flipside

    Trading volume
    AzinTrading volume
    Updated 2025-03-12
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DATE ,
    SUM(AMOUNT_USD) AS VOLUME ,
    SYMBOL ,
    TRADE_TYPE,
    SUM(VOLUME) OVER (ORDER BY DATE) AS Total_volume
    FROM
    arbitrum.vertex.ez_perp_trades
    WHERE is_taker = TRUE
    GROUP BY 1,3,4
    ORDER BY 1 DESC
    Last run: about 2 months ago
    DATE
    VOLUME
    SYMBOL
    TRADE_TYPE
    TOTAL_VOLUME
    1
    		2025-03-12 00:00:00.000282.776555311AAVE-PERPbuy/long123049778821.598
    2
    		2025-03-12 00:00:00.00024250.9224236MKR-PERPsell/short123049778821.598
    3
    		2025-03-12 00:00:00.00026584.3481948LINK-PERPsell/short123049778821.598
    4
    		2025-03-12 00:00:00.000248.394FTM-PERPbuy/long123049778821.598
    5
    		2025-03-12 00:00:00.000200521.2913989SOL-PERPsell/short123049778821.598
    6
    		2025-03-12 00:00:00.00010851.925297459TIA-PERPbuy/long123049778821.598
    7
    		2025-03-12 00:00:00.0006745.98493312DOT-PERPsell/short123049778821.598
    8
    		2025-03-12 00:00:00.00047530.816754351MPEPE-PERPbuy/long123049778821.598
    9
    		2025-03-12 00:00:00.0008851.939727385ADA-PERPbuy/long123049778821.598
    10
    		2025-03-12 00:00:00.0001647950.82345588BTC-PERPbuy/long123049778821.598
    11
    		2025-03-12 00:00:00.000683.9625PYTH-PERPsell/short123049778821.598
    12
    		2025-03-12 00:00:00.00016147.982906981LINK-PERPbuy/long123049778821.598
    13
    		2025-03-12 00:00:00.0004182.488092ARB-PERPsell/short123049778821.598
    14
    		2025-03-12 00:00:00.0008250.430368274OP-PERPbuy/long123049778821.598
    15
    		2025-03-12 00:00:00.0001999.584MEME-PERPsell/short123049778821.598
    16
    		2025-03-12 00:00:00.000213.70725MNT-PERPsell/short123049778821.598
    17
    		2025-03-12 00:00:00.00010024.359727AAVE-PERPsell/short123049778821.598
    18
    		2025-03-12 00:00:00.00048913.3080212MPEPE-PERPsell/short123049778821.598
    19
    		2025-03-12 00:00:00.00036027.773279256NEAR-PERPbuy/long123049778821.598
    20
    		2025-03-12 00:00:00.0004248.619120104LDO-PERPbuy/long123049778821.598
    ...
    49473
    4MB
    6s