sinahosseinzadehUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with addr as
(SELECT DISTINCT to_address
from ethereum.udm_events
where from_address ilike '0xf92cd566ea4864356c5491c177a430c222d7e678' and amount_usd is not NULL )
SELECT balance_date, sum(amount_usd) as total_amt, count(DISTINCT user_address)
from
(SELECT * from flipside_prod_db.ethereum.erc20_balances
where user_address in (SELECT * from addr) and amount_usd <pow(10,8) )
where amount_usd is not NULL
GROUP by 1
Run a query to Download Data