-- forked from h4wk / Jup stakers @ https://flipsidecrypto.xyz/h4wk/q/echH8y4sgDb-/jup-stakers -- forked from Jup stake @ https://flipsidecrypto.xyz/edit/queries/cd838d21-7ce4-41a1-a355-7ed37a2d5403 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' end as type -- sum(net_stake_jup) over (order by date) as "Net Stake JUP" from solana.core.fact_transfers join base on (tx_id = tx) where mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN' and block_timestamp > '2024-02-20' group by 1 ) select type, count(distinct user) as users, sum(net_stake_jup) as stake_volume from base2 group by 1 order by TYPE desc

Query	Creator	Created
Getting Started ethereum nft evm	asimsy-V4fpFx	Jun 23, 2024
Jup stakers copy solana	asimsy-V4fpFx	Jun 23, 2024

asimsy-V4fpFx