freeman_7Blur NFT MARKET STATISTIC
    Updated 2025-01-23
    With blur as(
    Select
    Date_trunc('{{period}}',block_timestamp) as date_time,
    Count(distinct tx_hash) as transactions,
    Count( distinct buyer_address) as Nft_buyers,
    Count(distinct seller_address) as nft_sellers,
    Sum(price_usd) as Volume,
    Sum(tx_fee) as Transaction_fee
    From ethereum.nft.ez_nft_sales
    Where platform_name ilike 'blur%'
    Group by 1

    ),

    Royalty_payer as (
    Select
    Date_trunc('{{period}}',block_timestamp) as date_time,
    Count(tx_hash) as royalty_transactions,
    Count(distinct buyer_address) as Royalty_payers,
    Sum(creator_fee_usd) as royalties_volume
    From ethereum.nft.ez_nft_sales
    Where platform_name ilike 'blur%'
    And CREATOR_FEE_USD > 0
    Group by 1
    ),

    Bluechip as (
    SELECT
    Date_trunc('{{period}}',block_timestamp) as date_time,
    --Project_name,
    Count(tx_hash) as bluechip_Royalty_transaction,
    Sum(price_usd) as bluechip_volume,
    Sum(creator_fee_usd) as Bluechip_Royalties_volume
    From ethereum.nft.ez_nft_sales
    Where platform_name ilike 'blur%'
    And Project_name in ('BoredApeYachtClub','MutantApeYachtClub','PudgyPenguins','Azuki','Wrapped Cryptopunks','DeGods','Meebits','Something','Doodles','BoredApeKennelClub','CloneX','Moonbirds','Otherdeed','Milady')
    Last run: about 2 months ago
    DATE_TIME
    TRANSACTIONS
    NFT_BUYERS
    MOVING_AVERAGE_NFT_BUYERS
    NFT_SELLERS
    VOLUME
    MOVING_AVERAGE_VOLUME
    ROYALTY_TRANSACTIONS
    TRANSACTION_FEE
    ROYALTY_PAYERS
    ROYALTIES_VOLUME
    BLUECHIP_ROYALTY_TRANSACTION
    BLUECHIP_VOLUME
    BLUECHIP_ROYALTIES_VOLUME
    ROUTE_THROUGH_OPENSEA_TRANSACTION
    1
    2022-08-01 00:00:00.0001132626341194448.903828386194448.9038283862388.148299725246886.8729380311013533.933812563676.696690628204
    2
    2022-08-29 00:00:00.00012673121694147441129.931233321317789.4175308533085194.09195213325610374.161393779212069.281940662603.4640970333723
    3
    2022-09-12 00:00:00.0001281324220.6664509613174.483103981416251.1060552293426141.83678482631533042.4972562763366407.2928643243320.3646432163212
    4
    2022-09-19 00:00:00.0001708419270.255383481140.824157426432473.5355807784695193.46359257140917267.9895418711317705.359196873885.2679598443975
    5
    2022-10-17 00:00:00.0001509567811572.4181705840861.425986711514151.11366196283331451.1710484445324141808.826028485265646732.43249968520834.56410393810866
    6
    2022-10-24 00:00:00.00018954875827701786611150341.88350643120182.9086360429487958.1692956746073185950.8816947075311822935.2479966953472.3737151710184
    7
    2022-10-31 00:00:00.00037345142964416.5712444275237295.266781513422627.5312283372761723.2630001958818655342.5909004295352305848.4556222860215.20303396210047
    8
    2022-11-07 00:00:00.00025833104395169.3752027422018098.313271314497061.3789836204431771.2226322325158190759.8738440975042265833.1054885839669.6030537158411
    9
    2022-11-14 00:00:00.0001669283446209.1251418018223838.805296816750735.116667211652828.8831854913503130725.6013222866742312373.8467184745614.2971185035026
    10
    2022-11-21 00:00:00.0001539276947131.8751258526127024.253648519961471.906969110805588.916825213077149448.7826846016734134870.9279919182320.1140308455234
    11
    2022-11-28 00:00:00.000333501566990502129326817243.180480623236980.494141222966936.8745891537240188632.09353240416734828932.7005220362450.2651598497359
    12
    2022-12-05 00:00:00.000274121165610454.6251654582638384.028904733506635.8947346136121186.2473636824136276976.27777182810095375612.77154505118446.6540048995442
    13
    2022-12-12 00:00:00.000352671192111097.12516727137423397.09195149954452.8529801196001841.4472423714783364826.3416875424351661103.1335172833368.1113346819
    14
    2022-12-19 00:00:00.000427281362011704.87518850144786938.53305366659027.4341734167661925.7639377094290200697.7028892116583329223.9680895669703.5580342848587
    15
    2022-12-26 00:00:00.000510151494211785.62523938129170834.25324373400719.8074812228032577.6580411925207305873.4964127997343503829.0889488197606.54819176211921
    16
    2023-01-02 00:00:00.000479241611712495.37525666105035630.92121283777911.3834738750982770.94261728713115861641.934202505764457739993.2364993386031.27593747314184
    17
    2023-01-09 00:00:00.000361061358613150.6252066092620380.768560393077479.1288818774242962.88907121512688744205.400215706806465301738.4351598387767.55042722210620
    18
    2023-01-16 00:00:00.0003169412489137501929678696690.032461899648687.3512334655912806.2393700811195627053.046740407617758476930.1470331369741.0642669199042
    19
    2023-01-23 00:00:00.000304491142513219.51631672227995.9937511105325031.452892653282385.69281881410497605747.559468061621943374149.1253357295834.9644954086688
    20
    2023-01-30 00:00:00.000277921071513101.8751454687551324.967401105939149.070204677213097.43075954210100694052.434546081907161996376.8024149388554.5096319355773
    ...
    123
    21KB
    7s