nasdfajsklj2024-07-31 check specific wash trading wallets on solana - multiple offender
Updated 2024-07-31
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
›
⌄
-- select *
-- from solana.core.fact_transfers
-- where 1=1
-- and tx_from = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi' or tx_to = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi'
-- select mint, count(*), sum(amount)
-- from solana.core.fact_transfers
-- where 1=1
-- and (tx_from = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi' or tx_to = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi')
-- and tx_from != '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1' and tx_to != '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1'
-- group by mint
select mint, count(*), sum(amount), tx_to, b.label, b.address_name
from solana.core.fact_transfers a
left join solana.core.dim_labels b on a.tx_to = b.address
where 1=1
and tx_from = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi'
-- and tx_to not in (
-- '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1' --raydium
-- ,'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh' --jito
-- ,'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY' --jito
-- ,'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe' --jito
-- )
group by mint, tx_to, b.label, b.address_name
-- select * from
-- select mint, count(*), sum(amount), tx_to
-- from solana.core.fact_transfers
-- where 1=1
-- and tx_to = 'Hk9AceDdBaTSWsPMf8nBp8MXdrmdHr1tUcKUTcqxbGBi'
-- and tx_from != '5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1'
-- group by mint, tx_to
QueryRunArchived: QueryRun has been archived