flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-07-17 11:16 AM
adriaparcerisas
2023-07-17 11:16 AM
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
distinct
receiver
,
project_name
,
min
(
block_timestamp
)
as
debut
,
count
(
distinct
tx_id
)
as
counts
from
osmosis
.
core
.
fact_transfers
x
join
osmosis
.
core
.
dim_labels
y
on
receiver
=
address
group
by
1
,
2
having
debut
>
'2023-01-01'
order
by
3
desc
Results
Run a query to Download Data