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 = bid×
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
01a0b62b-bf08-7411-b36d-f4bef1b2d6c1SPX2026-09-18 16:18synthetic2110413000.00longbid7650.50002.8000["7730"]["0.1355"]["7727"]["XCBO"]7730.00007730.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b62b-615c-76a2-a955-a3931c0894efSPX2026-09-18 16:18synthetic2115619500.00longbid7650.50002.8000["7730"]["0.1355"]["7727"]["XCBO"]7730.00007730.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b628-772f-7221-98b6-7a520e98b8e7SPX2026-09-18 16:14other2140704800.00unknownbid7650.50002.5000["7730","8200"]["0.1370","0.1280"][]["XCBO"]7730.00008200.000091182falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b628-772f-7221-98b6-7a459d002ffdSPX2026-09-18 16:14other211001720400.00unknownbid7650.50002.5000["7730","8200"]["0.1370","0.1280"][]["XCBO"]7730.00008200.000091182falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b627-4297-7041-99c7-f32dc4dbefe2SPX2026-09-18 16:13synthetic2122910800.00shortbid7650.50002.2000["7725"]["0.1359"]["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
01a0b627-4297-7041-99c7-f29a21471aacSPX2026-09-18 16:13ratio_risk_reversal2154402300.00shortbid7650.50001.0000["7200","7750"]["0.1773","0.1095"]["7792.12"]["XCBO"]7200.00007750.00003131falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b625-ac57-7163-b672-ec0f7c2d39a2SPX2026-09-18 16:11ratio_risk_reversal2140337200.00shortbid7650.50001.2000["7225","7750"]["0.1751","0.1090"]["7800.10"]["XCBO"]7225.00007750.00003232falsetruefalsetruetruecbmomarket_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-fb62cc3b3765SPX2026-09-18 16:11synthetic2113538720.00shortbid7650.50002.1000["7720"]["0.1361"]["7722.00"]["XCBO"]7720.00007720.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
01a0b624-681f-7fe1-a251-d1660fa78bc0SPX2026-09-18 16:10ratio_risk_reversal2120142610.00shortbid7650.50000.8000["7225","7750"]["0.1783","0.1102"]["7799.64"]["XCBO"]7225.00007750.00002828falsetruefalsetruetruecbmomarket_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
01a0b623-6e1f-7c21-a784-db3fd08e5795SPX2026-09-18 16:09other411002875700.00unknownbid7650.50002.1000["7700"]["0.1025"][]["XCBO"]7700.00007700.00001720falsefalsetruefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:10:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b622-83bf-7ad1-bb5f-82f71ebb02ebSPX2026-09-18 16:08other221053914400.00unknownbid7650.50002.1000["7720"]["0.1356"]["7763.20"]["XCBO"]7720.00007720.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:08:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61f-ff37-7ba0-ac89-507a4da142f3SPX2026-09-18 16:05synthetic22391614600.00shortbid7650.50002.2000["7720"]["0.1359"]["7722.00"]["XCBO"]7720.00007720.00009191falsefalsefalsefalsetruecbmomarket_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
01a0b61e-1ebf-76e0-9cdf-71c1c45a140aSPX2026-09-18 16:03synthetic21301242000.00shortbid7650.16002.3000["7720"]["0.1359"]["7720"]["XCBO"]7720.00007720.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:04:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61d-3c2f-7783-a988-2e6c67367668SPX2026-09-18 16:02synthetic216248640.00shortbid7650.16002.1000["7715"]["0.1361"]["7720.00"]["XCBO"]7715.00007715.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:02:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61d-3c2f-7783-a988-2dc71afe4762SPX2026-09-18 16:02call_vertical_spread2120101520.00unknownbid7650.16000.6000["7625","7660"]["0.0717","0.0634"]["7667.88"]["XCBO"]7625.00007660.000033falsefalsefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:02:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-c18f-7691-9d20-94313b2c8bb0SPX2026-09-18 15:58ratio_risk_reversal2140539490.00longbid7646.19001.7000["7710","8000"]["0.1406","0.1177"]["8021.85"]["XCBO"]7710.00008000.00009191falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-7370-79d2-81b8-640b10a27e98SPX2026-09-18 15:58strangle2115015195600.00unknownbid7645.60004.5000["7000","8000"]["0.1792","0.1169"]["7665.05"]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruecbmomarket_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
01a0b617-c9a7-7251-8227-f0d49cec41c3SPX2026-09-18 15:56synthetic22953942500.00shortbid7646.90002.0000["7710"]["0.1363"]["7711.00"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:57:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b616-d38f-76e1-9f5a-fe9984ccb4ddSPX2026-09-18 15:55strip21421305150.00unknownbid7648.50001.9000["7710"]["0.1382"]["7607.75"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_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-56155042fbd4SPX2026-09-18 15:54call_diagonal_spread21200635000.00unknownbid7643.86001.7000["7710","7900"]["0.1319","0.0973"][]["XCBO"]7710.00007900.00002891falsetruetruetruefalsecbmomarket_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-6a9a5cf51f8bSPX2026-09-18 15:53other211002275100.00unknownbid7644.35001.4000["7000","7710"]["0.2024","0.1317"][]["XCBO"]7000.00007710.000091272falsetruetruetruetruecbmomarket_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
01a0b610-8e17-7590-89f7-f9032581f19bSPX2026-09-18 15:48strangle2118323943903.00unknownbid7645.57002.6000["6500","7500"]["0.2341","0.1507"]["7597.35"]["XCBO"]6500.00007500.00006363falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:48:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-70f0-7cc2-8665-8a920f5ccbacSPX2026-09-18 15:47other2214477059.00unknownbid7645.43001.4000["7710"]["0.1375"]["7638.72"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-70f0-7cc2-8665-8a842acc96b1SPX2026-09-18 15:47other2119686649.00unknownbid7645.43001.4000["7710"]["0.1359"]["7767.79"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-6d08-7c21-96d8-5a5f0708e273SPX2026-09-18 15:47synthetic2114582400.00shortbid7645.42001.4000["7710"]["0.1367"]["7712.00"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-0f47-7732-9b4b-ec6731ddb9ffSPX2026-09-18 15:47synthetic21283100.00shortbid7645.97001.3000["7710"]["0.1365"]["7711.50"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmotrackeduw_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
01a0b60d-f220-77b1-a298-29612726d4b3SPX2026-09-18 15:46other331901302180.00unknownbid7643.23002.1000["7705","7900"]["0.1369","0.0967"][]["XCBO"]7705.00007900.00002891falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:46:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b607-d3b8-7753-846b-5d6809fd2968SPX2026-09-18 15:39strangle2175122175.00shortbid7641.50000.6000["7000","8000"]["0.2117","0.0974"]["6983.71","8016.29"]["XCBO"]7000.00008000.00002828falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:39:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b607-d3b7-7461-8f54-3982ecdde680SPX2026-09-18 15:39strangle21757597800.00unknownbid7641.50004.4000["7000","8000"]["0.2009","0.1057"]["7665.05"]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:39:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b606-415f-7183-9768-401f553cf6fcSPX2026-09-18 15:37synthetic221737214100.00shortbid7639.87001.4000["7705"]["0.1371"]["7705"]["XCBO"]7705.00007705.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:37:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b604-4978-7601-82b1-b194220ef267SPX2026-09-18 15:35put_ratio_spread215873129488.00unknownbid7637.35001.2000["6850","7710"]["0.2157","0.1408"]["6801.33"]["XCBO"]6850.00007710.00009191falsefalsefalsetruefalsecbmomarket_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-458f-79c1-86e4-66e01dd1531fSPX2026-09-18 15:35other44128710793200.00unknownbid7637.25002.5000["6850","6875","7710"]["0.2156","0.2132","0.1355"]["6814.47"]["XCBO"]6850.00007710.00009191falsefalsefalsetruetruecbmomarket_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-ad584aaf5bacSPX2026-09-18 15:35synthetic22381579812.00longbid7637.09001.6000["7710"]["0.1367"]["7705.40"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_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-b6e18a3b9f4fSPX2026-09-18 15:34straddle2215624000.00shortbid7637.80001.4000["7705"]["0.1368"]["7289","8121.00"]["XCBO"]7705.00007705.00009191falsefalsefalsefalsetruecbmomarket_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
01a0b5ff-e08f-7da0-a263-76f85c0b3b75SPX2026-09-18 15:30synthetic2228870828.00longbid7638.19001.5000["7710"]["0.1354"]["7811.37"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:30:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ff-e08f-7da0-a263-74c974d393b5SPX2026-09-18 15:30ratio_risk_reversal2270602150.00longbid7638.19000.9000["7550","7750"]["0.1322","0.1054"]["7764.72"]["XCBO"]7550.00007750.00002727falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:30:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fe-65a7-7bd3-bd61-d24e6ca45a98SPX2026-09-18 15:29other411001189800.00unknownbid7640.47002.3000["7700"]["0.2300"][]["XCBO"]7700.00007700.000003falsefalsetruefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:29:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-9e70-7d32-ae19-5b5a9a56fd35SPX2026-09-18 15:28other4350012100880.00unknownbid7640.44002.5000["6950","7710","8500"]["0.2024","0.1377","0.1203"][]["XCBO"]6950.00008500.000091182falsefalsetruetruetruecbmomarket_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
01a0b5f7-4d40-7342-83ae-96123d8f8a97SPX2026-09-18 15:21other6287846155696.00unknownbid7641.46003.9000["7700","7710"]["0.1359","0.1390"][]["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
01a0b5ef-b007-7050-88ff-b37ded6da6cbSPX2026-09-18 15:12other3115598850.00unknownbid7642.68003.2000["7100","7710"]["0.2058","0.1367"][]["XCBO"]7100.00007710.000091455falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:12:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ef-5e00-7d51-bea2-db1e9d81ab44SPX2026-09-18 15:12other3110202100.00unknownbid7642.54002.1000["7350","7710"]["0.1658","0.1367"][]["XCBO"]7350.00007710.00006391falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:12:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ed-79a0-7a43-b815-1e270fb5ada1SPX2026-09-18 15:10synthetic23983244800.00longbid7642.34001.4000["7710"]["0.1356"]["7794.90"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:11:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ed-3737-7f60-a09f-cd3f5f2f5625SPX2026-09-18 15:10other311002822500.00unknownbid7642.08002.8000["7000","7710"]["0.2053","0.1342"][]["XCBO"]7000.00007710.000091364falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:10:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ed-1bdf-7a43-89ee-1825c1e94bbdSPX2026-09-18 15:10other42305304400.00unknownbid7641.850014.6000["7400","7710","10000"]["0.1824","0.1367","0.1395"][]["XCBO"]7400.000010000.000091819falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:10:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ec-1a10-78f3-bd9d-1df38a704cb6SPX2026-09-18 15:09synthetic21283210.00longbid7640.79001.4000["7710"]["0.1368"]["7709.33"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:09:26Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ea-ce07-7610-bc0c-651949456a4cSPX2026-09-18 15:07synthetic21902246400.00longbid7641.45001.5000["7710"]["0.1395"]["7543.60"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmomarket_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
01a0b5ea-be68-7c02-bcc8-9ab9abbc761cSPX2026-09-18 15:07iron_condor4121312100.00unknownbid7641.71001110.0000["6000","7000"]["0.2163","0.2149"]["6680.25"]["XCBO"]6000.00007000.000019181918falsefalsefalsetruetruecbmomarket_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
01a0b5e3-f808-7622-9eed-776f008281e0SPX2026-09-18 15:00straddle21283200.00shortbid7642.16001.7000["7710"]["0.1367"]["7294","8126.00"]["XCBO"]7710.00007710.00009191falsefalsefalsefalsetruecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:00:32Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e3-f808-7622-9eed-763e564e2cadSPX2026-09-18 15:00call_calendar2150642400.00unknownbid7642.16000.7000["7650"]["0.1063"][]["XCBO"]7650.00007650.0000721falsetruetruefalsefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:00:32Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e3-9277-7513-a594-62bf573fbbd2SPX2026-09-18 14:59other427004024700.00unknownbid7641.76002.6000["6400","7400","7710"]["0.2714","0.1605","0.1360"][]["XCBO"]6400.00007710.00006391falsefalsetruetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:00:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15