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:net_side = bid×strategy = put_ratio_spread×ticker = SMH×

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

01a0ee96-2607-71a2-977a-f3b50a472f6b	SMH	2026-09-29 15:13	put_ratio_spread	2	5	26	60393.00	unknown	bid	607.7800	1.0500	["480","570"]	["0.4211","0.3822"]	["401.95","558.05"]	["AMXO","ARCO","XBOX","XCBO","XPHO"]	480.0000	570.0000	108	108	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T19:14:05Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0ee76-22b7-7991-aab3-3f5862ed4255	SMH	2026-09-29 14:38	put_ratio_spread	2	1	16	37304.00	unknown	bid	607.9200	1.8000	["480","570"]	["0.4221","0.3831"]	["523.37"]	["XISX"]	480.0000	570.0000	108	108	false	true	false
01a0ee53-b637-7a83-ae13-95f7fdcf98d1	SMH	2026-09-29 14:00	put_ratio_spread	2	4	40	94140.00	unknown	bid	607.2800	1.5000	["480","570"]	["0.4224","0.3835"]	["522.93"]	["AMXO","MCRY","XCBO","XPHO"]	480.0000	570.0000	108	108	false	true	false
01a0ee16-b8ef-7353-85c1-5870dc923041	SMH	2026-09-29 12:54	put_ratio_spread	2	7	32	33288.00	unknown	bid	606.7400	0.6600	["550","605"]	["0.3805","0.3280"]	["584.20"]	["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"]	550.0000	605.0000	17	17	false	true	false
01a0eda9-1e57-7a42-9f11-4f02f8d1043f	SMH	2026-09-29 10:54	put_ratio_spread	2	1	10	37440.00	unknown	bid	612.0800	2.8000	["530","600"]	["0.4031","0.3808"]	["466","594"]	["XISX"]	530.0000	600.0000	108	108	false	true	false
01a0eda1-429f-7503-b6f6-c38da44ede39	SMH	2026-09-29 10:46	put_ratio_spread	2	1	20	27350.00	unknown	bid	611.6450	0.9500	["577.5","607.5"]	["0.3624","0.3409"]	["580.15"]	["XISX"]	577.5000	607.5000	17	17	false	true	false
01a0e8d6-f509-7b43-b8bd-5bb6d8176437	SMH	2026-09-28 12:26	put_ratio_spread	2	3	160	59812.00	unknown	bid	602.8300	0.3900	["575","590"]	["0.4043","0.3761"]	["561","589"]	["ARCO","EMLD","SPHR"]	575.0000	590.0000	4	4	false	true	false
01a0e85b-7ba7-7c02-a4b5-cf46c0bb9b14	SMH	2026-09-28 10:11	put_ratio_spread	2	3	80	84040.00	unknown	bid	598.2600	0.5500	["560","585"]	["0.3557","0.3334"]	["563.99"]	["EDGO","XISX","XPHO"]	560.0000	585.0000	18	18	false	true	false
01a0da1e-43df-74e1-9586-ec519e58658b	SMH	2026-09-25 15:50	put_ratio_spread	2	1	30	116130.00	unknown	bid	607.3250	4.1500	["530","600"]	["0.4027","0.3756"]	["421.35","584.32"]	["XPHO"]	530.0000	600.0000	84	84	false	true	false
01a0d8f1-5c9f-7842-8e4b-282eb844aee7	SMH	2026-09-25 10:21	put_ratio_spread	2	1	40	156500.00	unknown	bid	603.7300	3.1500	["525","595"]	["0.4008","0.3814"]	["461.21","588.79"]	["XCBO"]	525.0000	595.0000	112	112	false	true	false
01a0d8f1-4917-73f3-a6c7-b53fbae5338e	SMH	2026-09-25 10:21	put_ratio_spread	2	1	10	39120.00	unknown	bid	603.4600	3.1500	["525","595"]	["0.4005","0.3801"]	["461.12","588.88"]	["XCBO"]	525.0000	595.0000	112	112	false	true	false
01a0d8f1-2dbf-77d2-b504-5737812977d3	SMH	2026-09-25 10:21	put_ratio_spread	2	1	10	39121.00	unknown	bid	603.4600	3.1500	["525","595"]	["0.4006","0.3800"]	["461.07","588.93"]	["XCBO"]	525.0000	595.0000	112	112	false	true	false
01a0d8f1-1e1f-77c3-8938-014ffe6cab55	SMH	2026-09-25 10:21	put_ratio_spread	2	1	10	39116.00	unknown	bid	603.8900	3.1500	["525","595"]	["0.4019","0.3806"]	["460.90","589.10"]	["XCBO"]	525.0000	595.0000	112	112	false	true	false
01a0d3e9-36ff-7de3-9a80-46ebea22020f	SMH	2026-09-24 10:54	put_ratio_spread	2	1	12	39438.00	unknown	bid	591.7304	2.2000	["580","615"]	["0.3362","0.3167"]	["546.81","613.19"]	["XISX"]	580.0000	615.0000	29	29	false	false	false
01a0cfa9-435e-73a1-8c8a-888d2fab6ba1	SMH	2026-09-23 15:06	put_ratio_spread	2	3	10	28872.00	unknown	bid	599.8500	1.6500	["520","580"]	["0.4009","0.3757"]	["464.46","575.54"]	["AMXO","EDGO","XISX"]	520.0000	580.0000	86	86	false	true	false
01a0cfa9-00f7-7fc2-b759-64970b6893ec	SMH	2026-09-23 15:05	put_ratio_spread	2	2	12	34422.00	unknown	bid	599.7800	1.8000	["520","580"]	["0.3995","0.3737"]	["522.63"]	["XPHO"]	520.0000	580.0000	86	86	false	true	false
01a0cfa9-00f7-7fc2-b759-647f9036d6c8	SMH	2026-09-23 15:05	put_ratio_spread	2	5	34	97894.00	unknown	bid	599.7800	1.8000	["520","580"]	["0.4001","0.3748"]	["464.48","575.52"]	["C2OX","EDGO","XCBO","XMIO","XPHO"]	520.0000	580.0000	86	86	false	true	false
01a0cfa9-00f7-7fc2-b759-6464d93d9f1e	SMH	2026-09-23 15:05	put_ratio_spread	2	3	12	34485.00	unknown	bid	599.7800	1.8000	["520","580"]	["0.3998","0.3743"]	["522.52"]	["AMXO","EDGO","XISX"]	520.0000	580.0000	86	86	false	true	false
01a0cfa9-00f7-7fc2-b759-645edd46a036	SMH	2026-09-23 15:05	put_ratio_spread	2	4	14	40326.00	unknown	bid	599.7800	1.8000	["520","580"]	["0.4002","0.3750"]	["464.48","575.52"]	["AMXO","C2OX","EDGO","XISX"]	520.0000	580.0000	86	86	false	true	false
01a0cfa8-fd0f-7261-93b1-aa8785898688	SMH	2026-09-23 15:05	put_ratio_spread	2	2	12	34422.00	unknown	bid	599.7800	1.8000	["520","580"]	["0.3995","0.3737"]	["522.63"]	["XPHO"]	520.0000	580.0000	86	86	false	true	false
01a0cfa0-0816-7be0-8762-12ddaba48e32	SMH	2026-09-23 14:56	put_ratio_spread	2	1	15	60985.00	unknown	bid	600.1000	2.5000	["530","595"]	["0.3963","0.3740"]	["429.15","580.42"]	["XISX"]	530.0000	595.0000	86	86	false	true	false
01a0cf98-342e-7232-9a61-ad8d382f9a62	SMH	2026-09-23 14:47	put_ratio_spread	2	2	60	243940.00	unknown	bid	599.7950	2.6000	["530","595"]	["0.3955","0.3729"]	["429.15","580.42"]	["XISX","XPHO"]	530.0000	595.0000	86	86	false	true	false
01a0cf25-752e-7730-9f70-386796f5ae33	SMH	2026-09-23 12:42	put_ratio_spread	2	6	63	98287.00	unknown	bid	596.8250	0.8714	["450","555"]	["0.4299","0.3770"]	["401.46","547.09"]	["AMXO","ARCO","XCBO","XMIO","XPHO"]	450.0000	555.0000	114	114	false	true	false
01a0cf25-752e-7730-9f70-38586ef8b435	SMH	2026-09-23 12:42	put_ratio_spread	2	1	24	37480.00	unknown	bid	596.8250	1.1000	["450","555"]	["0.4301","0.3772"]	["401.46","547.09"]	["XISX"]	450.0000	555.0000	114	114	false	true	false
01a0cf25-1b57-7fd1-bd63-4f0680b6912f	SMH	2026-09-23 12:41	put_ratio_spread	2	1	30	46690.00	unknown	bid	596.6901	1.2500	["450","555"]	["0.4293","0.3762"]	["401.46","547.09"]	["XCBO"]	450.0000	555.0000	114	114	false	true	false
01a0cf25-1b57-7fd1-bd63-4ef4520fd56b	SMH	2026-09-23 12:41	put_ratio_spread	2	11	114	177994.00	unknown	bid	596.6901	1.0750	["450","555"]	["0.4298","0.3768"]	["401.46","547.09"]	["AMXO","ARCO","C2OX","EDGO","EMLD","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"]	450.0000	555.0000	114	114	false	true
01a0cf23-36f7-7fa1-9939-6c1fc0bdfa56	SMH	2026-09-23 12:39	put_ratio_spread	2	1	19	34135.00	unknown	bid	597.3500	0.2000	["450","555"]	["0.4302","0.3783"]	["382.39","542.97"]	["XCBO"]	450.0000	555.0000	114	114	false	true	false
01a0cf23-0fe7-72c2-82a2-06a1c6489ddf	SMH	2026-09-23 12:39	put_ratio_spread	2	4	24	37316.00	unknown	bid	597.4100	0.3750	["450","555"]	["0.4304","0.3779"]	["401.46","547.08"]	["EMLD","MCRY","XBOX","XMIO"]	450.0000	555.0000	114	114	false	true	false
01a0cf23-0fe7-72c2-82a2-06945bc03e10	SMH	2026-09-23 12:39	put_ratio_spread	2	9	120	186216.00	unknown	bid	597.4100	0.5900	["450","555"]	["0.4300","0.3776"]	["401.47","547.06"]	["AMXO","ARCO","C2OX","EDGO","XBOX","XCBO","XISX","XPHO"]	450.0000	555.0000	114	114	false	true	false
01a0cf22-4c97-78f3-bfbe-bfca96415f53	SMH	2026-09-23 12:38	put_ratio_spread	2	1	30	46140.00	unknown	bid	597.6100	1.0500	["450","555"]	["0.4291","0.3763"]	["401.46","547.08"]	["XCBO"]	450.0000	555.0000	114	114	false	true	false
01a0cf21-2f6f-7a03-9c6f-79243db13e89	SMH	2026-09-23 12:37	put_ratio_spread	2	1	18	27636.00	unknown	bid	597.9300	0.8500	["450","555"]	["0.4285","0.3779"]	["401.60","546.80"]	["XISX"]	450.0000	555.0000	114	114	false	true	false
01a0cf21-2f6f-7a03-9c6f-791a08b03879	SMH	2026-09-23 12:37	put_ratio_spread	2	4	48	73540.00	unknown	bid	597.9300	1.2000	["450","555"]	["0.4282","0.3775"]	["401.60","546.80"]	["XBOX","XCBO","XMIO","XPHO"]	450.0000	555.0000	114	114	false	true	false
01a0ced0-86ff-7683-8bbd-8bb758ef7231	SMH	2026-09-23 11:09	put_ratio_spread	2	2	138	641102.00	unknown	bid	600.5000	3.2500	["525","595"]	["0.3909","0.3706"]	["415.95","579.52"]	["XBOX","XISX"]	525.0000	595.0000	114	114	false	true	false
01a0ced0-86ff-7683-8bbd-8ba80bf39643	SMH	2026-09-23 11:09	put_ratio_spread	2	2	6	27874.00	unknown	bid	600.5000	3.2500	["525","595"]	["0.3909","0.3706"]	["415.95","579.52"]	["XBOX","XISX"]	525.0000	595.0000	114	114	false	true	false
01a0ced0-5c07-7cd1-8c86-27182a67164c	SMH	2026-09-23 11:09	put_ratio_spread	2	2	6	27960.00	unknown	bid	600.3800	3.6000	["525","595"]	["0.3914","0.3710"]	["415.93","579.54"]	["ARCO","XISX"]	525.0000	595.0000	114	114	false	true	false
01a0c995-e77f-7da1-a8bd-76c1fbf8881c	SMH	2026-09-22 10:47	put_ratio_spread	2	1	40	148240.00	unknown	bid	598.4550	2.2500	["515","590"]	["0.3961","0.3715"]	["448.44","581.56"]	["XCBO"]	515.0000	590.0000	115	115	false	true	false
01a0c995-d3f7-7743-8789-bac55702089b	SMH	2026-09-22 10:47	put_ratio_spread	2	1	10	37054.00	unknown	bid	598.6550	2.2500	["515","590"]	["0.3967","0.3718"]	["448.37","581.63"]	["XCBO"]	515.0000	590.0000	115	115	false	true	false
01a0c52b-887f-7533-832c-0faf9f70838b	SMH	2026-09-21 14:12	put_ratio_spread	2	6	916	193154.00	unknown	bid	593.9600	0.3100	["565","590"]	["0.3992","0.3082"]	["585.78"]	["ARCO","C2OX","EDGO","EMLD","XBOX","XISX"]	565.0000	590.0000	2	2	true	true	false
01a0c520-ce67-7ab3-b60e-352684c43f47	SMH	2026-09-21 14:00	put_ratio_spread	2	3	525	93981.00	long	bid	593.5900	0.0800	["450","500"]	["0.5124","0.4227"]	["498.83"]	["XBOX","XCBO","XISX"]	450.0000	500.0000	25	25	false	true	false
01a0c4ff-2536-7810-8bac-8858a0bbc633	SMH	2026-09-21 13:24	put_ratio_spread	2	2	36	127296.00	unknown	bid	592.2400	1.5000	["510","580"]	["0.3911","0.3673"]	["446.60","573.40"]	["XISX","XPHO"]	510.0000	580.0000	116	116	false	true	false
01a0c4ff-214e-7bb1-b576-99c7d9aa9bd6	SMH	2026-09-21 13:24	put_ratio_spread	2	1	10	35344.00	unknown	bid	592.2400	1.5000	["510","580"]	["0.3911","0.3670"]	["446.56","573.44"]	["XCBO"]	510.0000	580.0000	116	116	false	true	false
01a0c459-a606-7a21-a03b-6c7d17f310bd	SMH	2026-09-21 10:23	put_ratio_spread	2	1	12	28374.00	unknown	bid	585.5900	1.6000	["565","595"]	["0.3432","0.3315"]	["536.77","593.23"]	["XISX"]	565.0000	595.0000	25	25	false	false	false
01a0b618-f670-7623-9fba-f495b2b4b184	SMH	2026-09-18 15:58	put_ratio_spread	2	3	100	350320.00	unknown	bid	572.6800	5.4500	["500","560"]	["0.3804","0.3596"]	["496.65"]	["XCBO","XISX","XPHO"]	500.0000	560.0000	119	119	false	true	false
01a0b51b-ae97-7e91-95f7-db030ec49f91	SMH	2026-09-18 11:21	put_ratio_spread	2	1	32	119472.00	unknown	bid	564.9000	2.0000	["500","560"]	["0.3743","0.3534"]	["443.11","556.89"]	["XCBO"]	500.0000	560.0000	119	119	false	true	false
01a0b511-f650-7df1-a287-8f7b8ea5aee3	SMH	2026-09-18 11:10	put_ratio_spread	2	1	64	237984.00	unknown	bid	564.8200	1.6000	["500","560"]	["0.3729","0.3525"]	["443.25","556.75"]	["XCBO"]	500.0000	560.0000	119	119	false	true	false
01a0b50c-5cb8-7550-9e34-41416a4a28cc	SMH	2026-09-18 11:04	put_ratio_spread	2	1	32	119088.00	unknown	bid	564.6400	1.8500	["500","560"]	["0.3733","0.3511"]	["442.99","557.01"]	["XCBO"]	500.0000	560.0000	119	119	false	true	false