yasminPlatform Metrics Overview 1
    Updated 2024-09-11
    -- forked from Platform Metrics Overview @ https://flipsidecrypto.xyz/edit/queries/bfc7520b-546f-4889-bbc6-b449a15c67f2

    WITH sales_data AS (
    SELECT
    seller_address AS seller,
    buyer_address AS buyer,
    TX_HASH,
    PLATFORM_FEE_USD,
    CREATOR_FEE_USD,
    TOTAL_PRICE,
    TOTAL_PRICE_USD
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    EVENT_TYPE = 'sale'
    AND platform_name in (
    '{{platform_name}}')
    AND block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= '{{End_Date}}'
    )

    SELECT
    COUNT(DISTINCT CASE WHEN seller IS NOT NULL THEN seller
    WHEN buyer IS NOT NULL THEN buyer
    END) AS n_traders,
    COUNT(DISTINCT TX_HASH) AS transactions,
    SUM(PLATFORM_FEE_USD) AS PLATFORM_FEE_USD,
    SUM(CREATOR_FEE_USD) AS CREATOR_FEE_USD,
    SUM(TOTAL_PRICE) AS volume_APT,
    SUM(TOTAL_PRICE_USD) AS volume_usd
    FROM
    sales_data;


    -- SELECT
    -- avg(price) AS price
    -- FROM
    QueryRunArchived: QueryRun has been archived