flipside

    dex volume over time
    SocioAnalyticadex volume over time
    Updated 2024-02-01
    SELECT
    date_trunc('d',block_timestamp) as date,
    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 "dex volume [usd]",
    CASE when date BETWEEN '2023-01-01' and '2023-04-01' then 'Q1 2023'
    when date BETWEEN '2023-04-01' and '2023-07-01' then 'Q2 2023'
    when date BETWEEN '2023-07-01' and '2023-10-01' then 'Q3 2023'
    when date BETWEEN '2023-10-01' and '2023-12-31' then 'Q4 2023'
    end as quarter
    FROM polygon.defi.ez_dex_swaps
    WHERE date BETWEEN '2023-01-01' AND '2023-12-31'
    GROUP by 1 , 2
    ORDER BY 1 DESC




    Last run: about 1 year ago
    DATE
    PLATFORM
    dex volume [usd]
    QUARTER
    1
    		2023-12-31 00:00:00.000curve3917048.55Q4 2023
    2
    		2023-12-31 00:00:00.000uniswap77791365.39Q4 2023
    3
    		2023-12-31 00:00:00.000hashflow58958.835Q4 2023
    4
    		2023-12-31 00:00:00.000sushiswap604403.645Q4 2023
    5
    		2023-12-31 00:00:00.000quickswap50656666.065Q4 2023
    6
    		2023-12-31 00:00:00.000balancer1823045.145Q4 2023
    7
    		2023-12-31 00:00:00.000fraxswap51720.94Q4 2023
    8
    		2023-12-31 00:00:00.000dodo1603167.82Q4 2023
    9
    		2023-12-31 00:00:00.000kyberswap146605.7Q4 2023
    10
    		2023-12-31 00:00:00.000woofi4002474.765Q4 2023
    11
    		2023-12-30 00:00:00.000fraxswap50734.42Q4 2023
    12
    		2023-12-30 00:00:00.000curve3008746.56Q4 2023
    13
    		2023-12-30 00:00:00.000hashflow184220Q4 2023
    14
    		2023-12-30 00:00:00.000kyberswap154673.875Q4 2023
    15
    		2023-12-30 00:00:00.000sushiswap508450.55Q4 2023
    16
    		2023-12-30 00:00:00.000quickswap40972966.52Q4 2023
    17
    		2023-12-30 00:00:00.000dodo1512731.805Q4 2023
    18
    		2023-12-30 00:00:00.000uniswap62219823.33Q4 2023
    19
    		2023-12-30 00:00:00.000woofi2950700.915Q4 2023
    20
    		2023-12-30 00:00:00.000balancer1362879.43Q4 2023
    ...
    3650
    211KB
    6s