hour,

AVG(price) AS price

FROM solana.price.ez_prices_hourly

WHERE token_address = 'So11111111111111111111111111111111111111112'

GROUP BY 1

),

top_markets AS (

SELECT * FROM

(

SELECT

'solana' AS chain,

marketplace,

SUM(sales_amount) AS volume

FROM solana.nft.fact_nft_sales

WHERE block_timestamp::date > CURRENT_DATE - 30

GROUP BY 1,2

ORDER BY volume DESC

LIMIT 4

)

UNION ALL

SELECT * FROM

(

SELECT

'ethereum' AS chain,

platform_name AS marketplace,

SUM(price_usd) AS volume

FROM ethereum.nft.ez_nft_sales

WHERE block_timestamp::date > CURRENT_DATE - 30

AND event_type = 'sale'

GROUP BY 1,2