barbodusage
    Updated 2022-04-14
    with t1 as(select
    purchaser,
    sum(sales_amount) as volume_sale
    from solana.fact_nft_sales
    where marketplace='magic eden v1'
    and block_timestamp between '2022-03-01' and '2022-04-01' and succeeded='TRUE'
    group by 1
    order by 2 desc limit 20)

    select
    date_trunc('day',block_timestamp) as dt,
    purchaser,
    s.mint,
    b.label as nft,
    count(b.label) as usage
    from solana.fact_nft_sales s LEFT OUTER JOIN Solana.dim_labels b ON s.mint = b.address
    where marketplace='magic eden v1'
    and purchaser in (select purchaser from t1)
    and block_timestamp between '2022-03-01' and '2022-04-01' and succeeded='TRUE'
    group by 1,2,3,4 having nft is not null
    --order by 4 desc
    Run a query to Download Data