-- forked from Aurora - Daily Transaction Count Cumu. @ https://flipsidecrypto.xyz/edit/queries/80d12465-d7c1-4951-8e89-755c581021dd
-- forked from Aurora - Daily Transaction Count @ https://flipsidecrypto.xyz/edit/queries/12efdd2f-63eb-48df-91e1-205d4e59a07a
select count(distinct tx_hash) as txn_count
from aurora.core.fact_transactions
/*
aurora.core.fact_blocks - 96m
aurora.core.fact_transactions - 55m
aurora.core.fact_receipts - 10m
aurora.core.fact_logs - 24m
*/