pimi1356-HdnUm3daily hubble metrics
Updated 2022-10-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('{{date_range}}',block_timestamp) as DATE,
count (distinct tx_id) as TX_Count,
count (distinct BLOCK_ID) as totalblocks,
count (distinct signers[0]) as Users_Count,
sum (FEE/1e9) as Totalfees,
sum(TX_Count) over (order by date) as cumulative_count_tx,
sum(totalblocks) over (order by date) as cumulative_ccccblock,
sum(Users_Count) over (order by date) as ccccumulative_ccccuser,
sum(Totalfees) over (order by date) as cumulative_fee
from solana.core.fact_transactions
where instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
and succeeded = 'TRUE'
GROUP BY DATE
Run a query to Download Data