flipside

    3C
    zyroq3C
    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
    DATE
    SYMBOL
    TOTAL_PERP_TRADES
    PERP_TRADERS
    TOTAL_PERP_VOLUME
    TOTAL_FEES
    CUMULATIVE_PERP_TRADES
    CUMULATIVE_PERP_TRADERS
    CUMULATIVE_PERP_VOLUME
    CUMULATIVE_FEES
    1
    		2025-01-19 14:00:00.000TRUMP-PERP72750404.93082305610.08733341672750404.93082305610.087333416
    2
    		2025-01-19 15:00:00.000TRUMP-PERP1531075177.29995768415.08637956422517125582.23078073925.173712979
    3
    		2025-01-19 16:00:00.000TRUMP-PERP87643518.4309950378.72937739731223169100.66177577733.903090377
    4
    		2025-01-19 17:00:00.000TRUMP-PERP296897486.19073215119.51028035160831266586.85250792853.413370728
    5
    		2025-01-19 18:00:00.000TRUMP-PERP68510383609.94764512576.745005485129341650196.800153053130.158376213
    6
    		2025-01-19 19:00:00.000TRUMP-PERP4086105929.04780021621.196956256170147756125.847953269151.355332469
    7
    		2025-01-19 20:00:00.000TRUMP-PERP7188159004.94916941931.809217379241955915130.797122687183.164549847
    8
    		2025-01-19 21:00:00.000TRUMP-PERP116514740295.302367569148.0804192093584691655426.09949026331.244969056
    9
    		2025-01-19 22:00:00.000TRUMP-PERP1010181221142.28688061244.2570806864594872876568.38637086575.502049742
    10
    		2025-01-19 23:00:00.000TRUMP-PERP60012557608.479322764111.5335223655194993434176.86569363687.035572107
    11
    		2025-01-20 00:00:00.000TRUMP-PERP246591380008.48257579276.03283779176591084814185.34826942963.068409898
    12
    		2025-01-20 01:00:00.000TRUMP-PERP172671266919.0356065253.42360954293851156081104.383875921216.49201944
    13
    		2025-01-20 02:00:00.000TRUMP-PERP127211533634.691191026106.741871786106571266614739.075066951323.233891226
    14
    		2025-01-20 03:00:00.000TRUMP-PERP5464467449.19628388893.500095008112031307082188.271350831416.733986234
    15
    		2025-01-20 04:00:00.000TRUMP-PERP173494556.26849767218.913827473113761347176744.539848511435.647813706
    16
    		2025-01-20 05:00:00.000TRUMP-PERP272438700.2808325777.740839777116481387215444.820681081443.388653483
    17
    		2025-01-20 06:00:00.000TRUMP-PERP24314153.9338520032.844775683116721417229598.754533091446.233429166
    18
    		2025-01-20 07:00:00.000TRUMP-PERP103782679.7246301216.54716724117751487312278.479163211462.780596406
    19
    		2025-01-20 08:00:00.000TRUMP-PERP24315684.4259107223.137104842117991517327962.905073931465.917701248
    20
    		2025-01-20 09:00:00.000TRUMP-PERP34643327.9652315778.666136217118331577371290.87030551474.583837464
    47
    5KB
    6s