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:code = mlft×strategy = put_ratio_spread×
idtexttickertextexecuted_attimestamp 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
01a0b606-0e97-7b23-8b98-27ab3aa2cb28IEF2026-09-18 15:37put_ratio_spread21181981113552.00unknownbid90.82500.0600["90","91"]["0.0746","0.0767"]["89.27"]["ARCO"]90.000091.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:37:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fe-f62f-7d71-bd9c-e2b03101a0f8IBIT2026-09-18 15:29put_ratio_spread233000278500.00unknown46.04500.0400["37","43"]["0.4475","0.3968"][]["AMXO"]37.000043.00006363falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:29:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e1-fc37-73b3-a3fc-708fb7cfa7c6NET2026-09-18 14:57put_ratio_spread214001272000.00unknownbid322.71502.0500["250","320"]["0.6050","0.5937"]["256.40"]["XBOX"]250.0000320.0000119119falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:58:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b597-1c3f-7943-be26-a2787ba3c987TSM2026-09-18 13:36put_ratio_spread21540422550.00unknownbid430.33000.7000["380","430"]["0.3513","0.3243"]["351.70","419.62"]["XBOX"]380.0000430.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:36:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b596-02ff-7ae3-8d6d-f88d0a024d68TSM2026-09-18 13:34put_ratio_spread21540766800.00unknownbid430.12500.7000["400","430"]["0.3337","0.3232"]["355.90","422.05"]["XBOX"]400.0000430.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:35:19Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58b-7f97-76c2-b85a-7c0ec4256d13QQQ2026-09-18 13:23put_ratio_spread2112003288800.00unknownask717.16600.2400["625","730"]["0.2728","0.2016"]["688.89"]["XBOX"]625.0000730.00009191falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:24:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b570-140f-7ce3-949c-e2e5681e38e7QQQ2026-09-18 12:53put_ratio_spread2275342900.00unknownbid716.66500.3400["650","730"]["0.2481","0.2175"]["523","713.50"]["AMXO"]650.0000730.0000182182falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:53:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-70b7-78f0-a84b-e2a7d08dde59AMD2026-09-18 12:32put_ratio_spread21576869760.00unknownbid543.74500.6500["470","540"]["0.5252","0.4851"]["415.20","524.80"]["ARCO"]470.0000540.00002121falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:32:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-6cd0-7c83-bf40-eb20962279c5COIN2026-09-18 12:32put_ratio_spread21140454790.00unknownbid194.96001.6000["185","190"]["0.7043","0.6961"]["161.33"]["SPHR"]185.0000190.00009191falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:32:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b559-481f-7d51-90dd-2605b0f3565cBTDR2026-09-18 12:28put_ratio_spread228000980000.00unknownask12.36500.3000["11","12"]["0.9537","1.0011"]["10.52"]["AMXO"]11.000012.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:29:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b535-9b50-7bf2-b642-65a309838c90KIE2026-09-18 11:49put_ratio_spread21675171900.00unknownbid61.92000.8500["61","63"]["0.2410","0.2362"]["57.80","62.60"]["AMXO"]61.000063.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:50:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ea-a7d0-7cc0-94a5-3d5fb08255f7SWKS2026-09-18 10:27put_ratio_spread211000367500.00unknown89.08000.7500["80","85"]["0.5704","0.5679"][]["XPHO"]80.000085.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:27:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d9-c77f-7741-89de-5b8a1334e3a8TSLA2026-09-18 10:09put_ratio_spread22450751950.00unknownask363.05500.3500["330","370"]["0.4311","0.4177"]["342.15"]["ARCO"]330.0000370.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:09:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d4-f907-7311-a707-43b2b2e68cebTSLA2026-09-18 10:04put_ratio_spread22576976032.00unknownbid364.71000.2700["280","370"]["0.4938","0.4439"]["212.61","347.39"]["AMXO"]280.0000370.00006363falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:04:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d1-66f7-7ac2-aa59-703173bfcf20INTC2026-09-18 10:00put_ratio_spread2216201037610.00unknownask109.15000.1900["90","115"]["0.6232","0.6126"]["102.19"]["ARCO"]90.0000115.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:00:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d1-248f-7543-8d55-e25bef79c87aINTC2026-09-18 09:59put_ratio_spread2119801179090.00unknownask109.04860.1700["85","115"]["0.6393","0.6161"]["103.09"]["ARCO"]85.0000115.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:00:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b00f-0113-7dd1-8c85-fc8a1b8cb215BMY2026-09-17 11:49put_ratio_spread2180001748000.00unknown63.43820.3200["52.5","62.5"]["0.3217","0.3322"][]["XPHO"]52.500062.50009292falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:49:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b002-ef3b-7d22-991a-2dcc9b3eb7c9NVDA2026-09-17 11:36put_ratio_spread22600661200.00unknown219.06000.4000["160","205"]["0.4243","0.3872"][]["AMXO"]160.0000205.0000183183falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:36:32Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afca-3b9b-7290-992d-bb292f640a05JETS2026-09-17 10:34put_ratio_spread21425178575.00unknown28.46000.5700["27","31"]["0.3709","0.3390"][]["XBOX"]27.000031.00009292falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:34:22Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abc7-7423-7f53-bcb3-9ea07ff3f17aAVGO2026-09-16 15:52put_ratio_spread2218005342400.00unknown339.01005.3500["240","340"]["0.4430","0.4433"][]["AMXO"]240.0000340.0000366366falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:52:50Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbc-15fb-7082-98fa-7e65856ab838USB2026-09-16 15:40put_ratio_spread211628127650.00unknown59.36750.6100["58","61"]["0.4302","0.4446"][]["XBOX"]58.000061.000022falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:40:28Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abb7-62db-7391-96cc-a4c1ee95aaacCRL2026-09-16 15:35put_ratio_spread21500210000.00unknown272.16253.6000["260","270"]["0.7152","0.8059"][]["XBOX"]260.0000270.000022falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:35:38Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abab-2223-7ff1-a1b4-644740bdeb4dIWM2026-09-16 15:21put_ratio_spread21950815300.00unknown281.42000.0700["275","280"]["0.2213","0.2051"][]["XBOX"]275.0000280.00003030falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:22:00Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaf7-1462-7ae0-b4cb-89ffc948409fLQD2026-09-16 12:05put_ratio_spread217000142000.00unknown104.83500.0600["104","104.5"]["0.1154","0.1034"][]["XPHO"]104.0000104.500022falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:06:01Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae9-e94b-7d32-a067-b9135795b6e6MXEF2026-09-16 11:50put_ratio_spread2152202800.00unknown1689.140015.7000["1340","1600"]["0.3223","0.2606"][]["AMXO"]1340.00001600.0000121121truetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:51:19Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae1-5dcb-7a41-96ca-85432d4afd53AMD2026-09-16 11:41put_ratio_spread214002966000.00unknown523.19004.8000["250","450"]["0.5625","0.5773"][]["XBOX"]250.0000450.0000821821falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:42:10Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aac6-bd63-7373-86cf-fcaa52e9ac44QQQ2026-09-16 11:12put_ratio_spread22150043500.00unknown711.11500.0200["650","684"]["0.5375","0.3532"][]["AMXO"]650.0000684.000022falsetruefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:12:25Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aab0-2c0b-7f53-9f39-1eab59ea8601META2026-09-16 10:47put_ratio_spread22900416700.00unknown680.13000.4000["550","650"]["0.4403","0.3902"][]["ARCO"]550.0000650.00003030falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:47:52Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa2-f53b-7b91-abc1-ed31a2779a01IWM2026-09-16 10:33put_ratio_spread21150003765000.00unknown285.74000.0700["240","270"]["0.3014","0.2301"][]["AMXO"]240.0000270.00006565falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:33:27Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa98-c3da-7be2-82af-907c493e0e6eQQQ2026-09-16 10:22put_ratio_spread224000129000.00unknown709.94000.0200["665","685"]["0.4390","0.3355"][]["AMXO"]665.0000685.000022falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:22:39Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa8a-2993-7b51-8230-ceeaf462f5a3GDS2026-09-16 10:06put_ratio_spread22680191000.00unknown30.33000.9000["30","32"]["0.5043","0.4911"][]["AMXO"]30.000032.00003030falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:06:30Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa85-4f63-75e3-b1d8-7f24fd9ddad1ORCL2026-09-16 10:00put_ratio_spread21102211905.00unknown145.83500.7000["140","145"]["0.5761","0.5736"][]["SPHR"]140.0000145.00009393falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:01:08Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa7c-e70c-7510-b4d4-c2e8dda01528XLF2026-09-16 09:51put_ratio_spread218000352000.00unknown56.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
01a0a684-ec5e-7b02-b173-cf6b76423cefAMZN2026-09-15 15:22put_ratio_spread224001983500.00unknown247.96002.3000["220","230"]["0.3638","0.3581"][]["AMXO"]220.0000230.0000822822falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:22:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a630-929e-7032-981b-47892b027fdcLEN2026-09-15 13:49put_ratio_spread211875850000.00unknown80.33560.8500["78","82"]["0.6055","0.5209"][]["ARCO"]78.000082.00001010falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:50:10Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5ff-a345-72b1-812a-2f711738f96cHYG2026-09-15 12:56put_ratio_spread226932103980.00unknown78.48000.0600["78","78.5"]["0.0861","0.0573"][]["AMXO"]78.000078.500033falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:57:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f9-abee-74d0-bad0-02e25de523d4MSTR2026-09-15 12:49put_ratio_spread2313135286612.00unknown132.05503.2000["65","130"]["0.8685","0.8303"][]["AMXO"]65.0000130.0000640640truetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:50:51Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5d1-6756-7bd1-b917-f23c954fa8c4ARM2026-09-15 12:05put_ratio_spread21600992000.00unknown245.23002.8500["170","250"]["0.6809","0.6852"][]["XPHO"]170.0000250.00009494falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:06:47Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b9-6ab6-7061-a765-f8296be89c7fGDX2026-09-15 11:39put_ratio_spread213252782460.00unknown92.99000.1200["90","93"]["0.5633","0.5383"][]["SPHR"]90.000093.000033falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:40:26Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a58b-0b9e-73a2-8c1d-56a051b79eadLITE2026-09-15 10:49put_ratio_spread211401473500.00unknown845.335011.7000["600","840"]["0.7633","0.7543"][]["XPHO"]600.0000840.0000122122falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:49:17Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a577-d1be-7f53-ac86-6bde80ccc36dLQD2026-09-15 10:28put_ratio_spread223000151500.00unknown104.17500.1200["103","105"]["0.1143","0.0890"][]["AMXO"]103.0000105.000033falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:28:31Z"}2026-09-152026-09-15 19:282026-09-15 19:28