e.block_timestamp, e.tx_hash , e.event_inputs:value/1e18 as Total_Volume

from arbitrum.core.fact_event_logs e

join arbitrum.core.fact_token_transfers t on e.tx_hash = t.tx_hash

where e.origin_to_address = '0x2f67a8d26f370b922b31b199c7946c3ed53c10c6'

and e.event_name = 'Transfer' and e.event_inputs:from = e.Origin_From_Address and e.tx_status= 'SUCCESS'

and e.contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'

select block_timestamp::date as day,

case when Total_Volume < 50 then 'Volume < $50' when Total_Volume >= 50 and Total_Volume < 200 then '$50 <= Volume < $200'

when Total_Volume >= 200 and Total_Volume < 1000 then '$200 <= Volume < $1000' when Total_Volume >= 1000 and Total_Volume < 5000 then '$1000 <= Volume < $5000'

when Total_Volume >= 5000 and Total_Volume < 10000 then '$5000 <= Volume < $10000' else 'More Than $10000' end as type,

count(distinct tx_hash) as "Number Trade"

from aaa

group by 1,2