MLDZMNtop_nfts2
    Updated 2023-04-27
    select
    SIGNERS[0] as deployer,
    count(distinct tx_id) as no_mints,
    count(distinct INSTRUCTION:accounts[1]) as no_minter,
    no_mints/no_minter as average_mint_minter,
    no_mints/count(distinct date_trunc(day, block_timestamp)) as average_mint_day,
    no_minter/count(distinct date_trunc(day, block_timestamp)) as average_minter_day

    from solana.core.fact_events
    where PROGRAM_ID ='BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
    and SUCCEEDED ='TRUE'
    and BLOCK_TIMESTAMP>='2023-04-06'
    group by 1
    order by 3 desc
    limit 10
    Run a query to Download Data