Simplify Analytics
← Data Explorer

Multi-leg option trades

core.multileg_trades

Class E accrual with a 24-hour vendor cap - the shortest window in the project.

367,592 rowsCSV — whole table, not this view

Sources in this table

executed_at (ET days)to
column equals (exact text)
sort
chart against executed_at
reset
active:code = cbmo×direction = long×net_side = ask×
idtexttickertextexecuted_at ↓timestamp with time zonestrategytextleg_countintegertxnsintegersizebiginttotal_premiumnumericdirectiontextnet_sidetextunderlying_pricenumericbid_ask_spreadnumericstrikesjsonbivsjsonbbreakevensjsonbuniq_exchangesjsonbmin_strikenumericmax_strikenumericmin_dteintegermax_dteintegerall_opening_legsbooleanall_otmbooleandiff_expirationsbooleandiff_strikesbooleandiff_typesbooleancodetextkept_bytextsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
01a0c59b-74d6-7df3-b618-ea1a0e19bfd8SPX2026-09-21 16:14call_ratio_spread21100954600.00longask7764.70005.3000["7700","7775"]["0.1075","0.1003"]["7701","7849.00"]["XCBO"]7700.00007775.000099falsefalsefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c598-63af-77c3-9912-9e39634abdc2SPX2026-09-21 16:11synthetic2125827820.00longask7764.70002.2000["7830"]["0.1351"]["7913.53"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:11:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c597-429f-7650-87f1-1363fa988364SPX2026-09-21 16:10put_frontspread2155277413.00longask7764.70000.4000["7650","7750"]["0.1246","0.1116"]["7525.74","7739.31"]["XCBO"]7650.00007750.00001111falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:11:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c596-67df-74d3-b111-48dfcd153834SPX2026-09-21 16:09synthetic221083358800.00longask7764.70002.0000["7830"]["0.1350"]["7935.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:09:30Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c593-897e-7e12-b9a4-271a1696a3f4SPX2026-09-21 16:06synthetic22321323520.00longask7764.70001.7000["7830"]["0.1361"]["7832.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:07:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c592-f8f7-7242-9ac7-e4c8b0c03dfbSPX2026-09-21 16:05synthetic2110413600.00longask7764.70002.1000["7830"]["0.1361"]["7832.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:07:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c58c-26df-7363-98fe-4da25c5f3b1eSPX2026-09-21 15:58straddle2210412000.00longask7767.87002.1000["7840"]["0.1354"]["7428","8252.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:58:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c589-504e-7e82-b9c8-a591e8f4bf04SPX2026-09-21 15:54synthetic2225210483200.00longask7766.73002.8000["7840"]["0.1368"]["7841.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c589-310e-7521-b2e3-a078841c182eSPX2026-09-21 15:54synthetic21502073000.00longask7767.96002.1000["7840"]["0.1363"]["7842.44"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:27Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c586-9516-7f73-b61c-e67f6a2edddeSPX2026-09-21 15:52synthetic2113538980.00longask7769.98002.0000["7840"]["0.1363"]["7842.44"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:52:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c586-5a7e-70a0-8d27-281cf8a443a3SPX2026-09-21 15:51synthetic21441826000.00longask7768.39002.1000["7840"]["0.1364"]["7843.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:52:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c573-f776-7802-ba70-fde9f07d4bdcSPX2026-09-21 15:31straddle218332000.00longask7771.86001.6000["7840"]["0.1364"]["7425","8255.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:32:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c570-4627-7c30-b888-1bf9042112e6SPX2026-09-21 15:27synthetic2121871920.00longask7771.85001.7000["7840"]["0.1365"]["7841.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:27:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56d-fc37-7b20-99eb-4f1bd585d901SPX2026-09-21 15:25risk_reversal2150031925000.00longask7771.46003.4000["7000","8000"]["0.2081","0.1546"]["8281.50"]["XCBO"]7000.00008000.0000298298falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:25:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c567-706e-7392-a202-2ee9999b490eSPX2026-09-21 15:18straddle2123957950.00longask7774.24001.7000["7840"]["0.1368"]["7423.50","8256.50"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:18:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd75989f1090SPX2026-09-21 14:57strangle21500169850500.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd65b9d7137aSPX2026-09-21 14:57strangle21500169850500.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd59f3e2c8c4SPX2026-09-21 14:57strangle2130001019103000.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51e-1aff-7ef2-97f2-4bc9ed5073b9SPX2026-09-21 13:57put_frontspread214489054.00longask7758.96001.1000["5000","7825"]["0.4160","0.1398"]["4801.79","7708.85"]["XCBO"]5000.00007825.00008888falsefalsefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:58:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51c-f607-7fc1-8808-cc3131e1d976SPX2026-09-21 13:56strangle21100155000.00longask7759.19000.4000["7735","7785"]["0.1143","0.1014"]["7719.50","7800.50"]["XCBO"]7735.00007785.000011falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:56:48Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51c-f606-7001-8e46-1927dffb4b48SPX2026-09-21 13:56strangle249001395000.00longask7759.19000.4000["7735","7785"]["0.1143","0.1014"]["7719.50","7800.50"]["XCBO"]7735.00007785.000011falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:56:48Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51b-b99f-73d2-9077-5636eb743ec9SPX2026-09-21 13:55risk_reversal21100031383000.00longask7758.94001.9000["7000","8000"]["0.2025","0.1351"]["8131.47"]["XCBO"]7000.00008000.0000151151falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:55:42Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c50c-c57f-7b41-aba3-8dfc16cb1414SPX2026-09-21 13:39put_frontspread2110094600.00longask7754.32000.3000["7300","7700"]["0.2635","0.1215"]["6914.92","7685.08"]["XCBO"]7300.00007700.000044falsetruefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:39:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c50c-c57f-7b41-aba3-8d977beaf57fSPX2026-09-21 13:39straddle2112495600.00longask7754.32001.5000["7825"]["0.1360"]["7412","8238.00"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:39:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c505-18a7-7fd2-8b61-10fc86bfc90dSPX2026-09-21 13:30synthetic2128206640.00longask7757.35000.5000["7750"]["0.1132"]["7762.40"]["XCBO"]7750.00007750.000044falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:31:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c505-18a7-7fd2-8b61-10e3cf227c8bSPX2026-09-21 13:30synthetic2342309960.00longask7757.35000.5000["7750"]["0.1132"]["7762.40"]["XCBO"]7750.00007750.000044falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:31:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f9-2dde-77a3-a7d1-736d2eca0f61SPX2026-09-21 13:17synthetic2226887500.00longask7757.20001.7000["7825"]["0.1366"]["7754.35"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:18:00Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f0-c587-79d3-a19b-f844e5227970SPX2026-09-21 13:08synthetic2116660160.00longask7753.66001.8000["7820"]["0.1359"]["7822.00"]["XCBO"]7820.00007820.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:08:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f0-4887-74f3-aeb3-a31cee5a018cSPX2026-09-21 13:07synthetic22311072400.00longask7754.58001.9000["7815"]["0.1370"]["7754.94"]["XCBO"]7815.00007815.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:08:12Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4df-d1ae-7571-86ab-43af116e5216SPX2026-09-21 12:49ratio_risk_reversal2150199500.00longask7752.32001.4000["6500","7820"]["0.2568","0.1331"]["6484.94"]["XCBO"]6500.00007820.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:50:02Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4d6-b5a6-7200-abae-1e61917c70a6SPX2026-09-21 12:39synthetic2111459800.00longask7749.62001.7000["7810"]["0.1378"]["7822.00"]["XCBO"]7810.00007810.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:40:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ac-3e8e-7c33-ae6e-a3714c837e45SPX2026-09-21 11:53synthetic21251037500.00longask7738.58001.5000["7800"]["0.1370"]["7807.00"]["XCBO"]7800.00007800.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:53:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a8-2b96-7fa1-af9d-49bee2da348aSPX2026-09-21 11:49risk_reversal212003329800.00longask7740.34001.2000["7000","8000"]["0.2066","0.1247"]["8062.49"]["XCBO"]7000.00008000.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:49:19Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a1-97fe-76a2-b2b2-5148af6d04adSPX2026-09-21 11:41synthetic2116493600.00longask7734.77001.5000["7795"]["0.1377"]["7697.50"]["XCBO"]7795.00007795.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:42:10Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c490-9487-7aa1-9193-fca908d6fd78SPX2026-09-21 11:23risk_reversal2310003787000.00longask7729.60000.2000["7600","7800"]["0.1258","0.0983"]["7807.81"]["XCBO"]7600.00007800.000099falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:23:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c477-e04f-7140-838b-b5dbc82019f9SPX2026-09-21 10:56straddle22632583000.00longask7721.04001.7000["7780"]["0.1356"]["7370","8190.00"]["XCBO"]7780.00007780.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:56:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c469-5d76-7332-a52a-aba145f108edSPX2026-09-21 10:40risk_reversal21801269280.00longask7722.62001.1000["7000","8000"]["0.2050","0.1229"]["8052.60"]["XCBO"]7000.00008000.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:40:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c45f-570f-7db0-b284-954f2a8c4f14SPX2026-09-21 10:29strangle21200390000.00longask7721.34000.8000["7000","8000"]["0.2239","0.1043"]["6980.50","8019.50"]["XCBO"]7000.00008000.00002525falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:29:36Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c449-c787-7893-b6b5-0655fcfbc990SPX2026-09-21 10:06ratio_risk_reversal212001916536.00longask7702.72001.4000["7305","7770"]["0.1759","0.1336"]["7225.69"]["XCBO"]7305.00007770.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:06:13Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c448-fc67-78f0-bf4a-790ae34586dfSPX2026-09-21 10:05synthetic2211348600.00longask7705.65001.8000["7770"]["0.1372"]["7678.91"]["XCBO"]7770.00007770.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:05:17Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c435-707e-7621-84d1-7491f606192eSPX2026-09-21 09:43synthetic222006576000.00longask7697.06001.6000["7760"]["0.1352"]["7845.20"]["XCBO"]7760.00007760.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:43:59Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c432-a5a7-76b2-a604-912ccaa46582SPX2026-09-21 09:40synthetic211004115000.00longask7697.66001.6000["7750"]["0.1365"]["7765.00"]["XCBO"]7750.00007750.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:40:51Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b629-1757-7ab3-9d16-fbf43135f0c3SPX2026-09-18 16:15synthetic219373500.00longask7650.50002.8000["7725"]["0.1362"]["7727.00"]["XCBO"]7725.00007725.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-9387-7453-9616-f87afb370493SPX2026-09-18 15:52synthetic22672787200.00longask7642.11001.9000["7710"]["0.1367"]["7713.00"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:52:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b606-d1e8-7353-bd42-0e0e99da453fSPX2026-09-18 15:38straddle211124659200.00longask7640.05001.4000["7710"]["0.1368"]["7294","8126.00"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:38:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b604-41a8-7a62-9bce-28d2bf38defaSPX2026-09-18 15:35strip216187950.00longask7637.40001.6000["7710"]["0.1383"]["7396.75","8336.50"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:35:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b604-41a8-7a62-9bce-2775a3c93a32SPX2026-09-18 15:35put_frontspread21140119650.00longask7637.40000.3000["7400","7500"]["0.1553","0.1320"]["7343.12"]["XCBO"]7400.00007500.000077falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:35:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ea-ce07-7610-bc0c-63aa749246aaSPX2026-09-18 15:07ratio_risk_reversal21150643500.00longask7641.45000.7000["7450","7750"]["0.1428","0.0986"]["7775.50"]["XCBO"]7450.00007750.00002020falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:08:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e1-0237-76f1-a9af-bfa1ab42347dSPX2026-09-18 14:56strangle2135043815450.00longask7643.08002.7000["7000","8000"]["0.1880","0.1341"]["6748.13","8251.87"]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:57:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e1-0237-76f1-a9af-bf94858962c8SPX2026-09-18 14:56strangle21678387529.00longask7643.08002.7000["7000","8000"]["0.1880","0.1341"]["6748.13","8251.87"]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:57:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15