date_trunc('hour', CONVERT_TIMEZONE('America/New_York', block_timestamp)) as date,

avg(price) as avg_eth,

count(*) as num_tx

FROM ethereum.core.ez_nft_sales

WHERE nft_address = '0xbd3531da5cf5857e7cfaa92426877b022e612cf8'

GROUP BY 1

ORDER BY 1