Drsimonterraforms2- 1w
    Updated 2023-03-08
    SELECT
    DISTINCT ez_nft_sales.PLATFORM_NAME AS platform_name,
    -- ez_nft_sales.PLATFORM_ADDRESS AS platform_address,
    COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.BUYER_ADDRESS ELSE NULL END) AS buyers_count,
    COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.SELLER_ADDRESS ELSE NULL END) * -1 AS sellers_count,
    COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TX_HASH ELSE NULL END) AS nft_sales_count,
    AVG(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE_USD ELSE NULL END) AS avg_price_usd,
    SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE_USD ELSE NULL END) AS total_sales_usd,
    SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE ELSE NULL END) AS total_sales_eth,
    SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TOTAL_FEES ELSE NULL END) AS total_fees_eth,
    SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TOTAL_FEES_USD ELSE NULL END) AS total_fees_usd,
    DATE_TRUNC('WEEK', ez_nft_sales.BLOCK_TIMESTAMP) AS date
    FROM ethereum.core.ez_nft_sales
    WHERE ez_nft_sales.PROJECT_NAME LIKE 'terraforms'
    AND ez_nft_sales.BLOCK_TIMESTAMP > '2020-01-01'
    GROUP BY ez_nft_sales.PLATFORM_NAME,date ORDER BY date DESC
    Run a query to Download Data