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: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
01a0c481-562e-7692-8915-328dadb40074SPX2026-09-21 11:06box_spread414531968.00shortbid7725.010012.3000["7200","8200"]["0.1816","0.1235"][]["XCBO"]7200.00008200.0000116116falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c481-2b36-7413-9bc4-1aa48c40ca6cSPX2026-09-21 11:06box_spread4181043744.00longask7724.88006.1000["7000","8000"]["0.1976","0.1256"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47f-98df-7003-a54f-4b1255240547SPX2026-09-21 11:04box_spread4130755730.00longask7724.19005.7000["7620","7700"]["0.1186","0.1053"][]["XCBO"]7620.00007700.000099falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:04:55Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47f-5e46-7153-8a6a-afce90f5e4e7SPX2026-09-21 11:04box_spread412598738.00longask7723.28006.4000["6000","7000"]["0.2568","0.1953"][]["XCBO"]6000.00007000.0000179179falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:04:55Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47d-b097-7330-b45a-b1ea2ca7f9e1SPX2026-09-21 11:02box_spread41101210150.00shortbid7722.31004.2000["7600","7800"]["0.1555","0.1441"][]["XCBO"]7600.00007800.0000151151falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:03:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47d-089f-7501-98d2-28003d9645d6SPX2026-09-21 11:02box_spread416782100.00unknown—7722.54004.0000["7000","8000"]["0.1976","0.1256"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:02:15Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47c-dda6-7ec3-bce7-435b2c773f5aSPX2026-09-21 11:01box_spread4151076180.00longask7722.43006.7000["8000","9000"]["0.1621","0.1382"][]["XCBO"]8000.00009000.0000361361falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:02:15Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c475-7b07-7640-a4b3-2e3791e7fd9cSPX2026-09-21 10:53box_spread413426666.00shortbid7719.81007.7000["7000","8000"]["0.1971","0.1291"][]["XCBO"]7000.00008000.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:54:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c474-4e3f-7401-b501-a020b8109f17SPX2026-09-21 10:52box_spread41123400776.00shortbid7719.44006.6000["6000","8000"]["0.2437","0.1526"][]["XCBO"]6000.00008000.0000269269falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:52:34Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c472-044f-7351-b724-84b3f4f21597SPX2026-09-21 10:49box_spread4110102430.00unknown—7721.00001.1500["7650","7750"]["0.1976","0.1273"][]["XCBO"]7650.00007750.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:50:13Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46f-f4f7-7cf2-b618-db2446899141SPX2026-09-21 10:47box_spread4110102630.00longask7721.80001.2500["7650","7750"]["0.1698","0.1209"][]["XCBO"]7650.00007750.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:47:53Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46d-31ef-7073-99a3-92e2e1fe64f8SPX2026-09-21 10:44box_spread412338572.00longask7719.89006.9000["7000","8000"]["0.1954","0.1404"][]["XCBO"]7000.00008000.0000179179falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:52Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46d-1e67-7353-ae61-a23e1100ac9aSPY2026-09-21 10:44box_spread417375739.00shortbid768.92507.7800["500","510"]["0.4751","0.4613"][]["EMLD"]500.0000510.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:52Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46d-1697-7632-bcaf-3ed2e73651d1SPY2026-09-21 10:44box_spread413161031.00shortbid768.92007.7800["500","510"]["0.4753","0.4615"][]["EMLD"]500.0000510.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:52Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46c-cc5f-7612-beee-d3ac15e2b896SPX2026-09-21 10:44box_spread412203996.00longask7719.88004.1000["7650","7750"]["0.1481","0.1417"][]["XCBO"]7650.00007750.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46a-4fa7-7620-a4a0-88dd5896c299IWM2026-09-21 10:41box_spread411981573902.00shortbid285.72003.7100["235","305"]["0.2749","0.1781"][]["XMIO"]235.0000305.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:41:54Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46a-4007-78b2-bc88-c0d14e72a433IWM2026-09-21 10:41box_spread4152413348.00shortbid285.72003.7000["235","305"]["0.2749","0.1781"][]["XMIO"]235.0000305.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:41:54Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c468-f017-7ad3-ba02-9f427ae50c92GLD2026-09-21 10:40box_spread421031195189.00shortbid397.45001.5000["340","440"]["0.2526","0.2482"][]["AMXO","XMIO"]340.0000440.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:40:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c468-ec2f-7be3-ab06-33b617f6143eGLD2026-09-21 10:40box_spread4249568645.00shortbid397.45001.5000["340","440"]["0.2529","0.2482"][]["EMLD","SPHR"]340.0000440.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:40:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c467-6d5f-7b32-8911-2695bd02c6e0SPX2026-09-21 10:38box_spread413307560.00unknown—7724.47004.0000["7650","7750"]["0.1486","0.1422"][]["XCBO"]7650.00007750.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:38:37Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c465-e6be-73a0-bead-d1949a1996b9SPX2026-09-21 10:36box_spread4131298145.00longask7723.12009.0000["4500","7000"]["0.4169","0.1952"][]["XCBO"]4500.00007000.0000151151falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:36:51Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c465-330e-7ce2-8ff0-1473ac6363c0SPX2026-09-21 10:35box_spread4141694012.00longask7721.840024.5000["4500","7000"]["0.4324","0.1974"][]["XCBO"]4500.00007000.0000116116falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:36:03Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c464-0647-77c0-9fe4-ecf7d3777049SPY2026-09-21 10:34box_spread424214774.00shortbid769.10505.6100["500","510"]["0.4694","0.4573"][]["ARCO","EMLD"]500.0000510.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:34:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c45f-476e-7c53-8ee1-db5f38e28e0fSPX2026-09-21 10:29box_spread413426840.00longask7721.13006.8000["7000","8350"]["0.2024","0.1196"][]["XCBO"]7000.00008350.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:29:36Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c45e-8fd7-7503-8fa1-71951b3d3605SPX2026-09-21 10:28box_spread412261116.00longask7723.09004.4000["7200","7700"]["0.1813","0.1451"][]["XCBO"]7200.00007700.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:28:37Z"}2026-09-212026-09-21 17:152026-09-21 17:15
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
01a0c45a-a7d6-7d43-ab7d-95d08b0d9997SPX2026-09-21 10:24box_spread411045000.00shortbid7720.87000.4000["7720","7745"]["0.1110","0.1201"]["0","7720","7745"]["XCBO"]7720.00007745.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:24:39Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-c7a6-77a3-a80a-0bcd6ef5f594SPX2026-09-21 10:20box_spread413480630.00unknown—7715.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.00unknown—256.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
01a0c44f-229f-78e3-9397-a42b68256767SPX2026-09-21 10:11box_spread412366122.00longask7705.280022.9000["6500","7500"]["0.2406","0.1556"][]["XCBO"]6500.00007500.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:11:58Z"}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.00unknown—7705.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
01a0c445-b877-71f2-9af5-f30910c896daSPX2026-09-21 10:01box_spread412701326.00longask7707.290026.6000["7450","8050"]["0.1944","0.1811"][]["XCBO"]7450.00008050.0000816816falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:01:49Z"}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
01a0c436-1876-7d52-a94c-b78168e9f475SPX2026-09-21 09:44box_spread412475928.00longask7697.87008.5000["7000","8050"]["0.2002","0.1592"][]["XCBO"]7000.00008050.0000361361falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:44:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c435-e1c7-75c1-9b10-73784aab6678SPX2026-09-21 09:44box_spread41836320.00shortbid7696.72000.5500["7670","7700"]["0.1045","0.0969"]["0","7670","7700"]["XCBO"]7670.00007700.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:44:30Z"}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