Query editor
withsusd_transfer as (selectvalue / 1e18 as value,evt_block_time,evt_tx_hashfromerc20_optimism.evt_Transferwhere"to" = (0xfeEFEEfeefEeFeefEEFEEfEeFeefEEFeeFEEFEeF)and contract_address = (0x8c6f28f2F1A3C87F0f938b96d27520d9751ec8d9)),spot_exchange as (selectevt_tx_hash,'spot' as tx_typefromsynthetix_optimism.SNX_evt_SynthExchange),future_tracking as (selectevt_tx_hash,'perpv1' as tx_typefrom (select evt_tx_hash fromsynthetix_optimism.FuturesMarket_evt_FuturesTrackingunionselect evt_tx_hashfromsynthetix_optimism.FuturesMarket_evt_PositionLiquidated)unionselectevt_tx_hash,'perpv2' as tx_typefrom (select evt_tx_hash fromsynthetix_futuresmarket_optimism.ProxyPerpsV2_evt_PerpsTrackingUnionselect evt_tx_hash fromsynthetix_futuresmarket_optimism.ProxyPerpsV2_evt_PositionLiquidated)),loan_tracking as (select*,'loan' as tx_typefrom(selectevt_tx_hashfromsynthetix_optimism.CollateralEth_evt_LoanCreatedunionselectevt_tx_hashfromsynthetix_optimism.CollateralEth_evt_LoanDrawnDownunionselectevt_tx_hashfrom