SELECT block_timestamp, 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 block_timestamp, 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'

),

Relaysumm AS (

SELECT Date_trunc('day', block_timestamp) AS Date,

count(DISTINCT tx_hash) AS Total_Transaction, type,

COUNT(DISTINCT Sender) AS Number_of_Unique_User,

SUM(Amount_usd) AS total_amount_usd

FROM RelayBlast

GROUP BY Date, type

SELECT Date, type,

Total_Transaction,

total_amount_usd,

FROM Relaysumm

ORDER BY Date DESC