HosseinUntitled Query
Updated 2022-07-26
9
1
2
3
4
5
6
7
›
⌄
select avg(tx_num) as average_tx_num from (
select a.block_id, count(distinct(tx_id)) as tx_num from solana.core.fact_transactions a
join solana.core.fact_blocks b on a.block_id = b.block_id
where succeeded = 1
and a.block_timestamp::date >= current_date - 10
group by a.block_id
)
Run a query to Download Data