price AS

SELECT

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

, avg( a.price ) AS price

, a.token_address AS tkn_address

, a.decimals AS tkn_decimal

, a.symbol AS tkn_symbol

FROM

ethereum.price.ez_hourly_token_prices a

GROUP BY 1 , 3 , 4 , 5

ORDER BY 1 DESC

,

collection AS

SELECT

-- min( b.event_index )

b.block_timestamp AS dt

, b.tx_hash AS tx

, b.contract_address AS ca

, case

when ca = '0x07887ee0bd24e774903963d50cf4ec6a0a16977d' then 'Pixels of The Doge NFT'

else b.contract_name

end

AS cn

, b.decoded_log:"from" AS se

FROM