nitsActive Whales on Alert
Updated 2022-11-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with whales as
(SELECT
DISTINCT user_address as ua
from ethereum.erc20_balances
where contract_address = 'ETH' and balance >= 100
and balance_date = CURRENT_DATE - 1)
SELECT DISTINCT origin_from_address as active_whales
from ethereum.core.ez_eth_transfers
WHERE
origin_from_address in (SELECT * from whales) and
block_timestamp >= CURRENT_DATE -90
-- GROUP by 1
-- limit 100
Run a query to Download Data