SELECT DATE(hour) AS dt, price

FROM blast.price.ez_hourly_token_prices

WHERE EXTRACT(HOUR FROM hour) = 0

AND symbol = 'WETH'

ORDER BY hour DESC

),

transfers AS (

SELECT

ORIGIN_FROM_ADDRESS as user,

DATE(block_timestamp) as dt,

COALESCE(SUM(CASE WHEN contract_address = '0x4300000000000000000000000000000000000004' THEN RAW_AMOUNT/1e18 END), 0) as weth_raw_amount_sum,

COALESCE(SUM(CASE WHEN contract_address = '0x4300000000000000000000000000000000000003' THEN RAW_AMOUNT/1e18 END), 0) as usb_raw_amount_sum

FROM blast.core.fact_token_transfers

WHERE from_address = '0x6a372dbc1968f4a07cf2ce352f410962a972c257'

AND ORIGIN_TO_ADDRESS IN (

'0x5430561b09c627264549fdb3a6154c34f5cabea7',

'0xb0ceff252f18710a3315e735b5e26481840ad286',

'0xdd56a994568e01eb16c69718dae13073098f4003',

'0x99660f7ade18a02f1f88f2bfc7a2515ceff9c9c6',

'0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8',

'0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8',

'0xca9d4fdc71c6866b7a5ba1cc463044271bd799d7',

'0x5d59a8cea43f6729e336cb7278a3210590be6fa9',

'0x99c1ca21a54d5d8d7e2ad52e0b3f7bd2326a92b4',

'0x8cbb731d960c9be0e743cd3984c18245de447113',

'0x379226d215509de2089103e0d5c425e54889830e',

'0xfc37d560b7102ad725193cf1220690740d2601cf',

'0x379226d215509de2089103e0d5c425e54889830e',

'0x8170826fd8bc4314be57f40673413e87453da691',

'0xec3d9ace23d03de91c1f5d553aa426230ab82f5c',

'0x4fde5557d54ed955c7e3da40f2c7900cde5eefe0'

)

GROUP BY ORIGIN_FROM_ADDRESS, DATE(block_timestamp)

),