aster2709volume_btc
    Updated 2025-01-07
    select sum(cast(decoded_log['exchangedQuote'] as float) / 1e18) as volume from blast.core.ez_decoded_event_logs
    where event_name = 'PositionChanged'
    and contract_address = '0x0c2309c6554aabbfbca7d5219545795dcaf6f4a9'
    and cast(decoded_log['tradeType'] as float) < 2
    QueryRunArchived: QueryRun has been archived