SELECT hour::date AS price_date, AVG(price) AS price

FROM crosschain.price.ez_prices_hourly

WHERE symbol IN ('WETH')

AND price_date >= '2024-06-15'

GROUP BY 1

),

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'

),

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')

SELECT