StangFASTOverall of holders
    Updated 2024-01-26

    with

    minted_tokens AS
    (
    SELECT
    a.tx_hash AS transaction
    , count( distinct a.tokenid ) AS token
    FROM
    avalanche.nft.ez_nft_transfers a
    WHERE
    a.nft_address = '0xcdab7d987f0198edb440d014ed1e71256a0e3e7a'
    AND a.event_type = 'mint'
    GROUP BY 1
    ORDER BY 2 DESC
    )
    ,
    minted_chart_1 AS
    (
    SELECT
    a.block_timestamp AS date
    , a.nft_to_address AS minter
    , a.tx_hash AS transaction
    , a.project_name AS project_name
    , a.tokenid AS token_id
    , b.amount_precise / c.token AS amount
    , b.amount_usd / c.token AS usd_volume
    FROM
    avalanche.nft.ez_nft_transfers a

    LEFT OUTER JOIN
    avalanche.core.ez_avax_transfers b
    ON a.block_timestamp = b.block_timestamp
    AND a.tx_hash = b.tx_hash
    AND a.nft_to_address = b.origin_from_address

    Last run: about 1 year ago
    Holder address
    Total tokens
    % of supply
    Total value
    1
    0x8d2a4252746090551b44839680305b0b3b6959e61004.00 %$ 34,099
    2
    0x6213fd5a700d1a059e2fb05077c5bd1e626ed9f3652.60 %$ 22,165
    3
    0x2c8477e1c5dc39c9c88d7893d140509f57dc8efb642.56 %$ 21,824
    4
    0xfb67a6a59609662330171f63142c7259f241f346622.48 %$ 21,142
    5
    0x14a5583db360426c88ce7e3b1b0a23e63fd2a009572.28 %$ 19,437
    6
    0x9932b4975e21c0c0e4215915a03728045cfdd539512.04 %$ 17,391
    7
    0x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc491.96 %$ 16,709
    8
    0x5f94c38ea6b01bcf7c0c225548e170c38d877efe421.68 %$ 14,322
    9
    0xddffe03665d437d2a247c7eae9e55fbd53b0bfd6321.28 %$ 10,912
    10
    0xf1d5345d0bf4bde68364887f48f5148bd25cb05b271.08 %$ 9,207
    11
    0x7bbe27f56ae5b95cae9e84255ca51d5e0d9a723e261.04 %$ 8,866
    12
    0x4085fbfc88192e5558aa8d1492106e757d11d6ae251.00 %$ 8,525
    13
    0xf5ffb26afbdb4a16f0812908c7863677174de5fe251.00 %$ 8,525
    14
    0x0f0e98e6b8cb3b9c0ed9ece10f9fe3d5aa52a628240.96 %$ 8,184
    15
    0x28db6bd5e71f57a19d2e52c5469289884e3afcb5230.92 %$ 7,843
    16
    0x9b4ee212fa55ad775802c4d21698c89cca9628f7220.88 %$ 7,502
    17
    0xd9f4da967fab291e475795c877504450c26de279220.88 %$ 7,502
    18
    0xd1fe7fa2322f10a84d66a908a9f4726b5383e196220.88 %$ 7,502
    19
    0x91eb12839003631e3a1550f0b4b59148be822dca200.80 %$ 6,820
    20
    0x270bf62aa871271c662b788202a711627fc98557190.76 %$ 6,479
    ...
    812
    63KB
    58s