date(BLOCK_TIMESTAMP) as days,

POOL_NAME,

count(distinct tx_hash) as count_txs,

count(distinct ORIGIN_FROM_ADDRESS) as count_users,

sum( TOKEN0_AMOUNT_USD ) as valuee,

sum(count_txs)over(partition by POOL_NAME order by days rows between unbounded preceding and current row ) as cumulative_count_txs,

sum(count_users)over(partition by POOL_NAME order by days rows between unbounded preceding and current row ) as cumulative_count_users,

sum(valuee)over(partition by POOL_NAME order by days rows between unbounded preceding and current row ) as cumulative_valuee

from optimism.velodrome.ez_lp_actions

where

LP_TOKEN_ACTION = 'burn'

and

BLOCK_TIMESTAMP between CURRENT_DATE - {{days_back}} and CURRENT_DATE-1

group by 1,2