0xbrun0wallet millionaries token balance -todo
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with ethereum_wallet_millionaire as (
select
distinct address
from crosschain.core.address_tags
where tag_name = 'wallet millionaire'
and creator = 'flipside'
and blockchain = 'ethereum'
),
balances as (
select
user_address,
contract_address,
balance,
ROW_NUMBER() OVER (
PARTITION BY
user_address, contract_address
ORDER BY
block_timestamp DESC
) AS row_num
from
ethereum.core.fact_token_balances
qualify
row_num = 1
)
select
tag_name,
count(distinct address) as num_addresses
from ethereum.core.fact_token_balances
where
address in (select distinct address from ethereum_wallet_millionaire)
Run a query to Download Data