date_trunc('hour', block_timestamp) as day,

min(PRICE) as "Minimum Sale Price",

min(PRICE_USD) as min_price_usd,

max(PRICE) as "Maximum Sale Price",

max(PRICE_USD) as max_price_usd,

avg(PRICE) as avg_price,

avg(PRICE_USD) as avg_price_usd,

sum(PRICE) as volume,

sum(PRICE_USD) as volume_usd

from

ethereum.core.ez_nft_sales

where

NFT_ADDRESS = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769'

group by

day