pool_name,

POOL_ADDRESS

ethereum.core.dim_dex_liquidity_pools

where PLATFORM ilike 'sushiswap'

)

select

block_timestamp::date as date,

'Deposit' as type,

symbol,

pool_name,

count(distinct tx_hash) as tran,

count(distinct from_address) as users,

sum(amount_usd) as amount_usd

from

ethereum.core.ez_token_transfers b

join main s on to_address = POOL_ADDRESS

where block_timestamp >= '2022-09-15'

and amount_usd is not null

group by 1,2,3,4