date_trunc('{{interval}}',block_timestamp) as days,

count(distinct tx_id) as LP_Count,

count(distinct liquidity_provider_address) as LPers_Count,

sum(amount) as Total_Volume,

avg(amount) as Average_Volume,

median(amount) as Median_Volume,

min(amount) as Minimum_Volume,

max(amount) as Maximum_Volume,

sum(lp_count) over (partition by action order by days) as Cumulative_TX_Count,

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

FROM osmosis.core.fact_liquidity_provider_actions t1

WHERE pool_id [0] = '773'

AND action IN ('pool_joined','pool_exited')

AND tx_status = 'SUCCEEDED'

AND days <=CURRENT_DATE-1

GROUP BY action,days

ORDER BY days