boomer77$LDO top airdrop
Updated 2022-05-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with holder as (select user_address, label, address_name, symbol, balance, amount_usd
from ethereum.erc20_balances
where balance_date = CURRENT_DATE - 1 and contract_address = lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32')
order by balance desc
limit 15),
airdrop as (select to_address, sum(raw_amount/1e18) as token_airdrop
from ethereum_core.fact_token_transfers
where from_address = lower('0xf73a1260d222f447210581ddf212d915c09a3249')
group by 1)
select a.user_address, a.balance, b.token_airdrop
from holder a
left join airdrop b on a.user_address = b.to_address
Run a query to Download Data