TS | SWAP_VOLUME | |
|---|---|---|
1 | 2024-01-30 00:00:00.000 | 2503663.83 |
2 | 2024-01-29 00:00:00.000 | 15187537.595 |
3 | 2024-01-28 00:00:00.000 | 4379254.955 |
4 | 2024-01-27 00:00:00.000 | 6460551.25 |
5 | 2024-01-26 00:00:00.000 | 16519944.815 |
6 | 2024-01-25 00:00:00.000 | 13544753.845 |
7 | 2024-01-24 00:00:00.000 | 6106793.39 |
8 | 2024-01-23 00:00:00.000 | 43206671.75 |
9 | 2024-01-22 00:00:00.000 | 14777833.1 |
10 | 2024-01-21 00:00:00.000 | 2058190.08 |
11 | 2024-01-20 00:00:00.000 | 3994481.31 |
12 | 2024-01-19 00:00:00.000 | 14120872.6 |
13 | 2024-01-18 00:00:00.000 | 11158707.845 |
14 | 2024-01-17 00:00:00.000 | 7540678.65 |
15 | 2024-01-16 00:00:00.000 | 10943083.57 |
16 | 2024-01-15 00:00:00.000 | 10598569.94 |
17 | 2024-01-14 00:00:00.000 | 18971663.765 |
18 | 2024-01-13 00:00:00.000 | 26263097.495 |
19 | 2024-01-12 00:00:00.000 | 102835158.79 |
20 | 2024-01-11 00:00:00.000 | 75823517.35 |
KeyrockDaily Volume Overtime
Updated 2024-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from andreafiandro / Hourly Volume overtime @ https://flipsidecrypto.xyz/andreafiandro/q/uVW8x51OzS3I/hourly-volume-overtime
SELECT *
FROM
(SELECT
date_trunc('day', block_timestamp) AS ts,
COALESCE(SUM((ABS(amount1_usd)+ABS(amount0_usd))/2), 0) AS swap_volume
FROM ethereum.uniswapv3.ez_swaps
WHERE
POOL_ADDRESS = '{{pool_address}}'
GROUP BY 1
)
ORDER BY ts DESC
Last run: over 1 year ago
...
1002
39KB
2s