Updated 2025-01-21
    WITH data AS (
    SELECT
    'Arbitrum' AS chain,
    block_timestamp,
    symbol,
    tx_hash,
    trader,
    amount_usd,
    fee_amount
    FROM arbitrum.vertex.ez_perp_trades
    WHERE is_taker = 'true'

    UNION

    SELECT
    'Blitz' AS chain,
    block_timestamp,
    symbol,
    tx_hash,
    trader,
    amount_usd,
    fee_amount
    FROM blast.blitz.ez_perp_trades
    WHERE is_taker = 'true'

    UNION

    SELECT
    'Base' AS chain,
    block_timestamp,
    symbol,
    tx_hash,
    trader,
    amount_usd,
    fee_amount
    FROM base.vertex.ez_perp_trades
    Last run: 3 months ago
    TRADER
    SYMBOL
    TOTAL_PERP_TRADES
    TOTAL_PERP_VOLUME
    TOTAL_FEES
    1
    0x48ea8f8c8f4ac5bc8f64ab8ccd756cd77d57f817Sei106035044899.58561181009.09609056
    2
    0x351d1d0ed37f6854bfc36ba24caa529688990f6eArbitrum12062304500.72850638460.945674738
    3
    0x5a7e077320a97d0c6befc88defc92e7f1dbb2757Arbitrum1187268674.5664301853.7676691
    4
    0x9dbdcf27fbb172061d651298480fc513cd48f97eArbitrum42237018.8991270247.4085721
    5
    0x02cd7b4de21181a2abb0ff337136efd5e67c85adArbitrum18122318.5219409524.46615479
    6
    0xc8e137b85215088f283cf315582ec596a2b0fb26Arbitrum159115527.80113095823.109348838
    7
    0x0f8aee5b3fa517b5ddf0198d7486df7111dbda8bArbitrum8393191.76268954118.655317301
    8
    0x258b06cd514811251f927438fa5b9f15f5e2c18cBase2289031.85718855517.812058955
    9
    0xb57bc9b9a0b021103052ccd8c7ca30acc4f41612Arbitrum2034291.039303686.85889732
    10
    0xc9ed8d544ac3abdba4ee464f214d7625ba5b192cArbitrum1221080.6039435184.216434158
    11
    0xddba7151fa13289ecf41c7b3e1445160f8d83d24Arbitrum220316.8580716144.063371614
    12
    0x7543ba9e89aaa54bd81fd4bf00915b67f6827856Blitz1119940.3560581133.988573473
    13
    0xf94df160beb58f3e45b24d4b61d38f3eea20a196Arbitrum1919606.48870443.9220956
    14
    0x55885e2b85028dfd9f3fa9d14417f4cf5cd16600Arbitrum1215514.1021403223.103077362
    15
    0x27bc3a7f1aeb524d190a8316a74b9a332aad3d8fBase1413666.6242639492.733628709
    16
    0xa4fb530d7e93bf7e3fb3b59aaadbe4dfe4068e40Arbitrum2112580.9567989612.523306201
    17
    0x02cca96992b4cbb06c829826db0991aa59ba8afdBlitz112563.46380462.5131954
    18
    0xeb92ff73094b24647c08ed8dcb10d23ebf2e9463Arbitrum4110889.3539758262.178089106
    19
    0x152f9ad924aa50ebdcc9cda3a9a84bcdae60e387Arbitrum138745.5240483921.749172712
    20
    0x1f97eb248777a23a3478561cb1df36af6561024eArbitrum48230.1843563211.646150241
    69
    6KB
    6s