date_trunc('day',block_timestamp) as daily,

pool_name,

LP_ACTION,

count(DISTINCT tx_hash) as TXNs,

count(DISTINCT origin_from_address) as Unique_Users,

WHEN lp_action LIKE 'deposit' THEN LP_TOKEN_AMOUNT_USD

WHEN lp_action LIKE 'withdraw' THEN -1 * LP_TOKEN_AMOUNT_USD END )

as volume,

sum (TXNs) over (partition by pool_name order by daily ) as cum_TXNs,

sum (Unique_Users) over (partition by pool_name order by daily ) as cum_Users,

sum (volume) over (partition by pool_name order by daily ) as cum_volume

FROM optimism.velodrome.ez_lp_actions

where daily < CURRENT_DATE

GROUP BY daily,pool_name,LP_ACTION