chispasTOP 10 ADDRESSES WITH THE BIGGEST AMOUNT OF SWAPS
    Updated 2023-10-03
    SELECT
    DISTINCT signers[0] AS wallet_address,
    COUNT(DISTINCT tx_id) AS num_swaps
    FROM
    solana.core.fact_events
    WHERE
    program_id = 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4'
    AND block_timestamp >= '2023-07-27'
    AND DATE_TRUNC('day', BLOCK_TIMESTAMP) <= current_date
    AND succeeded
    GROUP BY
    wallet_address
    ORDER BY
    num_swaps DESC
    LIMIT
    10;

    Run a query to Download Data