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:source = uw_multileg×strategy = risk_reversal×ticker = SMH×

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

01a0ee6c-a11f-7940-8bb9-2f0d98b6e2ab	SMH	2026-09-29 14:28	risk_reversal	2	1	20	54660.00	long	ask	607.8300	2.2500	["530","695"]	["0.4029","0.3543"]	["695.69"]	["XCBO"]	530.0000	695.0000	80	80	false	true	false	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T18:28:17Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0ee6c-1c4f-7000-b8b7-e09da7bf9422	SMH	2026-09-29 14:27	risk_reversal	2	1	20	54740.00	long	ask	607.6150	2.3000	["530","695"]	["0.4016","0.3560"]	["695.85"]	["XCBO"]	530.0000	695.0000	80	80	false	true	false
01a0e971-c5d7-7a01-b385-06ebd45be5ad	SMH	2026-09-28 15:15	risk_reversal	2	1	2	38628.00	short	ask	600.7200	7.5000	["600","710"]	["0.4020","0.3718"]	["598.88"]	["XPHO"]	600.0000	710.0000	627	627	false	true	false
01a0e919-16b7-7513-8041-0c00049bf195	SMH	2026-09-28 13:38	risk_reversal	2	1	5	37250.00	long	bid	601.4300	1.3000	["500","900"]	["0.4100","0.3609"]	["485.80"]	["ARCO"]	500.0000	900.0000	445	445	false	true	false
01a0e917-9fb7-7151-9666-d2d76fa49f5c	SMH	2026-09-28 13:37	risk_reversal	2	1	10	74500.00	long	bid	601.8800	1.9500	["500","900"]	["0.4099","0.3609"]	["486.02"]	["ARCO"]	500.0000	900.0000	445	445	false	true	false
01a0e914-7eef-7301-8f88-1c2e17557d8d	SMH	2026-09-28 13:33	risk_reversal	2	3	4	29776.00	long	bid	601.7000	1.9500	["500","900"]	["0.4111","0.3596"]	["485.42"]	["ARCO","C2OX","XISX"]	500.0000	900.0000	445	445	false	true	false
01a0e914-7b06-7cc0-b953-04670d6fcade	SMH	2026-09-28 13:33	risk_reversal	2	3	9	66969.00	long	bid	601.7000	2.0500	["500","900"]	["0.4113","0.3592"]	["485.29"]	["ARCO","C2OX","EDGO"]	500.0000	900.0000	445	445	false	true	false
01a0e914-7b06-7cc0-b953-04559fd31208	SMH	2026-09-28 13:33	risk_reversal	2	1	8	59520.00	long	bid	601.7000	1.5000	["500","900"]	["0.4123","0.3582"]	["484.88"]	["ARCO"]	500.0000	900.0000	445	445	false	true	false
01a0e90f-23d6-7521-b243-846a84787c81	SMH	2026-09-28 13:27	risk_reversal	2	2	9	67005.00	long	bid	600.7200	0.9000	["500","900"]	["0.4100","0.3607"]	["485.40"]	["EDGO","XBOX"]	500.0000	900.0000	445	445	false	true	false
01a0e90e-164e-75c2-919c-aad86f880e98	SMH	2026-09-28 13:26	risk_reversal	2	2	8	59496.00	short	ask	601.0800	1.2000	["500","900"]	["0.4110","0.3594"]	["485.10"]	["ARCO","EDGO"]	500.0000	900.0000	445	445	false	true	false
01a0e90d-9d37-76d3-a0de-8cb4e8cbb091	SMH	2026-09-28 13:26	risk_reversal	2	3	7	52150.00	short	ask	601.2100	2.1000	["500","900"]	["0.4112","0.3598"]	["485.21"]	["AMXO","ARCO","XISX"]	500.0000	900.0000	445	445	false	true	false
01a0e90c-3da6-71a0-9b24-4b9aa001f789	SMH	2026-09-28 13:24	risk_reversal	2	3	7	52150.00	short	ask	601.3650	2.3357	["500","900"]	["0.4112","0.3598"]	["485.28"]	["AMXO","ARCO","EDGO"]	500.0000	900.0000	445	445	false	true	false
01a0e908-af7f-72d2-894b-c7eb45cebb2b	SMH	2026-09-28 13:20	risk_reversal	2	3	5	37250.00	long	bid	601.2799	4.5650	["500","900"]	["0.4085","0.3623"]	["486.30"]	["ARCO","EDGO","XCBO"]	500.0000	900.0000	445	445	false	true	false
01a0e906-3a97-7d32-955c-56c5d8fe3bb0	SMH	2026-09-28 13:18	risk_reversal	2	4	13	96837.00	long	bid	602.0000	5.4385	["500","900"]	["0.4064","0.3641"]	["487.46"]	["C2OX","SPHR","XBOX","XISX"]	500.0000	900.0000	445	445	false	true	false
01a0e884-4126-7141-a942-8078c570d3e6	SMH	2026-09-28 10:56	risk_reversal	3	5	47	274032.00	long	ask	593.6001	3.7000	["500","555","605"]	["0.4565","0.3659","0.3232"]	["586.31"]	["ARCO","C2OX","EDGO","XCBO"]	500.0000	605.0000	18	18	false	false	false
01a0d9a8-fc6f-7f70-96d9-8232cc5fb897	SMH	2026-09-25 13:42	risk_reversal	2	1	10	36360.00	short	ask	607.3900	1.4000	["575","660"]	["0.3832","0.3581"]	["571.14"]	["XCBO"]	575.0000	660.0000	56	56	false	true	false
01a0d4f5-4fcf-7a91-aa7f-574ac422083a	SMH	2026-09-24 15:47	risk_reversal	2	1	1000	2519000.00	long	bid	599.7800	0.7500	["550","675"]	["0.3851","0.3556"]	["546.39"]	["ARCO"]	550.0000	675.0000	57	57	false	true	false
01a0d44c-ea6f-7c63-adc9-58dbafe29d0f	SMH	2026-09-24 12:43	risk_reversal	2	2	13	96785.00	long	bid	601.0650	1.2846	["500","900"]	["0.4103","0.3574"]	["485.08"]	["ARCO","XBOX"]	500.0000	900.0000	449	449	false	true	false
01a0d447-1a27-7bc2-90c9-d316cfd473e4	SMH	2026-09-24 12:37	risk_reversal	2	1	7	52150.00	long	bid	599.0600	2.1000	["500","900"]	["0.4102","0.3580"]	["484.30"]	["XBOX"]	500.0000	900.0000	449	449	false	true	false
01a0d441-ea07-7713-8013-4d06f7822368	SMH	2026-09-24 12:31	risk_reversal	2	1	15	111225.00	long	bid	597.1700	2.7000	["500","900"]	["0.4078","0.3588"]	["484.05"]	["XBOX"]	500.0000	900.0000	449	449	false	true	false
01a0d43e-446e-79c0-b566-256e9c8d5fbf	SMH	2026-09-24 12:27	risk_reversal	2	1	30	384030.00	short	ask	596.6000	8.0000	["605","740"]	["0.3935","0.3552"]	["568.53"]	["ARCO"]	605.0000	740.0000	358	358	false	false	false
01a0ca51-389e-7f93-8d60-257fe70139ce	SMH	2026-09-22 14:11	risk_reversal	2	1	26	59410.00	long	bid	605.0450	0.1000	["587.5","630"]	["0.3321","0.3221"]	["586.15"]	["XISX"]	587.5000	630.0000	24	24	false	true	false
01a0ca51-389e-7f93-8d60-25210137b77e	SMH	2026-09-22 14:11	risk_reversal	2	1	38	86830.00	long	bid	605.0450	0.1000	["587.5","630"]	["0.3321","0.3221"]	["586.15"]	["XISX"]	587.5000	630.0000	24	24	false	true	false
01a0ca50-cb3f-74d3-9bb8-a112635017bd	SMH	2026-09-22 14:11	risk_reversal	2	3	65	149175.00	short	ask	604.9850	0.6800	["587.5","630"]	["0.3342","0.3218"]	["585.97"]	["AMXO","XCBO","XPHO"]	587.5000	630.0000	24	24	false	true	false
01a0c54c-89b7-71f1-a76c-e1f320743855	SMH	2026-09-21 14:48	risk_reversal	2	2	8	31674.00	long	bid	595.3500	0.4000	["555","725"]	["0.3751","0.3444"]	["538.74"]	["EDGO","XISX"]	555.0000	725.0000	116	116	false	true	false
01a0c54c-89b7-71f1-a76c-e1e79210db7b	SMH	2026-09-21 14:48	risk_reversal	2	3	11	43536.00	long	bid	595.3500	0.4000	["555","725"]	["0.3751","0.3442"]	["538.72"]	["AMXO","EDGO","XISX"]	555.0000	725.0000	116	116	false	true	false
01a0c54c-7dff-78a2-93ef-247f9749b04d	SMH	2026-09-21 14:48	risk_reversal	2	2	8	31512.00	short	ask	595.3700	0.9000	["555","725"]	["0.3752","0.3421"]	["538.52"]	["AMXO","ARCO"]	555.0000	725.0000	116	116	false	true	false
01a0c54c-7dff-78a2-93ef-245fc4796546	SMH	2026-09-21 14:48	risk_reversal	2	3	8	31517.00	short	ask	595.3700	0.9000	["555","725"]	["0.3753","0.3420"]	["538.49"]	["AMXO","ARCO"]	555.0000	725.0000	116	116	false	true	false
01a0c542-8b1e-7a72-a330-23ea187c0bb5	SMH	2026-09-21 14:37	risk_reversal	2	2	50	156250.00	short	ask	594.9000	0.3000	["560","665"]	["0.3767","0.3541"]	["553.19"]	["EDGO","XISX"]	560.0000	665.0000	60	60	false	true	false
01a0c488-2077-7e02-bec5-39efb7b5c752	SMH	2026-09-21 11:14	risk_reversal	3	1	8	84464.00	long	bid	590.9000	5.1500	["530","660","860"]	["0.3870","0.3540","0.3445"]	["529.88"]	["C2OX"]	530.0000	860.0000	269	269	false	true	false
01a0c47e-411e-79d2-8c8c-0c96e45cf9e8	SMH	2026-09-21 11:03	risk_reversal	3	2	4	30302.00	long	ask	589.5500	4.6000	["520","560","570"]	["0.4023","0.3464","0.3389"]	["564"]	["XISX"]	520.0000	570.0000	25	25	false	false	false
01a0b5a8-5e37-7403-9204-98783bdfd62e	SMH	2026-09-18 13:55	risk_reversal	2	2	500	2092500.00	long	bid	564.5400	1.6500	["550","605"]	["0.3554","0.3370"]	["543.29"]	["AMXO"]	550.0000	605.0000	63	63	false	true	false
01a0b4b9-4347-7663-8256-41e7a5907da2	SMH	2026-09-18 09:33	risk_reversal	2	1	24	31632.00	short	bid	564.3050	4.9500	["400","750"]	["0.4297","0.3319"]	["751.20"]	["XCBO"]	400.0000	750.0000	154	154	false	true	false
01a0b0b4-ce63-70c1-9042-b5fa7730730a	SMH	2026-09-17 14:50	risk_reversal	2	3	43	158842.00	long	ask	561.1200	0.6000	["560","565"]	["0.3120","0.3125"]	["565.49"]	["ARCO","XBOX","XCBO"]	560.0000	565.0000	29	29	false	true	false
01a0b0b4-5d1a-71d3-b1e4-32852182d33a	SMH	2026-09-17 14:50	risk_reversal	2	2	31	114545.00	long	ask	561.1400	0.6387	["560","565"]	["0.3115","0.3132"]	["565.58"]	["XBOX","XCBO"]	560.0000	565.0000	29	29	false	true	false
01a0b0a3-4a03-7231-8cbe-adf4f6424053	SMH	2026-09-17 14:31	risk_reversal	2	1	19	69920.00	short	bid	561.4700	0.4500	["560","565"]	["0.3126","0.3095"]	["565.60"]	["ARCO"]	560.0000	565.0000	29	29	false	true	false
01a0afec-88db-7752-bafa-2bd6d0ac5ff3	SMH	2026-09-17 11:11	risk_reversal	2	1	62	432760.00	long	bid	559.6450	3.1500	["565","585"]	["0.3527","0.3469"]	["556.52"]	["XPHO"]	565.0000	585.0000	92	92	false	false	false
01a0a660-ca5e-7382-94cf-8c542df7e575	SMH	2026-09-15 14:42	risk_reversal	2	2	280	1211000.00	short	bid	541.3700	2.2000	["515","565"]	["0.3682","0.3439"]	["568.41"]	["AMXO"]	515.0000	565.0000	66	66	false	true	false
01a0a5ca-0c85-7de1-8aaf-807d6dd4f542	SMH	2026-09-15 11:57	risk_reversal	2	1	10	27650.00	short	ask	542.2600	0.1000	["500","600"]	["0.3748","0.3390"]	["497.75"]	["XBOX"]	500.0000	600.0000	66	66	false	true	false
01a0a5b6-3e36-77e2-baa9-63ec633f62eb	SMH	2026-09-15 11:36	risk_reversal	2	2	285	1239750.00	short	bid	543.0300	2.6000	["515","565"]	["0.3705","0.3425"]	["569.36"]	["AMXO"]	515.0000	565.0000	66	66	false	true	false
01a0a16b-f2f0-7cf2-b80f-0227c014f694	SMH	2026-09-14 15:36	risk_reversal	2	1	124	60512.00	short	ask	542.5800	0.6500	["405","800"]	["0.4348","0.3568"]	["401.76"]	["AMXO"]	405.0000	800.0000	95	95	false	true	false
01a0a115-3fa0-74a3-81e2-ca008f43a205	SMH	2026-09-14 14:01	risk_reversal	2	1	13	26585.00	short	ask	544.9700	0.2500	["520","575"]	["0.3450","0.3137"]	["518.79"]	["XPHO"]	520.0000	575.0000	32	32	false	true	false
01a0a115-37d0-7832-b576-5e482a4406a7	SMH	2026-09-14 14:01	risk_reversal	2	2	30	61350.00	unknown	—	544.9750	0.2500	["520","575"]	["0.3444","0.3142"]	[]	["XISX","XPHO"]	520.0000	575.0000	32	32	false	true	false	true	true
01a0a113-b518-7103-88f2-5e95a114184d	SMH	2026-09-14 14:00	risk_reversal	2	1	13	26507.00	long	bid	545.4600	0.1000	["520","575"]	["0.3446","0.3127"]	["519.05"]	["XPHO"]	520.0000	575.0000	32	32	false	true	false
01a0a110-9c20-7871-9f86-df65075e296c	SMH	2026-09-14 13:56	risk_reversal	2	1	13	26325.00	short	ask	545.4600	0.1000	["520","575"]	["0.3430","0.3121"]	["519.09"]	["XPHO"]	520.0000	575.0000	32	32	false	true	false
01a0a110-03c8-7f62-967f-f217adcd4fec	SMH	2026-09-14 13:56	risk_reversal	2	2	18	36180.00	long	bid	545.2500	0.2500	["520","575"]	["0.3414","0.3109"]	["519"]	["XISX","XPHO"]	520.0000	575.0000	32	32	false	true	false
01a0a10f-c548-7270-baee-eab6fc16139d	SMH	2026-09-14 13:55	risk_reversal	2	1	14	28014.00	unknown	—	545.3350	0.6500	["520","575"]	["0.3420","0.3087"]	[]	["AMXO"]	520.0000	575.0000	32	32	false	true	false	true	true
01a08cd4-7308-7962-aa87-c8434d3be485	SMH	2026-09-10 15:38	risk_reversal	2	1	20	38600.00	short	bid	561.6900	0.4000	["520","600"]	["0.3698","0.3326"]	["601.28"]	["XPHO"]	520.0000	600.0000	36	36	false	true	false
01a08cd4-6f20-7142-b41c-7f7b2fd6651b	SMH	2026-09-10 15:38	risk_reversal	2	3	19	36665.00	short	bid	561.6100	0.4000	["520","600"]	["0.3694","0.3330"]	["601.29"]	["C2OX","EDGO","XMIO"]	520.0000	600.0000	36	36	false	true	false
01a08bb8-02a0-7420-98a0-df077a239316	SMH	2026-09-10 10:28	risk_reversal	2	3	9	55305.00	long	bid	561.8150	2.3833	["520","675"]	["0.3860","0.3557"]	["508.48"]	["ARCO","MCRY","XBOX"]	520.0000	675.0000	190	190	false	true	false