flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
BECOME A PARTNER
flipside
Untitled Query
rackhael
Untitled Query
Updated 2023-01-18
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
count
(
tx_id
)
as
transactions
,
sum
(
amount
)
,
pool_address
from
terra
.
core
.
fact_lp_actions
group
by
date
,
pool_address
Results
Run a query to Download Data