flipside

    Total (Volume & Fee)
    RayyykTotal (Volume & Fee)
    Updated 5 hours ago
    -- thorchain
    with res1 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/d02962f2-17c8-468e-8096-3832a8b4b4b8/data/latest') as result),

    data1 as (select result:data as json_result_must_pivot from res1),

    thorchain as (select 'THORChain' as platform,
    to_timestamp(value:DATE) as date,
    sum(value:VOLUME_USD) as volume_usd,
    sum(value:TX_COUNT) as tx_count,
    sum(value:"Affiliate Fee in USD") as fee_usd
    from data1,
    LATERAL FLATTEN(input => data1.json_result_must_pivot::VARIANT) d
    group by 2),

    -- maya
    res2 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/6b5eaf14-cee1-4a8c-942b-0cee84ccc1b6/data/latest') as result),

    data2 as (select result:data as json_result_must_pivot from res2),

    maya as (select 'Maya Protocol' as platform,
    to_timestamp(value:DATE) as date,
    sum(value:VOLUME_USD) as volume_usd,
    sum(value:TX_COUNT) as tx_count,
    sum(value:"Affiliate Fee in USD") as fee_usd
    from data2,
    LATERAL FLATTEN(input => data2.json_result_must_pivot::VARIANT) d
    group by 2),

    -- lifi
    res3 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/f3f67b09-3a66-419d-8a30-e8050bdc3a8a/data/latest') as result),

    data3 as (select result:data as json_result_must_pivot from res3),

    lifi as (select 'LiFi' as platform,
    to_timestamp(value:DATE) as date,
    sum(value:USD_VOLUME) as volume_usd,
    Last run: about 5 hours ago
    PLATFORM
    DATE
    VOLUME_USD
    TX_COUNT
    FEE_USD
    TOTAL_VOLUME
    TOTAL_TX
    TOTAL_FEE
    1
    		THORChain2025-04-01 00:00:00.0007062545.300278959035312.72650139456541242.33898222613283339.754225742
    2
    		Maya Protocol2025-04-01 00:00:00.0005725.652854061428.6282642756541242.33898222613283339.754225742
    3
    		LiFi2025-04-01 00:00:00.00010385.6159458741852.30512276956541242.33898222613283339.754225742
    4
    		1inch2025-04-01 00:00:00.00040165.2940448319200.83382022556541242.33898222613283339.754225742
    5
    		THORChain2025-03-01 00:00:00.00020727971.4218185230103639.85710909349422420.47585852482247745.260517085
    6
    		Maya Protocol2025-03-01 00:00:00.00069777.64651927146348.88823259649422420.47585852482247745.260517085
    7
    		LiFi2025-03-01 00:00:00.0009661.4218692355248.87168473349422420.47585852482247745.260517085
    8
    		1inch2025-03-01 00:00:00.00037164.29813621713185.82684068149422420.47585852482247745.260517085
    9
    		THORChain2025-02-01 00:00:00.00010682316.315987855453411.58157993828577845.68751522141143521.816649982
    10
    		Maya Protocol2025-02-01 00:00:00.000439978.0811566041532199.89040578328577845.68751522141143521.816649982
    11
    		LiFi2025-02-01 00:00:00.000516723.705394869642607.46041238428577845.68751522141143521.816649982
    12
    		1inch2025-02-01 00:00:00.000204855.83890162231024.27229450828577845.68751522141143521.816649982
    13
    		THORChain2025-01-01 00:00:00.0007111147.8831899627635555.7394159516733971.7460743134784278.611957369
    14
    		Maya Protocol2025-01-01 00:00:00.000707389.9666098771153536.94983304916733971.7460743134784278.611957369
    15
    		LiFi2025-01-01 00:00:00.00094772.9326459165478.74785873816733971.7460743134784278.611957369
    16
    		1inch2025-01-01 00:00:00.000136251.68772757915681.25418863716733971.7460743134784278.611957369
    17
    		THORChain2024-12-01 00:00:00.0001449807.562350981177249.0378117558684409.2759010187644025.920660996
    18
    		Maya Protocol2024-12-01 00:00:00.000555010.3367956821042775.0516839798684409.2759010187644025.920660996
    19
    		LiFi2024-12-01 00:00:00.00082588.68859160274415.1155344368684409.2759010187644025.920660996
    20
    		1inch2024-12-01 00:00:00.00042222.61217795134211.1190607658684409.2759010187644025.920660996
    39
    4KB
    3s