KeyrockPolygon_token_balance
Updated 2024-04-09
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
polygon.defi.dim_dex_liquidity_pools
WHERE
-- TOKEN0_BALANCE_USD IS NOT NULL
-- AND TOKEN1_BALANCE_USD IS NOT NULL
POOL_ADDRESS = '0x13c6656a9a7c136ab651fa331e9264223f5bf9e4'
-- GROUP BY DAY
-- ORDER BY day DESC;
QueryRunArchived: QueryRun has been archived