nitsFLOW Non Whales Top Projects
    Updated 2022-10-20
    with f_ as
    (SELECT DISTINCT buyer as b from flow.core.fact_nft_sales
    where price > 2400),
    s_ as
    (SELECT DISTINCT purchaser as p from solana.core.fact_nft_sales
    where succeeded and sales_amount > 240),
    e_ as
    (SELECT DISTINCT buyer_address as b from ethereum.core.ez_nft_sales
    where price_usd > 2520*100),
    flow_whale as
    (SELECT nft_collection, COUNT(DISTINCT buyer) as popular
    from flow.core.fact_nft_sales
    where buyer not in (SELECT * from f_) and tx_succeeded
    GROUP by 1 )
    SELECT * from flow_whale
    ORDER by 2 desc
    -- UNION ALL
    -- SELECT * FROM flow.core.fact_nft_sales
    limit 10
    Run a query to Download Data