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 = CCL×
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
01a0c588-e2ef-78c2-ade5-c0a8c1d8bec3CCL2026-09-21 15:54put_diagonal_spread211100990400.00unknownask22.33500.5500["23","30"]["0.5011","0.5156"][]["XMIO"]23.000030.0000179452falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4fe-cf47-7d22-90d0-4c757b01a58aCCL2026-09-21 13:23put_vertical_spread2185191250.00longask22.38500.9000["32","35"]["0.5660","0.6428"]["32.08"]["XMIO"]32.000035.0000116116falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:23:59Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b0a2-f7fb-7fd1-afd9-b1ba9833a6dcCCL2026-09-17 14:31put_vertical_spread211247610779264.00unknown—22.26500.5200["25","28"]["1.6632","2.7702"][]["XBOX"]25.000028.000011truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:31:45Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a2-9a3b-7830-a2ac-803d0f21245bCCL2026-09-17 14:30put_vertical_spread2148875962140.00unknown—22.25500.5500["27","30"]["2.5504","3.5414"][]["XBOX"]27.000030.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:30:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a2-7ee3-7781-80a7-7d92781386acCCL2026-09-17 14:30put_vertical_spread21150008550000.00unknown—22.25500.4900["24","26"]["1.3053","2.1729"][]["XBOX"]24.000026.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:30:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a2-5bbb-7a01-9cb5-845dedb93e5bCCL2026-09-17 14:30put_ladder3130664170420.00unknown—22.25500.9000["28","29","30"]["2.9015","3.2308","3.5414"][]["XBOX"]28.000030.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:30:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b073-5892-77a2-add5-b43bc91da41bCCL2026-09-17 13:39put_calendar2190174510.00unknown—22.30020.8000["30"]["0.5192"][]["XCBO"]30.000030.0000491855falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:39:03Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b029-c4a3-7e93-a5e4-cc8adf539476CCL2026-09-17 12:18call_ratio_spread21112501800000.00unknown—22.30500.1000["24","30"]["0.4500","0.4446"][]["AMXO"]24.000030.0000120120falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:18:58Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0a62b-4ef6-74b1-a2a3-3b2becf21929CCL2026-09-15 13:44risk_reversal37475190627.00shortask22.11500.5600["17","21","30"]["0.5180","0.5077","0.4412"]["20.34"]["BATO","C2OX","EDGO","XCBO","XISX"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-4b0e-7592-b700-fc3a5b18d34eCCL2026-09-15 13:44risk_reversal37675268840.00shortask22.11500.5600["17","21","30"]["0.5163","0.5072","0.4367"]["20.32"]["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-3786-7812-9bb5-313bc892b165CCL2026-09-15 13:44risk_reversal36484192790.00shortask22.13000.5700["17","21","30"]["0.5197","0.5047","0.4380"]["20.36"]["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-3785-7892-b9f5-4b31e7cf683fCCL2026-09-15 13:44risk_reversal37297118304.00shortask22.13000.5700["17","21","30"]["0.5187","0.5056","0.4378"]["20.35"]["AMXO","EMLD","MCRY","XBOX","XISX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-3785-7892-b9f5-4b280984c383CCL2026-09-15 13:44risk_reversal35255102306.00shortask22.13000.5700["17","21","30"]["0.5197","0.5072","0.4411"]["20.36"]["BATO","C2OX","EDGO","XCBO","XISX"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-3785-7892-b9f5-4b1227e69b3eCCL2026-09-15 13:44risk_reversal37362144066.00shortask22.13500.5700["17","21","30"]["0.5190","0.5064","0.4360"]["20.34"]["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-2bce-72e3-9a33-f652ee65b19bCCL2026-09-15 13:43risk_reversal36300119900.00shortask22.13500.5800["17","21","30"]["0.5200","0.5050","0.4405"]["20.37"]["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-2bce-72e3-9a33-f64ac76c1cf0CCL2026-09-15 13:43risk_reversal36302120394.00shortask22.14500.5800["17","21","30"]["0.5221","0.5051","0.4372"]["20.37"]["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-2bce-72e3-9a33-f62aa6090e4cCCL2026-09-15 13:43risk_reversal37334132838.00shortask22.14500.5800["17","21","30"]["0.5198","0.5051","0.4371"]["20.36"]["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-1c2d-7e43-a330-4714358146d4CCL2026-09-15 13:43risk_reversal37350138750.00shortask22.14500.6100["17","21","30"]["0.5216","0.5014","0.4373"]["20.39"]["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]17.000030.0000185185falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:44:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a090f9-6c69-7803-b250-310ad021b12dCCL2026-09-11 10:57put_calendar2180206080.00longbid22.90501.9500["35"]["0.5352"][]["ARCO"]35.000035.0000279462falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:57:46Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c9b-7148-7682-9a2f-cc0d7b97be1aCCL2026-09-10 14:36other31346166308.00unknown—22.39501.1100["24.5","25","26"]["1.5069","2.1371","3.0044"][]["XBOX"]24.500026.000011truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:36:49Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c95-6280-7ab0-a180-6457dbfb1dd4CCL2026-09-10 14:29put_vertical_spread213000231000.00shortbid22.39000.1400["21.5","22.5"]["0.4235","0.3872"]["22.15"]["XPHO"]21.500022.500088truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:30:02Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ba8-7240-7393-b23a-737baff3ec8cCCL2026-09-10 10:11other2185212825.00unknown—22.54500.6500["35"]["0.5374"][]["XCBO"]35.000035.0000218463falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:11:08Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a06d2e-c816-7eb0-840a-22ee2e37671dCCL2026-09-04 12:09straddle211500682500.00longask23.57000.2300["24"]["0.4505"]["19.45","28.55"]["ARCO"]24.000024.0000105105truefalsefalsefalsetruemletmarket_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