flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2023-02-03 02:58 PM
Afonso_Diaz
2023-02-03 02:58 PM
Updated 2023-02-03
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
t1
as
(
select
tx_sender
,
min
(
block_timestamp
)
as
min_date
from
terra
.
core
.
fact_transactions
group
by
1
)
select
avg
(
datediff
(
day
,
min_date
,
current_date
)
)
as
average_wallets_age
from
t1
Results
Run a query to Download Data