market AS

SELECT

a.address

, a.address_name

, a.label_type

, a.label_subtype

, a.label

FROM

aptos.core.dim_labels a

WHERE

a.label_type = 'nft'

AND a.label_subtype = 'marketplace'

GROUP BY 1 , 2 , 3 , 4 , 5

,

prices AS

SELECT

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

, avg( a.price ) AS price

, a.symbol AS symbol

, a.decimals AS decimal

FROM

aptos.price.ez_hourly_token_prices a

WHERE

a.token_address = '0x1::aptos_coin::aptoscoin'