saeide-ahmadi-7Top TOKE Holders in January
Updated 2022-06-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH max_balance_per_day as (
SELECT
BALANCE_DATE ,
max(balance) as top_amount
FROM
ETHEREUM.ERC20_BALANCES
where
symbol = 'TOKE'
and BALANCE > 0
AND BALANCE_DATE >= '2022-01-01' and BALANCE_DATE <= '2022-01-31'
group by BALANCE_DATE)
SELECT
ETHEREUM.ERC20_BALANCES.BALANCE_DATE AS date_,
USER_ADDRESS as top_holder,
balance as toke_amount,
amount_usd as toke_amount_in_usd
FROM
ETHEREUM.ERC20_BALANCES
INNER JOIN max_balance_per_day on ETHEREUM.ERC20_BALANCES.balance = max_balance_per_day.top_amount
and ETHEREUM.ERC20_BALANCES.BALANCE_DATE = max_balance_per_day.BALANCE_DATE
ORDER BY date_
Run a query to Download Data