date_trunc(d, block_timestamp) as date,

case

when platform = 'uniswap-v3' then 'uniswap'

when platform = 'camelot-v2' then 'camelot'

when platform = 'fraxswap' then 'fraxswap'

when platform = 'kyberswap-v2' then 'kyberswap'

when platform = 'camelot-v3' then 'camelot'

when platform = 'gmx' then 'gmx'

when platform = 'hashflow' then 'hashflow'

when platform = 'dodo-v1' then 'dodo'

when platform = 'trader-joe-v1' then 'traderjoe'

when platform = 'curve' then 'curve'

when platform = 'kyberswap-v1' then 'kyberswap'

when platform = 'uniswap-v2' then 'uniswap'

when platform = 'hashflow-v3' then 'hashflow'

when platform = 'woofi' then 'woofi'

when platform = 'balancer' then 'balancer'

when platform = 'dodo-v2' then 'dodo'

when platform = 'sushiswap' then 'sushiswap'

else 'others'

end as platform,

count(DISTINCT tx_hash) as total_transactions,

count(DISTINCT origin_from_address) as uniqu_users,

sum(amount_in_usd) as volume,

arbitrum.defi.ez_dex_swaps

block_timestamp >= '2024-06-10'

group by

1,

2

order by

1 asc;