sum(event_inputs:value)/pow(10,18) as volume,

date_trunc('day', block_timestamp::date) as TIME

from flipside_prod_db.polygon.events_emitted

where tx_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and event_name = 'Transfer'

and event_inputs:to != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and event_inputs:from != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'

group by TIME