AryanGetting Your Feet Wet, Part 1
Updated 2022-03-06
9
1
2
3
4
5
6
7
8
9
›
⌄
(select distinct(tx_to) as wallet_id from terra.transactions as trans1 where trans1.tx_to not like '["terravaloper%' and date(trans1.block_timestamp) >= CURRENT_DATE - 90 and not exists (
(select * from terra.transactions as trans2 where trans2.tx_to not like '["terravaloper%' and date(trans2.block_timestamp) < CURRENT_DATE - 90 and trans1.tx_to=trans2.tx_to)
)
)
INTERSECT (
select distinct(tx_from) as wallet_id from terra.transactions as trans1 where date(trans1.block_timestamp) >= CURRENT_DATE - 90 and not exists (
(select * from terra.transactions as trans2 where trans2.tx_to not like '["terravaloper%' and date(trans2.block_timestamp) < CURRENT_DATE - 90 and trans1.tx_from=trans2.tx_to)
)
)
Run a query to Download Data