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:ticker = BMY×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
01a06d2a-4ba5-7641-ae96-27f0bc353ba0BMY2026-09-04 12:04other3145109485.00unknown—67.00502.1400["50","57.5","65"]["0.3608","0.2768","0.2412"][]["XMIO"]50.000065.0000133504falsefalsetruetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:05:10Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a0815c-cbb0-74b0-834b-64f867c3549fBMY2026-09-08 10:12other214205672800.00unknown—64.88500.3400["70"]["0.2431"][]["AMXO"]70.000070.00001073falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:12:29Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08b8e-2f98-7761-9b74-aef269460fafBMY2026-09-10 09:42call_diagonal_spread2189118370.00longbid64.14503.7000["65","67.5"]["0.2996","0.2563"][]["XMIO"]65.000067.5000280372falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:42:25Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c97-0860-7141-80c1-a63ac4786b4eBMY2026-09-10 14:31other21128761886334.00unknown—63.94000.1800["50","60"]["0.3362","0.3297"][]["XCBO"]50.000060.00009999truetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:31:45Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cc0-a0d0-7ef3-be03-81a50627eb87BMY2026-09-10 15:17other29202105814.00unknown—63.96920.2000["60"]["0.3356"][]["AMXO","ARCO","EDGO","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"]60.000060.000099127falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:17:15Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cc1-9300-73d1-953e-cb5c860531faBMY2026-09-10 15:18put_calendar210238127260.00shortbid63.93500.1559["60"]["0.3391"][]["AMXO","ARCO","C2OX","EDGO","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"]60.000060.000099127falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:18:22Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cc5-1570-7b33-b707-4090afa1fad1BMY2026-09-10 15:21other210159101462.00unknown—63.93500.2000["60","62.5"]["0.3485","0.3310"][]["AMXO","ARCO","EDGO","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"]60.000062.500099127falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:22:23Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0aaa4-e93b-7610-a21d-e035b6a4478cBMY2026-09-16 10:35call_calendar2636106194.00shortbid64.19000.4500["50"]["0.9252"][]["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]50.000050.00002184falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:35:35Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa4-e93b-7610-a21d-dfdb61a36e3aBMY2026-09-16 10:35call_calendar2535103229.00shortbid64.19000.4500["50"]["0.8731"][]["BATO","C2OX","EDGO","XCBO","XISX"]50.000050.00002184falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:35:35Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa4-e553-7043-a639-2e40ddb2fc6cBMY2026-09-16 10:35call_calendar2535103096.00shortbid64.19000.3100["50"]["1.0510"][]["AMXO","ARCO","MCRY","XBOX","XPHO"]50.000050.00002184falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:35:35Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aba7-a783-7cd3-85b2-7dac2010078aBMY2026-09-16 15:18put_frontspread2180001268000.00longask63.34000.2600["50","60"]["0.3446","0.3390"]["41.81","58.19"]["XPHO"]50.000060.00009393falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:18:21Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0afe7-83b3-7a20-b5e6-506f8abd0d8cBMY2026-09-17 11:06put_frontspread214000884000.00longask63.40000.1900["55","60"]["0.3357","0.3399"]["50.50","59.50"]["SPHR"]55.000060.00009292falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:06:27Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b00f-0113-7dd1-8c85-fc8a1b8cb215BMY2026-09-17 11:49put_ratio_spread2180001748000.00unknown—63.43820.3200["52.5","62.5"]["0.3217","0.3322"][]["XPHO"]52.500062.50009292falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:49:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0bd-3aa3-76b3-a9bc-8fdb3ab0335eBMY2026-09-17 14:59put_ladder31198134580.00unknown—63.06001.4500["66","67","70"]["0.8346","0.9377","1.7924"][]["XBOX"]66.000070.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:00:08Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b4dc-8a88-7ec0-bc7c-01449b052cceBMY2026-09-18 10:12call_diagonal_spread2135004098000.00unknownask62.51001.4500["55","62.5"]["3.5204","0.2772"][]["XPHO"]55.000062.50000272falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:12:34Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b615-d1bf-7e31-ab79-9b3bc8ae5c49BMY2026-09-18 15:54put_ratio_spread21576209088.00unknownbid62.77000.7500["45","55"]["0.3687","0.3660"]["36.22","53.78"]["XPHO"]45.000055.0000364364falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:54:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15