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:net_side = bid×ticker = VLO×
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
01a0c490-5dd7-77e3-a080-f18ed9a32328VLO2026-09-21 11:23call_condor4230157200.00shortbid405.49006.7000["405","410","412.5","417.5"]["0.5531","0.5415","0.5474","0.5511"]["405.80","416.7"]["XISX"]405.0000417.50001111falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:23:17Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b5ac-7517-7422-a8b6-cdebc614c6ddVLO2026-09-18 13:59other4130137430.00unknownbid411.09007.0000["412.5","415","417.5","420"]["0.5159","0.4834","0.4993","0.4632"][]["XMIO"]412.5000420.0000714falsetruetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:59:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ba-a2d8-74e2-9728-5b514e0dc45fVLO2026-09-18 09:35call_vertical_spread2141299218.00shortbid412.01006.6000["380","382.5"]["0.5264","0.5223"]["382.0"]["BATO"]380.0000382.50001414falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:35:24Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0e3-2993-7b33-9907-9447a94c68adVLO2026-09-17 15:41call_diagonal_spread2140621200.00longbid413.10504.6000["340","380"]["0.5055","0.5097"][]["XMIO"]340.0000380.000092120falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:41:11Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b086-c923-7c50-8bd4-66334b99e478VLO2026-09-17 14:00call_diagonal_spread21803876480.00shortbid409.80506.5000["170","175"]["0.8890","0.3809"][]["XPHO"]170.0000175.000092456falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:00:20Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b03b-f4e3-7c02-a613-80277f592e56VLO2026-09-17 12:38call_vertical_spread215130240.00shortbid409.17006.0000["270","300"]["0.5055","0.5109"]["296.80"]["EDGO"]270.0000300.00009292falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:39:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afec-65b3-7382-8da8-50d0acf45470VLO2026-09-17 11:11call_vertical_spread2138264898.00shortbid407.33003.8000["450","520"]["0.4945","0.4999"]["468.15"]["SPHR"]450.0000520.0000183183falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:11:55Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0a55a-185e-7c72-8ec3-9376dd68fc4aVLO2026-09-15 09:55call_frontspread229128808.00longbid390.19006.2000["270","460"]["0.5067","0.4915"]["383.20"]["XMIO"]270.0000460.0000122122falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:55:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a154-b9a0-7e22-90bc-d549ed2b60bcVLO2026-09-14 15:11strangle2130175530.00shortbid379.22000.6000["340","560"]["0.4837","0.4854"]["281.49","618.51"]["XISX"]340.0000560.0000276276falsetruefalsetruetruemletmarket_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
01a0a119-df38-7783-a1a6-3ceb24946bdfVLO2026-09-14 14:07call_diagonal_spread216101586.00shortbid381.55006.6000["390","450"]["0.4576","0.4307"][]["XISX"]390.0000450.0000494823falsetruetruetruefalsemletmarket_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
01a0917e-b968-7a52-848d-2f50e1e301f1VLO2026-09-11 13:23put_vertical_spread2150137300.00shortbid394.79002.4000["370","380"]["0.4789","0.4787"]["376.20"]["XCBO"]370.0000380.00003535falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:23:35Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0916c-f2a0-78d1-b9c5-2a5d1b1da81dVLO2026-09-11 13:03call_vertical_spread2115108210.00shortbid394.76002.1000["400","450"]["0.4844","0.4894"]["417.50"]["MCRY"]400.0000450.0000126126falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:04:11Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09149-af48-74a1-959b-905b3becfdd9VLO2026-09-11 12:25call_diagonal_spread219246600.00shortbid397.34008.0000["310","330"]["0.4407","0.4059"][]["XCBO"]310.0000330.0000462826falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:25:31Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0911a-8128-79e3-87ad-824f80794f3eVLO2026-09-11 11:33put_vertical_spread2120187400.00shortbid397.42007.5000["260","400"]["0.4842","0.4813"]["343.38"]["XCBO"]260.0000400.0000497497falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:34:09Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090e0-e328-74c2-ac15-724464b659d5VLO2026-09-11 10:30call_vertical_spread2120102760.00shortbid393.94005.0000["370","372.5"]["0.4970","0.4887"]["372.12"]["XCBO"]370.0000372.500077falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:30:57Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08662-f968-76d1-8d34-6096483ba2bfVLO2026-09-09 09:37call_diagonal_spread2119305786.00longbid383.61505.9000["260","390"]["1.5450","0.4808"][]["XMIO"]260.0000390.00009100falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:37:11Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08294-c6e0-7203-9c14-a6d68b8ee5bbVLO2026-09-08 15:53call_vertical_spread215107245.00shortbid383.85007.0000["360","400"]["0.4101","0.4108"]["375.95"]["XCBO"]360.0000400.0000829829falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:53:11Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08253-c258-7533-988a-79f55389bd02VLO2026-09-08 14:42risk_reversal2140148240.00shortbid382.49003.0000["320","450"]["0.4787","0.4807"]["457.58"]["XCBO"]320.0000450.0000129129falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:42:39Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08249-94e0-7383-aad8-c97673b8d42bVLO2026-09-08 14:30call_calendar216208800.00shortbid383.56007.4000["210"]["1.5314"][]["XMIO"]210.0000210.00001045falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:31:18Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081d9-fa90-7df3-a394-1c58d28302deVLO2026-09-08 12:28call_diagonal_spread213117135.00longbid381.74006.7000["185","190"]["2.1516","1.5994"][]["XISX"]185.0000190.00001017falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:29:10Z"}2026-09-082026-09-08 21:502026-09-08 21:50