SELECT
block_timestamp,
origin_from_address AS unstaker,
utils.udf_hex_to_int(SUBSTR(data, 67, 64))/POW(10, 9) AS amount_unstaked,
utils.udf_hex_to_int(SUBSTR(data, 3, 64)) AS stake_number,
tx_hash
FROM
bsc.core.fact_event_logs
WHERE
origin_to_address = lower('0x1E7866B5A5A4F09EfD235D28d49568c2Fe2F7EcD') --TOKENFI STAKING
AND
topics[0] = '0x7fc4727e062e336010f2c282598ef5f14facb3de68cf8195c2f23e1454b2b74e' --UNSTAKED
AND
tx_status = 'SUCCESS'
AND
block_timestamp > current_timestamp - interval '1 day'
ORDER
BY
block_timestamp
DESC