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×direction = short×strategy = synthetic×
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
01a0b616-c007-7e10-8597-524063238a7fNVDA2026-09-18 15:55synthetic2155035200.00shortbid222.09000.0500["220"]["2.9708"]["220.02"]["AMXO"]220.0000220.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:55:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60e-4427-7420-88fc-0f5b9061c2aaIWM2026-09-18 15:46synthetic2247855926.00shortask283.82500.0800["285"]["0.4754"]["283.85"]["AMXO"]285.0000285.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:46:28Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f9-02bf-7321-925f-ea69a57b9e9bHUM2026-09-18 15:23synthetic21110613800.00shortbid383.32004.6000["380"]["0.6622"]["383.40"]["XBOX"]380.0000380.00002828falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:23:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cf-81c0-71b3-92a7-55073b061d68IWM2026-09-18 14:37synthetic2247876002.00shortask283.45500.1200["285"]["0.2735"]["283.45"]["AMXO"]285.0000285.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c3-a2af-7b32-b888-64089d3c531aMU2026-09-18 14:24synthetic222460720.00shortbid1004.35930.3000["1000"]["0.3452"]["1004.00"]["AMXO"]1000.00001000.000033falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:24:53Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59b-237f-71a0-9c4d-7c2d74425f87ORCL2026-09-18 13:40synthetic22876116508.00shortbid146.11000.0500["145"]["0.4902"]["146.01"]["AMXO"]145.0000145.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:40:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b587-ab1f-72a0-b113-718c2e88445cNDX2026-09-18 13:19synthetic21173895720.00shortbid0.000036.6000["29725"]["0.1963"]["29725"]["XPHO"]29725.000029725.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b587-5cff-7a32-a8d1-e5a647e26f57NDX2026-09-18 13:18synthetic21327333120.00shortbid0.000036.6000["29725"]["0.1964"]["29735.00"]["XPHO"]29725.000029725.00009191truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b560-646f-7690-80c8-672a9b0cd9a8NDX2026-09-18 12:36synthetic21153443400.00shortbid0.000045.3000["29700"]["0.1972"]["29700"]["XPHO"]29700.000029700.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:37:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55e-ce2f-7cb0-842d-af2bfba709e2SPY2026-09-18 12:34synthetic21917165060.00shortask759.20500.0200["760"]["0.1406"]["759.02"]["AMXO"]760.0000760.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:35:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-2e4f-7ee3-ab80-9f61ba5835f4SOXX2026-09-18 12:31synthetic225005060000.00shortask523.45008.4000["575"]["0.3829"]["529.80"]["ARCO"]575.0000575.0000119119falsefalsefalsefalsetruemlftmarket_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
01a0b555-3910-7ac3-b163-035e05010eb5IWM2026-09-18 12:24synthetic2125061000.00shortask282.59000.1200["285"]["0.2281"]["282.60"]["AMXO"]285.0000285.000000falsefalsefalsefalsetruemlfttrackeduw_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
01a0b550-e3af-7d61-a13a-bc13ea33afc4NDX2026-09-18 12:19synthetic21255745500.00shortbid0.000041.0000["29700"]["0.1971"]["29700"]["XPHO"]29700.000029700.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:19:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b518-fb2f-7523-a7bd-8639c94b043cSPCX2026-09-18 11:18synthetic2212530250.00shortbid151.54500.0400["150"]["0.7390"]["151.40"]["AMXO"]150.0000150.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:18:44Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b518-c867-7492-b101-5942c85e85caTSM2026-09-18 11:18synthetic2150151600.00shortbid431.68000.4500["430"]["0.3180"]["433.08"]["XBOX"]430.0000430.00002828falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:18:44Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4db-6978-7aa0-900e-225977a2bff5QQQ2026-09-18 10:11synthetic22800283200.00shortask717.31000.0500["720"]["0.1863"]["717.20"]["AMXO"]720.0000720.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:11:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4b6-bebf-76e0-b43f-5168c2cab629QQQ2026-09-18 09:31synthetic22800393600.00shortbid719.15000.1800["715"]["0.2160"]["718.80"]["AMXO"]715.0000715.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:31:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0e0-81e3-7813-b171-3204de199e76NVDA2026-09-17 15:38synthetic211501174500.00shortbid219.62000.7000["220"]["0.3972"]["231.90"]["XBOX"]220.0000220.0000491491falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:38:46Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b097-43e3-70d2-8b8c-e75667e76516NDX2026-09-17 14:18synthetic213690450.00shortbid0.000036.7000["29725"]["0.1966"]["29725"]["XPHO"]29725.000029725.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:19:04Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b088-24cb-7d61-8e46-d3545d5dfa86SBUX2026-09-17 14:01synthetic21500682500.00shortask97.73000.3500["100"]["0.3037"]["98.45"]["XPHO"]100.0000100.0000120120falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:02:00Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b085-272b-7232-b647-df68a54c18c2BEAM2026-09-17 13:58synthetic21300156000.00shortbid24.66502.4500["23"]["0.6304"]["24.00"]["XBOX"]23.000023.00006464truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:58:43Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b04a-d963-77e1-bff3-7eed4d55053eTSM2026-09-17 12:54synthetic217502733750.00shortask427.09850.5500["450"]["0.3247"]["428.25"]["AMXO"]450.0000450.00002929falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:55:13Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b008-560b-7200-9b00-3c417f573723SPY2026-09-17 11:42synthetic227501619250.00shortbid762.30000.0600["740"]["0.2594"]["761.33"]["AMXO"]740.0000740.000011falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:42:26Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b001-800b-7073-9913-0396c81260d9NDX2026-09-17 11:34synthetic212467060.00shortbid0.000035.7000["29700"]["0.1996"]["29700"]["XPHO"]29700.000029700.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:34:48Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aff6-0e5b-7bb0-9b23-5430e5203a02NDX2026-09-17 11:22synthetic212466540.00shortbid0.000037.0000["29675"]["0.1996"]["29675"]["XPHO"]29675.000029675.00009292truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:22:46Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd6-5543-70c3-99fc-153c1a1df821LULU2026-09-17 10:47synthetic214502466000.00shortask95.70003.6500["130"]["0.5000"]["101.40"]["XBOX"]130.0000130.0000491491falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:47:42Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd2-6573-7ea0-9199-1c6229a7a6d1TSM2026-09-17 10:43synthetic215007225000.00shortbid424.80004.7000["440"]["0.3885"]["446.20"]["AMXO"]440.0000440.0000456456falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:43:20Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afc8-8deb-75a1-b5cb-77c4e0b55f4cMU2026-09-17 10:32synthetic211003945000.00shortask975.295011.0000["1200"]["0.5949"]["998.32"]["XPHO"]1200.00001200.0000183183falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:32:34Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afc3-ea6b-7212-8261-b0a3bedc9ad5NDX2026-09-17 10:27synthetic2111025589300.00shortbid0.000045.2000["29700"]["0.1986"]["29700"]["XPHO"]29700.000029700.00009292truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:27:45Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abc4-535b-7d13-a88d-9807ab7bfa66QQQ2026-09-16 15:49synthetic227508853750.00shortask704.17003.5100["780"]["0.2201"]["722.07"]["AMXO"]780.0000780.0000274274falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:49:28Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab8b-8c33-73b0-80af-ebd29149b6edORCL2026-09-16 14:47synthetic2175639750.00shortbid144.20503.0000["140"]["0.5650"]["152.40"]["XBOX"]140.0000140.0000730730falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:47:22Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab7e-41db-7f72-958c-29c62895418fWBD2026-09-16 14:32synthetic212000350000.00shortbid28.07000.3800["28"]["0.2727"]["28.15"]["SPHR"]28.000028.00003030falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:33:18Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab43-b1ab-7ad0-b28d-46ca98d37e73NDX2026-09-16 13:28synthetic2151179600.00shortbid0.000035.0000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:28:54Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab41-6f8b-76b2-a314-56d64f05f2daNDX2026-09-16 13:26synthetic21102358100.00shortbid0.000036.1000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:26:40Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab3b-d20b-7112-99a6-8cd109d05f96NDX2026-09-16 13:20synthetic212472300.00shortbid0.000034.2000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:21:03Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab32-b21b-73d3-93c4-ebac4de84d70JD2026-09-16 13:10synthetic22500271000.00shortask26.92500.1300["28"]["0.3524"]["27.50"]["ARCO"]28.000028.0000184184falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:11:10Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab2e-166b-7493-9a7e-810b8d52f985NDX2026-09-16 13:05synthetic2181882320.00shortask0.000035.0000["29475"]["0.2016"]["29445"]["XPHO"]29475.000029475.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:05:34Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab1b-51bb-78b3-8e9a-0bbcb61bb9acORCL2026-09-16 12:44synthetic21100717000.00shortbid143.92501.0500["145"]["0.5605"]["150.20"]["XBOX"]145.0000145.0000492492falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:44:52Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaeb-681b-70a0-a49f-d0b506d2dbdfNDX2026-09-16 11:52synthetic21143311000.00shortbid0.000039.4000["29500"]["0.2022"]["29500"]["XPHO"]29500.000029500.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:53:12Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaad-70d3-7c13-a263-9958a7141f2bNDX2026-09-16 10:44synthetic21389029180.00shortbid0.000049.4000["29450"]["0.2029"]["29450"]["XPHO"]29450.000029450.00009393truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:45:07Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a67e-d5c6-7381-94e9-236a7985c9b1NVDA2026-09-15 15:15synthetic22300109500.00shortask212.01500.0200["212.5"]["0.4097"]["211.99"]["ARCO"]212.5000212.500011falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:15:35Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a675-0dde-74d0-8f8c-1d4cad65b262QQQ2026-09-15 15:04synthetic217504387500.00shortask704.75010.3700["720"]["0.2044"]["711.32"]["XPHO"]720.0000720.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:04:43Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a673-873e-7892-91fd-a0b1eae39b46XLU2026-09-15 15:03synthetic2127045090.00shortask41.45510.2100["42"]["0.1691"]["41.27"]["XBOX"]42.000042.00003131falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:04:00Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a672-8186-7d02-8d63-c7a4980f2d67XLF2026-09-15 15:01synthetic211240262880.00shortask56.83430.1500["57"]["0.1605"]["56.72"]["XBOX"]57.000057.00003131falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:02:08Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a671-069e-7ac1-9998-946b0e2adb06XLK2026-09-15 15:00synthetic2111251181250.00shortbid183.74710.4500["184"]["0.2460"]["184"]["XBOX"]184.0000184.00003131truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:00:39Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a66c-a96e-7ed0-bca3-0c10e71ec1caAVGO2026-09-15 14:55synthetic2175609000.00shortask340.32501.5500["350"]["0.4159"]["346.30"]["XBOX"]350.0000350.0000185185falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:55:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a648-ba36-72a2-9814-1e6172070b60NDX2026-09-15 14:16synthetic2151189700.00shortbid0.000038.4000["29275"]["0.2036"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:16:33Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61f-48d6-7082-8de4-82f6819ff7f4NDX2026-09-15 13:31synthetic21112622290.00shortbid0.000041.3000["29250"]["0.2044"]["29250"]["XPHO"]29250.000029250.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:31:24Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a60b-016e-7511-9e6b-d28d992b72eeMU2026-09-15 13:08synthetic224001712000.00shortbid924.99001.7000["900"]["0.5684"]["925.20"]["AMXO"]900.0000900.000033falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:09:31Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5fe-ebae-7320-a6b3-b8deca270270NDX2026-09-15 12:55synthetic21255972250.00shortbid0.000039.1000["29275"]["0.2045"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:56:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28