bryguy2024-07-19 09:37 PM
Updated 2025-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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