StangFASThold - part 3 [ holding]
    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
    type
    users
    total users
    1
    a : only 1 token469469
    2
    b : < 3 tokens214683
    3
    c : < 10 tokens90773
    4
    d : < 20 tokens21794
    5
    e : > 20 tokens18812
    5
    138B
    2s