ethereum.erc20_balances.balance_date as balance_day,

count(DISTINCT ethereum.erc20_balances.user_address) as unique_addresses,

avg(ethereum.erc20_balances.price) as price

FROM ethereum.erc20_balances

WHERE balance >= 0 -- get addresses that may have staked ALCX (so it's not currently in balance)

AND ethereum.erc20_balances.symbol = 'ALCX'

GROUP BY balance_date

ORDER BY 1