HosseinUntitled Query
Updated 2023-01-07
9
1
2
3
4
5
6
7
8
›
⌄
select block_timestamp::date as day,
iff(pre_token_balances[0]:mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', 'BONK', 'Non-BONK') as type,
count (distinct (tx_id)) as txn_count,
sum (txn_count) over (partition by type order by day asc) as cumulative_txn_count
from solana.core.fact_transactions
where day >= '2022-12-24'
group by day, type
order by day
Run a query to Download Data