HosseinUntitled Query
    Updated 2023-01-10
    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