flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
The top ten Gas Guzzlers contract over the last month
princefarzam
The top ten Gas Guzzlers contract over the last month
Updated 2022-07-27
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
TX_RECEIVER
AS
Contracts
,
Sum
(
GAS_USED
)
/
1e12
AS
Total_Gas_Used
FROM
flipside_prod_db
.
mdao_near
.
transactions
WHERE
BLOCK_TIMESTAMP
::
DATE
>=
CURRENT_DATE
-
30
GROUP
BY
Contracts
ORDER
BY
Total_Gas_Used
DESC
LIMIT
10
Results
Run a query to Download Data