flipside

    By symbol in
    Afonso_DiazBy symbol in
    Updated 8 days ago
    with

    tokens as (
    select
    symbol,
    decimals,
    address as token_address
    from
    swell.core.dim_contracts

    union all

    select 'enzoBTC', 8, '0x6a9a65b84843f5fd4ac9a0471c4fc11afffbce4a'

    union all

    select 'swBTC', 18, '0xd557a21f78045380142a7bbccbca0fe3746a0787'

    union all

    select 'swBTC', 18, '0xe786314c7ee33bb45aaf72dd374d715da1c414e7'

    union all

    select 'earnETH', 18, '0x9ed15383940cc380faef0a75edace507cc775f22'
    ),

    pricet as (
    select
    hour::date as date,
    case token_address
    when '0x8db2350d78abc13f5673a411d4700bcf87864dde' then 'swBTC'
    when '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'rswETH'
    when '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' then 'SWELL'
    when '0xf951e335afb289353dc249e82926178eac7ded78' then 'swETH'
    when '0xecac9c5f704e954931349da37f60e39f515c11c1' then 'LBTC'
    Last run: 8 days ago
    SYMBOL_IN
    SWAPS
    SWAPPERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		WETH311915001199356.88718143384.53250631
    2
    		rswETH26956377884.5927421451404.775437703
    3
    		USDe1472150348316.366688603236.6279665
    4
    		rUSDC10539118307.8937143281126.741844898
    5
    		USD₮0734144645.780140436611.586029321
    6
    		SWELL114898531.93340380374.841521086
    7
    		wstETH21115570.005928486265.238377547
    8
    		rsETH24134265.557990979177.731582957
    9
    		XVELO32114068.572226846127.142882089
    10
    		KING32241887.53033963158.985323113
    11
    		BridgedMSWETH220.060367662630.03018383132
    11
    518B
    27s