YellowCumulative & Average gas of UNI & SUSHI
Updated 2022-04-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH uniswap AS (
SELECT SUM(gas_price) AS sum, AVG(gas_price) AS avg FROM ethereum.transactions
WHERE
DATEDIFF(DAY, block_timestamp, CURRENT_TIMESTAMP) <= 60
AND (
LOWER(to_address) = LOWER('0xE592427A0AEce92De3Edee1F18E0157C05861564')
OR LOWER(to_address) = LOWER('0x7a250d5630B4cF539739dF2C5dAcb4c659F2488D')
OR LOWER(to_address) = LOWER('0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45')
)
),
sushiswap AS (
SELECT SUM(gas_price) AS sum, AVG(gas_price) AS avg FROM ethereum.transactions
WHERE DATEDIFF(DAY, block_timestamp, CURRENT_TIMESTAMP) <= 60 AND
LOWER(to_address) = LOWER('0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F')
)
SELECT uniswap.sum AS "uniswap cumulative gas", sushiswap.sum AS "sushiswap cumulative gas",
uniswap.avg AS "uniswap average gas", sushiswap.avg AS "sushiswap average gas"
FROM uniswap, sushiswap;
Run a query to Download Data