Skip to content
Dune Analytics

@slash125 / ETH pool historical + 14d projected liquidity

ETH pool historical + 14d projected liquidity

Loading
 

About 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

Loading
 

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...