with

eth_price AS

SELECT

date_trunc( 'day' , a.hour ) AS day

, avg( a.price ) AS price

, a.symbol AS currency

FROM

ethereum.core.fact_hourly_token_prices a

GROUP BY

1 , 3

ORDER BY

1 DESC

,

new_eth_nft AS

SELECT

min( a.block_timestamp ) AS min_date

, a.project_name AS new_nft

FROM

ethereum.core.ez_nft_sales a

WHERE

a.event_type = 'sale'

GROUP BY

2

ORDER BY

1 DESC

,

eth_nft AS