nft_sales AS (

SELECT s.tx_hash

, s.block_timestamp

, s.buyer_address

, s.seller_address

, s.platform_name

, s.nft_address

, s.tokenid AS token_id

, s.price_usd

, (CASE WHEN s.currency_symbol IN ('ETH','WETH') THEN s.price

ELSE s.price_usd / p.price END) AS price_eth

FROM ethereum.core.ez_nft_sales AS s

LEFT JOIN ethereum.core.fact_hourly_token_prices AS p

ON p.hour = date_trunc('hour', s.block_timestamp)

AND s.currency_address = p.token_address

AND s.currency_symbol = 'WETH'

WHERE block_timestamp >= CURRENT_DATE - interval '1 years' - interval '{{TimePeriodDays}} days' - interval '1 month'

),

daily_volume AS (

SELECT date_trunc('day', block_timestamp) AS utc_date

, sum(price_usd) AS volume_usd

, sum(price_eth) AS volume_eth

FROM nft_sales

GROUP BY 1

),

daily_volume__annotated AS (

SELECT utc_date

, volume_usd