flipside

    impressive-aqua
    kentoimpressive-aqua
    Updated 2025-03-24
    -- 1️⃣ Total NFT Sales Volume ($) & Number of Active NFT Traders
    WITH eth_sales AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS date,
    SUM(price_usd) AS eth_sales_volume,
    COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address) AS eth_active_traders
    FROM ethereum.nft.ez_nft_sales
    WHERE block_timestamp >= '2025-01-01'
    GROUP BY 1
    ),
    arb_sales AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS date,
    SUM(price_usd) AS arb_sales_volume,
    COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address) AS arb_active_traders
    FROM arbitrum.nft.ez_nft_sales
    WHERE block_timestamp >= '2025-01-01'
    GROUP BY 1
    ),
    avax_sales AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS date,
    SUM(price_usd) AS avax_sales_volume,
    COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address) AS avax_active_traders
    FROM avalanche.nft.ez_nft_sales
    WHERE block_timestamp >= '2025-01-01'
    GROUP BY 1
    ),
    sol_sales AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS date,
    SUM(price_usd) AS sol_sales_volume,
    COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address) AS sol_active_traders
    FROM solana.nft.ez_nft_sales
    WHERE block_timestamp >= '2025-01-01'
    GROUP BY 1
    ),
    poly_sales AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS date,
    SUM(price_usd) AS poly_sales_volume,
    Last run: 3 months ago
    DATE
    ETH_SALES_VOLUME
    ARB_SALES_VOLUME
    AVAX_SALES_VOLUME
    SOL_SALES_VOLUME
    POLY_SALES_VOLUME
    ETH_ACTIVE_TRADERS
    ARB_ACTIVE_TRADERS
    AVAX_ACTIVE_TRADERS
    SOL_ACTIVE_TRADERS
    POLY_ACTIVE_TRADERS
    1
    		2025-01-01 00:00:00.00013307281.7356405178201.40777263631.896713121630112.663315144517783.627513447700134414377366352
    2
    		2025-01-02 00:00:00.00016543957.0175237304577.332613168758.1575913847528.521717481886407.065620788021902159108777965
    3
    		2025-01-03 00:00:00.00015830488.4886896302366.1885038267601.46429012463250.679704811615646.258808818922248422187107508
    4
    		2025-01-04 00:00:00.00014019966.4422466351522.32937825413546.93257942420691.93732452305141.5352397980213737482979102
    5
    		2025-01-05 00:00:00.00014622544.13019232439820.9935616580.3934205982299215.054449531664604.615552727726172918886237245
    6
    		2025-01-06 00:00:00.00022647793.79909081067400.2209978928687.1768894632950664.193410331004254.119855057843210817282056536
    7
    		2025-01-07 00:00:00.00024774426.0649661391799.97124619128226.1630233762754.458483311762669.795775097880194511384886844
    8
    		2025-01-08 00:00:00.00015929599.4379289280914.9433138653069.9343255521702526.250129321455664.191969447271153314871217811
    9
    		2025-01-09 00:00:00.00015789112.63652461100129.4054067929741.3735263962044722.147711331675912.688338117003344017374966846
    10
    		2025-01-10 00:00:00.00015393949.9393312355496.4752151293608.3527309691448917.161717471958599.942689537107217314872326484
    11
    		2025-01-11 00:00:00.00010746437.6606638407124.4637051532204.67788171942606.322762141174562.311872866776205711171806439
    12
    		2025-01-12 00:00:00.00010633249.8761777224257.6449880612334.6750551376622.625949431231008.97026391665115148178926318
    13
    		2025-01-13 00:00:00.00040244380.8567702138177.37074444828356.3304192361455962.334910571040482.387781198075240312872196253
    14
    		2025-01-14 00:00:00.00022399688.0925962296502.25956233531022.52188661361581.408957751171138.827413088209153230369986639
    15
    		2025-01-15 00:00:00.00022909665.0647576233544.3878459854613.82893471134333.078499961176976.635584977149226919766216358
    16
    		2025-01-16 00:00:00.00016578554.2865178693517.36749398130302.882661851227271.897345661042246.16800757024204917773905989
    17
    		2025-01-17 00:00:00.00022229566.7379582961923.2960484636000.690423491176887.432318443189249.152720937610392518861107732
    18
    		2025-01-18 00:00:00.00036520297.6861882157087.5480168852307.99400942295318.355487223599102.233196717729165614485419506
    19
    		2025-01-19 00:00:00.00030987272.5144927172587.0908183632298.527789661632071.019889031774312.822052955997126211969116587
    20
    		2025-01-20 00:00:00.00022930214.819124240017.1846056951691.8540779751564407.528452191022699.860185925249167411469415566
    83
    11KB
    21s