Afonso_DiazTop 10 Collections
    Updated 6 days ago
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    buyer_address,
    seller_address,
    price,
    price_usd,
    nft_address,
    token_id
    from
    near.nft.ez_nft_sales
    where
    platform_name = 'TradePort'
    )

    select
    nft_address,
    count(distinct tx_hash) as transactions,
    sum(price) as volume_near,
    sum(price_usd) as volume_usd
    from
    main
    group by 1
    order by transactions desc
    limit 10


    Last run: 6 days ago
    NFT_ADDRESS
    TRANSACTIONS
    VOLUME_NEAR
    VOLUME_USD
    1
    aa-harvest-moon-relics.near526329568.870199130127.84004024
    2
    harvestmoon.sharddog.near25721131.1824567206.778239388
    3
    x.paras.near591408.92181868.477313185
    4
    nft.ai-santa.tg501525.260892659.6693094
    5
    citizen.bodega-lab.near4441481.3869999983409.330094916
    6
    tinkerunion_nft.enleap.near30916416.42996982595.937081144
    7
    blackdragonforevernft.near2661819.7568913.968113
    8
    mint.sharddog.near23891.11445626.335387097
    9
    doubledog.hot.tg2273335.9895920615.70418526
    10
    hapi-nearonaut.near195139.94514.38014
    10
    550B
    1s