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;