LordkingWeekly
    Updated 2025-04-13

    with sales as (
    select
    trunc(block_timestamp, 'hour') as hourly,
    tx_hash,
    seller_address,
    buyer_address,
    platform_name,
    nft_address,
    token_id,
    price,price_usd
    from
    near.nft.ez_nft_sales
    ),
    volume as (
    select
    hourly,
    tx_hash,
    seller_address,
    buyer_address,
    platform_name,
    nft_address,
    token_id,
    price,
    round(price_usd) as price_usd
    from
    sales
    where
    nft_address = 'harvestmoon.sharddog.near'
    ),
    fnl as (
    select
    hourly,
    tx_hash,
    seller_address,
    buyer_address,
    Last run: 12 days ago
    Date
    Buyers
    Sales
    Sellers
    Volume (USD)
    Volume (near)
    Avg price (USD)
    Min price(USD)
    Max price(USD)
    Avg price (near)
    Min price(near)
    Max price(near)
    Avg NFT Per Buyer
    Avg Volume (USD) per Buyer
    Growth volume (USD)
    Growth volume (near)
    Growth Sales
    1
    2024-09-30 00:00:00.0007083659011.6049380.8910891089020.11490037620.047230.451.1857141.2857142867822813685.52802327923966
    2
    2024-03-25 00:00:00.0001488732195595774.5637974.16294642911440.5763123490.2001205.89864937.804054054300436098.34891964412548
    3
    2025-03-31 00:00:00.00011100.054990000.054990.054990.05499107846813747.24127627924307
    4
    2025-02-17 00:00:00.00046651.807490.8333333333050.30124833330.021.58251.51.257846113742.55419727924271
    5
    2024-07-22 00:00:00.0002778981142733479.4105881.96054519401270.34391003440.040322.53.2418779.8664259937639313274.94781757922817
    6
    2024-11-25 00:00:00.000587274.007292.0769230770220.30825307690.06253.10251.65.47830513711.88396927924128
    7
    2024-04-22 00:00:00.0002247722983251442.047694322.91047448511360.39574547390.15193.44642914.513392857491179056.04579676416795
    8
    2024-02-26 00:00:00.000709331416156351481.5912189111.70036210560.4470703738013.984.6741897.947813822116193190.9445379116750
    9
    2025-02-10 00:00:00.00044351.86751050.37350.051.612511.257845613740.74670727924265
    10
    2024-08-12 00:00:00.00036603511934.0503851.4512195120190.41524859760.054.80251.6666673.3055555567777013584.09250547923333
    11
    2025-03-17 00:00:00.00067262.9374390.75060.3671798750.054992.451.16666717846813746.76068627924293
    12
    2024-07-29 00:00:00.000183354801009207.26538292.277652370360.46786768150.0236.661.9344265.5136612027740213482.21320047923171
    13
    2025-02-03 00:00:00.00035310.96250.1428571429010.13750.10.31.6666670.33333333337845113738.87920727924261
    14
    2025-03-03 00:00:00.00013100.120000.020.020.02307846113742.84469727924278
    15
    2025-01-27 00:00:00.00035200.46890000.078150.06150.11.66666707845013737.91670727924256
    16
    2024-06-10 00:00:00.0001656861003025501.972400723.04939516111310.50602056520.23520.9994.15757618.3333333336793411712.61897957920663
    17
    2024-12-09 00:00:00.000555314.322496.20280.8644980.06253.9716.27840813725.65123827924162
    18
    2024-12-02 00:00:00.000102910729.4447791.440270.188895580.02023.972.97.27837713721.32874827924157
    19
    2024-04-01 00:00:00.000317140818765881002.5436993.29729729701910.50177362310284.4416420.782334385366317100.89261864413956
    20
    2024-07-08 00:00:00.00031834026155.114262.2695652171940.47925443480.26117.52.6774198.4193548397256412614.40702957921685
    61
    8KB
    4s