SocioAnalyticatotal nft sales per marketplace
    Updated 2024-02-01
    with
    q1 as (
    SELECT
    platform_name,
    sum(price_usd) as "Q1 2023"
    FROM polygon.nft.ez_nft_sales
    WHERE block_timestamp::date BETWEEN '2023-01-01' AND '2023-04-01'
    GROUP by 1
    )
    ,
    q2 as (
    SELECT
    platform_name,
    sum(price_usd) as "Q2 2023"
    FROM polygon.nft.ez_nft_sales
    WHERE block_timestamp::date BETWEEN '2023-04-01' AND '2023-07-01'
    GROUP by 1
    )
    ,
    q3 as (
    SELECT
    platform_name,
    sum(price_usd) as "Q3 2023"
    FROM polygon.nft.ez_nft_sales
    WHERE block_timestamp::date BETWEEN '2023-07-01' AND '2023-10-01'
    GROUP by 1
    )
    ,
    q4 as (
    SELECT
    platform_name,
    sum(price_usd) as "Q4 2023"
    FROM polygon.nft.ez_nft_sales
    WHERE block_timestamp::date BETWEEN '2023-10-01' AND '2023-12-31'
    GROUP by 1
    )
    Last run: about 1 year ago
    PLATFORM_NAME
    NFT Sales Q1 2023
    NFT Sales Q2 2023
    NFT Sales Q3 2023
    NFT Sales Q4 2023
    NFT Sales
    % Q4 2023
    1
    opensea146330585.46224242686974.669896623863047.813499720133129.2039564233013737.1495959
    2
    dew144574.9026693392161111.531129024114249.28210659930809.9333958317350745.6493007813
    3
    tofunft127516.1138196331052397.08002354805022.526270856519123.545636172504059.265750221
    3
    294B
    5s