flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2023-05-30 03:08 PM
jj_notgei
2023-05-30 03:08 PM
Updated 2023-06-02
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date
(
BLOCK_TIMESTAMP
)
as
datetime
,
sum
(
GAS_USED
)
/
1000000
as
gas_used
-- sum(FEE)/1000000 as fee_paid
from
evmos
.
core
.
fact_transactions
where
TX_SUCCEEDED
=
'true'
and
date
(
BLOCK_TIMESTAMP
)
>=
'2023-01-01'
group
by
1
Results
Run a query to Download Data