price_avax as

select

date_trunc( 'day' , a.hour ) as daily ,

avg( a.price ) as price ,

a.decimals as decimal ,

a.token_address as token_address ,

a.name as token_name ,

a.symbol as token_symbol

from

avalanche.price.ez_prices_hourly a

group by 1 , 3 , 4 , 5 , 6

order by 1 desc

,

minting_txhash as

select

a.block_timestamp as datetimes ,

a.tx_hash as txhashs ,

a.nft_from_address as from_address ,

a.nft_to_address as to_address ,

a.tokenid as token_id

from

avalanche.nft.ez_nft_transfers a

where

a.nft_address = '0xce4fee23ab35d0d9a4b6b644881ddd8adebeb300'

and a.event_type = 'mint'

group by 1 , 2 , 3 , 4 , 5

order by 1 desc