flipside

    Kaito Holders NFT Portfolio
    freemartianKaito Holders NFT Portfolio
    Updated 2025-04-09
    with temp_holders AS(
    SELECT *, user_address AS holder, rank() over(partition BY user_address ORDER BY block_timestamp DESC) AS rank
    FROM ethereum.core.fact_token_balances
    WHERE contract_address = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
    qualify rank = 1
    ),

    holders AS(
    SELECT
    user_address AS holder,
    balance,
    row_number() over (order by balance desc) AS row_num
    FROM temp_holders
    -- WHERE balance >=4
    WHERE balance >0
    ORDER BY 3 asc
    ),
    holders_nfts AS (
    SELECT
    block_timestamp,
    user_address,
    contract_address,
    balance,
    rank() over(PARTITION BY user_address, contract_address ORDER BY block_timestamp DESC) AS rank
    FROM ethereum.core.fact_token_balances
    WHERE user_address in (select holder from holders)
    and contract_address in (SELECT nft_address FROM ethereum.nft.dim_nft_collection_metadata)
    -- WHERE contract_address = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
    qualify rank = 1
    ORDER BY 2 DESC
    ),
    datas AS(
    SELECT
    user_address,
    contract_address,
    balance,
    Last run: 18 days agoAuto-refreshes every 1 hour
    TOP_COLLECTION_NAME
    USERS_WITH_COLLECTION
    1
    lilpudgys
    		54
    2
    pudgypenguins
    		48
    3
    azukielementals
    		33
    4
    beanzofficial
    		32
    5
    azuki
    		24
    6
    one-gravity-7
    		23
    7
    good-vibes-club
    		17
    8
    milady
    		17
    9
    otherdeed-expanded
    		17
    10
    memelandcaptainz
    		17
    11
    jirasan
    		14
    12
    mocaverse
    		14
    13
    memelandpotatoz
    		14
    14
    seeing-signs
    		12
    15
    morph-black
    		11
    16
    quills-adventure
    		11
    17
    sappy-seals
    		11
    18
    doodles-official
    		10
    19
    mutant-ape-yacht-club
    		9
    20
    clonex
    		9
    45
    904B
    634s