Updated 2022-03-07
9
1
2
3
4
5
6
7
›
⌄
WITH bountywallets AS (
select distinct address from terra.daily_balances where date =DATE_TRUNC('day', CURRENT_DATE )
EXCEPT
select distinct address from terra.daily_balances where date=DATE_TRUNC('day', CURRENT_DATE - 91)
)
select count(distinct address) from bountywallets