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.

403,968 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 = XLF×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
01a0aa7c-e70c-7510-b4d4-c2e8dda01528XLF2026-09-16 09:51put_ratio_spread218000352000.00unknown—56.51000.1400["56.5","57"]["0.3448","0.4685"][]["SPHR"]56.500057.000000falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:51:53Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa82-1b13-76f3-97de-a514de3e3fc8XLF2026-09-16 09:57call_diagonal_spread21500298000.00unknown—56.65000.6200["53","59"]["0.1735","0.1425"][]["XCBO"]53.000059.000030184falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:57:46Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa7-620a-7c33-ab2a-7c66a4c27dddXLF2026-09-16 10:38put_vertical_spread213000240000.00unknown—56.63000.1500["56","57"]["0.2344","0.2674"][]["AMXO"]56.000057.000022falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:38:31Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aac5-0fb3-7e61-90ac-030e9cfe5c65XLF2026-09-16 11:10put_vertical_spread215250651000.00unknown—56.66000.0500["55","56"]["0.1867","0.1742"][]["AMXO"]55.000056.00003030falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:11:05Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaef-82e3-7450-aed9-2af3314ada35XLF2026-09-16 11:56put_vertical_spread211026000.00longask56.56502.3000["69","70"]["1.4662","1.4874"]["69.02"]["XMIO"]69.000070.000022falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:57:36Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab03-5133-77c0-8059-3e6bc636ef00XLF2026-09-16 12:18call_calendar217855068.00unknown—56.48000.2500["56"]["0.1603"][]["AMXO"]56.000056.0000184196falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:18:49Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab03-5ceb-7312-b3e8-402e0c3233a0XLF2026-09-16 12:18call_calendar2214099120.00shortask56.48000.2500["56"]["0.1610"][]["EDGO","XCBO"]56.000056.0000184196falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:18:49Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab03-5ceb-7312-b3e8-401eb1473f66XLF2026-09-16 12:18call_calendar25347245122.00shortask56.48000.2500["56"]["0.1605"][]["C2OX","EMLD","MCRY","XMIO","XPHO"]56.000056.0000184196falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:18:49Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab03-ab0b-7391-99f0-ea58c38d5390XLF2026-09-16 12:18call_vertical_spread2110531605.00shortbid56.47530.1800["54.5","59.5"]["0.1635","0.1559"]["56.85"]["XMIO"]54.500059.50004444truefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:19:54Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab63-ef92-7691-a54e-85107d17d302XLF2026-09-16 14:04put_vertical_spread2140089600.00unknown—56.41000.1500["45","55"]["0.2600","0.1915"][]["XISX"]45.000055.0000184184falsetruefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:04:33Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab64-6c93-7f00-94a0-54c4f0c608a1XLF2026-09-16 14:04put_vertical_spread2140091200.00unknown—56.41000.0800["45","55"]["0.2635","0.1929"][]["XPHO"]45.000055.0000184184falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:05:00Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab68-1613-7a41-aa9a-346075301901XLF2026-09-16 14:08put_vertical_spread2120045000.00unknown—56.50500.1600["45","55"]["0.2630","0.1937"][]["XPHO"]45.000055.0000184184falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:08:51Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab6a-6fa3-7bd2-bd0c-5f6b93b44821XLF2026-09-16 14:11put_vertical_spread2120044600.00unknown—56.50000.1400["45","55"]["0.2612","0.1929"][]["XPHO"]45.000055.0000184184falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:11:54Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab9b-478b-7e60-aa7d-324dc2b125c5XLF2026-09-16 15:04call_diagonal_spread224835472.00shortbid55.88482.8900["63","65"]["0.1634","0.1608"][]["XCBO","XPHO"]63.000065.0000492856falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:04:49Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab9b-478b-7e60-aa7d-32262e3c0751XLF2026-09-16 15:04call_diagonal_spread227958372.00shortbid55.88482.8900["63","65"]["0.1634","0.1608"][]["XCBO","XPHO"]63.000065.0000492856falsetruetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:04:49Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abab-7fe3-74c3-9207-c25672df42fcXLF2026-09-16 15:22other4575008523750.00unknown—55.48500.4400["50"]["0.4908"][]["AMXO"]50.000050.0000230falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:22:22Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abb1-8ac4-7910-8faf-69d86363dfe3XLF2026-09-16 15:28put_ratio_spread2151645150.00unknown—55.54000.1000["40","54"]["0.3362","0.1957"][]["XMIO"]40.000054.0000121121falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:29:02Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbb-23cc-7911-a811-9e6b72cc8d27XLF2026-09-16 15:39put_ratio_spread2197481329.00unknown—55.66500.0600["40","54"]["0.3334","0.1940"][]["EDGO"]40.000054.0000121121falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:39:35Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbd-b7f3-7443-bc29-fabdfe15c898XLF2026-09-16 15:42put_ratio_spread2150040750.00unknown—55.67100.0900["40","54"]["0.3311","0.1916"][]["EDGO"]40.000054.0000121121falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:42:12Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbf-e2a3-7a62-8b78-b4423912bd33XLF2026-09-16 15:44put_vertical_spread212000960000.00unknown—55.67500.8000["40","52"]["0.2702","0.2325"][]["ARCO"]40.000052.0000821821falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:44:59Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbf-ee5b-7fe2-b778-86fc5488cb87XLF2026-09-16 15:44put_vertical_spread211000200000.00unknown—55.66500.1300["55","56"]["0.1841","0.1774"][]["XBOX"]55.000056.00003030falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:44:59Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc7-c243-7993-bb51-a814a8e98068XLF2026-09-16 15:53put_diagonal_spread2110000150000.00longask55.88500.0600["55","55.5"]["0.2692","1.6420"][]["SPHR"]55.000055.500002falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:53:11Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0af96-b433-7dc3-a84b-f5a73866a05aXLF2026-09-17 09:38put_vertical_spread215000180000.00longask56.05050.1100["55.5","56"]["0.2572","0.2457"]["55.84"]["XCBO"]55.500056.000011falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T13:38:08Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb6-ee33-78f3-8939-d54ce3d43279XLF2026-09-17 10:13put_vertical_spread21173027680.00unknown—55.67110.0500["52.5","53.5"]["0.2549","0.2328"][]["XCBO"]52.500053.500088falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:13:28Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb6-fdd4-7810-9fcf-e284b60d4c00XLF2026-09-17 10:13put_vertical_spread2327445974.00unknown—55.67000.0500["54","56"]["0.1932","0.1771"][]["EDGO","XCBO","XISX"]54.000056.00002929falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:13:28Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afc1-61fb-7e80-b0fd-b915b46ef29eXLF2026-09-17 10:24put_ratio_spread2165249552.00unknown—55.79000.0600["40","54"]["0.3318","0.1871"][]["XBOX"]40.000054.0000120120falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:25:02Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd4-3a33-7731-aa0c-22bc40e3a2bdXLF2026-09-17 10:45call_diagonal_spread211549620.00shortbid55.77501.4500["39","40"]["0.5286","0.4214"][]["XMIO"]39.000040.00006492falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:45:41Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aff1-c0cb-78f3-8d76-b99eccc26b6fXLF2026-09-17 11:17put_vertical_spread2130026400.00unknown—55.82500.0400["52","55"]["0.2170","0.1816"][]["XPHO"]52.000055.00002929falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:17:32Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aff8-e8d3-7f83-9790-8dee5fe4b00cXLF2026-09-17 11:25put_vertical_spread2243844176.00unknown—55.85000.0586["47","53"]["0.2498","0.1920"][]["XPHO"]47.000053.00009292falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:25:25Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b033-51f3-7080-8bb6-781bcd35d138XLF2026-09-17 12:29put_calendar216526910.00unknown—56.03500.1300["58"]["0.3265"][]["XCBO"]58.000058.000018falsefalsetruefalsefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:29:14Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b082-48ca-7b42-a8ed-ffc061670995XLF2026-09-17 13:55call_calendar213330558.00longbid56.03990.2000["52"]["0.1350"][]["XPHO"]52.000052.000013120falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:56:03Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b092-88f3-7f60-89be-cd2dd1fd5444XLF2026-09-17 14:13call_diagonal_spread213031050.00shortbid56.06500.3500["51","52"]["0.2360","0.1578"][]["XCBO"]51.000052.000013120falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:13:27Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0c6-a0e3-7d91-bcf9-0fd7c80a7030XLF2026-09-17 15:09put_calendar2113053950.00shortbid55.99500.2600["58"]["0.3640"][]["XMIO"]58.000058.000018falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:10:21Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0c7-299b-72a3-9eb6-b8586124576eXLF2026-09-17 15:10put_ratio_spread2175076750.00unknown—55.99500.0600["54","56"]["0.1847","0.1691"][]["XPHO"]54.000056.00002929falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:11:05Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b4c5-93a0-7ac0-805c-37c78351cdbeXLF2026-09-18 09:47call_calendar2192368276.00shortask55.66501.1500["36"]["0.3443"][]["XCBO"]36.000036.000091182falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:47:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c5-93a0-7ac0-805c-37bb529df3ceXLF2026-09-18 09:47call_calendar211040060.00unknownask55.66502.8500["36"]["0.4888"][]["XISX"]36.000036.000091182falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:47:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c8-6a30-7e61-93e7-85e1362ad98cXLF2026-09-18 09:50call_calendar21184628360.00shortbid55.59000.6500["39"]["0.2800"][]["XCBO"]39.000039.000091182falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:50:29Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c8-6a30-7e61-93e7-85d6c841bfdeXLF2026-09-18 09:50call_calendar212171631.00shortbid55.59000.7500["39"]["0.2800"][]["XISX"]39.000039.000091182falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:50:29Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e3-54cf-7383-8fcc-289ce85df0adXLF2026-09-18 10:19other3212400541334.00unknownbid55.78000.0722["54","57","61"]["0.1832","0.1317","0.1544"]["53.64"]["AMXO"]54.000061.00002828falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:20:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e6-3aff-7e82-aa06-7dd0cd67b631XLF2026-09-18 10:23put_vertical_spread2324625830.00longask55.74000.0881["47","53"]["0.2534","0.1927"]["52.39"]["XPHO"]47.000053.00009191falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:23:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e6-3aff-7e82-aa06-7dcf1646b2dbXLF2026-09-18 10:23put_vertical_spread2243845990.00shortbid55.74000.1157["47","53"]["0.2534","0.1927"]["52.39"]["XPHO"]47.000053.00009191falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:23:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b555-48b0-7583-8fd2-2ce20d9ffff4XLF2026-09-18 12:24risk_reversal21700123200.00longbid55.73500.0800["54","59"]["0.1834","0.1513"]["53.66"]["AMXO"]54.000059.00009191falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:24:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b586-341f-7c43-b331-3cb9c2b64ddfXLF2026-09-18 13:17put_calendar2118164436.00shortask55.80500.2300["55"]["0.1838"][]["XISX"]55.000055.0000119182falsetruetruefalsefalsemlettrackeduw_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
01a0b5d3-8ce8-73d2-89a6-aecec467e3abXLF2026-09-18 14:42other441250014887500.00unknownask55.88500.3300["50"]["2.4658"][]["AMXO"]50.000050.0000028falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:42:16Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d4-9e57-74d0-a5a6-9f6bdf29c194XLF2026-09-18 14:43strangle215000945000.00longask55.88990.0400["54","58"]["0.1757","0.1418"]["52.11","59.89"]["ARCO"]54.000058.00009191falsetruefalsetruetruemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:43:51Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d7-4dd8-7a41-84ec-c0bdccf3c8a8XLF2026-09-18 14:46call_diagonal_spread213574585.00shortask55.92500.6500["45","46"]["0.3137","0.2050"][]["AMXO"]45.000046.00006391falsefalsetruetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:46:19Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fd-8318-7510-833c-a2ec900819cbXLF2026-09-18 15:28put_diagonal_spread211109168568.00longbid55.89500.0500["56","57"]["0.1662","1.5501"][]["XBOX"]56.000057.000004falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:28:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0c464-ecbe-7db3-9eee-8d6cf3f2a239XLF2026-09-21 10:35put_calendar218125920.00unknownbid55.86000.1100["55"]["0.1723"][]["AMXO"]55.000055.0000116179falsetruetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:35:43Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c465-db07-7702-bf62-0eab9aae0da2XLF2026-09-21 10:36put_calendar2119061370.00shortask55.83500.1200["55"]["0.1727"][]["C2OX"]55.000055.0000116179falsetruetruefalsefalsemlettrackeduw_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
01a0c466-09e7-7af1-9581-6d94cf5c0ed1XLF2026-09-21 10:36put_calendar2117857494.00unknownbid55.83000.0700["55"]["0.1726"][]["ARCO"]55.000055.0000116179falsetruetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:37:10Z"}2026-09-212026-09-21 17:152026-09-21 17:15