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

Evgeny Medvedev
Feb 5 · 2 min read
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

Evgeny Medvedev

Written by

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

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade