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:direction = long×strategy = box_spread×ticker = SPX×
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
01a0b628-34c7-7131-b314-871a27c2c52dSPX2026-09-18 16:14box_spread41496253625.00longask7650.50004.9000["7000","8000"]["0.1971","0.1217"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b623-b46f-7c82-ae3a-eff8c43838b4SPX2026-09-18 16:09box_spread412378884.00longask7650.50004.6000["6500","7500"]["0.2364","0.1555"][]["XCBO"]6500.00007500.0000119119falsefalsefalsetruetruemletmarket_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
01a0b61f-3800-7c82-8af6-ccab9c6589d8SPX2026-09-18 16:04box_spread412231330.00longask7650.50005.1000["7000","8000"]["0.1994","0.1141"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_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
01a0b61b-f7f7-7822-b56d-ce582716e613SPX2026-09-18 16:01box_spread415577775.00longask7650.12005.2000["7000","8000"]["0.1978","0.1145"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61b-e087-7703-9578-926691b39154SPX2026-09-18 16:01box_spread41252888125.00longask7650.12004.4000["7000","8000"]["0.1972","0.1148"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61b-9268-7061-bae1-a31dea59fed2SPX2026-09-18 16:00box_spread41252888025.00longask7650.12004.9000["7000","8000"]["0.1965","0.1152"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61b-53e8-79e3-a717-642dcdb6ed8dSPX2026-09-18 16:00box_spread41252886875.00longask7650.12004.6000["7000","8000"]["0.1950","0.1158"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61b-05c7-7640-9dc8-8d24427231feSPX2026-09-18 16:00box_spread41252885875.00longask7650.12005.4000["7000","8000"]["0.1937","0.1163"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-7157-7bb0-adf8-e6e785d6580dSPX2026-09-18 15:59box_spread413381285.00longask7647.85004.8000["7000","8000"]["0.1926","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:44Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-4a47-7bc0-bdf1-a7fb96c7afeaSPX2026-09-18 15:59box_spread412254110.00longask7646.98004.6000["7000","8000"]["0.1925","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:32Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-0faf-7711-a38f-f70e9558d3b1SPX2026-09-18 15:59box_spread41252885625.00longask7646.64004.6000["7000","8000"]["0.1956","0.1155"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-f06f-7772-be28-916db34a2eb1SPX2026-09-18 15:59box_spread41333398175.00longask7645.51005.2000["7000","8000"]["0.2068","0.1017"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-d518-71c1-8a81-ba7268564e57SPX2026-09-18 15:58box_spread414508080.00longask7645.81004.3000["7000","8000"]["0.1924","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_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-92b0-7d03-a6ae-fa7bc79cee43SPX2026-09-18 15:58box_spread41202540600.00longask7646.50004.5000["7000","8000"]["0.1925","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:58:52Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-542f-7a81-9ef9-0fa21619f242SPX2026-09-18 15:58box_spread413381255.00longask7647.09004.6000["7000","8000"]["0.1926","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_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-0c58-7863-b808-90d5c2fee8feSPX2026-09-18 15:54box_spread417807485.00longask7643.85005.2000["7000","8000"]["0.1965","0.1150"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:55:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b615-be37-7712-905b-922d3efaeef5SPX2026-09-18 15:54box_spread412254090.00longask7643.42004.6000["7000","8000"]["0.1939","0.1223"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:54:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-5cd8-7553-b2e5-33a9ccd25f60SPX2026-09-18 15:51box_spread41505146250.00longask7642.80004.7000["7000","8000"]["0.2091","0.0992"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:51:55Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b610-8648-71f0-9fc7-31d6c045a0bfSPX2026-09-18 15:48box_spread412421096.00longask7645.48009.9500["8000","9000"]["0.1567","0.1337"][]["XCBO"]8000.00009000.0000336336falsefalsefalsetruetruemletmarket_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
01a0b60c-540f-78b2-9627-4fbd15253b09SPX2026-09-18 15:44box_spread417889560.00longask7643.60003.5000["7000","8000"]["0.1935","0.1227"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_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
01a0b604-9797-7220-b80b-09d03489cabdSPX2026-09-18 15:35box_spread412422016.00longask7637.66005.9000["8000","9000"]["0.1566","0.1339"][]["XCBO"]8000.00009000.0000336336falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:36:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b602-a398-7b22-989d-687bc514e62bSPX2026-09-18 15:33box_spread41283555320.00longask7637.14003.9000["7000","8000"]["0.1937","0.1229"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:33:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b601-9ddf-7d21-94cc-ce4817a3d35fSPX2026-09-18 15:32box_spread4121271484.00longask7637.47001124.7000["6000","7600"]["0.2186","0.2070"][]["XCBO"]6000.00007600.000019181918falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:32:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fc-c3af-79e1-a895-9b71f2b7dbd7SPX2026-09-18 15:27box_spread417889147.00longask7640.49003.5000["7000","8000"]["0.1936","0.1227"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:27:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fb-ba0f-7952-9396-28006569062cSPX2026-09-18 15:26box_spread416546384.00longask7639.67001.8000["7500","7700"]["0.1527","0.1380"][]["XCBO"]7500.00007700.00009191falsefalsefalsetruetruemletmarket_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
01a0b5f4-b52f-70e3-81ab-acb880552215SPX2026-09-18 15:18box_spread41181853280.00longask7642.08004.2000["7000","8000"]["0.2069","0.1016"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:18:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f3-fd97-7e10-ade4-7f8fc4423695SPX2026-09-18 15:17box_spread416617790.00longask7641.65004.7000["7000","8000"]["0.2074","0.1012"][]["XCBO"]7000.00008000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:17:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f2-9a1f-76f3-bc62-ff451cbe2e0dSPX2026-09-18 15:16box_spread412276376.00longask7641.67004.8000["7000","8000"]["0.1938","0.1257"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:16:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f0-f827-75b0-ac38-0b6f22c40a69SPX2026-09-18 15:14box_spread4110100330.00longask7641.03001.4500["7600","7700"]["0.3144","0.3030"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:14:50Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5eb-6277-7903-8ab7-3031220e1a70SPX2026-09-18 15:08box_spread412421192.00longask7641.65007.9000["8000","9000"]["0.1564","0.1337"][]["XCBO"]8000.00009000.0000336336falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:08:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e3-5fb0-71b2-852f-ddf7747f9738SPX2026-09-18 14:59box_spread412410520.00longask7642.08003.6000["6000","7925"]["0.2869","0.1178"][]["XCBO"]6000.00007925.00006363falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:59:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e0-fe4f-72e0-b2fd-8e053920e606SPX2026-09-18 14:56box_spread41101523140.00longask7643.08004.1000["7000","8000"]["0.1924","0.1315"][]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruemfslmarket_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-fa67-7b63-a8c7-4a9b445f5668SPX2026-09-18 14:56box_spread41101523140.00longask7643.08004.1000["7000","8000"]["0.1924","0.1315"][]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruemfslmarket_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-fa67-7b63-a8c7-4a8faf66eff7SPX2026-09-18 14:56box_spread41182741652.00longask7643.08004.1000["7000","8000"]["0.1924","0.1315"][]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruemfslmarket_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-fa67-7b63-a8c7-4a784bee55caSPX2026-09-18 14:56box_spread4191370826.00longask7643.08004.1000["7000","8000"]["0.1924","0.1315"][]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruemfslmarket_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-fa67-7b63-a8c7-4a69ad53193fSPX2026-09-18 14:56box_spread41233503222.00longask7643.08004.1000["7000","8000"]["0.1924","0.1315"][]["XCBO"]7000.00008000.0000154154falsefalsefalsetruetruemfslmarket_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
01a0b5df-ba18-7b91-b84a-79365d963d75SPX2026-09-18 14:55box_spread413381435.00longask7642.91004.6000["7000","8000"]["0.1937","0.1229"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:55:34Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5dc-89af-7c21-911d-416827b7b6bbSPX2026-09-18 14:52box_spread412254222.00longask7642.76003.8000["7000","8000"]["0.1935","0.1229"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:52:26Z"}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
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
01a0b5cf-c427-7782-97ff-3ec40ec031c2SPX2026-09-18 14:38box_spread415244400.00longask7633.700010.6000["7430","7830"]["0.1452","0.0980"][]["XCBO"]7430.00007830.00002121falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:46Z"}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
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
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
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
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
01a0b5af-18df-73e0-b130-0fa439673bcbSPX2026-09-18 14:02box_spread412207212.00longask7629.22005.0000["7400","8100"]["0.1602","0.1216"][]["XCBO"]7400.00008100.00009191falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:02:45Z"}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