origin_from_address,

min(block_timestamp) as first_tx

from optimism.velodrome.ez_lp_actions

group by 1)

select date_trunc('day', first_tx) as first_tx_date,

case when first_tx_date >= '2022-08-05' then 'After Velodrome Exploit' else 'Before Velodrome Exploit' end as periods,

count(distinct(origin_from_address)) as count_new_lper,

sum(count_new_lper) over (order by first_tx_date) as cumulative_count_new_lper

from base

group by 1