Query editor
SELECT SUM(gas_used*gas_price)::FLOAT/1e18 AS ETH_USED, successFROM ethereum.transactions etWHERE et.to = '\xdd69da9a83cedc730bc4d3c56e96d29acc05ecde'--and value > 0group by success--AND success = FALSE AND value > 0
Query editor
1SELECT SUM(gas_used*gas_price)::FLOAT/1e18 AS ETH_USED, success2FROM ethereum.transactions et3WHERE et.to = '\xdd69da9a83cedc730bc4d3c56e96d29acc05ecde'4--and value > 05group by success6--AND success = FALSE AND value > 0