Sandesh1. forefront Top 10 holders
Updated 2022-03-30
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
›
⌄
with forefront_table_latest as
(
select * from ethereum.erc20_balances
where contract_address='0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
and balance_date = '2022-03-29'
),
top10 as
(
select USER_ADDRESS,balance from forefront_table_latest
order by amount_usd DESC
limit 10
)
select user_address,balance, balance/100000 as "percentage",
case
when user_address='0x2fb9f0ef424b24a8d293999298f392a33fe6a8b5' then 'Treasury'
when user_address='0xc22103115ea757c427788622880be6afb8a4eb64' then 'Team tokens'
when user_address='0xfe3ea7f424b3cdfe2a3cfeccebc8f4114c955858' then 'Team tokens'
when user_address='0xc5d5c20ee7ec75292fc58c44972120d403e0decf' then 'Address'
when user_address='0x52544e5a0c02925eaf874fc539b7717619de0825' then 'Address'
when user_address='0xd61dbd8ad20de957a7ff9ad4be0782f335cdb688' then 'Address'
when user_address='0x0028ce89ff53fecc0708000cc9ca8962f3c43b25' then 'Address'
when user_address='0xd069efa415ef5113598b36619305dbf88dcd363e' then 'Parnter'
when user_address='0xc8f2cda4243d365db018d5b5207dea5ef200d29f' then 'Parnter'
when user_address='0x70b0969a069516e117aa777fc87b819d0334a419' then 'Contract'
else 'Unknown'
end as "Type of holder"
from top10
Run a query to Download Data