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