ArkanWBTC-WETH swapped volume & count
    Updated 2022-09-27
    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
    )
    ),
    pool_token_details AS (
    SELECT
    pool_name,
    Run a query to Download Data