kaibladeTotal value locked of oSQETH token in Uniswap LPs
Updated 2022-06-30
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
›
⌄
WITH streamlined_data AS (
SELECT MAX(block_timestamp) AS recent_timestamp, pool_address, pool_name
FROM flipside_prod_db.uniswapv3.pool_stats
WHERE
token0_symbol = 'oSQTH'
OR
token1_symbol = 'oSQTH'
GROUP BY pool_name, pool_address
),
expanded_data AS (
SELECT
stats.block_timestamp,
stream.pool_name,
stream.pool_address,
(CASE
WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_balance_adjusted
WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_balance_adjusted
END
) AS osqth_balance,
(CASE
WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_address
WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_address
END
) AS osqth_address,
(CASE
WHEN stats.token1_symbol = 'oSQTH' THEN stats.token1_balance_usd
WHEN stats.token0_symbol = 'oSQTH' THEN stats.token0_balance_usd
END
) AS osqth_balance_usd
FROM flipside_prod_db.uniswapv3.pool_stats stats
JOIN streamlined_data stream
Run a query to Download Data