from optimism.velodrome.ez_lp_actions

where lp_token_action like 'burn'

group by pool_name

order by transactions desc

limit 10)

select date_trunc('day',block_timestamp)as date,a.pool_name,count(tx_hash) as transactions

from optimism.velodrome.ez_lp_actions a

join pools p on p.pool_name = a.pool_name

where lp_token_action like 'burn'

group by date,a.pool_name

order by date asc