block_timestamp::date as day,

count(distinct(tx_id)) as txn_count,

count(distinct(address)) as stakers_count,

(txn_count / stakers_count) as avg_txn_per_staker,

sum(amount/ pow(10, 9)) as total_amount,

avg((amount/ pow(10, 9))) as avg_amount,

median((amount/ pow(10, 9))) as median_amount,

sum (txn_count) over (order by day asc) as comulative_txn_count,

sum (stakers_count) over (order by day asc) as comulative_stakers_count,

sum (total_amount) over (order by day asc) as comulative_total_amount

from solana.core.fact_stake_pool_actions

where succeeded = 1

and action ilike '%deposit%'

and block_timestamp::date >= '2022-11-01'

group by day

order by day asc