flipside

    nf collection
    SocioAnalyticanf collection
    Updated 2024-02-01
    SELECT
    date_trunc('d',block_timestamp) as date,
    project_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
    qualify row_number() over (partition by date ORDER BY "NFT sales volume [usd]" DESC) <= 10
    ORDER BY 1 DESC






    Last run: about 1 year ago
    DATE
    PROJECT_NAME
    NFT sales volume [usd]
    QUARTER
    1
    		2023-12-31 00:00:00.000Sandbox's LANDs3898.488872Q4 2023
    2
    		2023-12-31 00:00:00.000Crypto Unicorns: Shadowcorns4288.11545425Q4 2023
    3
    		2023-12-31 00:00:00.000Voice NFT5170.418134194Q4 2023
    4
    		2023-12-31 00:00:00.000Smoofs6672.65950998Q4 2023
    5
    		2023-12-31 00:00:00.000REAL STEEL7747.467Q4 2023
    6
    		2023-12-31 00:00:00.000Blocklords Heroes10617.360489865Q4 2023
    7
    		2023-12-31 00:00:00.000Enigma Vault13690.38933Q4 2023
    8
    		2023-12-31 00:00:00.00021360.074705878Q4 2023
    9
    		2023-12-31 00:00:00.000Socrates Genesis Pen34596.9Q4 2023
    10
    		2023-12-31 00:00:00.000WildPass38976.4828596Q4 2023
    11
    		2023-12-30 00:00:00.000SATOSHI FRIENDS HNY 20245521.353546107Q4 2023
    12
    		2023-12-30 00:00:00.00061176.467179173Q4 2023
    13
    		2023-12-30 00:00:00.000Enigma Vault38959.690448Q4 2023
    14
    		2023-12-30 00:00:00.000WildPass25884.868498Q4 2023
    15
    		2023-12-30 00:00:00.000Sandbox's LANDs16018.113827873Q4 2023
    16
    		2023-12-30 00:00:00.000Fableborne Primordials8436.06284403Q4 2023
    17
    		2023-12-30 00:00:00.000Smoofs8182.5459283Q4 2023
    18
    		2023-12-30 00:00:00.000Trump Digital Trading Cards Series 27222.803803Q4 2023
    19
    		2023-12-30 00:00:00.000GasHeroCoupon7129.233748Q4 2023
    20
    		2023-12-30 00:00:00.000OpenSea Collections4284.371387076Q4 2023
    ...
    3650
    249KB
    4s