flipside

    nft sales over time by marketplace
    SocioAnalyticanft sales over time by marketplace
    Updated 2024-02-01
    SELECT
    date_trunc('d',block_timestamp) as date,
    platform_name,
    sum(price_usd) as "NFT sales volume [usd]",
    CASE when date BETWEEN '2023-01-01' and '2023-04-01' then 'Q1 2023'
    when date BETWEEN '2023-04-01' and '2023-07-01' then 'Q2 2023'
    when date BETWEEN '2023-07-01' and '2023-10-01' then 'Q3 2023'
    when date BETWEEN '2023-10-01' and '2023-12-31' then 'Q4 2023'
    end as quarter
    FROM polygon.nft.ez_nft_sales
    WHERE date BETWEEN '2023-01-01' AND '2023-12-31'
    GROUP by 1 , 2
    ORDER BY 1 DESC





    Last run: about 1 year ago
    DATE
    PLATFORM_NAME
    NFT sales volume [usd]
    QUARTER
    1
    		2023-12-31 00:00:00.000opensea231284.356295381Q4 2023
    2
    		2023-12-31 00:00:00.000tofunft8752.360113986Q4 2023
    3
    		2023-12-31 00:00:00.000dew3601.809415529Q4 2023
    4
    		2023-12-30 00:00:00.000tofunft6507.774217595Q4 2023
    5
    		2023-12-30 00:00:00.000opensea270166.819586691Q4 2023
    6
    		2023-12-30 00:00:00.000dew8838.024026411Q4 2023
    7
    		2023-12-29 00:00:00.000opensea240752.2141252Q4 2023
    8
    		2023-12-29 00:00:00.000dew13942.064044835Q4 2023
    9
    		2023-12-29 00:00:00.000tofunft5005.861122529Q4 2023
    10
    		2023-12-28 00:00:00.000tofunft7632.59134028Q4 2023
    11
    		2023-12-28 00:00:00.000opensea300384.856636642Q4 2023
    12
    		2023-12-28 00:00:00.000dew20579.968931563Q4 2023
    13
    		2023-12-27 00:00:00.000dew34380.46676546Q4 2023
    14
    		2023-12-27 00:00:00.000tofunft7113.205929054Q4 2023
    15
    		2023-12-27 00:00:00.000opensea307336.975990259Q4 2023
    16
    		2023-12-26 00:00:00.000dew11947.032050425Q4 2023
    17
    		2023-12-26 00:00:00.000tofunft5854.632329653Q4 2023
    18
    		2023-12-26 00:00:00.000opensea349503.694761904Q4 2023
    19
    		2023-12-25 00:00:00.000dew11941.269262665Q4 2023
    20
    		2023-12-25 00:00:00.000tofunft3773.4615899Q4 2023
    ...
    1012
    62KB
    2s