nasdfajskljphantom rug buys and sells unfiltered
Updated 2024-08-12
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 buys as (
select
tx_id
,max(swap_from_amount_usd) as usd
,swap_to_mint as token
from solana.defi.ez_dex_swaps
where swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint 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','GfLkhUs8cGAkCdZ1smJgj7cfejkm6ApnzgDHu6uipnXg','DhBSoopwAMNQB1H3etvkercdSpkq2X9JZxrFMe6Hwb1B','FArQbF1CZS4gCgVdn1RBmvNwT3RWrcR1QAqytaEhJCkq','63B8TM7jfNQwgnvkCoGrgkZamSMF4Qod6mDaMSMqAL8','Aw2TVf37xsUoRRHY1GWEzhhonmpPDcMWFQpmF9pD3UKT','FabCA9sPrLo4kckfXcvpNYQ2nBtndhnjUSy7otJXMYPM','5eLMc3zq9MffMEPu7qJiTsJn8XVtuLh1L9QHP2Fgi57m','9JnvZUKqrjBQF2E9ivZEXu9uP6P2by9ss2q9858nG2rs','6S2zTzu4E7k6GV4Tazb52FZNE9bjyxFz3KCGKT2WNPRw','Fg4bAiK7uMCR1UCkht2NyxXks5jgnqierVKqWkERXv52','HMDQsL5pv2BHhM12ynryGNGTocu8zTSSyJQMkixLSmjm','E26oe2htH2r9GMhP8tZX![]()
![]()
)
and swap_to_mint not in (
--false positives kinda
'HRw8mqK8N3ASKFKJGMJpy4FodwR3GKvCFKPDQNqUNuEP'
,'GfLkhUs8cGAkCdZ1smJgj7cfejkm6ApnzgDHu6uipnXg'
,'CLoUDKc4Ane7HeQcPpE3YHnznRxhMimJ4MyaUqyHFzAu'
,'3dCCbYca3jSgRdDiMEeV5e3YKNzsZAp3ZVfzUsbb4be4'
)
GROUP BY tx_id, swap_to_mint
)
, sells as (
select
tx_id
,max(swap_to_amount_usd) as usd
,swap_from_mint as token
from solana.defi.ez_dex_swaps
where swap_to_mint = 'So11111111111111111111111111111111111111112'
and swap_from_mint 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','GfLkhUs8cGAkCdZ1smJgj7cfejkm6ApnzgDHu6uipnXg','DhBSoopwAMNQB1H3etvkercdSpkq2X9JZxrFMe6Hwb1B','FArQbF1CZS4gCgVdn1RBmvNwT3RWrcR1QAqytaEhJCkq','63B8TM7jfNQwgnvkCoGrgkZamSMF4Qod6mDaMSMqAL8','Aw2TVf37xsUoRRHY1GWEzhhonmpPDcMWFQpmF9pD3UKT','FabCA9sPrLo4kckfXcvpNYQ2nBtndhnjUSy7otJXMYPM','5eLMc3zq9MffMEPu7qJiTsJn8XVtuLh1L9QHP2Fgi57m','9JnvZUKqrjBQF2E9ivZEXu9uP6P2by9ss2q9858nG2rs','6S2zTzu4E7k6GV4Tazb52FZNE9bjyxFz3KCGKT2WNPRw','Fg4bAiK7uMCR1UCkht2NyxXks5jgnqierVKqWkERXv52','HMDQsL5pv2BHhM12ynryGNGTocu8zTSSyJQMkixLSmjm','E26oe2htH2r9GMhP8tZX![]()
![]()
)
and swap_from_mint not in (
--false positives kinda
'HRw8mqK8N3ASKFKJGMJpy4FodwR3GKvCFKPDQNqUNuEP'
,'GfLkhUs8cGAkCdZ1smJgj7cfejkm6ApnzgDHu6uipnXg'
,'CLoUDKc4Ane7HeQcPpE3YHnznRxhMimJ4MyaUqyHFzAu'
,'3dCCbYca3jSgRdDiMEeV5e3YKNzsZAp3ZVfzUsbb4be4'
QueryRunArchived: QueryRun has been archived