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×ticker = USO×
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
01a0b50b-5317-79c0-8f6f-4e46fea12347USO2026-09-18 11:03call_calendar2185997050.00shortask155.85008.8000["120"]["0.3654"][]["SPHR"]120.0000120.0000819854falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:03:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b507-4407-7360-becd-84410a52ecf9USO2026-09-18 10:59other4320408100.00unknownask155.970016.6500["133","137"]["0.3693","0.3750"][]["AMXO"]133.0000137.0000819854falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:59:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0aa6a-784b-72f0-b966-912437962884USO2026-09-16 09:31put_vertical_spread21115344425.00unknown159.15002.0500["155","165"]["0.5554","0.5681"][]["AMXO"]155.0000165.00006565falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:31:46Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa69-479b-7410-88f5-c3bb56c062efUSO2026-09-16 09:30put_butterfly_spread314001059800.00shortbid159.28006.3500["152","161","170"]["0.5496","0.5675","0.5824"]["152.95","169.05"]["SPHR"]152.0000170.00004444truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:30:23Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a032-e650-79e1-9d64-5936671de217USO2026-09-14 09:54put_calendar21200117400.00longask159.72500.8500["155"]["0.6461"][]["SPHR"]155.0000155.0000211falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:54:48Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091e0-1731-7933-a805-5acbb6701d7dUSO2026-09-11 15:09other31100108350.00unknown154.67501.3300["70","90","110"]["0.5535","0.4980","0.4654"][]["SPHR"]70.0000110.0000497497falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:09:46Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0913a-4dc8-7f92-a9cf-a06ab930ff7dUSO2026-09-11 12:08call_vertical_spread21527886941.00unknown154.16501.2500["250","260"]["0.4026","0.4063"][]["SPHR"]250.0000260.0000497497falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:09:02Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09102-8c58-7ab2-b50d-15deb3df02f0USO2026-09-11 11:07call_vertical_spread2179127190.00unknown153.79002.4000["250","260"]["0.3976","0.4014"][]["SPHR"]250.0000260.0000497497falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:08:00Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08cd7-45b0-73f1-b50d-4a20a9e81d13USO2026-09-10 15:41call_diagonal_spread21400015660000.00unknown158.33141.6000["134","151"]["0.8146","0.5339"][]["XPHO"]134.0000151.0000836falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:42:01Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c91-d458-7931-8591-5687e99046c7USO2026-09-10 14:25other311500011575000.00unknown158.41532.5600["70","100","130"]["0.5760","0.4972","0.4697"][]["SPHR"]70.0000130.0000280280truetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:26:01Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c61-cf60-7983-b15e-27e81dac371bUSO2026-09-10 13:33other4120002302000.00unknown157.26001.0100["150","165","200"]["0.5441","0.5729","0.7746"][]["XPHO"]150.0000200.0000836falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:33:42Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ba6-ff28-71c0-811b-87e69cfb7c37USO2026-09-10 10:09other413800508380.00unknown153.95000.5100["120","130","135","145"]["0.7269","0.5809","0.5103","0.4995"][]["SPHR"]120.0000145.0000815falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:09:55Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ba1-fa00-7291-805c-d4f5aa60ecb5USO2026-09-10 10:04call_vertical_spread2150130000.00shortbid153.79001.2000["150","200"]["0.4592","0.5385"]["162.50"]["SPHR"]150.0000200.0000127127falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:04:07Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0872a-2d81-7252-b685-824f7e8ca351USO2026-09-09 13:14put_condor41250152500.00longask147.87500.4200["127","135","140","148"]["0.5552","0.4650","0.4427","0.4543"]["129.68","145.32"]["SPHR"]127.0000148.000099falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:15:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0871f-b5d0-7c10-9f13-e228dca529c0USO2026-09-09 13:03put_condor41250151750.00longask148.03000.5100["127","135","140","148"]["0.5582","0.4687","0.4429","0.4623"]["129.71","145.29"]["SPHR"]127.0000148.000099falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:03:21Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0868c-8df0-7360-b061-43636429f793USO2026-09-09 10:22call_backspread212000397000.00longbid149.13500.2300["150","200"]["0.4445","0.8096"]["153.65","246.35"]["AMXO"]150.0000200.000099falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:22:44Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0828c-6658-72a0-abd5-e7d28c044a73USO2026-09-08 15:43other2140007544000.00unknown145.28501.5000["134","151"]["0.5045","0.4600"][]["XPHO"]134.0000151.00001038falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:44:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08147-0190-7dc3-87fc-9ef26435fecbUSO2026-09-08 09:48put_vertical_spread21140235340.00unknown145.02000.9500["130","135"]["0.4408","0.4454"][]["SPHR"]130.0000135.0000129129falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:48:38Z"}2026-09-082026-09-08 21:502026-09-08 21:50