block_timestamp::date as date,

action,

count (distinct tx_id) as no_actions,

count (distinct liquidity_provider_address) as no_users,

sum (amount/pow(10,decimal)) as Total_Volume,

avg (amount/pow(10,decimal)) as Average_Volume,

median (amount/pow(10,decimal)) as Median_Volume,

avg(Average_Volume) OVER (partition by action ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,

sum (no_actions) over (partition by action order by date) as Cumulative_LP,

sum (Total_Volume) over (partition by action order by date) as Cumulative_Volume

from osmosis.core.fact_liquidity_provider_actions

where pool_id [0] = '773'

and action in ('pool_joined','pool_exited')

and currency='ibc/3FF92D26B407FD61AE95D975712A7C319CDE28DE4D80BDC9978D935932B991D7'

and tx_status = 'SUCCEEDED'

group by 1,2 having Total_Volume is not null

order by 1