with ez_transfer as (

BLOCK_TIMESTAMP,

BLOCK_NUMBER,

EVENT_INDEX,

TX_HASH,

CONTRACT_ADDRESS,

CONCAT('0x', SUBSTR(topics [1], 27, 40))::STRING as from_address,

CONCAT('0x', SUBSTR(topics [2], 27, 40))::STRING as to_address,

livequery.utils.udf_hex_to_int(SUBSTR(DATA, 3, 64))::integer as raw_amount

FROM blast.core.fact_event_logs

WHERE topics[0]::STRING = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

),

tb1 as (SELECT

BLOCK_TIMESTAMP::date as day,

To_ADDRESS,

sum(RAW_AMOUNT/1e18) as volume_receive

from ez_transfer

where CONTRACT_ADDRESS = lower ('0x4300000000000000000000000000000000000003')

group by 1,2),

tb2 as (SELECT

BLOCK_TIMESTAMP::date as day,

From_ADDRESS,

sum(RAW_AMOUNT/1e18) as volume_sent

from ez_transfer

where CONTRACT_ADDRESS = lower ('0x4300000000000000000000000000000000000003')

group by 1,2),

tb3 as (select

tb1.day,

tb1.to_address as user,