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:endpoint = /api/option-trades/multi-leg×ticker = XLP×

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

01a0ca12-148f-7341-9eeb-bc0215897181	XLP	2026-09-22 13:02	put_vertical_spread	2	4	17	30685.00	long	ask	82.8600	0.6971	["85","95"]	["0.1896","0.2253"]	["88.25"]	["ARCO","EMLD","SPHR","XPHO"]	85.0000	95.0000	486	486	false	false	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T17:03:11Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0c575-149f-7c03-a6fc-864abbf5b821	XLP	2026-09-21 15:32	risk_reversal	2	1	1500	1167000.00	long	ask	82.0500	0.6200	["75","85"]	["0.1826","0.1172"]	["88.42"]	["XBOX"]	75.0000	85.0000	487	487	false	true	false
01a0c4e5-4437-7903-a036-c3dd4826c8e1	XLP	2026-09-21 12:55	other	4	1	110	52250.00	unknown	—	82.2500	0.6100	["82","83"]	["0.1648","0.1657"]	[]	["XISX"]	82.0000	83.0000	4	39	false	false	true	true	false
01a0c4e5-4437-7903-a036-c3786a582c60	XLP	2026-09-21 12:55	other	4	1	69	32775.00	unknown	—	82.2500	0.6100	["82","83"]	["0.1648","0.1657"]	[]	["XISX"]	82.0000	83.0000	4	39	false	false	true	true	false
01a0c486-2c77-7213-9bff-a0630a46b6ec	XLP	2026-09-21 11:12	other	4	1	225	74250.00	unknown	—	81.9400	0.4800	["81.5","82"]	["0.1585","0.1531"]	[]	["XISX"]	81.5000	82.0000	4	32	false	false	true	true	false
01a0c47d-4eef-7311-b1d2-9a9bd657e6e8	XLP	2026-09-21 11:02	other	4	1	250	129750.00	unknown	ask	81.9300	0.3400	["82.5","83"]	["0.1512","0.1525"]	[]	["XISX"]	82.5000	83.0000	4	25	false	false	true
01a0c437-f507-72b0-84c3-06deddf630d5	XLP	2026-09-21 09:46	put_calendar	2	2	182	120850.00	short	bid	81.7400	0.2500	["85"]	["0.1860"]	[]	["XBOX","XISX"]	85.0000	85.0000	4	32	false	false	true
01a0c437-f507-72b0-84c3-06cc94212e2e	XLP	2026-09-21 09:46	put_calendar	2	4	218	143250.00	short	bid	81.7400	0.3459	["85"]	["0.1661"]	[]	["ARCO","EMLD","SPHR","XPHO"]	85.0000	85.0000	4	32	false	false	true
01a0b5ec-ecff-7bb3-82dc-09f2ab53cfee	XLP	2026-09-18 15:09	strangle	2	2	216	33696.00	short	bid	83.0950	0.1400	["82.5","83"]	["0.1778","0.0953"]	["80.94","84.56"]	["ARCO","EDGO"]	82.5000	83.0000	14	14	false	false	false
01a0b517-3227-7bd3-9b2c-6fd1bf2fd037	XLP	2026-09-18 11:16	put_ratio_spread	2	1	18750	10075000.00	unknown	bid	83.0750	1.5700	["55","85"]	["0.2317","0.2083"]	["6.92","79.04"]	["SPHR"]	55.0000	85.0000	854	854	true	false	false
01a0b4e1-68a0-7b42-ac78-dc315281299c	XLP	2026-09-18 10:17	other	4	1	187	25619.00	unknown	bid	82.9600	0.1200	["82","82.5","83"]	["0.1952","0.2001","0.2136"]	[]	["XCBO"]	82.0000	83.0000	0	7	false	false	true
01a0b4d4-9f2f-7782-b940-b2d9db618572	XLP	2026-09-18 10:03	other	4	1	250	49500.00	unknown	bid	83.0550	0.3300	["82","82.5","83"]	["0.1727","0.2153","0.1820"]	[]	["XBOX"]	82.0000	83.0000	0	21	false	true	true
01a0b0a6-66e3-79a3-98bb-6a725971b09c	XLP	2026-09-17 14:34	put_vertical_spread	2	1	1653	717402.00	unknown	—	83.4650	0.4100	["85.5","86"]	["0.3813","0.4583"]	[]	["XBOX"]	85.5000	86.0000	1	1	false	false	false	true	false
01a0b0a6-4f73-7dc2-a5a0-d1a1ec6665c0	XLP	2026-09-17 14:34	put_ladder	3	1	3920	2295536.00	unknown	—	83.4700	0.7100	["86","86.5","87"]	["0.4636","0.5520","0.5440"]	[]	["XBOX"]	86.0000	87.0000	1	1	false	false	false	true	false
01a0b002-9562-7b60-a668-54ac8f5dde56	XLP	2026-09-17 11:35	put_vertical_spread	2	1	200	30200.00	unknown	—	83.1150	0.3500	["80","81"]	["0.1692","0.1669"]	[]	["XMIO"]	80.0000	81.0000	43	43	true	true	false	true	false
01a0abd6-54bb-7c90-9d5a-d8ba4529e1cb	XLP	2026-09-16 16:09	other	4	3	808	37174.00	unknown	—	83.3300	0.2700	["86","86.5","87","89"]	["0.1360","0.2679","0.2712","0.3908"]	[]	["AMXO"]	86.0000	89.0000	2	30	false	true	true	true	false
01a0ab26-001a-7c51-9e0b-3e15a82c9572	XLP	2026-09-16 12:56	other	4	1	130	37440.00	unknown	—	83.9550	0.3600	["83","84"]	["0.1970","0.1979"]	[]	["XISX"]	83.0000	84.0000	2	16	false	false	true	true	false
01a0a670-434e-73c2-8526-663b176a1f9e	XLP	2026-09-15 14:59	straddle	2	1	305	91501.00	short	bid	83.9550	0.2000	["84"]	["0.1536"]	["81.00","87.00"]	["EDGO"]	84.0000	84.0000	31	31	false	false	false
01a0a64d-cb16-7303-8a4e-5030bae9c06a	XLP	2026-09-15 14:21	straddle	2	1	400	58000.00	long	ask	83.9700	0.1900	["85"]	["0.1949"]	["83.55","86.45"]	["XBOX"]	85.0000	85.0000	3	3	false	false	false
01a0a185-4f20-7f10-8b13-3a65efdac213	XLP	2026-09-14 16:04	other	3	1	800	299200.00	unknown	—	84.4200	3.3500	["82","85"]	["0.1698","0.1583"]	[]	["XBOX"]	82.0000	85.0000	32	123	false	false	true	true	true
01a0a180-8878-7c70-ba18-b6ea2f44ff70	XLP	2026-09-14 15:59	other	3	1	1200	456000.00	unknown	—	84.4450	0.5600	["82","85"]	["0.1744","0.1597"]	[]	["XBOX"]	82.0000	85.0000	32	123	false	false	true	true	true
01a08c9d-6d18-70e0-a883-9a9a273dfab6	XLP	2026-09-10 14:38	other	2	1	548	446072.00	unknown	—	83.2450	0.4000	["85.5","89"]	["0.3849","0.3135"]	[]	["XBOX"]	85.5000	89.0000	1	8	true	false	true	true	false
01a087a9-ae20-7151-a63a-615aa31a812f	XLP	2026-09-09 15:33	other	4	1	100	44600.00	unknown	—	83.0650	0.3400	["83","83.5"]	["0.1772","0.1771"]	[]	["XISX"]	83.0000	83.5000	2	30	false	false	true	true	false
01a0874b-78f0-7e11-b092-a2ae2319eaf3	XLP	2026-09-09 13:51	put_vertical_spread	2	3	133	41162.00	unknown	—	83.1250	0.0600	["81","86"]	["0.1722","0.1685"]	[]	["XBOX","XCBO","XISX"]	81.0000	86.0000	9	9	false	false	false	true	false
01a0874b-7508-7c43-af24-6efde76c0030	XLP	2026-09-09 13:51	put_vertical_spread	2	1	166	51460.00	unknown	—	83.1200	0.0400	["81","86"]	["0.1728","0.1677"]	[]	["C2OX"]	81.0000	86.0000	9	9	false	false	false	true	false
01a0874b-7120-7970-9096-208f6306ee29	XLP	2026-09-09 13:51	put_vertical_spread	2	4	106	32860.00	unknown	—	83.1200	0.0400	["81","86"]	["0.1728","0.1677"]	[]	["C2OX","XCBO","XISX"]	81.0000	86.0000	9	9	false	false	false	true	false
01a0874b-6d38-7ad2-a64c-22bcfaf8bcd0	XLP	2026-09-09 13:51	put_vertical_spread	2	1	166	51792.00	unknown	—	83.1200	0.0800	["81","86"]	["0.1759","0.1718"]	[]	["XISX"]	81.0000	86.0000	9	9	false	false	false	true	false
01a0870e-7ba8-70e2-9d7f-7074ae6377da	XLP	2026-09-09 12:44	other	2	1	3000	1660500.00	unknown	—	82.9950	0.8800	["85","95"]	["0.1872","0.1333"]	[]	["XBOX"]	85.0000	95.0000	499	499	false	false	false	true	true
01a08671-2e20-7e70-8bb2-7c7a5db13fe0	XLP	2026-09-09 09:52	put_diagonal_spread	2	1	40	43480.00	long	ask	83.1750	0.5600	["83.5","91"]	["0.1867","0.1995"]	[]	["XMIO"]	83.5000	91.0000	30	281	false	false	true
01a0866d-0b88-7810-9541-73d9d75924fa	XLP	2026-09-09 09:48	other	2	1	87	40368.00	unknown	—	83.1800	0.5000	["85"]	["0.2740"]	[]	["XBOX"]	85.0000	85.0000	2	16	false	false	true	false	false
01a0866d-0b88-7810-9541-73ca0b385514	XLP	2026-09-09 09:48	other	2	5	113	49419.00	unknown	—	83.1800	0.5124	["85"]	["0.2264"]	[]	["ARCO","EMLD","SPHR","XBOX","XPHO"]	85.0000	85.0000	2	16	false	false	true	false	false
01a08221-5c00-7782-94e0-9c3f649a2e22	XLP	2026-09-08 13:46	other	2	1	3000	2062500.00	unknown	—	83.9423	0.8000	["80","85"]	["0.1925","0.1105"]	[]	["SPHR"]	80.0000	85.0000	500	500	false	true	false	true	true
01a08142-1f90-7030-826b-46d118d44634	XLP	2026-09-08 09:43	other	2	1	40	37640.00	unknown	—	84.0650	0.7600	["83","91"]	["0.1796","0.2049"]	[]	["XISX"]	83.0000	91.0000	24	282	false	false	true	true	false
01a06dfd-08dd-7560-b8ef-717ed362bdbb	XLP	2026-09-04 15:54	put_vertical_spread	2	1	250	27250.00	unknown	—	84.5950	0.2000	["82.5","83"]	["0.1648","0.1637"]	[]	["XCBO"]	82.5000	83.0000	21	21	false	true	false	true	false
01a06def-83ed-7441-82c7-ab3635783e0b	XLP	2026-09-04 15:40	other	2	1	3000	2137500.00	unknown	—	84.6908	0.7500	["80","85"]	["0.1883","0.1267"]	[]	["XBOX"]	80.0000	85.0000	504	504	false	true	false	true	true