primo_datapolygon_daily_transactions
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
--Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
--In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
-- Daily Transactions
select date(block_timestamp) dt, status, count(distinct tx_hash) ct, sum(tx_fee) total_matic_fees
from polygon.core.fact_transactions
where date(block_timestamp) >= date('2022-07-01')
and date(block_timestamp) <= date('2022-07-12')
group by 1,2
order by 1,2 asc
Run a query to Download Data