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 = ratio_risk_reversal×sorted by executed_at ↑×

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

01a06d22-b63d-70f3-b08c-419dc5865c75	META	2026-09-04 11:56	ratio_risk_reversal	2	3	12	28306.00	short	bid	611.7400	0.6500	["520","635"]	["0.4182","0.4072"]	["639.58"]	["XCBO","XMIO","XPHO"]	520.0000	635.0000	77	77	false	true	false	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-04T15:56:29Z"}	2026-09-04	2026-09-07 00:53	2026-09-07 00:53
01a06d39-e3d5-7401-89c7-1b24f0fcf9a6	RUT	2026-09-04 12:21	ratio_risk_reversal	2	2	16	77624.00	long	ask	2976.0216	1.3000	["2850","3025"]	["0.1920","0.1532"]	["2847.46"]	["C2OX","XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d39-eba5-7501-b9c9-24a348d87718	RUT	2026-09-04 12:21	ratio_risk_reversal	2	1	14	67914.00	long	ask	2976.0216	1.3000	["2850","3025"]	["0.1920","0.1532"]	["2847.45"]	["XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d39-eba5-7501-b9c9-24997e889689	RUT	2026-09-04 12:21	ratio_risk_reversal	2	1	12	58212.00	long	ask	2976.0216	1.3000	["2850","3025"]	["0.1920","0.1532"]	["2847.45"]	["C2OX"]	2850.0000	3025.0000	42	42	false	true	false
01a06d39-f376-71a0-b073-284c35c52e37	RUT	2026-09-04 12:21	ratio_risk_reversal	2	2	14	67921.00	long	ask	2975.9901	1.3000	["2850","3025"]	["0.1919","0.1533"]	["2847.48"]	["C2OX","XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d39-fb45-7323-8f99-3845b8fb9713	RUT	2026-09-04 12:21	ratio_risk_reversal	2	1	14	67935.00	long	ask	2975.9901	1.3000	["2850","3025"]	["0.1920","0.1533"]	["2847.44"]	["XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d39-fb45-7323-8f99-383287d46b6d	RUT	2026-09-04 12:21	ratio_risk_reversal	2	1	8	38820.00	long	ask	2975.9901	1.3000	["2850","3025"]	["0.1920","0.1533"]	["2847.44"]	["C2OX"]	2850.0000	3025.0000	42	42	false	true	false
01a06d3a-0315-74f3-9c40-b64fb1b0e2bb	RUT	2026-09-04 12:21	ratio_risk_reversal	2	1	8	38812.00	long	ask	2975.9884	1.3000	["2850","3025"]	["0.1920","0.1533"]	["2847.46"]	["XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d3a-06fd-7102-a8df-8aef4a542f0e	RUT	2026-09-04 12:21	ratio_risk_reversal	2	2	6	29106.00	long	ask	2975.9884	1.3000	["2850","3025"]	["0.1918","0.1535"]	["2847.55"]	["C2OX","XCBO"]	2850.0000	3025.0000	42	42	false	true	false
01a06d71-d425-7830-8fae-98dfab58db6c	AMAT	2026-09-04 13:22	ratio_risk_reversal	2	1	130	164279.00	short	bid	452.5700	1.9000	["300","600"]	["0.5830","0.5669"]	["606.75"]	["C2OX"]	300.0000	600.0000	105	105	false	true	false
01a06d9e-5e7d-70c2-b782-3adeccc66690	MU	2026-09-04 14:11	ratio_risk_reversal	2	2	4	26889.00	long	bid	999.3950	2.1500	["990","1220"]	["0.6377","0.6778"]	["966.96"]	["AMXO","ARCO"]	990.0000	1220.0000	42	42	false	true	false
01a06da6-d28d-7470-b830-06dd12cb8833	SPX	2026-09-04 14:20	ratio_risk_reversal	2	1	15	171555.00	long	ask	7713.4400	0.8000	["7440","7920"]	["0.1550","0.1127"]	["7421.79"]	["XCBO"]	7440.0000	7920.0000	56	56	false	true	false
01a06daf-1f8d-7de2-9a75-933e87b0d30e	SPX	2026-09-04 14:29	ratio_risk_reversal	2	1	24	273512.00	short	bid	7713.9700	0.9000	["7440","7920"]	["0.1548","0.1125"]	["7422.02"]	["XCBO"]	7440.0000	7920.0000	56	56	false	true	false
01a06daf-1f8d-7de2-9a75-93a30bdf392c	SPX	2026-09-04 14:29	ratio_risk_reversal	2	1	6	68404.00	short	bid	7713.9700	0.9000	["7440","7920"]	["0.1548","0.1126"]	["7422.13"]	["XCBO"]	7440.0000	7920.0000	56	56	false	true	false
01a0814c-6478-75f2-9077-370c85ca4324	SOXX	2026-09-08 09:54	ratio_risk_reversal	2	1	400	717000.00	short	bid	526.5700	4.5000	["475","542.5"]	["0.4288","0.4028"]	["555.50"]	["XISX"]	475.0000	542.5000	24	24	true	true	false
01a0814d-7200-74b0-aad2-20466f611b88	SOXX	2026-09-08 09:55	ratio_risk_reversal	2	1	400	734800.00	short	bid	526.8100	4.5000	["475","542.5"]	["0.4435","0.4051"]	["555.50"]	["XMIO"]	475.0000	542.5000	24	24	false	true	false
01a08152-9668-7cd3-8dd5-0a646f4d52d5	SOXX	2026-09-08 10:01	ratio_risk_reversal	2	1	400	734800.00	short	bid	526.8350	4.5000	["475","542.5"]	["0.4436","0.4049"]	["555.50"]	["XMIO"]	475.0000	542.5000	24	24	false	true	false
01a08153-2ec0-7b71-8e08-0abe9134a836	SOXX	2026-09-08 10:01	ratio_risk_reversal	2	2	68	121720.00	unknown	—	526.8700	4.5000	["475","542.5"]	["0.4293","0.4002"]	[]	["XPHO"]	475.0000	542.5000	24	24	false	true	false	true	true
01a08153-4a19-76a2-ac9f-1c2296cb147e	SOXX	2026-09-08 10:01	ratio_risk_reversal	2	2	332	594280.00	unknown	—	526.7500	4.5000	["475","542.5"]	["0.4287","0.4011"]	[]	["XPHO"]	475.0000	542.5000	24	24	false	true	false	true	true
01a08156-a578-7ff3-8d5f-725100e0860e	SOXX	2026-09-08 10:05	ratio_risk_reversal	2	1	400	734800.00	short	bid	526.6300	4.5000	["475","542.5"]	["0.4426","0.4066"]	["555.50"]	["XMIO"]	475.0000	542.5000	24	24	false	true	false
01a08157-5541-7060-ab52-0f29f68f42ed	SOXX	2026-09-08 10:06	ratio_risk_reversal	2	1	398	712420.00	unknown	—	526.5500	4.5000	["475","542.5"]	["0.4278","0.4027"]	[]	["XISX"]	475.0000	542.5000	24	24	false	true	false	true	true
01a08157-8420-7531-a907-e766b8fca1e3	SOXX	2026-09-08 10:06	ratio_risk_reversal	2	1	400	711600.00	unknown	—	526.2300	4.5000	["475","542.5"]	["0.4262","0.4032"]	[]	["XISX"]	475.0000	542.5000	24	24	false	true	false	true	true
01a081a4-15b0-78f0-922f-ed5e2c2d0dc7	FLEX	2026-09-08 11:30	ratio_risk_reversal	2	2	308	148533.00	long	bid	113.2200	1.0500	["115","135"]	["0.5886","0.6052"]	["135.17"]	["EDGO","XCBO"]	115.0000	135.0000	38	38	false	false	false
01a081af-b640-7fe2-889f-c04013a2e89c	SKHY	2026-09-08 11:42	ratio_risk_reversal	2	15	65	306129.00	long	ask	189.2000	1.4500	["180","210"]	["0.6976","0.7150"]	["177.63"]	["AMXO","C2OX","EDGO","EMLD","MCRY","SPHR","XCBO","XISX","XMIO","XPHO"]	180.0000	210.0000	129	129	false	true	false
01a081b1-1da1-7201-add5-edc2958ff5c7	SNOW	2026-09-08 11:44	ratio_risk_reversal	2	1	15	118750.00	short	bid	334.6150	6.9000	["230","350"]	["0.5625","0.5800"]	["228.95"]	["XCBO"]	230.0000	350.0000	829	829	false	true	false
01a081b3-34c8-7491-9a23-f9c587cdf764	SOXX	2026-09-08 11:46	ratio_risk_reversal	2	1	40	75201.00	unknown	—	533.6400	2.8000	["525","535"]	["0.4412","0.4396"]	[]	["XPHO"]	525.0000	535.0000	10	10	false	true	false	true	true
01a081b3-34c8-7491-9a23-f9b0ce68f8a2	SOXX	2026-09-08 11:46	ratio_risk_reversal	2	1	40	75480.00	unknown	—	533.6400	2.8000	["525","535"]	["0.4412","0.4436"]	[]	["XPHO"]	525.0000	535.0000	10	10	false	true	false	true	true
01a0827b-d810-7d42-a090-4ac9902c9259	AAPL	2026-09-08 15:25	ratio_risk_reversal	2	7	42	40572.00	short	bid	315.9100	0.3000	["285","320"]	["0.3027","0.2773"]	["320.77"]	["AMXO","ARCO","C2OX","EDGO","EMLD","XCBO","XMIO"]	285.0000	320.0000	73	73	false	true	false
01a08294-0778-7ce1-954f-2f3ebc308f6b	ORCL	2026-09-08 15:52	ratio_risk_reversal	2	4	24	47678.00	long	ask	162.2030	0.7500	["135","160"]	["0.6289","0.6297"]	["166.50"]	["C2OX","EMLD","SPHR","XPHO"]	135.0000	160.0000	101	101	false	false	false
01a0865c-8e65-70d1-9b9e-ec99240f79ed	GOOG	2026-09-09 09:30	ratio_risk_reversal	2	1	6	40590.00	short	bid	328.6200	8.8500	["280","300"]	["0.3884","0.3571"]	["276.35"]	["XPHO"]	280.0000	300.0000	828	828	false	false	false
01a0867a-1b49-7890-8060-148597f8c7a4	SOXX	2026-09-09 10:02	ratio_risk_reversal	2	3	300	309500.00	unknown	—	533.4500	1.4000	["475","535"]	["0.5320","0.4092"]	[]	["AMXO","EDGO"]	475.0000	535.0000	9	9	false	true	false	true	true
01a0868d-35e9-79e1-b6fa-60decf8f8c1e	SMH	2026-09-09 10:23	ratio_risk_reversal	2	1	9	32955.00	long	ask	574.3000	1.5500	["430","650"]	["0.4202","0.3708"]	["428.85"]	["XBOX"]	430.0000	650.0000	281	281	false	true	false
01a0868d-ca58-78d0-a0cd-855dd88a63ef	SMH	2026-09-09 10:23	ratio_risk_reversal	2	2	9	32985.00	long	ask	574.3650	2.7500	["430","650"]	["0.4190","0.3735"]	["429.19"]	["SPHR","XBOX"]	430.0000	650.0000	281	281	false	true	false
01a0868e-0cc0-7f10-8ae5-315db08bbe95	SMH	2026-09-09 10:24	ratio_risk_reversal	2	3	9	32985.00	long	ask	574.5800	2.1500	["430","650"]	["0.4196","0.3724"]	["429.12"]	["SPHR","XBOX","XPHO"]	430.0000	650.0000	281	281	false	true	false
01a0868e-33d1-7272-ab02-4d981b9d09fd	SMH	2026-09-09 10:24	ratio_risk_reversal	2	1	18	65970.00	unknown	—	574.5800	1.9500	["430","650"]	["0.4204","0.3709"]	[]	["SPHR"]	430.0000	650.0000	281	281	false	true	false	true	true
01a08690-6268-76f3-8e01-278f460b1c1e	SMH	2026-09-09 10:26	ratio_risk_reversal	2	3	9	32985.00	long	ask	575.3700	1.8000	["430","650"]	["0.4204","0.3709"]	["429.15"]	["SPHR","XBOX","XPHO"]	430.0000	650.0000	281	281	false	true	false
01a08691-9700-7bb2-ba8d-4541a04dd3af	SMH	2026-09-09 10:28	ratio_risk_reversal	2	1	9	32985.00	long	ask	575.4250	1.5000	["430","650"]	["0.4216","0.3689"]	["428.90"]	["SPHR"]	430.0000	650.0000	281	281	false	true	false
01a0869d-a8d8-7b52-8bf3-265806ac7dcb	DELL	2026-09-09 10:41	ratio_risk_reversal	2	2	40	57047.00	long	ask	553.7500	0.5500	["525","552.5"]	["0.8136","0.8259"]	["566.60"]	["XBOX","XMIO"]	525.0000	552.5000	2	2	false	false	false
01a0869d-e370-7122-afa8-58622efdf52b	SMH	2026-09-09 10:41	ratio_risk_reversal	2	4	264	971080.00	short	bid	575.4250	2.6500	["430","650"]	["0.4214","0.3711"]	["429.07"]	["AMXO","ARCO","XBOX","XMIO"]	430.0000	650.0000	281	281	false	true	false
01a086b1-0db0-7792-8bcd-c12d7baa8dab	SMH	2026-09-09 11:02	ratio_risk_reversal	2	1	18	66330.00	long	ask	576.0200	3.7000	["430","650"]	["0.4177","0.3784"]	["650.45"]	["XBOX"]	430.0000	650.0000	281	281	false	true	false
01a086b1-86c8-7500-8b7b-001dcdc3a863	SMH	2026-09-09 11:02	ratio_risk_reversal	2	4	282	1040110.00	long	ask	575.6400	3.6500	["430","650"]	["0.4191","0.3765"]	["429.76"]	["ARCO","EMLD","XBOX","XPHO"]	430.0000	650.0000	281	281	false	true	false
01a086bc-40e0-7242-91b6-420605b3a055	META	2026-09-09 11:14	ratio_risk_reversal	2	2	6	26980.00	long	ask	653.7600	1.8250	["490","780"]	["0.4373","0.4349"]	["487.18"]	["C2OX","XISX"]	490.0000	780.0000	281	281	false	true	false
01a086f0-2dd9-7732-91b6-cbbd7062c231	GLD	2026-09-09 12:11	ratio_risk_reversal	2	6	90	288915.00	long	ask	403.0900	0.4500	["380","410"]	["0.2418","0.2485"]	["424.06"]	["C2OX","EMLD","MCRY","XBOX","XMIO","XPHO"]	380.0000	410.0000	128	128	false	true	false
01a086f5-a448-7c52-b02b-f92abb3a4c59	SMH	2026-09-09 12:17	ratio_risk_reversal	2	1	14	59325.00	long	ask	572.7800	3.4500	["450","700"]	["0.4122","0.3682"]	["445.84"]	["ARCO"]	450.0000	700.0000	281	281	false	true	false
01a086f6-5fc9-77e1-bf26-be52323e6aff	SMH	2026-09-09 12:18	ratio_risk_reversal	2	2	50	212375.00	long	ask	572.6900	2.4500	["450","700"]	["0.4112","0.3707"]	["446.18"]	["EDGO","XBOX"]	450.0000	700.0000	281	281	false	true	false
01a086f7-bb70-7120-8401-4d0b7c43bc2f	SMH	2026-09-09 12:19	ratio_risk_reversal	2	1	26	110500.00	short	bid	572.7100	1.2500	["450","700"]	["0.4138","0.3675"]	["445.55"]	["ARCO"]	450.0000	700.0000	281	281	false	true	false
01a086fa-95e9-70c2-bfab-993fcfa689ec	SMH	2026-09-09 12:22	ratio_risk_reversal	2	1	20	85000.00	long	ask	572.6000	1.3500	["450","700"]	["0.4132","0.3682"]	["445.65"]	["XBOX"]	450.0000	700.0000	281	281	false	true	false
01a086fb-12e8-7ef3-98a6-66c732f6713a	MRVL	2026-09-09 12:23	ratio_risk_reversal	2	1	24	66280.00	long	ask	236.7100	0.7000	["155","300"]	["0.6719","0.7132"]	["154.82"]	["ARCO"]	155.0000	300.0000	281	281	false	true	false
01a086fb-16d0-71c2-9360-0fc35ee0b0f0	SMH	2026-09-09 12:23	ratio_risk_reversal	2	1	30	127500.00	long	ask	572.7300	0.8500	["450","700"]	["0.4144","0.3666"]	["445.40"]	["AMXO"]	450.0000	700.0000	281	281	false	true	false
01a086fb-1ab9-7743-97f6-6ef582e30080	SMH	2026-09-09 12:23	ratio_risk_reversal	2	2	18	76500.00	short	bid	572.7300	0.6000	["450","700"]	["0.4159","0.3645"]	["445.01"]	["AMXO"]	450.0000	700.0000	281	281	false	true	false