select

block_timestamp::date as day,

pool_name,

count (distinct origin_from_address) as users_deposit,

sum(TOKEN0_AMOUNT_USD + TOKEN1_AMOUNT_USD ) as sum_deposit

from optimism.velodrome.ez_lp_actions

where lp_action = 'deposit'

and block_timestamp >= CURRENT_DATE - 7

and lp_token_amount_usd is not null

group by day, pool_name

)

select * from deposits

qualify row_number() over (partition by day order by sum_deposit desc) <= 5