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:strategy = box_spread×ticker = SPY×
idtexttickertextexecuted_attimestamp 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
01a0b5e7-d837-7ac0-b93f-ba0fd2cd5e51SPY2026-09-18 15:04box_spread41327429.00shortbid761.34500.7200["735","795"]["0.1617","0.1240"][]["EMLD"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e7-d837-7ac0-b93f-b9f5349c0c7cSPY2026-09-18 15:04box_spread43763975.00shortbid761.34500.7200["735","795"]["0.1618","0.1237"][]["ARCO","EMLD","XMIO"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:04:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e6-651f-7711-8c6c-14092417d4f4SPY2026-09-18 15:02box_spread42982317.00shortbid761.18000.4133["735","795"]["0.1620","0.1238"][]["ARCO","EMLD"]735.0000795.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:02:57Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bd-ab57-7e43-8f1b-296b8302c1daSPY2026-09-18 14:18box_spread415107920.00shortbid759.94500.7900["755","775"]["0.1809","0.1741"][]["XMIO"]755.0000775.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:18:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ba-1d2f-79b0-be3e-ffbace5f7dedSPY2026-09-18 14:14box_spread415107910.00shortbid759.87000.7900["755","775"]["0.1809","0.1741"][]["XMIO"]755.0000775.0000364364falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:14:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b080-be43-7e73-8e5a-e5ea95ea4827SPY2026-09-17 13:53box_spread41364860.00shortbid762.30503.6400["755","775"]["0.1748","0.1676"][]["XMIO"]755.0000775.0000365365falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:54:04Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afe4-b8db-7000-9519-7678248feae9SPY2026-09-17 11:03box_spread42453472.00shortbid760.80001.9300["705","790"]["0.1850","0.1354"][]["EMLD","XMIO"]705.0000790.0000120120falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:03:22Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afe4-b8db-7000-9519-76696aa807f1SPY2026-09-17 11:03box_spread42566840.00shortbid760.80001.9300["705","790"]["0.1850","0.1354"][]["EMLD","XMIO"]705.0000790.0000120120falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:03:22Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afdc-6bdb-7543-b35a-8b13acdcc888SPY2026-09-17 10:54box_spread41343422.00shortbid760.69003.4500["720","800"]["0.1780","0.1439"][]["ARCO"]720.0000800.0000162162falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:54:34Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd1-b993-7c40-b2c8-a1e832251597SPY2026-09-17 10:42box_spread41578295.00longask762.21002.1500["700","792"]["0.1896","0.1443"][]["EMLD"]700.0000792.0000162162falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:42:50Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afd1-a60b-7113-b2b8-2ec2e27ee756SPY2026-09-17 10:42box_spread42462656.00longask762.15001.9700["700","792"]["0.1903","0.1440"][]["ARCO","EMLD"]700.0000792.0000162162falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:42:26Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb9-14fc-74b0-8c1a-0875c30a7267SPY2026-09-17 10:15box_spread41462376.00longask761.12002.5600["700","792"]["0.1890","0.1444"][]["EMLD"]700.0000792.0000162162falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:15:36Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afb9-055b-7841-9353-5fb62859d7c5SPY2026-09-17 10:15box_spread42577980.00longask761.18002.6800["700","792"]["0.1888","0.1445"][]["EMLD","XMIO"]700.0000792.0000162162falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:15:36Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0af9b-5f83-75b3-877b-5233523e1c47SPY2026-09-17 09:43box_spread418171632.00unknown760.99502.7600["755","775"]["0.1735","0.1670"][]["XISX"]755.0000775.0000365365falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T13:43:08Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab06-bc33-72d3-a953-b7dd8e486467SPY2026-09-16 12:22box_spread4110215160.00unknown760.02003.4800["755","775"]["0.1788","0.1731"][]["XCBO"]755.0000775.0000366366falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:22:44Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaee-d703-7290-9e02-af226eee3fc4SPY2026-09-16 11:56box_spread4110215620.00shortbid760.81001.0200["755","775"]["0.1789","0.1731"][]["XPHO"]755.0000775.0000366366falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:56:33Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa82-49f3-7463-9cb3-390308c43a3eSPY2026-09-16 09:57box_spread4110215040.00unknown760.23002.2000["755","775"]["0.1786","0.1729"][]["XISX"]755.0000775.0000366366falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:57:46Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa7e-98a3-75d0-b230-3abf6a56476fSPY2026-09-16 09:53box_spread41243004.00unknown760.08008.1500["755","775"]["0.1780","0.1736"][]["XISX"]755.0000775.0000366366falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:53:45Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a691-198e-7712-ba20-4a21b431c079SPY2026-09-15 15:35box_spread4130641940.00shortbid756.92000.9700["755","775"]["0.1789","0.1731"][]["XISX"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:35:42Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a683-9886-7403-b427-4d01994d7059SPY2026-09-15 15:20box_spread4230642084.00shortbid757.19001.3700["755","775"]["0.1789","0.1729"][]["XMIO"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:20:52Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a680-a2b6-7561-82ec-33cdbf58d5d6SPY2026-09-15 15:17box_spread4316341648.00unknown757.12000.9300["755","775"]["0.1782","0.1728"][]["AMXO"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:17:45Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a676-3aa6-7e93-b7e9-3ee5d51bd583SPY2026-09-15 15:05box_spread4110214200.00shortbid757.33000.9700["755","775"]["0.1789","0.1731"][]["XISX"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:06:34Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f9-4275-7ad1-9b79-3fd94a08365fSPY2026-09-15 12:49box_spread4110214720.00shortbid757.37001.0300["755","775"]["0.1793","0.1736"][]["XISX"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:49:47Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f5-e32e-7661-b767-1fe2de5a8b70SPY2026-09-15 12:45box_spread4110214840.00shortbid757.70001.0000["755","775"]["0.1794","0.1734"][]["XMIO"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:46:29Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f5-568e-7501-9fa6-8e03d0b91430SPY2026-09-15 12:45box_spread4210214800.00unknown757.65501.1500["755","775"]["0.1792","0.1736"][]["XISX"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:45:42Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5e9-8b06-7d91-9af7-df317787d367SPY2026-09-15 12:32box_spread417150472.00shortbid757.64001.0500["755","775"]["0.1794","0.1737"][]["XISX"]755.0000775.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:32:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5a6-86c6-7093-a7ed-3194377660a9SPY2026-09-15 11:19box_spread42459166.00longask757.32002.4900["715","769"]["0.1828","0.1526"][]["ARCO","EMLD"]715.0000769.0000164164falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:19:09Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a593-ae8e-78f3-89e3-a35be5b7c7dcSPY2026-09-15 10:58box_spread42458900.00longask756.64002.5100["715","769"]["0.1823","0.1524"][]["EMLD","XMIO"]715.0000769.0000164164falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:59:00Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a572-47c6-7662-b6bd-aac527484096SPY2026-09-15 10:22box_spread419212922.00unknown757.62503.0100["700","800"]["0.1976","0.1679"][]["XISX"]700.0000800.0000367367falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:22:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a55c-1bfe-75b3-93f0-c47d531b93ddSPY2026-09-15 09:57box_spread41328662.00longask759.50002.1200["735","795"]["0.1657","0.1320"][]["EMLD"]735.0000795.00007676falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:57:53Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a091cc-25b8-7b20-a896-772a67e76dfcSPY2026-09-11 14:47box_spread41658164.00shortbid765.24000.3100["735","795"]["0.1647","0.1297"][]["SPHR"]735.0000795.00008080falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:48:11Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091cc-25b8-7b20-a896-77124aa331a7SPY2026-09-11 14:47box_spread42987362.00shortbid765.24000.5778["735","795"]["0.1656","0.1294"][]["ARCO","EMLD"]735.0000795.00008080falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:48:11Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08cb3-1fc8-7cf2-8a00-f0c36f2613d0SPY2026-09-10 15:02box_spread411842174.00unknown757.54000.4300["765","770"]["0.1190","0.1117"][]["ARCO"]765.0000770.000055falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:02:56Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c7c-2d60-7a33-9bc0-4de65df1faa9SPY2026-09-10 14:02box_spread4110182220.00shortbid758.03500.5700["755","775"]["0.1753","0.1679"][]["AMXO"]755.0000775.0000280280falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:02:41Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c50-2bc0-7133-954f-fa7ffe70604bSPY2026-09-10 13:14box_spread419164142.00shortbid759.17000.3600["755","775"]["0.1750","0.1676"][]["XISX"]755.0000775.0000280280falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:14:37Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bfc-81c9-7852-8caf-146561fcb453SPY2026-09-10 11:42box_spread4118328464.00shortbid759.28500.2100["755","775"]["0.1751","0.1677"][]["XISX"]755.0000775.0000280280falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:43:11Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b83-3ed2-77a2-85d6-7736b0a5e2f3SPY2026-09-10 09:30box_spread4117310080.00longask758.14002.0500["755","775"]["0.1751","0.1683"][]["XISX"]755.0000775.0000280280falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:30:26Z"}2026-09-102026-09-10 17:152026-09-10 17:15