sum(PLATFORM_FEE_USD) as SUM_PLATFORM_FEE_USD,

avg(PLATFORM_FEE_USD) as AVG_PLATFORM_FEE_USD,

MEDIAn(PLATFORM_FEE_USD) as MEDIAn_PLATFORM_FEE_USD,

sum(CREATOR_FEE_USD) as SUM_CREATOR_FEE_USD,

avg(CREATOR_FEE_USD) as AVG_CREATOR_FEE_USD,

MEDIAn(CREATOR_FEE_USD) as MEDIAn_CREATOR_FEE_USD

-- sum(TOTAL_FEES_USD) as TOTAL_FEES_USD

from optimism.core.ez_nft_sales

where NFT_ADDRESS = lower('0x0deaAc29d8A3d4EbBAAa3eCd3cC97C9deF00f720') and event_type = 'sale'-- and date_trunc('hour', BLOCK_TIMESTAMP) >= dateadd(hour,-24,getdate())