Multi-leg option trades

core.multileg_trades

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

438,407 rowsCSV — whole table, not this view

Sources in this table

uw_multileg438,407 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:source = uw_multileg×strategy = call_ratio_spread×ticker = SMH×

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

01a0cefc-1f26-71d1-989b-29e0ca267b4b	SMH	2026-09-23 11:57	call_ratio_spread	2	1	500	77750.00	unknown	bid	597.7750	0.2000	["605","625"]	["0.3087","0.3368"]	["608.11"]	["XBOX"]	605.0000	625.0000	2	2	false	true	false	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-23T15:57:11Z"}	2026-09-23	2026-09-23 17:15	2026-09-23 17:15
01a0cec5-c12f-7be3-9b47-606319a89bed	SMH	2026-09-23 10:57	call_ratio_spread	2	1	10	73850.00	unknown	—	600.0800	5.2000	["560","610"]	["0.3760","0.3564"]	[]	["XISX"]	560.0000	610.0000	86	86	false	false	false	true	false
01a0ce92-7c2f-7150-b0f8-b8dc63bb47ad	SMH	2026-09-23 10:01	call_ratio_spread	2	1	500	125500.00	long	ask	601.3500	0.5300	["605","625"]	["0.3181","0.3472"]	["608.14","641.86"]	["XMIO"]	605.0000	625.0000	2	2	false	true	false
01a0ca98-f7cf-7d01-8248-f114e8369d6f	SMH	2026-09-22 15:30	call_ratio_spread	2	1	177	129741.00	long	ask	606.5000	0.8700	["605","620"]	["0.3110","0.3114"]	["609.40","641.21"]	["EDGO"]	605.0000	620.0000	3	3	false	false	false
01a0ca98-effe-7693-ad4e-72b7620d6f2e	SMH	2026-09-22 15:30	call_ratio_spread	2	1	45	32205.00	long	ask	606.2800	0.6600	["605","620"]	["0.3094","0.3102"]	["609.34","641.31"]	["XPHO"]	605.0000	620.0000	3	3	false	false	false
01a0ca1a-51ef-7592-9b4f-c3f6762ccaab	SMH	2026-09-22 13:11	call_ratio_spread	2	2	130	1251300.00	unknown	ask	604.3100	4.3000	["530","580"]	["0.3849","0.3457"]	["612.67"]	["AMXO"]	530.0000	580.0000	24	24	false	false	false
01a0c98a-98f7-7b90-a842-001a75d6c8d7	SMH	2026-09-22 10:34	call_ratio_spread	2	2	40	41000.00	long	ask	603.4899	0.8500	["605","635"]	["0.3417","0.3421"]	["610.90","659.10"]	["XISX","XPHO"]	605.0000	635.0000	10	10	false	true	false
01a0c573-5b36-71e2-a7c0-4dbd9d99fe39	SMH	2026-09-21 15:31	call_ratio_spread	2	1	1500	2206250.00	unknown	ask	596.6830	1.2000	["660","730"]	["0.3561","0.3536"]	["704.12"]	["XBOX"]	660.0000	730.0000	88	88	false	true	false
01a0c56e-2b17-7341-b4e0-7d38beff7f09	SMH	2026-09-21 15:25	call_ratio_spread	2	1	12	48732.00	long	ask	596.6100	4.3500	["565","575"]	["0.4381","0.3730"]	["599.50"]	["XISX"]	565.0000	575.0000	4	4	false	false	false
01a0c566-478f-75e3-bde3-f66e285fdc91	SMH	2026-09-21 15:16	call_ratio_spread	2	1	90	218190.00	long	ask	596.7000	1.2000	["595","630"]	["0.3367","0.3340"]	["603.86","682.29"]	["EDGO"]	595.0000	630.0000	25	25	false	false	false
01a0c564-99de-74d2-98b1-f440b1eaabb1	SMH	2026-09-21 15:14	call_ratio_spread	2	1	10	40865.00	unknown	ask	596.4450	5.0500	["565","575"]	["0.4574","0.3948"]	["598.91"]	["XBOX"]	565.0000	575.0000	4	4	false	false	false
01a0c4eb-a8ef-7fc2-af3e-52b50623ff96	SMH	2026-09-21 13:02	call_ratio_spread	2	2	40	25420.00	long	ask	593.6400	0.3500	["605","635"]	["0.3226","0.3220"]	["609.75","660.25"]	["XISX","XPHO"]	605.0000	635.0000	11	11	false	true	false
01a0c4d1-4aef-70c1-9269-63c3b1b85f98	SMH	2026-09-21 12:34	call_ratio_spread	2	1	150	440641.00	unknown	—	593.1000	1.1000	["590","615"]	["0.3313","0.3290"]	[]	["XISX"]	590.0000	615.0000	25	25	false	false	false	true	false
01a0c48a-7236-7ec1-ae1a-ca37e6309cb7	SMH	2026-09-21 11:16	call_ratio_spread	2	1	32	27184.00	unknown	bid	590.5700	0.4000	["625","650"]	["0.3354","0.3379"]	["641.99"]	["XCBO"]	625.0000	650.0000	25	25	false	true	false
01a0c485-941e-7d43-bb62-3831aa5b9ea5	SMH	2026-09-21 11:11	call_ratio_spread	2	1	15	71020.00	unknown	bid	590.3850	2.6000	["600","650"]	["0.3609","0.3483"]	["658.41"]	["ARCO"]	600.0000	650.0000	88	88	false	true	false
01a0c45b-1d06-7d42-bcaa-a252f5516b2d	SMH	2026-09-21 10:24	call_ratio_spread	2	1	12	28016.00	unknown	ask	585.9313	1.4000	["580","610"]	["0.3344","0.3287"]	["615.56"]	["XPHO"]	580.0000	610.0000	25	25	false	false	false
01a0c458-c75f-7e63-bf48-f9f17621c40e	SMH	2026-09-21 10:22	call_ratio_spread	2	1	4	107120.00	unknown	—	585.1500	8.4000	["425","585"]	["0.3960","0.3661"]	[]	["XMIO"]	425.0000	585.0000	487	487	false	false	false	true	false
01a0c443-ff0f-7132-9084-ef1844128297	SMH	2026-09-21 09:59	call_ratio_spread	2	1	35	33075.00	unknown	ask	584.3200	0.5000	["620","650"]	["0.3300","0.3326"]	["624.19","753.25"]	["XPHO"]	620.0000	650.0000	25	25	false	true	false
01a0c443-d416-74c2-9ee9-e79948f4821f	SMH	2026-09-21 09:59	call_ratio_spread	2	1	30	28302.00	unknown	ask	584.2000	0.5000	["620","650"]	["0.3305","0.3328"]	["624.19","753.23"]	["XMIO"]	620.0000	650.0000	25	25	false	true	false
01a0c443-997f-7ae3-9215-4e1d4008c6f8	SMH	2026-09-21 09:59	call_ratio_spread	2	1	35	32963.00	unknown	ask	584.2950	0.6000	["620","650"]	["0.3296","0.3324"]	["624.17","753.31"]	["C2OX"]	620.0000	650.0000	25	25	false	true	false
01a0c443-532f-7e63-a3e1-91e511d7d1f8	SMH	2026-09-21 09:58	call_ratio_spread	2	1	45	42930.00	unknown	—	584.5500	0.4500	["620","650"]	["0.3298","0.3333"]	[]	["C2OX"]	620.0000	650.0000	25	25	false	true	false	true	false
01a0c443-14af-7de1-ae05-0690e9f78595	SMH	2026-09-21 09:58	call_ratio_spread	2	1	45	42930.00	unknown	ask	584.5650	0.2000	["620","650"]	["0.3297","0.3332"]	["624.18","753.30"]	["C2OX"]	620.0000	650.0000	25	25	false	true	false
01a0c442-f56f-7ee0-99fa-f9f35f32bea6	SMH	2026-09-21 09:58	call_ratio_spread	2	1	45	42750.00	unknown	bid	584.6600	0.4500	["620","650"]	["0.3290","0.3319"]	["631.88"]	["C2OX"]	620.0000	650.0000	25	25	false	true	false
01a0c442-7487-72c2-b614-98a2e8067493	SMH	2026-09-21 09:58	call_ratio_spread	2	1	35	33432.00	unknown	ask	584.7300	0.4500	["620","650"]	["0.3291","0.3325"]	["631.94"]	["MCRY"]	620.0000	650.0000	25	25	false	true	false
01a0c442-3dd6-77a3-ba17-002b2be97d3b	SMH	2026-09-21 09:57	call_ratio_spread	2	1	45	42660.00	unknown	—	584.4950	0.5500	["620","650"]	["0.3296","0.3322"]	[]	["EMLD"]	620.0000	650.0000	25	25	false	true	false	true	false
01a0c441-7a87-7250-8a1a-b2b53f618274	SMH	2026-09-21 09:56	call_ratio_spread	2	1	30	27624.00	unknown	bid	584.4700	0.6100	["620","650"]	["0.3260","0.3285"]	["631.51"]	["XBOX"]	620.0000	650.0000	25	25	false	true	false
01a0b619-8adf-7530-ae33-1e6c078ab346	SMH	2026-09-18 15:58	call_ratio_spread	2	2	200	43940.00	unknown	ask	572.4150	0.3900	["575","582.5"]	["0.1842","0.1892"]	["579.39"]	["EDGO","XBOX"]	575.0000	582.5000	3	3	false	true	false
01a0b4d8-f877-7142-8090-b633bd8db0f2	SMH	2026-09-18 10:08	call_ratio_spread	2	2	1000	1653500.00	unknown	bid	564.4400	1.9500	["565","600"]	["0.3048","0.2968"]	["598.07"]	["AMXO"]	565.0000	600.0000	28	28	false	true	false
01a0b054-ef6b-7cf2-a940-da3e0fc75ba1	SMH	2026-09-17 13:05	call_ratio_spread	2	1	12	25710.00	unknown	—	561.0900	1.3000	["560","585"]	["0.3146","0.3098"]	[]	["EMLD"]	560.0000	585.0000	29	29	false	false	false	true	false
01a0afe2-a59a-7991-897c-3e03d14e833f	SMH	2026-09-17 11:00	call_ratio_spread	2	1	39	38688.00	unknown	—	559.1000	0.4000	["595","620"]	["0.3148","0.3123"]	[]	["EDGO"]	595.0000	620.0000	29	29	false	true	false	true	false
01a0afe2-a59a-7991-897c-3dfabeaa62d2	SMH	2026-09-17 11:00	call_ratio_spread	2	1	36	35784.00	unknown	—	559.1000	0.3500	["595","620"]	["0.3150","0.3127"]	[]	["EDGO"]	595.0000	620.0000	29	29	false	true	false	true	false
01a0a681-71bd-7163-bba4-3d163497c8ae	SMH	2026-09-15 15:18	call_ratio_spread	2	1	6	50184.00	long	ask	541.5700	7.1000	["800","850"]	["0.3577","0.3562"]	["943.40"]	["XCBO"]	800.0000	850.0000	822	822	false	true	false
01a0a624-368e-7d10-b432-30faedb5c179	SMH	2026-09-15 13:36	call_ratio_spread	2	1	4	59394.00	unknown	—	540.9850	3.9500	["430","540"]	["0.3919","0.3489"]	[]	["AMXO"]	430.0000	540.0000	122	122	false	false	false	true	false
01a0a59d-999e-7d52-b89b-c3c7032c9351	SMH	2026-09-15 11:09	call_ratio_spread	2	1	1500	15412000.00	unknown	—	542.8200	7.8000	["560","760"]	["0.3654","0.3483"]	[]	["ARCO"]	560.0000	760.0000	493	493	true	true	false	true	false
01a0a55e-8916-7333-9c33-77c53b5dbcc2	SMH	2026-09-15 10:00	call_ratio_spread	2	2	68	48144.00	long	ask	546.7400	0.4750	["580","610"]	["0.3087","0.3058"]	["582.40","637.60"]	["XISX","XPHO"]	580.0000	610.0000	31	31	false	true	false
01a081bd-e710-7f63-81c5-57e9af4104df	SMH	2026-09-08 11:58	call_ratio_spread	2	1	38	84816.00	long	ask	577.8500	2.1500	["805","860"]	["0.3598","0.3589"]	["921.84"]	["AMXO"]	805.0000	860.0000	282	282	false	true	false
01a06df1-54c5-75d3-8ed1-08a990dd248e	SMH	2026-09-04 15:42	call_ratio_spread	2	1	60	186020.00	long	ask	565.3500	2.6000	["550","600"]	["0.3413","0.3326"]	["559.14","640.86"]	["XMIO"]	550.0000	600.0000	42	42	false	false	false
01a06dba-896d-7b30-884a-ab16fb78c0b8	SMH	2026-09-04 14:42	call_ratio_spread	2	1	54	158724.00	long	ask	564.8000	1.9500	["560","610"]	["0.3342","0.3255"]	["574.29","681.42"]	["AMXO"]	560.0000	610.0000	42	42	false	false	false