GoGoPoolggAVAX 7 Day Volume Per Platform
    Updated 2 days ago
    with ggAVAX_swaps_excl_wom as (
    SELECT
    DATE_TRUNC('hour', block_timestamp) AS hour,
    CASE
    WHEN token_in = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN amount_in
    WHEN token_out = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN amount_out
    END AS ggAVAX_volume,
    platform
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE
    (
    token_in = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    OR token_out = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    )
    ),
    ggAVAX_wom_swaps as (
    SELECT
    DATE_TRUNC('hour', block_timestamp) as hour,
    CASE
    WHEN decoded_log:fromToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN decoded_log:fromAmount / 1e18
    WHEN decoded_log:toToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' THEN decoded_log:toAmount / 1e18
    END AS ggAVAX_volume,
    'wombat' as platform
    FROM
    avalanche.core.fact_decoded_event_logs
    WHERE
    contract_address = '0xbba43749efc1bc29ea434d88ebaf8a97dc7aeb77'
    AND event_name = 'Swap'
    AND (
    decoded_log:fromToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    OR decoded_log:toToken = '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3'
    )
    ),
    ggAVAX_swaps as (
    SELECT
    Last run: 2 days ago
    PLATFORM
    TOTAL_VOLUME
    1
    trader-joe-v2$ 3,979,835
    2
    pharaoh-v2$ 1,585,554
    3
    balancer$ 80,201
    4
    wombat$ 3,137
    5
    uniswap-v3$ 22
    5
    153B
    3s