Livedocs
Ethereum Price Analysis
This notebook explores Ethereum's price history from November 2017 to March 2022. It examines daily price data, identifies trends and volatility, and analyzes yearly average prices. The notebook reveals a 57x increase in price over the period, highlighting the crypto winter, significant bull runs, and periods of stabilization.
ETH-USD.csv
DateOpenHighLowCloseAdj CloseVolume
2017-11-09
308.644989
329.451996
307.056
320.884003
320.884003
893249984
2017-11-10
320.67099
324.717987
294.541992
299.252991
299.252991
885985984
2017-11-11
298.585999
319.453003
298.191986
314.681
314.681
842300992
2017-11-12
314.690002
319.153015
298.513
307.90799
307.90799
1613479936
2017-11-13
307.024994
328.415009
307.024994
316.716003
316.716003
1041889984
2017-11-14
316.763
340.177002
316.763
337.631012
337.631012
1069680000
2017-11-15
337.963989
340.911987
329.812988
333.356995
333.356995
722665984
2017-11-16
333.442993
336.158997
323.605988
330.924011
330.924011
797254016
2017-11-17
330.166992
334.963989
327.52301
332.394012
332.394012
621732992
2017-11-18
331.980011
349.615997
327.687012
347.612
347.612
649638976
10 Rows
ETH-USD.csv
total_recordsearliest_datelatest_datelowest_pricehighest_priceaverage_price
1598
2017-11-09
2022-03-25
84.308296
4812.087402
1027.554834328536
1 Rows

πŸš€ Ethereum Price Journey: From $84 to $4,800+

Welcome to this interactive data exploration! Today we're going to take a fascinating journey through Ethereum's price history from November 2017 to March 2022.

What is Ethereum?

Ethereum is like digital money, but it's also a platform that allows people to build applications on top of it. Think of it as both a currency and a foundation for other digital services.

What We're Looking At

Our dataset contains 1,598 days of price data, showing us:

  • Daily opening and closing prices
  • Highest and lowest prices each day
  • Trading volume (how much was bought and sold)

The most incredible part? Ethereum's price went from a low of $84 to a peak of $4,812 - that's a journey of nearly 57x growth! πŸ“ˆ

Let's explore this amazing story together...

ETH-USD.csv
DatePriceVolumeYearMonth
2017-11-09
320.884003
893249984
2017
2017-11
2017-11-10
299.252991
885985984
2017
2017-11
2017-11-11
314.681
842300992
2017
2017-11
2017-11-12
307.90799
1613479936
2017
2017-11
2017-11-13
316.716003
1041889984
2017
2017-11
2017-11-14
337.631012
1069680000
2017
2017-11
2017-11-15
333.356995
722665984
2017
2017-11
2017-11-16
330.924011
797254016
2017
2017-11
2017-11-17
332.394012
621732992
2017
2017-11
2017-11-18
347.612
649638976
2017
2017-11
1598 Rows
dataframe_2

πŸ“Š What This Chart Tells Us

Look at that incredible journey! This line chart shows Ethereum's daily closing price from November 2017 to March 2022. Here are the key moments:

🎒 The Rollercoaster Ride

  • 2017-2018: Started around $300, shot up to over $1,000, then crashed back down
  • 2018-2020: The "crypto winter" - prices stayed relatively low, mostly under $500
  • 2020-2021: The amazing bull run - prices exploded from under $200 to nearly $5,000!
  • 2022: Some volatility but still at historically high levels

πŸ’‘ Key Insights

  • Ethereum is highly volatile - meaning prices can change dramatically
  • Despite the ups and downs, the long-term trend is upward
  • The biggest growth happened during 2020-2021

Let's look at this data in different ways to understand the story better...

ETH-USD.csv
Yearavg_pricemin_pricemax_pricetrading_days
2017
532.09
299.25
826.82
53
2018
483.51
84.31
1396.42
365
2019
181.77
104.54
336.75
365
2020
307.54
110.61
751.62
366
2021
2778.35
730.37
4812.09
365
2022
2908.88
2405.18
3829.56
84
6 Rows
dataframe_3

πŸ“‹ Year-by-Year Analysis

This bar chart shows us the average price for each year, and the story is remarkable:

πŸ’° The Numbers

  • 2017: $532 average (only had 2 months of data)
  • 2018: $484 average (the crash year)
  • 2019: $182 average (the bottom of the market)
  • 2020: $308 average (recovery begins)
  • 2021: $2,778 average (πŸš€ TO THE MOON!)
  • 2022: $2,909 average (staying high)

πŸ—‘οΈ What Happened?

  • 2018-2019: The "crypto winter" - prices fell dramatically after the initial hype
  • 2020: COVID-19 actually helped crypto as people looked for new investments
  • 2021: The breakthrough year - Ethereum became mainstream
  • 2022: Prices remained elevated, showing the market had matured

Amazing fact: If someone bought Ethereum in 2019 (average $182) and held until 2021 (average $2,778), they would have made over 15 times their money!

dataframe_2

πŸ“ What This Histogram Shows Us

This histogram is like a "frequency chart" - it shows us how many days Ethereum spent at different price levels. Here's what we can learn:

πŸ” Key Observations

  • Most common prices: The majority of days, Ethereum was priced under $1,000
  • The big spike: You can see a large number of days clustered in the lower price ranges (under $500)
  • High-price days: Very few days were spent above $3,000, making those periods quite rare
  • Distribution shape: This is what we call a "right-skewed" distribution - most values are on the left (low prices) with a long tail extending right (high prices)

πŸ€” What This Means

  • Ethereum spent most of its time at "reasonable" prices - under $1,000
  • The super-high prices above $4,000 were very rare events - only a few days!
  • This pattern is common in financial markets - big moves up or down don't last very long

This type of analysis helps investors understand that while the headlines focus on the dramatic highs, most of the time Ethereum traded at much more modest levels.

πŸŽ† Summary: Ethereum's Incredible Journey

πŸ“Š What Our Data Analysis Revealed

We just explored 1,598 days of Ethereum price data and discovered some fascinating insights:

πŸ’― The Big Picture

  • Price Range: From $84 to $4,812 (a 57x increase!)
  • Time Period: November 2017 to March 2022 (about 4.5 years)
  • Pattern: Extreme volatility with an overall upward trend

πŸ•‘ Timeline of Events

  1. 2017-2018: The first bubble and crash
  2. 2018-2020: The "crypto winter" recovery period
  3. 2020-2021: The mainstream breakthrough
  4. 2022: Price stabilization at high levels

🧠 Key Lessons About Data Analysis

This demonstration shows how Livedocs makes data exploration simple and interactive:

  • Easy Data Import: We loaded a CSV file with no coding required
  • SQL Made Simple: We queried the data using everyday language
  • Beautiful Visualizations: Created charts that tell a clear story
  • Collaborative: Multiple people can work on this together in real-time

πŸš€ Why This Matters

Whether you're analyzing cryptocurrency prices, sales data, or any other dataset, the same principles apply:

  • Start with exploration (what's in the data?)
  • Look for patterns (trends over time)
  • Break it down (yearly averages, distributions)
  • Tell the story (what does it all mean?)

Livedocs makes this entire process accessible to everyone - no complex programming required, just curiosity and the right questions to ask!


Ready to explore your own data? Upload a file and start discovering insights today! πŸš€