bryguy2024-07-19 09:37 PM
    Updated 2025-02-01
    SELECT
    block_timestamp,
    tx_hash,
    token0_symbol,
    token1_symbol,
    amount0_adjusted as token0_amount,
    amount1_adjusted as token1_amount,
    amount0_usd,
    amount1_usd,
    sender,
    recipient
    FROM ethereum.uniswapv3.ez_swaps
    WHERE block_timestamp >= DATEADD(day, -30, CURRENT_DATE())
    AND ABS(amount0_usd) > 10000 -- filtering for larger swaps
    ORDER BY block_timestamp DESC
    LIMIT 10;
    QueryRunArchived: QueryRun has been archived