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:ticker = MRK×sorted by executed_at ↑×
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
01a06d2e-a105-7861-bdc1-d8b64f6192ecMRK2026-09-04 12:09call_vertical_spread21145144130.00shortbid150.76000.6500["145","150"]["0.2333","0.2344"]["148.40"]["XMIO"]145.0000150.00001414falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:09:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d59-4ecd-7210-bb31-b9aa948a185eMRK2026-09-04 12:56other2196487872.00unknown—150.24003.9500["120","135"]["0.7398","0.3032"][]["ARCO"]120.0000135.000014105falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:56:20Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d64-9585-7a12-9726-10d4909d3bf2MRK2026-09-04 13:08call_diagonal_spread_bearish21748477218.00shortask150.37001.9300["145","165"]["0.2733","0.2780"][]["XMIO"]145.0000165.0000721falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:08:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d99-70c6-7851-9abf-221fe53adff2MRK2026-09-04 14:06straddle2562179118.00longask150.34680.6581["155"]["0.3279"]["126.11","183.89"]["ARCO","MCRY","XBOX","XPHO"]155.0000155.0000196196falsefalsefalsefalsetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:06:53Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a0820d-62b8-77b0-a1e6-98c15d279a7bMRK2026-09-08 13:25call_vertical_spread2185639710.00unknown—148.76504.2500["110","115"]["0.3908","0.2190"][]["AMXO"]110.0000115.0000129129falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:25:27Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08253-4940-70b3-bec9-715e5c4df5a0MRK2026-09-08 14:41call_diagonal_spread2120178600.00longbid148.63004.4000["95","120"]["0.5716","0.2965"][]["XMIO"]95.0000120.0000101282falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:41:47Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08667-7da9-7112-8ed4-4df4cce11419MRK2026-09-09 09:42call_diagonal_spread2111134420.00longbid148.43506.6500["85","90"]["2.5073","0.6437"][]["XCBO"]85.000090.00009100falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:42:13Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08b8a-0918-7871-8d72-4db34310542bMRK2026-09-10 09:37call_diagonal_spread2140301960.00shortask146.88005.5500["100","125"]["1.6174","0.3037"][]["XMIO"]100.0000125.00008190falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:38:05Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ba0-8300-7e50-bcba-48a4a2d211d8MRK2026-09-10 10:02call_diagonal_spread2144222816.00longbid146.24503.1000["120","135"]["0.8790","0.3071"][]["XMIO"]120.0000135.00008280falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:02:36Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bd4-e528-7b33-827b-22f4f8277eebMRK2026-09-10 10:59call_calendar2154489672.00shortbid144.44002.7500["100"]["0.6045"][]["SPHR"]100.0000100.00008190falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:00:02Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bd4-f4c8-7a21-ab75-69f667f63694MRK2026-09-10 10:59call_calendar2183752644.00shortbid144.43502.7500["100"]["0.6176"][]["SPHR"]100.0000100.00008190falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:00:02Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c66-bd18-7913-b1da-348a70e166d4MRK2026-09-10 13:38call_calendar2181743904.00shortask144.98002.6500["100"]["0.6491"][]["XPHO"]100.0000100.00008190falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:39:29Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c95-eb38-7fe2-a59f-4e5b782bcccaMRK2026-09-10 14:30put_vertical_spread2174141340.00unknown—145.01002.7500["152.5","155"]["1.0631","1.2685"][]["XBOX"]152.5000155.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:30:37Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a090ba-34d0-7cf2-b66e-0822d9a38d12MRK2026-09-11 09:48call_diagonal_spread22244581208.00shortbid145.14002.0500["135","140"]["0.2380","0.2942"][]["ARCO"]135.0000140.00003598falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:48:51Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090bd-3270-7900-b7ba-c9f610f72570MRK2026-09-11 09:51call_diagonal_spread2165387270.00shortask144.96004.7500["115","130"]["0.3795","0.2821"][]["XMIO"]115.0000130.000098371falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:52:08Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090c9-82c8-74f0-b81c-6b2fa49eaa0fMRK2026-09-11 10:05other22731143080811.00unknown—144.04005.2500["105"]["0.3374"][]["XCBO"]105.0000105.000098189falsefalsetruefalsefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:05:23Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09179-9500-7632-adcb-6fca1002c62bMRK2026-09-11 13:17call_diagonal_spread2170637000.00unknown—145.57003.6000["100","105"]["0.3162","0.2370"][]["XISX"]100.0000105.000098371falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:17:55Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0917f-3668-7472-a062-858737450ceeMRK2026-09-11 13:23call_diagonal_spread2132297152.00shortbid145.40002.4000["100","105"]["0.3530","0.2442"][]["XISX"]100.0000105.0000126497falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:24:13Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0917f-3668-7472-a062-85759078e09aMRK2026-09-11 13:23call_diagonal_spread2132297152.00shortbid145.40002.4000["100","105"]["0.3530","0.2442"][]["XPHO"]100.0000105.0000126497falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:24:13Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0917f-3668-7472-a062-85ac616ef225MRK2026-09-11 13:23other2128262360.00unknown—145.40002.2500["100","105"]["0.3530","0.2612"][]["XBOX"]100.0000105.0000126497falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:24:13Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0917f-3668-7472-a062-85901258d5a4MRK2026-09-11 13:23other2264597568.00unknown—145.40002.2500["100","105"]["0.3530","0.2545"][]["XBOX","XISX"]100.0000105.0000126497falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:24:13Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0919c-9dc0-7211-972c-f5a51207779aMRK2026-09-11 13:55other2130171300.00unknown—145.37502.2000["115","120"]["1.0342","0.1944"][]["XPHO"]115.0000120.0000798falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:56:26Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0a08c-8b89-7de0-ac2c-80627ec63cc2MRK2026-09-14 11:32other2250190000.00unknown—144.74501.4000["110","200"]["1.4914","0.3152"][]["EDGO","XPHO"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:32:41Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a09d-2d58-7730-acf7-b2092b02ea17MRK2026-09-14 11:50other2384324001.00unknown—145.02531.2000["110","200"]["1.4012","0.3149"][]["EDGO","XCBO","XISX"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:50:52Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a09d-2971-7382-9c6f-5f5e1fbe5fb8MRK2026-09-14 11:50call_diagonal_spread2442161930.00longbid145.02531.1786["110","200"]["1.4340","0.3142"][]["AMXO","XBOX","XMIO","XPHO"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:50:52Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a09d-b9f8-7251-93aa-c29338e3d3c1MRK2026-09-14 11:51call_diagonal_spread2453204608.00shortask145.14001.4500["110","200"]["1.3193","0.3137"][]["AMXO","EDGO","XCBO","XISX"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:51:28Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a09d-b9f8-7251-93aa-c27e0a0680cdMRK2026-09-14 11:51call_diagonal_spread2332123680.00shortask145.14001.1406["110","200"]["1.3838","0.3136"][]["XBOX","XPHO"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:51:28Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a09d-b9f8-7251-93aa-c237c5a1f63aMRK2026-09-14 11:51call_diagonal_spread2436139164.00longbid145.11001.0708["110","200"]["1.4235","0.3138"][]["XBOX","XMIO","XPHO"]110.0000200.00004276falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:51:28Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a1-1558-7331-9c25-84fbf40141ddMRK2026-09-14 11:55other216612842300.00unknown—145.26504.2500["125"]["0.2720"][]["XBOX"]125.0000125.00003267falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:55:15Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a1-e460-7fc0-9e71-7c7a3f1c5b6cMRK2026-09-14 11:55call_calendar2240167520.00shortbid145.24004.2500["125"]["0.2566"][]["ARCO"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:55:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a1-fbd0-7d32-8556-bb3fb3b692adMRK2026-09-14 11:56call_calendar2140165790.00shortbid145.20003.4313["125"]["0.2427"][]["XISX"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:56:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a2-0f59-71a0-b2e8-9a38ddd270e8MRK2026-09-14 11:56other2231128394.00unknown—145.20002.5919["125"]["0.2417"][]["BATO","XISX"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:56:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a2-22e0-7752-9ca7-ca4fc17b37edMRK2026-09-14 11:56call_calendar2135144830.00shortbid145.21002.7500["125"]["0.2360"][]["XMIO"]125.0000125.00003267falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:56:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a2-3668-7070-961b-588a79b0e89aMRK2026-09-14 11:56call_calendar2140167200.00shortbid145.24502.7000["125"]["0.2452"][]["XMIO"]125.0000125.00003267falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:56:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a3-6330-7272-8128-c9b5d754269bMRK2026-09-14 11:57other2140167600.00unknown—145.26002.3000["125"]["0.2618"][]["MCRY"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:57:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a3-76b8-78c1-b917-a97d93ae227fMRK2026-09-14 11:57other2140167600.00unknown—145.28002.2000["125"]["0.2556"][]["MCRY"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:57:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a3-8a40-73c2-850f-368e09558578MRK2026-09-14 11:57other2140167600.00unknown—145.28002.2000["125"]["0.2556"][]["EMLD"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:57:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0a3-9dc8-7c80-98c6-d0cacf6d6d17MRK2026-09-14 11:57other2128117320.00unknown—145.28002.2000["125"]["0.2556"][]["BATO"]125.0000125.00003267falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:57:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0ab-8538-7e81-b776-740ec01c59b3MRK2026-09-14 12:06call_diagonal_spread2146110676.00longbid145.06001.3500["130","150"]["0.1810","0.2953"][]["BATO"]130.0000150.000032123falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:06:49Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0ae-e098-7c11-ba42-49e36808c4c8MRK2026-09-14 12:10call_diagonal_spread2140105560.00longbid145.07501.3000["130","135"]["0.5080","0.2354"][]["XMIO"]130.0000135.0000432falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:10:13Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0b6-2010-7b62-a1a3-1326622ea407MRK2026-09-14 12:18call_diagonal_spread21227251970.00longask145.15001.8000["140","146"]["0.2904","0.2978"][]["XMIO"]140.0000146.0000446falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:18:28Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0bb-4861-76b1-ad40-335bac39f1cbMRK2026-09-14 12:23call_diagonal_spread219106038.00unknown—145.23005.6500["85","100"]["0.2115","0.2201"][]["XMIO"]85.0000100.0000494858falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:23:55Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0e7-b378-7e50-bfb8-98fe124f47c6MRK2026-09-14 13:12call_diagonal_spread2158352176.00shortask145.20002.1500["115","120"]["0.2152","0.2811"][]["ARCO"]115.0000120.000095186falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:12:43Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0ec-d3f8-7da1-9396-945c6c90e3afMRK2026-09-14 13:17call_diagonal_spread2122132836.00shortask145.21003.0500["115","120"]["0.4801","0.2834"][]["XMIO"]115.0000120.000032214falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:18:06Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0ed-0aa8-72d3-9225-79c175b66e7aMRK2026-09-14 13:18call_diagonal_spread2128168980.00shortask145.32002.9000["115","120"]["0.4495","0.2787"][]["XMIO"]115.0000120.000032214falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:18:06Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a114-12d8-7d13-840f-25eb6b50cec1MRK2026-09-14 14:00call_diagonal_spread21385518210.00unknown—145.29500.7500["140","145"]["0.2795","0.3017"][]["EDGO"]140.0000145.0000467falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:01:24Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a126-56a1-77e3-848e-b1902c0204c1MRK2026-09-14 14:20call_calendar2112134016.00shortask145.28003.4500["90"]["0.3593"][]["EDGO"]90.000090.0000123214falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:21:00Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a155-03d8-7a60-a79c-a02a21431f56MRK2026-09-14 15:11other214171736585.00unknown—144.74002.2000["115","120"]["1.2474","0.2941"][]["XCBO"]115.0000120.00004186falsefalsetruetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:11:50Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a155-03d8-7a60-a79c-a0123df9ece7MRK2026-09-14 15:11other2186509980.00unknown—144.74002.2000["115","120"]["1.2474","0.2941"][]["XCBO"]115.0000120.00004186falsefalsetruetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:11:50Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a16d-46c8-7470-9182-2af4cab0597dMRK2026-09-14 15:38other2120280440.00unknown—144.69006.2000["50","100"]["0.4415","0.5683"][]["XPHO"]50.0000100.000032494falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:38:42Z"}2026-09-142026-09-14 17:152026-09-14 17:15