Multi-leg option trades

core.multileg_trades

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

508,354 rowsCSV — whole table, not this view

Sources in this table

uw_multileg508,354 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:strategy = risk_reversal×ticker = SMH×sorted by executed_at ↑×

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

01a08b93-a9f0-72b2-b87e-bb6d4c624c8c	SMH	2026-09-10 09:48	risk_reversal	2	4	79	484665.00	short	ask	560.0700	1.6500	["520","675"]	["0.3855","0.3554"]	["507.45"]	["ARCO","EDGO","SPHR","XBOX"]	520.0000	675.0000	190	190	false	true	false	true	true	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-10T13:48:34Z"}	2026-09-10	2026-09-10 17:15	2026-09-10 17:15
01a08b9b-85a8-7932-a205-7fe830609536	SMH	2026-09-10 09:56	risk_reversal	2	3	97	592185.00	long	bid	558.3000	2.8000	["520","675"]	["0.3808","0.3579"]	["507.37"]	["ARCO","MCRY","XBOX"]	520.0000	675.0000	190	190	false	true	false	true
01a08ba6-3fc0-73f3-9cf1-656aae404dea	SMH	2026-09-10 10:08	risk_reversal	2	5	142	1162270.00	short	ask	559.0200	2.8500	["525","700"]	["0.3875","0.3631"]	["508.04"]	["AMXO","ARCO","EDGO","XBOX"]	525.0000	700.0000	280	280	false	true	false	true
01a08bb2-ce98-7473-babe-7482a9630b04	SMH	2026-09-10 10:22	risk_reversal	2	1	22	135190.00	short	ask	560.3062	1.2000	["520","675"]	["0.3867","0.3549"]	["507.35"]	["XBOX"]	520.0000	675.0000	190	190	false	true	false	true
01a08bb2-ce98-7473-babe-7475cbf0b96c	SMH	2026-09-10 10:22	risk_reversal	2	1	6	36870.00	short	ask	560.2500	0.7000	["520","675"]	["0.3867","0.3551"]	["507.35"]	["XBOX"]	520.0000	675.0000	190	190	false	true	false	true
01a08bb2-de38-7490-a110-613ae5534630	SMH	2026-09-10 10:22	risk_reversal	2	2	5	30725.00	long	bid	560.3700	0.6000	["520","675"]	["0.3858","0.3558"]	["507.64"]	["ARCO","XCBO"]	520.0000	675.0000	190	190	false	true	false	true
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	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	true
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	true
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	mlet
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	true
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	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	true
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	mlet
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true