boomer77polygon daily tx
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with firsts as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_hash) as tx_count, count(distinct from_address) as add_count
from polygon.core.fact_transactions
where date(block_timestamp) >= '2022-07-01' and nonce = 1 and status = 'SUCCESS'
group by 1),
total as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_hash) as total_tx, count(distinct from_address) as total_address
from polygon.core.fact_transactions
where date(block_timestamp) >= '2022-07-01' and status = 'SUCCESS'
group by 1)
select a.dt, a.add_count as new_acc, b.total_tx, b.total_address, (b.total_address-new_acc) as address_bal
from firsts a
left join total b on a.dt = b.dt
Run a query to Download Data