HosseinUntitled Query
Updated 2023-01-10
9
1
2
3
4
5
6
7
8
9
›
⌄
select
iff(year(block_timestamp) = 2022, 'Before Christmas', 'After Christmas') as timespan,
count(distinct tx_id) as stakes_count,
count(distinct address) as stakers_count
from solana.core.fact_stake_pool_actions
where succeeded = 1
and block_timestamp between date('2023-01-01') - interval '1 weeks' and date('2023-01-01') + interval '1 weeks'
and action in ('withdraw','withdraw_stake')
group by timespan
Run a query to Download Data