Multi-leg option trades

core.multileg_trades

Class E accrual with a 24-hour vendor cap - the shortest window in the project.

508,354 rowsCSV — whole table, not this view

Sources in this table

uw_multileg508,354 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×source = uw_multileg×ticker = XLU×

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

01a0da2e-35e7-7783-ae54-a5eeb09a0dbc	XLU	2026-09-25 16:07	put_vertical_spread	2	1	200	26800.00	short	bid	39.5400	0.6000	["37","39"]	["0.1858","0.1847"]	["38.40"]	["XMIO"]	37.0000	39.0000	84	84	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T20:09:07Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0da20-477f-7870-926d-0b472fb4fb6c	XLU	2026-09-25 15:52	call_ratio_spread	2	1	2000	87000.00	long	ask	39.5750	0.0600	["40","42"]	["0.2012","0.2094"]	["40.35","43.65"]	["XPHO"]	40.0000	42.0000	21	21	false	true
01a0da13-bc8f-7543-8a22-b53e832a473c	XLU	2026-09-25 15:38	put_diagonal_spread	2	1	2500	3425000.00	long	ask	39.4700	0.8000	["45","47.5"]	["0.2696","0.3244"]	[]	["XPHO"]	45.0000	47.5000	84	112	false	false
01a0d9fe-d4fe-7f12-9764-41452366a9ea	XLU	2026-09-25 15:15	call_vertical_spread	2	1	456	138624.00	long	ask	39.4450	0.1600	["38","42.5"]	["0.1976","0.1866"]	["40.04"]	["XISX"]	38.0000	42.5000	84	84	false	false
01a0d9c0-fcf7-7c71-916d-6e39cdf23cc8	XLU	2026-09-25 14:08	call_calendar	2	2	10000	610000.00	short	ask	39.3561	0.0500	["40"]	["0.2090"]	[]	["AMXO"]	40.0000	40.0000	7	14	false	true
01a0d9bf-a91e-74b1-9984-55bf8bf49e43	XLU	2026-09-25 14:06	call_calendar	2	1	20000	1220000.00	unknown	bid	39.3950	0.0600	["40"]	["0.2034"]	[]	["XISX"]	40.0000	40.0000	7	14	false	true
01a0d9b0-b8e7-7073-9d60-9e264eb0d35d	XLU	2026-09-25 13:50	call_ratio_spread	2	1	466	48697.00	long	ask	39.3350	0.0800	["39.5","45"]	["0.1670","0.1809"]	["40.67","49.33"]	["EDGO"]	39.5000	45.0000	112	112	false	true
01a0d989-7dee-7f93-a9c0-5456f71902c0	XLU	2026-09-25 13:07	call_butterfly_spread	3	1	10000	320000.00	short	bid	39.2950	0.1000	["40.5","41.5","42"]	["0.1867","0.1974","0.2053"]	["40.62"]	["AMXO"]	40.5000	42.0000	21	21	false
01a0d972-6baf-77d0-ba21-03a80ef1bad6	XLU	2026-09-25 12:42	call_diagonal_spread	2	1	18172	803202.00	unknown	ask	39.3500	0.1100	["41","43"]	["0.1859","0.2025"]	[]	["XBOX"]	41.0000	43.0000	21	56	true	true
01a0d952-3597-74f0-bcd4-ac0131c18a06	XLU	2026-09-25 12:07	put_vertical_spread	2	4	28	25680.00	short	bid	39.2950	0.9321	["40","45"]	["0.2185","0.2452"]	["41.85"]	["ARCO","EMLD","SPHR","XPHO"]	40.0000	45.0000	483	483	false
01a0d93c-86ce-7c52-bc00-c89c31de9eb8	XLU	2026-09-25 11:43	call_diagonal_spread	2	2	112	46032.00	short	bid	39.1850	0.1500	["38.5","42.5"]	["0.1761","0.1494"]	[]	["BATO","EDGO"]	38.5000	42.5000	84	448	false	false
01a0d509-8b7f-7092-9b06-2b9d7cecb0f1	XLU	2026-09-24 16:09	risk_reversal	2	1	3000	1659000.00	short	bid	39.4180	5.2600	["35","42"]	["0.2105","0.1262"]	["44.45"]	["ARCO"]	35.0000	42.0000	848	848	false	true
01a0d500-f05f-7a62-a128-6f48352f770c	XLU	2026-09-24 16:00	call_diagonal_spread	2	1	525	54075.00	long	ask	39.3600	0.1000	["40","42"]	["0.1800","0.1965"]	[]	["BATO"]	40.0000	42.0000	22	57	false	true
01a0d4fb-fad7-7d31-bf94-3fefe358ba54	XLU	2026-09-24 15:54	risk_reversal	2	1	10000	5250000.00	long	ask	39.4550	1.0800	["35","42"]	["0.2022","0.1189"]	["44.45"]	["ARCO"]	35.0000	42.0000	848	848	true	true
01a0d4b7-0297-7603-a1af-7069407b49a5	XLU	2026-09-24 14:39	put_diagonal_spread	2	1	356	309720.00	unknown	ask	39.5200	0.6900	["42.5","45"]	["0.3231","0.2756"]	[]	["XBOX"]	42.5000	45.0000	15	85	false	false
01a0d4b6-ef0f-74d0-bd59-2cd2836881b6	XLU	2026-09-24 14:39	other	3	1	5688	5251760.00	unknown	ask	39.5200	0.7500	["41","44.5","45"]	["0.6199","0.2644","0.2756"]	[]	["XBOX"]	41.0000	45.0000	1	85	false	false
01a0d4b6-52cf-7851-a595-6b87950aaba5	XLU	2026-09-24 14:38	other	8	1	2505	2130012.00	unknown	bid	39.4800	4.1800	["41.5","42","43","44","45","47.5","49"]	["0.7148","0.7696","0.1951","0.4187","0.2240","0.5041","2.9086"]	[]	["XBOX"]	41.5000	49.0000	1	85	false
01a0d464-4ace-7ff1-938b-0a13f922a082	XLU	2026-09-24 13:08	call_diagonal_spread	2	1	100	133700.00	short	bid	39.6500	1.1000	["33","34"]	["0.2411","0.2272"]	[]	["XCBO"]	33.0000	34.0000	113	176	false	false
01a0d44a-bbd7-7db2-b7b3-c6a1814f2d97	XLU	2026-09-24 12:41	other	3	1	750	28500.00	unknown	ask	39.6100	0.1300	["38","41.5","55"]	["0.1948","0.1804","0.6385"]	["37.62","41.88"]	["AMXO"]	38.0000	55.0000	22	22	false	true
01a0d3ee-d47f-7b40-b620-d7d2fdbafac2	XLU	2026-09-24 11:00	put_diagonal_spread	2	1	45	32445.00	short	bid	39.5050	0.9200	["42","42.5"]	["0.1979","0.2146"]	[]	["XCBO"]	42.0000	42.5000	204	449	false	false
01a0d3e7-ac77-76f0-b2de-56b637371682	XLU	2026-09-24 10:52	call_diagonal_spread	2	1	132	35772.00	short	bid	39.5050	0.2800	["44","45"]	["0.1622","0.1590"]	[]	["XMIO"]	44.0000	45.0000	266	449	false	true
01a0d3c7-85ff-7200-aa64-052e06c80b9c	XLU	2026-09-24 10:17	put_vertical_spread	2	5	50	43046.00	unknown	ask	39.7300	0.7052	["40","45"]	["0.2141","0.2393"]	["38.20"]	["ARCO","EMLD","SPHR","XPHO"]	40.0000	45.0000	484	484	false
01a0d3b0-a686-7282-a14c-78d36b18822e	XLU	2026-09-24 09:52	call_diagonal_spread	2	1	220	26180.00	short	bid	39.7550	0.0700	["40","42"]	["0.1716","0.1832"]	[]	["AMXO"]	40.0000	42.0000	22	57	false	true
01a0ce8a-b017-70c2-af15-d1eb55d6d9da	XLU	2026-09-23 09:53	put_vertical_spread	2	1	200	27600.00	long	ask	39.9150	0.2500	["39.5","40.5"]	["0.1471","0.1525"]	["39.98"]	["XMIO"]	39.5000	40.5000	30	30	false	false
01a0ce89-aa5e-7da3-a760-fa14791ab244	XLU	2026-09-23 09:52	put_vertical_spread	2	2	200	38400.00	long	ask	39.9600	0.2300	["40","41"]	["0.1521","0.1577"]	["40.38"]	["C2OX"]	40.0000	41.0000	30	30	false	false
01a0ce87-3d47-72e1-8033-00364ec0e55f	XLU	2026-09-23 09:49	put_vertical_spread	2	1	200	65800.00	unknown	—	40.0200	0.7400	["41.5","42"]	["0.1813","0.2383"]	[]	["XMIO"]	41.5000	42.0000	16	16	false	false	false	true
01a0cab1-c75f-7bd2-bba8-4cbedf002e98	XLU	2026-09-22 15:57	put_calendar	2	1	200	42200.00	short	ask	40.5450	0.6100	["41.5"]	["0.1951"]	[]	["XCBO"]	41.5000	41.5000	3	17	false	false
01a0ca18-a827-7643-ba71-9079e9d6bca2	XLU	2026-09-22 13:10	put_vertical_spread	2	1	100	145100.00	long	ask	40.6850	0.5000	["45","50"]	["0.2302","0.2817"]	["45.89"]	["XCBO"]	45.0000	50.0000	486	486	false	false
01a0ca15-9ae7-7371-8eb3-d9c21462b591	XLU	2026-09-22 13:06	call_vertical_spread	2	1	110	53350.00	unknown	bid	40.7150	0.1300	["42.5","45"]	["0.1434","0.1478"]	["46.18"]	["XISX"]	42.5000	45.0000	451	451	false	true
01a0c54f-96f6-72c2-a542-e4f1389f6edc	XLU	2026-09-21 14:51	put_vertical_spread	2	1	50	37638.00	long	ask	40.6950	0.4700	["40","45"]	["0.2083","0.2279"]	["42.22"]	["XCBO"]	40.0000	45.0000	487	487	false	false
01a0c4c9-7ed6-7510-a004-c3d94aba86fb	XLU	2026-09-21 12:25	put_vertical_spread	2	1	825	61863.00	long	ask	40.8450	0.1300	["37","40"]	["0.1914","0.1685"]	["39.49"]	["EDGO"]	37.0000	40.0000	60	60	false	true
01a0c4bd-846e-7e63-8ece-fed6269a3eda	XLU	2026-09-21 12:12	strangle	2	1	250	46250.00	short	bid	40.8600	0.2900	["38","46"]	["0.1902","0.1526"]	["36.15","47.85"]	["AMXO"]	38.0000	46.0000	269	269	false	true
01a0c442-709f-7661-b5ac-24493f201b27	XLU	2026-09-21 09:58	other	4	1	65	31785.00	unknown	—	40.6700	0.6000	["39","40","43"]	["0.1753","0.1925","0.2540"]	[]	["XCBO"]	39.0000	43.0000	4	25	false	false	true	true
01a0c438-858f-7a92-b40e-fb084a3cfab9	XLU	2026-09-21 09:47	put_calendar	2	2	201	73365.00	short	bid	40.6350	0.7600	["42.5"]	["0.2816"]	[]	["C2OX","XCBO"]	42.5000	42.5000	4	18	false	false
01a0b5f0-adef-7c91-b667-3ddf0c12bb12	XLU	2026-09-18 15:14	strangle	2	1	2100	128100.00	short	bid	41.2250	0.1100	["39.5","43"]	["0.1880","0.1460"]	["38.89","43.61"]	["ARCO"]	39.5000	43.0000	42	42	false	true
01a0b5e9-a13f-7a23-bf02-bc961b21570f	XLU	2026-09-18 15:06	call_diagonal_spread	2	1	54	50868.00	long	ask	41.2250	0.3500	["37","42"]	["0.1917","0.1176"]	[]	["XCBO"]	37.0000	42.0000	119	819	false	false
01a0b5c5-c58f-7c33-ab72-1fbd8f18f19b	XLU	2026-09-18 14:27	put_ratio_spread	2	1	9000	2682000.00	unknown	bid	41.2100	1.3800	["30","41"]	["0.2358","0.2271"]	["12.80","38.60"]	["XBOX"]	30.0000	41.0000	854	854	true	true
01a0b574-ee40-7390-bca2-9f18b07dc76b	XLU	2026-09-18 12:58	other	3	1	3500	415000.00	unknown	bid	41.1350	0.3300	["39.5","42.5","43"]	["0.1856","1.2542","0.1509"]	[]	["XPHO"]	39.5000	43.0000	0	42	false	false
01a0b539-5c3f-7be1-908f-53abface971b	XLU	2026-09-18 11:53	put_diagonal_spread	2	1	2000	191000.00	unknown	bid	41.1750	0.1200	["40","42"]	["0.1826","0.1982"]	[]	["XMIO"]	40.0000	42.0000	28	63	false	false
01a0b0a2-b593-7970-971f-8a0d631b88d5	XLU	2026-09-17 14:30	put_vertical_spread	2	1	1161	645516.00	unknown	—	41.6550	0.5500	["44","45"]	["1.2078","1.1152"]	[]	["XBOX"]	44.0000	45.0000	1	1	false	false	false	true
01a0b0a2-a20b-74e1-a096-a35660faa085	XLU	2026-09-17 14:30	put_vertical_spread	2	1	6928	2369376.00	unknown	—	41.6550	0.4200	["43","43.5"]	["0.6198","0.7609"]	[]	["XBOX"]	43.0000	43.5000	1	1	false	false	false	true
01a0b0a2-8e83-7bc2-9c15-9b90d6867ca0	XLU	2026-09-17 14:30	put_vertical_spread	2	1	7628	3371576.00	unknown	—	41.6550	0.3700	["43","44.5"]	["0.6198","1.0200"]	[]	["XBOX"]	43.0000	44.5000	1	1	false	false	false	true
01a0b0a2-3c7b-7d51-b206-8ef7d5278294	XLU	2026-09-17 14:30	put_vertical_spread	2	1	2680	1608000.00	unknown	—	41.6550	0.5500	["44.5","45"]	["1.3023","1.1152"]	[]	["XBOX"]	44.5000	45.0000	1	1	false	false	false	true
01a0b094-bb73-7a83-986c-d6137969620a	XLU	2026-09-17 14:15	call_vertical_spread	2	1	120	55800.00	short	bid	41.6150	0.2200	["39","42"]	["0.0857","0.1421"]	["40.75"]	["SPHR"]	39.0000	42.0000	120	120	false	false
01a0b020-d77b-7b41-bd91-89a3a4f9e35d	XLU	2026-09-17 12:08	put_diagonal_spread	2	2	294	49686.00	long	bid	41.6500	0.1600	["35","40"]	["0.2155","0.1870"]	[]	["ARCO"]	35.0000	40.0000	120	491	false	true
01a0afbf-df42-7971-a419-aab90526df6d	XLU	2026-09-17 10:22	call_diagonal_spread	2	1	80	86240.00	short	bid	41.4100	2.9000	["36","37"]	["0.2915","0.5676"]	[]	["XCBO"]	36.0000	37.0000	15	64	false	false
01a0afbe-9723-7dc0-a505-eff4d366c4c3	XLU	2026-09-17 10:21	call_diagonal_spread	2	2	43	51756.00	long	ask	41.4350	0.9209	["36","40"]	["0.2359","0.1063"]	[]	["BATO","MCRY"]	36.0000	40.0000	92	855	false	false
01a0afbd-27f3-70e2-ad3a-a32d8ca151a2	XLU	2026-09-17 10:20	call_diagonal_spread	2	1	100	106230.00	long	ask	41.4200	0.8500	["40","40.5"]	["0.1047","0.1246"]	[]	["XMIO"]	40.0000	40.5000	491	855	false	false
01a0abce-de93-7fd1-a7c9-4af95c0bf5de	XLU	2026-09-16 16:00	other	6	1	7625	355358.00	unknown	—	41.3200	0.1150	["42","43","43.5","44","44.5","45"]	["0.1463","0.2832","0.3504","0.4149","0.4773","0.5378"]	[]	["XCBO"]	42.0000	45.0000	2	30	false	true	true	true
01a0abb4-8093-71f1-a138-61a556e632ae	XLU	2026-09-16 15:32	call_vertical_spread	2	1	80	42480.00	short	bid	41.1996	1.1900	["38","41"]	["0.1679","0.1456"]	["39.75"]	["SPHR"]	38.0000	41.0000	121	121	false	false