Multi-leg option trades

core.multileg_trades

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

570,195 rowsCSV — whole table, not this view

Sources in this table

uw_multileg570,195 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×net_side = ask×ticker = XLV×

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

01a0eec0-954e-7df2-91c1-b4cb742bbba9	XLV	2026-09-29 15:59	risk_reversal	2	1	66	39336.00	long	ask	170.7200	0.5600	["150","175"]	["0.2017","0.1646"]	["179.36"]	["EDGO"]	150.0000	175.0000	108	108	false	true	false	true	true	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T20:00:05Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0eebc-ebce-7480-b726-f446150c1a7c	XLV	2026-09-29 15:55	risk_reversal	2	1	120	70668.00	long	ask	170.5700	0.4600	["150","175"]	["0.2008","0.1645"]	["179.29"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0eeb6-7777-7550-9921-76e259aecd3a	XLV	2026-09-29 15:48	risk_reversal	2	3	51	30141.00	long	ask	170.5800	0.3000	["150","175"]	["0.2009","0.1650"]	["179.31"]	["AMXO","BATO","XBOX"]	150.0000	175.0000	108	108	false	true
01a0eead-e03f-7d40-9f8b-e6d8374179f0	XLV	2026-09-29 15:39	strangle	2	1	120	70080.00	long	ask	170.6300	0.3200	["150","175"]	["0.1991","0.1633"]	["144.16","180.84"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0eea7-6416-7f71-a09d-56cfc3b40b37	XLV	2026-09-29 15:32	strangle	2	1	120	69720.00	long	ask	170.5800	0.2700	["150","175"]	["0.1988","0.1631"]	["144.19","180.81"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0eea5-3d4e-7823-bc73-2a6a11b277a4	XLV	2026-09-29 15:29	strangle	2	1	101	58777.00	long	ask	170.5800	0.2700	["150","175"]	["0.1988","0.1633"]	["144.18","180.82"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0eea0-f78f-7063-86d3-dbefa0e0ed96	XLV	2026-09-29 15:25	risk_reversal	2	1	120	69000.00	long	ask	170.5100	0.2600	["150","175"]	["0.1977","0.1626"]	["179.23"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee9e-ccdf-70b0-b9c7-77daa5513582	XLV	2026-09-29 15:22	risk_reversal	2	1	120	68880.00	long	ask	170.5100	0.2600	["150","175"]	["0.1977","0.1623"]	["179.22"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee9c-c557-72b1-8ebe-7a38d3cb5907	XLV	2026-09-29 15:20	risk_reversal	2	3	47	27217.00	long	ask	170.5500	0.2100	["150","175"]	["0.1987","0.1629"]	["179.25"]	["BATO","SPHR","XBOX"]	150.0000	175.0000	108	108	false	true
01a0ee9a-871f-7422-8d26-0e8605f0e28f	XLV	2026-09-29 15:18	risk_reversal	2	5	50	28710.00	long	ask	170.4600	0.3600	["150","175"]	["0.1985","0.1626"]	["179.19"]	["AMXO","ARCO","EDGO","XMIO"]	150.0000	175.0000	108	108	false	true
01a0ee98-5c6f-7f23-9e2a-50c3e9423ba0	XLV	2026-09-29 15:15	strangle	2	1	120	68989.00	long	ask	170.4000	0.4100	["150","175"]	["0.1991","0.1631"]	["144.25","180.75"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee94-0af7-76b0-bd3f-6b527d04d55f	XLV	2026-09-29 15:11	strangle	2	1	120	68880.00	long	ask	170.4300	0.4100	["150","175"]	["0.1993","0.1625"]	["144.26","180.74"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee91-e047-7e62-9bd2-fab00ceb302e	XLV	2026-09-29 15:08	strangle	2	1	120	68160.00	long	ask	170.3200	0.3100	["150","175"]	["0.1986","0.1622"]	["144.32","180.68"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee8b-73be-78e1-b849-52dccc8f88cf	XLV	2026-09-29 15:01	strangle	2	1	120	67200.00	long	ask	170.3100	0.4200	["150","175"]	["0.1972","0.1607"]	["144.40","180.60"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee89-490f-7ba1-afd4-2744e7261e82	XLV	2026-09-29 14:59	strangle	2	1	120	66960.00	long	ask	170.2600	0.4200	["150","175"]	["0.1969","0.1608"]	["144.42","180.58"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee84-ff67-7fa2-8538-4733c3ec9c78	XLV	2026-09-29 14:54	strangle	2	1	120	67197.00	long	ask	170.2351	0.4100	["150","175"]	["0.1981","0.1611"]	["144.40","180.60"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee82-d4b6-75f3-b278-ef7c0a43964e	XLV	2026-09-29 14:52	strangle	2	1	120	67432.00	long	ask	170.2390	0.3100	["150","175"]	["0.1982","0.1616"]	["144.38","180.62"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0ee80-adef-7ca0-b5f7-c3e3160bc161	XLV	2026-09-29 14:50	strangle	2	1	111	62491.00	long	ask	170.3200	0.3100	["150","175"]	["0.1986","0.1609"]	["144.37","180.63"]	["EDGO"]	150.0000	175.0000	108	108	false	true
01a0e912-dcf7-7f20-a179-5e7424a611da	XLV	2026-09-28 13:32	call_vertical_spread	2	1	8	102560.00	long	ask	171.1800	1.8000	["105","110"]	["1.4153","1.3066"]	["109.98"]	["MCRY"]	105.0000	110.0000	11	11	false	false
01a0e910-3d17-7b11-85a4-5f93a56348d1	XLV	2026-09-28 13:29	call_vertical_spread	2	1	32	411072.00	unknown	ask	171.1700	1.8000	["105","110"]	["1.5127","1.3951"]	["171.73"]	["MCRY"]	105.0000	110.0000	11	11	false	false
01a0e90c-0ec7-7781-b773-858be0ea9234	XLV	2026-09-28 13:24	call_vertical_spread	2	1	40	513760.00	long	ask	171.2601	1.9000	["105","110"]	["1.4468","1.3352"]	["109.98"]	["XMIO"]	105.0000	110.0000	11	11	false	false
01a0e8f2-8b86-7262-9ecb-e396d931d67a	XLV	2026-09-28 12:56	call_vertical_spread	2	1	9	114606.00	long	ask	171.3900	1.7000	["105","110"]	["2.0597","2.0566"]	["109.98"]	["XISX"]	105.0000	110.0000	4	4	false	false
01a0e8e5-ae8f-7952-8f4c-17bfd9641e91	XLV	2026-09-28 12:42	call_vertical_spread	2	1	3	47088.00	unknown	ask	171.4699	2.8000	["90","95"]	["1.5054","1.3745"]	["170.98"]	["MCRY"]	90.0000	95.0000	11	11	false	false
01a0e8ce-61b7-71c0-b9a0-64306b20e335	XLV	2026-09-28 12:17	call_vertical_spread	2	1	7	109473.00	long	ask	171.1400	2.8000	["90","95"]	["1.6506","1.5156"]	["94.99"]	["AMXO"]	90.0000	95.0000	11	11	false	false
01a0d8d1-16e7-72c1-9b6a-7760345dc8ff	XLV	2026-09-25 09:46	call_vertical_spread	2	1	3	25626.00	long	ask	169.2900	4.2000	["125","130"]	["1.4455","1.2990"]	["129.98"]	["XCBO"]	125.0000	130.0000	7	7	false	false
01a0d4e2-546f-7163-89ea-34804a7b2ac6	XLV	2026-09-24 15:26	strangle	2	2	500	907500.00	long	ask	170.3300	2.4500	["160","175"]	["0.1978","0.1625"]	["141.85","193.15"]	["ARCO"]	160.0000	175.0000	358	358	false	true
01a0d41b-fb16-7381-902a-c0f61ffc9626	XLV	2026-09-24 11:49	call_vertical_spread	2	1	17	162010.00	long	ask	169.8800	1.8000	["120","125"]	["0.7283","0.6660"]	["124.98"]	["XMIO"]	120.0000	125.0000	15	15	false	false
01a0d418-edd7-73e2-b8fc-08c45564e31d	XLV	2026-09-24 11:46	call_vertical_spread	2	1	2	26998.00	long	ask	170.0200	1.4000	["100","105"]	["1.1502","1.1444"]	["104.97"]	["XMIO"]	100.0000	105.0000	15	15	false	false
01a0d3f0-9d86-7243-83ad-3fae7f9204e1	XLV	2026-09-24 11:02	call_vertical_spread	2	1	12	79992.00	long	ask	170.4000	2.7000	["135","140"]	["0.6050","0.5297"]	["139.98"]	["XCBO"]	135.0000	140.0000	15	15	false	false
01a0d3ec-7aef-7892-a603-8a84934e46a9	XLV	2026-09-24 10:58	call_vertical_spread	2	1	10	66640.00	long	ask	170.5300	2.7000	["135","140"]	["0.5070","0.4482"]	["139.98"]	["XMIO"]	135.0000	140.0000	15	15	false	false
01a0d3ec-57c7-7432-ba73-9887e59a8097	XLV	2026-09-24 10:57	call_vertical_spread	2	1	10	66640.00	long	ask	170.5375	2.7000	["135","140"]	["0.4983","0.4414"]	["139.98"]	["XMIO"]	135.0000	140.0000	15	15	false	false
01a0d3eb-908f-7082-82d7-c1d9142b85a2	XLV	2026-09-24 10:57	call_vertical_spread	2	1	20	133320.00	long	ask	170.4700	2.7000	["135","140"]	["0.5654","0.4959"]	["139.98"]	["XCBO"]	135.0000	140.0000	15	15	false	false
01a0d3e3-9d67-7920-9392-24028f8a28ad	XLV	2026-09-24 10:48	call_vertical_spread	2	1	20	133320.00	long	ask	170.7800	2.7000	["135","140"]	["0.7079","0.6429"]	["139.98"]	["XCBO"]	135.0000	140.0000	15	15	false	false
01a0cfab-79c6-7170-a4f7-87cecd7da909	XLV	2026-09-23 15:08	call_diagonal_spread	2	1	20	46980.00	long	ask	168.6250	1.4700	["160","170"]	["0.1600","0.1860"]	[]	["XMIO"]	160.0000	170.0000	2	485	false	false
01a0cf22-19cf-75c1-9b29-86c283e12c3c	XLV	2026-09-23 12:38	call_vertical_spread	2	1	4	45536.00	long	ask	168.6500	3.3000	["110","115"]	["3.5126","3.2207"]	["114.98"]	["XMIO"]	110.0000	115.0000	2	2	false	false
01a0cf1f-c80e-75c3-bdc7-a3df6569ed4a	XLV	2026-09-23 12:35	call_vertical_spread	2	1	3	45807.00	long	ask	168.6100	0.6000	["90","95"]	["1.2067","1.1499"]	["94.97"]	["XISX"]	90.0000	95.0000	16	16	false	false
01a0cf1d-14a7-7902-9c21-346abd0280e4	XLV	2026-09-23 12:33	call_vertical_spread	2	1	2	28760.00	long	ask	168.6600	2.8000	["95","100"]	["2.0754","1.9223"]	["99.98"]	["XMIO"]	95.0000	100.0000	9	9	false	false
01a0cf1a-fd7e-7800-9158-5bf07388d5c5	XLV	2026-09-23 12:30	call_vertical_spread	2	1	48	590112.00	long	ask	168.7205	0.8500	["105","110"]	["0.9220","0.8582"]	["109.98"]	["XCBO"]	105.0000	110.0000	16	16	false	false
01a0cf17-3c8f-7691-8549-bb76760c3ec8	XLV	2026-09-23 12:26	call_vertical_spread	2	1	21	258090.00	long	ask	168.6750	0.8000	["105","110"]	["0.9637","0.8927"]	["109.98"]	["XMIO"]	105.0000	110.0000	16	16	false	false
01a0cf17-05df-7541-b3d9-b82b7ed3f147	XLV	2026-09-23 12:26	call_vertical_spread	2	1	16	196640.00	long	ask	168.6700	0.8000	["105","110"]	["0.9708","0.8987"]	["109.98"]	["XMIO"]	105.0000	110.0000	16	16	false	false
01a0cf16-3ea6-7991-bc8f-c9c34e547065	XLV	2026-09-23 12:25	call_vertical_spread	2	1	20	245840.00	long	ask	168.6400	0.8000	["105","110"]	["1.0194","0.9407"]	["109.98"]	["XCBO"]	105.0000	110.0000	16	16	false	false
01a0cf10-f32f-79e0-9913-8a27cc617aca	XLV	2026-09-23 12:19	call_vertical_spread	2	1	20	245800.00	long	ask	168.6700	0.8000	["105","110"]	["0.9708","0.8987"]	["109.98"]	["XMIO"]	105.0000	110.0000	16	16	false	false
01a0cf0f-1e6f-7a62-84ed-ec327623f53b	XLV	2026-09-23 12:17	call_vertical_spread	2	1	2	26560.00	long	ask	168.6600	0.8000	["100","105"]	["1.0058","0.9401"]	["104.98"]	["XMIO"]	100.0000	105.0000	16	16	false	false
01a0ca78-024f-75e1-8ca1-b80b371e3a01	XLV	2026-09-22 14:54	put_diagonal_spread	2	1	2700	830200.00	unknown	ask	170.1700	1.1300	["145","160"]	["0.2105","0.1970"]	[]	["XBOX"]	145.0000	160.0000	115	360	false	true
01a0c9fe-59c7-73c2-841d-c93e073bda6b	XLV	2026-09-22 12:41	call_vertical_spread	2	1	50	323000.00	long	ask	170.0950	2.8000	["135","140"]	["0.7409","0.6868"]	["139.98"]	["XPHO"]	135.0000	140.0000	10	10	false	false
01a0c9f9-25bf-7f61-95fe-dcfb5b9cf7a1	XLV	2026-09-22 12:35	call_vertical_spread	2	1	50	323100.00	long	ask	170.1000	2.8000	["135","140"]	["0.7379","0.6847"]	["139.98"]	["XCBO"]	135.0000	140.0000	10	10	false	false
01a0c4d4-9e7f-7e41-bf83-da23a98f241f	XLV	2026-09-21 12:37	call_vertical_spread	2	1	2	26426.00	long	ask	168.6200	3.5500	["100","105"]	["1.3333","1.2597"]	["104.97"]	["XMIO"]	100.0000	105.0000	18	18	false	false
01a0c46b-12f7-7981-829b-7ed87f9ab579	XLV	2026-09-21 10:42	call_vertical_spread	2	1	19	116356.00	long	ask	168.8800	4.2500	["135","140"]	["0.6210","0.5628"]	["139.98"]	["XCBO"]	135.0000	140.0000	11	11	false	false
01a0b612-b0f8-7421-8617-65e629495d4a	XLV	2026-09-18 15:51	call_diagonal_spread	2	1	5	68800.00	unknown	ask	168.5850	4.2000	["90","110"]	["0.8741","1.4075"]	[]	["XPHO"]	90.0000	110.0000	7	21	false	false
01a0b612-a53f-7d83-8365-d23d2cc83620	XLV	2026-09-18 15:51	call_diagonal_spread	2	1	5	31830.00	unknown	ask	168.6100	4.3500	["120","154"]	["0.8215","0.3397"]	[]	["XPHO"]	120.0000	154.0000	14	28	false	false