0xaimanDaily Average NFT mint txn by User
    Updated 2022-07-06
    with bm as (select dt, avg(n_txn) as avg_txn
    from (

    select date(block_timestamp) as dt, purchaser, count(tx_id) as n_txn from solana.core.fact_nft_mints
    group by 1,2 order by 1
    )
    group by 1 order by 1 ),


    m as (

    select date(block_timestamp) as dt, purchaser, count(tx_id) as n_txn from solana.core.fact_nft_mints
    group by 1,2 order by 1)

    select m.dt, avg_txn --, case when n_txn> avg_txn then 'NFT trader' else null end as act_type
    from m inner join bm on m.dt=bm.dt
    Run a query to Download Data