BLOCK_TIMESTAMP | TOKEN0_DOLLAR_BAL | TOKEN1_DOLLAR_BAL | |
|---|---|---|---|
1 | 2024-02-08 00:00:00.000 | 1024328.47 | 985879.71 |
2 | 2024-02-07 00:00:00.000 | 2209323.46 | 1694578.49 |
3 | 2024-02-06 00:00:00.000 | 2793952.21 | 1880643.27 |
4 | 2024-02-05 00:00:00.000 | 1591481.42 | 1518493.99 |
5 | 2024-02-04 00:00:00.000 | 1311646.67 | 1433178.33 |
6 | 2024-02-03 00:00:00.000 | 1298418.4 | 1327903.35 |
7 | 2024-02-02 00:00:00.000 | 2307319.23 | 2264611.11 |
8 | 2024-02-01 00:00:00.000 | 1961764.67 | 1753898.01 |
9 | 2024-01-31 00:00:00.000 | 2496511.39 | 3200157.05 |
10 | 2024-01-30 00:00:00.000 | 2552136.91 | 2296260.43 |
11 | 2024-01-29 00:00:00.000 | 3504513.62 | 2797745.43 |
12 | 2024-01-28 00:00:00.000 | 1854717.78 | 2063453.56 |
13 | 2024-01-27 00:00:00.000 | 1087987.61 | 1064819.88 |
14 | 2024-01-26 00:00:00.000 | 2443864.8 | 1911540.05 |
15 | 2024-01-25 00:00:00.000 | 2100404.6 | 2227792.71 |
16 | 2024-01-24 00:00:00.000 | 2091174.98 | 2178293.11 |
17 | 2024-01-23 00:00:00.000 | 4537696.07 | 5287203.15 |
18 | 2024-01-22 00:00:00.000 | 2935711.98 | 4474858.04 |
19 | 2024-01-21 00:00:00.000 | 1049051.88 | 1164279.07 |
20 | 2024-01-20 00:00:00.000 | 1220323.04 | 1455530.86 |
KeyrockUniv2 Volume
Updated 2024-02-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc -- usdc/eth
0xa43fe16908251ee70ef74718545e4fe6c5ccec9f --pepe/eth
*/
WITH pool_info AS (
SELECT
RIGHT(LEFT(CAST(DECIMALS AS VARCHAR), 12), 2) AS token0_dec,
LEFT(RIGHT(CAST(DECIMALS AS VARCHAR), 3), 2) AS token1_dec,
RIGHT(LEFT(CAST(TOKENS AS VARCHAR), 53), 42) AS token0_addy,
LEFT(RIGHT(CAST(TOKENS AS VARCHAR), 44), 42) AS token1_addy
FROM
ethereum.defi.dim_dex_liquidity_pools
WHERE
POOL_ADDRESS = '{{Univ2_pool_contract}}'
),
CTE_0 AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS block_timestamp,
SUM(amount_out_usd) AS total_amount_out0
FROM
ethereum.defi.ez_dex_swaps AS swap
JOIN pool_info AS pi ON swap.token_in = pi.token0_addy
WHERE
swap.contract_address = '{{Univ2_pool_contract}}'
GROUP BY
DATE_TRUNC('day', BLOCK_TIMESTAMP)
),
CTE_1 AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS block_timestamp,
SUM(amount_out_usd) AS total_amount_out1
FROM
ethereum.defi.ez_dex_swaps AS swap
JOIN pool_info AS pi ON swap.token_in = pi.token1_addy
WHERE
swap.contract_address = '{{Univ2_pool_contract}}'
Last run: over 1 year ago
...
769
37KB
5s