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 = EXPE×
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
01a0c435-419f-7b82-a8cc-058e3f26d9b0EXPE2026-09-21 09:43call_vertical_spread2150301400.00shortbid281.22504.4000["280","290"]["0.4784","0.4750"]["284.62"]["XCBO"]280.0000290.0000116116falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:43:41Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b597-7de7-74b0-bfd9-ce2ad88a63b8EXPE2026-09-18 13:36put_diagonal_spread2140132280.00shortask278.51004.9000["292.5","295"]["0.4583","2.5577"][]["XCBO"]292.5000295.000007falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:36:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b578-2677-7e03-9254-0bdf9321ee04EXPE2026-09-18 13:02call_diagonal_spread214001560000.00unknownask278.18003.6000["310","360"]["0.4883","0.4714"][]["ARCO"]310.0000360.000091272falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:02:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b516-3c0f-7f70-9828-1a7d699b1012EXPE2026-09-18 11:15put_butterfly_spread3470216520.00longask279.28006.5000["200","230","260"]["0.5177","0.4993","0.4899"]["203.96","256.04"]["AMXO","XBOX","XMIO","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:15:51Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b516-3827-7e00-aaa6-4b8061f66bf8EXPE2026-09-18 11:15put_butterfly_spread3242130435.00unknownask279.28006.5000["200","230","260"]["0.5111","0.5004","0.4953"]["224.06"]["XBOX","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:15:51Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50c-9b37-7570-82df-415cef3ab966EXPE2026-09-18 11:04put_butterfly_spread3444133592.00shortbid281.74505.7000["200","230","260"]["0.5289","0.5037","0.4906"]["203.89","256.11"]["AMXO","XCBO","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:05:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50c-8f7f-7f80-b1c3-1c7b7719a07eEXPE2026-09-18 11:04put_butterfly_spread3246139704.00shortbid281.74505.7000["200","230","260"]["0.5158","0.5039","0.4979"]["203.88","256.12"]["AMXO","XBOX"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:05:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50c-8f7f-7f80-b1c3-1c5750d08e40EXPE2026-09-18 11:04put_butterfly_spread3372218160.00shortbid281.74505.7000["200","230","260"]["0.5271","0.5032","0.4907"]["203.88","256.12"]["AMXO","XMIO","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:05:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50c-8b98-7572-8b6d-cde40540f535EXPE2026-09-18 11:04put_butterfly_spread3252157808.00unknownbid281.74505.7000["200","230","260"]["0.5178","0.5037","0.4964"]["194.81"]["XBOX","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:05:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50c-7428-77c0-94a6-e14d51109f84EXPE2026-09-18 11:04put_butterfly_spread3266199569.00unknownbid281.74505.7000["200","230","260"]["0.5137","0.5029","0.4969"]["219.84"]["XBOX","XPHO"]200.0000260.0000182182falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:04:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4eb-b93f-7380-905d-cc274c21f7cfEXPE2026-09-18 10:29other31100523000.00unknown—281.37507.1000["220","260","360"]["0.5035","0.5066","0.4640"][]["XBOX"]220.0000360.0000182182truetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:29:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0b0-175b-7d10-88bd-68be6251acc6EXPE2026-09-17 14:45put_ladder618986321908.00unknown—283.740020.2000["305","307.5","310","312.5","315","317.5"]["1.2968","1.5864","1.6865","1.3823","1.7621","1.9720"][]["XBOX"]305.0000317.500011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:45:42Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a6-18c4-7193-8722-ce9edbe2c8ecEXPE2026-09-17 14:34other4120118180.00unknown—283.550013.0000["280","290","295","300"]["0.4332","0.4293","0.2586","0.5150"][]["XCBO"]280.0000300.0000136falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:34:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a0-4c63-7dd0-887f-292fb645f172EXPE2026-09-17 14:28put_ladder5115408463080.00unknown—283.320018.0000["310","312.5","315","317.5","330"]["1.6171","1.6519","1.6443","1.8632","2.3540"][]["XBOX"]310.0000330.000011truefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:28:37Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aafb-b013-7dd3-9774-10b8142b961bEXPE2026-09-16 12:10other4120119980.00unknown—290.72006.4000["280","290","295","300"]["0.5226","0.5090","0.5490","0.4931"][]["XPHO"]280.0000300.0000265falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:11:11Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaec-621b-7ff0-9a9a-44139229d5aeEXPE2026-09-16 11:53other4120154760.00unknown—290.78006.8000["290","295","300"]["0.5211","0.4607","0.4887"][]["XCBO"]290.0000300.0000965falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:54:05Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a60d-66b6-7390-bc68-12974ed5479cEXPE2026-09-15 13:11call_frontspread2217118294141.00longbid292.86007.1000["250","280"]["1.3592","0.5448"]["291.66"]["XCBO"]250.0000280.000033falsefalsefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:12:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a605-11e6-7d61-9db3-b16901b176a9EXPE2026-09-15 13:02call_vertical_spread2189510860.00unknown—292.64007.3000["250","280"]["0.9040","0.5872"][]["XISX"]250.0000280.000033falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:02:57Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a603-7ba6-75d1-98bc-03043ab81912EXPE2026-09-15 13:00call_vertical_spread21100568100.00shortbid292.82504.6000["250","280"]["1.2408","0.5222"]["278.51"]["XISX"]250.0000280.000033falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:01:18Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a602-b46e-7200-b466-9a76e4985cd8EXPE2026-09-15 12:59call_vertical_spread21100568100.00shortbid292.97504.6000["250","280"]["1.2008","0.5026"]["278.51"]["XISX"]250.0000280.000033falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:00:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a08bbd-1b51-72e2-88da-0d5040224668EXPE2026-09-10 10:33put_diagonal_spread2145172350.00longbid278.15005.8000["295","297.5"]["0.4624","0.7570"][]["XISX"]295.0000297.500018falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:34:00Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b96-45e8-77e3-888c-b64aa52aa656EXPE2026-09-10 09:51put_calendar2145281205.00shortask275.29506.0000["305"]["0.8710"][]["XMIO"]305.0000305.0000122falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:51:24Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0874a-86c0-79a3-881c-fa5fb66b51ceEXPE2026-09-09 13:50other2131176142.00unknown—272.62005.0000["240","270"]["0.5053","0.4930"][]["MCRY"]240.0000270.0000100373falsetruetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:50:02Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0867d-6ed8-7b51-abed-728df6def0e8EXPE2026-09-09 10:06other2722126162.00unknown—266.70003.9000["220","270"]["0.5346","0.4586"][]["C2OX","EDGO","XBOX","XMIO"]220.0000270.00003737falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:06:04Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08294-bf11-7350-8189-020c2d6b8010EXPE2026-09-08 15:52other2135178710.00unknown—275.69006.0000["285","315"]["0.4526","0.4626"][]["AMXO"]285.0000315.00001010falsefalsefalsetruefalsemlatmarket_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
01a0828e-4ea0-7f02-80fc-f01791a28acdEXPE2026-09-08 15:45put_vertical_spread228101856.00longask274.73005.4000["337.5","340"]["0.3244","0.8256"]["337.52"]["C2OX"]337.5000340.00001010falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:46:02Z"}2026-09-082026-09-08 21:502026-09-08 21:50