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 = CCJ×
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
01a0c49d-e6af-7973-93df-d00fb106eab2CCJ2026-09-21 11:37call_butterfly_spread33364128310.00unknownask92.08000.5400["100","120","140"]["0.4920","0.5105","0.5539"]["101.99","138.01"]["BATO","C2OX","EDGO"]100.0000140.00006060falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:38:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b0ac-0c33-7171-ab9d-f39fd21b6651CCJ2026-09-17 14:40put_ladder8119664619980.00unknown92.640014.2500["101","104","105","106","107","110","115","120"]["1.8834","2.3692","2.1575","2.7584","2.8750","3.1280","3.7237","4.1950"][]["XBOX"]101.0000120.000011truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:41:00Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b00c-6133-7311-8141-0d87837fd522CCJ2026-09-17 11:46call_calendar2160508200.00unknown92.44503.9500["50"]["4.2403"][]["XPHO"]50.000050.0000164falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:46:47Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aac5-f243-7983-b87e-88e70f86096fCCJ2026-09-16 11:11call_diagonal_spread2110105400.00shortask92.65004.7500["45","50"]["0.5945","0.5083"][]["ARCO"]45.000050.0000492856falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:11:41Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaac-8e42-7732-bfdd-4b7896a768c0CCJ2026-09-16 10:43other4160147660.00unknown91.98001.7000["95","100"]["0.5297","0.5699"][]["XCBO"]95.0000100.000029falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:44:27Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a5f0-b6f6-7bc1-8cfc-ef8f986fca5aCCJ2026-09-15 12:40call_vertical_spread2130109950.00unknown91.71501.8000["90","125"]["0.5100","0.5030"][]["XMIO"]90.0000125.0000493493falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:40:52Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a589-fa2e-7ea2-aeda-ba7c65dcf149CCJ2026-09-15 10:47call_calendar2238244359.00unknown91.82002.0250["80"]["0.5189"][]["ARCO","XPHO"]80.000080.0000493857falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:48:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a08c95-c040-7661-b82b-67b4ab245587CCJ2026-09-10 14:30time_butterfly3173259580.00unknown97.73006.1500["107","108","140"]["1.5408","1.5013","1.4234"][]["XBOX"]107.0000140.000018truefalsetruetruefalsemlftmarket_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
01a08c12-3478-7561-aeca-4be4188b6f56CCJ2026-09-10 12:06call_vertical_spread2120107880.00shortbid98.34713.1000["85","105"]["0.5257","0.5134"]["93.80"]["ARCO"]85.0000105.0000498498falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:06:52Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bbd-9c38-7331-a390-00e63bbc4570CCJ2026-09-10 10:34call_vertical_spread21100104200.00unknown99.05001.3400["90","105"]["0.5086","0.5035"][]["XISX"]90.0000105.000088falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:34:32Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08259-3cb1-70a3-804a-0aa823f7c962CCJ2026-09-08 14:47call_vertical_spread25116109148.00longask103.54000.5400["115","140"]["0.5046","0.5146"]["119.75"]["MCRY","XBOX","XCBO","XISX"]115.0000140.0000101101falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:48:00Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0824d-8898-7fc0-9f92-3b9fb2c86f38CCJ2026-09-08 14:35call_vertical_spread25139131877.00shortbid103.58000.5600["115","140"]["0.5057","0.5169"]["119.75"]["BATO","SPHR","XCBO","XMIO","XPHO"]115.0000140.0000101101falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:35:30Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0821c-dba8-7bc2-ac9e-6d04c7114a39CCJ2026-09-08 13:42straddle21500712500.00shortbid103.60500.5000["110"]["0.4897"]["95.75","124.25"]["AMXO"]110.0000110.00003838falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:42:21Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06e00-21d6-7470-bc96-704f194c8224CCJ2026-09-04 15:58call_calendar2161612439756.00shortask100.80500.2700["110"]["0.4527"][]["SPHR"]110.0000110.00001442falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:58:25Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d7d-93f5-7ed2-b9d4-0928fb93a64bCCJ2026-09-04 13:35other22159174955.00unknown100.46000.8802["94","97"]["2.6156","0.4091"][]["C2OX","EDGO"]94.000097.000007falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:36:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d7d-900d-7250-9f36-80051fc34d57CCJ2026-09-04 13:35other24249254476.00unknown100.43001.5323["94","97"]["3.7860","0.3165"][]["C2OX","SPHR","XBOX","XCBO"]94.000097.000007falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:36:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d48-dbdd-7202-9aaf-30523696864aCCJ2026-09-04 12:38other211000387000.00unknown100.83000.3000["110"]["0.4513"][]["XPHO"]110.0000110.00001442falsetruetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:38:21Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d47-f94d-72c0-a286-9eeda22b2347CCJ2026-09-04 12:37other212000774000.00unknown100.79000.3100["110"]["0.4525"][]["XPHO"]110.0000110.00001442falsetruetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:37:38Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d40-aa35-70d2-a3a8-44b9e1d61690CCJ2026-09-04 12:29call_calendar26574220633.00shortask100.66000.2888["110"]["0.4504"][]["ARCO","C2OX","EDGO","XCBO","XPHO"]110.0000110.00001442falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:29:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-a075-7f70-9495-0f5f1ad00f13CCJ2026-09-04 12:13other45267105478.00unknown100.77002.2935["105","110"]["1.5250","0.4541"][]["BATO","C2OX","EDGO","MCRY","XBOX"]105.0000110.0000042falsefalsetruetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d28-6b2d-76c1-a308-87de943b5844CCJ2026-09-04 12:02call_calendar24330123970.00shortask100.64000.3400["110"]["0.4459"][]["AMXO","EMLD","XBOX","XMIO"]110.0000110.00001442falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:03:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53