date_trunc('week', block_timestamp) as date,

case when LP_TOKEN_AMOUNT_USD < 10 then 'Less Than $10'

when LP_TOKEN_AMOUNT_USD >= 10 and LP_TOKEN_AMOUNT_USD < 100 then '$10 - $100'

when LP_TOKEN_AMOUNT_USD >= 100 and LP_TOKEN_AMOUNT_USD < 1000 then '$100 - $1000'

when LP_TOKEN_AMOUNT_USD >= 1000 and LP_TOKEN_AMOUNT_USD < 10000 then '$1000 - $10000'

else 'More Than $10000' end as dist,

count(distinct tx_hash) as tx_count,

count(distinct ORIGIN_FROM_ADDRESS) as wallets,

sum(LP_TOKEN_AMOUNT_USD) as vol,

avg(LP_TOKEN_AMOUNT_USD) as avg_vol,

sum(tx_count) over(partition by dist order by date) as cumu_tx_count,

sum(vol) over(partition by dist order by date) as cumu_vol

from optimism.velodrome.ez_lp_actions

where date >= '2022-01-01'

and LP_ACTION = 'withdraw'

group by date, dist