adambalaDaily Gas Fees on Uniswap and SushiSwap
Updated 2022-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH sushi AS (SELECT DATE(block_timestamp) as date, avg(tx_fee) as avg_gas_fee_in_eth_sushi
FROM ethereum.transactions
WHERE to_label ='sushiswap' AND DATE(block_timestamp) BETWEEN '2021-12-01' AND '2022-01-31'
GROUP BY date
ORDER BY date),
uni AS (SELECT DATE(block_timestamp) as date, avg(tx_fee) as avg_gas_fee_in_eth_uni
FROM ethereum.transactions
WHERE to_label ='uniswap' AND DATE(block_timestamp) BETWEEN '2021-12-01' AND '2022-01-31'
GROUP BY date
ORDER BY date)
SELECT sushi.date as date, avg_gas_fee_in_eth_sushi, avg_gas_fee_in_eth_uni
FROM sushi JOIN uni ON sushi.date = uni.date
ORDER BY date
Run a query to Download Data