StangFAST003 - minted hourly [ number ]
    Updated 2024-01-29

    --- Dokyo
    --- 0x54c800d2331e10467143911aabca092d68bf4166

    --- Creator
    --- 0x610512654af4fa883bb727afdff2dd78b65342b7

    with

    final0 AS
    (
    SELECT
    a.block_timestamp AS dt
    , a.tx_hash AS tx
    , b.origin_to_address AS oa
    , b.avax_from_address AS af
    , b.avax_to_address AS at
    , a.nft_from_address AS nf
    , a.nft_to_address AS nt
    , a.project_name AS pj
    -- , a.tokenid AS tk
    , b.amount_precise AS am
    , b.amount_usd AS us
    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
    WHERE
    a.project_name = 'Dokyo'
    AND a.nft_address = '0x54c800d2331e10467143911aabca092d68bf4166'
    AND a.event_type = 'mint'
    GROUP BY 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
    ORDER BY 1 DESC
    Last run: about 1 year ago
    AVG( "USERS" )
    AVG( "TOKENS" )
    AVG( "MINT COUNTS" )
    AVG( "USD VOLUME" )
    SUM( "USERS" )
    SUM( "TOKENS" )
    SUM( "MINT COUNTS" )
    SUM( "USD VOLUME" )
    1
    189.21111413.489226.257594655552067356905.03
    1
    55B
    42s