alitaslimiPools Liquidity Overview
    Updated 2022-07-30
    WITH
    prices AS (
    SELECT
    symbol AS token,
    decimals,
    AVG(price) AS price
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    hour BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1)
    AND (symbol IN ('WBTC', 'WETH', 'USDC', 'LINK', 'GNO') OR token_address = '0xc770eefad204b5180df6a14ee197d99d808ee52d')
    GROUP BY
    token,
    decimals
    ),
    inflows AS (
    SELECT
    CASE
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x8e5bbbb09ed1ebde8674cda39a0c169401db4252' THEN 'WBTC'
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1' THEN 'WETH'
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xddafbb505ad214d7b80b1f830fccc89b60fb7a83' THEN 'USDC'
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0xe2e73a1c69ecf83f464efce6a5be353a37ca09b2' THEN 'LINK'
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x9c58bacc331c9aa871afd802db6379a98e80cedb' THEN 'GNO'
    WHEN COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve) = '0x21a42669643f45bc0e086b8fc2ed70c23d67509d' THEN 'FOX'
    ELSE COALESCE(event_inputs:token, event_inputs:vault, event_inputs:reserve)
    END AS token,
    SUM(event_inputs:amount) AS amount
    FROM
    gnosis.core.fact_event_logs
    WHERE
    block_timestamp::date BETWEEN (CURRENT_DATE - 31) AND (CURRENT_DATE - 1) AND event_removed = FALSE AND tx_status = 'SUCCESS'
    AND origin_to_address = '0x5e15d5e33d318dced84bfe3f4eace07909be6d9c' AND contract_address = origin_to_address
    AND event_name IN ('Deposit', 'Repay')
    GROUP BY
    token
    ),
    Run a query to Download Data