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.

403,968 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:net_side = bid×ticker = JPM×
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
01a0ca7c-3c57-7d22-878a-b2af8156a955JPM2026-09-22 14:58call_vertical_spread2150467250.00shortbid340.88504.3000["370","380"]["0.2223","0.2232"]["373.83"]["XPHO"]370.0000380.0000815815falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T18:59:07Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c9ec-d17f-70a3-aa6f-1d27973b9f24JPM2026-09-22 12:22call_diagonal_spread2713115372.00unknownbid340.73004.2269["310","370"]["0.2263","0.2183"][]["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"]310.0000370.0000115850falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T16:22:25Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c9d2-8aee-7b93-abdd-ed250e07c729JPM2026-09-22 11:53put_vertical_spread2110120500.00shortbid338.63003.9500["380","390"]["0.2973","0.3017"]["383.30"]["BATO"]380.0000390.0000486486falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T15:53:35Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c9ce-31a6-7fb1-9b4b-8bd140556014JPM2026-09-22 11:48call_diagonal_spread2625217984.00unknownbid338.10002.8000["310","370"]["0.2469","0.2234"][]["BATO","EMLD","XCBO","XISX","XMIO","XPHO"]310.0000370.0000115850falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T15:48:56Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c9cd-bc77-7cd1-9378-9c72bd41468cJPM2026-09-22 11:48call_diagonal_spread2414122462.00unknownbid338.11682.1000["310","370"]["0.2491","0.2241"][]["AMXO","EMLD","XISX","XMIO"]310.0000370.0000115850falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T15:48:56Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c98b-44d7-7081-9091-6f6fa2d3e43dJPM2026-09-22 10:35call_diagonal_spread2130472800.00unknownbid340.00003.3750["260","270"]["0.6158","0.2442"][]["XISX"]260.0000270.000024178falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T14:35:56Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c98a-8d3f-7bf1-b5cb-0ab48b9bac3bJPM2026-09-22 10:34call_vertical_spread28100165736.00unknownbid340.04000.5500["345","365"]["0.2390","0.2324"]["361.57"]["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"]345.0000365.00005959falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T14:35:10Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c989-fcb6-7be2-9961-f07855821c67JPM2026-09-22 10:34call_diagonal_spread21601013040.00longbid340.19505.7000["255","265"]["0.4479","0.2525"][]["XMIO"]255.0000265.000059178falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T14:34:47Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c978-2267-7143-b793-d09fe08d363eJPM2026-09-22 10:14call_butterfly_spread3120106480.00unknownbid342.01007.3500["300","340","360"]["0.2617","0.2436","0.2368"]["361.62"]["XCBO"]300.0000360.0000115115falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T14:14:52Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0c973-0d9f-77f1-b687-6ce0e3f00aa6JPM2026-09-22 10:09call_calendar241741129426.00shortbid343.40001.0000["350"]["0.2321"][]["C2OX","EDGO","XCBO","XPHO"]350.0000350.0000268360falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-22T14:09:19Z"}2026-09-222026-09-22 17:152026-09-22 17:15
01a0b614-9557-7e82-a0d2-83367b2971e5JPM2026-09-18 15:53call_diagonal_spread2110109440.00longbid348.51245.1000["300","330"]["0.2457","0.2323"][]["XMIO"]300.0000330.0000182364falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:53:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60f-9030-7850-a116-6f9d1fe0c4bbJPM2026-09-18 15:47call_vertical_spread2150471000.00shortbid347.47505.7000["380","390"]["0.2251","0.2271"]["383.50"]["SPHR"]380.0000390.0000819819falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b579-6e97-7520-8d22-2d1bf578562fJPM2026-09-18 13:03strangle21500569000.00shortbid347.16000.6500["335","355"]["0.2839","0.2324"]["323.62","366.38"]["XPHO"]335.0000355.00002828falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:03:57Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b56d-ba7f-7483-ae46-1a7ca2620727JPM2026-09-18 12:50call_diagonal_spread2182122580.00shortbid346.86501.2500["340","350"]["0.5302","0.2354"][]["XCBO"]340.0000350.0000028falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:51:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d7-5e50-7971-a2a2-2d1c8055a95fJPM2026-09-18 10:06call_calendar2120389120.00longbid346.85006.1000["250"]["3.6683"][]["XMIO"]250.0000250.0000091falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:06:48Z"}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
01a0afbe-aaab-7cf2-936d-0592f2930a91JPM2026-09-17 10:21call_diagonal_spread2125152000.00shortbid346.68002.3500["325","330"]["0.2532","0.2478"][]["XCBO"]325.0000330.000064120falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:21:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afbb-c47b-7841-9159-0623826f06ebJPM2026-09-17 10:18put_vertical_spread2110112360.00shortbid346.09504.3000["380","390"]["0.2945","0.2977"]["383.70"]["XMIO"]380.0000390.0000491491falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:18:31Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab99-e02b-7dd1-b67e-818caf6aa3b6JPM2026-09-16 15:03call_diagonal_spread2120423220.00longbid347.89006.1500["240","250"]["2.5382","0.3126"][]["XCBO"]240.0000250.00002184falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:03:06Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaef-e48b-74a0-9601-7be3a75dc134JPM2026-09-16 11:57straddle211501615500.00shortbid351.80992.7500["350"]["0.2614"]["242.30","457.70"]["AMXO"]350.0000350.0000821821falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:57:36Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aae0-5043-7ca2-aacd-4d22ecd20134JPM2026-09-16 11:40put_calendar22224313152.00shortbid350.31000.8500["350"]["0.3112"][]["ARCO"]350.0000350.0000230falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:41:10Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa92-9da3-77d0-bb19-810c69e0c9afJPM2026-09-16 10:15put_vertical_spread2110107280.00shortbid350.35003.9500["380","390"]["0.2903","0.2926"]["383.96"]["BATO"]380.0000390.0000492492falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:15:56Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a686-2cae-7951-8607-6f37019de36fJPM2026-09-15 15:23call_vertical_spread21600267600.00shortbid353.17500.6100["375","385"]["0.2390","0.2395"]["376.50"]["XMIO"]375.0000385.00003131falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:23:40Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5ec-bb6e-7353-ab47-c1d04fe8e755JPM2026-09-15 12:35call_diagonal_spread2218130601.00shortbid344.94001.7500["310","340"]["0.6156","0.2460"][]["EDGO"]310.0000340.00003275falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:35:51Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5e6-4ee6-74a3-a412-d245c116851eJPM2026-09-15 12:28call_calendar219218970.00shortbid344.72006.2000["225"]["0.4456"][]["XPHO"]225.0000225.000094185falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:29:00Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a54f-df2e-7a53-bf9c-66202d91ef4cJPM2026-09-15 09:44call_diagonal_spread2110246220.00longbid349.85006.7500["225","230"]["0.4688","0.4270"][]["XMIO"]225.0000230.00006694falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:44:44Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a167-b8e9-7081-b477-1976215f33c6JPM2026-09-14 15:32put_diagonal_spread2596207770.00shortbid349.25500.8271["350","355"]["0.2858","0.2597"][]["ARCO","BATO","C2OX","EDGO","XBOX"]350.0000355.0000467falsefalsetruetruefalsemletmarket_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
01a0a142-46f9-7431-8780-536c5a15c372JPM2026-09-14 14:51call_diagonal_spread215115330.00shortbid350.29005.6000["220","250"]["0.5384","1.7552"][]["EDGO"]220.0000250.0000467falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:52:04Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a101-3e88-7400-9989-ea10810fdc92JPM2026-09-14 13:40put_calendar2150131000.00longbid348.81500.9500["350"]["0.2696"][]["BATO"]350.0000350.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:40:22Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a090-aa38-7b41-bf44-3dbc2e74574aJPM2026-09-14 11:37call_diagonal_spread2118369630.00longbid350.62826.7500["250","270"]["0.3151","0.2661"][]["XISX"]250.0000270.0000123494falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:37:19Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a068-4660-7fd2-b71e-7607883d4864JPM2026-09-14 10:53call_diagonal_spread2116135424.00shortbid350.96005.5000["310","320"]["0.8781","0.2637"][]["ARCO"]310.0000320.00004123falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:53:20Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a09127-d350-7980-adb3-23ec896f59eaJPM2026-09-11 11:48call_diagonal_spread218105984.00shortbid357.06507.0000["330","350"]["0.2487","0.2445"][]["EDGO"]330.0000350.0000497826falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:48:26Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09104-12f8-7230-a3b3-bf12ea832a3aJPM2026-09-11 11:09call_diagonal_spread2117158236.00shortbid355.90004.5500["320","350"]["0.2459","0.2450"][]["XMIO"]320.0000350.000098462falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:09:38Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c83-a388-7d21-8dca-dfa15833ad36JPM2026-09-10 14:10straddle22250546250.00shortbid352.64001.1000["350"]["0.2461"]["328.15","371.85"]["AMXO"]350.0000350.00003636falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:11:03Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c24-5ce9-7721-a873-6fba6079ce96JPM2026-09-10 12:26call_vertical_spread2127101466.00shortbid352.52000.9500["370","375"]["0.2410","0.2398"]["372"]["XMIO"]370.0000375.0000190190falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:27:11Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bce-fd70-7870-8abc-c4c163babd0cJPM2026-09-10 10:53call_calendar2117655656.00shortbid352.75006.4500["160"]["1.8978"][]["ARCO"]160.0000160.0000871falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:53:45Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08723-a1b8-7251-8f5b-84c2a1e0ddbbJPM2026-09-09 13:07call_calendar21156138528.00shortbid355.06090.8000["375"]["0.2342"][]["BATO"]375.0000375.00003744falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:08:17Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0868c-cc70-7cc0-9997-dc6557e5b660JPM2026-09-09 10:22call_diagonal_spread2110173530.00shortbid353.67506.2500["270","310"]["0.2970","0.2182"][]["XMIO"]270.0000310.0000100828falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:23:08Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a06d95-7d0d-7ad0-a143-d83e9a5c2686JPM2026-09-04 14:01call_calendar212004007000.00longbid358.77003.9000["260"]["0.4176"][]["XCBO"]260.0000260.000042105falsefalsetruefalsefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:01:50Z"}2026-09-042026-09-07 00:532026-09-07 00:53