Skip to content
Dune Analytics

@p0s / Wasted ETH

ETH wasted by failed tx per DEXWasted ETH


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


SQL query

3when ethereum."transactions".to = '\x7a250d5630B4cF539739dF2C5dAcb4c659F2488D' THEN 'uniswapV2'
4when ethereum."transactions".to = '\x11111254369792b2Ca5d084aB5eEA397cA8fa48B' THEN '1inch'
5when ethereum."transactions".to in ('\x9AAb3f75489902f3a48495025729a0AF77d4b11e', '\x818E6FECD516Ecc3849DAf6845e3EC868087B755') THEN 'kyber'
6when ethereum."transactions".to = '\xdc6c91b569c98f9f6f74d90f9beff99fdaf4248b' THEN 'tokenlon'
7when ethereum."transactions".to = '\x6317C5e82A06E1d8bf200d21F4510Ac2c038AC81' THEN 'balancer'
8end as exchange,
9sum(gas_used * gas_price) / 10^18 as "ETH wasted"
10from ethereum."transactions"
11where ethereum."transactions".to IN (
12'\x7a250d5630B4cF539739dF2C5dAcb4c659F2488D', -- uniswap router02
13'\x11111254369792b2Ca5d084aB5eEA397cA8fa48B', -- 1inch
14'\x9AAb3f75489902f3a48495025729a0AF77d4b11e', -- kyber1
15'\x818E6FECD516Ecc3849DAf6845e3EC868087B755', -- kyber2
16'\x6317C5e82A06E1d8bf200d21F4510Ac2c038AC81', -- balancer
17'\xdc6c91b569c98f9f6f74d90f9beff99fdaf4248b' -- tokenlon
19and success = false
20group by ethereum."transactions".to