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:net_side = bid×strategy = box_spread×
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
01a0c583-5cde-7182-9181-013d8920c3b1SPX2026-09-21 15:48box_spread412268716.00shortbid7772.92004.8000["7000","8000"]["0.2011","0.1287"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:48:54Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57f-3276-7192-8fa9-8391251fb96fQQQ2026-09-21 15:44box_spread419125964.00shortbid742.57000.3100["675","775"]["0.2446","0.1864"][]["XMIO"]675.0000775.00007070falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:44:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57f-26bf-74c0-8132-f7acd56d7794QQQ2026-09-21 15:43box_spread4214195916.00shortbid742.55000.4879["675","775"]["0.2446","0.1864"][]["EMLD","XMIO"]675.0000775.00007070falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:44:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57e-e06f-7302-867b-4eb1596b721fSPX2026-09-21 15:43box_spread4171734544.00shortbid7774.59007.5000["7000","8000"]["0.2033","0.1647"][]["XCBO"]7000.00008000.0000361361falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:43:40Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57d-bb76-7b70-af3d-90fda09e4f31SPX2026-09-21 15:42box_spread412578238.00shortbid7774.46006.5000["6000","7275"]["0.2593","0.1818"][]["XCBO"]6000.00007275.0000179179falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:42:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57d-84c7-72b0-b50b-88bb9c07c225SPX2026-09-21 15:42box_spread41231440.00shortbid7774.53000.9000["7725","7790"]["0.1172","0.1065"]["0","7725","7790"]["XCBO"]7725.00007790.000044falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:42:22Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c576-4d1f-7fe1-80ef-d7609296d1a3SPX2026-09-21 15:34box_spread41202052800.00shortbid7774.91004.5000["7250","8250"]["0.1872","0.1184"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:34:20Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c575-1886-7eb0-872a-b772c93bb008SPX2026-09-21 15:32box_spread412206654.00shortbid7773.19002.5000["7550","8140"]["0.1565","0.1258"][]["XCBO"]7550.00008140.0000101101falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:33:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56e-dade-7f52-8747-e58c3800dbb3SPX2026-09-21 15:26box_spread414420180.00shortbid7770.70004.4000["7000","8000"]["0.2281","0.1064"][]["XCBO"]7000.00008000.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:26:39Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56e-b7b7-7bd3-985f-060c681d0168SPX2026-09-21 15:26box_spread412210090.00shortbid7770.61004.7000["7000","8000"]["0.2273","0.1066"][]["XCBO"]7000.00008000.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:26:03Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56e-6997-7d00-aefd-55f59b344238SPX2026-09-21 15:25box_spread41202054400.00shortbid7771.10004.8000["7250","8250"]["0.1876","0.1195"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:26:03Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56d-bdb6-7890-8fd1-b9819fe5fb22SPX2026-09-21 15:24box_spread41808218400.00shortbid7771.25005.8000["7250","8250"]["0.1881","0.1191"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:25:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c567-7456-7962-a0c2-f74e68a4f9caSPX2026-09-21 15:18box_spread41102577980.00shortbid7774.240011.7000["7400","8900"]["0.1893","0.1493"][]["XCBO"]7400.00008900.0000452452falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:18:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c558-e1df-7332-abf6-5c0724503420XSP2026-09-21 15:02box_spread413378427.80shortbid777.25002.8700["700","800"]["0.2030","0.1624"][]["XCBO"]700.0000800.0000333333falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:02:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c557-20a7-7b03-b77a-bb3d4f397d2dSPX2026-09-21 15:00box_spread41202054600.00shortbid7773.74004.5000["7250","8250"]["0.1895","0.1173"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:00:20Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c549-12ff-7a30-936b-a2aca723e37dSPX2026-09-21 14:44box_spread41101027400.00shortbid7770.77004.5000["7250","8250"]["0.1892","0.1175"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:45:02Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c544-c187-7583-8a03-34792f919dd7SPX2026-09-21 14:40box_spread4161667514.00shortbid7769.45005.6000["6000","7000"]["0.2813","0.2022"][]["XCBO"]6000.00007000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:40:40Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53d-cc47-78f2-a46a-3614599c806fSPX2026-09-21 14:32box_spread4191207800.00shortbid7767.20004.3000["7000","8000"]["0.2020","0.1288"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:32:39Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53d-2067-7502-a7ec-2fe310b86fe4QQQ2026-09-21 14:31box_spread411685840.00shortbid740.37000.2600["742","746"]["0.1740","0.1716"][]["XCBO"]742.0000746.00002525falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:32:11Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53c-e1e6-7702-a235-782a18162fa6SPX2026-09-21 14:31box_spread41112431132.00shortbid7768.08005.1000["7700","7800"]["0.1753","0.1717"][]["XCBO"]7700.00007800.0000374374truefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:31:39Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53b-d45f-7033-8476-2e469105d34dSPX2026-09-21 14:30box_spread41101027700.00shortbid7768.76004.4000["7250","8250"]["0.1885","0.1190"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:30:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c52a-2cd7-7b50-a480-3f638fcb302aSPX2026-09-21 14:11box_spread413676941.00shortbid7761.57004.3000["6000","8000"]["0.2803","0.1284"][]["XCBO"]6000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:11:29Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c527-3ed6-7f92-a12d-b7044cd712f9SPX2026-09-21 14:07box_spread412209810.00shortbid7762.90004.6000["7000","8000"]["0.2290","0.1069"][]["XCBO"]7000.00008000.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:08:20Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51d-386f-77f2-b88a-675bb8e9bafeSPX2026-09-21 13:56box_spread412204538.00shortbid7758.24007.1000["7500","8000"]["0.1594","0.1296"][]["XCBO"]7500.00008000.0000101101falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:57:23Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c50c-dcef-7062-82d1-c75b7c65ed85SPX2026-09-21 13:39box_spread415207375.00shortbid7754.170027.0000["7500","7600"]["0.2861","0.1515"][]["XCBO"]7500.00007600.000022falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:39:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c504-516e-7753-9228-294ba8108063SPX2026-09-21 13:29box_spread411584300.00shortbid7758.06000.5800["7720","7745"]["0.1743","0.1253"]["0","7720","7745"]["XCBO"]7720.00007745.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:30:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f2-d4df-7620-8d38-6df6bb7591a7SPX2026-09-21 13:10box_spread4194175055.00shortbid7754.960013.6000["5000","6000"]["0.4159","0.2784"][]["XCBO"]5000.00006000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:11:09Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ec-6857-7912-96e7-5ec697fa37e0SPX2026-09-21 13:03box_spread41352260.00shortbid7753.47000.7000["7725","7750"]["0.1004","0.0977"]["0","7725","7750"]["XCBO"]7725.00007750.000077falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:03:49Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4db-beb6-7353-b3c6-9a87ffe92815SPX2026-09-21 12:45box_spread4110110238471.00shortbid7752.04004.7000["7725","7775"]["0.1458","0.1427"][]["XCBO"]7725.00007775.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:45:32Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4d9-9fbf-7510-98c5-efc8093aecd6SPX2026-09-21 12:43box_spread413548175.00shortbid7751.65005.7000["7000","8775"]["0.2048","0.1457"][]["XCBO"]7000.00008775.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:43:14Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4d4-9a96-7821-abe2-0ccbbb532cbcSPX2026-09-21 12:37box_spread413891201.00shortbid7754.03008.0000["6750","7000"]["0.2121","0.2019"][]["XCBO"]6750.00007000.0000333333falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:37:54Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ce-68a7-7562-85d4-7493d2c36e3aSPX2026-09-21 12:30box_spread412240460.00shortbid7750.85004.5000["7000","8000"]["0.2048","0.1227"][]["XCBO"]7000.00008000.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:31:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4c5-15ee-79f3-8a7e-6985f923fee9SPX2026-09-21 12:20box_spread41418149078.00shortbid7746.65005.8000["7000","8000"]["0.1983","0.1512"][]["XCBO"]7000.00008000.0000242242falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:20:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4bf-1e96-7361-8a07-81b1261025f9SPX2026-09-21 12:14box_spread41112466904.00shortbid7745.03004.3000["6000","8000"]["0.2765","0.1281"][]["XCBO"]6000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:14:13Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4b3-08d7-72d0-b1e4-031e624c9a0aSPX2026-09-21 12:00box_spread41153133245.00shortbid7736.43008.2000["8000","9000"]["0.1606","0.1375"][]["XCBO"]8000.00009000.0000333333falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:01:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4af-28a6-7d40-ae49-c259ef7acbebSPX2026-09-21 11:56box_spread416791592.00shortbid7738.17003.7000["7000","8000"]["0.1991","0.1277"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_whaleuw_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
01a0c4aa-13df-7611-bcf3-7cff942c9f4aSPX2026-09-21 11:51box_spread412205758.00shortbid7739.94004.0000["7700","7725"]["0.1467","0.1451"][]["XCBO"]7700.00007725.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:51:42Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a8-ac7e-7e73-9178-964b02151482SPX2026-09-21 11:49box_spread4141089392.00shortbid7740.21005.9000["6000","7000"]["0.2778","0.1995"][]["XCBO"]6000.00007000.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:49:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a6-b0af-71c3-9f84-a7363796f4daSPX2026-09-21 11:47box_spread413294582.00shortbid7740.48004.0000["7440","7960"]["0.1625","0.1293"][]["XCBO"]7440.00007960.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:47:45Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a4-a926-7333-8ee3-e903376e3b56SPX2026-09-21 11:45box_spread416872004.00shortbid7738.50004.9000["7400","7900"]["0.1722","0.1456"][]["XCBO"]7400.00007900.0000179179falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:45:28Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c49b-fa7f-7c40-aa66-eefef3c2b2d5SPX2026-09-21 11:35box_spread413599742.00shortbid7729.01006.7000["7400","7500"]["0.1796","0.1750"][]["XCBO"]7400.00007500.0000269269falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:35:55Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c48f-7f2e-7323-9d44-0194dea64284SPX2026-09-21 11:22box_spread415168820.00shortbid7730.76001.8000["7680","7780"]["0.1152","0.1061"][]["XCBO"]7680.00007780.00002121falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:22:19Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c48b-4cf7-78f3-a0ed-f6d301575441SPX2026-09-21 11:17box_spread4117570418.00shortbid7729.34001.8000["7680","7780"]["0.1145","0.1055"][]["XCBO"]7680.00007780.00002121falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:17:58Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c482-05f6-7830-ae41-1a374211628fSPX2026-09-21 11:07box_spread4110926090.00shortbid7725.07004.1000["7500","7900"]["0.1560","0.1298"][]["XCBO"]7500.00007900.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:30Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c481-562e-7692-8915-328dadb40074SPX2026-09-21 11:06box_spread414531968.00shortbid7725.010012.3000["7200","8200"]["0.1816","0.1235"][]["XCBO"]7200.00008200.0000116116falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47d-b097-7330-b45a-b1ea2ca7f9e1SPX2026-09-21 11:02box_spread41101210150.00shortbid7722.31004.2000["7600","7800"]["0.1555","0.1441"][]["XCBO"]7600.00007800.0000151151falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:03:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c475-7b07-7640-a4b3-2e3791e7fd9cSPX2026-09-21 10:53box_spread413426666.00shortbid7719.81007.7000["7000","8000"]["0.1971","0.1291"][]["XCBO"]7000.00008000.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:54:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c474-4e3f-7401-b501-a020b8109f17SPX2026-09-21 10:52box_spread41123400776.00shortbid7719.44006.6000["6000","8000"]["0.2437","0.1526"][]["XCBO"]6000.00008000.0000269269falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:52:34Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46d-1e67-7353-ae61-a23e1100ac9aSPY2026-09-21 10:44box_spread417375739.00shortbid768.92507.7800["500","510"]["0.4751","0.4613"][]["EMLD"]500.0000510.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:52Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c46d-1697-7632-bcaf-3ed2e73651d1SPY2026-09-21 10:44box_spread413161031.00shortbid768.92007.7800["500","510"]["0.4753","0.4615"][]["EMLD"]500.0000510.00006060falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:44:52Z"}2026-09-212026-09-21 17:152026-09-21 17:15