flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily and total gas used in the last 90 days
dr1888
Daily and total gas used in the last 90 days
Updated 2023-03-17
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
BLOCK_TIMESTAMP
::
Date
as
BTD
,
sum
(
GAS_USED
)
as
SGU
,
sum
(
SGU
)
over
(
order
by
BTD
)
from
ethereum
.
core
.
fact_transactions
where
TO_ADDRESS
=
lower
(
'0xec568fffba86c094cf06b22134b23074dfe2252c'
)
and
BTD
>=
CURRENT_DATE
-
90
group
by
BTD
Results
Run a query to Download Data