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:endpoint = /api/option-trades/multi-leg×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
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
01a0b625-0847-7920-bd39-f0b5d5a61243SPX2026-09-18 16:11box_spread41111403655.00shortbid7650.50005.0000["7000","8000"]["0.1972","0.1216"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_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-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-a037-7651-b6f9-df68cb8fcddbSPX2026-09-18 15:59box_spread424508200.00unknown—7647.45005.2000["7000","8000"]["0.1921","0.1230"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-947f-7451-bf90-6e20d2a03678SPX2026-09-18 15:59box_spread415500595.00unknown—7647.810010.3500["7000","8000"]["0.2863","0.1429"][]["XCBO"]7000.00008000.000077falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-947f-7451-bf90-6df3b5f3b016SPX2026-09-18 15:59box_spread412336540.00shortbid7647.81001.4261["7635","7645"]["2.0176","0.5110"][]["XCBO"]7635.00007645.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:54Z"}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-9a7f-7d62-b97e-b4e84f657153SPX2026-09-18 15:58box_spread414508160.00unknown—7646.87004.4000["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-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
01a0b617-ecd0-7883-884e-9cda44d9de2dSPX2026-09-18 15:56box_spread41101154150.00shortbid7646.89005.1000["7000","8000"]["0.1955","0.1155"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemlatmarket_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
01a0b617-7b87-7f10-bef4-59bb8b1e0d19SPX2026-09-18 15:56box_spread41252885375.00unknown—7646.82005.1000["7000","8000"]["0.1954","0.1156"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:56:28Z"}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
01a0b614-79ff-7560-8688-8621defa55ddSPX2026-09-18 15:53box_spread41101153400.00shortbid7643.77005.8000["7000","8000"]["0.1962","0.1151"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:53:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-8fa0-7392-bbda-e9f954fd3eb0SPX2026-09-18 15:52box_spread417807310.00unknown—7642.23004.4000["7000","8000"]["0.1969","0.1148"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_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
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
01a0b612-c098-79f0-a884-d3f5dff26b38GLD2026-09-18 15:51box_spread4220298700.00shortbid401.64001.0138["350","475"]["0.2414","0.2707"][]["ARCO"]350.0000475.0000154154falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:51:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b612-283f-7322-b200-aade0a4dbce3SPX2026-09-18 15:50box_spread4161263624.00shortbid7643.15007.0000["8000","9000"]["0.1566","0.1337"][]["XCBO"]8000.00009000.0000336336falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:50:46Z"}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
01a0b60e-b187-75b0-a318-9487696f8f36SPX2026-09-18 15:46box_spread412230820.00unknown—7644.23003.8000["7000","8000"]["0.1966","0.1151"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:05Z"}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
01a0b608-ecf7-7df3-8aeb-a17ccd14dd86SPX2026-09-18 15:40box_spread412542800.00shortbid7640.65007.6000["6550","8700"]["0.2169","0.1393"][]["XCBO"]6550.00008700.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:40:42Z"}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
01a0b5ff-6f47-7320-bfc3-7bbecdd19eaeSPX2026-09-18 15:30box_spread421927930.00shortbid7638.57000.5605["7640","7645"]["0.1404","0.1326"]["0","7640","7645"]["XCBO"]7640.00007645.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:30:24Z"}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
01a0b5fc-7d5f-7372-beb2-63845b39ae89SPX2026-09-18 15:26box_spread4121041992.00shortbid7640.3300150.0000["6000","7400"]["0.2238","0.2025"][]["XCBO"]6000.00007400.000011901190falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:26:59Z"}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
01a0b5fa-9517-7a32-8b63-5a9a94513fadSPX2026-09-18 15:24box_spread41285582.00shortbid7640.04005.6000["7600","7800"]["0.1255","0.1051"][]["XCBO"]7600.00007800.00002828falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:25:07Z"}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
01a0b5ed-6617-7320-8717-4c1250564331SPX2026-09-18 15:10box_spread4110100330.00unknown—7642.34001.5500["7600","7700"]["0.3297","0.3119"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_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
01a0b5eb-81b7-7870-a5bb-ce40b207700fSPX2026-09-18 15:08box_spread412400012.00shortbid7641.66008.8500["7000","8000"]["0.1953","0.1494"][]["XCBO"]7000.00008000.0000272272falsefalsefalsetruetruemletmarket_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
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
01a0b5ea-9370-72a3-9b46-2972ff24ab8aSPX2026-09-18 15:07box_spread412714508.00shortbid7641.490011.2000["6000","7250"]["0.2295","0.1904"][]["XCBO"]6000.00007250.0000455455falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:07:33Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e9-2828-7d20-84ff-285616e9e9bfSPX2026-09-18 15:05box_spread4110100330.00unknown—7643.07001.3500["7600","7700"]["0.3252","0.2959"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:05:50Z"}2026-09-182026-09-18 17:152026-09-18 17:15