Delamir-6014 USDC Volume in Sushi WBTC-WETH compared with WETH-USDC
    Updated 2022-09-22
    WITH
    pools_WETH AS (
    SELECT
    pool_name as pool_name_WETH,
    pool_address as pool_address_WETH ,
    token0 as token0_WETH,
    token1 as token1_WETH
    FROM
    ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
    WHERE
    pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')
    ),
    pools_WBTC AS (
    SELECT
    pool_name as pool_name_WBTC,
    pool_address as pool_address_WBTC ,
    token0 as token0_WBTC,
    token1 as token1_WBTC
    FROM
    ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS
    WHERE
    pool_address = LOWER('0xceff51756c56ceffca006cd410b03ffc46dd3a58')
    ),
    -- dddd
    decimals_WETH AS (
    SELECT
    address as address_WETH,
    symbol as symbol_WETH,
    decimals as decimals_WETH
    FROM
    ETHEREUM_CORE.DIM_CONTRACTS
    WHERE
    address = (
    SELECT
    LOWER(token1_WETH)
    FROM
    Run a query to Download Data