cristinatintoaptos quest 3 bluemove
    Updated 2024-02-07
    --select * from aptos.core.fact_events
    --where tx_hash='0x425f703900dfc44be6d62518f52602c70d97855e62172b8baacc8ae373ff929c'

    SELECT
    trunc(block_timestamp,'day') as date,
    count(distinct tx_hash) as minting_actions,
    sum(minting_actions) over (order by date) as total_minting_actions,
    count(distinct event_data:token_name) as nfts_minted,
    sum(nfts_minted) over (order by date) as total_nfts_minted,
    count(distinct event_data:minter) as minters,
    sum(minters) over (order by date) as total_minters
    from aptos.core.fact_events
    where event_address='0xd0118317dd73ab998ffa8ac442f3d4eb2c43bd7de6bec2e8aa4afbfa8c3d27ab'
    and event_module='factory' and event_resource='MintEvent'
    and event_data:collection_name='Aptos Quest 3'
    group by 1 order by 1 desc
    Last run: 12 months ago
    DATE
    MINTING_ACTIONS
    TOTAL_MINTING_ACTIONS
    NFTS_MINTED
    TOTAL_NFTS_MINTED
    MINTERS
    TOTAL_MINTERS
    1
    2024-02-07 00:00:00.0003001925611422499127817736
    2
    2024-02-06 00:00:00.0008331895610092384977417458
    3
    2024-02-05 00:00:00.000692181238522284063116684
    4
    2024-02-04 00:00:00.000123117431139421988117416053
    5
    2024-02-03 00:00:00.000650162007612059463014879
    6
    2024-02-02 00:00:00.000705155508481983366514249
    7
    2024-02-01 00:00:00.000109414845128418985101913584
    8
    2024-01-31 00:00:00.000128313751150117701120912565
    9
    2024-01-30 00:00:00.000492912468609716200452511356
    10
    2024-01-29 00:00:00.00075397539101031010368316831
    10
    597B
    4s