madhulika05: Finding Active Buyers
    Updated 2023-11-17
    SELECT ft.BLOCK_NUMBER, (SELECT COUNT(DISTINCT fi.PUBKEY_SCRIPT_ADDRESS)
    FROM bitcoin.core.fact_inputs fi
    WHERE fi.TX_ID = ft.TX_ID) AS ActiveBuyers
    FROM bitcoin.core.fact_transactions ft
    GROUP BY ft.BLOCK_NUMBER, ActiveBuyers
    ORDER BY ActiveBuyers DESC
    LIMIT 10;
    Run a query to Download Data