ArioPolyMarket - Trading Volume
    Updated 2024-11-07
    with CFTE_NRCFTE as (
    select
    CONVERT_TIMEZONE( 'America/New_York' , BLOCK_TIMESTAMP ) as BLOCK_TIMESTAMP
    ,TX_HASH
    ,CONTRACT_ADDRESS
    ,EVENT_NAME
    ,DECODED_LOG:fee::float as fee
    ,DECODED_LOG:maker::string as maker
    ,DECODED_LOG:makerAmountFilled::float as makerAmountFilled
    ,DECODED_LOG:makerAssetId::string as makerAssetId
    ,DECODED_LOG:orderHash::string as orderHash
    ,DECODED_LOG:taker::string as taker
    ,DECODED_LOG:takerAmountFilled::float as takerAmountFilled
    ,DECODED_LOG:takerAssetId::string as takerAssetId
    from polygon.core.ez_decoded_event_logs
    where
    CONTRACT_ADDRESS in ('0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e', '0xc5d563a36ae78145c45a50134d48a1215220f80a')
    and
    EVENT_NAME = 'OrderFilled'
    and
    TX_STATUS = 'SUCCESS'
    ),
    daily_volume AS (
    SELECT
    BLOCK_TIMESTAMP::date AS date,
    SUM(
    CASE
    WHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled AS DOUBLE)
    WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled AS DOUBLE)
    END
    ) / pow(10, 6) AS volume
    FROM
    CFTE_NRCFTE
    GROUP BY
    1
    )
    Last run: about 1 month ago
    DATE
    Daily Trading Volume
    30 Days Trading Volume
    1
    2025-01-11 00:00:00.0001522337.179711690070121.97513
    2
    2025-01-10 00:00:00.00040658523.6638091742099282.4219
    3
    2025-01-09 00:00:00.00037201206.9193011758968055.0338
    4
    2025-01-08 00:00:00.00033473591.5417981763804835.57338
    5
    2025-01-07 00:00:00.00036475998.2428731780121967.41626
    6
    2025-01-06 00:00:00.00034194285.427841781561799.78477
    7
    2025-01-05 00:00:00.00040152494.440491782211196.01835
    8
    2025-01-04 00:00:00.00034694733.1286271811999548.13647
    9
    2025-01-03 00:00:00.00043011131.1127221843697964.6415
    10
    2025-01-02 00:00:00.00049590055.274831875563260.05948
    11
    2025-01-01 00:00:00.00054260628.2065311886347574.64755
    12
    2024-12-31 00:00:00.00060388571.311431882894854.1718
    13
    2024-12-30 00:00:00.00064001224.6012521870519865.62172
    14
    2024-12-29 00:00:00.00076622263.8818811846233072.52539
    15
    2024-12-28 00:00:00.00074194981.7501321838574759.30131
    16
    2024-12-27 00:00:00.00088421199.0224941832676257.75808
    17
    2024-12-26 00:00:00.00068628319.3507191787930107.66571
    18
    2024-12-25 00:00:00.00073541870.9080251754761724.83737
    19
    2024-12-24 00:00:00.00076141655.2662751741277829.80413
    20
    2024-12-23 00:00:00.00086679551.8682311715885698.89087
    ...
    181
    11KB
    538s