Comparing Transaction Throughputs for 8 blockchains in Google BigQuery with Google Data Studio

Daily transaction counts. Scroll to bottom for interactive version of the graphs.
with daily_transactions as (
select date(block_timestamp) as date, count(*) as count
from `bigquery-public-data.crypto_bitcoin.transactions`
group by date
)
select date_trunc(date, WEEK) as week, cast(avg(count) as INT64) as count
from daily_transactions
group by week
order by week
Daily transaction counts (Interactive).

Transaction Throughputs

--

--

--

Creator of https://github.com/blockchain-etl, Co-founder of https://d5.ai and https://nansen.ai, Google Cloud GDE, AWS Certified Solutions Architect

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Evgeny Medvedev

Evgeny Medvedev

Creator of https://github.com/blockchain-etl, Co-founder of https://d5.ai and https://nansen.ai, Google Cloud GDE, AWS Certified Solutions Architect

More from Medium

Natural Language Processing (NLP)

Using AI to help the visually impaired in traffic

Introducing Data NFTs

Filecoin Network Analytics: Data-Driven Governance in Web3