mo115Holders (low ETH)
Updated 2022-04-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with A as (select DATE_TRUNC('day', hour) AS time , sum(price)/count(price) as higherprices
from ethereum.token_prices_hourly
where symbol='ETH'
and price <= 3000
group by time
),
B as (select DATE_TRUNC('day', block_timestamp) AS time ,from_address as wallets
from ethereum.udm_events
where to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
)
select distinct(b.wallets), c.balance
from A a join B b on a.time=b.time
join ethereum.erc20_balances c on b.wallets=c.USER_ADDRESS
where c.CONTRACT_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and c.BALANCE_DATE = '2022-04-02'
Run a query to Download Data