Multi-leg option trades

core.multileg_trades

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

637,282 rowsCSV — whole table, not this view

Sources in this table

uw_multileg637,282 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×ticker = AAPL×

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

01a0f7ac-b796-7423-8575-a85fedddad18	AAPL	2026-10-01 09:34	other	3	2	13	57304.00	unknown	—	329.9756	1.4900	["310","350","380"]	["0.2828","0.2347","0.2653"]	[]	["EMLD","SPHR"]	310.0000	380.0000	15	351	false	false	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-10-01T13:35:00Z"}	2026-10-01	2026-10-01 17:15	2026-10-01 17:15
01a0f7ac-abde-7b61-ab9a-80c0daa3f842	AAPL	2026-10-01 09:34	other	3	5	29	127850.00	unknown	bid	330.0150	1.5400	["310","350","380"]	["0.2825","0.2331","0.2651"]	[]	["ARCO","C2OX","MCRY","XCBO","XPHO"]	310.0000	380.0000	15	351	false	false	true
01a0f7ac-a7f6-7c53-9a0f-7f47e83566e2	AAPL	2026-10-01 09:34	call_vertical_spread	2	1	15	27990.00	long	ask	329.9900	0.9000	["345","350"]	["0.2495","0.2477"]	["346.76"]	["XCBO"]	345.0000	350.0000	78	78	false	true	false
01a0f7ac-a027-74f2-ab34-488bb9f187b0	AAPL	2026-10-01 09:34	other	3	4	13	57303.00	unknown	ask	330.0250	1.6400	["310","350","380"]	["0.2777","0.2343","0.2653"]	[]	["BATO","EDGO","XPHO"]	310.0000	380.0000	15	351	false	false	true
01a0f7ac-9086-70f3-a488-e1b60600d75b	AAPL	2026-10-01 09:34	other	3	2	7	37781.00	unknown	bid	329.8801	1.0900	["305","350","365"]	["0.3149","0.2343","0.2688"]	[]	["C2OX","MCRY"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-9086-70f3-a488-e1a481932de8	AAPL	2026-10-01 09:34	other	3	2	9	48244.00	unknown	bid	329.9100	1.2900	["305","350","365"]	["0.2973","0.2355","0.2670"]	[]	["EMLD","XBOX"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-80e7-7a80-9327-548de7795d6f	AAPL	2026-10-01 09:34	other	3	3	11	59294.00	unknown	ask	329.8450	1.3300	["305","350","365"]	["0.3114","0.2349","0.2689"]	[]	["EDGO","MCRY","XCBO"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-7cff-7550-b841-6d236f7c7f47	AAPL	2026-10-01 09:34	other	3	2	6	32310.00	unknown	ask	329.8450	1.3300	["305","350","365"]	["0.3092","0.2355","0.2687"]	[]	["ARCO","EMLD"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-7147-7991-b7a7-758bf7a2e524	AAPL	2026-10-01 09:34	other	3	3	11	59168.00	unknown	bid	330.0100	1.3300	["305","350","365"]	["0.2950","0.2330","0.2677"]	[]	["BATO","EDGO","XISX"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-7147-7991-b7a7-7572a7c2f27a	AAPL	2026-10-01 09:34	other	3	2	7	37687.00	unknown	bid	330.0681	1.3300	["305","350","365"]	["0.2945","0.2309","0.2677"]	[]	["AMXO","EMLD"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-658f-79e2-903a-8fcb93029292	AAPL	2026-10-01 09:34	other	3	2	7	37709.00	unknown	ask	330.0300	1.3400	["305","350","365"]	["0.2936","0.2350","0.2680"]	[]	["SPHR","XMIO"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-55ef-74b0-bad7-a22bcd8b3e51	AAPL	2026-10-01 09:34	other	3	3	6	32364.00	unknown	bid	329.9900	1.1400	["305","350","365"]	["0.3015","0.2323","0.2687"]	[]	["ARCO","BATO","XISX"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-55ef-74b0-bad7-a20b72a17706	AAPL	2026-10-01 09:34	other	3	2	6	32352.00	unknown	bid	330.0500	1.1400	["305","350","365"]	["0.2962","0.2310","0.2684"]	[]	["AMXO","SPHR"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-464e-7bb3-88fe-fd9fdbc3ca11	AAPL	2026-10-01 09:34	other	3	2	7	37786.00	unknown	—	329.9300	1.2900	["305","350","365"]	["0.3077","0.2329","0.2691"]	[]	["AMXO","ARCO"]	305.0000	365.0000	15	351	false	false	true	true	false
01a0f7ac-464e-7bb3-88fe-fd8cf183f8b4	AAPL	2026-10-01 09:34	other	3	2	8	43176.00	unknown	bid	329.9300	1.2900	["305","350","365"]	["0.3077","0.2329","0.2690"]	[]	["EMLD","SPHR"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-3a97-7cf0-81b8-8a124d0cfb40	AAPL	2026-10-01 09:34	other	3	2	6	32328.00	unknown	bid	330.0100	1.4900	["305","350","365"]	["0.2973","0.2327","0.2683"]	[]	["C2OX","MCRY"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-3a97-7cf0-81b8-8a0540977c48	AAPL	2026-10-01 09:34	other	3	2	8	42872.00	unknown	bid	330.0100	1.5900	["305","350","365"]	["0.2839","0.2344","0.2669"]	[]	["EMLD","XBOX"]	305.0000	365.0000	15	351	false	false	true
01a0f7ac-2af6-7231-86e8-60a6a844f7f6	AAPL	2026-10-01 09:34	other	3	3	11	59348.00	unknown	ask	330.0900	1.8000	["305","350","365"]	["0.2919","0.2334","0.2683"]	[]	["BATO","XCBO","XISX"]	305.0000	365.0000	15	351	false	false	true
01a0f7ab-fc16-7b90-9c90-dc2c3806a987	AAPL	2026-10-01 09:33	call_vertical_spread	2	1	7	74039.00	short	bid	329.8350	7.4500	["340","350"]	["0.2767","0.2756"]	["344.51"]	["SPHR"]	340.0000	350.0000	624	624	false	true	false
01a0f7ab-fc16-7b90-9c90-dc1072103e77	AAPL	2026-10-01 09:33	call_vertical_spread	2	2	8	84616.00	short	bid	329.8350	7.4500	["340","350"]	["0.2767","0.2756"]	["344.51"]	["EMLD","SPHR"]	340.0000	350.0000	624	624	false	true
01a0f7ab-dcd7-7662-aca0-2db494e953dc	AAPL	2026-10-01 09:33	call_diagonal_spread	2	1	15	315635.00	unknown	—	329.9300	6.3000	["240","250"]	["0.3106","0.3022"]	[]	["XISX"]	240.0000	250.0000	477	533	false	false	true	true	false
01a0f7ab-6f77-7493-9129-26fb2c23164a	AAPL	2026-10-01 09:33	put_ratio_spread	2	7	120	29460.00	unknown	bid	329.1900	0.1100	["325","330"]	["0.3824","0.3566"]	["320.81","329.19"]	["ARCO","C2OX","EDGO","SPHR","XCBO","XISX"]	325.0000	330.0000	1	1	false	false
01a0f7ab-4867-7fc3-90aa-cdf3cad54e6d	AAPL	2026-10-01 09:33	put_ratio_spread	2	4	112	27160.00	unknown	bid	329.3000	0.1400	["325","330"]	["0.3848","0.3609"]	["325.15"]	["ARCO","C2OX","EDGO","XBOX"]	325.0000	330.0000	1	1	false	false
01a0f7ab-4867-7fc3-90aa-cdebb676ee74	AAPL	2026-10-01 09:33	call_diagonal_spread	2	1	1000	836000.00	long	ask	329.3600	0.3600	["325","330"]	["0.2503","0.3734"]	[]	["XISX"]	325.0000	330.0000	1	4	false	false	true
01a0f7aa-a06f-7fd3-ac43-c514f26123c0	AAPL	2026-10-01 09:32	put_ratio_spread	2	4	140	37590.00	unknown	bid	328.7540	0.2600	["325","330"]	["0.3813","0.3559"]	["324.88"]	["C2OX","XBOX","XCBO","XISX"]	325.0000	330.0000	1	1	false	false
01a0f7aa-94b7-7973-aef4-7c09fd20531c	AAPL	2026-10-01 09:32	other	4	2	37	138279.00	unknown	—	328.4300	3.6100	["310","315","350","355"]	["0.3111","0.2926","0.2389","0.2414"]	[]	["C2OX","XISX"]	310.0000	355.0000	15	15	false	false	false	true	false
01a0f7aa-42af-7560-a8aa-439d1c7055a5	AAPL	2026-10-01 09:32	put_calendar	2	1	15	26988.00	unknown	bid	329.1300	1.0500	["320"]	["0.2662"]	[]	["XCBO"]	320.0000	320.0000	50	106	false	true	true
01a0f7a9-6fbf-7c11-b4a9-b485aa1af7d4	AAPL	2026-10-01 09:31	call_diagonal_spread	2	1	10	46120.00	short	bid	329.5400	4.7500	["315","320"]	["0.2812","0.2703"]	[]	["ARCO"]	315.0000	320.0000	50	78	false	false	true
01a0f7a8-b056-7c60-8b99-92188db686dc	AAPL	2026-10-01 09:30	call_diagonal_spread	2	1	10	83640.00	long	ask	330.1600	4.0500	["290","295"]	["0.4305","0.2978"]	[]	["XISX"]	290.0000	295.0000	15	78	false	false	true
01a0f7a8-8561-7cd1-bfc5-308c03889f70	AAPL	2026-10-01 09:30	call_diagonal_spread	2	1	45	126090.00	short	bid	329.6000	2.6500	["325","330"]	["0.2984","0.2732"]	[]	["BATO"]	325.0000	330.0000	29	50	false	false	true
01a0f7a8-8561-7cd1-bfc5-307cd12445ba	AAPL	2026-10-01 09:30	other	6	2	11	178033.00	unknown	—	329.6000	8.8000	["320","330","350"]	["0.2884","0.2523","0.2670"]	[]	["XISX","XPHO"]	320.0000	350.0000	29	841	false	false	true	true	true
01a0f7a8-8561-7cd1-bfc5-2f571985accf	AAPL	2026-10-01 09:30	call_calendar	2	2	33	511027.00	short	ask	330.2300	6.9167	["320"]	["0.2884"]	[]	["XCBO","XISX"]	320.0000	320.0000	806	841	false	false	true
01a0f7a8-6a43-78f1-bebb-0d974f5d3cf0	AAPL	2026-10-01 09:30	call_calendar	2	1	2	36184.00	short	ask	329.5725	5.5000	["240"]	["2.3115"]	[]	["XISX"]	240.0000	240.0000	1	8	false	false	true
01a0f7a8-6a43-78f1-bebb-0d69e99bed5b	AAPL	2026-10-01 09:30	call_vertical_spread	2	1	8	106160.00	long	ask	329.5725	5.1000	["260","380"]	["0.3090","0.2705"]	["326.18"]	["XPHO"]	260.0000	380.0000	533	533	false	false	false
01a0f7a8-6a43-78f1-bebb-0d5d7222f669	AAPL	2026-10-01 09:30	call_diagonal_spread	2	1	4	40596.00	long	ask	329.5725	6.4000	["340","350"]	["0.2809","0.2798"]	[]	["XISX"]	340.0000	350.0000	533	624	false	true	true
01a0f7a8-6a43-78f1-bebb-0d431cb79aca	AAPL	2026-10-01 09:30	call_diagonal_spread	2	1	2	27100.00	short	ask	329.5725	5.5000	["290","320"]	["0.2940","0.2839"]	[]	["XISX"]	290.0000	320.0000	477	533	false	false	true
01a0f3e7-00ef-7d23-aab3-2c4f9b1f01a4	AAPL	2026-09-30 15:59	call_diagonal_spread	2	1	13	84487.00	long	ask	333.1500	1.8000	["340","355"]	["0.2721","0.2725"]	[]	["XPHO"]	340.0000	355.0000	260	352	false	true	true
01a0f3e6-938f-7ac1-8065-24d4d663a4ee	AAPL	2026-09-30 15:59	put_vertical_spread	2	1	20	44140.00	long	ask	333.3700	2.0500	["335","347.5"]	["0.2240","0.2247"]	["338.99"]	["EMLD"]	335.0000	347.5000	16	16	false	false	false
01a0f3e4-da26-70e2-8655-c0c5ce13518a	AAPL	2026-09-30 15:57	call_diagonal_spread	2	2	57	88920.00	long	ask	333.3500	0.8000	["350","360"]	["0.2479","0.2412"]	[]	["XMIO"]	350.0000	360.0000	51	107	false	true	true
01a0f3e4-da26-70e2-8655-c0b1fd816235	AAPL	2026-09-30 15:57	call_diagonal_spread	2	1	10	63490.00	short	bid	333.3600	1.8500	["320","350"]	["0.2738","0.2693"]	[]	["XBOX"]	320.0000	350.0000	107	352	false	false	true
01a0f3e3-b146-7833-8c2d-e04e472ad327	AAPL	2026-09-30 15:56	put_vertical_spread	2	1	20	30060.00	long	ask	333.2000	1.3000	["332.5","345"]	["0.2217","0.2243"]	["336.01"]	["XISX"]	332.5000	345.0000	5	5	false	false	false
01a0f3e3-95ee-7110-96ea-226a09c55253	AAPL	2026-09-30 15:56	call_diagonal_spread	2	1	10	47010.00	short	bid	333.2100	1.7500	["330","375"]	["0.2658","0.2631"]	[]	["ARCO"]	330.0000	375.0000	107	352	false	false	true
01a0f3e2-5d6f-78b1-83b6-ec91da679aad	AAPL	2026-09-30 15:54	call_calendar	2	1	25	45750.00	unknown	bid	333.4900	1.8000	["325"]	["0.2554"]	[]	["XISX"]	325.0000	325.0000	2	5	false	false	true
01a0f3e2-5987-7e63-9b78-3a617027bec1	AAPL	2026-09-30 15:54	other	4	1	5	25810.00	unknown	ask	333.6800	3.9200	["305","330","355","375"]	["0.3294","0.2718","0.2202","0.2272"]	[]	["XPHO"]	305.0000	375.0000	16	198	false	false	true
01a0f3df-ec6e-7af2-adee-eac5471fd522	AAPL	2026-09-30 15:52	call_calendar	2	1	5	45030.00	short	bid	334.3700	4.8500	["290"]	["10.8687"]	[]	["XISX"]	290.0000	290.0000	0	12	false	false	true
01a0f3df-9e4f-7d60-8641-dcb13866968f	AAPL	2026-09-30 15:51	call_diagonal_spread	2	1	11	59191.00	long	ask	334.3450	1.4000	["360","380"]	["0.2653","0.2685"]	[]	["XPHO"]	360.0000	380.0000	260	443	false	true	true
01a0f3df-34d7-7a31-b17f-184ffc82be56	AAPL	2026-09-30 15:51	call_diagonal_spread	2	1	25	94750.00	long	bid	334.2800	4.1000	["315","320"]	["0.5533","0.2609"]	[]	["XMIO"]	315.0000	320.0000	2	23	false	false	true
01a0f3de-c38e-7823-8cee-a6492105ba72	AAPL	2026-09-30 15:50	call_diagonal_spread	2	1	2	25862.00	short	bid	334.3700	2.1700	["230","360"]	["0.3183","0.2481"]	[]	["XISX"]	230.0000	360.0000	37	534	false	false	true
01a0f3dd-ecbf-74b0-8557-67c00908a86f	AAPL	2026-09-30 15:50	call_diagonal_spread	2	5	74	32814.00	long	bid	335.2700	0.5200	["332.5","337.5"]	["1.8118","0.2691"]	[]	["ARCO","C2OX","EDGO","SPHR"]	332.5000	337.5000	0	2	false	false
01a0f3dc-a0af-7420-929b-143ffd2c4a5a	AAPL	2026-09-30 15:48	put_vertical_spread	2	1	100	99000.00	long	ask	335.2771	0.1900	["270","320"]	["0.3185","0.2673"]	["312.56"]	["XCBO"]	270.0000	320.0000	79	79	false	true	false