cryptonomical117ETH_UNI_test
    Updated 2024-05-10
    SELECT
    *
    FROM ethereum.uniswapv3.ez_positions
    WHERE
    BLOCK_NUMBER = 18678134
    -- BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-01'
    LIMIT 10;

    SELECT DISTINCT POOL_NAME, TOKEN0_SYMBOL, TOKEN1_SYMBOL
    FROM ethereum.uniswapv3.ez_positions
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-01'
    ;

    SELECT
    DISTINCT liquidity_provider
    FROM ethereum.uniswapv3.ez_positions
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2023-01-01' AND '2023-12-30'
    ;



    SELECT
    *
    FROM ethereum.uniswapv3.ez_lp_actions
    WHERE
    (token0_symbol = 'USDC' AND token1_symbol = 'USDT') OR
    (token1_symbol = 'USDT' AND token1_symbol = 'USDC')
    LIMIT 100
    ;

    SELECT
    *
    FROM ethereum.uniswapv3.ez_positions
    WHERE
    QueryRunArchived: QueryRun has been archived