flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
AlgoDEX transactions
zakkisyed
AlgoDEX transactions
Updated 2022-07-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
BLOCK_TIMESTAMP
::
DATE
AS
DATE
,
COUNT
(
DISTINCT
(
tx_id
)
)
AS
Transactions
,
sum
(
FEE
)
as
fee
from
flipside_prod_db
.
algorand
.
application_call_transaction
where
app_id
in
(
'354073718'
,
'354073834'
)
GROUP
BY
DATE
ORDER
BY
DATE
ASC
Results
Run a query to Download Data