eferB. Canceled proposals using contract cancel method
    Updated 2023-04-13
    WITH canceled_proposals_txn AS(
    SELECT
    BLOCK_TIMESTAMP,
    FROM_ADDRESS AS executer,
    CAST(CAST(CONCAT('0x', SPLIT(INPUT_DATA, '0x40e58ee5')[1]) AS REAL) AS STRING) AS canceled_proposal
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    AND ORIGIN_FUNCTION_SIGNATURE='0x40e58ee5'
    AND STATUS='SUCCESS'
    ORDER BY block_timestamp ASC
    )
    SELECT * FROM canceled_proposals_txn
    Run a query to Download Data