KeyrockETH_token_balance
Updated 2024-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
AVG(token0_balance_usd + token1_balance_usd) as daily_tvl,
CASE
WHEN AVG(token0_balance_usd + token1_balance_usd) = 0 THEN NULL
ELSE AVG(token0_balance_usd) / AVG(token0_balance_usd + token1_balance_usd)
END as base_token,
CASE
WHEN AVG(token0_balance_usd + token1_balance_usd) = 0 THEN NULL
ELSE AVG(token1_balance_usd) / AVG(token0_balance_usd + token1_balance_usd)
END 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 = '0x13c6656a9a7c136ab651fa331e9264223f5bf9e4'
GROUP BY DAY
ORDER BY day DESC;
QueryRunArchived: QueryRun has been archived