In March 2024 Bitcoin BTC reached a new all-time high with prices exceeding 73000 USD marking a milestone for the cryptocurrency market This surge was due to the approval of Bitcoin exchange-traded funds ETFs in the United States allowing investors to access Bitcoin without directly holding it This development increased Bitcoin’s credibility and brought fresh demand from institutional investors echoing previous price surges in 2021 when Tesla announced its 15 billion investment in Bitcoin and Coinbase was listed on the Nasdaq By the end of 2022 Bitcoin prices dropped sharply to 15000 USD following the collapse of cryptocurrency exchange FTX and its bankruptcy which caused a loss of confidence in the market By August 2024 Bitcoin rebounded to approximately 64178 USD but remained volatile due to inflation and interest rate hikes Unlike fiat currency like the US dollar Bitcoin’s supply is finite with 21 million coins as its maximum supply By September 2024 over 92 percent of Bitcoin had been mined Bitcoin’s value is tied to its scarcity and its mining process is regulated through halving events which cut the reward for mining every four years making it harder and more energy-intensive to mine The next halving event in 2024 will reduce the reward to 3125 BTC from its current 625 BTC The final Bitcoin is expected to be mined around 2140 The energy required to mine Bitcoin has led to criticisms about its environmental impact with estimates in 2021 suggesting that one Bitcoin transaction used as much energy as Argentina Bitcoin’s future price is difficult to predict due to the influence of large holders known as whales who own about 92 percent of all Bitcoin These whales can cause dramatic market swings by making large trades and many retail investors still dominate the market While institutional interest has grown it remains a small fraction compared to retail Bitcoin is vulnerable to external factors like regulatory changes and economic crises leading some to believe it is in a speculative bubble However others argue that Bitcoin is still in its early stages of adoption and will grow further as more institutions and governments recognize its potential as a hedge against inflation and a store of value 2024 has also seen the rise of Bitcoin Layer 2 technologies like the Lightning Network which improve scalability by enabling faster and cheaper transactions These innovations are crucial for Bitcoin’s wider adoption especially for day-to-day use and cross-border remittances At the same time central bank digital currencies CBDCs are gaining traction as several governments including China and the European Union have accelerated the development of their own state-controlled digital currencies while Bitcoin remains decentralized offering financial sovereignty for those who prefer independence from government control The rise of CBDCs is expected to increase interest in Bitcoin as a hedge against these centralized currencies Bitcoin’s journey in 2024 highlights its growing institutional acceptance alongside its inherent market volatility While the approval of Bitcoin ETFs has significantly boosted interest the market remains sensitive to events like exchange collapses and regulatory decisions With the limited supply of Bitcoin and improvements in its transaction efficiency it is expected to remain a key player in the financial world for years to come Whether Bitcoin is currently in a speculative bubble or on a sustainable path to greater adoption will ultimately be revealed over time.

Bitcoin (BTC) price again reached an all-time high in 2024, as values exceeded over 73,000 USD in March 2024. That particular price hike was connected to the approval of Bitcoin ETFs in the United States, whilst previous hikes in 2021 were due to events involving Tesla and Coinbase, respectively. Tesla's announcement in March 2021 that it had acquired 1.5 billion U.S. dollars' worth of the digital coin, for example, as well as the IPO of the U.S.' biggest crypto exchange fueled mass interest. The market was noticably different by the end of 2022, however, with Bitcoin prices reaching roughly 87,471.70 as of March 25, 2025 after another crypto exchange, FTX, filed for bankruptcy.Is the world running out of Bitcoin?Unlike fiat currency like the U.S. dollar - as the Federal Reserve can simply decide to print more banknotes - Bitcoin's supply is finite: BTC has a maximum supply embedded in its design, of which roughly 89 percent had been reached in April 2021. It is believed that Bitcoin will run out by 2040, despite more powerful mining equipment. This is because mining becomes exponentially more difficult and power-hungry every four years, a part of Bitcoin's original design. Because of this, a Bitcoin mining transaction could equal the energy consumption of a small country in 2021.Bitcoin's price outlook: a potential bubble?Cryptocurrencies have few metrices available that allow for forecasting, if only because it is rumored that only few cryptocurrency holders own a large portion of available supply. These large holders - referred to as 'whales' - are said to make up of two percent of anonymous ownership accounts, whilst owning roughly 92 percent of BTC. On top of this, most people who use cryptocurrency-related services worldwide are retail clients rather than institutional investors. This means outlooks on whether Bitcoin prices will fall or grow are difficult to measure, as movements from one large whale already having a significant impact on this market.

By 2025, the Bitcoin market cap had grown to over 2,000 billion USD as the cryptocurrency kept growing. Market capitalization is calculated by multiplying the total number of Bitcoins in circulation by the Bitcoin price. The Bitcoin market capitalization increased from approximately one billion U.S. dollars in 2013 to several times this amount since its surge in popularity. Dominance The Bitcoin market cap takes up a significant portion of the overall cryptocurrency market cap. This is referred to as "dominance". Within the crypto world, this so-called "dominance" ratio is one of the oldest and most investigated metrics available. It measures the coin's market cap relative to the overall crypto market — effectively showing how strong Bitcoin compared to all the other cryptocurrencies that are not BTC, called "altcoins". The Bitcoin dominance was above 50 percent. Maximum supply and scarcity Bitcoin is unusual from other cryptocurrencies in that its maximum supply is getting closer. By 2025, well over 19 million out of all 21 million possible Bitcoin had been created. Bitcoin's supply is expected to reach its maximum around the year 2140, likely making mining more energy-intensive.

Context

Blockchain technology, first implemented by Satoshi Nakamoto in 2009 as a core component of Bitcoin, is a distributed, public ledger recording transactions. Its usage allows secure peer-to-peer communication by linking blocks containing hash pointers to a previous block, a timestamp, and transaction data. Bitcoin is a decentralized digital currency (cryptocurrency) which leverages the Blockchain to store transactions in a distributed manner in order to mitigate against flaws in the financial industry.

Nearly ten years after its inception, Bitcoin and other cryptocurrencies experienced an explosion in popular awareness. The value of Bitcoin, on the other hand, has experienced more volatility. Meanwhile, as use cases of Bitcoin and Blockchain grow, mature, and expand, hype and controversy have swirled.

Content

In this dataset, you will have access to information about blockchain blocks and transactions. All historical data are in the bigquery-public-data:crypto_bitcoin dataset. It’s updated it every 10 minutes. The data can be joined with historical prices in kernels. See available similar datasets here: https://www.kaggle.com/datasets?search=bitcoin.

Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.crypto_bitcoin.[TABLENAME]. Fork this kernel to get started.

Method & Acknowledgements

Allen Day (Twitter | Medium), Google Cloud Developer Advocate & Colin Bookman, Google Cloud Customer Engineer retrieve data from the Bitcoin network using a custom client available on GitHub that they built with the bitcoinj Java library. Historical data from the origin block to 2018-01-31 were loaded in bulk to two BigQuery tables, blocks_raw and transactions. These tables contain fresh data, as they are now appended when new blocks are broadcast to the Bitcoin network. For additional information visit the Google Cloud Big Data and Machine Learning Blog post "Bitcoin in BigQuery: Blockchain analytics on public data".

Photo by Andre Francois on Unsplash.

Inspiration

• How many bitcoins are sent each day?
• How many addresses receive bitcoin each day?
• Compare transaction volume to historical prices by joining with other available data sources

Graph and download economic data for Coinbase Bitcoin (CBBTCUSD) from 2014-12-01 to 2025-03-25 about cryptocurrency and USA.

Ethereum's price history suggests that that crypto was worth significantly less in 2022 than during late 2021, although nowhere near the lowest price recorded. Much like Bitcoin (BTC), the price of ETH went up in 2021 but for different reasons altogether: Ethereum, for instance, hit the news when a digital art piece was sold as the world's most expensive NFT for over 38,000 ETH - or 69.3 million U.S. dollars. Unlike Bitcoin - of which the price growth was fueled by the IPO of the U.S.' biggest crypto trader Coinbase - the rally on Ethereum came from technological developments that caused much excitement among traders. First, the so-called 'Berlin update' rolled out on the Ethereum network in April 2021, an update which would eventually lead to the Ethereum Merge in 2022 and reduced ETH gas prices - or reduced transaction fees. The collapse of FTX in late 2022, however, changed much for the cryptocurrency. As of March 25, 2025, Ethereum was worth 2,067.76 U.S. dollars - significantly less than the 4,400 U.S. dollars by the end of 2021.Ethereum's future and the DeFi industry Price developments on Ethereum are difficult to predict, but cannot be seen without the world of DeFi - or Decentralized Finance. This industry used technology to remove intermediaries between parties in a financial transaction. One example includes crypto wallets such as Coinbase Wallet that grew in popularity in recent years, with other examples including smart contractor Uniswap, Maker (responsible for stablecoin DAI), money lender Dharma and market protocol Compound. Ethereum's future developments are tied with this industry: Unlike Bitcoin and Ripple, Ethereum is technically not a currency but an open-source software platform for blockchain applications - with Ether being the cryptocurrency that is used inside the Ethereum network. Essentially, Ethereum facilitates DeFi - meaning that if DeFi does well, so does Ethereum.NFTs: the most well-known application of EthereumNFTs or non-fungible tokens grew nearly ten-fold between 2018 and 2020, as can be seen in the market cap of NFTs worldwide. These digital blockchain assets can essentially function as a unique code connected to a digital file, allowing to distinguish the original file from any potential copies. This application is especially prominent in crypto art, although there are other applications: gaming, sports and collectibles are other segments where NFT sales occur.

Prices for BTCUSD Bitcoin US Dollar including live quotes, historical charts and news. BTCUSD Bitcoin US Dollar was last updated by Trading Economics this March 26 of 2025.

Bitcoin's circulating supply has grown steadily since its inception in 2009, reaching over 19 million coins by early 2025. This gradual increase reflects the cryptocurrency's design, which put a limit of 21 million on the total number of bitcoins that can ever exist. This impacts the Bitcoin price somewhat, as its scarcity can lead to volatility on the market. Maximum supply and scarcity Bitcoin is unusual from other cryptocurrencies in that its maximum supply is getting closer. By 2025, more than 90 percent of all possible Bitcoin had been created. That said, Bitcoin's circulating supply is expected to reach its maximum around the year 2140. Meanwhile, mining becomes exponentially more difficult and energy-intensive. Institutional investors In 2025, countries like the United States openly started discussion the possibility of buying bitcoins to hold in reserve. By the time of writing, it was unclear whether this would happen. Nevertheless, institutional investors displayed more interest in the cryptocurrency than before. Certain companies owned several thousands of Bitcoin tokens in 2025, for example. This and the limited number of Bitcoin may further fuel price volatility.

Bitcoin dominance steadily declined in April 2024 to below 50 percent, amid rumors of central banks halting or potentially lowering interest rates in the future. Within the crypto world, this so-called "dominance" ratio is one of the oldest and most investigated metrics available. It measures the coin's market cap relative to the overall crypto market — effectively showing how strong Bitcoin compared to all the other cryptocurrencies that are not BTC, called "altcoins". Why dominance matters is because market caps of any crypto can change relatively quickly, either due to sudden price changes or a change of recorded trading volume. Essentially, the figure somewhat resembles a trading sentiment, revealing whether Bitcoin investors are responding to certain events or whether Bitcoin is losing out on functions offered by, for example, stablecoins or NFT tokens. "Dominance" criticism: Ethereum and stablecoin The interpretation of the Bitcoin metric is not without its criticism. When first conceived, Bitcoin was the first cryptocurrency to be created and had a substantial market share within all cryptocurrencies? The overall share of stablecoins, such as Tether, as well as Ethereum increasingly start to resemble that of Bitcoin, however. Some analysts argue against this comparison. For one, they point towards the large influence of trading activity between Bitcoin and Ethereum in the dominance metric. Second, they argue that stablecoins can be traded in for Bitcoin and Ethereum, essentially showing how much investors are willing to engage with "regular" cryptocurrency. A rally around Bitcoin in late 2023? By December 2023, the Bitcoin price reached roughly 41,000 U.S. dollars — the first time in 20 months such a value was reached. A weaker U.S. dollar, speculation on decreasing interest rates, and a potential Bitcoin ETF approval are believed to be at the heart of this price increase. Whether this will hold in 2024 is unclear: The monthly interest rate from the U.S. Fed is speculated to decrease in 2024, despite a vow of "higher for longer". In December 2023, the thought of decreasing interest rates and the potential of a Bitcoin ETF fuelled market sentiment towards riskier assets.

The average price of one Bitcoin Cash reached its all-time high in 2017, although the price since then never came close to that position. As of March 25, 2025, one Bitcoin Cash token was worth 335.67 U.S. dollars, as opposed to the nearly 2,500 USD from the peak in 2017. Bitcoin Cash - abbreviated as BCH - is a variant of the much more known Bitcoin - or BTC -, and is traded separately on online exchanges. That the two cryptocurrencies are different from each other already shows when looking at the price of a 'regular' Bitcoin: this was over 40,000 U.S. dollars during the same time frame.

Ripple - or XRP - prices surged in 2021, but went down significantly as 2022 progressed. As of March 26, 2025, one XRP token was worth 2.35 U.S. dollars. Ethereum's price, for example, kept on reaching new all-time highs, a feat not performed by XRP. Indeed, XRP's more price spikes followed relatively late - only occurring in early 2021, against late 2020 for most other cryptos - after the US SEC filed a legal complaint against Ripple in November 2020. This legal action caused the XRP price to plummet from around 0.70 U.S. dollars to 0.20 U.S. dollars.Ripple versus XRP: two become oneTechnically speaking, Ripple is not a cryptocurrency. Renamed from a protocol called OpenCoin in 2013, Ripple facilitates open-source payments. XRP, on the other hand, is the cryptocurrency that runs on this network. In that sense, Ripple and XRP have a similar symbiosis to each other like the Ethereum network and its cryptocurrency Ether. Unlike Ethereum - whose price changes are connected to the world of Decentralized Finance or DeFI - Ripple/XRP mostly looks at developments on cross-border payments for companies. In 2020, companies worldwide began to favor fintech solutions for future B2B solutions and, in a way, Ripple is an extension of that.What affects the price of Ripple?Ripple is mostly active in Southeast Asia - a region with a splintered payment landscape and that heavily investigates its own types of state-issued cryptocurrency to make cross-border payments a lot easier. Price spikes tend to follow after news on this topic in this specific region. In 2019, for example, the XRP price grew after Japan and South Korea began testing to reduce time and costs for transferring international funds between the two countries. In March 2021, Ripple announced that it had agreed to acquire 40 percent of Malaysian cross-border payments firm Tranglo to meet growing demand in Southeast Asia.

Following NFT hype and growing demand in the DeFi community, the price of cryptocurrency Solana or SOL more than tripled during the summer of 2021. This had all but evaporated by the end of 2022, as a price of 143.82 U.S. dollars for SOL on March 25, 2025 was similar to the price of Solana in early 2021. The collapse of crypto trader FTX in 2022 especially impacted the cryptocurrency, as FTX and its sister firm Alameda Research sold a large amount of the coin in order to avoid bankruptcy. The Solana protocol is similar to Ethereum in that can allow for nun-fungible tokens to be created ('minted') or traded. Solana, however, uses a technology called 'PoH' or Proof of History, which allows it to reach high transaction speeds. The Solana Foundation - the creators of the protocol, based in Switzerland - claims they could reach up to 65,000 transactions per second compared to 16 for Ethereum. Additionally, Solano had no transaction fees or 'gas', unlike Ethereum, which had growing transaction costs. These two reasons combined - Solana being deemed cheaper and faster than Ethereum - turned this relatively young protocol into a breeding ground for NFT projects in August 2021.

Memecoin Shiba Inu saw its price grow by more than 300 percent within one and the same month, marking a trading fury reminiscent of Dogecoin in early 2021. Indeed, the SHIB coin ranked as one of the biggest crypto in the world based on 24h trading volume in October 2021 - with trading activity being almost as high as that of Ethereum. Originally starting out as a fun token based on the famous Japanese dog breed, the digital currency grabbed mainstream attention in 2021 probably due to its low barrier of entry: Even after its price spikes, Shiba Inu was one of the cheapest coins availalbe, especially when compared to the price of 99 other cryptocurrencies. Combine this with survey information that most consumers in the U.S. and the UK invest in crypto either for growth or fun, and Shiba Inu is probably seen by many as a relatively simple, "quick win" investment.

After several fluctuations in earlier years, the price of Tether or USDT since 2020 achieved the stability against the U.S. dollar that it was designed to reach. In 2021, Tether ranks as one of the biggest cryptocurrencies in the world and is regarded as the most well-known "stablecoin", or cryptocurrency that is connected to the price development of another, real-world asset. As Tether's USDT code suggest, the token is, in this case, connected to the U.S. dollar. This effectively means that a single Tether will nearly always be worth one single U.S. dollar. This relative stability, unlike the price development of, say, Ripple (XRP), is what defines a stablecoin and is especially important for decentralized lending and borrowing. This particular segment made up roughly half of the overall value locked in Decentralized Finance or DeFi.

Dogecoin (DOGE) price per day from July 1, 2022 to March 26, 2025 (in U.S. cents)

The price of Ethereum Classic (ETC) - a different crypto than Ethereum (ETH) - decreased significantly following the Ethereum Merge of September 2022. After years of development, the "original" Ethereum changed from proof-of-work (mining) to proof-of-stake (staking) during this event. This change had the potential to impact both the transaction speed as well as the energy consumption of the Ethereum blockchain. Some miners, however, started looking into Proof-of-Work alternatives were they could continue using their mining rigs - including Ethereum Classic (ETC), but also EthereumPOW (ETHW), and Ravencoin (RVN). The influx caused such a spike in hashrate - the computing power required to successfully mine a crypto - that the price declined.

The Litecoin cryptocurrency peaked in both 2017 and 2020 - reaching prices worth around 250 dollars - but did not reach this by 2022. As of March 21, 2025, one Litcoin token was worth 90.93 U.S. dollars. Litecoin's price was relatively volatile in recent years, revealing high price swings between months.What is a cryptocurrency?Cryptocurrencies are digital currencies that do not have a centralized regulating authority. The first of these, Bitcoin, introduced a technology called blockchain, in which a distributed ledger records every transaction on every bitcoin in circulation to prevent fraud. Litecoin also uses this technology. To accommodate the demands of constant ledger updates, users sell computational power in exchange for an amount of Litecoin, a process known as mining.More about LitecoinCryptocurrencies are still emerging technology, and few are using them for transactions. As such, most users are speculators who look at the value of all coins in circulation as the market capitalization rather than money supply. Still, the average number of Litecoin transactions ranges in the tens of thousands, meaning that the cryptocurrency has a substantial financial footprint.

The price of the native coin from BNB Chain (formerly BSC) grew by 50 percent in late 2021 but was much lower in 2022. In March 25, 2025, for example, a single BNB coin was worth more than 629.94 U.S. dollars - a value that very different to the all-time high of 600 U.S. dollars in November 2021. Regardless, Binance Coin ranked in the top 10 most expensive cryptocurrencies in 2022. Noticeable is that the price increase of BNB in November 2021 coincides with a similar price change for Ethereum (ETH) - a cryptocurrency where BNB initially originated in 2017 before coming on its own years later.BNB's history: From reward token in 2017 to an ecosystem after 2019As the name suggests, Binance Coin or BNB originally started as an extension of the Binance.com trading platform - the most used cryptocurrency exchange in the world. It initially functioned on the Ethereum blockchain network as an ERC-20 token, offering incentives to owners like reduced trading fees, affiliate rewards, or a lottery ticket system ('Launchpad') that let users invest in new, Binance-selected crypto projects. In 2019, however, BNB moved away from the Ethereum network and migrated to Binance's self-developed blockchain: Binance Smart Chain or BSC (called BNB Chain since February 2022). Here, BNB started to support a chain that initially did not focus on hosting decentralized apps but focused on high transaction speed and being able to handle large amounts of traffic.DeFi and GameFi: the main segments for BNBBSC, however, made significant strides in 2021 partly due to traffic overload and high gas prices on Ethereum as well as the growing interest in both Decentralized Finance (DeFI) and NFTs. Much like Cardano, Solana, and Terra, Binance Smart Chain consequently became a valid alternative to Ethereum: The total value locked (TVL) of BNBs blockchain within DeFi, for example, ranked only behind that of Terra and Ethereum in early 2022. Another area where Binance's blockchain and token play a significant role is that of GameFi - or 'play-to-earn' blockchain games that are powered by cryptocurrencies. Some of the more well-known and most popular NFT games like Alien Worlds and Axie Infinity run on the blockchain behind BNB.

Swiss cryptocurrency Cardano (ADA) witnessed a price surge of nearly 100 percent in seven days in early February 2021, amid high interest from investors. One reason for this interest is the digital coin's close relation to Ethereum (ETH), as mathematician Charles Hoskinson co-founded both virtual currencies. Also, like Ethereum, ADA has an open-source format, meaning anybody can develop this currency further. As of March 25, 2025, one ADA token was worth 0.75 U.S. dollars.

For a brief time in November 2021, the price of a Algorand cryptocurrency was worth more than two U.S. dollars - twice the value it recorded in August 2021. The relatively young token - originally coined in 2017, it did not record a market cap until 2019 - gained in relevance in 2021 as exchanges like Coinbase listed the ALGO coin more often. This ease of access made Algorand an interesting prospect for investors who were looking for coins that cover smart contracts and interoperability: Unlike Bitcoin, which is meant to store value and essentially act as a digital substitute for gold, coins like Algorand are meant to power technical innovation in the blockchain and propel Decentralized Finance (DeFi). In the case of ALGO, it allows for the launch of projects across several of the most popular DeFi blockchains at the same time. As of March 21, 2025, one ALGO token was worth 0.19 U.S. dollars.