0xbiVolume
    Updated 2024-01-09
    with swap_history_dim as
    (
    SELECT
    BLOCK_NUMBER
    ,BLOCK_TIMESTAMP
    ,TX_HASH
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    ,EVENT_NAME
    -- ,DECODED_LOG
    ,baseToken
    ,exchangedPositionNotional/1e18 as exchangedPositionNotional
    ,exchangedPositionSize/1e18 as exchangedPositionSize
    ,fee /1e18 as fee
    ,openNotional / 1e18 as openNotional
    ,realizedPnl / 1e18 as realizedPnl
    ,sqrtPriceAfterX96
    ,trader
    ,ORIGIN_FROM_ADDRESS
    ,ORIGIN_TO_ADDRESS
    ,stat_date
    ,action_type
    from
    (
    SELECT
    BLOCK_NUMBER
    ,BLOCK_TIMESTAMP
    ,a.TX_HASH as TX_HASH
    ,EVENT_INDEX
    ,CONTRACT_ADDRESS
    ,EVENT_NAME
    -- ,DECODED_LOG
    ,baseToken
    ,exchangedPositionNotional
    ,exchangedPositionSize
    ,fee
    QueryRunArchived: QueryRun has been archived