where tx_hash = '0x0d7269b990939d59a4504673cf9b185781e7cb072ad70789a36eb15d312a98a7'

select sum(raw_amount)/pow(10,18)*0.025 as fee, date_trunc('day', block_timestamp::date) as TIME

from polygon.core.fact_token_transfers

where contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'

and origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and from_address != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

and to_address != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'

group by TIME