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 = ask×ticker = GLW×
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
01a0c456-71b7-72c1-ac64-20f1ac365bd5GLW2026-09-21 10:19call_ratio_spread2192321816.00longask156.87001.5000["130","160"]["0.6205","0.5952"]["190.26"]["BATO"]130.0000160.00008888falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-71b7-72c1-ac64-20ef2102a9afGLW2026-09-21 10:19call_ratio_spread2272252000.00longask156.87001.5500["130","160"]["0.6227","0.5951"]["190.20"]["XISX","XPHO"]130.0000160.00008888falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-6dcf-7a52-8289-04d249fc7059GLW2026-09-21 10:19call_ratio_spread2196336000.00longask156.87002.1000["130","160"]["0.6227","0.5951"]["190.20"]["XISX"]130.0000160.00008888falsefalsefalsetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-6dcf-7a52-8289-04cc9f0a6104GLW2026-09-21 10:19call_ratio_spread2164223520.00longask156.87001.7500["130","160"]["0.6205","0.5934"]["190.15"]["XBOX"]130.0000160.00008888falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b5bf-d607-7c53-8fae-80c07746e8fbGLW2026-09-18 14:20put_diagonal_spread212501136000.00shortask149.07004.0500["100","170"]["0.6325","0.5981"][]["SPHR"]100.0000170.0000119490falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:20:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b58e-90bf-7342-bf94-883d6b308762GLW2026-09-18 13:26call_diagonal_spread2130557248.00unknownask150.45005.6000["30","75"]["47.1989","0.6211"][]["XPHO"]30.000075.00000854truefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:27:31Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d7-1be7-7293-b98d-8a9ff1e79405GLW2026-09-18 10:06put_vertical_spread21100152800.00longask149.60502.1400["80","130"]["0.6161","0.6065"]["117.50"]["XMIO"]80.0000130.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:06:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4b6-bad8-7fe0-8bef-2038a05844baGLW2026-09-18 09:31call_vertical_spread2159167029.00longask153.26003.0300["125","175"]["2.8911","2.0818"]["153.25"]["XMIO"]125.0000175.000000falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:31:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0d4-c9e3-7a81-abd2-8467a81babb7GLW2026-09-17 15:25call_diagonal_spread2116259872.00shortask147.70832.6500["65","70"]["8.0482","0.7445"][]["XMIO"]65.000070.00001120falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:25:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b01a-8a33-7501-9f8c-54196188a3fdGLW2026-09-17 12:02call_diagonal_spread2148735312.00shortask148.44495.2000["72.5","75"]["0.7091","0.6286"][]["XISX"]72.500075.000092183falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:02:05Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0a602-75ee-7641-abb3-694a7a65d4e2GLW2026-09-15 12:59call_diagonal_spread2110177430.00shortask143.48005.6500["35","120"]["0.7509","0.6490"][]["XCBO"]35.0000120.0000458857falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:59:44Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5c3-af9e-7c73-9cf8-9cda92e47a12GLW2026-09-15 11:50synthetic2277151382.00shortask143.44000.3500["145"]["0.5873"]["144.05"]["ARCO","XBOX"]145.0000145.00003131falsefalsefalsefalsetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:51:42Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5c3-a7ce-7180-aa3b-51b9818bedfbGLW2026-09-15 11:50synthetic2258113854.00shortask143.44000.4500["145"]["0.5864"]["144.02"]["ARCO","XBOX"]145.0000145.00003131falsefalsefalsefalsetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:51:42Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a12b-4840-7452-aac2-eac147ab6ed6GLW2026-09-14 14:26call_diagonal_spread2125282059.00longask145.75005.6500["140","145"]["0.6342","0.6296"][]["XMIO"]140.0000145.0000641858falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:26:10Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a090-fc40-79a0-9e95-fa94681641b0GLW2026-09-14 11:37call_vertical_spread211297137482.00longask147.68500.1300["160","175"]["0.7402","0.8135"]["160.82"]["AMXO"]160.0000175.000044falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:37:48Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a06d-d058-7531-bf7f-355a68d94adbGLW2026-09-14 10:59call_vertical_spread2115122190.00longask146.24004.8000["120","145"]["0.6517","0.6477"]["131.82"]["XCBO"]120.0000145.0000276276falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:59:13Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a05e-76a9-7cc2-8118-8e707eb4c99cGLW2026-09-14 10:42call_vertical_spread2115151800.00longask148.60505.5000["100","200"]["0.6495","0.6503"]["136.80"]["XMIO"]100.0000200.0000494494falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:42:25Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091a8-51d8-7051-9eb8-24f166a23dadGLW2026-09-11 14:08call_vertical_spread2130455910.00longask167.07643.7500["70","120"]["0.6742","0.6350"]["114.51"]["XCBO"]70.0000120.0000126126falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:08:46Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090d4-2571-7ce3-808e-9e19a8c938e8GLW2026-09-11 10:16call_diagonal_spread21100359900.00longask165.61003.8500["150","200"]["0.5742","0.6333"][]["XCBO"]150.0000200.00007189falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:17:05Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08bef-df68-7400-bdd6-7024562879e9GLW2026-09-10 11:29put_vertical_spread2120127600.00longask165.70004.4000["130","140"]["0.6704","0.6699"]["134.94"]["XMIO"]130.0000140.0000645645falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:29:52Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08752-5e90-76f0-8c0b-4e36ebd18bc3GLW2026-09-09 13:58call_vertical_spread2245134280.00longask168.51500.9500["170","200"]["0.6670","0.6762"]["179.70"]["XCBO"]170.0000200.00007272falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:58:35Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086f5-4688-7de1-8315-4415fe9cd8c4GLW2026-09-09 12:16call_diagonal_spread21100534800.00shortask168.17503.1000["140","150"]["0.7799","0.6551"][]["EDGO"]140.0000150.0000937falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:17:21Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0825a-9858-7b03-bf05-77c537e81878GLW2026-09-08 14:49call_diagonal_spread2134237490.00longask167.92004.1000["135","145"]["0.9003","0.6679"][]["XMIO"]135.0000145.000010101falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:49:49Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0825a-9088-79f3-ac3e-a4dc2e96dff3GLW2026-09-08 14:49call_diagonal_spread2132223520.00longask168.03004.1000["135","145"]["0.8680","0.6651"][]["XCBO"]135.0000145.000010101falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:49:49Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081f0-b6e0-7803-b754-2b92a19e07cdGLW2026-09-08 12:53call_diagonal_spread215105200.00shortask168.14503.4500["70","75"]["0.6628","0.6298"][]["XCBO"]70.000075.0000465647falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:54:31Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0814a-b2e0-7452-8408-7c3c8837cc49GLW2026-09-08 09:52call_diagonal_spread2147128498.00longask163.64993.2500["152.5","175"]["0.8749","0.6491"][]["BATO"]152.5000175.0000373falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:52:48Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08141-92f0-7e70-b4b9-d6228ef208baGLW2026-09-08 09:42put_vertical_spread2125114850.00longask161.13003.8000["110","120"]["0.6650","0.6645"]["115.50"]["XMIO"]110.0000120.0000647647falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:42:35Z"}2026-09-082026-09-08 21:502026-09-08 21:50