eth_deposits AS (

SELECT

block_timestamp,

tx_hash,

decoded_log:user :: string AS user,

decoded_log:amount / pow(10,18) AS amount,

'Ethereum Deposit' AS label

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'

AND event_name = 'DepositCreated'

AND block_timestamp::date >= '2024-06-01'

),

eth_withdraws AS (

SELECT

block_timestamp,

tx_hash,

decoded_log:user :: string AS user,

decoded_log:totalAmount / pow(10,18) AS amount,

'Ethereum Withdraw' AS label

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'

AND event_name = 'DepositsWithdrawn'

AND block_timestamp::date >= '2024-06-01'

),

base_deposits AS(

SELECT

block_timestamp,

tx_hash,

from_address :: string AS user,

amount,

'Base Deposit' AS label