select pool_address from ethereum.core.dim_dex_liquidity_pools

where platform = 'sushiswap'

select

block_timestamp::date as date,

case

when date < '2022-09-15' then 'Before'

else 'After'

end as period,

count(distinct tx_hash) as daily_txs,

count(distinct origin_from_address) as daily_addresses,

sum(amount_usd) as added_volume_usd,

sum(added_volume_usd) over (order by date) as cum_added_volume_usd

from ethereum.core.ez_token_transfers t

join pools on t.to_address = pool_address

where origin_function_signature in ('0xf305d719','0xe8e33700')

and date between '2022-09-01' and '2022-09-30'

group by 1,2

order by 1 asc