flipside

    Liquidity Pool Total Deposit (USD)
    RayyykLiquidity Pool Total Deposit (USD)
    Updated 4 hours ago
    --weth/fox eth
    with res1 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/b99c9a5e-7387-4520-a4d8-e3529bb935a7/data/latest') as result),

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

    table_1 as (select to_timestamp(value:DAY) as date,
    'Ethereum' as chain,
    'WETH/FOX' as pool,
    'ETH' as other_asset_name,
    value:"ETH Deposit USD" as asset_deposit_usd,
    value:"FOX Deposit USD" as fox_deposit_usd,
    value:"ETH Withdraw USD" as asset_withdraw_usd,
    value:"FOX Withdraw USD" as fox_withdraw_usd
    from data1,
    LATERAL FLATTEN(input => data1.json_result_must_pivot::VARIANT) d
    where date < current_date),

    --gix/fox eth
    res2 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/f9e797a1-452b-4b6b-8634-4ea6cebeec79/data/latest') as result),

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

    table_2 as (select to_timestamp(value:DAY) as date,
    'Ethereum' as chain,
    'GIV/FOX' as pool,
    'GIV' as other_asset_name,
    value:"GIV Deposit USD" as asset_deposit_usd,
    value:"FOX Deposit USD" as fox_deposit_usd,
    value:"GIV Withdraw USD" as asset_withdraw_usd,
    value:"FOX Withdraw USD" as fox_withdraw_usd
    from data2,
    LATERAL FLATTEN(input => data2.json_result_must_pivot::VARIANT) d
    where date < current_date),

    --weth/fox polygon
    res3 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/6957951d-5ab1-418d-b168-6df4211029e0/data/latest') as result),
    Last run: about 4 hours agoAuto-refreshes every 24 hours
    CHAIN
    POOL
    Total Deposit (3 Days)
    Total Deposit (7 Days)
    Total Deposit (30 Days)
    Total Deposit (90 Days)
    1
    		ArbitrumWETH/FOX V3🟡 0🟡 0🟢 259.397573367🟢 1113.965807912
    2
    		ArbitrumWETH/FOX V2🟢 366.205905317🟢 1487.00308167🟢 5300.481103287🟢 39827.875538163
    3
    		EthereumGIV/FOX🟡 0🟡 0🟡 0🟡 0
    4
    		EthereumWETH/FOX🟡 0🟢 221.46735898🟢 158284.858189551🟢 410811.611222327
    5
    		GnosisHNY/FOX🟡 0🟡 0🟡 0🟡 0
    6
    		GnosisGIV/FOX🟡 0🟡 0🟡 0🟡 0
    7
    		GnosiswxDAI/FOX🟡 0🟡 0🟡 0🟢 150.671694133
    8
    		PolygonWETH/FOX🟡 0🟡 0🟢 0.3318191617🟢 0.3318191617
    9
    		THORChainRUNE/FOX🟡 0🟡 0🟡 0🟢 2896.548395165
    9
    703B
    88s