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

FROM crosschain.price.ez_prices_hourly

WHERE symbol IN ('WETH','BNB','MATIC','AVAX')

AND price_date >= '2024-06-15'

GROUP BY 1,2

),

arb_zro AS (

SELECT

block_timestamp,

tx_hash,

from_address,

to_address,

symbol,

amount

FROM arbitrum.core.ez_token_transfers

WHERE symbol = 'ZRO'

AND origin_function_signature = '0xac6ae3ee'

AND from_address = '0xd6b6a6701303b5ea36fa0edf7389b562d8f894db'

AND to_address <> '0x0000000000000000000000000000000000000000'

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

),

op_zro AS(

SELECT

block_timestamp,

tx_hash,

from_address,

to_address,

symbol,

amount