The visualization between Bitcoin price and COVID-19 pandemic in the United States

Coronavirus (COVID-19) outbreak has rapidly spread all over the world and infecting millions of people and causing thousands of deaths. World Health Organization declared this outbreak a global pandemic. The governments are implementing several restrictions such as travel bans, school closures, and curfews, and the lives of billions are affected.

To show the visualization:

1. First the bitcoin data was downloaded from:

https://finance.yahoo.com/quote/BTC-USD/history/

The time period we chose was 2020-01-01 to 2022-07-10.

2. Then the COVID-19 data was downloaded from WHO website:

https://covid19.who.int/data

Then the United states country was filtered from the Covid-19 table and the "New_cases" column from Covid-19 table was copied to a new excel. We copied and pasted the "Open" column from bitcoin table, from January 3rd 2020 to the new excel.

Now the new table looks like this:

To normalize the data:

Two new columns have been created, one for the new cases and one for the bitcoin prices. Then the following formulas were used:

=Cell/MAX(New_cases column)

=Cell/MAX(Open column)

Then we go to https://app.flourish.studio/projects

Upload the new excel (Covid-19 and bitcoin).

Check out the following visualization:

The visualization indicates that there is a negative relationship between Bitcoin value and number of reported cases and deaths; however, the relationship becomes positive during the later period.

Further studies can examine the co-movement of Bitcoin price with the pandemic and compare the findings.