hypergladegf pool contract Total Amount of Each Event Type Over Time
    Updated 2024-06-28
    SELECT
    EVENT_NAME,
    SUM(CAST(DECODED_LOG:amount AS NUMERIC)) AS total_amount
    FROM ethereum.core.ez_decoded_event_logs
    WHERE CONTRACT_ADDRESS = LOWER('0xB01b315e32D1D9B5CE93e296D483e1f0aAD39E75')
    GROUP BY EVENT_NAME
    ORDER BY EVENT_NAME;

    QueryRunArchived: QueryRun has been archived