arb_zro AS (

SELECT

block_timestamp,

tx_hash,

from_address,

to_address,

symbol,

amount

FROM arbitrum.core.ez_token_transfers

WHERE symbol = 'ZRO'

AND from_address = '0xd6b6a6701303b5ea36fa0edf7389b562d8f894db'

AND to_address <> '0x0000000000000000000000000000000000000000'

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

),

arb_donate AS (

SELECT

block_timestamp,

tx_hash,

from_address,

to_address,

symbol,

amount_usd

FROM arbitrum.core.ez_token_transfers

WHERE to_address = '0xb09f16f625b363875e39ada56c03682088471523'

AND symbol IN ('USDC','USDT')

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

SELECT

block_timestamp,

tx_hash,