SELECT

Date_trunc('day', block_timestamp) AS date,

tx_hash,

'Deposit' AS Type,

from_address AS Sender,

amount_usd

FROM

blast.core.ez_native_transfers

WHERE

to_address = '0xf70da97812cb96acdf810712aa562db8dfa3dbef'

AND block_timestamp >= '2024-01-01'

UNION ALL

SELECT

Date_trunc('day', block_timestamp) AS date,

tx_hash,

'Withdraw' AS Type,

to_address AS Sender,

-amount_usd

FROM

blast.core.ez_native_transfers

WHERE

from_address = '0xf70da97812cb96acdf810712aa562db8dfa3dbef'

AND block_timestamp >= '2024-01-01'

),

newuser AS (

SELECT

MIN(date) AS MinDate,

Sender

FROM

RelayBlast

GROUP BY

Sender