block_timestamp :: date as date,

lp_action,

count (distinct tx_hash) as TX_Count,

count (distinct origin_from_address) as Users_Count,

sum (token0_amount_usd) as Volume,

sum (Users_Count) over (

partition by lp_action

order by

date

) as cum_users,

sum (TX_Count) over (

partition by lp_action

order by

date

) as cum_tx,

sum (

sum (token0_amount_usd)

) over (

partition by lp_action

order by

date

) as Cumulative_volume_lp

from

optimism.velodrome.ez_lp_actions

group by

1,

2

order by

1