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.

312,778 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×net_side = ask×
idtexttickertextexecuted_attimestamp 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
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
01a0b629-1757-7ab3-9d16-fbe442e64a95SPX2026-09-18 16:15put_diagonal_spread2175153750.00unknownask7650.50000.4000["7550","7575"]["0.1119","0.0871"][]["XCBO"]7550.00007575.0000310falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b628-772f-7221-98b6-7a30f64fbc88SPX2026-09-18 16:14other4550010305800.00unknownask7650.50004.7000["7730","8200","8600"]["0.1357","0.1280","0.1207"][]["XCBO"]7730.00008600.000091182falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b625-ac57-7163-b672-ec71e874fff9SPX2026-09-18 16:11other2120663200.00unknownask7650.50002.3000["7725"]["0.1366"]["7640.60"]["XCBO"]7725.00007725.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:13:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b624-f0d7-7b21-984a-fa5ac0ddf963SPX2026-09-18 16:11other7150369000.00unknownask7650.50001.5500["7150","7175","7250","7325","7375","7450","7600"]["0.2294","0.1980","0.1965","0.1662","0.1542","0.1384","0.1098"][]["XCBO"]7150.00007600.0000714falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:11:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b624-681f-7fe1-a251-d1d9abc810e3SPX2026-09-18 16:10strip2110311000.00unknownask7650.50001.9000["7725"]["0.1368"]["7620"]["XCBO"]7725.00007725.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:11:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61f-ff37-7ba0-ac89-50309d508495SPX2026-09-18 16:05put_diagonal_spread22860151360.00unknownask7650.50000.2000["7415","7510"]["0.1527","0.1076"][]["XCBO"]7415.00007510.000035falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:06:22Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-7370-79d2-81b8-641a5e6732e5SPX2026-09-18 15:58risk_reversal21150244350.00shortask7645.60000.7000["7000","8000"]["0.2126","0.0964"]["6993.81"]["XCBO"]7000.00008000.00002828falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:58:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b616-d38f-76e1-9f5a-fbc3254f23c9SPX2026-09-18 15:55ratio_risk_reversal21200214000.00shortask7648.50000.4000["7400","7800"]["0.1505","0.0803"]["7800.50"]["XCBO"]7400.00007800.00001212falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:55:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b616-009f-71f3-b938-560ae8a0ab6fSPX2026-09-18 15:54other211001129000.00unknownask7643.86002.1000["7700","7710"]["0.1101","0.1409"][]["XCBO"]7700.00007710.00002891falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:54:52Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b614-b880-7fa2-81ce-6a8aa7224b99SPX2026-09-18 15:53other321504551150.00unknownask7644.35002.3000["7000","7710"]["0.2024","0.1375"][]["XCBO"]7000.00007710.000091272falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:53:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-fd00-7172-93f9-6f747f48823aSPX2026-09-18 15:52other313007515000.00unknownask7642.20002.3000["7710","8800"]["0.1364","0.1341"][]["XCBO"]7710.00008800.000091364falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:52:51Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-9f40-7a72-9de1-e3a1c1839336SPX2026-09-18 15:52other312005003000.00unknownask7642.09003.2000["7710","8800"]["0.1364","0.1340"][]["XCBO"]7710.00008800.000091364falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:52:30Z"}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
01a0b610-bcf7-7750-86af-72511575b4caSPX2026-09-18 15:49other211707289110.00unknownask7645.82002.4000["7710","8100"]["0.1409","0.1519"][]["XCBO"]7710.00008100.000091364falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:49:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b610-bcf7-7750-86af-7247ff060c37SPX2026-09-18 15:49call_diagonal_spread211705653750.00unknownask7645.82002.5000["7710","8300"]["0.1325","0.1454"][]["XCBO"]7710.00008300.000091364falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:49:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-0f47-7732-9b4b-e9b9dd96fd2cSPX2026-09-18 15:47put_vertical_spread211537050.00unknownask7645.97000.4000["7275","7500"]["0.1758","0.1310"]["7475.30"]["XCBO"]7275.00007500.00001212falsetruefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:19Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60c-6f67-7242-8f61-62a9afcbefffSPX2026-09-18 15:44put_ratio_spread212537050.00unknownask7643.71000.4000["7200","7325"]["0.1915","0.1671"]["7310.18"]["XCBO"]7200.00007325.00001414falsetruefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:44:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60c-57f7-7572-b611-91c32fb88da2SPX2026-09-18 15:44other313009247854.00unknownask7643.58002.2000["7600","7710"]["0.1503","0.1349"][]["XCBO"]7600.00007710.000091119falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:44:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b606-ed3f-7b62-b8b0-27f07d24f62aSPX2026-09-18 15:38other422005797000.00unknownask7640.29001.9000["7700"]["0.1020"][]["XCBO"]7700.00007700.00001720falsefalsetruefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:38:38Z"}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
01a0b604-0edf-78b2-a69c-ab703496b1c4SPX2026-09-18 15:35put_diagonal_spread22150327750.00unknownask7637.09000.4000["7400","7500"]["0.1492","0.1318"][]["XCBO"]7400.00007500.0000712falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:35:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b603-2867-7252-bcb6-b524739a3e8eSPX2026-09-18 15:34put_calendar225003442500.00unknownask7637.80000.5000["7600"]["0.1114"][]["XCBO"]7600.00007600.0000712falsetruetruefalsefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:34:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-dcef-7ac3-8ff5-d01fc873f919SPX2026-09-18 15:28put_ratio_spread2180372520.00unknownask7640.16001.0000["6675","7710"]["0.2325","0.1411"]["6654.81"]["XCBO"]6675.00007710.00009191falsefalsefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:28:53Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-dcef-7ac3-8ff5-d00b6fc8c5a3SPX2026-09-18 15:28other431201670080.00unknownask7640.16002.5000["6675","7300","7710"]["0.2325","0.1738","0.1357"]["4242.83","7251.70"]["XCBO"]6675.00007710.00009191falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:28:53Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-a257-71b2-b46a-8d4472128f24SPX2026-09-18 15:28other211001907360.00unknownask7640.52001.3000["6950","7710"]["0.2025","0.1326"][]["XCBO"]6950.00007710.000091182falsetruetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:28:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-a257-71b2-b46a-8d3956f49fadSPX2026-09-18 15:28other211001907360.00unknownask7640.44001.3000["6950","7710"]["0.2024","0.1326"][]["XCBO"]6950.00007710.000091182falsetruetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:28:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fb-cd97-7340-bb05-15cace207657SPX2026-09-18 15:26call_diagonal_spread212007269800.00unknownask7639.97002.2000["7710","8300"]["0.1322","0.1450"][]["XCBO"]7710.00008300.000091364falsetruetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:26:28Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f7-4d40-7342-83ae-96240458597aSPX2026-09-18 15:21other3162821457976.00unknownask7641.46002.0000["7700","7710"]["0.1308","0.1327"][]["XCBO"]7700.00007710.00006391falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:21:41Z"}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
01a0b5e7-c898-77a0-94be-daacd6d1d77cSPX2026-09-18 15:04put_diagonal_spread21662811780.00unknownask7643.18002.4000["7500","7710"]["0.1911","0.1417"][]["XCBO"]7500.00007710.000091455falsefalsetruetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e7-c898-77a0-94be-da96bb19c227SPX2026-09-18 15:04other4115016427220.00unknownask7643.18005.6000["7500","7710","8500"]["0.1911","0.1355","0.1592"][]["XCBO"]7500.00008500.000091455falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e7-b127-7be1-9c2c-3505c7b5be3eSPX2026-09-18 15:04other311002046500.00unknownask7643.40002.4000["7300","7710"]["0.1744","0.1368"]["7307.60"]["XCBO"]7300.00007710.00009191falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e1-e4c7-7cd2-930a-383ec2180726SPX2026-09-18 14:57other322002043200.00unknownask7643.84002.1000["7400","7710"]["0.1526","0.1355"][]["XCBO"]7400.00007710.00002891falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:58:08Z"}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
01a0b5e1-0237-76f1-a9af-bf8b0445cec2SPX2026-09-18 14:56strangle21759389025.00longask7643.08002.8000["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
01a0b5e0-c3b7-7343-8ee5-ca96d0d95a3cSPX2026-09-18 14:56other62846992130.00unknownask7643.44006.3000["7700","7710","7800","7925"]["0.1592","0.1384","0.1330","0.1449"][]["XCBO"]7700.00007925.000091245falsefalsetruetruetruecbmomarket_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
01a0b5dd-358f-7362-b94b-31737891a990SPX2026-09-18 14:52put_ratio_spread22197510979450.00unknownask7642.90000.5000["7350","7400"]["0.1642","0.1575"]["7333.80"]["XCBO"]7350.00007400.00002828falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:52:57Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d4-253f-7091-b1cd-34d5f518d737SPX2026-09-18 14:42other2116564300.00unknownask7633.71001.6000["7700"]["0.1367"]["7187","8052.69"]["XCBO"]7700.00007700.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:42:53Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ce-2de7-7112-a5a8-2bcf3914854cSPX2026-09-18 14:36put_calendar21150612900.00unknownask7634.94000.4000["7625"]["0.0891"][]["XCBO"]7625.00007625.000037falsetruetruefalsefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:36:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cd-b4cf-7f70-8677-bf54410d688bSPX2026-09-18 14:35other412003635400.00unknownask7634.96002.4000["7200","7300","7700"]["0.1822","0.1748","0.1375"][]["XCBO"]7200.00007700.00002891falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:36:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cd-9977-7811-a526-fa6885f39605SPX2026-09-18 14:35other4120028102400.00unknownask7634.85004.9000["7700"]["0.1530"][]["XCBO"]7700.00007700.000091336falsefalsetruefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:36:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cd-85ef-7f51-83a7-aaee5b87b83fSPX2026-09-18 14:35other4150908600.00unknownask7634.72002.2000["7200","7300","7700"]["0.1821","0.1747","0.1375"][]["XCBO"]7200.00007700.00002891falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:36:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cd-62c7-7282-b9ad-f5295f199555SPX2026-09-18 14:35put_ratio_spread21400412400.00unknownask7634.64000.4500["7160","7425"]["0.2010","0.1497"]["7383.76"]["XCBO"]7160.00007425.00001414falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:35:38Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ca-26a7-7792-bc1b-e1d8daca0ab2SPX2026-09-18 14:31straddle2220836000.00longask7632.87001.6000["7700"]["0.1376"]["7282","8118.00"]["XCBO"]7700.00007700.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:32:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c7-ffdf-7521-8202-613998ae1c8dSPX2026-09-18 14:29put_ratio_spread21200255000.00unknownask7634.35000.4000["7400","7600"]["0.1579","0.1125"]["7549"]["XCBO"]7400.00007600.000077falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:29:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c7-1d4f-7222-926a-d05f8ebd90e9SPX2026-09-18 14:28strangle2135035471450.00unknownask7633.33003.9000["7000","8000"]["0.2022","0.1068"]["7657.36"]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:29:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15