flipside

    Kaito Holders NFT Portfolio
    freemartianKaito Holders NFT Portfolio
    Updated 21 minutes ago
    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: 21 minutes agoAuto-refreshes every 1 hour
    TOP_COLLECTION_NAME
    USERS_WITH_COLLECTION
    1
    lilpudgys
    		56
    2
    pudgypenguins
    		53
    3
    azukielementals
    		32
    4
    azuki
    		24
    5
    pudgyrods
    		23
    6
    one-gravity-7
    		17
    7
    otherdeed-expanded
    		17
    8
    milady
    		16
    9
    good-vibes-club
    		15
    10
    mocaverse
    		14
    11
    sappy-seals
    		13
    12
    memelandcaptainz
    		13
    13
    doodles-official
    		12
    14
    ethos-validators
    		12
    15
    jirasan
    		12
    16
    the-dooplicator
    		10
    17
    mutant-ape-yacht-club
    		9
    18
    cryptopunks
    		9
    19
    opepen-edition
    		8
    20
    moriusa-stpr
    		8
    45
    950B
    81s