@slash125 / ETH pool historical + 14d projected liquidity
@slash125About queries and results
Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.
We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.
Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.
SQL query results
SQL query
1WITH projected_eth as ( WITH supply AS (
2WITH eth_liq as (with inn as ( SELECT call_block_time as "date", output_mint/10e17 as value from hegic."HegicETHPool_call_provide"
3WHERE call_success = true
4 ORDER by call_block_time ASC),
5out as (
6
7SELECT call_block_time as "date", -output_burn/10e17 as value from hegic."HegicETHPool_call_withdraw" p
8WHERE call_success = true
9 ORDER by call_block_time ASC
10),
11
12merge as (
13 SELECT * from inn
14 UNION
15 SELECT * from out
16 ORDER by "date" ASC)
17
18 SELECT
19 a."date",
20 a.value as
21 "writeETH"
22 FROM merge AS a
23 )
24
25...