0-MIDdaily unstaked count
    Updated 2023-04-12
    select BLOCK_TIMESTAMP::date as date,sum(EVENT_INPUTS:amount)/1e18 as unstaked_matic
    from ethereum.core.fact_event_logs
    where ORIGIN_FUNCTION_SIGNATURE='0xc83ec04d'
    and CONTRACT_NAME='EventsHubProxy'
    and EVENT_NAME='ShareBurnedWithId'
    and TX_STATUS='SUCCESS'
    and BLOCK_TIMESTAMP>='2022-07-01'
    group by 1




    Run a query to Download Data