hypergladegf pool contract total deposits overtime
    Updated 2024-06-27
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
    SUM(CAST(DECODED_LOG:amount AS NUMERIC)) AS total_deposits
    FROM ethereum.core.ez_decoded_event_logs
    WHERE CONTRACT_ADDRESS = LOWER('0xB01b315e32D1D9B5CE93e296D483e1f0aAD39E75')
    AND EVENT_NAME = 'DepositMade'
    GROUP BY month
    ORDER BY month;




    QueryRunArchived: QueryRun has been archived