flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
distinct addresses
CryptoLion
distinct addresses
Updated 2023-03-27
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc
(
'month'
,
block_timestamp
)
as
month
,
count
(
DISTINCT
borrower
)
as
distinct_addresses
,
repay_contract_symbol
FROM
compound
.
repayments
WHERE
block_timestamp
>=
getdate
(
)
-
interval
'1 year'
GROUP
BY
month
,
repay_contract_symbol
Results