hour::date as datee,

avg(PRICE) as usdprice

from aptos.price.ez_prices_hourly

where symbol = 'APT'

group by 1

select DISTINCT platform_name,

count(DISTINCT tx_hash) as "Sales",

count(DISTINCT buyer_address) as "Buyers",

sum(total_price_raw/pow(10,8)) as "Sales Volume $APT",

sum((total_price_raw/pow(10,8))*usdprice) as "Sales Volume USD",

sum((platform_fee_raw/pow(10,8))*usdprice) as "Platform Fees USD",

sum((CREATOR_FEE_RAW/pow(10,8))*usdprice) as "Creator Fees USD",

sum((TOTAL_FEES_RAW/pow(10,8))*usdprice) as "Total Fees USD"

from aptos.nft.fact_nft_sales

join price on block_timestamp::date=datee

where block_timestamp::date >= current_date-30

group by 1

order by 5 DESC