flipside

    evm-dexes
    octavionotpunkevm-dexes
    Updated 2024-02-09
    -- forked from solana-dexes @ https://flipsidecrypto.xyz/edit/queries/b5a65067-e25d-4608-8287-52ac3ae683e1

    with raw_dex_data as (
    select *, 'ethereum' as chain from ethereum.defi.ez_dex_swaps
    union all
    select *, 'bsc' as chain from bsc.defi.ez_dex_swaps
    union all
    select *,'polygon' as chain from polygon.defi.ez_dex_swaps
    union all
    select *,'base' as chain from base.defi.ez_dex_swaps
    union all
    select *,'avalanche' as chain from avalanche.defi.ez_dex_swaps
    union all
    select *,'gnosis' as chain from gnosis.defi.ez_dex_swaps
    union all
    select *,'arbitrum' as chain from arbitrum.defi.ez_dex_swaps
    union all
    select *,'optimism' as chain from optimism.defi.ez_dex_swaps)


    , dex_data as (
    select
    DATE_TRUNC('hour', BLOCK_TIMESTAMP) as time,
    amount_in,
    amount_in_usd,
    amount_out,
    amount_out_usd,
    token_in,
    token_out,
    symbol_in,
    symbol_out,
    platform,
    tx_hash,
    tx_to as receiver,
    chain
    from
    Last run: about 1 year ago
    VALUE
    RECEIVER
    TRANSACTIONS
    TIME
    PLATFORM
    1
    		34211099.5260272772023-08-01 00:00:00.000zyberswap-v3
    2
    		32064.610911542023-08-01 00:00:00.000zyberswap-v2
    3
    		218328929.47834713818422023-08-01 00:00:00.000woofi
    4
    		767306.3425711632023-08-01 00:00:00.000verse
    5
    		101182996.7203763662742023-08-01 00:00:00.000velodrome-v2
    6
    		7187587.855921677222023-08-01 00:00:00.000velodrome
    7
    		13104484087.5537914540045472023-08-01 00:00:00.000uniswap-v3
    8
    		1676690767.0214180812038302023-08-01 00:00:00.000uniswap-v2
    9
    		387218045.05674564647472023-08-01 00:00:00.000trader-joe-v2
    10
    		19427981.5134811377542023-08-01 00:00:00.000trader-joe-v1
    11
    		9737013.73302012023-08-01 00:00:00.000synthetix
    12
    		173922.72473104132023-08-01 00:00:00.000swapr
    13
    		642207.2740612742023-08-01 00:00:00.000swapbased
    14
    		139138287.03551014491622023-08-01 00:00:00.000sushiswap
    15
    		99964150.246913401602023-08-01 00:00:00.000shibaswap
    16
    		406825908.9437525134082023-08-01 00:00:00.000quickswap-v3
    17
    		27667904.2118215496492023-08-01 00:00:00.000quickswap-v2
    18
    		16348800.4628150722023-08-01 00:00:00.000platypus
    19
    		10565412.282250742042023-08-01 00:00:00.000pangolin
    20
    		2094383763.6512642311607642023-08-01 00:00:00.000pancakeswap-v3
    ...
    291
    18KB
    21s