LordkingTotal
    Updated 2025-05-17
    with sales as (
    select
    trunc(block_timestamp, 'hour') as hourly,
    tx_hash,
    seller_address,
    buyer_address,
    platform_name,
    nft_address,
    price_usd,
    token_id,
    price
    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 a
    where
    nft_address = 'tinkerunion_nft.enleap.near'
    ),
    fnl as (
    select
    hourly,
    tx_hash,
    seller_address,
    Last run: 25 days ago
    Buyers
    Sales
    Sellers
    Volume (USD)
    Volume (near)
    Max price (near)
    Max price ()USD
    Avg price (near)
    Avg price (USD)
    Avg NFT Per Buyer
    Avg Volume (USD) per Buyer
    1
    186353562042954102138343.253587361400236825.800681385177.937709812.874933512.132045089
    1
    100B
    1s