NatGas as a proxy 1/2
Updated 2022-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with gas_sushi as (
select
date_trunc('{{date_filter}}',block_timestamp) as date,
sum(gas_used*gas_price*1e-18) as gas_eth,
count(DISTINCT tx_id) as txn_count,
sum(fee_usd) as fee_in_usd
from ethereum.transactions
where to_label = 'sushiswap'
and block_timestamp::date > '2021-12-31'
group by date
)
select
*
from gas_sushi
order by date
Run a query to Download Data