SELECT origin_address as unique_stakers, sum(amt) as total_amt
from
(SELECT date(block_timestamp) as day,tx_id,origin_address, max(amount) as amt, max(amount_usd) as amt_usd from ethereum.udm_events
where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84') and from_address = '0x0000000000000000000000000000000000000000'
and amount is not NULL and amount_usd is not NULL
GROUP by 1 , 2,3 )
GROUP by 1
ORDER by 2 desc
LIMIT 10