Delamir-6014Ethereum Educational Bounty03
    Updated 2022-09-22
    WITH
    pools AS (
    SELECT
    pool_name,
    pool_address,
    token0,
    token1
    FROM ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
    WHERE pool_address = LOWER('0xceff51756c56ceffca006cd410b03ffc46dd3a58')),
    decimals AS (
    SELECT
    address,
    symbol,
    decimals
    FROM
    ETHEREUM_CORE.DIM_CONTRACTS
    WHERE
    address = (
    SELECT
    LOWER(token1)
    FROM
    pools
    )
    OR address = (
    SELECT
    LOWER(token0)
    FROM
    pools
    )
    )
    SELECT
    pool_name,
    pool_address,
    token0,
    token1,
    token0.symbol AS token0symbol,
    Run a query to Download Data