Skip to content
Dune Analytics

@phabc / Chi - Gas in USD

SQL query

1select 
2    sum(t.gas_used * t.gas_price / 1e18 * (SELECT price FROM prices.usd WHERE symbol = 'ETH' ORDER BY minute desc LIMIT 1)) as total_in,
3    sum(t.gas_used / 12000000) as blocks_gas_used,
4    sum(t.gas_used / 12000000 * 15 / 60 / 60) as hours_used
5from ethereum.transactions t
6where t."to" =  '\x0000000000004946c0e9F43F4Dee607b0eF1fA1c'
7and t.block_number >= 10130724

SQL query results

Loading