SocioAnalyticadex volume
    Updated 2024-02-01
    with
    q1 as (
    SELECT
    CASE when platform ilike 'uniswap%' then 'uniswap'
    when platform ilike 'quickswap%' then 'quickswap'
    when platform ilike 'dodo%' then 'dodo'
    when platform ilike 'kyberswap%' then 'kyberswap'
    when platform ilike 'hashflow%' then 'hashflow'
    else platform end as platform,
    sum((amount_in_usd + amount_out_usd)/2) as "Q1 2023"
    FROM polygon.defi.ez_dex_swaps
    WHERE block_timestamp::date BETWEEN '2023-01-01' AND '2023-04-01'
    GROUP by 1
    )
    ,
    q2 as (
    SELECT
    CASE when platform ilike 'uniswap%' then 'uniswap'
    when platform ilike 'quickswap%' then 'quickswap'
    when platform ilike 'dodo%' then 'dodo'
    when platform ilike 'kyberswap%' then 'kyberswap'
    when platform ilike 'hashflow%' then 'hashflow'
    else platform end as platform,
    sum((amount_in_usd + amount_out_usd)/2) as "Q2 2023"
    FROM polygon.defi.ez_dex_swaps
    WHERE block_timestamp::date BETWEEN '2023-04-01' AND '2023-07-01'
    GROUP by 1
    )
    ,
    q3 as (
    SELECT
    CASE when platform ilike 'uniswap%' then 'uniswap'
    when platform ilike 'quickswap%' then 'quickswap'
    when platform ilike 'dodo%' then 'dodo'
    when platform ilike 'kyberswap%' then 'kyberswap'
    when platform ilike 'hashflow%' then 'hashflow'
    Last run: about 1 year ago
    PLATFORM
    Dex volume Q1 2023
    Dex volume Q2 2023
    Dex volume Q3 2023
    Dex volume Q4 2023
    Dex volume
    % Q4 2023
    1
    uniswap8827187071.9154916418920.6953482924018.836969534990.8324196065002.2729
    2
    quickswap3443955640.32639160593.0251766016441.324242345892.3551209147856735
    3
    dodo822900096.965306012940.2172487163.655223107963.6751524508164.49515
    4
    kyberswap860795664.705110384672.6154386845.5112395480.725987962663.5551
    5
    woofi133328301.075203842602.655172503943.265456999472.315966674319.3147
    6
    curve420021106.69203854369.415117955122.3125886355.93867716954.33515
    7
    balancer182783677.435185905802.53115938566.495108994743.775593622790.23518
    8
    sushiswap154623906.83570148428.7952766477.41559800595.5337339408.5418
    9
    hashflow65403524.9429855830.8213628840.24511685508.315120573704.3210
    10
    fraxswap10053390.9955232033.743392719.9755911771.39524589916.10524
    10
    820B
    7s