adambalamatic
Updated 2022-09-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
balance_date,
sum(non_adjusted_balance)/pow(10,18) as balance ,avg(price)
from ethereum.erc20_balances
where lower(contract_address) = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0' )
and MONTHNAME(balance_date) >'JULY' AND DATE(balance_date) >'2022-01-01'
and USER_ADDRESS not in ('0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2','0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff','0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca','0x50d669f43b484166680ecc3670e4766cdb0945ce')
group by balance_date
Run a query to Download Data