SELECT

TX_ID,

BLOCK_TIMESTAMP,

NFT_COLLECTION,

NFT_ID,

BUYER,

SELLER,

PRICE,

CURRENCY,

MARKETPLACE,

TX_SUCCEEDED

FROM flow.nft.ez_nft_sales

WHERE NFT_COLLECTION ilike '%topshot%'

AND TX_SUCCEEDED = TRUE

),

all_time AS (

SELECT

COUNT(DISTINCT TX_ID) AS total_sales,

COUNT(DISTINCT BUYER) AS total_buyers,

COUNT(DISTINCT SELLER) AS total_sellers,

SUM(PRICE) AS total_sales_value,

AVG(PRICE) AS avg_sale_price,

MAX(PRICE) AS max_sale_price,

MIN(PRICE) AS min_sale_price,

COUNT(DISTINCT NFT_ID) AS total_unique_nfts_sold,

COUNT(DISTINCT MARKETPLACE) AS total_marketplaces--,

--EXTRACT(YEAR FROM BLOCK_TIMESTAMP) AS year,

--EXTRACT(MONTH FROM BLOCK_TIMESTAMP) AS month

FROM sales_data

--GROUP BY year, month

),

past_year AS (

SELECT

COUNT(DISTINCT TX_ID) AS total_sales,