brian-terralibradick
Updated 2025-02-16
999
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
›
⌄
-- forked from librastool @ https://flipsidecrypto.xyz/studio/queries/27a7229a-e452-4af0-86ea-144c29f8e0fa
-- forked from GMS @ https://flipsidecrypto.xyz/studio/queries/aa6c17e6-982f-4c72-9a21-6bc83296fed1
-- forked from GMS @ https://flipsidecrypto.xyz/studio/queries/22a08020-8b41-478e-9e0b-7249b0c0bc34
select
swap_program,
'portnoy' as name,
block_timestamp,
swapper,
swap_to_mint,
tx_id
from solana.defi.ez_dex_swaps
where swapper = '5rkPDK4JnVAumgzeV2Zu8vjggMTtHdDtrsd5o9dhGZHD'
and swap_to_mint = '9wXZa1EY3n2xmVyPaFdXNsB7ZJiCDgoUBm4nbdWDpump'
UNION ALL
select
swap_program,
'rugsie7' as name,
block_timestamp,
swapper,
swap_to_mint,
tx_id
from solana.defi.ez_dex_swaps
where swapper = 'BFTCyf9BfP8WWuheCBoRfBWKz54JQ2aSQoGz1MGwwMNT'
and swap_to_mint = '9wXZa1EY3n2xmVyPaFdXNsB7ZJiCDgoUBm4nbdWDpump'
UNION ALL
select
swap_program,
'GMSCreator' as name,
QueryRunArchived: QueryRun has been archived