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×strategy = other×ticker = XLE×

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

01a0d9ea-147f-78d1-ab3b-b8d6472b556a	XLE	2026-09-25 14:53	other	4	1	35	28940.00	unknown	—	61.9050	0.5200	["60","65","68"]	["0.2658","0.2647","0.2876"]	[]	["XPHO"]	60.0000	68.0000	21	56	false	false	true	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T18:53:56Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0d4f3-6787-7a71-8157-be3170f0a049	XLE	2026-09-24 15:45	other	2	1	10	26280.00	unknown	bid	62.7050	1.1500	["55","80"]	["0.2808","0.3722"]	[]	["XPHO"]	55.0000	80.0000	98	113	false	false
01a0d40c-7e3f-7480-b2f4-e849b23617c7	XLE	2026-09-24 11:33	other	4	1	238	39151.00	unknown	—	63.3150	0.1700	["61","63","65"]	["0.2761","0.2666","0.2674"]	[]	["XCBO"]	61.0000	65.0000	8	8	false	false	false	true
01a0ca3c-9377-7c02-852e-0bc0e01b3b93	XLE	2026-09-22 13:49	other	2	1	20	30200.00	unknown	—	62.4700	1.2800	["47","54"]	["0.3219","0.1653"]	[]	["XCBO"]	47.0000	54.0000	87	815	false	false	true	true	true
01a0c4a4-1c87-7fc3-bc63-c657e587218d	XLE	2026-09-21 11:44	other	3	1	109	33463.00	unknown	—	62.7950	0.0700	["65","75"]	["0.2617","0.2842"]	[]	["XCBO"]	65.0000	75.0000	25	60	false	true	true	true	false
01a0b604-f16f-7431-8b06-113341550659	XLE	2026-09-18 15:36	other	4	1	234	34632.00	unknown	ask	64.2950	0.1300	["62","64","66"]	["0.3099","0.2652","0.2261"]	["60.84","63.16","64.84","67.16"]	["XMIO"]	62.0000	66.0000	7	7	false	false
01a0b5b8-d50f-72a1-b99e-be2d86542651	XLE	2026-09-18 14:13	other	3	1	38	29868.00	unknown	bid	64.3950	0.4800	["60.5","61.5","64.5"]	["0.2868","0.1796","0.3040"]	["63.4"]	["XMIO"]	60.5000	64.5000	7	7	false	false
01a0b5b2-1e4f-7701-a90b-59e6d0dd9db2	XLE	2026-09-18 14:05	other	4	1	80	102720.00	unknown	bid	64.3350	0.4200	["58.5","59","64","64.5"]	["0.1762","0.1929","0.2908","0.2864"]	[]	["XMIO"]	58.5000	64.5000	0	35	false	false
01a0b51d-2d67-7472-b83e-1c66b27d9e00	XLE	2026-09-18 11:23	other	4	1	50	80150.00	unknown	—	64.6650	0.6300	["59","61","63"]	["2.5062","0.9766","0.2198"]	[]	["XCBO"]	59.0000	63.0000	0	28	false	false	true	true	false
01a0b035-8c43-7690-8c52-f9adf42937a7	XLE	2026-09-17 12:31	other	3	2	148	64084.00	unknown	—	64.1800	0.1600	["65","75"]	["0.2448","0.2730"]	[]	["MCRY","XPHO"]	65.0000	75.0000	29	64	false	true	true	true	false
01a0abce-07bb-7e43-850c-c5176f84bc2a	XLE	2026-09-16 15:59	other	5	1	14573	1450168.00	unknown	—	64.0550	0.1200	["65","66","67","67.5"]	["0.3047","0.3245","0.2656","0.3711"]	[]	["XCBO"]	65.0000	67.5000	2	30	false	true	true	true
01a0a177-1680-7a90-be2c-239a1e05ee21	XLE	2026-09-14 15:48	other	2	1	5530	480430.00	unknown	—	64.3750	0.0300	["63.5","64"]	["0.3250","0.3217"]	[]	["XPHO"]	63.5000	64.0000	4	4	false	true	false	true	false
01a0a146-ea78-71f3-b50d-e8d0a02fb3c6	XLE	2026-09-14 14:56	other	3	1	38	35359.00	unknown	—	64.4700	0.5000	["60","60.5","64"]	["0.4678","0.2569","0.2863"]	[]	["XMIO"]	60.0000	64.0000	4	14	false	false	true	true
01a0a129-92c0-7ce3-8c56-8359889e7216	XLE	2026-09-14 14:24	other	3	1	20	26620.00	unknown	—	64.7261	0.6800	["58.5","59","64.5"]	["0.2001","0.1904","0.3042"]	[]	["AMXO"]	58.5000	64.5000	4	39	false	false	true	true
01a0a074-2570-7540-97d3-f8043fa6fc4f	XLE	2026-09-14 11:05	other	4	1	111	80253.00	unknown	—	65.4200	0.5900	["62.5","65","68","71"]	["0.3554","0.3074","0.2545","0.2568"]	[]	["XMIO"]	62.5000	71.0000	4	67	false	false	true	true
01a0a072-b258-7363-bf34-40fbda9a6a76	XLE	2026-09-14 11:04	other	4	1	96	72288.00	unknown	—	65.5300	0.2900	["62.5","65","68","71"]	["0.3646","0.3051","0.2568","0.2600"]	[]	["XMIO"]	62.5000	71.0000	4	67	false	false	true	true
01a091e3-b8e0-7a53-ae5c-1a6b0a9224a2	XLE	2026-09-11 15:13	other	2	2	80	44600.00	unknown	—	65.0850	0.2200	["58","65"]	["0.4862","0.2324"]	[]	["XCBO","XPHO"]	58.0000	65.0000	7	35	false	false	true	true	false
01a091c9-c840-7fe3-b6d7-a57eeeb81e48	XLE	2026-09-11 14:45	other	2	1	2000	892000.00	unknown	—	65.0600	0.2300	["58","65"]	["0.5147","0.2435"]	[]	["XBOX"]	58.0000	65.0000	7	7	false	false	false	true	false
01a0919d-af31-78f1-91bd-9368a0691b42	XLE	2026-09-11 13:57	other	3	2	60	86724.00	unknown	—	65.0000	1.5600	["58","58.5","65"]	["0.1857","0.1712","0.2432"]	[]	["XCBO","XISX"]	58.0000	65.0000	7	42	false	false	true	true
01a0919d-af31-78f1-91bd-935c1ebe270c	XLE	2026-09-11 13:57	other	3	2	32	45904.00	unknown	—	65.0000	1.5600	["58","58.5","65"]	["0.2236","0.2215","0.2519"]	[]	["XBOX","XISX"]	58.0000	65.0000	7	42	false	false	true	true
01a09189-2948-76b1-8ff5-56afc229d5ab	XLE	2026-09-11 13:34	other	2	1	625	42250.00	unknown	—	65.1400	0.0500	["62","63"]	["0.2836","0.2680"]	[]	["EDGO"]	62.0000	63.0000	7	35	false	true	true	true	false
01a09105-5348-7202-998d-8b6e6956d697	XLE	2026-09-11 11:10	other	2	6	115	77488.00	unknown	—	64.8050	0.1800	["65","68"]	["0.2521","0.2412"]	[]	["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"]	65.0000	68.0000	70	189	false	true	true	true
01a09105-3fc0-7de2-953d-249b6b9f058a	XLE	2026-09-11 11:10	other	2	2	63	42651.00	unknown	—	64.8150	0.1800	["65","68"]	["0.2525","0.2421"]	[]	["EMLD","XMIO"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-3fc0-7de2-953d-247bdffd6aa4	XLE	2026-09-11 11:10	other	2	4	112	75824.00	unknown	—	64.8150	0.1550	["65","68"]	["0.2525","0.2421"]	[]	["AMXO","MCRY","XBOX","XPHO"]	65.0000	68.0000	70	189	false	true	true	true
01a09104-e9d1-7f91-97ac-abdb208299d4	XLE	2026-09-11 11:10	other	2	1	38	25916.00	unknown	—	64.8900	0.1700	["65","68"]	["0.2498","0.2424"]	[]	["MCRY"]	65.0000	68.0000	70	189	false	true	true	true	false
01a090e3-09f1-75a3-b216-f1e99ef9fa9d	XLE	2026-09-11 10:33	other	2	2	3900	5457400.00	unknown	—	65.2250	1.2125	["55","70"]	["0.1882","0.2252"]	[]	["XCBO"]	55.0000	70.0000	279	371	false	false	true	true	false
01a090df-54b8-7250-aabe-c2e52f68c619	XLE	2026-09-11 10:29	other	2	1	111	34743.00	unknown	—	65.2401	0.0900	["63.5","64.5"]	["0.5497","0.2605"]	[]	["EDGO"]	63.5000	64.5000	0	7	false	false	true	true	false
01a08cb8-f3f8-7ec3-b01f-9af07f2f8e9c	XLE	2026-09-10 15:08	other	2	1	59	118590.00	unknown	—	65.2050	0.6500	["60","65"]	["0.2202","0.1984"]	[]	["MCRY"]	60.0000	65.0000	280	827	false	false	true	true	false
01a08c8e-7ce0-7793-926d-e0517eb730e2	XLE	2026-09-10 14:22	other	3	1	38	44080.00	unknown	—	65.2000	0.4700	["59.5","60","64"]	["0.9238","0.3258","0.2812"]	[]	["XPHO"]	59.5000	64.0000	1	8	false	false	true	true
01a08c79-3791-7cd2-add3-ef4d5c9ab46b	XLE	2026-09-10 13:59	other	2	2	24	33080.00	unknown	—	65.1050	0.7500	["59","60"]	["0.4153","0.2008"]	[]	["ARCO","XISX"]	59.0000	60.0000	8	463	false	false	true	true	false
01a08c79-3791-7cd2-add3-ef38c3525553	XLE	2026-09-10 13:59	other	2	3	56	77312.00	unknown	—	65.1050	0.7500	["59","60"]	["0.4435","0.2013"]	[]	["ARCO","EDGO","XISX"]	59.0000	60.0000	8	463	false	false	true	true
01a08c79-33a8-7d23-966a-b7626efe7b17	XLE	2026-09-10 13:59	other	2	3	42	57930.00	unknown	—	65.1050	0.7000	["59","60"]	["0.4021","0.2012"]	[]	["AMXO","XCBO","XPHO"]	59.0000	60.0000	8	463	false	false	true	true
01a08c64-5fa0-7062-8829-7be771048636	XLE	2026-09-10 13:36	other	2	1	40	40960.00	unknown	—	65.2500	0.2800	["60","62.5"]	["0.2272","0.2940"]	[]	["C2OX"]	60.0000	62.5000	8	127	false	false	true	true	false
01a08bcc-ced9-7e10-94f0-3081b766f90f	XLE	2026-09-10 10:50	other	4	1	154	27566.00	unknown	—	64.6950	0.1700	["63","65","67"]	["0.2821","0.2783","0.2785"]	[]	["XPHO"]	63.0000	67.0000	8	8	false	false	false	true
01a081ae-a8b8-7423-af61-052ae4005798	XLE	2026-09-08 11:41	other	2	1	22	53350.00	unknown	—	64.7800	1.9000	["52.5","53"]	["0.7851","0.4630"]	[]	["BATO"]	52.5000	53.0000	10	45	false	false	true	true	false
01a08192-7210-7473-94c4-63d309e82c08	XLE	2026-09-08 11:10	other	2	1	180	25920.00	unknown	—	64.8750	0.0700	["62","63"]	["0.2504","0.2710"]	[]	["XMIO"]	62.0000	63.0000	8	38	false	true	true	true	false
01a0818a-e091-7a72-b8c2-8d9cc94c9439	XLE	2026-09-08 11:02	other	2	1	10	32590.00	unknown	—	64.8150	1.7000	["50"]	["0.2614"]	[]	["AMXO"]	50.0000	50.0000	101	465	false	false	true	false	false
01a0815e-8900-7a01-af68-d9856ee83166	XLE	2026-09-08 10:14	other	2	1	189	113589.00	unknown	—	65.1700	0.3300	["62.5","64"]	["0.2699","0.2720"]	[]	["XMIO"]	62.5000	64.0000	101	192	false	true	true	true	false
01a06e01-fe65-7063-b198-81807fc29d86	XLE	2026-09-04 16:00	other	2	2	10000	708000.00	unknown	—	64.0600	0.4700	["63","65"]	["0.1910","29.7806"]	[]	["AMXO"]	63.0000	65.0000	0	5	false	false	true	true	false
01a06dd9-061d-7b90-99c9-057f23401c71	XLE	2026-09-04 15:15	other	2	7	102	27836.00	unknown	—	63.9850	0.0500	["52.5","55"]	["0.4474","0.2681"]	[]	["AMXO","ARCO","BATO","EDGO","MCRY","XPHO"]	52.5000	55.0000	14	469	false	true	true	true
01a06d46-3fe5-7ab1-84f5-dc5a0dda692e	XLE	2026-09-04 12:35	other	2	4	76	33646.00	unknown	—	64.0850	0.2600	["57.5","60"]	["0.2861","0.2678"]	[]	["ARCO","EDGO","XBOX","XISX"]	57.5000	60.0000	14	469	false	true	true	true
01a06d45-7c95-7d32-96e9-32f71cb9cf0e	XLE	2026-09-04 12:34	other	2	3	106	36781.00	unknown	—	64.0950	0.2200	["54","57.5"]	["0.3778","0.2668"]	[]	["EDGO","XBOX","XISX"]	54.0000	57.5000	14	469	false	true	true	true
01a06d44-d49d-7ed2-9fe0-e43ad4de0778	XLE	2026-09-04 12:33	other	2	1	108	47898.00	unknown	—	64.1100	0.2600	["57.5","60"]	["0.2840","0.2684"]	[]	["EDGO"]	57.5000	60.0000	14	469	false	true	true	true	false