flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Top 20 contracts with the highest spending gas (over past month)
kasadegh
Top 20 contracts with the highest spending gas (over past month)
Updated 2022-07-27
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
TX_RECEIVER
as
contract
,
sum
(
GAS_USED
)
/
POW
(
10
,
12
)
as
Total_fee
from
near
.
core
.
fact_transactions
where
BLOCK_TIMESTAMP
::
date
>=
DATEADD
(
day
,
-
30
,
CURRENT_DATE
)
group
by
TX_RECEIVER
order
by
2
desc
limit
20
Results
Run a query to Download Data