Updated 2022-03-09
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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(*) as transaction_count
from terra.transactions
where (tx_to[0] in (select * from bountywallets) or tx_from[0] in(select * from bountywallets))
and block_timestamp > CURRENT_DATE - 90 ;