2844Untitled Query
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select b.date,b."Holded Tokes", t.Wallets,t.amount
from (select USER_ADDRESS As Wallets, sum(balance) as amount
from ethereum.erc20_balances
where contract_address = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
and balance >= 100000
and balance_date between '2022-01-01' and '2022-01-31'
group by Wallets
order by amount DESC) as t,
(select BALANCE_DATE::date as date, BALANCE as "Holded Tokes"
from flipside_prod_db.ethereum.erc20_balances
where date= current_date -1
and CONTRACT_ADDRESS= lower ('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
group by 1,2) as b
صاثقث
Run a query to Download Data