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:endpoint = /api/option-trades/multi-leg×ticker = AAOI×

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

01a0ee7b-23f7-70b2-ba3d-1b62718330da	AAOI	2026-09-29 14:44	other	3	1	40	311320.00	unknown	bid	101.5700	5.2000	["50","80","110"]	["0.9498","0.9662","0.9580"]	[]	["XISX"]	50.0000	110.0000	261	843	false	true	true	true	true	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T18:44:24Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0ed72-b0bf-72f1-ba3e-cf816f37c0af	AAOI	2026-09-29 09:55	other	4	2	30	239680.00	unknown	—	102.4400	8.4000	["109","113","140"]	["0.9247","1.2570","1.1280"]	[]	["XISX","XPHO"]	109.0000	140.0000	3	31	false	false	true	true	false
01a0e97c-54f7-7bf3-a4ae-8e7989ce44cf	AAOI	2026-09-28 15:27	call_vertical_spread	2	1	195	1027650.00	unknown	—	96.9000	4.2000	["70","71"]	["2.4165","2.3342"]	[]	["XCBO"]	70.0000	71.0000	4	4	false	false	false	true	false
01a0e97a-0337-7450-a396-5733988e7171	AAOI	2026-09-28 15:24	other	4	1	32	431696.00	unknown	—	96.9150	12.5000	["90","100","105","115"]	["0.9359","0.9397","0.9414","0.9425"]	[]	["XMIO"]	90.0000	115.0000	627	627	false	false	false	true	false
01a0e972-759e-74a1-a4b4-7708d7aa71aa	AAOI	2026-09-28 15:16	call_vertical_spread	2	1	20	104220.00	long	ask	96.9700	4.8000	["70","71"]	["2.2254","2.2216"]	["70.99"]	["XCBO"]	70.0000	71.0000	4	4	false	false	false
01a0e972-277f-7182-9f99-46658a3d6716	AAOI	2026-09-28 15:16	call_vertical_spread	2	1	88	458568.00	long	ask	96.8000	4.8000	["70","71"]	["2.3425","2.3288"]	["70.99"]	["XCBO"]	70.0000	71.0000	4	4	false	false	false
01a0e971-b637-7602-9623-c097b305a3f8	AAOI	2026-09-28 15:15	call_vertical_spread	2	1	88	458568.00	long	ask	96.8000	4.8000	["70","71"]	["2.3425","2.3288"]	["70.99"]	["XCBO"]	70.0000	71.0000	4	4	true	false	false
01a0e96f-77ff-79b2-bc78-8dbf0f3f713d	AAOI	2026-09-28 15:13	other	4	1	166	261284.00	unknown	ask	96.9800	2.0500	["85","92","95","100"]	["0.8318","0.9299","0.8431","0.9674"]	[]	["AMXO"]	85.0000	100.0000	4	18	false	false	true
01a0e923-28d7-7640-b19a-97c5ce550627	AAOI	2026-09-28 13:49	other	3	2	50	346350.00	unknown	ask	95.9400	3.1000	["50","80","110"]	["0.9502","0.9593","0.9405"]	[]	["XPHO"]	50.0000	110.0000	172	844	false	true	true
01a0e88e-7a57-7d12-a03a-710fd4ae20a7	AAOI	2026-09-28 11:07	put_vertical_spread	2	1	40	105600.00	short	bid	94.3750	2.8000	["88","104"]	["0.9736","1.0029"]	["94.46"]	["AMXO"]	88.0000	104.0000	39	39	true	false	false
01a0da23-5c8f-7d01-8866-e8ab1a43fe8e	AAOI	2026-09-25 15:55	call_vertical_spread	2	1	88	516560.00	unknown	—	101.4820	7.8000	["72","73"]	["1.4590","1.4091"]	[]	["XCBO"]	72.0000	73.0000	7	7	false	false	false	true	false
01a0da22-899f-70b2-a172-5795e4a477cd	AAOI	2026-09-25 15:54	call_vertical_spread	2	1	88	515416.00	long	ask	101.5500	2.7000	["72","73"]	["1.3147","1.2807"]	["72.99"]	["XCBO"]	72.0000	73.0000	7	7	false	false	false
01a0da1e-e407-7f71-9590-bf97f90b4d79	AAOI	2026-09-25 15:50	call_vertical_spread	2	1	177	1036512.00	long	ask	101.5300	2.7000	["72","73"]	["1.3388","1.2919"]	["73"]	["XCBO"]	72.0000	73.0000	7	7	false	false	false
01a0da1d-ea07-7c01-bf40-deb99891f3f8	AAOI	2026-09-25 15:49	call_vertical_spread	2	1	177	929250.00	unknown	—	101.5700	3.4000	["75","76"]	["1.1126","1.0696"]	[]	["XCBO"]	75.0000	76.0000	7	7	false	false	false	true	false
01a0da1b-ee37-7123-aba3-06b2754d1893	AAOI	2026-09-25 15:47	call_vertical_spread	2	1	177	1037397.00	long	ask	101.5900	2.6000	["72","73"]	["1.2895","1.2570"]	["72.99"]	["XCBO"]	72.0000	73.0000	7	7	true	false	false
01a0da18-cd6f-7320-a46d-62d0f844a182	AAOI	2026-09-25 15:44	call_vertical_spread	2	1	88	462616.00	long	ask	101.4200	3.5000	["75","76"]	["1.3020","1.2620"]	["75.99"]	["XCBO"]	75.0000	76.0000	7	7	false	false	false
01a0da18-5457-76f2-885d-7d0782036c88	AAOI	2026-09-25 15:43	call_vertical_spread	2	1	88	462440.00	long	ask	101.3900	3.5000	["75","76"]	["1.3177","1.2770"]	["75.99"]	["XMIO"]	75.0000	76.0000	7	7	false	false	false
01a0da17-69f7-7d40-97ca-42665d31984d	AAOI	2026-09-25 15:42	call_vertical_spread	2	1	88	462528.00	long	ask	101.4000	3.5000	["75","76"]	["1.3181","1.2694"]	["76"]	["XCBO"]	75.0000	76.0000	7	7	false	false	false
01a0da16-931f-7ed0-8752-01bec5823d42	AAOI	2026-09-25 15:41	call_vertical_spread	2	1	88	466136.00	long	ask	101.3950	4.5000	["75","76"]	["1.4645","1.4182"]	["75.99"]	["XCBO"]	75.0000	76.0000	7	7	true	false	false
01a0da14-54e7-77f2-bded-322c73139a65	AAOI	2026-09-25 15:39	call_vertical_spread	2	1	188	1191920.00	unknown	—	101.4490	5.2000	["70","71"]	["1.8471","1.7894"]	[]	["XCBO"]	70.0000	71.0000	7	7	false	false	false	true	false
01a0da12-9b7f-7660-82ad-f1ddf5845556	AAOI	2026-09-25 15:37	call_vertical_spread	2	1	188	1193236.00	long	ask	101.3600	5.1000	["70","71"]	["1.9152","1.8615"]	["70.99"]	["XCBO"]	70.0000	71.0000	7	7	true	false	false
01a0da06-667f-7ca3-9f00-09b8af7260ec	AAOI	2026-09-25 15:24	call_vertical_spread	2	1	30	120420.00	short	bid	101.6820	1.8000	["150","160"]	["0.9635","0.9642"]	["151.80"]	["XPHO"]	150.0000	160.0000	265	265	false	true	false
01a0d938-73d7-7812-9ce5-78e8d5317767	AAOI	2026-09-25 11:39	call_vertical_spread	2	1	100	347000.00	long	ask	101.8300	3.6000	["250","350"]	["0.9627","0.9759"]	["256.20"]	["XMIO"]	250.0000	350.0000	483	483	false	true	false
01a0d8f7-9277-7073-b505-8f5f287b3cda	AAOI	2026-09-25 10:28	call_vertical_spread	2	1	182	855400.00	unknown	—	101.2000	4.0000	["77","78"]	["8.2515","7.9485"]	[]	["XCBO"]	77.0000	78.0000	0	0	false	false	false	true	false
01a0d8f5-8aef-7c93-ab5d-80ce6a4de2e1	AAOI	2026-09-25 10:26	call_vertical_spread	2	1	44	206756.00	long	ask	100.9800	4.1000	["77","78"]	["3.9228","4.0892"]	["77.99"]	["XISX"]	77.0000	78.0000	0	0	false	false	false
01a0d8f5-2d2f-7440-a467-163b0f09c15f	AAOI	2026-09-25 10:25	call_vertical_spread	2	1	25	117475.00	long	ask	100.9899	4.1000	["77","78"]	["8.7112","3.7541"]	["77.99"]	["XISX"]	77.0000	78.0000	0	0	false	false	false
01a0d8f3-680f-7180-b2fa-3a550ae994c8	AAOI	2026-09-25 10:23	call_vertical_spread	2	1	88	411752.00	long	ask	100.8700	4.5000	["77","78"]	["4.2436","4.2781"]	["77.99"]	["XISX"]	77.0000	78.0000	0	0	false	false	false
01a0d8f3-0a4f-7d60-85fc-01946b1b7c75	AAOI	2026-09-25 10:23	call_vertical_spread	2	1	25	116975.00	long	ask	100.6461	4.5000	["77","78"]	["6.1709","5.9693"]	["77.99"]	["XISX"]	77.0000	78.0000	0	0	false	false	false
01a0d8d8-371f-77f3-ae28-b688e91feb16	AAOI	2026-09-25 09:54	other	4	2	30	307594.00	unknown	—	102.2000	4.7000	["105","140"]	["1.0277","0.9870"]	[]	["XISX"]	105.0000	140.0000	0	265	false	false	true	true	true
01a0d4e9-9bb7-7502-bb59-493633b7a808	AAOI	2026-09-24 15:34	call_vertical_spread	2	1	61	269620.00	unknown	—	100.8175	5.6000	["79","80"]	["3.6026","3.4596"]	[]	["XCBO"]	79.0000	80.0000	1	1	false	false	false	true	false
01a0d4e8-e036-7c52-9b23-dbc20a087ad0	AAOI	2026-09-24 15:33	call_vertical_spread	2	1	88	388960.00	unknown	—	100.7100	5.6000	["79","80"]	["3.7213","3.5747"]	[]	["XCBO"]	79.0000	80.0000	1	1	false	false	false	true	false
01a0d4d2-ef06-7130-b568-db243f3e04ca	AAOI	2026-09-24 15:09	call_vertical_spread	2	1	25	113025.00	long	ask	101.9200	5.3000	["79","80"]	["2.6785","2.5928"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d4d2-bc3f-7b31-90fa-9bf62630a5c9	AAOI	2026-09-24 15:09	call_vertical_spread	2	1	25	113025.00	long	ask	101.9500	5.3000	["79","80"]	["2.5923","2.5126"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d4d2-7dbe-78d2-9f27-e35c70503f61	AAOI	2026-09-24 15:09	call_vertical_spread	2	1	25	113025.00	long	ask	101.8800	5.3000	["79","80"]	["2.7800","2.6880"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d4d2-470f-7793-a239-af81dcd20eb1	AAOI	2026-09-24 15:09	call_vertical_spread	2	1	25	113025.00	long	ask	101.9000	5.3000	["79","80"]	["2.7308","2.6418"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d4d0-6e66-7943-aa85-aff816acdac8	AAOI	2026-09-24 15:07	call_vertical_spread	2	1	25	113025.00	long	ask	102.0259	5.3000	["79","80"]	["2.3022","2.2495"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d4d0-148e-7930-924d-639c0b042157	AAOI	2026-09-24 15:06	call_vertical_spread	2	1	25	113025.00	long	ask	101.9200	5.3000	["79","80"]	["2.6785","2.5928"]	["79.99"]	["XISX"]	79.0000	80.0000	1	1	false	false	false
01a0d3f4-6a2f-7fc0-99cb-44965008deb1	AAOI	2026-09-24 11:06	put_calendar	2	1	55	284350.00	unknown	—	98.7600	4.2000	["125"]	["2.1433"]	[]	["BATO"]	125.0000	125.0000	1	8	false	false	true	false	false
01a0cfb5-d236-7de1-abbb-b5a120a658ae	AAOI	2026-09-23 15:19	call_vertical_spread	2	1	39	200460.00	unknown	—	101.7800	4.4000	["76","77"]	["2.5104","2.4181"]	[]	["XCBO"]	76.0000	77.0000	2	2	false	false	false	true	false
01a0cfb3-f5a6-7203-9970-c682e5a8ce5a	AAOI	2026-09-23 15:17	call_vertical_spread	2	1	50	257000.00	unknown	—	101.6400	4.4000	["76","77"]	["2.6733","2.5764"]	[]	["XCBO"]	76.0000	77.0000	2	2	false	false	false	true	false
01a0cfb1-905f-7f93-a412-a297572900b0	AAOI	2026-09-23 15:15	call_vertical_spread	2	1	50	257000.00	unknown	—	101.7900	4.4000	["76","77"]	["2.4977","2.4057"]	[]	["XCBO"]	76.0000	77.0000	2	2	false	false	false	true	false
01a0cfa3-869f-7173-a337-e4dc296d45a9	AAOI	2026-09-23 14:59	call_vertical_spread	2	1	50	257000.00	unknown	—	102.0900	4.4000	["76","77"]	["1.9448","1.8690"]	[]	["XCBO"]	76.0000	77.0000	2	2	false	false	false	true	false
01a0cf9e-b057-7562-9f3b-ccba44602a2f	AAOI	2026-09-23 14:54	call_vertical_spread	2	1	49	173460.00	unknown	—	102.0000	3.6000	["84","85"]	["1.5263","1.4488"]	[]	["XCBO"]	84.0000	85.0000	2	2	false	false	false	true	false
01a0cf98-b8fe-7902-86c2-a84fa3360b49	AAOI	2026-09-23 14:48	call_vertical_spread	2	1	49	173460.00	unknown	—	101.9250	3.6000	["84","85"]	["1.6308","1.5493"]	[]	["XCBO"]	84.0000	85.0000	2	2	false	false	false	true	false
01a0cf94-a607-77b2-8d14-e899e188b1b8	AAOI	2026-09-23 14:43	call_vertical_spread	2	1	50	178500.00	unknown	—	102.1800	3.0000	["84","85"]	["1.4862","1.4107"]	[]	["XCBO"]	84.0000	85.0000	2	2	false	false	false	true	false
01a0cf8e-50ef-7e20-a269-2ac0f12218da	AAOI	2026-09-23 14:36	call_vertical_spread	2	1	99	355509.00	long	ask	102.2000	2.8000	["84","85"]	["1.6139","1.5473"]	["84.99"]	["XCBO"]	84.0000	85.0000	2	2	false	false	false
01a0cf8d-a50e-79c2-be6b-86fc9392aabd	AAOI	2026-09-23 14:35	call_vertical_spread	2	1	88	316008.00	long	ask	102.1250	2.8000	["84","85"]	["1.7070","1.6351"]	["84.99"]	["XCBO"]	84.0000	85.0000	2	2	false	false	false
01a0cf8b-37f7-7c01-9483-21bbe9ef05c5	AAOI	2026-09-23 14:33	call_vertical_spread	2	1	88	354288.00	long	ask	102.4450	2.7000	["82","83"]	["1.6824","1.6051"]	["83"]	["XCBO"]	82.0000	83.0000	2	2	false	false	false
01a0cf89-1517-75e3-8fce-0824fab419e8	AAOI	2026-09-23 14:30	call_vertical_spread	2	1	88	354200.00	long	ask	102.5550	2.9000	["82","83"]	["1.3815","1.3516"]	["82.99"]	["XMIO"]	82.0000	83.0000	2	2	false	false	false
01a0cf85-9a77-7050-9772-08af67c630f3	AAOI	2026-09-23 14:27	call_vertical_spread	2	1	188	979292.00	long	ask	102.6250	3.2000	["76","77"]	["2.8651","2.8646"]	["76.99"]	["XISX"]	76.0000	77.0000	2	2	false	false	false