fantacollectionsovertime
    Updated 2022-04-09
    with top20wallets as (select top 20 sum(sales_amount) as sales_amount , purchaser as wallet from solana.fact_nft_sales
    where block_timestamp::date >='2022-03-01' and
    (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
    group by wallet
    order by sales_amount desc
    )
    , selling as (select count(1) as number , nft.purchaser as wallet from solana.fact_nft_sales as nft inner join top20wallets
    on nft.purchaser=top20wallets.wallet
    where nft.block_timestamp::date >='2022-03-01'
    and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
    group by nft.purchaser
    order by number desc)
    , collections as (
    select count(1) as number , token_name from solana.fact_nft_sales as nft inner join top20wallets
    on nft.purchaser=top20wallets.wallet
    inner join solana.dim_nft_metadata as dnft on nft.mint=dnft.mint
    where nft.block_timestamp::date >='2022-03-01'
    and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
    group by token_name
    order by number desc
    )
    ,collectionsovertime as(
    select count(1) as number , nft.block_timestamp::date as nftdate,token_name from solana.fact_nft_sales as nft inner join top20wallets
    on nft.purchaser=top20wallets.wallet
    inner join solana.dim_nft_metadata as dnft on nft.mint=dnft.mint
    where nft.block_timestamp::date>='2022-03-01'
    and (MARKETPLACE='magic eden v1' or MARKETPLACE ='magic eden v2')
    and token_name in ( select token_name from collections)
    group by nftdate,token_name)
    select * from collectionsovertime
    Run a query to Download Data