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.

367,592 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:direction = unknown×ticker = JPM×
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
01a0b52a-3d28-74e1-8a26-716df7c97baeJPM2026-09-18 11:37other41120567900.00unknown347.16006.0500["330","340"]["0.7684","0.3427"][]["XISX"]330.0000340.000007falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:37:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d4-f907-7311-a707-45012adf190aJPM2026-09-18 10:04other4135103495.00unknownbid346.45754.0000["345","355"]["0.2306","0.2270"][]["XCBO"]345.0000355.0000714falsefalsetruetruefalsemlatmarket_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
01a0b0db-1b13-7af0-b350-742e7a304e6aJPM2026-09-17 15:32call_diagonal_spread214180176.00unknown349.38507.0000["105","145"]["1.0448","0.5383"][]["XPHO"]105.0000145.0000120273falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:32:30Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0b5-a923-7190-bdae-f38709160433JPM2026-09-17 14:51put_butterfly_spread3183263834.00unknown349.94006.5500["362.5","365","370"]["0.8191","0.7959","1.0873"][]["XBOX"]362.5000370.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:51:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aba1-526b-7803-aaec-6073afdf4b0aJPM2026-09-16 15:11other42400106304.00unknown346.28506.2300["330","375","385"]["0.4334","0.2430","0.2460"][]["XMIO","XPHO"]330.0000385.0000230falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:11:15Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab80-b6c4-7b42-8fac-343a12ed3274JPM2026-09-16 14:35call_calendar2123876070.00unknown350.05006.7000["160"]["2.8786"][]["XPHO"]160.0000160.0000265falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:35:43Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab22-fe93-7533-91a0-aab83c37f31cJPM2026-09-16 12:53other61100115400.00unknown350.08001.6000["315","330","335","345","370","375"]["0.3160","0.4037","0.2932","0.3282","0.2400","0.3710"][]["AMXO"]315.0000375.0000230falsetruetruetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:53:46Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aac8-c4eb-7f72-a909-a047456cd9bfJPM2026-09-16 11:14call_diagonal_spread2140130840.00unknown351.55000.7500["330","370"]["0.2643","0.2295"][]["XCBO"]330.0000370.00003065falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:14:39Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa8-aa2c-73f2-86b7-675e60868c1fJPM2026-09-16 10:39call_diagonal_spread2110188200.00unknown351.70006.2000["250","270"]["0.3360","0.2999"][]["XMIO"]250.0000270.000093121falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:40:02Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a680-ecee-7bc0-9f27-24e275b6c878JPM2026-09-15 15:17call_diagonal_spread2115124800.00unknown352.47506.4000["310","320"]["1.1088","0.2514"][]["XISX"]310.0000320.0000394falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:17:45Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a643-c896-76d1-a16a-3094f68b3ab9JPM2026-09-15 14:10put_vertical_spread221353798270.00unknown345.09500.4900["340","345"]["0.3345","0.3168"][]["ARCO"]340.0000345.000033falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:11:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a638-6e55-7b32-b578-679d97db5347JPM2026-09-15 13:58put_diagonal_spread21150408000.00unknown344.57002.7500["350","360"]["0.2582","0.3167"][]["SPHR"]350.0000360.0000324falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:58:59Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a625-1d06-7bf3-9d98-104a1277ddd3JPM2026-09-15 13:37call_vertical_spread2168555084.00unknown345.21003.8500["310","320"]["0.2467","0.2442"][]["XISX"]310.0000320.0000122122falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:37:56Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a621-4c75-7de1-bdcc-8e3dc769dc41JPM2026-09-15 13:33other4214164536.00unknown345.38005.9600["290","350","370"]["0.8124","0.3257","0.2416"][]["EMLD","XBOX"]290.0000370.0000331falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:33:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5fd-6cde-7700-91e0-232ab3eee1e6JPM2026-09-15 12:54call_diagonal_spread2114196000.00unknown344.70003.7000["300","340"]["0.2291","0.2207"][]["MCRY"]300.0000340.0000493857falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:54:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a563-307d-7550-8593-64c5eac80f3dJPM2026-09-15 10:05other43999839048.00unknown350.61000.9400["360","370","375"]["0.2359","0.3030","0.2310"][]["XISX"]360.0000375.0000331falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:05:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a546-f205-7a43-9b31-6a2c3535d5d0JPM2026-09-15 09:34call_vertical_spread21307104073.00unknown348.83500.8200["375","385"]["0.2437","0.2463"][]["XMIO"]375.0000385.00003131falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:34:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a170-b1c8-7192-824f-284ae8c84f43JPM2026-09-14 15:41other2264141952.00unknown350.01751.6500["345","350"]["0.2794","0.2296"][]["EMLD","SPHR"]345.0000350.0000467falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:41:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a167-b8e9-7081-b477-1989852b58ffJPM2026-09-14 15:32other2164138176.00unknown349.25500.6000["350","355"]["0.2840","0.2593"][]["XCBO"]350.0000355.0000467falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:32:03Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a14a-6130-7700-980d-83aa335337a1JPM2026-09-14 14:59other2117129948.00unknown350.50006.7000["410","420"]["0.2389","0.2371"][]["XCBO"]410.0000420.0000823858falsetruetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:00:00Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a129-d140-7543-9f03-ca28c0b9ca7dJPM2026-09-14 14:24other2146355396.00unknown349.62003.5000["310","320"]["0.7621","0.2395"][]["XMIO"]310.0000320.0000495falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:24:30Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a119-eed8-7793-a30f-74e8dfabad6fJPM2026-09-14 14:07other2127108810.00unknown348.79002.9000["330","350"]["0.3755","0.2408"][]["MCRY"]330.0000350.00004123falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:07:14Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0911a-13c8-78c1-a2b9-4104df1ac507JPM2026-09-11 11:33other2110100000.00unknown356.71006.1000["305","310"]["0.2142","0.3079"][]["XMIO"]305.0000310.00002135falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:33:36Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090e8-6509-7a01-8c4c-cdd340442b52JPM2026-09-11 10:39other2256497504.00unknown355.58003.5750["315"]["0.3770"][]["ARCO","EDGO"]315.0000315.0000798falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:39:11Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090c5-3538-7ca0-a008-e0c0a4adf393JPM2026-09-11 10:00call_vertical_spread21367248092.00unknown358.78501.3600["375","385"]["0.2245","0.2248"][]["XISX"]375.0000385.00003535falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:00:39Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090c0-66c1-7f73-847c-1e6691b06d7eJPM2026-09-11 09:55other4135209685.00unknown357.56007.3600["350","355","375","380"]["0.2381","0.2533","0.2025","0.2490"][]["XISX"]350.0000380.0000770falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:55:31Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08bed-c071-7013-bdfb-f57dc3c13a43JPM2026-09-10 11:26other218245352.00unknown353.58004.9000["200"]["1.1671"][]["MCRY"]200.0000200.0000899falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:26:59Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b99-4f40-7d32-a3b2-23b35ce85976JPM2026-09-10 09:54call_diagonal_spread2110100050.00unknown351.57006.0500["300","350"]["0.6159","0.2510"][]["XISX"]300.0000350.00008463falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:54:42Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b99-4f40-7d32-a3b2-23af906d1812JPM2026-09-10 09:54other2241369328.00unknown351.57006.4500["310","350"]["0.5183","0.2509"][]["XMIO"]310.0000350.00008463falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:54:42Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0874c-2ca0-7f72-9db4-45f91e091d4aJPM2026-09-09 13:51call_diagonal_spread215153310.00unknown354.77004.9500["200","210"]["1.7544","0.4277"][]["XMIO"]200.0000210.00009373falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:52:06Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086bc-92e9-74e2-a2ec-b6f5752499e3JPM2026-09-09 11:14iron_butterfly45135110539.00unknown354.13500.7000["350","355","360"]["0.2840","0.2811","0.2849"][]["EDGO","MCRY","XCBO","XISX","XPHO"]350.0000360.000022falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:15:09Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086b7-08f0-7ee2-bc9d-9b4565d79512JPM2026-09-09 11:08iron_butterfly41150123750.00unknown354.60001.1800["350","355","360"]["0.2867","0.2837","0.2880"][]["XMIO"]350.0000360.000022falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:08:59Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a081b8-de01-75d0-9fd8-eff875636b98JPM2026-09-08 11:52other215953106750.00unknown355.84001.4000["350","360"]["0.2406","0.2440"][]["XBOX"]350.0000360.0000129282falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:52:59Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0814d-c7f0-7060-8553-705bf88749f9JPM2026-09-08 09:55other2112003316800.00unknown356.80003.5000["270","320"]["0.3087","0.2939"][]["AMXO"]270.0000320.0000282500truetruetruetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:55:55Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08137-4e08-7fe1-a221-2ce3ea395bd9JPM2026-09-08 09:31call_vertical_spread23160114240.00unknown355.37002.1900["375","385"]["0.2434","0.2436"][]["XCBO","XPHO"]375.0000385.00003838falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:31:20Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06de9-32be-7802-b3dc-dadea7181be3JPM2026-09-04 15:33other217202825.00unknown358.05005.1500["210","220"]["0.8004","0.4774"][]["XBOX"]210.0000220.00004277falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:33:14Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06da7-b51d-7253-8e04-1b0907331a8dJPM2026-09-04 14:21call_vertical_spread22159128154.00unknown359.22500.4400["375","385"]["0.2188","0.2169"][]["XISX"]375.0000385.00004242falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:21:55Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d6c-88ad-7d40-97dd-0a8e78fe277aJPM2026-09-04 13:17other4140108240.00unknown358.55003.7500["350","375"]["0.2563","0.2151"][]["XISX"]350.0000375.00004249falsetruetruetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:17:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d3e-e12d-7452-8b12-09a7f08cd8a0JPM2026-09-04 12:27put_vertical_spread21200221200.00unknown358.11000.7000["340","345"]["0.2599","0.2563"][]["XCBO"]340.0000345.00004242falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:27:50Z"}2026-09-042026-09-07 00:532026-09-07 00:53