flipside

    Test
    Afonso_DiazTest
    Updated 2025-04-04
    -- forked from Total @ https://flipsidecrypto.xyz/studio/queries/059402e5-0fa9-4743-b25e-b935fb065473

    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'
    QueryRunArchived: QueryRun has been archived