mariya Matic staked (Weekly)
    Updated 2022-09-18
    SELECT
    date_trunc('week', block_timestamp) as date,
    sum((tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18)) as amount_staked
    FROM ethereum.core.fact_transactions
    WHERE (tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18) IS NOT NULL
    AND to_address = lower('0x9ee91F9f426fA633d227f7a9b000E28b9dfd8599')
    AND DATE >= '2022-07-01'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data