tx_hash,

seller_address,

buyer_address,

platform_name,

nft_address,

token_id,

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_usd) as "Price (USD)"

from sales a join price b on a.hourly = b.hour)

,

uwon as (select DISTINCT tx_hash,

from near.core.fact_actions_events_function_call

where method_name = 'ft_on_transfer'

and receiver_id = 'uwon.hot.tg'

and block_timestamp::date >= '2024-05-01'

,

uwon_1 as ( select block_timestamp,