flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
txn4
MLDZMN
txn4
Updated 2023-07-21
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'{{Time_basis}}'
,
BLOCK_TIMESTAMP
)
as
date
,
STATUS
,
count
(
distinct
tx_hash
)
as
no_txn
from
aurora
.
core
.
fact_transactions
group
by
1
,
2
having
STATUS
is
not
null
Results
Run a query to Download Data