SELECT

trunc(block_timestamp, 'hour') AS hourly,

tx_hash,

seller_address,

buyer_address,

platform_name,

nft_address,

token_id,

price

FROM near.nft.ez_nft_sales

),

price AS (

SELECT

hour,

price AS avg_price

FROM near.price.ez_prices_hourly

WHERE symbol = 'NEAR'

),

volume AS (

SELECT

hourly,

tx_hash,

seller_address,

buyer_address,

platform_name,

nft_address,

token_id,

price,

price * avg_price AS price_usd,

ROUND(price * avg_price) AS "Price (USD)"

FROM sales a

JOIN price b ON a.hourly = b.hour

),

uwon AS (

SELECT DISTINCT tx_hash