MLDZMNcom6
    Updated 2023-04-27
    select
    s.BLOCK_TIMESTAMP::date as date,
    case
    when s.BLOCK_TIMESTAMP>='2023-04-06' then 'after announcement'
    else 'before announcement' end as time_period,
    count(distinct s.tx_id) as no_mint,
    count(distinct PURCHASER) as no_minter,
    count(distinct MINT) as no_NFTs,
    sum(MINT_PRICE) as volume,
    avg(MINT_PRICE)as average_volume,
    Median(MINT_PRICE) as median_volume,
    volume/count(distinct date_trunc(day, s.block_timestamp)) as average_volume_day,
    no_NFTs/count(distinct date_trunc(day, s.block_timestamp)) as average_mint_day,
    avg(fee/1e9) as avg_fee,
    sum(fee/1e9) as total_fee
    from solana.core.fact_nft_mints s
    left join solana.core.fact_transactions a on s.tx_id=a.tx_id
    where s.BLOCK_TIMESTAMP>='2023-03-15'
    and s.SUCCEEDED='TRUE'
    and MINT_PRICE > 0
    and MINT_CURRENCY='So11111111111111111111111111111111111111111'
    group by 1,2
    Run a query to Download Data