PS0G1Share of the staked/unstaked
    Updated 2022-09-23
    select 'Unstake' as type,
    count (distinct tx_hash) as Unstake,
    count (distinct Origin_to_Address) as Unstakers,
    sum (amount) as Unstake_Volume,
    sum (amount_usd) as Unstake_USD


    from ethereum.core.ez_token_transfers
    where BLOCK_TIMESTAMP >= '2022-07-01' and contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
    and from_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908' and origin_function_signature = '0x6ab15071' and SYMBOL = 'MATIC'

    UNION

    select 'Stake' as type,
    count (distinct tx_hash) as Stake,
    count (distinct Origin_From_Address) as Stakers,
    sum (amount) as Stake_Volume,
    sum (amount_usd) as Stake_USD


    from ethereum.core.ez_token_transfers
    where BLOCK_TIMESTAMP >= '2022-07-01' and contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
    and to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908' and origin_function_signature = '0x6ab15071' and SYMBOL = 'MATIC'


    Run a query to Download Data