Hadisehnetwork 1
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with t1 as ( select trunc(block_timestamp,'day') as date, count(DISTINCT tx_id) as transaction
from solana.core.fact_transactions
where block_timestamp::date >= '2022-06-01' and SUCCEEDED = 'TRUE'
group by 1
)
select 'June' as month , date , transaction
from t1
where date < '2022-07-01'
UNION
select 'July' as month , date , transaction
from t1
where date >= '2022-07-01'
Run a query to Download Data