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.

367,592 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_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
01a0c45e-60f7-7180-a0ad-890a4a06735eSPX2026-09-21 10:28box_spread41394603326.00longask7722.13004.7000["7000","8000"]["0.2018","0.1196"][]["XCBO"]7000.00008000.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:28:19Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c45b-ff97-78e3-b7c4-3063e232b32dSPX2026-09-21 10:25box_spread412265692.00longask7721.70005.6000["7200","8200"]["0.1814","0.1233"][]["XCBO"]7200.00008200.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:26:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-c7a6-77a3-a80a-0bcd6ef5f594SPX2026-09-21 10:20box_spread413480630.00unknown7715.13005.6000["7325","7925"]["0.1773","0.1473"][]["XCBO"]7325.00007925.0000207207falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:24Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c454-b84f-7ce1-8fee-dc852f5dbd2dSPX2026-09-21 10:17box_spread4193356262.00shortbid7714.250033.2000["7000","8000"]["0.2042","0.1822"][]["XCBO"]7000.00008000.0000816816falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:18:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c451-a727-77f3-bfd9-d80c1bb88d25AMZN2026-09-21 10:14box_spread412002287200.00unknown256.90502.9100["200","300"]["0.3979","0.3642"][]["XISX"]200.0000300.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:14:49Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c448-15ef-71d3-9009-0a4b63eb55cfSPX2026-09-21 10:04box_spread413628695.00shortbid7705.60004.5000["6000","7695"]["0.2916","0.1352"][]["XCBO"]6000.00007695.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:04:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c447-df3f-75d0-abb5-1a26281114f9SPX2026-09-21 10:03box_spread41276649155.00unknown7705.30009.1500["6000","7000"]["0.3550","0.2199"][]["XCBO"]6000.00007000.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:04:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c440-b34f-76d3-b854-dfce28d14252SPX2026-09-21 09:56box_spread41151943370.00longask7705.50005.2000["7000","8000"]["0.1973","0.1256"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:56:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c43e-80cf-7880-8944-2bbd17ec6460SPX2026-09-21 09:53box_spread412246020.00longask7704.220012.7000["7200","8200"]["0.1811","0.1226"][]["XCBO"]7200.00008200.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:53:58Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c43b-a26f-7be0-a4fd-eed91fe0b16dSPX2026-09-21 09:50box_spread4172598680.00shortbid7700.680031.7000["7000","8000"]["0.2039","0.1819"][]["XCBO"]7000.00008000.0000816816falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:50:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c432-efdf-7bb2-9846-bdc27d2460d5SPX2026-09-21 09:41box_spread4151174245.00longask7696.96009.9000["7450","7650"]["0.1826","0.1754"][]["XCBO"]7450.00007650.0000389389falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:41:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c431-1b1e-7ea1-97b6-54b4ec9cf76aSPX2026-09-21 09:39box_spread4120770580.00shortbid7696.64001.4000["7690","7700"]["0.1201","0.1189"][]["XCBO"]7690.00007700.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:39:16Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c42c-8b27-7cf0-9e34-d780a9ca3e3fSPX2026-09-21 09:34box_spread414466056.00longask7694.98006.5000["7000","8000"]["0.2010","0.1173"][]["XCBO"]7000.00008000.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:34:14Z"}2026-09-212026-09-21 17:152026-09-21 17:15
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.00unknown7647.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.00unknown7647.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-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.00unknown7646.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-7b87-7f10-bef4-59bb8b1e0d19SPX2026-09-18 15:56box_spread41252885375.00unknown7646.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.00unknown7642.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-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.00unknown7644.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
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