Multi-leg option trades

core.multileg_trades

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

473,794 rowsCSV — whole table, not this view

Sources in this table

uw_multileg473,794 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:net_side = ask×strategy = call_ratio_spread×ticker = SMH×

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

01a0d447-8f56-7420-84af-ef96b3ba0aa3	SMH	2026-09-24 12:37	call_ratio_spread	2	2	40	41960.00	long	ask	599.3250	0.7750	["610","630"]	["0.3152","0.3118"]	["611.10","648.90"]	["XISX","XPHO"]	610.0000	630.0000	15	15	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-24T16:37:46Z"}	2026-09-24	2026-09-24 17:15	2026-09-24 17:15
01a0d446-899f-7fa2-ae4a-5f13333efb95	SMH	2026-09-24 12:36	call_ratio_spread	2	2	40	30560.00	long	ask	598.4800	0.6500	["605","622.5"]	["0.3205","0.3169"]	["607.0","638.00"]	["XISX","XPHO"]	605.0000	622.5000	8	8	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
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
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-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-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
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
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
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