SELECT SWAPPER, COUNT(*) C FROM ( SELECT SWAPPER from solana.defi.fact_swaps where SWAP_TO_MINT = '6sDRYssRXDxmM1sCa4r5vcy9MpUfGHBML4gVGw1Qpump' and BLOCK_TIMESTAMP < '2024-08-13 00:28:54.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER from solana.defi.fact_swaps where SWAP_TO_MINT = '9RxQeMi2MRjiFU2ZfPWirP8M242KMhoyW9SB1UvfVXhu' and BLOCK_TIMESTAMP < '2024-08-12 16:54:51.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER from solana.defi.fact_swaps where SWAP_TO_MINT = '14X4oKT279pBZWGe2E3HNo3QJmyTAtttfMqjmCiBANDA' and BLOCK_TIMESTAMP < '2024-08-12 17:07:29.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER from solana.defi.fact_swaps where SWAP_TO_MINT = '5HYQ4qK7sK1wBXfKSpxnVikCQizrMjhdbzu7o3Zfpump' and BLOCK_TIMESTAMP < '2024-08-12 15:00:15.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER from solana.defi.fact_swaps where SWAP_TO_MINT = 'FMqSsC45H9zAbBb7vUkH718n2k6vG1ynXy5yh1umFNEi' and BLOCK_TIMESTAMP < '2024-08-13 01:08:32.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'rM5LmDKDSQTTj5WDLi6pZaiWYUQEbTQLQcYaypCpump' AND BLOCK_TIMESTAMP < '2024-08-12 12:50:40.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '7daimycUVeZxq4ArSymVBJa1eXhdePRyJG1GJW7q8khT' AND BLOCK_TIMESTAMP < '2024-08-13 00:47:02.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '4xQcLu34JTqhW7GmtPSH8cnUvp9736SncP3dcom2uH1y' AND BLOCK_TIMESTAMP < '2024-08-12 15:24:06.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'EZNvdJM7hjG2knnhAEGS15McUwkpavx8xWDemFufSTbW' AND BLOCK_TIMESTAMP < '2024-08-13 01:25:23.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '7kBJzbScyVfQuKiBtzFKQePLDfWiTLkGGdNKpVGcpump' AND BLOCK_TIMESTAMP < '2024-08-12 16:11:35.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '99MnAFx4UXYobLPQQ9hSsTJDgbkJzThzJx4JckjApump' AND BLOCK_TIMESTAMP < '2024-08-12 13:12:50.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '6gshSm9Lk16tQ8HcccqdjVz6vPFmG6vGqATHbXtKPaMh' AND BLOCK_TIMESTAMP < '2024-08-12 13:39:31.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'EiSAMgRt7a8YHKFaYXgxnepBekgzD1GbpYTeTVLepump' AND BLOCK_TIMESTAMP < '2024-08-12 12:34:18.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'ASuHFNcxoLq5HURKYGwBQ1f4UEGKPFJz64Srxes8pump' AND BLOCK_TIMESTAMP < '2024-08-12 17:25:40.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '5XEa4zhDUy5iaJmSnkmnE1L3t1RuJcrTxmy5gc3Upump' AND BLOCK_TIMESTAMP < '2024-08-13 00:27:21.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '9DV6rEABJcLyr9LZBj33mfxrYw6je62YtmAJ8UCZf4bn' AND BLOCK_TIMESTAMP < '2024-08-13 00:22:39.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'F8t6ZynJ93g8grC3peyU326JQDEvcNiJo347JYDvpump' AND BLOCK_TIMESTAMP < '2024-08-12 12:59:16.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = 'FGitPTNWVqppcaoWKuBG59iqjToWQEWiG9xtLQvRd5Mq' AND BLOCK_TIMESTAMP < '2024-08-12 15:29:11.000' GROUP BY SWAPPER UNION ALL SELECT SWAPPER FROM solana.defi.fact_swaps WHERE SWAP_TO_MINT = '2VLoPasioJHirMDteGVuB3dQm4BvDDobFoRvfo2Wpump' AND BLOCK_TIMESTAMP < '2024-08-12 13:30:23.000' GROUP BY SWAPPER ) GROUP BY SWAPPER ORDER BY C DESC

Query	Creator	Created
sol analyse solana token swaps	77dao-eth	Aug 27, 2024
Getting Started solana swaps	77dao-eth	Aug 10, 2024
fresh-blue solana swaps	77dao-eth	Aug 13, 2024

77dao-eth