flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
#3 Thorchain Active Wallets:LP
zakkisyed
#3 Thorchain Active Wallets:LP
Updated 2024-01-14
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc
(
week
,
block_timestamp
)
as
date
,
count
(
distinct
from_address
)
as
total_count
from
flipside_prod_db
.
thorchain
.
liquidity_actions
where
LP_ACTION
=
'add_liquidity'
and
block_timestamp
>=
CURRENT_DATE
-
90
group
by
1
order
by
1
desc
Results
QueryRunArchived: QueryRun has been archived