misaghlbtmp Total Value Locked - Opyn Squeeth (osQETH)
Updated 2022-06-28
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
osqthwethv3vol AS (
SELECT date_trunc('day', BLOCK_TIMESTAMP) AS day, SUM(AMOUNT_IN_USD) as volume
FROM ethereum.core.ez_dex_swaps
WHERE TOKEN_IN in ('0x82c427adfdf2d245ec51d8046b41c4ee87f0d29c')
group by 1
order by 1, 2 desc
),
osqthwethv3_eth_reserves AS (
SELECT
BALANCE_DATE,
BALANCE,
AMOUNT_USD
FROM flipside_prod_db.ethereum.erc20_balances
WHERE USER_ADDRESS = '0x82c427adfdf2d245ec51d8046b41c4ee87f0d29c'
AND CONTRACT_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
),
osqthwethv3_osqth_reserves AS (
SELECT
BALANCE_DATE,
BALANCE,
AMOUNT_USD
FROM flipside_prod_db.ethereum.erc20_balances
WHERE USER_ADDRESS = '0x82c427adfdf2d245ec51d8046b41c4ee87f0d29c'
AND CONTRACT_ADDRESS = '0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b'
)
SELECT
dtv.day,
volume AS "Volume",
ethReserves.BALANCE AS "ethReserves",
osqthReserves.BALANCE AS "osqthReserves",
ethReserves.AMOUNT_USD AS "ethReserves_usd",
osqthReserves.AMOUNT_USD AS "osqthReserves_usd",
(ethReserves.AMOUNT_USD + osqthReserves.AMOUNT_USD) AS "TVL",
osqthReserves.AMOUNT_USD / (ethReserves.AMOUNT_USD + osqthReserves.AMOUNT_USD) AS osqthpct,
Run a query to Download Data