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.

312,778 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 = mlet×strategy = call_ratio_spread×ticker = SPY×
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
01a0b615-d1bf-7e31-ab79-9aa533813688SPY2026-09-18 15:54call_ratio_spread21227644.00longask761.42504.8500["670","760"]["0.2083","0.1722"]["852.80"]["XCBO"]670.0000760.0000364364falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:54:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a2-4f6f-7c90-8031-f5a9fbff68ebSPY2026-09-18 13:48call_ratio_spread212429880.00unknownask759.75000.0800["758","770"]["0.1265","0.1128"]["774.30"]["XISX"]758.0000770.00002828falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:49:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b507-6347-7f53-a17b-038c4c51ddfbSPY2026-09-18 10:59call_ratio_spread21663378.00unknown—759.78500.4300["685","760"]["0.1991","0.1441"][]["EDGO"]685.0000760.0000119119falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:59:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b505-8e87-7133-b448-05dd4ef1f066SPY2026-09-18 10:57call_ratio_spread2110105590.00unknown—759.66002.7200["685","760"]["0.2001","0.1441"][]["EMLD"]685.0000760.0000119119falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:57:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4de-d85f-7d42-829c-4b4d22a8a695SPY2026-09-18 10:14call_ratio_spread213240537840.00longask759.25000.0200["757","762"]["0.1713","0.1508"]["759.20","764.80"]["XISX"]757.0000762.000000falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:15:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4dc-404f-7350-8577-cceeae78a2f5SPY2026-09-18 10:12call_ratio_spread21231724.00longask759.89009.7200["655","760"]["0.2029","0.1707"]["868.04"]["XCBO"]655.0000760.0000455455falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:12:20Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b090-2f62-7572-85ec-a4b2f933c22eSPY2026-09-17 14:10call_ratio_spread217192512.00unknown—762.53006.0600["500","525"]["3.7321","3.9770"][]["XCBO"]500.0000525.000011falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:10:46Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b08b-ca63-7a71-9c23-c20fcf7eed60SPY2026-09-17 14:05call_ratio_spread21230811.00unknown—762.81002.6600["680","735"]["0.2124","0.1838"][]["XISX"]680.0000735.0000273273falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:05:45Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b018-b95b-7c43-83c7-6658ed26cdddSPY2026-09-17 12:00call_ratio_spread213096740.00longask762.57160.2100["750","760"]["0.1358","0.1270"]["782.50"]["XCBO"]750.0000760.00004343falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:00:18Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd7-eb83-7ae1-969e-873000eb6e4eSPY2026-09-17 10:49call_ratio_spread2187761520.00longask761.10500.0200["764","767"]["0.1184","0.1247"]["764.20","769.79"]["XCBO"]764.0000767.000011falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:49:24Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb9-e7eb-7482-af2e-d0798de45436SPY2026-09-17 10:16call_ratio_spread2113251348.00unknown—761.27000.1500["757","762"]["0.1121","0.1148"][]["XPHO"]757.0000762.000011falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:16:41Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb9-c0db-7b61-8a44-e11b57324f30SPY2026-09-17 10:16call_ratio_spread228231734.00longask761.24000.1000["757","762"]["0.1126","0.1150"]["758.70","765.30"]["C2OX","EDGO"]757.0000762.000011falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:16:21Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb8-c2f3-7330-b4de-e5f59469b4eaSPY2026-09-17 10:15call_ratio_spread2111644428.00unknown—761.21000.1700["757","762"]["0.1111","0.1146"][]["XPHO"]757.0000762.000011falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:15:14Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abb1-c173-7001-b762-fa768a53b1ebSPY2026-09-16 15:29call_ratio_spread211146868.00unknown—750.67001.8900["735","750"]["0.1625","0.1487"][]["XISX"]735.0000750.00006565falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:29:20Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aba2-9a8b-78e0-b78c-2ed3f63e8d45SPY2026-09-16 15:12call_ratio_spread211729551.00unknown—751.72000.1400["755","760"]["0.1329","0.1272"][]["EDGO"]755.0000760.00003030falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:12:39Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab37-0393-70d3-a501-71d834bdf4a5SPY2026-09-16 13:15call_ratio_spread211263486.00unknown—759.73500.3600["730","760"]["0.1646","0.1389"][]["XISX"]730.0000760.00006565falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:15:38Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aac2-40f3-73d3-91c0-7b375b32db25SPY2026-09-16 11:07call_ratio_spread2148637584.00unknown—760.48000.0200["765","775"]["0.1587","0.1514"][]["C2OX"]765.0000775.000022falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:07:50Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a69f-ee6e-7183-a1c5-f5430b6b5a5dSPY2026-09-15 15:51call_ratio_spread2110097600.00unknown—756.73000.0900["764","774"]["0.1208","0.1110"][]["XISX"]764.0000774.00002424falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:51:56Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a651-93d6-7c22-9747-25c6f631cf14SPY2026-09-15 14:25call_ratio_spread211050545.00unknown—757.51000.4000["770","810"]["0.1537","0.1384"][]["AMXO"]770.0000810.0000288288falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:26:47Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a569-4ee6-76a1-b000-1d7ae1453f3aSPY2026-09-15 10:12call_ratio_spread21226592.00longask758.18005.3900["670","760"]["0.1940","0.1628"]["0","670","850.00"]["XCBO"]670.0000760.0000367367falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:12:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a546-423e-7cf0-a87c-af9f84fe743eSPY2026-09-15 09:33call_ratio_spread212086148106.00longask758.87000.0200["759","764"]["0.1601","0.1572"]["760.10","767.90"]["XISX"]759.0000764.000000falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:34:05Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a153-d328-7872-9192-9b9a88d641c1SPY2026-09-14 15:10call_ratio_spread21227412.00longask761.86504.9400["670","760"]["0.1929","0.1637"]["852.40"]["XCBO"]670.0000760.0000368368falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:11:02Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a099-4d28-7953-9316-e00a6ed8cd78SPY2026-09-14 11:46call_ratio_spread21227514.00longask761.68006.3400["670","760"]["0.1968","0.1650"]["852.30"]["XCBO"]670.0000760.0000368368falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:46:40Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091d4-5b48-7f43-a324-32ca090a8647SPY2026-09-11 14:56call_ratio_spread21227190.00longask765.21252.8300["675","765"]["0.1930","0.1635"]["857.10"]["XCBO"]675.0000765.0000371371falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:56:58Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0918b-ffd8-77f0-a4d6-942ee02ecb1dSPY2026-09-11 13:37call_ratio_spread21227784.00longask765.93505.2400["670","765"]["0.1951","0.1639"]["671.48","858.52"]["XCBO"]670.0000765.0000371371falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:38:16Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09140-e548-7cd1-8d5b-91f135aa59ceSPY2026-09-11 12:15call_ratio_spread21227751.00longask765.55005.1100["670","765"]["0.1967","0.1643"]["671.75","858.25"]["XCBO"]670.0000765.0000371371falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:16:18Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090d6-8ea0-7771-a199-100d1892e144SPY2026-09-11 10:19call_ratio_spread211025095.00longask765.65500.1400["770","790"]["0.1371","0.1257"]["812.69"]["EDGO"]770.0000790.00009898falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:19:48Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08bb8-7001-7512-8a8e-93e7b3ecc3b9SPY2026-09-10 10:28call_ratio_spread21344168560.00longask759.06460.0400["756","761"]["0.2163","0.1973"]["756.64","765.36"]["MCRY"]756.0000761.000011falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:28:47Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb8-7001-7512-8a8e-93cc8da909e4SPY2026-09-10 10:28call_ratio_spread2310651924.00longask759.03000.0300["756","761"]["0.2177","0.1981"]["756.64","765.36"]["C2OX"]756.0000761.000011falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:28:47Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb8-7001-7512-8a8e-93b50ecf1c97SPY2026-09-10 10:28call_ratio_spread2515475440.00longask759.03000.0300["756","761"]["0.2177","0.1982"]["756.64","765.36"]["C2OX","SPHR","XPHO"]756.0000761.000011falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:28:47Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0865f-1d20-7000-b755-710b98307323SPY2026-09-09 09:32call_ratio_spread222988113544.00longask763.50000.0200["765","770"]["0.1555","0.1655"]["765.60","774.40"]["XISX"]765.0000770.000000falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T13:33:04Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a06d55-013d-7053-9f1a-f9c42aab8d92SPY2026-09-04 12:51call_ratio_spread24450900564.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.04","839.96"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9bc52835036SPY2026-09-04 12:51call_ratio_spread2270140107.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["MCRY","XPHO"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9ae75efe81aSPY2026-09-04 12:51call_ratio_spread213672090.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["XPHO"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f99ebc7b01afSPY2026-09-04 12:51call_ratio_spread213672090.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["XPHO"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9836f792dc7SPY2026-09-04 12:51call_ratio_spread23108216054.00longask771.21000.0633["790","815"]["0.1264","0.1187"]["790.05","839.95"]["MCRY","XBOX","XPHO"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-843e-7953-99a2-f4a65e3bcbfbSPY2026-09-04 12:50call_ratio_spread243468017.00longask771.22000.0700["790","815"]["0.1264","0.1187"]["790.05","839.95"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:50:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-5175-71b1-b1d5-b684f43b27f0SPY2026-09-04 12:50call_ratio_spread24100200082.00longask771.22000.0700["790","815"]["0.1264","0.1187"]["790.05","839.95"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:50:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53