SWAPPER | PROFIT_SOL | PERCENTAGE | |
|---|---|---|---|
1 | 66nqaZdu61yEjKXQBBJyMmqf8zjX45jPtV7gWNhjdJ5M | 290.156580205 | 8071.334621016 |
2 | FFqRN97pydBTxgwP8QhJhUm7ndtAguukiwSS1C6CuPF3 | 347.361012527 | 8000.860221391 |
3 | AGLMz2ueo3ufeciG3RxN78ZFLijvp75zs6CfKFhDJo3h | 459.020425989 | 7815.925802471 |
4 | GkLxV6b7WBYAjYRXm5EYVz9LFeED3PY4iZxJ5to8j49e | 29.172109381 | 5934.4218762 |
5 | dsc5uzR5X68MkXyc7n2WkXFWo6fTMBYXSYHbe8a28YV | 167.65255991 | 5763.018011444 |
6 | GFeBr4iZ7Fiw5DKqv9fAZDiPiTq6QU8JnBDsU3zUXLmQ | 338.088428601 | 5734.80714335 |
7 | aFEHUcSWzFW97ky49ed8BNxNHp99bdPYN1LVdVZRDdy | 470.318975708 | 5050.726060084 |
8 | 6BDdWmsgKb4esDFKg2QUViFmm88GpDBj989prrM5aSvq | 153.384524181 | 4893.266380656 |
9 | 3ehAUesXTihTMaZa6bf2em1vEVTnhUdtcSV7Ydmn9tHT | 275.306069019 | 4813.337939034 |
10 | 85S1KdZGSm5Mvhtmki7rybMjZpj2p9LpWbVqcv5fH2HE | 22.047250851 | 4509.4501702 |
11 | 7Whmbdqy5b3RsrqbmickLeFEA1LDXR9hXpGGCmd26V4Y | 399.284356686 | 4385.778868561 |
12 | 34CyZFfaYHNtJhZksH6VbXa282uEUqumfXuNdptGffY7 | 3404.68233934 | 4217.790787718 |
13 | CBLLZ2fRE5jYrPSoNBer9Wp5o3QgwrkWVHgNV8Eh2qKr | 341.452051305 | 4206.215605258 |
14 | HBZEKF4AswUUaz4PZ1p1ZnDmkTmDCPyrNd9WuDH1Jnfh | 244.69118006 | 4178.186334333 |
15 | DiBi2jGtyT9VsuvrZfQFaFTCEkFqwr46qLQmeVnpkDeL | 199.581439984 | 4091.62879968 |
16 | HzX4vGnU6A7wUP5z7cQJHThMxb2NdwNq4pGL9LxZTsm | 37.015575688 | 3801.5575688 |
17 | 5aUmHcpMbQUXJ6JLuCyxSK5WRpcDk3i7V9oGLGSg2u5h | 65.511896089 | 3375.59480445 |
18 | AndwKxNeQT7HTWAPPbEED6ekMQGaUBWJyNL4YoSS6td | 466.965979455 | 3213.1065297 |
19 | 36MuMtrjvm491k2YqEB74kBNWcbSFH9dQEVUPSMu99gg | 56.953401895 | 2947.67009475 |
20 | LB4TbU9mrLdxuimW7AihUjuESGzi5iUxip5zfasPEJE | 56.395141658 | 2919.7570829 |
mmdrezaVvaifu
Updated 2025-01-24
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 buyer as (
select
distinct swapper as swappers,
sum(swap_from_amount) as amount
from solana.defi.ez_dex_swaps
where swap_to_mint = 'FQ1tyso61AH1tzodyJfSwmzsD3GToybbRNoZxUBz21p8'
and swap_from_mint = 'So11111111111111111111111111111111111111112'
and block_timestamp <= '2024-11-15 16:30:00.000'
group by 1
having sum(swap_from_amount) >= 0.5
),
tab2 as (
select
distinct swapper as users,
count(*) as tx_count
from solana.defi.ez_dex_swaps
where swapper in (select swappers from buyer)
and block_timestamp >= current_date - 30
group by 1),
tab_users as (select users
from tab2
where tx_count < 150
and tx_count > 10),
tab_buy as (select
distinct swapper,
sum(swap_from_amount) as buy
from solana.defi.ez_dex_swaps
where swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint = 'FQ1tyso61AH1tzodyJfSwmzsD3GToybbRNoZxUBz21p8'
and swapper in (select users from tab_users)
group by 1),
tab_sell as (select
Last run: 3 months ago
...
609
45KB
85s