with naf_sales_txs as (

BLOCK_TIMESTAMP,

TX_HASH,

PLATFORM_ADDRESS as MARKETPLACE_ADDRESS,

PLATFORM_NAME as MARKETPLACE,

PROJECT_NAME as COLLECTION_NAME,

TOKENID as NFT_ID,

TOTAL_PRICE_RAW/1e8 as price,

TOTAL_FEES_RAW/1e8 as total_fee,

PLATFORM_FEE_RAW/1e8 as platform_fee,

CREATOR_FEE_RAW/1e8 as creator_fee,

seller_address as seller,

BUYER_ADDRESS as BUYER

from aptos.nft.fact_nft_sales

,

priceTb as (

SELECT

TO_TIMESTAMP(value[0]::string) as p_date,

'APT' as symbol,

value[1] as usd_price

FROM (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/aptos/market_chart?vs_currency=usd&days=max&interval=daily&precision=3') as resp

),LATERAL FLATTEN(input => resp:data:prices)

WHERE p_date >= '2022-10-19'

date_trunc('day', BLOCK_TIMESTAMP) as date,

MARKETPLACE,

count(DISTINCT tx_hash) as n_sales,

count(DISTINCT buyer) as n_buyers,

count(DISTINCT seller) as n_sellers,