flipside

    ShapeShift DAO Revenue
    RayyykShapeShift DAO Revenue
    Updated 13 hours ago
    -- thorchain
    with res1 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/cd583e34-6bcc-45fe-aa0b-2993af229b20/data/latest') as result),

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

    thorchain as (select to_timestamp(value:DATE) as date,
    --value:Affiliates as affiliate,
    value:"Affiliate Fee in USD" as usd_volume
    from data1,
    LATERAL FLATTEN(input => data1.json_result_must_pivot::VARIANT) d
    where value:Affiliates = 'ShapeShift'),

    -- cowswap
    cowswap as (select date,
    "Total" as usd_volume
    from $query('6c1c5ef6-9aab-4acb-a9a9-5e44231ace97')),

    -- 0x
    res3 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/de479636-e92f-45f0-8926-10fd96df7619/data/latest') as result),

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

    ox as (select to_timestamp(value:DATE) as date,
    sum(value:Total) as usd_volume
    from data3,
    LATERAL FLATTEN(input => data3.json_result_must_pivot::VARIANT) d
    group by 1),

    -- cosmos
    res4 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/f4bd86c5-275d-4e0b-b797-c0102ab0792a/data/latest') as result),

    data4 as (select result:data as json_result_must_pivot from res4),

    cosmos as (select to_timestamp(value:DATE) as date,
    value:USD_RECEIVED as usd_volume
    from data4,
    Last run: about 13 hours agoAuto-refreshes every 24 hours
    DAY
    Total
    SOURCE
    START_DATE
    END_DATE
    1
    		2025-04-01 00:00:00.000313.02CowSwap01/01/20232025-04-08 00:00:00.000
    2
    		2025-04-01 00:00:00.0001961.989012658LiFi01/01/20232025-04-08 00:00:00.000
    3
    		2025-04-01 00:00:00.0006629.942632121THORChain01/01/20232025-04-08 00:00:00.000
    4
    		2025-04-01 00:00:00.000134.026045645Portals01/01/20232025-04-08 00:00:00.000
    5
    		2025-04-01 00:00:00.000177.8526373190x01/01/20232025-04-08 00:00:00.000
    6
    		2025-04-01 00:00:00.00012406.210608046ChainFlip01/01/20232025-04-08 00:00:00.000
    7
    		2025-03-01 00:00:00.000538.836441667Cosmos01/01/20232025-04-08 00:00:00.000
    8
    		2025-03-01 00:00:00.0002376.333992401LiFi01/01/20232025-04-08 00:00:00.000
    9
    		2025-03-01 00:00:00.00015637.954885977ChainFlip01/01/20232025-04-08 00:00:00.000
    10
    		2025-03-01 00:00:00.000130.2773456450x01/01/20232025-04-08 00:00:00.000
    11
    		2025-03-01 00:00:00.0003625.47CowSwap01/01/20232025-04-08 00:00:00.000
    12
    		2025-03-01 00:00:00.0001323.613085864Portals01/01/20232025-04-08 00:00:00.000
    13
    		2025-03-01 00:00:00.00030684.957288671THORChain01/01/20232025-04-08 00:00:00.000
    14
    		2025-02-01 00:00:00.0004062.068392003LiFi01/01/20232025-04-08 00:00:00.000
    15
    		2025-02-01 00:00:00.0001126.9CowSwap01/01/20232025-04-08 00:00:00.000
    16
    		2025-02-01 00:00:00.0002197.256795833Cosmos01/01/20232025-04-08 00:00:00.000
    17
    		2025-02-01 00:00:00.00016234.783632ChainFlip01/01/20232025-04-08 00:00:00.000
    18
    		2025-02-01 00:00:00.000501.1988162260x01/01/20232025-04-08 00:00:00.000
    19
    		2025-02-01 00:00:00.00076741.362884237THORChain01/01/20232025-04-08 00:00:00.000
    20
    		2025-02-01 00:00:00.00043.62408567Portals01/01/20232025-04-08 00:00:00.000
    ...
    122
    11KB
    62s