MLDZMNnfts1
    Updated 2023-04-27
    -- thanks to marqu for valubel tips
    with tb2 as (select
    RECORDED_HOUR::date as day,
    avg(close) as price_token
    from solana.core.fact_token_prices_hourly where SYMBOL='SOL'
    group by 1)
    select
    count(distinct tx_id) as no_mints,
    count(distinct INSTRUCTION:accounts[1]) as no_minter,
    count(distinct SIGNERS[0]) as no_collections,
    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'
    limit 10
    Run a query to Download Data