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:code = mesl×ticker = XOM×
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
01a0c4e5-7ae7-71f1-a065-4696ae2df3e4XOM2026-09-21 12:56call_vertical_spread211037450.00unknownask158.42500.9000["140","145"]["0.3093","0.2989"]["161.22"]["XISX"]140.0000145.00006060falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:56:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4e5-7317-7442-9cef-8946c26fdcb0XOM2026-09-21 12:56call_vertical_spread211235580.00unknownask158.42500.7000["145","150"]["0.3016","0.2932"]["162.32"]["XPHO"]145.0000150.00006060falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:56:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ba-c167-7610-9f9d-0fc6056213ccXOM2026-09-21 12:09put_diagonal_spread21941175.00longbid158.70512.2000["175","182.5"]["0.3228","0.7367"][]["XPHO"]175.0000182.50004179falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:09:28Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4af-20d6-7a83-a68c-c825621765b5XOM2026-09-21 11:56call_diagonal_spread213077400.00shortbid159.29001.2500["155","165"]["0.2852","0.2577"][]["C2OX"]155.0000165.000088269falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:56:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c44b-6597-7252-a620-c3dd4fd978d2XOM2026-09-21 10:07put_vertical_spread2117036210.00longask159.45000.1000["155","157.5"]["0.3497","0.3460"]["156.79"]["XISX"]155.0000157.500044falsetruefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:07:57Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b585-3a1f-74b3-abbc-28564d8732c0XOM2026-09-18 13:16call_diagonal_spread232473920.00shortbid162.52001.6500["170","175"]["0.2701","0.2456"][]["XPHO"]170.0000175.0000272455falsetruetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:16:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b585-3a1f-74b3-abbc-28413bae55c4XOM2026-09-18 13:16call_diagonal_spread2333101670.00shortbid162.52001.6212["170","175"]["0.2707","0.2453"][]["XPHO"]170.0000175.0000272455falsetruetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:16:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-97c7-7272-a439-88a80d8d8567XOM2026-09-18 12:32call_calendar21426820.00shortbid162.75001.9500["155"]["0.2162"][]["XCBO"]155.0000155.0000819854falsefalsetruefalsefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:32:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0d3-378b-7311-b417-51d634c5b24cXOM2026-09-17 15:23call_diagonal_spread21431272823.00longask162.75500.2500["170","175"]["0.2853","0.2857"][]["C2OX"]170.0000175.00002964falsetruetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:23:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0d3-27eb-7d72-a38b-92b4f0a1da79XOM2026-09-17 15:23call_diagonal_spread2110163933.00longask162.75500.2500["170","175"]["0.2853","0.2857"][]["C2OX"]170.0000175.00002964falsetruetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:23:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab21-02c3-7c52-a91a-839058f0aec7XOM2026-09-16 12:51call_calendar21538325.00unknown—164.86501.2000["130"]["0.2431"][]["C2OX"]130.0000130.000093274falsefalsetruefalsefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:51:30Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a60a-4dbe-77e3-bce5-1f659c7bcc75XOM2026-09-15 13:08ratio_risk_reversal2199206415.00unknown—169.11000.1000["160","180"]["0.3241","0.2682"][]["ARCO"]160.0000180.0000275275falsetruefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:08:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a60a-4dbe-77e3-bce5-1f457f836baaXOM2026-09-15 13:08ratio_risk_reversal232143700.00unknown—169.11000.1071["160","180"]["0.3237","0.2677"][]["XCBO"]160.0000180.0000275275falsetruefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:08:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5bc-58b6-77c2-a4d4-2f0935ae93e8XOM2026-09-15 11:42ratio_risk_reversal21300624000.00longask169.13002.3500["160","180"]["0.3214","0.2706"]["157.40"]["XCBO"]160.0000180.0000275275falsetruefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:43:20Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a13b-78c8-7820-ba08-09c1e77b9c4eXOM2026-09-14 14:43call_diagonal_spread211026900.00shortask165.00510.9000["160","170"]["0.2884","0.2810"][]["C2OX"]160.0000170.0000123186falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:44:16Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0e6-57d0-7c60-a786-6beb84517074XOM2026-09-14 13:10call_calendar212382455.00shortbid165.20003.0500["150"]["0.3263"][]["C2OX"]150.0000150.00003267falsefalsetruefalsefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T17:11:21Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a070-f8f0-70a3-8f83-ab8556f17e60XOM2026-09-14 11:02call_diagonal_spread211326130.00unknown—167.43000.8500["155","180"]["0.3124","0.2842"][]["C2OX"]155.0000180.00003295falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:02:41Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a09194-ba38-70a0-9e9b-8d8781d69594XOM2026-09-11 13:47call_diagonal_spread213167735.00shortbid165.59001.0000["170","200"]["0.2843","0.2574"][]["XMIO"]170.0000200.0000126497falsetruetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:47:21Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09194-ba38-70a0-9e9b-8d657ba2c986XOM2026-09-11 13:47call_diagonal_spread212248070.00shortbid165.59001.0000["170","200"]["0.2843","0.2574"][]["XMIO"]170.0000200.0000126497falsetruetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:47:21Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c64-d4d1-7240-a6d4-91f4fa407db7XOM2026-09-10 13:36other211076950.00unknown—165.60503.4600["130"]["0.3127"][]["XCBO"]130.0000130.000036280falsefalsetruefalsefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:37:13Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b91-9e80-7470-a0f0-edfcd8d88c8dXOM2026-09-10 09:46put_calendar213039600.00shortbid165.04002.7000["165"]["0.2999"][]["XISX"]165.0000165.00004350falsetruetruefalsefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:46:30Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08762-7f78-7ed0-a0c2-f1eb08749243XOM2026-09-09 14:16other211940907.00unknown—164.90000.5200["160","180"]["0.3136","0.3174"][]["MCRY"]160.0000180.00009128falsefalsetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:16:31Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0814c-3980-75c1-82a0-7d5b5c2aa570XOM2026-09-08 09:54call_vertical_spread219981180.00shortbid160.73000.5400["160","175"]["0.2858","0.2850"]["165"]["C2OX"]160.0000175.00003838falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:54:31Z"}2026-09-082026-09-08 21:502026-09-08 21:50