Abbas_ra21Aave Delegates Votes 3
Updated 2023-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
-- forked from 0cb1ae19-ae95-40df-9f8c-c1dd8d3f7ca3
with
tb AS (
select
TX_HASH
from
ethereum.aave.ez_votes
)
select
GAS_PRICE AS "Gas Price (Gwei)",
sum(TX_FEE) AS "Generated Fee (ETH)",
sum(GAS_USED/1e9) AS "Used GAS"
from
ethereum.core.fact_transactions
where
TX_HASH in (
Select
TX_HASH
from
tb
) and BLOCK_TIMESTAMP >= Dateadd('Day',-180,current_date)
group by
1
Run a query to Download Data