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 = mlet×strategy = box_spread×
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
01a0b5dc-3f78-7383-b4c4-8ca93a716ec1SPX2026-09-18 14:51box_spread413674508.00shortbid7642.78009.6000["7900","8100"]["0.1688","0.1625"][]["XCBO"]7900.00008100.0000455455falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:51:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d8-8e27-71e3-ad7f-171faf489f6eSPX2026-09-18 14:47box_spread41202541820.00longask7643.91006.5000["7000","8000"]["0.1934","0.1227"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:47:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d8-76b8-7030-a429-caeb409a2855SPX2026-09-18 14:47box_spread412418678.00shortbid7643.96004.9000["6000","7515"]["0.2836","0.1464"][]["XCBO"]6000.00007515.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:47:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d5-fa00-7450-9b71-32183e92ce70SPX2026-09-18 14:44box_spread41516467565.00longask7635.35003.7000["7000","8000"]["0.1932","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:45:03Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d5-88b8-73c1-b916-2f3ec1e1a9c9SPX2026-09-18 14:44box_spread412341382.00shortbid7635.04005.1000["6900","7900"]["0.1972","0.1412"][]["XCBO"]6900.00007900.0000182182falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:44:29Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cf-992f-79b2-9479-490fc592fdedSPX2026-09-18 14:37box_spread41469276.00shortbid7633.39000.8000["7670","7680"]["0.0973","0.0956"][]["XCBO"]7670.00007680.000077falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cf-9547-7b62-a1bc-dbe7e186da2fSPX2026-09-18 14:37box_spread41586565.00shortbid7633.32000.9000["7670","7680"]["0.0973","0.0955"][]["XCBO"]7670.00007680.000077falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ce-0ea7-79a2-a008-ab38481e1e03SPX2026-09-18 14:36box_spread413466044.00longask7635.23008.5000["6700","7700"]["0.2166","0.1390"][]["XCBO"]6700.00007700.0000104104falsefalsefalsetruetruemletmarket_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
01a0b5cb-5370-7f82-a080-4302a99b9742SPX2026-09-18 14:33box_spread4151164515.00unknown—7633.58008.9500["6000","7000"]["0.3814","0.2059"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:33:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c2-eb17-7d13-b72b-600f1ee2f8dfSPX2026-09-18 14:24box_spread412242466.00shortbid7634.21003.8000["7000","7400"]["0.1959","0.1571"][]["XCBO"]7000.00007400.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:24:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bd-ab57-7e43-8f1b-296b8302c1daSPY2026-09-18 14:18box_spread415107920.00shortbid759.94500.7900["755","775"]["0.1809","0.1741"][]["XMIO"]755.0000775.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:18:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bd-611f-7f22-b875-e35e87d9b3faSPX2026-09-18 14:17box_spread4151372240.00longask7629.62005.4000["6000","8000"]["0.2421","0.1493"][]["XCBO"]6000.00008000.0000272272falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:18:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bd-2e57-7bb2-a508-6edebb7baa9bSPX2026-09-18 14:17box_spread412414260.00longask7629.73005.3000["7500","8050"]["0.1784","0.1569"][]["XCBO"]7500.00008050.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:18:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ba-1d2f-79b0-be3e-ffbace5f7dedSPY2026-09-18 14:14box_spread415107910.00shortbid759.87000.7900["755","775"]["0.1809","0.1741"][]["XMIO"]755.0000775.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:14:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b9-ee4f-75e0-8384-ac1daf2870d3SPX2026-09-18 14:14box_spread413823290.00longask7629.29006.3000["6000","8000"]["0.2421","0.1493"][]["XCBO"]6000.00008000.0000272272falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:14:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b6-e8df-7e30-b5a2-0ec3816b0c5cSPX2026-09-18 14:10box_spread415658175.00longask7628.460012.0000["7000","8000"]["0.1923","0.1243"][]["XCBO"]7000.00008000.0000104104falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:11:26Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b6-a28f-7542-8389-d2e7e50c2c8fSPX2026-09-18 14:10box_spread4151577160.00shortbid7628.580017.6000["7000","8000"]["0.2008","0.1735"][]["XCBO"]7000.00008000.0000637637falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:10:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b4-1250-7051-afed-ecff6d89e5b3SPX2026-09-18 14:07box_spread4191184571.00longask7628.510012.1000["7000","8000"]["0.1922","0.1243"][]["XCBO"]7000.00008000.0000104104falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:08:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b2-5cd0-7602-8d77-3fd846c08364SPX2026-09-18 14:05box_spread41505153750.00shortbid7629.40005.0000["7000","8000"]["0.2056","0.1049"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:06:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5af-fb6f-7f72-8def-17b3cd27fb42SPX2026-09-18 14:03box_spread413597954.00longask7629.05006.0000["7000","8000"]["0.1952","0.1494"][]["XCBO"]7000.00008000.0000272272falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:03:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ad-20f7-7c72-9ba2-0e46821e60d3SPX2026-09-18 14:00box_spread41285579756.00longask7627.90005.1000["7000","8000"]["0.1953","0.1494"][]["XCBO"]7000.00008000.0000272272falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:00:52Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a8-fa77-76d0-a551-d6ae5500dfb0SPX2026-09-18 13:55box_spread4191184859.00longask7627.890012.8000["7000","8000"]["0.1924","0.1244"][]["XCBO"]7000.00008000.0000104104falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:56:03Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a7-d197-7280-a4eb-f7aac47ec7f0SPX2026-09-18 13:54box_spread41101316790.00longask7628.620012.2000["7000","8000"]["0.1923","0.1245"][]["XCBO"]7000.00008000.0000104104falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:54:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a6-9917-7f13-a075-5287dd775025SPX2026-09-18 13:53box_spread4271084685.00longask7628.52004.9000["7325","7925"]["0.1748","0.1442"][]["XCBO"]7325.00007925.0000210210falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:53:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a4-e77f-7f50-be65-ea4d6f1c253fSPX2026-09-18 13:51box_spread412253642.00longask7627.93003.2000["7000","8000"]["0.1932","0.1236"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:51:21Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b599-a4af-7b13-8e97-d402a383d5eeSPX2026-09-18 13:38box_spread412190934.00longask7626.77002.7000["7410","7910"]["0.1596","0.1267"][]["XCBO"]7410.00007910.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:39:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b599-a0c8-7080-ad8f-788673c83a03SPX2026-09-18 13:38box_spread418763736.00longask7626.81002.7000["7410","7910"]["0.1596","0.1267"][]["XCBO"]7410.00007910.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:39:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b599-9ce0-7323-9a0d-b51136d973bfSPX2026-09-18 13:38box_spread41131241071.00longask7626.74002.7000["7410","7910"]["0.1596","0.1267"][]["XCBO"]7410.00007910.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:39:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58d-a65f-7872-b51c-e42567b18c28SPX2026-09-18 13:25box_spread4131824369.00longask7625.850016.8000["2000","8000"]["0.8339","0.1242"][]["XCBO"]2000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:26:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58b-8b4f-7d73-ab92-2effb63443e4SPX2026-09-18 13:23box_spread413736701.00shortbid7624.88004.8000["6000","8050"]["0.2494","0.1360"][]["XCBO"]6000.00008050.0000182182falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:24:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58a-6a40-7790-8b55-c93a487334f8SPX2026-09-18 13:22box_spread4151564100.00longask7624.08004.1000["5000","8000"]["0.4076","0.1243"][]["XCBO"]5000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:22:44Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b587-e1cf-7a02-ba15-7269d64d60c1SPX2026-09-18 13:19box_spread413490500.00shortbid7623.91004.2000["7000","8000"]["0.1916","0.1378"][]["XCBO"]7000.00008000.0000182182falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b587-d618-7792-b8fd-ae5eb17915c3SPX2026-09-18 13:19box_spread412679734.00shortbid7623.98009.3000["6000","7600"]["0.2291","0.1785"][]["XCBO"]6000.00007600.0000455455falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b586-3807-78a1-818f-f4fa9a2ef8a3SPX2026-09-18 13:17box_spread41131500681.00shortbid7624.83003.9000["7000","8000"]["0.1962","0.1175"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:18:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b583-22f8-7f91-9604-5a93829050deSPX2026-09-18 13:14box_spread412248328.00longask7623.41006.3000["7100","8100"]["0.1853","0.1226"][]["XCBO"]7100.00008100.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:14:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b580-5c07-7d81-a75b-5980612921eeSPX2026-09-18 13:11box_spread412551010.00shortbid7622.82005.5000["6000","7125"]["0.2487","0.1842"][]["XCBO"]6000.00007125.0000182182falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:11:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b57a-fd07-7ce1-bdeb-ed3479b122a6SPX2026-09-18 13:05box_spread412253980.00longask7623.82004.7000["7000","8000"]["0.1939","0.1242"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:06:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b577-cc9f-7310-928c-7b030cb8856bSPX2026-09-18 13:01box_spread411543335.00unknown—7622.99000.6000["7615","7630"]["0.1202","0.1138"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:02:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b576-8c4f-7921-878e-b18b5efdfd83SPX2026-09-18 13:00box_spread412254000.00shortbid7622.93004.8000["7000","8000"]["0.1940","0.1242"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:01:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-ae37-7303-9a89-bb79e9af970fSPX2026-09-18 12:55box_spread412219010.00shortbid7624.52002.4000["7400","7800"]["0.1636","0.1365"][]["XCBO"]7400.00007800.0000119119falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:56:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-2967-7891-993f-771df9e14bd9SPX2026-09-18 12:54box_spread411854792.00unknown—7624.82000.5000["7615","7630"]["0.1230","0.1192"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-257f-7d12-8c1f-04e57d2703c2SPX2026-09-18 12:54box_spread411648784.00unknown—7624.85000.6000["7615","7630"]["0.1234","0.1193"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-1daf-7561-a1ce-3e6e0f8f0c75SPX2026-09-18 12:54box_spread411442756.00unknown—7624.76000.5000["7615","7630"]["0.1238","0.1195"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b570-d377-77b3-9cf8-1702bb3ebbbdSPX2026-09-18 12:54box_spread41758240.00unknown—7624.91000.8000["7620","7625"]["0.0754","0.0746"][]["XCBO"]7620.00007625.000033falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:54:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b56b-9f6f-7c50-b1c1-d88bb84fffd9SPX2026-09-18 12:48box_spread412275506.00longask7619.92004.0000["7000","8000"]["0.1940","0.1264"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:48:47Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b566-28ff-71d3-bb10-e2e758811e15SPX2026-09-18 12:42box_spread412801990.00longask7620.470020.9000["4000","7930"]["0.5673","0.1191"][]["XCBO"]4000.00007930.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:42:47Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b565-0bd7-7740-a8bd-dd89677ab1acSPX2026-09-18 12:41box_spread41111395416.00longask7620.09003.0000["7000","8000"]["0.1939","0.1240"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:41:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b564-19a8-7052-86aa-66499277a83fSPX2026-09-18 12:40box_spread41101268560.00longask7620.07003.0000["7000","8000"]["0.1938","0.1241"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:40:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b563-a478-73a0-8bfa-a21b6f93e088SPX2026-09-18 12:39box_spread417722120.00shortbid7619.90007.9000["7000","8000"]["0.2053","0.1068"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:40:19Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b563-4aa0-7932-b267-8449c8b7b06fSPX2026-09-18 12:39box_spread412253640.00longask7620.37004.7000["7000","8000"]["0.1938","0.1239"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:39:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15