flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Mega Terra Wallets 1
mattkstew
Mega Terra Wallets 1
Updated 2023-01-04
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with
tab1
as
(
select
tx_sender
,
min
(
block_timestamp
)
as
min_date
from
terra
.
core
.
fact_transactions
group
by
1
)
select
date_trunc
(
'week'
,
min_date
)
as
date1
,
count
(
*
)
as
value
from
tab1
group
by
1
order
by
1
Results
Run a query to Download Data