KingTigerMafia-7mwRZbWallet profit most from NFT
    Updated 2022-06-08
    select mints.purchaser as wallet, sum(sales_amount) as amount_sale, sum(mint_price) as price_mint, amount_sale-price_mint as profit
    from flipside_prod_db.solana.fact_nft_sales sales inner join flipside_prod_db.solana.fact_nft_mints mints on sales.purchaser = mints.purchaser
    where sales.succeeded = 'TRUE' and mints.block_timestamp::date >= '2022-01-01' and mint_currency = 'So11111111111111111111111111111111111111111'
    group by 1
    order BY 4 desc
    limit 10
    Run a query to Download Data