with base as (

select distinct

tx_id as tx,

signers[0] as user

from solana.core.fact_events

where block_timestamp > '2024-02-20'

and program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'

, base2 as (

select

-- date(block_timestamp) as date,

user,

sum(case when tx_from = user then amount else 0 end) as stake_volume,

sum(case when tx_to = user then amount else 0 end) as withdraw_volume,

stake_volume - withdraw_volume as net_stake_jup,

case when net_stake_jup <= 0.01 then 'Stake < 0.01 JUP'

when net_stake_jup <= 0.01 then 'Stake < 0.01 JUP'

when net_stake_jup <= 0.1 then 'Stake < 0.1 JUP'

when net_stake_jup <= 1 then 'Stake < 1 JUP'

when net_stake_jup <= 10 then 'Stake < 10 JUP'

when net_stake_jup <= 20 then 'Stake < 20 JUP'

when net_stake_jup <= 50 then 'Stake < 50 JUP'

when net_stake_jup <= 100 then 'Stake < 100 JUP'

when net_stake_jup <= 105 then 'Stake < 105 JUP'

when net_stake_jup <= 110 then 'Stake < 110 JUP'

when net_stake_jup <= 120 then 'Stake < 120 JUP'

when net_stake_jup <= 1000 then 'Stake < 1000 JUP'

when net_stake_jup <= 10000 then 'Stake < 10000 JUP'

when net_stake_jup <= 100000 then 'Stake < 100000 JUP'