drone-mostafaUntitled Query
Updated 2022-06-25
9
1
2
3
4
5
6
7
8
9
›
⌄
select
count(USER_ADDRESS) as wallets, avg(balance) as Balance
from flipside_prod_db.ethereum.erc20_balances
where USER_ADDRESS IN (select distinct ORIGIN_FROM_ADDRESS as wallets from ethereum.core.fact_event_logs where contract_address = lower('0x881d40237659c251811cec9c364ef91dc08d300c'))
and CONTRACT_ADDRESS = 'ETH' and BALANCE_DATE = '2022-06-21'
Run a query to Download Data