StangFASTmint - part 1
    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
    minters
    transactions
    tokens
    amount AVAX
    amount USD
    total minters
    total transactions
    total tokens
    total amount AVAX
    total amount USD
    1
    2024-01-10 16:05:00.0001717251254326.2513601406250012250423972.5
    2
    2024-01-10 16:04:00.00054598944515401.4513431389247512125419646.25
    3
    2024-01-10 16:03:00.00010411317587530283.7512891330238611680404244.8
    4
    2024-01-10 16:02:00.000265274466233080641.311851217221110805373961.05
    5
    2024-01-10 16:01:00.000249256443221576661.1592094317458475293319.75
    6
    2024-01-10 16:00:00.00067068612526260216658.667168713026260216658.6
    7
    2024-01-08 07:06:00.000115000115000
    7
    542B
    47s