flipside

    Daily Flow NFT Sales Group by Users
    mmdrezaDaily Flow NFT Sales Group by Users
    Updated 2022-07-17
    with table1 as (
    SELECT
    buyer,
    COUNT(*) as amt
    FROM flow.core.fact_nft_sales
    GROUP BY 1
    )
    SELECT
    date_trunc('day', block_timestamp) as day,
    CASE WHEN buyer in (SELECT buyer FROM table1 where amt > 25) THEN 'Whale' ELSE 'Normal user' END,
    COUNT(*) as sales
    FROM flow.core.fact_nft_sales
    GROUP BY 1,2
    Run a query to Download Data