freemartianTop Holders NFT Collections
    Updated 53 seconds ago
    -- with sapes_api as (
    -- SELECT
    -- livequery.live.udf_api(
    -- 'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/sale.json'
    -- ) AS response
    -- ),
    -- datas AS(
    -- SELECT
    -- to_timestamp(value:closing_date) AS block_timestamp,
    -- value:transaction AS tx_hash,
    -- value:event_type AS event,
    -- value:protocol_address AS protocol_address,
    -- value:nft:identifier AS identifier,
    -- value:nft:collection AS collection,
    -- value:chain AS chain,
    -- value:buyer AS buyer,
    -- value:seller AS seller,
    -- (value:payment:quantity) / pow(10, 18) AS price,
    -- -- ROUND(((value:payment:quantity) / pow(10,18)),8) AS price,
    -- value:quantity AS qty
    -- FROM
    -- sapes_api,
    -- LATERAL FLATTEN (input => response:data)
    -- GROUP BY
    -- ALL
    -- ORDER BY
    -- 1 DESC
    -- ),
    -- sellers AS(
    -- SELECT
    -- seller AS seller,
    -- count(tx_hash) AS transactions,
    -- -- count(DISTINCT seller) AS seller,
    -- -- count(DISTINCT buyer) AS buyer,
    -- SUM(price) AS eth_value,
    -- SUM(qty) AS quantity
    Last run: 1 minute agoAuto-refreshes every 1 hour
    USER_ADDRESS
    COLLECTION
    Collection NFTs
    Kaito NFTs
    1
    0xe5e83c2347be43eb917715c7385ae2a2cf95453c
    kaito-genesis
    5757
    2
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    the-dooplicator
    6830
    3
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    space-doodles-official
    4130
    4
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    memelandpotatoz
    3630
    5
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    kaito-genesis
    3030
    6
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    gemesis
    2030
    7
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    skyborne-genesisimmortals
    230
    8
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    memelandmvp
    130
    9
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    nexusnodes
    130
    10
    0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4
    pudgypenguins
    130
    11
    0x7decd0770371096f135547bdbdf3831799239ccf
    kaito-genesis
    2626
    12
    0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9
    kaito-genesis
    2525
    13
    0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9
    milady
    125
    14
    0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9
    meebits
    125
    15
    0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9
    azuki
    125
    16
    0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4
    ultiverse-electric-sheep
    4525
    17
    0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4
    kaito-genesis
    2525
    18
    0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4
    bodegacatceo-editions
    825
    19
    0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4
    renga
    525
    20
    0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4
    es0rigin
    425
    ...
    1091
    74KB
    38s