select

block_timestamp,

amount,

amount_usd,

contract_address,

symbol,

token_price,

from_address,

to_address,

from ethereum.core.ez_token_transfers

where

contract_address ='0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e'

or contract_address = '0xb460daa847c45f1c4a41cb05bfb3b51c92e41b36'

or contract_address = '0x8eb6c82c3081bbbd45dcac5afa631aac53478b7c'

or contract_address = '0xefaa1604e82e1b3af8430b90192c1b9e8197e377'

or contract_address = '0x85370d9e3bb111391cc89f6de344e80176046183'

or contract_address = '0x32296969ef14eb0c6d29669c550d4a0449130230'

and from_address = '0x1e7267fa2628d66538822fc44f0edb62b07272a4'

or from_address = '0xc0a893145ad461af44241a7db5bb99b8998e7d2c'

or from_address = '0xae0baf66e8f5bb87a6fd54066e469cdfe93212ec'

),

grouped_pools as (

select

date_trunc('day', block_timestamp) as date,

sum(amount) as amount,

symbol,

contract_address

from allpools

group by 1, 4, 3

)

select

*