flipside

    Top 10 Collections
    Afonso_DiazTop 10 Collections
    Updated 5 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: 5 days ago
    NFT_ADDRESS
    TRANSACTIONS
    VOLUME_NEAR
    VOLUME_USD
    1
    		aa-harvest-moon-relics.near517429066.270199128760.09464024
    2
    		harvestmoon.sharddog.near25701131.0824767206.509293188
    3
    		x.paras.near591408.92181868.477313185
    4
    		nft.ai-santa.tg498523.380892655.0370094
    5
    		citizen.bodega-lab.near4441481.3869999983409.330094916
    6
    		tinkerunion_nft.enleap.near30716347.42996982409.547081144
    7
    		blackdragonforevernft.near2591780.1768800.254613
    8
    		mint.sharddog.near23891.11445626.335387097
    9
    		doubledog.hot.tg2273335.9895920615.70418526
    10
    		hapi-nearonaut.near195139.94514.38014
    10
    550B
    1s