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:ticker = XLI×sorted by executed_at ↑×
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
01a06d36-cadd-75e0-971a-c41cc38d8b66XLI2026-09-04 12:18strangle211500975000.00shortbid175.27000.6600["174","178"]["0.1905","0.1614"]["167.50","184.50"]["SPHR"]174.0000178.00004242truetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:18:31Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06ddf-d065-71f1-9d2c-5a229ee84100XLI2026-09-04 15:22call_backspread213000396000.00longbid175.01000.3100["177.5","180"]["0.1628","0.1661"]["182.54"]["XPHO"]177.5000180.00001414falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:23:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a0813d-1a68-7512-82f9-57bfb3209b3bXLI2026-09-08 09:37call_vertical_spread211400257600.00unknown—175.28000.9000["185","190"]["0.1887","0.1904"][]["XBOX"]185.0000190.00003838truetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:37:49Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081f1-37c8-7341-abec-8c220c8c26fcXLI2026-09-08 12:54put_frontspread22372312101.00longask175.13001.2000["140","157"]["0.2553","0.2428"]["119.42","156.76"]["XCBO"]140.0000157.0000500500truetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:54:31Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08792-1711-7ba2-80e7-ca866164951cXLI2026-09-09 15:08strangle2114002044000.00unknown—172.01001.3000["170","180"]["0.1968","0.1888"][]["ARCO"]170.0000180.0000191191truetruefalsetruetruemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:08:34Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08ba1-32c9-7133-aa0a-66ff712581f7XLI2026-09-10 10:03other314570155.00unknown—170.48001.9400["162","164","165"]["0.2072","0.2064","0.2152"][]["XBOX"]162.0000165.00007171falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:03:22Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c9d-6161-70a0-958b-e97e6b540eefXLI2026-09-10 14:38put_vertical_spread212055400.00unknown—170.22001.9500["182.5","185"]["0.9621","1.0999"][]["XBOX"]182.5000185.000011falsefalsefalsetruefalsemlfttrackeduw_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
01a08ca1-31f0-72a3-93ff-927242ec78c4XLI2026-09-10 14:42other6121245295000.00unknown—170.18505.2000["177","180","181","182","182.5","183"]["0.6433","0.8293","0.3396","0.3907","0.9389","0.3907"][]["XBOX"]177.0000183.000018falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:43:02Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ca1-4d48-72c2-bc76-916369cf23c8XLI2026-09-10 14:42put_vertical_spread217688920.00unknown—170.19001.6000["176","177"]["0.5798","0.6456"][]["XBOX"]176.0000177.000011falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:43:02Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a091ca-2218-7631-8e03-b5f6846d962bXLI2026-09-11 14:45put_vertical_spread21179179179.00unknown—172.52000.3100["172.5","182.5"]["0.1957","2.5755"][]["XISX"]172.5000182.500000falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:46:06Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091ca-2218-7631-8e03-b5e0ad7be175XLI2026-09-11 14:45put_vertical_spread217171923.00unknown—172.52000.3100["172.5","182.5"]["0.2202","2.5755"][]["EDGO"]172.5000182.500000falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:46:06Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0a05c-57b0-71a1-a79d-197e625d64a4XLI2026-09-14 10:39other422000810000.00unknown—169.40001.1800["160","165","170"]["0.2358","0.2385","0.2120"][]["AMXO"]160.0000170.0000418falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:40:07Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a0-03e9-70e3-82b4-181ff7b2e424XLI2026-09-14 11:53put_diagonal_spread212844884.00shortbid169.72001.0000["175","177.5"]["0.2039","0.2810"][]["XCBO"]175.0000177.5000467falsefalsetruetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:53:57Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a16b-bc40-7a41-b80d-4c39008b4fdcXLI2026-09-14 15:36other2130027750.00unknown—169.97500.1800["167","169"]["0.2135","0.2011"][]["EDGO"]167.0000169.000044falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:36:33Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a64a-e0fe-78c3-9338-efa724cefad9XLI2026-09-15 14:18other3118091000.00unknown—169.36000.6400["180","185"]["0.3715","0.4107"][]["SPHR"]180.0000185.000033falsefalsefalsetruetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:19:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a670-1086-7f40-a335-5bae1a2be84bXLI2026-09-15 14:59straddle21270205740.00longask169.15000.4500["169"]["0.1936"]["161.38","176.62"]["EDGO"]169.0000169.00003131truefalsefalsefalsetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:59:15Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0abc8-a0eb-7a82-bcde-598cda62fad1XLI2026-09-16 15:54put_vertical_spread223927924.00unknown—168.43000.3000["166","170"]["0.2095","0.2038"][]["XCBO","XISX"]166.0000170.00003030falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc8-9d03-7ff2-8d48-3e008b4588c0XLI2026-09-16 15:54put_vertical_spread26257185114.00unknown—168.43000.3034["166","170"]["0.2106","0.2050"][]["ARCO","C2OX","EMLD","MCRY","XBOX","XMIO"]166.0000170.00003030falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc8-b08b-7b70-b6a6-6faef7aa045bXLI2026-09-16 15:54put_vertical_spread23181129577.00unknown—168.41000.2903["166","170"]["0.2093","0.2030"][]["EDGO","XCBO","XISX"]166.0000170.00003030falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc8-b08b-7b70-b6a6-6f9bbb616422XLI2026-09-16 15:54put_vertical_spread225035850.00shortbid168.41000.3000["166","170"]["0.2096","0.2033"]["168.23"]["MCRY","XPHO"]166.0000170.00003030falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc8-b08b-7b70-b6a6-6f89c2589b4aXLI2026-09-16 15:54put_vertical_spread2512488860.00shortbid168.41000.3000["166","170"]["0.2095","0.2032"]["168.23"]["AMXO","EMLD","MCRY","XMIO","XPHO"]166.0000170.00003030falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc8-c02b-7bf2-84d3-c37973327d0bXLI2026-09-16 15:54put_vertical_spread238762379.00unknown—168.42000.2900["166","170"]["0.2098","0.2036"][]["EDGO","XCBO","XISX"]166.0000170.00003030falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:54:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abcc-4683-7fb3-955b-c472fd0183f2XLI2026-09-16 15:58other33855126006.00unknown—168.75000.4600["174","176","190"]["0.1667","0.3500","0.6520"][]["ARCO"]174.0000190.0000230falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:58:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0afb5-4083-7b81-bf7a-979091944c41XLI2026-09-17 10:11call_diagonal_spread211056260.00shortbid169.06755.3000["160","170"]["0.2102","0.2040"][]["XISX"]160.0000170.0000491855falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:11:40Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0b4-8bfb-78a3-acaa-314448730194XLI2026-09-17 14:50put_vertical_spread215768970.00unknown—169.14501.1500["174","176"]["0.4417","0.5655"][]["XBOX"]174.0000176.000011falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:50:39Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0b4-a753-74f1-aa88-dbf9013897bcXLI2026-09-17 14:50other41688510164060.00unknown—169.15001.9000["174","175","176","177"]["0.4443","0.5075","0.5686","0.5458"][]["XBOX"]174.0000177.000011truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:50:39Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0b5-571b-7d03-8040-31e47487f7c0XLI2026-09-17 14:51other4127804152888.00unknown—169.11002.1000["174","178","179","180"]["0.4227","0.7308","0.6037","0.7646"][]["XBOX"]174.0000180.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:51:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0db-1b13-7af0-b350-7311ee1e201aXLI2026-09-17 15:32put_vertical_spread2150079500.00unknown—169.16500.3900["160","165"]["0.2402","0.2070"][]["AMXO"]160.0000165.00001515falsetruefalsetruefalsemlcttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:32:30Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b4c6-3f7f-7201-8e92-66bea8be6e9fXLI2026-09-18 09:48call_ratio_spread2119663308.00longask169.24000.3200["173","195"]["0.1836","0.1846"]["177.14","212.86"]["EDGO"]173.0000195.00009191falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:48:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c7-1e27-7a51-aac7-7fe568e7d624XLI2026-09-18 09:49call_ratio_spread226228923.00longask169.16000.3100["170","195"]["0.1784","0.1757"]["175.89","214.11"]["EDGO","XCBO"]170.0000195.0000119119falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:49:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4df-e200-7ea1-8122-01e8f739436cXLI2026-09-18 10:16call_diagonal_spread2166661518.00longask168.99003.2500["120","121"]["0.5246","0.3110"][]["XCBO"]120.0000121.000063182falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:16:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b530-a5c7-70c3-9372-d23be2556740XLI2026-09-18 11:44call_ratio_spread2116078800.00unknownask168.56000.3900["170","190"]["0.1781","0.1738"]["179.85"]["XPHO"]170.0000190.0000119119falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:44:33Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f1-696f-7e43-a694-64439e3ea41bXLI2026-09-18 15:14put_frontspread236932597.00longask169.50500.5300["164","172"]["0.2066","0.1977"]["153.00","169.50"]["AMXO","EDGO","XPHO"]164.0000172.00002828falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:15:21Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f1-696f-7e43-a694-6439befa3b60XLI2026-09-18 15:14put_frontspread2210850562.00longask169.50500.5300["164","172"]["0.2053","0.1958"]["152.98","169.51"]["EDGO","XPHO"]164.0000172.00002828falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:15:21Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b602-883f-7c30-8afb-6201d3a6ac65XLI2026-09-18 15:33put_diagonal_spread212250019620000.00longbid169.45500.7500["160","170"]["0.2155","0.1975"][]["SPHR"]160.0000170.000063119falsefalsetruetruefalsemlftmarket_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
01a0b610-1118-74a0-9044-8506798589e3XLI2026-09-18 15:48iron_butterfly418260699.00unknown—169.80000.9000["155","170","180"]["0.2354","0.1763","0.1652"][]["C2OX"]155.0000180.00002828falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:48:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b610-249f-77b0-8705-51362e68e9fdXLI2026-09-18 15:48iron_butterfly41168124049.00unknown—169.80000.7000["155","170","180"]["0.2354","0.1758","0.1652"][]["C2OX"]155.0000180.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:48:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-1a70-7953-8d32-d8c64a8121eeXLI2026-09-18 15:51iron_butterfly418261500.00longbid169.82000.5800["155","170","180"]["0.2372","0.1772","0.1702"]["164.20","175.80"]["C2OX"]155.0000180.00002828falsefalsefalsetruetruemesltrackeduw_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
01a0b613-2df8-7430-a494-d94695d53462XLI2026-09-18 15:51iron_butterfly41168126000.00unknown—169.82000.8000["155","170","180"]["0.2356","0.1772","0.1712"][]["C2OX"]155.0000180.00002828falsefalsefalsetruetruemeslmarket_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