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 = short×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
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
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
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
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
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
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
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-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
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
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
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
01a0b5e8-e5bf-7c71-8d06-e23ecb56bd52SPX2026-09-18 15:05box_spread422032440.00shortbid7642.74000.5000["7640","7645"]["0.1298","0.1233"]["0","7640","7645"]["XCBO"]7640.00007645.000000falsefalsefalsetruetruemlettrackeduw_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
01a0b5e7-d837-7ac0-b93f-ba0fd2cd5e51SPY2026-09-18 15:04box_spread41327429.00shortbid761.34500.7200["735","795"]["0.1617","0.1240"][]["EMLD"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e7-d837-7ac0-b93f-b9f5349c0c7cSPY2026-09-18 15:04box_spread43763975.00shortbid761.34500.7200["735","795"]["0.1618","0.1237"][]["ARCO","EMLD","XMIO"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e6-651f-7711-8c6c-14092417d4f4SPY2026-09-18 15:02box_spread42982317.00shortbid761.18000.4133["735","795"]["0.1620","0.1238"][]["ARCO","EMLD"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:02:57Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e0-3b00-7b82-b303-d73255cf2b54SPX2026-09-18 14:56box_spread412449500.00shortbid7643.64009.5000["7900","8100"]["0.1687","0.1625"][]["XCBO"]7900.00008100.0000455455falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:56:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
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-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-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
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
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
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
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
01a0b5b0-af20-75f1-aa74-9ee350d4628cSPX2026-09-18 14:04box_spread414929960.00shortbid7629.59006.2000["7000","8050"]["0.1985","0.1569"][]["XCBO"]7000.00008050.0000364364falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:04:31Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b590-32b8-71e1-812a-42ecf971378aSPX2026-09-18 13:28box_spread413795120.00shortbid7625.96008.7000["7100","7700"]["0.1950","0.1751"][]["XCBO"]7100.00007700.0000455455falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:29:16Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58d-f097-71d3-953c-c5afaa22af3bSPX2026-09-18 13:26box_spread4282959200.00shortbid7625.500051.2000["6900","7900"]["0.2051","0.1822"][]["XCBO"]6900.00007900.0000819819falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:26:47Z"}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
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
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
01a0b57c-b66f-7a12-9994-10064877d0e9SPX2026-09-18 13:07box_spread41269350.00shortbid7624.680010.2000["7500","7750"]["0.1345","0.0994"][]["XCBO"]7500.00007750.00001414falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:08:07Z"}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
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
01a0b560-6857-7f81-b5e9-fe6162b0d9f5SPX2026-09-18 12:36box_spread414507352.00shortbid7621.62005.8000["7000","8000"]["0.1937","0.1239"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:37:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55f-8d97-7673-996a-3d6b270691f8SPX2026-09-18 12:35box_spread412253720.00shortbid7621.49003.7000["7000","8000"]["0.1939","0.1239"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:35:50Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-ca8f-75a1-ae30-fb7be7293025SPX2026-09-18 12:32box_spread41111394800.00shortbid7617.99004.2000["7000","8000"]["0.1937","0.1242"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:32:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55b-3067-7690-908a-7654e7157275SPX2026-09-18 12:30box_spread41253171100.00shortbid7619.06004.1000["7000","8000"]["0.1938","0.1242"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:31:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55a-327f-7bc1-ac80-9e4deeb49d2eSPX2026-09-18 12:29box_spread412275410.00shortbid7618.57005.6000["7000","8000"]["0.1938","0.1265"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:30:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b556-cb68-7a90-84a8-2a9a01c10f4eSPX2026-09-18 12:25box_spread41204572660.00shortbid7611.60004.8000["6000","7000"]["0.3807","0.2047"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:26:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54f-3600-71d0-98a8-13ea62e61f2aSPX2026-09-18 12:17box_spread413346125.00shortbid7620.54004.7000["7000","8000"]["0.1959","0.1178"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:17:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54d-9fbf-77a3-927e-0d911c866c25SPX2026-09-18 12:15box_spread412275462.00shortbid7620.30008.8000["7000","8000"]["0.1936","0.1265"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:16:26Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54c-673f-76b1-823a-24937249f4f5SPX2026-09-18 12:14box_spread413346110.00shortbid7621.13003.8000["7000","8000"]["0.1961","0.1175"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:15:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b549-0fc7-72d2-aa5a-61c7e63b3f8bSPX2026-09-18 12:10box_spread412326770.00shortbid7621.59004.2000["7000","8000"]["0.1915","0.1379"][]["XCBO"]7000.00008000.0000182182falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:11:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b548-bdc0-7c81-afa4-3dec8505ca23SPX2026-09-18 12:10box_spread412326758.00shortbid7622.02003.8000["7000","8000"]["0.1915","0.1378"][]["XCBO"]7000.00008000.0000182182falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:11:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15