flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Unique transactions LP by action
Madi
Unique transactions LP by action
Updated 2022-10-20
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
DATE_TRUNC
(
'month'
,
BLOCK_TIMESTAMP
)
as
date
,
ACTION
,
COUNT
(
DISTINCT
TX_ID
)
as
TX_COUNT
FROM
osmosis
.
core
.
fact_liquidity_provider_actions
group
by
date
,
action
Results
Run a query to Download Data