mrwildcatmatic: daily staking usd
    Updated 2023-04-13
    SELECT --date_trunc( 'day', block_timestamp ) AS date,
    block_timestamp::date,
    sum (CASE WHEN to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908' THEN amount_usd END ) as matic_staked -- StakeManagerProxy
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp::date between '2022-07-01' and CURRENT_DATE
    and origin_function_signature = '0x6ab15071'
    and symbol = 'MATIC'
    GROUP BY 1

    Run a query to Download Data