StangFASTTotal transactions that have already minted Steady
    Updated 2024-01-26
    --- avax transfer
    --- CALL_ORIGIN


    --- steady [ STDY ]
    --- 0xcdab7d987f0198edb440d014ed1e71256a0e3e7a

    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

    Last run: about 1 year ago
    Date
    Minter address
    Transaction hash
    Token ID
    amount AVAX
    amount USD
    1
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b00$ 0
    2
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b10$ 0
    3
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b20$ 0
    4
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b30$ 0
    5
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b40$ 0
    6
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b50$ 0
    7
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b60$ 0
    8
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b70$ 0
    9
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b80$ 0
    10
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b90$ 0
    11
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b100$ 0
    12
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b110$ 0
    13
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b120$ 0
    14
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b130$ 0
    15
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b140$ 0
    16
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b150$ 0
    17
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b160$ 0
    18
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b170$ 0
    19
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b180$ 0
    20
    2024-01-08 07:06:13.0000x9c3fe49f747b0a169aa3b8028c41e5af4ea9efcc0x7c6a9371ba68c9b43d184488c280bced1a0b81ef8b23b8ed81842665ad573e8b190$ 0
    ...
    2500
    389KB
    40s