nitsTop Lido Stakers by asset amount
    Updated 2022-04-26
    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
    Run a query to Download Data