marc_keyrockTop GENE traders
    Updated 2025-05-30
    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
    SWAPPER
    GENE_BOUGHT
    GENE_SOLD
    TRADED_VOLUME
    BUY_TRADES
    SELL_TRADES
    1
    GSfgmzjU6xWkzBEySACgHKPMnSchZ2J3tzJj4C9cBwJT6083345.003952968708611.8238343514791956.827787336555355
    2
    CwyQtt6xGptR7PaxrrksgqBSRCZ3Zb2GjUYjKD9jH3tf3425842.338744573205490.156916631332.495654579816987240
    3
    GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM3821916.315382861673715.901726455495632.2171093180462441
    4
    BPiunxZKqnVjfyGwxEGDJ8fo2Anc9KZW2w81gpbPRJV32477582.347076432477582.347076434955164.694152874610046100
    5
    GM8Fvy48LSuwZ1rd1KzNgWP5xh3jDDfbCMsZZDrFck2q1436804.849604922770882.022670384207686.872275317653690
    6
    Gf3xcCvK2RH1sKUM8PEAJ8ymA9B2qkqzJRJxZExVgMxJ1112279.771837271644484.868007352756764.63984462457670
    7
    CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw61438411.58941105676398.3939841222114809.983395183689653
    8
    J8EbdJaYNA13movGsC2vnJfKtG1b5kFrqErYG4CNNPSs460721.3974028711324523.444634731785244.8420376198535
    9
    EK8mfHEbdtXcaN23Qa5GnZfEkVFrGvpzKHVF6ykMnNyj809430.544118528960696.034462341770126.5785808775127222
    10
    BEmUSjqs7mpgaSXw6QdrePfTsD8aQHbdtnqUxa63La6E858619.68252274858437.6909335821717057.3734563296509648
    11
    524X2N4SN1jqHy3c2RdictkQ1tpdXnXqUEEs66d6ih3A526726.3144449311150131.297673251676857.61211819154340
    12
    Dv4Ue38ZDWys3kgEmYsb9KVeFmrt4E4XdtMpDRu3GQ1H695078.711892862921053.671583741616132.3834766984536377
    13
    4CSPR37gm1t1eBeabFPuoyXHbwWoUrpBmqLsg1M1FPD6537111.8666117321007031.819006231544143.68561796335653
    14
    FQALtCrik9tuae1cqpb5WNBma1VuVNu9UR3hvUDytyzu709412.916690183709412.9166901831418825.833380371296112961
    15
    benRLpbWCL8P8t51ufYt522419hGF5zif3CqgWGbEUm701430.504668116701573.1589020171403003.6635701315431544
    16
    BQ72nSv9f3PRyRKCBnHLVrerrv37CYTHm5h3s9VSGQDV653908.757552468726621.0617300591380529.8192825316591431
    17
    HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK684775.338131943687353.3484107091372128.6865426525332571
    18
    6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB622661.940670147720409.3096189991343071.2502891516561453
    19
    2Dp9x3SUNdA83U77TmfHSio8479BU6qJk5U3rLHRsekf774833.837101534547425.5366145171322259.3737160559042191
    20
    4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71647659.502384094659562.599027661307222.1014117516811417
    ...
    1000
    100KB
    402s