freemartianFarmers KMP
Updated 2022-07-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select user_address, sum(balance), decimals, symbol,
case when user_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd' then 'Stake contract'
else 'Other Holders'
end as holders
from flipside_prod_db.ethereum.erc20_balances
where contract_address in (
'0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89',
'0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50',
'0x561770b93d0530390eb70e17acbbd6e5d2f52a31',
'0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1',
'0x0ea032decbfbea581d77d4a9b9c5e9db7c102a7c',
'0x17fb5f39c55903de60e63543067031ce2b2659ee',
'0x668edab8a38a962d30602d6fa7ca489484ee3224',
'0xf678b4a096bb49309b81b2a1c8a966ef5f9756ba',
'0x3485a7c8913d640245e38564ddc05bfb40104635',
'0x5f92e4300024c447a103c161614e6918e794c764',
'0x418bc3ff0ba33ad64931160a91c92fa26b35acb0'
)
and balance_date = CURRENT_DATE - 1
group by symbol, user_address, decimals, holders
Run a query to Download Data