barbodnft
Updated 2022-06-08
9
1
›
with mints as ( select distinct purchaser, mint, mint_price from flipside_prod_db.solana.fact_nft_mints where succeeded = 'TRUE' and mint_currency = 'So11111111111111111111111111111111111111111' and block_timestamp >= '2022-01-01' and purchaser not in ( select address from flipside_prod_db.solana.dim_labels where label_type = 'nft' )), sells as ( select block_timestamp::date as date, mint, sales_amount from flipside_prod_db.solana.fact_nft_sales where block_timestamp >= '2022-01-01' group by 1,2,3 ) select purchaser as Nft_minter, count(m.mint) as total_minted, sum(mint_price) as mint_prices, sum(sales_amount) as amount_sold, (amount_sold - mint_prices ) as total_profit from mints m join sells s on m.mint = s.mint where s.date >= '2022-01-01' group by 1 order by 5 desc limit 10
Run a query to Download Data