Multi-leg option trades

core.multileg_trades

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

677,480 rowsCSV — whole table, not this view

Sources in this table

uw_multileg677,480 rows

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:kept_by = tracked×strategy = call_ratio_spread×

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

01a0fd3e-4117-79c0-9a12-49c87eb3bc8a	WDC	2026-10-02 11:31	call_ratio_spread	2	1	20	34810.00	long	ask	398.8400	4.0500	["610","970"]	["0.6944","0.7420"]	["624.05","1315.95"]	["XPHO"]	610.0000	970.0000	168	168	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-10-02T15:32:01Z"}	2026-10-02	2026-10-02 17:15	2026-10-02 17:15
01a0fd3e-25bf-7f01-8890-52e57f8084ab	WDC	2026-10-02 11:31	call_ratio_spread	2	1	20	36510.00	long	ask	398.7400	4.1000	["610","970"]	["0.7012","0.7572"]	["623.51","1316.49"]	["AMXO"]	610.0000	970.0000	168	168	false	true	false
01a0fd3b-010e-7420-b976-11b4117548c0	SPX	2026-10-02 11:28	call_ratio_spread	2	1	50	34959.00	long	ask	7712.3800	0.2500	["7725","7745"]	["0.1924","0.1896"]	["7727.32","7762.68"]	["XCBO"]	7725.0000	7745.0000	0	0	false	true	false
01a0fd39-0157-7b40-abe8-719e65416439	SPCX	2026-10-02 11:26	call_ratio_spread	2	2	14	29508.00	unknown	ask	155.9300	0.8500	["310","450"]	["0.5282","0.5359"]	["352.15"]	["EDGO","XISX"]	310.0000	450.0000	805	805	false	true	false
01a0fd38-f987-78b0-91d1-7065b5ef2e05	SPX	2026-10-02 11:26	call_ratio_spread	2	1	12	31800.00	unknown	ask	7704.8200	0.2000	["7700","7705"]	["0.2134","0.2106"]	["7718.90"]	["XCBO"]	7700.0000	7705.0000	0	0	false	false	false
01a0fd38-a397-7830-bfff-2e5b94d9f89a	SPCX	2026-10-02 11:25	call_ratio_spread	2	1	12	25440.00	long	ask	156.0400	0.9000	["310","450"]	["0.5292","0.5365"]	["590.48"]	["XPHO"]	310.0000	450.0000	805	805	false	true	false	true
01a0fd38-9bc7-7443-ba8a-8c9f4f413d49	SPCX	2026-10-02 11:25	call_ratio_spread	2	2	12	25342.00	long	ask	156.0600	0.7500	["310","450"]	["0.5281","0.5359"]	["590.49"]	["AMXO","XISX"]	310.0000	450.0000	805	805	false	true	false
01a0fd38-97df-7061-ac01-c394fac3958d	SPCX	2026-10-02 11:25	call_ratio_spread	2	3	12	25198.00	long	ask	156.0703	0.9333	["310","450"]	["0.5267","0.5350"]	["590.49"]	["AMXO","XCBO","XISX"]	310.0000	450.0000	805	805	false	true	false
01a0fd38-900f-7461-a0eb-ddb6b2469a96	SPCX	2026-10-02 11:25	call_ratio_spread	2	1	12	25368.00	unknown	ask	156.1400	0.7000	["310","450"]	["0.5281","0.5358"]	["352.28"]	["EDGO"]	310.0000	450.0000	805	805	false	true	false
01a0fd38-900f-7461-a0eb-dda383992bf9	SPCX	2026-10-02 11:25	call_ratio_spread	2	1	12	25248.00	unknown	bid	156.1400	0.8500	["310","450"]	["0.5269","0.5350"]	["352.08"]	["XISX"]	310.0000	450.0000	805	805	false	true	false
01a0fd35-6b5f-7f00-beaf-67c653fe2c1b	SPY	2026-10-02 11:22	call_ratio_spread	2	1	380	59850.00	long	ask	768.4400	0.0300	["784","790"]	["0.1061","0.1040"]	["784.15","795.85"]	["ARCO"]	784.0000	790.0000	14	14	false	true	false
01a0fd31-9ad0-7263-8b14-28b8e3604c21	XLU	2026-10-02 11:17	call_ratio_spread	2	1	364	26572.00	long	ask	39.9350	0.0500	["41","43"]	["0.2058","0.2061"]	["41.22","44.78"]	["XMIO"]	41.0000	43.0000	49	49	false	true	false	true
01a0fd31-9ad0-7263-8b14-2890161ce5d6	XLU	2026-10-02 11:17	call_ratio_spread	2	2	458	32518.00	unknown	bid	39.9350	0.0500	["41","43"]	["0.2022","0.2036"]	["42.42"]	["ARCO","XPHO"]	41.0000	43.0000	49	49	false	true	false
01a0fd31-9ad0-7263-8b14-2887ba47448e	XLU	2026-10-02 11:17	call_ratio_spread	2	1	382	27122.00	unknown	bid	39.9350	0.0500	["41","43"]	["0.2022","0.2036"]	["42.42"]	["XISX"]	41.0000	43.0000	49	49	false	true	false	true
01a0fd30-ac87-7482-af1b-d9591583eeb7	STX	2026-10-02 11:16	call_ratio_spread	2	1	40	36700.00	long	ask	809.4050	13.2500	["1045","1250"]	["0.7866","0.8500"]	["1050.99","1449.01"]	["XCBO"]	1045.0000	1250.0000	28	28	true	true	false
01a0fd2d-31e7-7c82-808f-1bf67a1536e1	SPX	2026-10-02 11:13	call_ratio_spread	2	1	50	36725.00	long	ask	7711.7600	0.3500	["7725","7745"]	["0.1983","0.1889"]	["7727.65","7762.35"]	["XCBO"]	7725.0000	7745.0000	0	0	false	true	false
01a0fd2b-5557-76d1-afc5-8276d6b6f539	STX	2026-10-02 11:11	call_ratio_spread	2	1	2	35154.00	unknown	ask	810.8300	16.6000	["700","810"]	["0.7231","0.7244"]	["801.51"]	["BATO"]	700.0000	810.0000	35	35	false	false	false
01a0fd2b-228f-7bc0-8373-7f505c6ea429	SPX	2026-10-02 11:10	call_ratio_spread	2	1	2	31968.00	long	ask	7715.0300	1.8000	["8450","8955"]	["0.1351","0.1283"]	["8496.40","9413.60"]	["XCBO"]	8450.0000	8955.0000	271	271	false	true	false
01a0fd25-2f1f-7323-8536-b93a8550f11b	RUT	2026-10-02 11:04	call_ratio_spread	2	1	250	33750.00	unknown	ask	2841.8676	0.5500	["2980","3060"]	["0.1512","0.1668"]	["2983.38"]	["XCBO"]	2980.0000	3060.0000	14	14	false	true	false
01a0fd20-7fe7-7e42-b937-b80c22adbb2e	VIX	2026-10-02 10:59	call_ratio_spread	2	1	1000	80890.00	long	ask	15.5300	0.0900	["18","22"]	["1.4345","1.5974"]	["23.31"]	["XCBO"]	18.0000	22.0000	19	19	false	true	false	true
01a0fd20-1a57-7563-b978-2f2a41808953	SPX	2026-10-02 10:58	call_ratio_spread	2	1	3	25502.00	long	ask	7738.3200	1.8000	["9000","9600"]	["0.1346","0.1305"]	["9903.35"]	["XCBO"]	9000.0000	9600.0000	350	350	false	true	false	true
01a0fd1f-feff-7f41-aecf-f8f63a807f57	SPX	2026-10-02 10:58	call_ratio_spread	2	1	3	25516.00	long	ask	7739.1900	1.7000	["9000","9600"]	["0.1345","0.1304"]	["9903.40"]	["XCBO"]	9000.0000	9600.0000	350	350	false	true	false	true
01a0fd1c-a787-7151-8b24-dea1714c8556	XLV	2026-10-02 10:55	call_ratio_spread	2	1	96	50112.00	unknown	ask	166.1000	1.3100	["162","171"]	["0.1720","0.1621"]	["166.84"]	["BATO"]	162.0000	171.0000	14	14	false	false	false
01a0fd1c-9fb7-70e1-82a1-452278ba46dc	STX	2026-10-02 10:55	call_ratio_spread	2	2	24	85432.00	long	ask	800.0000	15.5000	["790","870"]	["0.7215","0.6907"]	["912.81"]	["ARCO","XPHO"]	790.0000	870.0000	14	14	false	false	false
01a0fd1a-cedf-7d81-86c6-8ea708996cca	VIX	2026-10-02 10:53	call_ratio_spread	2	2	2250	52050.00	unknown	—	15.5200	0.0500	["37","40"]	["2.0318","2.1404"]	[]	["XCBO"]	37.0000	40.0000	19	19	false	true	false	true	false	mfsl
01a0fd1a-888f-7d11-92d1-70c4606542ed	SPCX	2026-10-02 10:52	call_ratio_spread	2	1	14	30100.00	long	ask	157.6500	1.5500	["310","450"]	["0.5252","0.5341"]	["590.60"]	["XISX"]	310.0000	450.0000	805	805	false	true	false	true
01a0fd19-e867-77b2-bda7-6158714ee2f1	WDC	2026-10-02 10:52	call_ratio_spread	2	3	88	87950.00	long	ask	401.0555	1.0900	["500","650"]	["0.7365","0.7749"]	["509.00","791.00"]	["ARCO","XBOX","XISX"]	500.0000	650.0000	49	49	false	true	false
01a0fd19-bd6f-7d23-88eb-c69d3b544a83	WDC	2026-10-02 10:51	call_ratio_spread	2	1	30	30840.00	long	ask	402.0350	1.1100	["500","650"]	["0.7372","0.7794"]	["509","791.00"]	["XISX"]	500.0000	650.0000	49	49	false	true	false	true
01a0fd19-9a47-70b0-af04-332cfb78e489	WDC	2026-10-02 10:51	call_ratio_spread	2	1	26	27196.00	long	ask	402.4100	1.0500	["500","650"]	["0.7390","0.7829"]	["509","791.00"]	["XISX"]	500.0000	650.0000	49	49	false	true	false	true
01a0fd18-e697-77e0-add9-0877c39ec30e	SPCX	2026-10-02 10:51	call_ratio_spread	2	1	26	55926.00	long	ask	157.4100	1.0500	["310","450"]	["0.5264","0.5349"]	["590.58"]	["XISX"]	310.0000	450.0000	805	805	false	true	false	true
01a0fd18-dec7-7ac0-878a-4464b65e92a6	SPCX	2026-10-02 10:50	call_ratio_spread	2	1	32	68832.00	long	ask	157.4400	1.0500	["310","450"]	["0.5263","0.5348"]	["590.58"]	["XISX"]	310.0000	450.0000	805	805	false	true	false	true
01a0fd18-1791-7aa2-a39f-83feecb5d7fd	QQQ	2026-10-02 10:50	call_ratio_spread	2	3	24	25732.00	long	ask	753.2800	0.4200	["800","850"]	["0.1883","0.1834"]	["805.64","894.36"]	["EDGO","EMLD","SPHR"]	800.0000	850.0000	90	90	false	true	false
01a0fd18-1791-7aa2-a39f-839566725769	QQQ	2026-10-02 10:50	call_ratio_spread	2	8	32	34000.00	unknown	bid	753.2800	0.4200	["800","850"]	["0.1876","0.1827"]	["821.25"]	["ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XPHO"]	800.0000	850.0000	90	90	false	true	false
01a0fd17-f84f-7bb2-a50b-0b57a7dd0cf6	WDC	2026-10-02 10:49	call_ratio_spread	2	1	28	30240.00	unknown	bid	404.5799	1.2600	["500","650"]	["0.7343","0.7842"]	["521.60"]	["XISX"]	500.0000	650.0000	49	49	false	true	false
01a0fd17-cd57-74b3-8ece-22b90befa40f	WDC	2026-10-02 10:49	call_ratio_spread	2	1	50	53900.00	unknown	bid	404.4300	1.2700	["500","650"]	["0.7347","0.7842"]	["521.56"]	["XISX"]	500.0000	650.0000	49	49	false	true	false
01a0fd16-e6de-71b3-84e6-2af4f64a0432	SPX	2026-10-02 10:48	call_ratio_spread	2	2	100	48600.00	long	ask	7751.7900	0.2000	["7765","7790"]	["0.1484","0.1552"]	["7768.60","7822.10"]	["XCBO"]	7765.0000	7790.0000	0	0	false	true	false
01a0fd14-087f-7fc3-9704-e403161eb574	SPX	2026-10-02 10:45	call_ratio_spread	2	1	2	45442.00	long	ask	7749.3100	2.9000	["8325","8900"]	["0.1406","0.1302"]	["8399.30","9400.70"]	["XCBO"]	8325.0000	8900.0000	287	287	false	true	false
01a0fd13-ed27-7973-904a-4419ab08f633	SPX	2026-10-02 10:45	call_ratio_spread	2	1	2	45261.00	long	ask	7747.7800	2.2000	["8325","8900"]	["0.1405","0.1301"]	["8399.25","9400.75"]	["XCBO"]	8325.0000	8900.0000	287	287	false	true	false
01a0fd12-8d97-75d2-91f9-c4b2e8e5159f	WDC	2026-10-02 10:44	call_ratio_spread	2	1	78	88062.00	unknown	bid	408.4150	0.7500	["500","650"]	["0.7284","0.7768"]	["522.58"]	["ARCO"]	500.0000	650.0000	49	49	false	true	false
01a0fd12-8d97-75d2-91f9-c492d4c7032c	WDC	2026-10-02 10:44	call_ratio_spread	2	1	34	38250.00	long	ask	408.4150	0.9000	["500","650"]	["0.7276","0.7758"]	["509.50","790.50"]	["XMIO"]	500.0000	650.0000	49	49	false	true	false
01a0fd12-33be-75d3-85eb-dc4df69b7daa	SPX	2026-10-02 10:43	call_ratio_spread	2	2	1475	55460.00	unknown	ask	7748.5200	0.1500	["7885","7980"]	["0.0864","0.1214"]	["7885.38"]	["XCBO"]	7885.0000	7980.0000	3	3	false	true	false
01a0fd10-f36f-7561-947a-0424b63013ab	META	2026-10-02 10:42	call_ratio_spread	2	1	12	54008.00	unknown	ask	734.3900	0.8500	["750","1000"]	["0.4039","0.4126"]	["885.02"]	["XISX"]	750.0000	1000.0000	168	168	false	true	false
01a0fd10-8de0-7ed3-84f9-15d537e2ef1c	AMZN	2026-10-02 10:41	call_ratio_spread	2	1	20	62110.00	unknown	bid	252.2430	0.7000	["235","255"]	["0.3764","0.3663"]	["262.37"]	["XCBO"]	235.0000	255.0000	49	49	false	false	false
01a0fd0f-f586-7d23-a37b-568b4bbdbb18	STX	2026-10-02 10:41	call_ratio_spread	2	1	7	61064.00	long	ask	816.0001	20.2000	["800","1000"]	["0.7252","0.7350"]	["838.88","1214.83"]	["XMIO"]	800.0000	1000.0000	49	49	false	false	false
01a0fd0b-2710-7ab2-80e4-213e5396feb4	AVGO	2026-10-02 10:35	call_ratio_spread	2	1	10	51700.00	unknown	ask	356.9051	0.9000	["350","360"]	["0.4017","0.4029"]	["380.80"]	["ARCO"]	350.0000	360.0000	105	105	false	false	false
01a0fd0a-f05f-7821-9cc6-d7a8e4ebb698	SPCX	2026-10-02 10:35	call_ratio_spread	2	1	16	34408.00	long	ask	157.5650	1.5500	["310","450"]	["0.5257","0.5344"]	["590.59"]	["XCBO"]	310.0000	450.0000	805	805	false	true	false	true
01a0fd0a-f05f-7821-9cc6-d79a19738cdd	SPCX	2026-10-02 10:35	call_ratio_spread	2	2	22	47335.00	long	ask	157.5650	1.5500	["310","450"]	["0.5258","0.5345"]	["590.59"]	["EDGO","MCRY"]	310.0000	450.0000	805	805	false	true	false
01a0fd0a-f05f-7821-9cc6-d78d6e17cccd	SPCX	2026-10-02 10:35	call_ratio_spread	2	1	16	34072.00	unknown	bid	157.5650	1.5500	["310","450"]	["0.5233","0.5328"]	["352.59"]	["AMXO"]	310.0000	450.0000	805	805	false	true	false
01a0fd0a-f05f-7821-9cc6-d77d134ae34d	SPCX	2026-10-02 10:35	call_ratio_spread	2	2	22	47495.00	long	ask	157.5650	1.5500	["310","450"]	["0.5266","0.5350"]	["590.59"]	["MCRY","XPHO"]	310.0000	450.0000	805	805	false	true	false
01a0fd0a-f05f-7821-9cc6-d760f4c570e9	SPCX	2026-10-02 10:35	call_ratio_spread	2	1	16	34376.00	long	ask	157.5650	1.5500	["310","450"]	["0.5255","0.5342"]	["590.59"]	["XMIO"]	310.0000	450.0000	805	805	false	true	false	true