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

uw_multileg403,968 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:code = mlet×endpoint = /api/option-trades/multi-leg×ticker = XLI×

idtext	tickertext	executed_at ↓timestamp with time zone	strategytext	leg_countinteger	txnsinteger	sizebigint	total_premiumnumeric

01a0caad-79cf-78c0-9f7f-3043d6605a74	XLI	2026-09-22 15:52	call_ratio_spread	2	2	172	62780.00	long	ask	170.4600	0.4900	["173","195"]	["0.1929","0.1862"]	["177.72","212.28"]	["ARCO","EDGO"]	173.0000	195.0000	87	87	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T19:52:45Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0caad-71ff-7913-ae5a-e07e939efea8	XLI	2026-09-22 15:52	call_ratio_spread	2	2	180	65880.00	long	ask	170.4650	0.6300	["173","195"]	["0.1934","0.1862"]	["177.74","212.26"]	["C2OX","EDGO"]	173.0000	195.0000	87	87	false	true
01a0caa4-138f-70e2-a391-3c4e280fdaa6	XLI	2026-09-22 15:42	call_ratio_spread	2	4	94	48595.00	long	ask	170.2800	0.6700	["170","195"]	["0.1864","0.1782"]	["176.46","213.54"]	["C2OX","EDGO","XCBO","XISX"]	170.0000	195.0000	115	115	false	false
01a0caa4-138f-70e2-a391-3c3e6239f36e	XLI	2026-09-22 15:42	call_ratio_spread	2	7	116	59845.00	long	ask	170.2800	0.6700	["170","195"]	["0.1861","0.1778"]	["176.46","213.54"]	["ARCO","EMLD","MCRY","SPHR","XBOX","XMIO","XPHO"]	170.0000	195.0000	115	115	false	false
01a0caa4-138f-70e2-a391-3c2f5a7b51a0	XLI	2026-09-22 15:42	call_ratio_spread	2	5	78	39999.00	long	ask	170.2800	0.6700	["170","195"]	["0.1852","0.1771"]	["176.45","213.55"]	["AMXO","ARCO","MCRY","XMIO","XPHO"]	170.0000	195.0000	115	115	false	false
01a0ca24-3cff-7101-a06e-e40f90132ab6	XLI	2026-09-22 13:22	call_diagonal_spread	2	1	10	25590.00	unknown	bid	169.6000	1.0000	["168","170"]	["0.2037","0.2045"]	[]	["XPHO"]	168.0000	170.0000	87	360	false	false
01a0ca24-1dbf-7b71-a30c-2c2bc2bcd9bb	XLI	2026-09-22 13:22	call_diagonal_spread	2	1	10	25520.00	long	ask	169.6000	1.1500	["168","170"]	["0.2019","0.2044"]	[]	["ARCO"]	168.0000	170.0000	87	360	false	false
01a0ca23-cf9f-7fd2-9687-9701bebe1042	XLI	2026-09-22 13:22	call_diagonal_spread	2	2	10	31800.00	long	ask	169.6500	1.2000	["160","168"]	["0.2128","0.2022"]	[]	["ARCO","XPHO"]	160.0000	168.0000	87	360	true	false
01a0ca12-5adf-7c33-80a4-78d31203aeea	XLI	2026-09-22 13:03	put_diagonal_spread	2	1	12	29484.00	short	bid	169.8650	0.3500	["173","190"]	["0.1694","0.2227"]	[]	["BATO"]	173.0000	190.0000	24	87	false	false
01a0c979-dfb6-7932-8526-388d42edf1f1	XLI	2026-09-22 10:16	other	4	5	40	32284.00	unknown	bid	169.4900	1.3600	["135","155","170","190"]	["0.2712","0.2142","0.1853","0.1784"]	["174","216.67"]	["C2OX","EDGO","EMLD","XCBO","XMIO"]	135.0000	190.0000	115	115	false	true
01a0c979-dfb6-7932-8526-3875e0db017f	XLI	2026-09-22 10:16	other	4	5	40	32374.00	unknown	bid	169.4900	1.6000	["135","155","170","190"]	["0.2680","0.2156","0.1865","0.1780"]	["174","216.67"]	["AMXO","BATO","XBOX","XISX","XPHO"]	135.0000	190.0000	115	115	false	true
01a0c96c-b49e-79d2-96eb-4d80bd19a096	XLI	2026-09-22 10:02	call_ratio_spread	2	4	54	27750.00	long	ask	169.9300	0.6600	["170","195"]	["0.1882","0.1822"]	["176.25","213.75"]	["C2OX","EDGO","XCBO","XISX"]	170.0000	195.0000	115	115	false	true
01a0c96c-b49e-79d2-96eb-4d482db92093	XLI	2026-09-22 10:02	call_ratio_spread	2	5	60	30652.00	long	ask	169.9300	0.6600	["170","195"]	["0.1875","0.1814"]	["176.25","213.75"]	["ARCO","MCRY","SPHR","XBOX","XPHO"]	170.0000	195.0000	115	115	false	true
01a0c58d-d0a6-7a30-b65b-796faa456b0e	XLI	2026-09-21 15:59	call_ratio_spread	2	1	78	28119.00	long	ask	169.9500	0.2300	["173","195"]	["0.1959","0.1892"]	["177.59","212.41"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0c58d-d0a6-7a30-b65b-795c13249b88	XLI	2026-09-21 15:59	call_ratio_spread	2	1	120	43200.00	long	ask	169.9400	0.2300	["173","195"]	["0.1960","0.1889"]	["177.60","212.40"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0c58b-f7fe-7243-82b5-f72fdb82524e	XLI	2026-09-21 15:57	call_ratio_spread	2	1	220	79090.00	long	ask	169.9900	0.6600	["173","195"]	["0.1944","0.1893"]	["177.55","212.45"]	["EDGO"]	173.0000	195.0000	88	88	false	true
01a0c431-3a5f-7cd0-90b9-5ea19f2c2a0b	XLI	2026-09-21 09:39	other	4	5	40	33396.00	unknown	bid	169.3000	1.6200	["135","155","170","190"]	["0.2723","0.2175","0.1895","0.1836"]	["173.80","217.00"]	["C2OX","EDGO","EMLD","XCBO","XMIO"]	135.0000	190.0000	116	116	false	true
01a0c431-26d7-7590-9558-59c3e949b90d	XLI	2026-09-21 09:39	other	4	5	40	33872.00	unknown	bid	169.3300	1.7100	["135","155","170","190"]	["0.2699","0.2198","0.1923","0.1844"]	["173.80","217.00"]	["AMXO","BATO","XBOX","XISX","XPHO"]	135.0000	190.0000	116	116	false	true
01a0b610-249f-77b0-8705-51362e68e9fd	XLI	2026-09-18 15:48	iron_butterfly	4	1	168	124049.00	unknown	—	169.8000	0.7000	["155","170","180"]	["0.2354","0.1758","0.1652"]	[]	["C2OX"]	155.0000	180.0000	28	28	false	false	false	true
01a0b610-1118-74a0-9044-8506798589e3	XLI	2026-09-18 15:48	iron_butterfly	4	1	82	60699.00	unknown	—	169.8000	0.9000	["155","170","180"]	["0.2354","0.1763","0.1652"]	[]	["C2OX"]	155.0000	180.0000	28	28	false	false	false	true
01a0b5f1-696f-7e43-a694-64439e3ea41b	XLI	2026-09-18 15:14	put_frontspread	2	3	69	32597.00	long	ask	169.5050	0.5300	["164","172"]	["0.2066","0.1977"]	["153.00","169.50"]	["AMXO","EDGO","XPHO"]	164.0000	172.0000	28	28	false	false
01a0b5f1-696f-7e43-a694-6439befa3b60	XLI	2026-09-18 15:14	put_frontspread	2	2	108	50562.00	long	ask	169.5050	0.5300	["164","172"]	["0.2053","0.1958"]	["152.98","169.51"]	["EDGO","XPHO"]	164.0000	172.0000	28	28	false	false
01a0b4c7-1e27-7a51-aac7-7fe568e7d624	XLI	2026-09-18 09:49	call_ratio_spread	2	2	62	28923.00	long	ask	169.1600	0.3100	["170","195"]	["0.1784","0.1757"]	["175.89","214.11"]	["EDGO","XCBO"]	170.0000	195.0000	119	119	false	true
01a0afb5-4083-7b81-bf7a-979091944c41	XLI	2026-09-17 10:11	call_diagonal_spread	2	1	10	56260.00	short	bid	169.0675	5.3000	["160","170"]	["0.2102","0.2040"]	[]	["XISX"]	160.0000	170.0000	491	855	false	false
01a0abc8-c02b-7bf2-84d3-c37973327d0b	XLI	2026-09-16 15:54	put_vertical_spread	2	3	87	62379.00	unknown	—	168.4200	0.2900	["166","170"]	["0.2098","0.2036"]	[]	["EDGO","XCBO","XISX"]	166.0000	170.0000	30	30	false	false	false	true
01a0abc8-b08b-7b70-b6a6-6faef7aa045b	XLI	2026-09-16 15:54	put_vertical_spread	2	3	181	129577.00	unknown	—	168.4100	0.2903	["166","170"]	["0.2093","0.2030"]	[]	["EDGO","XCBO","XISX"]	166.0000	170.0000	30	30	false	false	false	true
01a0abc8-b08b-7b70-b6a6-6f9bbb616422	XLI	2026-09-16 15:54	put_vertical_spread	2	2	50	35850.00	short	bid	168.4100	0.3000	["166","170"]	["0.2096","0.2033"]	["168.23"]	["MCRY","XPHO"]	166.0000	170.0000	30	30	false	false
01a0abc8-b08b-7b70-b6a6-6f89c2589b4a	XLI	2026-09-16 15:54	put_vertical_spread	2	5	124	88860.00	short	bid	168.4100	0.3000	["166","170"]	["0.2095","0.2032"]	["168.23"]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	166.0000	170.0000	30	30	false	false
01a0abc8-a0eb-7a82-bcde-598cda62fad1	XLI	2026-09-16 15:54	put_vertical_spread	2	2	39	27924.00	unknown	—	168.4300	0.3000	["166","170"]	["0.2095","0.2038"]	[]	["XCBO","XISX"]	166.0000	170.0000	30	30	false	false	false	true
01a0abc8-9d03-7ff2-8d48-3e008b4588c0	XLI	2026-09-16 15:54	put_vertical_spread	2	6	257	185114.00	unknown	—	168.4300	0.3034	["166","170"]	["0.2106","0.2050"]	[]	["ARCO","C2OX","EMLD","MCRY","XBOX","XMIO"]	166.0000	170.0000	30	30	false	false	false	true
01a0a16b-bc40-7a41-b80d-4c39008b4fdc	XLI	2026-09-14 15:36	other	2	1	300	27750.00	unknown	—	169.9750	0.1800	["167","169"]	["0.2135","0.2011"]	[]	["EDGO"]	167.0000	169.0000	4	4	false	true	false	true	false
01a091ca-2218-7631-8e03-b5f6846d962b	XLI	2026-09-11 14:45	put_vertical_spread	2	1	179	179179.00	unknown	—	172.5200	0.3100	["172.5","182.5"]	["0.1957","2.5755"]	[]	["XISX"]	172.5000	182.5000	0	0	false	false	false	true
01a091ca-2218-7631-8e03-b5e0ad7be175	XLI	2026-09-11 14:45	put_vertical_spread	2	1	71	71923.00	unknown	—	172.5200	0.3100	["172.5","182.5"]	["0.2202","2.5755"]	[]	["EDGO"]	172.5000	182.5000	0	0	false	false	false	true