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.

403,968 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 = PFE×sorted by executed_at ↑×
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
01a06da7-1cc5-7d51-a680-395831809e83PFE2026-09-04 14:21straddle21250127500.00shortbid28.49500.1800["27"]["0.2451"]["21.90","32.10"]["SPHR"]27.000027.0000286286falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:21:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dc3-6add-73c2-86fe-ae83b15234f2PFE2026-09-04 14:51other213000102000.00unknown—28.51500.0500["28.5"]["0.2125"][]["XCBO"]28.500028.500007falsefalsetruefalsefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:52:02Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a081ac-2819-7a23-94cb-572eb92af0c5PFE2026-09-08 11:38put_vertical_spread211000154000.00unknown—27.90500.0300["25","27"]["0.2858","0.2795"][]["XCBO"]25.000027.0000101101falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:38:56Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08262-4d00-72e1-8e60-c8a1d6e8ffc4PFE2026-09-08 14:57other219499759920.00unknown—27.83000.0300["28","29"]["0.2371","0.2344"][]["XBOX"]28.000029.00001038falsetruetruetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:58:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0865f-d4b9-7660-b96d-85f1bc24fa4fPFE2026-09-09 09:33call_calendar22240160560.00longask27.64000.5500["25"]["0.2339"][]["XISX"]25.000025.000072191falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:33:40Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0a0e8-d870-7d21-a89e-14f49ea89cf7PFE2026-09-14 13:13other21100161300.00unknown—27.75501.8500["20"]["1.0540"][]["ARCO"]20.000020.0000467falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:13:38Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a145-aa28-7353-97f7-a0ccf9deff98PFE2026-09-14 14:54call_calendar211299171092.00shortbid27.74140.4002["25"]["0.4728"][]["AMXO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"]25.000025.0000432falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:55:03Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a14b-18c8-7f51-9f71-cdeaaa0febf7PFE2026-09-14 15:00other311800390600.00unknown—27.74500.4100["27"]["0.2547"][]["SPHR"]27.000027.00004494falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:01:06Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a5bf-f296-7dc1-a15b-5cd1fa0338daPFE2026-09-15 11:46call_diagonal_spread214420221006.00shortbid27.50500.1500["30","37"]["0.4731","0.2274"][]["XCBO"]30.000037.00003367falsetruetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:47:29Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5e6-a0ee-7743-ad4b-0ddcd816f587PFE2026-09-15 12:29call_diagonal_spread23583147499.00unknown—27.52000.0800["26","29"]["0.4256","0.2235"][]["EDGO","XCBO","XPHO"]26.000029.00003122falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:29:51Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a630-4865-7461-8bc5-9971f5864152PFE2026-09-15 13:49call_diagonal_spread211000265999.00shortask27.48500.1000["26","28"]["0.4331","0.2211"][]["XCBO"]26.000028.0000394falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:50:10Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0b0b3-5f33-7e23-a696-83f38f9698d3PFE2026-09-17 14:48other51728171648.00unknown—27.68501.3700["28.5","29","29.5","30"]["0.3795","0.7998","0.6656","1.3749"][]["XBOX"]28.500030.000018falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:49:10Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b571-545f-7f11-bf9a-429a4e91333fPFE2026-09-18 12:54put_vertical_spread21717116154.00longask27.52500.0300["25","27"]["0.2809","0.2816"]["26.32"]["XISX"]25.000027.00009191falsetruefalsetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0c458-ea87-77c2-80c6-488b3b2077d8PFE2026-09-21 10:22put_ratio_spread2160114150.00longbid27.67020.7100["30","45"]["0.3276","0.7625"]["28.01"]["SPHR"]30.000045.00008888falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:22:44Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46c-207f-7ad0-83a0-2ca81cf4e703PFE2026-09-21 10:43call_diagonal_spread21415481815.00longbid27.62170.5580["22","25"]["0.2406","0.0800"][]["XPHO"]22.000025.0000487851falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:43:41Z"}2026-09-212026-09-21 17:152026-09-21 17:15