adambalaTop TOKE Holders
Updated 2022-06-23
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
33
34
35
36
›
⌄
with
a as (
select distinct user_address,
max(balance) as balance
from flipside_prod_db.ethereum.erc20_balances
where LOWER(contract_address) = LOWER('0x2e9d63788249371f1dfc918a52f8d799f4a38c94')
and balance_date between '2022-01-01' and '2022-01-31'
and label is null
group by 1
order by 2 desc
limit 20
),
now as (
select
user_address ,
balance ,
amount_usd
from ethereum.erc20_balances
where lower(contract_address) = lower('0x2e9d63788249371f1dfc918a52f8d799f4a38c94' )
and balance_date::date = current_date - 1
and user_address in ( select user_address from a)
),
b as (
select
now.user_address,
now.balance as now,
a.balance as past
from now inner join a on NOW.user_address=A.user_address
group by 1,2,3
)
select
count(distinct user_address) as holders,
case when now > past then 'add more TOKE'
Run a query to Download Data