Multi-leg option trades

core.multileg_trades

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

403,968 rowsCSV — whole table, not this view

Sources in this table

uw_multileg403,968 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:code = mlet×strategy = put_ratio_spread×ticker = SMH×

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

01a0c998-7ba6-70f0-9cef-bf77168bc285	SMH	2026-09-22 10:50	put_ratio_spread	2	3	14	51874.00	unknown	ask	600.4700	2.8000	["515","590"]	["0.4003","0.3777"]	["515.89"]	["ARCO","XISX"]	515.0000	590.0000	115	115	false	true	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T14:50:11Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0c998-7ba6-70f0-9cef-bf6e5174ff2f	SMH	2026-09-22 10:50	put_ratio_spread	2	2	40	148360.00	unknown	ask	600.4700	2.8000	["515","590"]	["0.4004","0.3782"]	["515.82"]	["XISX","XPHO"]	515.0000	590.0000	115	115	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
01a0c570-6d36-72d0-b19c-e82f1f2d3b4a	SMH	2026-09-21 15:27	put_ratio_spread	2	1	30	50700.00	unknown	ask	596.5100	0.5000	["552.5","587.5"]	["0.3638","0.3396"]	["562.15"]	["XPHO"]	552.5000	587.5000	25	25	false	true	false
01a0c543-0437-7410-8bd9-a91ed4c3c92e	SMH	2026-09-21 14:38	put_ratio_spread	2	1	20	70300.00	unknown	ask	594.9500	2.0500	["510","580"]	["0.3960","0.3735"]	["509.90"]	["XPHO"]	510.0000	580.0000	116	116	false	true	false
01a0c535-e4d7-7302-9aa1-495c2fa3d473	SMH	2026-09-21 14:23	put_ratio_spread	2	2	30	105250.00	unknown	ask	594.6900	2.0500	["510","580"]	["0.3951","0.3722"]	["509.94"]	["XCBO","XPHO"]	510.0000	580.0000	116	116	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
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
01a0b559-c137-7f22-9597-4eca3b39ffbe	SMH	2026-09-18 12:29	put_ratio_spread	2	2	45	49740.00	unknown	ask	563.3000	1.0000	["535","557.5"]	["0.3318","0.3064"]	["540.92"]	["XISX","XPHO"]	535.0000	557.5000	14	14	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
01a0b51b-ae97-7e91-95f7-daf9d428df37	SMH	2026-09-18 11:21	put_ratio_spread	2	2	68	254762.00	unknown	ask	564.9000	2.0000	["500","560"]	["0.3746","0.3550"]	["495.02"]	["XISX","XPHO"]	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
01a0b0f0-a2cb-74a3-b4c7-fc6084a3134a	SMH	2026-09-17 15:55	put_ratio_spread	2	7	24	46216.00	unknown	—	560.9800	2.2000	["460","540"]	["0.4079","0.3566"]	[]	["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"]	460.0000	540.0000	64	64	false	true	false	true	false
01a0b0f0-6c1b-73c2-bfaf-7f19bc1a28fa	SMH	2026-09-17 15:55	put_ratio_spread	2	7	21	40904.00	unknown	—	560.9550	2.5500	["460","540"]	["0.4105","0.3584"]	[]	["AMXO","ARCO","MCRY","XBOX","XCBO","XMIO","XPHO"]	460.0000	540.0000	64	64	false	true	false	true	false
01a0aaba-f9ab-7b71-9d53-17208f913950	SMH	2026-09-16 10:59	put_ratio_spread	2	2	316	56030.00	unknown	—	551.1600	0.2000	["525","535"]	["0.4931","0.4575"]	[]	["ARCO","XBOX"]	525.0000	535.0000	2	2	false	true	false	true	false
01a0a66f-2626-7e00-8bd9-a4858b63674e	SMH	2026-09-15 14:58	put_ratio_spread	2	2	40	60240.00	unknown	—	541.4300	0.8500	["500","535"]	["0.3597","0.3320"]	[]	["XISX","XPHO"]	500.0000	535.0000	31	31	false	true	false	true	false
01a0a667-5a0e-7592-a36d-eced445ed494	SMH	2026-09-15 14:49	put_ratio_spread	2	2	40	61180.00	unknown	—	540.8800	0.6500	["500","535"]	["0.3599","0.3320"]	[]	["XISX","XPHO"]	500.0000	535.0000	31	31	false	true	false	true	false
01a0a56c-ecad-72c2-acd3-2ec54bd12959	SMH	2026-09-15 10:16	put_ratio_spread	2	1	48	34680.00	unknown	—	545.3500	0.6500	["535","545"]	["0.3984","0.3784"]	[]	["XMIO"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-ecad-72c2-acd3-2ebafd36d97a	SMH	2026-09-15 10:16	put_ratio_spread	2	2	80	57600.00	unknown	—	545.3500	0.6500	["535","545"]	["0.3976","0.3772"]	[]	["AMXO","XPHO"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-ecad-72c2-acd3-2ea76da7c4a7	SMH	2026-09-15 10:16	put_ratio_spread	2	2	132	96422.00	unknown	—	545.3500	0.6500	["535","545"]	["0.4007","0.3825"]	[]	["ARCO","XBOX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-ecad-72c2-acd3-2e91533d9b67	SMH	2026-09-15 10:16	put_ratio_spread	2	1	52	37310.00	unknown	—	545.3500	0.6500	["535","545"]	["0.3969","0.3759"]	[]	["XISX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-983a0844b552	SMH	2026-09-15 10:15	put_ratio_spread	2	2	50	36450.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3964","0.3738"]	[]	["ARCO","XBOX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-980b45ac117c	SMH	2026-09-15 10:15	put_ratio_spread	2	2	62	45210.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3964","0.3739"]	[]	["ARCO","XBOX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-97ea02f16c84	SMH	2026-09-15 10:15	put_ratio_spread	2	1	122	89670.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3981","0.3769"]	[]	["XMIO"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-97d22f66e672	SMH	2026-09-15 10:15	put_ratio_spread	2	2	200	146400.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3973","0.3753"]	[]	["AMXO","XPHO"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-97c3a5b39d1c	SMH	2026-09-15 10:15	put_ratio_spread	2	2	318	235134.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3994","0.3791"]	[]	["ARCO","XBOX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a56c-5456-7f93-8317-97b54e7a7533	SMH	2026-09-15 10:15	put_ratio_spread	2	1	128	94080.00	unknown	—	545.0800	0.5000	["535","545"]	["0.3981","0.3769"]	[]	["XISX"]	535.0000	545.0000	3	3	false	true	false	true	false
01a0a55f-86fe-78c0-8e33-d0dd5f8fcaf3	SMH	2026-09-15 10:01	put_ratio_spread	2	2	12	39066.00	unknown	—	547.1000	3.0000	["490","540"]	["0.3801","0.3590"]	[]	["ARCO","XISX"]	490.0000	540.0000	94	94	false	true	false	true	false