-- Note "refund" events in block results, e.g.
-- https://midgard.ninerealms.com/v2/debug/block/8231961
SELECT block_id, --fact_refund_events.*
fact_refund_events.block_timestamp,
from_address,
POWER(10,-8) * asset_e8 AS asset_amount,
TO_CHAR(SPLIT(asset, '-')[0]) AS asset,
UPPER(SPLIT(memo, ':')[1]) AS target_asset
FROM thorchain.core.fact_refund_events INNER JOIN thorchain.core.dim_block ON fact_refund_events.dim_block_id = dim_block.dim_block_id
WHERE (reason LIKE '%insufficient funds for outbound request%')
AND (DATE(fact_refund_events.block_timestamp) = '2022-11-15')
QUALIFY asset_amount = MAX(asset_amount) OVER(PARTITION BY asset, target_asset)
ORDER BY block_id DESC