flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
User segmentation_analy1.3
sarath
User segmentation_analy1.3
Updated 2023-01-02
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
top
10
date_trunc
(
'week'
,
block_timestamp
)
,
Substring
(
sender
,
0
,
charindex
(
'1'
,
sender
)
-
1
)
as
Chain
,
count
(
*
)
from
osmosis
.
core
.
fact_transfers
where
transfer_type
like
'IBC_TRANSFER_IN'
group
by
1
,
2
Results
Run a query to Download Data