withdrawals as (

SELECT

date_trunc('day', block_timestamp) as day,

'Withdrawals' as txn_class,

-SUM((TO_NUMBER(decoded_log:"amountSentLD"::STRING) / 1e18)) AS amount,

-COUNT(DISTINCT decoded_log:"fromAddress" :: STRING) as address

FROM

blast.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS = lower('0x04C0599Ae5A44757c0af6F9eC3b93da8976c150A')

AND event_name = 'OFTSent'

GROUP BY 1, 2

),

deposits_eth as (

SELECT

date_trunc('day', block_timestamp) as day,

'Deposits' as txn_class,

SUM(amount) as amount,

COUNT(DISTINCT to_address) as address

FROM

blast.core.ez_token_transfers

WHERE contract_address = lower('0x04C0599Ae5A44757c0af6F9eC3b93da8976c150A')

AND from_address = lower('0x0000000000000000000000000000000000000000')

AND tx_hash IN (SELECT

tx_hash

FROM blast.core.ez_decoded_event_logs

WHERE contract_address = lower('0x52c4221Cb805479954CDE5accfF8C4DcaF96623B')

AND event_name = 'Deposit'

)

GROUP BY 1, 2

SELECT * FROM deposits_eth