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×ticker = XLE×
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
01a087a5-4150-7dd0-a4c9-b7e8c37ff910XLE2026-09-09 15:29call_vertical_spread2120035200.00longask65.47500.0700["65","67.5"]["0.2671","0.2623"]["66.0"]["XMIO"]65.000067.500099falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:29:20Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08781-6d70-7672-b9df-7d98e7b001d8XLE2026-09-09 14:49call_vertical_spread218067840.00shortbid65.39500.2000["64","65"]["0.2494","0.2511"]["64.52"]["XISX"]64.000065.0000100100falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:50:11Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08770-6de0-7d33-a65d-95283093cf27XLE2026-09-09 14:31put_vertical_spread212036640.00longask65.35000.5000["74","75"]["4.3908","3.2756"]["74.02"]["BATO"]74.000075.000000falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:31:42Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08742-2251-7a92-96b6-c325722bf042XLE2026-09-09 13:40call_diagonal_spread211435728.00unknown—65.41001.0500["50","57.5"]["0.3077","0.2074"][]["XMIO"]50.000057.5000128203falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:41:16Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086c3-6500-79a1-bad4-e83a1a45f5a2XLE2026-09-09 11:22call_diagonal_spread272836682.00longbid65.27500.2500["57.5","62.5"]["0.4092","0.2449"][]["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"]57.500062.50009100falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:22:35Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086c3-6500-79a1-bad4-e817c65e8591XLE2026-09-09 11:22call_diagonal_spread275369437.00longbid65.27500.2500["57.5","62.5"]["0.4064","0.2449"][]["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"]57.500062.50009100falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:22:35Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086c3-6500-79a1-bad4-e80f774108a1XLE2026-09-09 11:22call_diagonal_spread275369433.00longbid65.27500.2500["57.5","62.5"]["0.4058","0.2449"][]["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"]57.500062.50009100falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:22:35Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08688-6b59-7cb3-b2e7-21bfb70f61e8XLE2026-09-09 10:17straddle2410072200.00shortbid65.25000.3500["65"]["0.2656"]["57.78","72.22"]["ARCO","EDGO","XBOX","XPHO"]65.000065.0000100100falsefalsefalsefalsetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:18:09Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08672-10b0-7640-98c0-930a48025274XLE2026-09-09 09:53call_vertical_spread211526835.00longask65.77000.9000["55","60"]["0.2598","0.2340"]["59.25"]["AMXO"]55.000060.00007272falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:53:37Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0865d-5fd1-7293-b34c-a9a971ee51b3XLE2026-09-09 09:30call_vertical_spread211526220.00longask65.68500.6500["57.5","65"]["0.2155","0.2302"]["62.0"]["XMIO"]57.500065.0000281281falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:30:59Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0826a-28b8-7990-b9d5-837999bb1a37XLE2026-09-08 15:06put_diagonal_spread219267252.00unknown—64.85000.4100["60","63"]["0.2697","0.2792"][]["EDGO"]60.000063.0000192374falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:06:36Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08231-a7e0-7f42-b63c-918380ae6138XLE2026-09-08 14:04call_calendar212961185598.00shortbid64.67702.2500["45"]["0.7441"][]["XCBO"]45.000045.000010192falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:05:26Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081ae-a8b8-7423-af61-052ae4005798XLE2026-09-08 11:41other212253350.00unknown—64.78001.9000["52.5","53"]["0.7851","0.4630"][]["BATO"]52.500053.00001045falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:41:53Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08192-7210-7473-94c4-63d309e82c08XLE2026-09-08 11:10other2118025920.00unknown—64.87500.0700["62","63"]["0.2504","0.2710"][]["XMIO"]62.000063.0000838falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:11:10Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0818a-e091-7a72-b8c2-8d9cc94c9439XLE2026-09-08 11:02other211032590.00unknown—64.81501.7000["50"]["0.2614"][]["AMXO"]50.000050.0000101465falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:02:59Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0815f-92a1-7722-ba0c-17151c4cdc62XLE2026-09-08 10:15call_diagonal_spread214086040.00unknown—65.16001.4500["55","57"]["0.1656","0.1857"][]["XMIO"]55.000057.0000192204falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:15:28Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08151-1798-7781-9112-d90486c3cef2XLE2026-09-08 09:59call_vertical_spread261833690.00shortbid64.80000.7833["60","80"]["0.1817","0.2198"]["67.30"]["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"]60.000080.0000829829falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:59:44Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08142-42b8-7022-a953-d9420262fbadXLE2026-09-08 09:43call_vertical_spread213051570.00longask64.86010.7000["54","59"]["0.3427","0.1828"]["58.85"]["XMIO"]54.000059.00003838falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:43:31Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06d7c-f7b5-77f3-84e8-de4edbdf0e44XLE2026-09-04 13:34call_calendar211028330.00shortask64.21503.3500["50"]["7.2743"][]["BATO"]50.000050.000007falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:35:32Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d75-db65-7b91-8c57-48644cd04025XLE2026-09-04 13:27call_vertical_spread215038850.00shortbid64.16500.2500["62.5","65"]["0.2362","0.2408"]["63.75"]["XMIO"]62.500065.0000105105falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:27:29Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d46-3fe5-7ab1-84f5-dc5a0dda692eXLE2026-09-04 12:35other247633646.00unknown—64.08500.2600["57.5","60"]["0.2861","0.2678"][]["ARCO","EDGO","XBOX","XISX"]57.500060.000014469falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:35:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d45-7c95-7d32-96e9-32f71cb9cf0eXLE2026-09-04 12:34other2310636781.00unknown—64.09500.2200["54","57.5"]["0.3778","0.2668"][]["EDGO","XBOX","XISX"]54.000057.500014469falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:34:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d44-d49d-7ed2-9fe0-e43ad4de0778XLE2026-09-04 12:33other2110847898.00unknown—64.11000.2600["57.5","60"]["0.2840","0.2684"][]["EDGO"]57.500060.000014469falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:34:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53