SELECT block_timestamp::DATE AS date,
SUM(nft.price) eth_vol,
SUM(nft.price*t.price) usd_vol,
COUNT(DISTINCT tx_hash) AS sales
FROM ethereum.core.ez_nft_sales nft
JOIN ethereum.core.fact_hourly_token_prices t
ON hour = DATE_TRUNC('HOUR', block_timestamp)
WHERE token_address ilike '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'
AND nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
AND block_timestamp::DATE >= '2022-01-01'
GROUP BY 1