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 = unknown×ticker = ORCL×
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
01a0b5ea-3997-7aa1-b321-5336d5d707a4ORCL2026-09-18 15:06other41301235300.00unknown148.22003.1000["180","300","310"]["0.5845","0.8827","0.9595"][]["XPHO"]180.0000310.00007119falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:07:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0d3-760b-7c51-b8d7-86c267a663edORCL2026-09-17 15:24call_diagonal_spread2175501000.00unknown149.20220.9500["145","150"]["0.5519","0.5526"][]["XBOX"]145.0000150.0000273365falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:24:34Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a8-7a23-71b2-a3fc-d3d859df74ebORCL2026-09-17 14:37put_ladder51127816896072.00unknown149.17891.8000["167.5","170","180","220","230"]["1.3011","1.3553","1.8303","3.3636","3.6866"][]["XBOX"]167.5000230.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:37:26Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a8-3ba3-7ad2-a4cf-207c4917c80fORCL2026-09-17 14:36other41163024739250.00unknown149.16001.4500["190","195","200","210"]["2.2143","2.4127","2.6036","2.9657"][]["XBOX"]190.0000210.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:36:54Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a4-ccbb-7ce2-98e5-d41bded13ad6ORCL2026-09-17 14:33other8152712745570.00unknown149.39503.3000["170","175","200","220","240","250","270","310"]["1.2866","1.5220","2.5476","3.2415","0.9823","4.1403","4.4004","0.8846"][]["XBOX"]170.0000310.00001120falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:33:42Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a4-ad7b-7781-90c8-b82b488d334eORCL2026-09-17 14:32other51234418600032.00unknown149.41002.3500["175","185","260","270","300"]["1.5518","1.9943","4.4725","4.7325","0.9060"][]["XBOX"]175.0000300.0000192falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:33:02Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b05c-714b-77d1-a92c-c32d4d6655beORCL2026-09-17 13:14put_calendar22560266840.00unknown149.92000.2800["150"]["0.5450"][]["ARCO"]150.0000150.0000115falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:14:03Z"}2026-09-172026-09-17 17:152026-09-17 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
01a0a661-c846-7c33-a5f6-045339fc3111ORCL2026-09-15 14:43other3210001395500.00unknown141.41000.8000["140","155"]["0.5346","0.4936"][]["AMXO"]140.0000155.000031122falsetruetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:44:19Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a051-4b90-7a22-9ca2-3ab95a10fdfbORCL2026-09-14 10:27call_vertical_spread2157556206.00unknown142.32503.5500["140","160"]["0.5747","0.5690"][]["SPHR"]140.0000160.0000823823falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:28:09Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0914d-1278-7a60-b1de-2c31849400afORCL2026-09-11 12:29other22400608000.00unknown151.76000.9000["125","145"]["0.5589","0.5688"][]["ARCO"]125.0000145.000098189falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:29:20Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c68-7e50-7cf3-a90d-d021dbc3f054ORCL2026-09-10 13:40put_vertical_spread22578165308.00unknown155.90000.0300["130","140"]["2.3710","2.5323"][]["AMXO"]130.0000140.000011falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:41:35Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c46-f848-7ea2-8e7d-3979b2b4e842ORCL2026-09-10 13:04other22500849500.00unknown156.52000.9500["110","115"]["0.5946","0.6106"][]["ARCO"]110.0000115.0000127400falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:04:44Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c46-0618-7ad2-9b77-a79c35e6bf4eORCL2026-09-10 13:03other221000490000.00unknown156.81000.2200["150","200"]["1.1110","1.2420"][]["ARCO"]150.0000200.000088falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:03:51Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bda-d0c8-7463-9efa-1eb18bd9227eORCL2026-09-10 11:06other31160302600.00unknown158.41990.9000["120","170","220"]["0.6244","0.6397","0.6550"][]["XPHO"]120.0000220.00009999falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:06:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08748-cd59-7b21-b69a-20c47c1162faORCL2026-09-09 13:48other214002190000.00unknown163.35002.0000["200","230"]["0.6666","0.7007"][]["AMXO"]200.0000230.0000100100falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:48:57Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0872f-80c8-7ed2-bc69-8eab7a8265f8ORCL2026-09-09 13:20other224001472300.00unknown162.61501.3500["250","280"]["0.7280","0.6068"][]["AMXO"]250.0000280.0000100373falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:21:12Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08277-cce8-7870-a198-d66ecc93b735ORCL2026-09-08 15:21call_vertical_spread2150319250.00unknown161.53751.0500["155","190"]["0.5930","0.6008"][]["XPHO"]155.0000190.0000282282falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:22:02Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08152-0db0-7713-b703-bb715284fac5ORCL2026-09-08 10:00other4111254358737.00unknown164.83991.5000["155","170","175","185"]["0.6393","0.6721","0.6689","0.6849"][]["XBOX"]155.0000185.00003838falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:00:45Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06d7b-fdb5-76c1-a6d9-44a3fabcb77eORCL2026-09-04 13:33other2113001658150.00unknown157.59000.7000["125","170"]["0.6455","0.6594"][]["XBOX"]125.0000170.00004242falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:34:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d7b-22f5-7a40-8a6f-fbe97a7a7aeaORCL2026-09-04 13:32other2213002361450.00unknown157.35501.0000["90","250"]["0.6057","0.5897"][]["AMXO"]90.0000250.0000469469falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:33:34Z"}2026-09-042026-09-07 00:532026-09-07 00:53