fantaUnique buyers/sellers OF Lightning OGs over time on Magic Eden
    Updated 2022-03-27
    with tbl_mint as (select distinct mint from solana.dim_nft_metadata where token_name='Lightning OG')

    ,tbl_PURCHASER as (select * from solana.fact_nft_sales
    where
    (program_id='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' or program_id='M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    and block_timestamp::date >= '2022-02-05'
    and mint in (select distinct mint from tbl_mint)
    )

    select count(distinct PURCHASER) as p,block_timestamp::date as d from tbl_PURCHASER
    group by d
    order by d
    Run a query to Download Data