matejchiNFT stats
    Updated 2025-01-15
    select
    'Arbitrum' as chain,
    date_trunc('month', block_timestamp) as month,
    count(*) as total_sales,
    sum(price_usd) as volume,
    count(distinct buyer_address) as buyers,
    sum(total_fees_usd) as fees,
    sum(platform_fee_usd) as platform_fees,
    sum(creator_fee_usd) as creator_fees,
    count(distinct nft_address) as collections,
    count(distinct platform_name) as marketplaces
    from arbitrum.nft.ez_nft_sales
    where month < date_trunc('month', current_date)
    group by month

    union all

    select
    'Base' as chain,
    date_trunc('month', block_timestamp) as month,
    count(*) as total_sales,
    sum(price_usd) as volume,
    count(distinct buyer_address) as buyers,
    sum(total_fees_usd) as fees,
    sum(platform_fee_usd) as platform_fees,
    sum(creator_fee_usd) as creator_fees,
    count(distinct nft_address) as collections,
    count(distinct platform_name) as marketplaces
    from base.nft.ez_nft_sales
    where month < date_trunc('month', current_date)
    group by month

    union all

    select
    'Optimism' as chain,
    Last run: 27 days ago
    CHAIN
    MONTH
    TOTAL_SALES
    VOLUME
    BUYERS
    FEES
    PLATFORM_FEES
    CREATOR_FEES
    COLLECTIONS
    MARKETPLACES
    1
    Arbitrum2021-11-01 00:00:00.00051294534411.532646131067226720.576632307226720.576632307081
    2
    Arbitrum2021-12-01 00:00:00.000854713856458.88633311754692822.944316656692822.9443166560101
    3
    Arbitrum2022-01-01 00:00:00.00021319125690385.64182842186284519.282091396284519.28209139091
    4
    Arbitrum2022-02-01 00:00:00.0004325380365664.125245154018283.206262254018283.206262250141
    5
    Arbitrum2022-03-01 00:00:00.0003319621945607.454140645771097280.372707031082594.8842244914685.488482535181
    6
    Arbitrum2022-04-01 00:00:00.0003388314416175.30815275346721410.570795848654030.46731124567380.103484603241
    7
    Arbitrum2022-05-01 00:00:00.000239434838940.839685955301252330.454214712223194.70069884829135.753515864261
    8
    Arbitrum2022-06-01 00:00:00.000258292008228.898540796286109868.03872202185761.4727086824106.566013341481
    9
    Arbitrum2022-07-01 00:00:00.00012403740445.20978238201540671.88818511330706.9027296369964.985455477641
    10
    Arbitrum2022-08-01 00:00:00.000155101745099.76831139280988553.08695065580510.6981132988042.388837357721
    11
    Arbitrum2022-09-01 00:00:00.000234301127459.18480872625557866.93707551947067.41400385610799.5230716631402
    12
    Arbitrum2022-10-01 00:00:00.000448661182255.928332592519956132.29721706441225.4473207814906.8498962841862
    13
    Arbitrum2022-11-01 00:00:00.000537481517462.956730462280179950.68345213949060.80410781830889.8793443212542
    14
    Arbitrum2022-12-01 00:00:00.0001236113155154.6895272436337200372.58337723394816.491318422105556.0920588112882
    15
    Arbitrum2023-01-01 00:00:00.000609033776551.0145811321562214490.842870095140600.82594028673890.0169298092812
    16
    Arbitrum2023-02-01 00:00:00.000781268982821.9769991528493491450.514188115204458.26684309286992.2473450253042
    17
    Arbitrum2023-03-01 00:00:00.000352223417303.3020577813756172833.590153024132783.27883289740050.3113201272433
    18
    Arbitrum2023-04-01 00:00:00.000111081405154.3276057169175292.84065841760025.11159858515267.7290598321063
    19
    Arbitrum2023-05-01 00:00:00.000679253026636.0715589810399158724.98476237369474.48213104989250.5026313244373
    20
    Arbitrum2023-06-01 00:00:00.000315852314243.680155845026117509.38128110760597.90704692856911.4742341793523
    93
    11KB
    18s