nasdfajskljlazy-black
Updated 2024-08-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with trades as (
select
tx_id
,max(swap_from_amount_usd) as usd
,swap_to_mint as token
,case when token in (
'FL6XicwNJJV4LN6SoxR8qBhj3CVzLT7H6itE82xnPpJq','65Q8EaQjdH1zrAPthXb3uj6RCHwNd6fEr22BW76q648n','8c6cgn1LUjNFpF6LjaKwQVV69bhbUMukYVr3qNvsouF9','GNLEixQ2987RwRqsVmpj7WdaaDvwRo6cdYLu8xZMo4a7','2orbVLVVjQTuPSxdEPkLYNRHe1u5oJ2pjG59yGyKqpyC','3ZdDSbzifsXnd7uZYg79XnQxiQatPsV8SGvFS2634nBw','HgHFe7o9dAaMC9AgEgMcHAEffyF6csG8mdBLzMeQczbe','FPTECJbhciAysiv9VTD9ZNNX1SgY1Ei4kYuQDEsCvPZD','8hhD7BWnckWvEbAnCLFnKinUDzZBMuN3LiXKJTP9xKxh','5keovKMg3viMENFQsC6Z1r69JMe8CYLQM1NnsGvXfCYx','BmaHNyQcABWaJ4Rw1x3ad4fjHSE3Z6efoCP7attpvyZo','4cZpoZg3pPbgUt23zTi9Ty5jFkGP575KtkvsXA4eY5xw','DfdqAFExb59Mfu4KM8KzGfeCZMdWkBSeJgbnWN8nQab1','GcZmiMN1Gphukj3WzDGdzwCoNVeQpt63EaUjviXnmPCP','9S9f2MggHnf9EdKeHJyH8MpPQBnDZV7HvQqjGuYarHfS','4fWWweV3CwC9a7cXm8SLYDXNFZSnMn5gPAHHxjenEefJ','BUnBTQp9ndHHZmCRo9wq8SR6RB3BuavbNC2y8kNqtzYe','6UtpLrkgrquXkyc7DQdm9pn7Wus2UMRAmNpKmpHQ6eJw','Hmu5wMatr3iDTKnMGViuvPACcfGUno9g3ANgFTyMSDZo','2WxKi6wA7FwW4KPKCWLx2brCye1HsbTtuC3iJvgSES42','B9DMrytraYJT7iB3GRRgsngxDGL5kSDSRVH3BeNbWMC4','Eb9BZGusyzCxtJrUqM4rHf9Y5CHM6t3A1nV4EZdDCacR','CpdAChzFf365DcVu64QfVbdWVqGrsZ5X5FMcd1oBSou9','2dDwh7n2Tsjadr4XvPV7gXRChh9kP5ZgXr2LvYnKEJ6r','AowPKT4NHkx4eMax7nS5ZxijwuDfoeedBryLqq6nDZfH','AusTcg8xcfNz6FAz3ZASRy2yW2cZ12f4UxZQKac92YxE','Eb3VvC3ZiL9Tz3GNatcgqoCh32mZ3kmgSNW9aDUG7y5f','HDMA1qpgH3buZEVVxmAHVb1aLESjRzHmsgRDKZFLs2w1','GkaoCmgvX1Q93wH7rgKMCSTidzMEK523kL3hiTW7ntxS','7P5Qh5rMPyE5Cn47aedz93NKyjM83rA47isv43R1jUhA','DChbEmk2Eo3yZZuu8sGb3AXcnNAyBG9VKyqM66MTBZVv','J6cSqDQBmyfHmDJMzvABZarhgeB3k6uZ96YPPRHcQWDd','EkBAzM5mjKRnLTCUgz7T2JYUNy1gkkZpUoUHcaJXYoH7','44EP4AXi1x2u69Q5L6axci1NpWw42dY88HP1FL1cFi4L','BN5wdJ8D2P3eqhe838n2Z591nFbicdDChNDKN9QfdUKq' ,'DhBSoopwAMNQB1H3etvkercdSpkq2X9JZxrFMe6Hwb1B','FArQbF1CZS4gCgVdn1RBmvNwT3RWrcR1QAqytaEhJCkq','63B8TM7jfNQwgnvkCoGrgkZamSMF4Qod6mDaMSMqAL8','Aw2TVf37xsUoRRHY1GWEzhhonmpPDcMWFQpmF9pD3UKT','FabCA9sPrLo4kckfXcvpNYQ2nBtndhnjUSy7otJXMYPM','5eLMc3zq9MffMEPu7qJiTsJn8XVtuLh1L9QHP2Fgi57m','9JnvZUKqrjBQF2E9ivZEXu9uP6P2by9ss2q9858nG2rs','6S2zTzu4E7k6GV4Tazb52FZNE9bjyxFz3KCGKT2WNPRw','Fg4bAiK7uMCR1UCkht2NyxXks5jgnqierVKqWkERXv52','HMDQsL5pv2BHhM12ynryGNGTocu8zTSSyJQMkixLSmjm','E26oe2htH2r9GMhP8tZXMkFrKBvPZYr1zeQ7RBJsh2kX','7RPCR3![]()
![]()
) then 1 else 0 end as rug_token
, swapper
,'buy' as buysell
from solana.defi.ez_dex_swaps
where swap_from_mint = 'So11111111111111111111111111111111111111112'
and swapper in (
'5bgLLXTdUmTAib62Tbt8r5A3dywNYJZge3PnxcsMCXcD','9fJvG8E835mADixyazTEMzmGeVtnKrzidiX6chNcFhgq','HGxCofTxHXrEKQqjtafqeNFSLCLM5tS6VExHSzjuc29r','4fzUTJQycEwHxWCbtXD4PoGyYXMVrgFCWmJrKUhJ28Yn','ZruMg22W2fYMspWTkCoeoeTY4XVE8b1mtdgcXmg7asx','A6UMtEhfgL7RTEr2rdQdYWA6c3Gk9zA77r1pgCoXAkMf','6VE1TeyTgPVcxWVy3eGmMwvFPG8KP5YSUpxzw8YQY3L2','ErSJhqUofpJytuyR3KTjZubGfTA1FMeUNBYBRTrvoz5f','AycwAnsdx8wGejoCsPwcFMZYbGU4dtRs3iqcb7Czzv7J','BanQcotdtRnVLvbNPzjzs3yHPHqUJV1tiCqyUCy138oc','ByyR2pT6X6kiLaKYFT9vp3cb8Wqa2ALEAeuwiWEdK2oW','72hqgcYZNHYHFVX7Vn7nBPM3Bq4zFXxqW9htNQRYZANC','9rFA3sr2ngV4iyRtc6cQg56sabFkL5iMdyjGEppxnVxT','ES11RPXofT7wQUa8jAhcwZHNMCeScdBosFxZVhXpc3qF','F3RE9Tp8NT45cZVEsE4yxtadEPm3e37FqJGbbymnRBX1','DxaPBKGcrZVd8wz25fgbbZHxov9u2YV7UXPHRJ3nYHUw','HUQnRwf1E4HuXBPo5cPA6SDnfJ54hEDNMnLqHCwjbAKg','AwxbzLcQQLERxLarTRudxKfJzDuNzmzKkV6mHgXSpWAa','J8UqPbbeQGfKx5WbW2n82oYbP2kLMfTyoYXHNBr9FCz4','72PshFyefotyEQkJX9AxXRcQcD9PcDfpevqMju1wrkr9','F2jB3CGmPazKLs8wzcXLvy2ESCFauxUjX2uwZzezu4UZ','53du61Ld23EBUCKkFKAhdfMAYLP6GEeEqfmEgCfeTKHU','ALRFpmeEkFxUuKXjFbNKvzz3MLAvEE3maKupJPDqRFUv','Fe8W9RRpLASRXcixfhhGByfoPmESoyD8cZQCA5xpnv3w','2JGpeYVVQs3i2VEbzqQu2QJuHL1aT9DMTrg8V1rwQNoT','6nGZzPfzxrkXcH9y7pjHGPDdMrMpHQmmuoTXs9HefDCA','FnPZr9AQo4zFad3XDZinHdZaqms7VZU1bWDj81QrVxXv','3vUFswhFpU3fmwFEMZuruxCvB2gT9SvxUqAE7Lt4789L','65K7FED5qfVe9bsH3demRaTnfo5Lhq7D3uy56AE1sSR9','WQMPqwFfWw6s9yr4mx6AJqsDT5V8VndKQcokZJKNmGK','EXD57Zin2tjfzwEEyLfJiTYTV9adgKNcYejoZfgDGJtL','HstwUH5akEo5rC9rSinC7EZRCkY9QcsayDy4aPfpyTSy','2RzQDjCxZsnqTCgVa7JYzpqqAQuiR6CG7SJEJYKniuRe','D66kKLCkTsB8Lb2dm9Yx1Zbn73G1imURj8qEdbYvij3D','DrA1QiqCMofGWtkAo3C2UjPxrAyLASoHFXtBWbzYcPmi','8T2d2WAwVpxMZqwmQAWh5ouRtF2Ka2Bixy6XtAaxCzUq','Bog8Hqw36UbbuSWtiL21gfRrp4F9xahr6euHmRj7dBHs','4bhfPNNBvQF1z7fBuKA28TyG3bTqftqvmw12jVAKM3Uk','5EKbhgF5baPrs97Qmuyj7oA9FR1uRxDL91HuKK6trmYW','J2CRXvGPWngT9ACK4wTMzsK2LkwsevigECtEiD3Rjuph','3A8Vu8az42wgi2gkckqxfvTzyfiVzGRpsQp3MqVX9GVU','7eLaYrHbKqZ9QCMJ5JXA6bwR9hzAoFNq6j9VKypVEmsD','DZURzBiSpxFiFKhokAxtC9gkZaTi7KieRmJfF3mXuETF','3e17nD68aahxR5gTU8FnBkX2LCvLhtxti7kiQTda7U5Q','3tftySE5iVDUrtVbRyd6TxFcXHnd9LTgfu51fUXthHTi','4Sy4qGaKv6A3EJHY8gjZofKL9wo6u4aUFvWHVfSoTieh','3871moksLPB9pE![]()
![]()
,'2vqFS8o6QfvaXrDyy8PmDU16ZdaLLMSrzjkjFYJdqtFi','8NwijC4rUFgfvAaB1CrcYcRvHGP2x5XtUoKPqAeJUX8p','8dHgcGmkEYZudijkdcjpJe7S9XCpxZv99aHr8SEuujQT','3h8XtqV4AqvzTjXgaoomvVByVT7LGaw5vNNk7wXpjCLA','AnypCvjauYtCtMTqPnAo19jRY74i6KF8TkYwvbP7uGgd','3na3VZyP1DhFD6dTu8yABP35gi7xf9ahhRmLsNyAS28E','CLWWjUBZ2TcQSirxx8kgEPSk4BfG3Vuhd79Y7sJgqTHF','3TkFBeNriFiVjqbuszuyu3VR6KenzuPjVRBSmHQn2T7e','G4hgFPPaVQcYQAvfXJiK7zrJUj7EQaYz15R8xBCnPaT9','487rJ2XFwM64drtUpijjgxqy7pWAW1tXh6rRco9yAr9V','7rh7F4iGvryMfrAJMpRrSCEJivnzJAZXs3ATAPrsTBhY','6pG1fHYmjnTwBQ2PrPekMay9krVYxWo4373m7qHrASaR','6Ts5uXhbhnKVH4X1Xupqip4tWQPZ5Jcr2W8i1krqNXk','F2qrmHXLjh5c66PQuLoLwuGeLQE985Le2tzHnuarn7qG','86kZxoDGj6GWtikC7AgbsPHixq8CrhqYoUzoYU5pJtp3','vh7hco4XuKKAEHzaEvdawaakVpje6FRSsh3F2duW8rx','GXQ41gnL9cQHJtrgyXUb2mSJeSTXmLdNKg73S1SraFiF','D6cpPqWLbDQSUTJFX98NNNAWQ2LZSmccNNcDpNMY1xiB','HKoNjnF69i8eTM2xPs9ZaPoVP34v7cTW8KmjUfNydqoc','ECTpppm484rAHmxPbrYG56V5fobgfdFh5NvByLdqaS86','CHh9WAzKmuVJf1PTEsbiEuZFqeC6LBiPfgfkz2qPmpVZ','AFmQBnGqoKeJa5QjPAZcChb6SocyXjoQU8NCyopaquma','76AVd8y5v8WqCmkPTU6Y4xBwvvn7UWBLzhfVvRbNmCWL','6xCwMtftrXFuLu9ioRfWzCDnGiFdQXscUfEBNTJCVp2C','5xHqPjFsnb6BS6j4cU99zsnZaP7nCfMRtfaiGBSPc9p8','Dha8eaLXgg6y3uPYp18tQZ84vCrPs7sx9mpH4dVCbVyJ','8tBmTiyQw4prEr5DELzNiGnMZkWH1X7ThbfcYaE2JRtt','FcX6BFdMKJQKF4iEVMays1xGxMLtWWFaWM51m5jvcmfS','HZsqdwR5tR5NrR7PcMraB27oeCh24eiFZYyugBhK1nP8','1KuBorUH8GU6edj6JCevvGAnp6c8E6ngCDkkw6CHRAd','7a8sn2yyvnipLHEmPQnDbwTs1HEv3iGZxP3rQpZVbB3G','BmXDFSKE2bNwpgHYL2rxrozJKZth7qTcMWurcFeyux8X','7UUSsXq2S2xMJrKBevohVg2B5bhFVsrLnycQdKfvwv6B','3yWDpArS5wWZWwyWBQXpMmRrDgHKsciwUYuDeb3VTcRo','3RTCwBPfqsRF3uudAwFqSp3BoRBQ8vX1XqZCWi1xsBMF','4KRXjQF1VT5v2jCYPbUdgd9HKzG4yHAUN7P4KZnH1AjU','46BuAdNpj7XAzkv6XbDiKZeSAuCg7zybuNdJGs68MNcY','2HiARcVYHEFz3Nxy1nYddtM9hVaYLuCQRbMtncSyi1qA','7LyikYYrkDU8T2vQyRGE8fQ7G8y1izmVNADDG9Kyn7X2','e97pAvDqz3QkCUys82Qb9wToUcyfRjKFfZLqcdjPBo1','9SexiJ4nRUUkE4GqPeHVMmJSK7kRdLAkyX7cxsq7EeW','BLDBngoHczcEiZdsBQQ9sjRXPLGBadsZ7tQpjNBT9HjN','BgcbYg8jiMYAz1xQPCfWNkBV2GjvscgFekXjP2zHLzNP','BUthi4izu6UR91FL4xsYhrvaEu8uXWrzDkxBN3yicHdi','5DNaX74vtFKzDdwmyT8PtZgP5d9aq5MFJyeAJq6vS5L','nm5Ao2TNDUu6MBvgbh2bAv7obeSGPNrpmztho1KcgeH','HE8wsKAS6f9NCsAqM2![]()
![]()
,'AgjVJ7Fr3yNiySv8zziFErBypNQbmdk1o9DqfuK5CfNw','CjhBGGWVpzkUFDd85cVzGLstyfrkwNmFV35couSxybU3','C5M1E4vzdLKL3ofEf4avWTT2njdsT1JcvNkU5TbtsDNn','CGgtLA362B7kYc6h2wyef71aqFdmhbgCkhWwceFSdygk','3k8J4frbW3VXn2WPLL23y3yWu1wD1N5BfwBtN1yG2Rya','GwTEJnUKxpczpskeyjbHktZ4pwxHepkQarXYEzp3sY8R','83YAsz4zguHJWhsVZiHFQL6RKZkz45Jo9b6svKdCohVK','GwfW8BxDYj1vFBgC8Jwit1MCKFK7SySVuisa6Sh7VRcG','Eas3q6NMYRpz9z9Q2deXtvr6AsEAFKwFXpQZgqR2uhVu','CFmFZvid2Av7NpZ2vEX5KJjoRHutbGQX5advWZfdnM3R','4B6DC1F7CfaHCx53cR7SAC8z7fB83dEe26XMGRz8LHTP','9FrcJioeCHHQKV1wJv6yceA3dnY2wg8C21f8W2ZcDMie','9sgE6RXaaxtEX3W15Y9Bo1KrN4N9BcMa5uq4TfWeK5SN','HFn56zys8GU33Hc8Hyj6w6jcASd9SusLhyq8JN1pTiNp','47iYpAvxNegodLKwSWBAviV2HQgUVsf6rMRZNNsYdwNP','HcwwSmJXevNLtFGE8e7dKD8k6iRZh6eutfSFTpdQvnDi','6GX2McyqT5k2oTf7QbL6LvbfuZKqXh4s1Mhop54NaUrH','CapWjfDxCMFbRr5Ex3dgGqBWTYVVxmCUQBBmfCwrFXuo','4CvdPPSdF8wjuitcqEheMbS8JuvnT2e9cZWvL1xRFRmj','3XMbCNLqJLvd18WVankQXwZbPzgjntUsAdhGRNA87oM7','GBYYH44xt2dGRassAfN2oZ5CgC6bwPrYuNoWtPaXwk8w','ChAVCfeBRAMaCsFpiQcmCmLxkVRFUijaNotN9DGLH3c3','76GsgRppv2271XoMbyLQFciZN9duSGvPXBgm4K31FHWZ','7ZEVWpoHhxbsZTpdDbuDfG6VRhsacCZvjsMmUoM1xnDn','9A7GTMVZBp9v1JPpq5rTf6oCyxfRuTvUyY3hNABBmgo2','B3EUKhv4KL6NZBAaN4MSXgjNRg6y6pZh3YFLpPhFYKTA','CJqMBh3C83CPmHaYAABLm6P29aCezEqmo9DkjtJiBf2','6exx9xjxSyKZ9vhgi5sVQzPFrHtfYj9wB86HHPJKMed1','5Kie4n5RiPZw1dQ7diYyvM17Pj9RvzcmzaZoUVGLGYHa','AodvD96qRQ7LjDwhne9uFHhiEYU6yvbvXPMG82hKHo8','EZfbWXLFCAKjoZMZCiqXYELrttrRihAgp7Wrnkg8oGs8','BY3u5rsv53Xf26LSyP9o7nNreySULjao7bkHhkhvX5YT','EX3xJueW5w5XLqQczJDfuv7hXurHX86oUrmbUNFtyCUz','CtrsUsxrnDjxoZkBrYdg5qKsBxgstp4HVQJ7qnBeYZRn','6NJGaJCwBu6bW2kP2ZGMVZxWik1PhmRfJQkzVpsqFpk','8LWLHECHWd1woYCcHKDaJEBmFT1wGwc6foapUSPzfxAV','96vYstabEG5U5CVsrZiyh6kp3SJSbrNg4ve8NsdCuV5H','6LHzr9UxhCYmwgAytqvr23YadeiXAefPvqtbdggXa7gw','88UWk4m9w2EDzCuDeU7uHw9iAoYGqw1rZD498XYcHgNT','9x94jTpyiNumSqTf9VMUpR6YedJ85RMdp9V55mtkWaYV','61HGShMmjLyjfMiALGSNPfJwV5qso7eEXokFcZWiFyNw','6xvRhLPFr874Yq6moqTwtmsMxw8mW9NCKtNUJUgnpf6c','5vFthEfwNQszvQ8vMykQZW6kJnq1apxaPAaxcabpxhz','FdKTFsijDJGjaiRA7AmKTRiXTsTdgRUoWs6SbpKuTPJk','DMJy4iUhC38NeWWL28idsVN9nBSzGj5ssdtX6aTUaSPk','94r3xySJczDmBtRj4nHFi6yApKHL4ZczgmB5mJjDGMRH','AHAtPTPf8ACY1zA![]()
![]()
,'6tUnFrf1XfuNCmJKkBsBN68naT84dqMupwJMq8fZz2Vr','68LKESLfCWfHfuYHdL5WeFhnQRraTAcWPywSzZFpcVEA','3LegyiDwi8UJPzq79L8ccMdEWRiFhuhxNWa73L6WpE21','CqRs6TwgatKYqLEftNc7CHSQA69F1Q2azc67XC93LGr8','5d3atCeMFaT9cQCJoYNZBRvwvbAcbGys13WW55d5qD4j','6qWvy8xy19ihEDGq5tbjZQf6HSzk7JDCtkcPa6bcsAYg','X266AEJrAX7dHVHCt5gjb84uPKk6DvqVmhpUu65SUyQ','E89PQ7RRUkJnT95vk5nzdMm96TY7CX11gVUcXyeZrS5r','H87TZRXUFLMSzvxAcPpYY9GgkxN23KYgbzAkWexAM7G1','HKEy24LNvw1BskCjFbx3kFqXKzMh5EbQaaCNtJkykZqE','7FysMUsHPkC4mDhPzQ71zmunj3RiLA7GoqHUwDcFVvCM','2q86vzr9EFvaHvxRukU2r1gahMtvgonDs76ZFFuievib','6NVkQtwk7peUXheZPY2uXLpDQV9JbtF9f4yjTvkhMSdA','34J8JQVZnDBHZXTi4gyCbZqkxranBYMTNvecSkQJMoFE','Qddd6adcyr4YnzZ9Uu3ecTWj5kASdc2PzLULG31PfCL','9HN9j9gcwCWkNsa9yLfcMaiyuitVrWPpRb4THdNyytet','JEEz7Lgs3LWy2RMCx2AYrzA61VYwNjWxvRmygVX4mzd3','AUcimjR2gPaKGfWuhrkUYdwE2krx4pG1WQ33m3DTebnb','7vmnJSjBuHtYpSoEWJEYDCBshFpRddCiKnYf5yc3RtRE','AkY5ZZhtmHRdoz9AWstuvi73VcT2pWpZmWdHts6BNNTD','3czcTqN1syFJyCT1r2ShDs51dPLFR4NR9kvN44s8TYVF','95yW2ioVhfBAhN2GUi28kpsNUZVKxcJzrajRxwESAXmh','CfsVVNS3mtVLymJHmUcwJada7BwMnN7Whc5FDbkrm1To','G4d9gFqBU5JUrB3dKREG7Db4ThfPzSGYLmSV9DQ3XqLa','FMpGkhrKA88DsfPCBf1e1bv4Z95wVPCKW1gxDV3jL6sg','76TYT9UdDP3hVxLxYFLgb5djvZcGA5XX9hXt46jJ5JvL','4UiLvwzJReV1xCq4sYgrbYXZAYHQGz9QgNEx78QuzLkD','HHqSM9vwPCAozUvynFRu3AnCmtVa1G2VTiVKEFwx2rk2','Edw7c2KW3mdPPZEcDM8PGSq75tcKo9DjLNscEQDGXxu8','7P1q77JA5euN91fCeghLXFCWYYTGLJ6prRZpo3XcJQNY','EgVUEBkw8aUeyrHWjK9swvvigwyuhD6jBg9QnzGmN7Ff','Bd2TPHMRkLtacrAWvPiydRyY2m9BwjZp3neBTkktVFzV','Doz6muFALF5QNnjsHGv4erQKYf5yoh1qnjYdUytoAJhW','CqbuzDrP9vRRpEPXg13Zo12zv1qhXtqqLbfLrXsN8GCr','7JW6Fp7MsQNU5DsQYcE8JPk7crgEJNgSgaCBnUPfSQdB','7rzg1TdWPonJmHN4pV28dTYMEghTk4R3nPZ4xcubyuKT','2SjBZceBFxdMcTQAGJdXQAJmw5pVro35ZukMKtqzAZHo','4GPqP4YhpVnbyhLB7pBmMMmrNToZSLcei5FT82y2JEyz','8v7sStMcWXwQJfNvYwvT8E7oTzeCrMdBsEP93TwFzLK4','AiHn42gedJotcgiQkyxQPhXnPDru5PR8dosEdPJeQGjR','G3BbWERrhdHz6hr6yH1y3qwQA7qmMN1KJmWoWmijSoeY','Csvt8M22g3ESquSK83yXZ82zctnNAENqCGDZDFWKTNCV','FjRgShhJSy4YbXxo5rtpseMHs2H99CRJYWJGEvJARz7D','FPRoJC1HxYFzUB4axu8xSJ4my3Xh2LEuWAXancHPzc9N','9uvHtgBzuVx6JWWQjxuYYeHWMYozwLu4UtdjMVZJE8Jm','Hi1tBkV8atN4ha4G5T7qu3tytDqECH3kwqiXhd2Xq2sZ','8C9ikqtecZM8v![]()
![]()
,'6ufcnrbQbgsibAirv9LgA8Kx4Keod8TErBtwbDWmaV2J','DEpeZkrPTpz4u9HjxDkQrAWrrDMkZSMtyj8jRDJoanZe','A8eBFkSKRky3sFrZShXxmWGv3nysUeB8gqipDafsE6QS','DoHDfMkMvF3Rax6SzUjvFNxLYxinDmL4YGcoTftvujYa','iuPdXqv7sXaqngdUipJcGex3u8M3vRCnsjLSuUFKsxB','DpkYBGL1srE3YyeEnMyuFyo4o6NTY2jBPXyNvjyqFazj','CpsNbYVi2Dah4iXyjEckadn8kwPUrvQnvnSrsVKYJooG','EjrUN62yVmA6ZyHQUKnufndbvEvbZzgxYccbAA8e2SGw','7MhbNwPmdqfEZBnaGKh1bAMzLvAtuGp6RjxfRWGNpfjA','3L7hntEtPNjCe94duQV2vBPB5n7ewCmNT2uowgZkHuaE','8wUG8dJFxH1K929c77nsqwteFanz4bfMSWuUBuvNKYZj','1QMYMmBxi5ZVXv7B2DYstDt7EwYvbTHddWf5MqiK8EC','EcQyNtJFveR9DwXUANxyPpFy1ersFF2o9ERkxoxEhi84','FdPYDrWTqeSUVxBWsaYdvs6JLusCsn5QpB7ifozQbcp3','9QAWz7A3HzXZTFqwP8hMMH6rcqDKChNbWcK2KmGdU4rN','4ukVDP9rQuXbXNSPP4K4GpjANHDyGJnh9SC8QHxYdcze','5ZYmdKPn7ppbNDCvWuXoo55SvF8akJu6K5kwQwtoizEx','GRS8iA7DmEy82R9AtKG811j3EiojRoVpfyE2Lu3RrQik','7qgzWzdrzgSegPZihoPR6Nkausu4rJCK4DGgeVDviiCf','BC4jAnsmWoBWSddhUBpTDmoJubeRKRPHazotfZLa8KBu','3aYt55r8sECCZ9qaTLGSbKaNe5XCi4Ljf1XQiMHKKeBD','CJBV9WYmg6qNA3xXcmQWq8v87WAopAv6UpxXYRtSSa3c','2cZLnk8kVnBt3Y1hPUTXtaTKX6RUr949b6QVdG8qZT7z','BwwXFupxFK4nUYnRkojFwEhkePRxMfueuuxKeyHAadWa','22nwxcYsE7yvYib199GsGXF6dxSYY76zwC6ndqRTGpJL','HUfqYvZo8E6Mo255h3k1Z1iFYi2okD9K9QzmWAMtt5uQ','DcvoJTi9AoH8jGH2Aowh7VjEYTN7rrgp4vzmX1VbN6Ux','GtS8yPt5NVwHk9zpwYTDTtAGU1RpWG8dkgfi8nXdn6Ez','5Qb9xUY5wAvKF527feDFsBm8zmhhQWArYnoVfjfXLhAy','E2AQxWukgaYgCcKmCrTfvaaH7j7KfeKe6BDbsS6qNhUo','HcPumjExP9jdUTe4EqGpMxEnugrBgiJYPmzBs36LrpPK','J5bvbdF8xKr5iMKkG39Tczggc4w1WChEPCiCsAs6E4oq','DSvChamTDPxh32CC33fyXd27P8pN7SNLNDcfigEaL25J','4urdb3Qo5MbiXUXZs3AnyMtuxxGULjsAjztkS1cDdUx9','FwiYAjHmzpH2twsMxTnkj4WDPrXFNYqTQMn8soTMYGGB','37SggoNcsoKEeXKj4qHMGAqv7J1bXG9G1gVPujN7kKL8','6YsHAZ7P62gAoB9zCt7bYJnVmfJ5z7yP22LcgeUEKfvC','9cUsVPkz525XDprfH5QcpLm2HGMbHHLxkuMyTyX6Mros','E77yVuarZNN8bCDixCujk9oNd8fQrjeALf8U72i7hspv','DLUpsPPemZvCcE8kKDjUFKN8oDPkUKoeGHC7VwbNp782','FHMD1oJ8E99GSJUsxVA5y8ZXBNw8ExZaL3tn5MG6Vdj8','3YWRSMMredragnT6zSGivpaGFEYBsKRbYyEifYjN62LY','42iDxxqrsXAvc6dVQVcqnexCpqTzneA1ZXXENZtYrMSZ','8MqH3yz8tmhHMMr8au7XYQLA2cgLCmeqA9kEnVNbmUpg','9j1jKoCXxTsLuvUeGLgbmyXVyyte4h8ZZrSo5a4cRNbL','8kCBhDfi1Hm6Mrk6FtLmivN9e17hn9bw7gXYJSQs1B1H','44QXTgKYyFwsF![]()
![]()
,'EugegQkuRECxT4hbuct5bHsstsbUoUH1wFBScusswWKi','U19hoQUxpjnx5Di3CAV6DfdpYrMKPogFE9bkpC8yjGE','AZZambg6tVK3LcECahzLU53L5xCHmp1jgPVsPzobQBM6','FL4SFiESsjqPj9Eiy1bzoESLbWf1TNztNFzPKNLbmm8W','4fMqmvcVqfULABZ7jEyMAcyqhSQHEb9TPGYtNVM5ZRtd','AZqXY23HjUAxJwTW9Us5ktwhvRQcNGfuSx27vwXoJ6sr','7ri9BG5CcYMF8Wbnj2yu3EaRnYgoTjG4BViaCZcsBTTH','23oBpeRPzN7YBr4vYVJ4Kp5vqUfim2c1wgWdQaVvFZXR','HvxEGXhAgp3YKnYxNe6uadMfN3rXDjAKZLik3rn5z25H','3Wc5j9Wu3VQB5oT5e77a7VnygpHwfRDwzpmiPVChPbo6','2kdeSBpHkuSK2aZhz9Y5DQQoGUHhgtZUH8DVZvYdu1o5','cVvA5rtFbRWFVGtFomZMBszZ4UuZiYhVDiBJGWUVUur','EbaMFtoaoYYg3uXuBrXy8PxZzVyqoKS1GYgd7677itit','CNREnhJ9fgyRMeyhttU1injyzPdpfNqeCqA4yaazcBK5','6wLD3xKXUVFkdvQRV3LTwfM7VfhMKDD4MT3KdxTM438n','9jWaVXMdzkUauB7PFYHeiggL6dSMd4XStGvjGFzs43x3','f5VcVw8bNJXciqaiiVF8W8uNqtGAxEFabaoFUYxXnS3','AsRDYX8yy9uPMyYqkdQvrNDBw2y2JFhcxXqfLoK1StVS','4xL5Dpkza3R5hNGQh2icqzsUXDsK9sjSicTzRcpMQ2B4','BA7K4T7jUMuNGsauKvZJtJ2iyZEeN9LBty73GinEjNq','6PZkAbFEva5qU8Lp5ifvuerG5fTG1A27j4achBobCRf8','38RSwPPKgJ3G5jJzhgGRYpXVfib4KxGQjss5xCBe4Qqy','48CzZhQjuvXDzSXDUGs3cYMAxvWNFyxET7yZarNmxyhf','4WvkoKutry9Qv7n7mTdm2Z9ePV48VLqm85TaNQR44EcG','FsPgLrYBZSmAbse4NRDdA9tYSZ9Tw8DiiuVGi6pDGRZc','58uv64goj5EqPU62mbKQgmFRbM1NMoUfDYbB6P5kS2Ww','BHf3M3apxdXvwvAHsSzgwRGXmhgzNKuXRNxFuANWYszY','9hbeyjzPLtYjfSDETfoCXv4YguU9mBCmAQsRGLeMhdjg','BCE8aaAScynmitJP5yjP1cqPFXcwj2M2SqZ7q74PN55s','7H9GQKVm4gjKD7oiKMH7QFnGdnZiNUoazbQLmqwTfq4G','3Yo37E5PkLPoNybat3jDVsXgjpsCRBchp3uniwitxYxZ','4GkTN4kGMBcf9MCZQ2m5Zp8iiJxrGfVHtoe7dzuFsBCC','2Ki95Xko21iV9WNWxPyXrxWYpVr6fQjBFEtwQMUcMbRF','5fd3pouPVGRi3fyBk1FTPNF8Zie4xjYhvi2NVzdzcNBP','kPnpHjckp9r77rbZpHrJHdM4fmQ18VeyohyvCYjxTqh','8v1qKg8zZpXLG2mGk1kuPMnsi4X3khnAAnE52XsivXW9','Cso2p8JXLCHjjce7ABm8vLHGJEqHo1QRwym5BxAMdfCq','C93GrFrhrAmBWEWCaSNF5XJ5C8zEe6LUYDFM6v2ad47L','JD3DGqMmiNoxaSKJ6XK8tUXDxFoLosyTayauKwF39JJb','7Z8XL1DUyyXtsEs32G8KNuf938e5CeMJZU21kw1oyZmb','Fzss2fZi2qkvFyQu8tv9xqMPLSUXCFaigfpHU81NN24v','Cp1G8wELCof56YNkFsdxXoWRwDm6V5NA3SEiSbKvUQSi','4ekJw2fBx6W2jVEpgDd6gbPpQptPh7s4CCK6NgZ1coEp','D5E6kRQeoWGXr33utoanuu8FuLE2HiKVgcSSAR418avM','Fu6XKczrnw4TVm78Ctm8vwRSBK2TfyGFsh6jeCSH4ayP','5AEs4YEJQhx4cBsDDX8YUt6sdZ2JPemtoFvzd8RJ3Ldx','GNcYVjpSz1hMf5qQ![]()
![]()
,'J2HqRPganF9uRYjZ5ebxbDpkMiSAXLcZUWPx8R5yaK46','52LsbjftQyNS5b2wmQ2Aq7SgyayfdhgrPw2veLSUoV7Q','9CDXDNxsvEKfeeJxoicq4uE1PgaHoYErq6UJ6nPCnztx','CjNuLYHBM7qWXR96qivjHWh7CN2uaVxcFLbrLKq1BBnw','2YG5TAY6988a1WhBHWCyVSv3EB9zn36XEkhiTEfveCvU','E1sB9QYYfDmK92eCnrNjNw6DtcN7GTX1f53zNugha6t1','9QDbymrmgq3cQqCW2LVcWynMr6A6C22jhGU3LaSkT7Qa','Gb9qM1TFjpL7RrmmEie27G1C98LaVnmHYdferEpU8XeC','913aA9reQbMygtJn5PNvv2LFGGQtcfyFSUmfZEzQn6bX','Dsph8vEJ1ZfQcM6WRmnRezbeRpEuUpbAFaE4ZQbwdpb8','4KL9Jkp72fBDpWsBfG5ax45mc7qWfwPKRWwxUmz3KZXZ','3U5EiZA2SjPFxB3h7ok17eeDJ7PQnFMXkRes1nbcLUCP','Grb2P9WfQ7wpyb37gSfCxGM46B246GuE9mWe1Fy8qQL','9wS4rhHDJxkmza9Wj9bPvReVvPa1RZhhAQ2E35rBZxbS','E7kogdfM4y6b327objLYB3xvsrwiTfFBpGmEaJH6B3n1','8F7KDQvpezWeUUEdHmWSodBcajPgwecQ9dUqT46froPc','6yWWSJqRDWYck4eJhwz6GA7vUgt3Fue7GpikpnxTh6bE','Gyr3vpvQhmmRfKYkCBLrtcKqcNd4evTWAhu6W1y8TTaY','9TqLxqukWZCfhzAoWwaSTbSCTumYDSFH6V5vgsET7dgG','B65xgzAaqxbidArhnVgnXdCCPh1h7fqS9NQWm2VPigP','3fgYxEFymrDS5RHqjUNbkYdqrUVptE2zReKX6E9Dnp3U','51ZLMJEWQE8n7gTVijnDzUf4yXUkFGTeTQ7VM3p1Wz86','HNh1RFXrpkJDucCUrvYaN3NuJtnhCURgCrzaVGBMmeDp','HC6794xfLCoygPKuBRNqn7s5xxmNsu7sdYHvh4hoxnY2','HYwA3HSuDPk3S1tPN1wAkJfFofn2vPrGvUWuaw2tSD19','5zV9UEritStEc1cY3Btu5RMApfmbbrLTQjfjJnYYCa4k','7qna3nsBJpeWvd43d2Y6D2h9KjhEA5u4apt5spxSREGz','8V9rxSr89dsLQ8vUMeZW81mxdstH9io13EhbrGdwYsPG','4mmLu3VBRsT5RY85qKtouaC6YBJLZ2piGSZZcUuxjcBY','BjwAVcWCu2f6NWxdvHtojmuLL5rDb9qyrkxgmghSY55p','EUBk1vKepDHEZ7YXq5ugAzRLb2CKtw9a4jFm5x4hRyrS','4iNn53G8JfrGKTZVT1Mmk7D8zPVHRPpst2nNvi78vx1j','BQjrCjvtchkT3j4XNs4DqstQQ8oyFmESgTD8XnSrukJC','D5aSeNUYx8vTy1vmsx4dTDF5ENJ3PWLakfGxBLQoYk8e','9gvHnRCJtqiTSUjGw9R3YFkNvcUj8kaQxsdYZaqwQqLs','HQn7PnRc15u9ui4yn2UJ2WPXj3Z89mEyBsMT2ThLfN6g','6zX3wCt5T6ZaapxtT5xAJqPvYVJxhKhF2q6ss6yrU3rk','ZJ1mFimpySYXkkTH28oXwhQDD9aDz4amxfEJV7xWtor','9Hyj5wYyU17tpBTXZpY9XNJdyHe3RkWL34dbk3Ja1dR9','8L7v3PAqAWkHmpSzxneJHTw6RUCYogwxsN4t2KEijEtX','C9N12DEZZcAG3FZFUqY44H9jLzQRgsAczUnZF1zmX9eo','94QEkEJezTT52ZFgxttPmmNcyGRVNoVCKVukU5GPD2uB','H5Yo3sGQPrgtfXPKaFR4vhBxon7865prhFcw2FxwkTH3','5iiPe8H5HsDZPnGgqbYg4uPwVcoMxazzeDC1DWgDdjF7','AHxo74UPYnD1fuaHNAFB3tx6PyMFWe5c9BqSxvMRmefa','EQhmLqrMqDPDxBvytdnLsT9LtYZPH5eHabmvtYMGQhX9','83nH9PBUUUTdzK![]()
![]()
)
and block_timestamp between '2024-07-01' and '2024-08-01'
GROUP BY tx_id, swap_to_mint, swapper --remove duplicates, sometimes jupiter->raydium shows as 2 rows in dex.swaps
UNION
select
tx_id
,max(swap_to_amount_usd) as usd
,swap_from_mint as token
,case when token in (
'FL6XicwNJJV4LN6SoxR8qBhj3CVzLT7H6itE82xnPpJq','65Q8EaQjdH1zrAPthXb3uj6RCHwNd6fEr22BW76q648n','8c6cgn1LUjNFpF6LjaKwQVV69bhbUMukYVr3qNvsouF9','GNLEixQ2987RwRqsVmpj7WdaaDvwRo6cdYLu8xZMo4a7','2orbVLVVjQTuPSxdEPkLYNRHe1u5oJ2pjG59yGyKqpyC','3ZdDSbzifsXnd7uZYg79XnQxiQatPsV8SGvFS2634nBw','HgHFe7o9dAaMC9AgEgMcHAEffyF6csG8mdBLzMeQczbe','FPTECJbhciAysiv9VTD9ZNNX1SgY1Ei4kYuQDEsCvPZD','8hhD7BWnckWvEbAnCLFnKinUDzZBMuN3LiXKJTP9xKxh','5keovKMg3viMENFQsC6Z1r69JMe8CYLQM1NnsGvXfCYx','BmaHNyQcABWaJ4Rw1x3ad4fjHSE3Z6efoCP7attpvyZo','4cZpoZg3pPbgUt23zTi9Ty5jFkGP575KtkvsXA4eY5xw','DfdqAFExb59Mfu4KM8KzGfeCZMdWkBSeJgbnWN8nQab1','GcZmiMN1Gphukj3WzDGdzwCoNVeQpt63EaUjviXnmPCP','9S9f2MggHnf9EdKeHJyH8MpPQBnDZV7HvQqjGuYarHfS','4fWWweV3CwC9a7cXm8SLYDXNFZSnMn5gPAHHxjenEefJ','BUnBTQp9ndHHZmCRo9wq8SR6RB3BuavbNC2y8kNqtzYe','6UtpLrkgrquXkyc7DQdm9pn7Wus2UMRAmNpKmpHQ6eJw','Hmu5wMatr3iDTKnMGViuvPACcfGUno9g3ANgFTyMSDZo','2WxKi6wA7FwW4KPKCWLx2brCye1HsbTtuC3iJvgSES42','B9DMrytraYJT7iB3GRRgsngxDGL5kSDSRVH3BeNbWMC4','Eb9BZGusyzCxtJrUqM4rHf9Y5CHM6t3A1nV4EZdDCacR','CpdAChzFf365DcVu64QfVbdWVqGrsZ5X5FMcd1oBSou9','2dDwh7n2Tsjadr4XvPV7gXRChh9kP5ZgXr2LvYnKEJ6r','AowPKT4NHkx4eMax7nS5ZxijwuDfoeedBryLqq6nDZfH','AusTcg8xcfNz6FAz3ZASRy2yW2cZ12f4UxZQKac92YxE','Eb3VvC3ZiL9Tz3GNatcgqoCh32mZ3kmgSNW9aDUG7y5f','HDMA1qpgH3buZEVVxmAHVb1aLESjRzHmsgRDKZFLs2w1','GkaoCmgvX1Q93wH7rgKMCSTidzMEK523kL3hiTW7ntxS','7P5Qh5rMPyE5Cn47aedz93NKyjM83rA47isv43R1jUhA','DChbEmk2Eo3yZZuu8sGb3AXcnNAyBG9VKyqM66MTBZVv','J6cSqDQBmyfHmDJMzvABZarhgeB3k6uZ96YPPRHcQWDd','EkBAzM5mjKRnLTCUgz7T2JYUNy1gkkZpUoUHcaJXYoH7','44EP4AXi1x2u69Q5L6axci1NpWw42dY88HP1FL1cFi4L','BN5wdJ8D2P3eqhe838n2Z591nFbicdDChNDKN9QfdUKq' ,'DhBSoopwAMNQB1H3etvkercdSpkq2X9JZxrFMe6Hwb1B','FArQbF1CZS4gCgVdn1RBmvNwT3RWrcR1QAqytaEhJCkq','63B8TM7jfNQwgnvkCoGrgkZamSMF4Qod6mDaMSMqAL8','Aw2TVf37xsUoRRHY1GWEzhhonmpPDcMWFQpmF9pD3UKT','FabCA9sPrLo4kckfXcvpNYQ2nBtndhnjUSy7otJXMYPM','5eLMc3zq9MffMEPu7qJiTsJn8XVtuLh1L9QHP2Fgi57m','9JnvZUKqrjBQF2E9ivZEXu9uP6P2by9ss2q9858nG2rs','6S2zTzu4E7k6GV4Tazb52FZNE9bjyxFz3KCGKT2WNPRw','Fg4bAiK7uMCR1UCkht2NyxXks5jgnqierVKqWkERXv52','HMDQsL5pv2BHhM12ynryGNGTocu8zTSSyJQMkixLSmjm','E26oe2htH2r9GMhP8tZXMkFrKBvPZYr1zeQ7RBJsh2kX','7RPCR3![]()
![]()
) then 1 else 0 end as rug_token
, swapper
,'sell' as buysell
from solana.defi.ez_dex_swaps
QueryRunArchived: QueryRun has been archived