nitsUntitled Query
Updated 2022-02-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT * from
(SELECT * from
(SELECT * from ethereum.erc20_balances
where
user_address in
(SELECT to_address
from ethereum.udm_events
where from_address_name is not NULL and lower(symbol) = lower('xSushi') and amount is not NULL and block_timestamp > CURRENT_DATE -60 and to_label is NULL
))
where
balance_date = CURRENT_DATE -1 and
amount_usd is not NULL )
-- GROUP by 1
-- order by 2 desc
limit 100
Run a query to Download Data