date(block_timestamp) as day,

round(sum(lp_token_amount_usd),2) as total_liq_amount_usd,

round(avg(lp_token_amount_usd),2) as avg_liq_amount_usd,

count(distinct(tx_hash)) as no_of_lp_txns,

count(distinct(origin_from_address)) as no_of_liq_providers

from optimism.velodrome.ez_lp_actions

where lp_token_action = 'mint'

group by day

order by day desc