DAY | DAILY_TVL | BASE_TOKEN | PAIR_TOKEN | |
|---|---|---|---|---|
1 | 2024-02-09 00:00:00.000 | 55000088.8937528 | 0.3404446771 | 0.6595553229 |
2 | 2024-02-08 00:00:00.000 | 55454209.1543377 | 0.3530456361 | 0.6469543639 |
3 | 2024-02-07 00:00:00.000 | 56662195.0572826 | 0.377459356 | 0.622540644 |
4 | 2024-02-06 00:00:00.000 | 58233063.3197391 | 0.4079823027 | 0.5920176973 |
5 | 2024-02-05 00:00:00.000 | 55289361.7591768 | 0.4641760509 | 0.5358239491 |
6 | 2024-02-04 00:00:00.000 | 54084959.9400552 | 0.4646029951 | 0.5353970049 |
7 | 2024-02-03 00:00:00.000 | 54312838.9122443 | 0.4528834151 | 0.5471165849 |
8 | 2024-02-02 00:00:00.000 | 54715812.2327727 | 0.4582202294 | 0.5417797706 |
9 | 2024-02-01 00:00:00.000 | 54371324.0715759 | 0.4776456335 | 0.5223543665 |
10 | 2024-01-31 00:00:00.000 | 54083119.7221719 | 0.4422325239 | 0.5577674761 |
11 | 2024-01-30 00:00:00.000 | 53705275.1489266 | 0.443221182 | 0.556778818 |
12 | 2024-01-29 00:00:00.000 | 57130716.0396608 | 0.5059343417 | 0.4940656583 |
13 | 2024-01-28 00:00:00.000 | 59036880.8151661 | 0.5066629865 | 0.4933370135 |
14 | 2024-01-27 00:00:00.000 | 59178379.9651493 | 0.5120408528 | 0.4879591472 |
15 | 2024-01-26 00:00:00.000 | 58642990.1637262 | 0.5310904388 | 0.4689095612 |
16 | 2024-01-25 00:00:00.000 | 58428008.0309875 | 0.5535884288 | 0.4464115712 |
17 | 2024-01-24 00:00:00.000 | 58662708.7541053 | 0.5382090916 | 0.4617909084 |
18 | 2024-01-23 00:00:00.000 | 58508282.603145 | 0.5195752194 | 0.4804247806 |
19 | 2024-01-22 00:00:00.000 | 58251098.2178911 | 0.4232360468 | 0.5767639532 |
20 | 2024-01-21 00:00:00.000 | 54340989.5845062 | 0.3826756896 | 0.6173243104 |
KeyrockTVL Overtime (per pool)
Updated 2024-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
AVG(token0_balance_usd + token1_balance_usd) as daily_tvl,
AVG(token0_balance_usd) / AVG(token0_balance_usd + token1_balance_usd) as base_token,
AVG(token1_balance_usd) / AVG(token0_balance_usd + token1_balance_usd) as pair_token
FROM
ethereum.uniswapv3.ez_pool_stats
WHERE
TOKEN0_BALANCE_USD IS NOT NULL
AND TOKEN1_BALANCE_USD IS NOT NULL
AND POOL_ADDRESS = '{{pool_address}}'
GROUP BY DAY
ORDER BY day DESC;
Last run: about 1 year ago
...
1011
70KB
3s