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:direction = unknown×ticker = XLP×
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
01a0c4e5-4437-7903-a036-c3dd4826c8e1XLP2026-09-21 12:55other4111052250.00unknown—82.25000.6100["82","83"]["0.1648","0.1657"][]["XISX"]82.000083.0000439falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:56:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4e5-4437-7903-a036-c3786a582c60XLP2026-09-21 12:55other416932775.00unknown—82.25000.6100["82","83"]["0.1648","0.1657"][]["XISX"]82.000083.0000439falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:56:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c486-2c77-7213-9bff-a0630a46b6ecXLP2026-09-21 11:12other4122574250.00unknown—81.94000.4800["81.5","82"]["0.1585","0.1531"][]["XISX"]81.500082.0000432falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:12:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47d-4eef-7311-b1d2-9a9bd657e6e8XLP2026-09-21 11:02other41250129750.00unknownask81.93000.3400["82.5","83"]["0.1512","0.1525"][]["XISX"]82.500083.0000425falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:02:40Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b517-3227-7bd3-9b2c-6fd1bf2fd037XLP2026-09-18 11:16put_ratio_spread211875010075000.00unknownbid83.07501.5700["55","85"]["0.2317","0.2083"]["6.92","79.04"]["SPHR"]55.000085.0000854854truefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:16:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e1-68a0-7b42-ac78-dc315281299cXLP2026-09-18 10:17other4118725619.00unknownbid82.96000.1200["82","82.5","83"]["0.1952","0.2001","0.2136"][]["XCBO"]82.000083.000007falsefalsetruetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:17:55Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d4-9f2f-7782-b940-b2d9db618572XLP2026-09-18 10:03other4125049500.00unknownbid83.05500.3300["82","82.5","83"]["0.1727","0.2153","0.1820"][]["XBOX"]82.000083.0000021falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:03:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0a6-66e3-79a3-98bb-6a725971b09cXLP2026-09-17 14:34put_vertical_spread211653717402.00unknown—83.46500.4100["85.5","86"]["0.3813","0.4583"][]["XBOX"]85.500086.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:34:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a6-4f73-7dc2-a5a0-d1a1ec6665c0XLP2026-09-17 14:34put_ladder3139202295536.00unknown—83.47000.7100["86","86.5","87"]["0.4636","0.5520","0.5440"][]["XBOX"]86.000087.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:34:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b002-9562-7b60-a668-54ac8f5dde56XLP2026-09-17 11:35put_vertical_spread2120030200.00unknown—83.11500.3500["80","81"]["0.1692","0.1669"][]["XMIO"]80.000081.00004343truetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:35:54Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abd6-54bb-7c90-9d5a-d8ba4529e1cbXLP2026-09-16 16:09other4380837174.00unknown—83.33000.2700["86","86.5","87","89"]["0.1360","0.2679","0.2712","0.3908"][]["AMXO"]86.000089.0000230falsetruetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T20:09:55Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab26-001a-7c51-9e0b-3e15a82c9572XLP2026-09-16 12:56other4113037440.00unknown—83.95500.3600["83","84"]["0.1970","0.1979"][]["XISX"]83.000084.0000216falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:57:19Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a185-4f20-7f10-8b13-3a65efdac213XLP2026-09-14 16:04other31800299200.00unknown—84.42003.3500["82","85"]["0.1698","0.1583"][]["XBOX"]82.000085.000032123falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T20:05:44Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a180-8878-7c70-ba18-b6ea2f44ff70XLP2026-09-14 15:59other311200456000.00unknown—84.44500.5600["82","85"]["0.1744","0.1597"][]["XBOX"]82.000085.000032123falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:59:21Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a08c9d-6d18-70e0-a883-9a9a273dfab6XLP2026-09-10 14:38other21548446072.00unknown—83.24500.4000["85.5","89"]["0.3849","0.3135"][]["XBOX"]85.500089.000018truefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:39:30Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a087a9-ae20-7151-a63a-615aa31a812fXLP2026-09-09 15:33other4110044600.00unknown—83.06500.3400["83","83.5"]["0.1772","0.1771"][]["XISX"]83.000083.5000230falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:34:03Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0874b-78f0-7e11-b092-a2ae2319eaf3XLP2026-09-09 13:51put_vertical_spread2313341162.00unknown—83.12500.0600["81","86"]["0.1722","0.1685"][]["XBOX","XCBO","XISX"]81.000086.000099falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:52:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0874b-7508-7c43-af24-6efde76c0030XLP2026-09-09 13:51put_vertical_spread2116651460.00unknown—83.12000.0400["81","86"]["0.1728","0.1677"][]["C2OX"]81.000086.000099falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:52:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0874b-7120-7970-9096-208f6306ee29XLP2026-09-09 13:51put_vertical_spread2410632860.00unknown—83.12000.0400["81","86"]["0.1728","0.1677"][]["C2OX","XCBO","XISX"]81.000086.000099falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:52:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0874b-6d38-7ad2-a64c-22bcfaf8bcd0XLP2026-09-09 13:51put_vertical_spread2116651792.00unknown—83.12000.0800["81","86"]["0.1759","0.1718"][]["XISX"]81.000086.000099falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:52:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0870e-7ba8-70e2-9d7f-7074ae6377daXLP2026-09-09 12:44other2130001660500.00unknown—82.99500.8800["85","95"]["0.1872","0.1333"][]["XBOX"]85.000095.0000499499falsefalsefalsetruetruemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:44:51Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0866d-0b88-7810-9541-73d9d75924faXLP2026-09-09 09:48other218740368.00unknown—83.18000.5000["85"]["0.2740"][]["XBOX"]85.000085.0000216falsefalsetruefalsefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:48:19Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0866d-0b88-7810-9541-73ca0b385514XLP2026-09-09 09:48other2511349419.00unknown—83.18000.5124["85"]["0.2264"][]["ARCO","EMLD","SPHR","XBOX","XPHO"]85.000085.0000216falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:48:19Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08221-5c00-7782-94e0-9c3f649a2e22XLP2026-09-08 13:46other2130002062500.00unknown—83.94230.8000["80","85"]["0.1925","0.1105"][]["SPHR"]80.000085.0000500500falsetruefalsetruetruemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:47:44Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08142-1f90-7030-826b-46d118d44634XLP2026-09-08 09:43other214037640.00unknown—84.06500.7600["83","91"]["0.1796","0.2049"][]["XISX"]83.000091.000024282falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:43:12Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06dfd-08dd-7560-b8ef-717ed362bdbbXLP2026-09-04 15:54put_vertical_spread2125027250.00unknown—84.59500.2000["82.5","83"]["0.1648","0.1637"][]["XCBO"]82.500083.00002121falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:55:02Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06def-83ed-7441-82c7-ab3635783e0bXLP2026-09-04 15:40other2130002137500.00unknown—84.69080.7500["80","85"]["0.1883","0.1267"][]["XBOX"]80.000085.0000504504falsetruefalsetruetruemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:40:09Z"}2026-09-042026-09-07 00:532026-09-07 00:53