SWAPPER | GENE_BOUGHT | GENE_SOLD | TRADED_VOLUME | BUY_TRADES | SELL_TRADES | |
---|---|---|---|---|---|---|
1 | GSfgmzjU6xWkzBEySACgHKPMnSchZ2J3tzJj4C9cBwJT | 6083345.00395296 | 8708611.82383435 | 14791956.8277873 | 3655 | 5355 |
2 | CwyQtt6xGptR7PaxrrksgqBSRCZ3Zb2GjUYjKD9jH3tf | 3425842.33874457 | 3205490.15691 | 6631332.49565457 | 98169 | 87240 |
3 | GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM | 3821916.31538286 | 1673715.90172645 | 5495632.21710931 | 8046 | 2441 |
4 | BPiunxZKqnVjfyGwxEGDJ8fo2Anc9KZW2w81gpbPRJV3 | 2477582.34707643 | 2477582.34707643 | 4955164.69415287 | 46100 | 46100 |
5 | GM8Fvy48LSuwZ1rd1KzNgWP5xh3jDDfbCMsZZDrFck2q | 1436804.84960492 | 2770882.02267038 | 4207686.8722753 | 1765 | 3690 |
6 | Gf3xcCvK2RH1sKUM8PEAJ8ymA9B2qkqzJRJxZExVgMxJ | 1112279.77183727 | 1644484.86800735 | 2756764.63984462 | 457 | 670 |
7 | CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6 | 1438411.58941105 | 676398.393984122 | 2114809.98339518 | 3689 | 653 |
8 | J8EbdJaYNA13movGsC2vnJfKtG1b5kFrqErYG4CNNPSs | 460721.397402871 | 1324523.44463473 | 1785244.8420376 | 198 | 535 |
9 | EK8mfHEbdtXcaN23Qa5GnZfEkVFrGvpzKHVF6ykMnNyj | 809430.544118528 | 960696.03446234 | 1770126.57858087 | 7512 | 7222 |
10 | BEmUSjqs7mpgaSXw6QdrePfTsD8aQHbdtnqUxa63La6E | 858619.68252274 | 858437.690933582 | 1717057.37345632 | 9650 | 9648 |
11 | 524X2N4SN1jqHy3c2RdictkQ1tpdXnXqUEEs66d6ih3A | 526726.314444931 | 1150131.29767325 | 1676857.61211819 | 154 | 340 |
12 | Dv4Ue38ZDWys3kgEmYsb9KVeFmrt4E4XdtMpDRu3GQ1H | 695078.711892862 | 921053.67158374 | 1616132.3834766 | 9845 | 36377 |
13 | 4CSPR37gm1t1eBeabFPuoyXHbwWoUrpBmqLsg1M1FPD6 | 537111.866611732 | 1007031.81900623 | 1544143.68561796 | 335 | 653 |
14 | FQALtCrik9tuae1cqpb5WNBma1VuVNu9UR3hvUDytyzu | 709412.916690183 | 709412.916690183 | 1418825.83338037 | 12961 | 12961 |
15 | benRLpbWCL8P8t51ufYt522419hGF5zif3CqgWGbEUm | 701430.504668116 | 701573.158902017 | 1403003.66357013 | 1543 | 1544 |
16 | BQ72nSv9f3PRyRKCBnHLVrerrv37CYTHm5h3s9VSGQDV | 653908.757552468 | 726621.061730059 | 1380529.81928253 | 1659 | 1431 |
17 | HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK | 684775.338131943 | 687353.348410709 | 1372128.68654265 | 2533 | 2571 |
18 | 6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB | 622661.940670147 | 720409.309618999 | 1343071.25028915 | 1656 | 1453 |
19 | 2Dp9x3SUNdA83U77TmfHSio8479BU6qJk5U3rLHRsekf | 774833.837101534 | 547425.536614517 | 1322259.37371605 | 5904 | 2191 |
20 | 4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71 | 647659.502384094 | 659562.59902766 | 1307222.10141175 | 1681 | 1417 |
marc_keyrockTop GENE traders
Updated 2025-05-30Copy Reference Fork
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
›
⌄
WITH gene_sales AS (
SELECT DISTINCT SWAPPER, SUM(SWAP_FROM_AMOUNT) AS gene_sold, COUNT(*) AS sell_trades
FROM solana.defi.fact_swaps
WHERE
SWAP_FROM_MINT = 'GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz'
AND SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= '2022-01-01'
GROUP BY 1
ORDER BY 2 DESC
),
gene_buys AS (
SELECT DISTINCT SWAPPER, SUM(SWAP_TO_AMOUNT) AS gene_bought, COUNT(*) AS buy_trades
FROM solana.defi.fact_swaps
WHERE
SWAP_TO_MINT = 'GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz'
AND SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= '2022-01-01'
GROUP BY 1
ORDER BY 2 DESC
)
SELECT a.SWAPPER, gene_bought, gene_sold, gene_bought + gene_sold AS traded_volume, buy_trades, sell_trades
FROM gene_buys a
JOIN gene_sales b ON a.SWAPPER=b.SWAPPER
ORDER BY 4 DESC
LIMIT 1000
-- SELECT rownum(), token_address, pool, upper_tick, lower_tick
-- FROM arbitrum.core.fact_event_logs
Last run: about 2 months agoAuto-refreshes every 3 hours
1000
100KB
402s