PierandreaLiquidity Pools Active
    WITH POOLS AS (
    SELECT
    LEFT(date_trunc('day', CREATION_TIME), 10) AS DATE_OF_CREATION,
    POOL_NAME,
    POOL_ADDRESS,
    PLATFORM,
    TOKEN0,
    TOKEN1
    FROM
    ethereum.core.dim_dex_liquidity_pools
    WHERE
    TOKEN0_SYMBOL = {{TOKEN}}
    OR TOKEN1_SYMBOL = {{TOKEN}}
    ),
    LIQUIDITY0 AS (
    SELECT
    CURRENT_BAL AS TOKEN0_BAL,
    USD_VALUE_NOW AS TOKEN0_USD,
    USER_ADDRESS,
    CONTRACT_ADDRESS
    FROM
    ethereum.core.ez_current_balances
    ),
    LIQUIDITY1 AS (
    SELECT
    CURRENT_BAL AS TOKEN1_BAL,
    USD_VALUE_NOW AS TOKEN1_USD,
    USER_ADDRESS,
    CONTRACT_ADDRESS
    FROM
    ethereum.core.ez_current_balances
    ),

    TOT AS (
    SELECT
    POOL_NAME,
    Run a query to Download Data