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

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

01a0caa8-5567-7493-b28d-7883a522e3ba	AAOI	2026-09-22 15:47	put_diagonal_spread	2	1	63	114975.00	unknown	bid	107.0200	2.2000	["110","112"]	["0.8404","0.8617"]	[]	["XBOX"]	110.0000	112.0000	10	17	false	false	true	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T19:47:17Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0c96c-d7c7-7382-a6ec-e189c23edd5b	AAOI	2026-09-22 10:02	call_diagonal_spread	2	1	12	125160.00	unknown	—	109.7650	7.8000	["100","120"]	["0.9756","0.9781"]	[]	["XISX"]	100.0000	120.0000	486	633	false	false	true	true
01a0c4bc-7acf-71b0-af2f-824a99638e8b	AAOI	2026-09-21 12:11	put_diagonal_spread	2	1	63	111825.00	unknown	—	108.7800	1.7000	["112","115"]	["0.9570","1.1003"]	[]	["BATO"]	112.0000	115.0000	4	11	false	false	true	true
01a0c4b3-148f-77f3-926f-1784ab2c2b7e	AAOI	2026-09-21 12:01	call_vertical_spread	2	1	500	1822500.00	long	ask	108.5250	4.7000	["90","92"]	["1.3426","1.2998"]	["91.85"]	["XMIO"]	90.0000	92.0000	4	4	false	false
01a0c4a9-fc6f-7f52-aa98-b06171407dbd	AAOI	2026-09-21 11:51	risk_reversal	3	4	34	219976.00	long	bid	109.0105	4.1000	["60","125","150"]	["0.9615","0.9709","0.9709"]	["58.20"]	["ARCO","EDGO","XCBO","XISX"]	60.0000	150.0000	269	269	false	true
01a0c4a9-fc6f-7f52-aa98-b05ca5df3ecf	AAOI	2026-09-21 11:51	risk_reversal	3	6	16	103486.00	long	bid	109.0105	4.1000	["60","125","150"]	["0.9623","0.9708","0.9700"]	["58.21"]	["C2OX","EMLD","MCRY","XBOX","XMIO","XPHO"]	60.0000	150.0000	269	269	false	true
01a0c4a9-5477-7693-a77d-e1f0d1b712bd	AAOI	2026-09-21 11:50	risk_reversal	3	4	34	219857.00	long	bid	109.1150	4.2000	["60","125","150"]	["0.9620","0.9686","0.9690"]	["58.20"]	["ARCO","EDGO","XCBO","XISX"]	60.0000	150.0000	269	269	false	true
01a0c46e-56e7-7032-8706-1206b7f0dd30	AAOI	2026-09-21 10:45	put_calendar	2	1	20	155900.00	unknown	—	106.4750	5.5000	["145"]	["1.1088"]	[]	["ARCO"]	145.0000	145.0000	11	32	false	false	true	false
01a0b5ef-bfa7-7d43-bd3f-42ad39bf51e0	AAOI	2026-09-18 15:13	other	4	3	44	232424.00	unknown	—	105.1200	4.9000	["120","130","160"]	["1.0033","1.0362","16.3482"]	[]	["XISX"]	120.0000	160.0000	0	63	false	false	true	true
01a0b561-2f8f-7671-ad3e-23bcbfdc532f	AAOI	2026-09-18 12:37	put_calendar	2	1	55	270050.00	unknown	—	100.5700	2.6000	["125"]	["4.6559"]	[]	["BATO"]	125.0000	125.0000	0	7	false	false	true	false
01a0b55e-5130-76b2-ae75-63cf68fc182c	AAOI	2026-09-18 12:34	other	4	2	20	121680.00	unknown	bid	100.4600	7.1000	["108","110","120"]	["0.8471","1.9845","3.9939"]	[]	["SPHR","XCBO"]	108.0000	120.0000	0	14	false	false
01a0b542-2257-7cc1-bd8b-bba22c730c1c	AAOI	2026-09-18 12:03	other	4	7	27	129922.00	unknown	ask	101.1800	3.0500	["90","150","200"]	["0.9353","0.9629","0.9868"]	[]	["ARCO","EMLD","MCRY","SPHR","XISX","XMIO","XPHO"]	90.0000	200.0000	91	182	false	true
01a0b542-2257-7cc1-bd8b-bb9af9c81be7	AAOI	2026-09-18 12:03	other	4	9	38	182946.00	unknown	ask	101.1800	3.0500	["90","150","200"]	["0.9338","0.9646","0.9903"]	[]	["AMXO","ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"]	90.0000	200.0000	91	182	false	true
01a0b541-91cf-7d32-b42d-97511b133e53	AAOI	2026-09-18 12:02	call_vertical_spread	2	1	600	1200000.00	short	bid	101.0500	3.2000	["90","92"]	["5.0901","4.4071"]	["91.98"]	["XMIO"]	90.0000	92.0000	0	0	false	false
01a0b509-d447-7aa3-a675-df0a8ddeaafd	AAOI	2026-09-18 11:01	call_diagonal_spread	2	2	50	410250.00	short	bid	100.3400	4.0000	["100","200"]	["0.9611","0.9730"]	[]	["MCRY"]	100.0000	200.0000	490	854	false	false
01a0b082-4cb3-7ab2-b35c-074df146ebde	AAOI	2026-09-17 13:55	call_vertical_spread	2	1	44	589116.00	long	ask	98.1950	2.6000	["31","32"]	["10.8083","10.7298"]	["31.97"]	["XMIO"]	31.0000	32.0000	1	1	false	false
01a0af8f-6135-74e1-a302-3e22f01978ca	AAOI	2026-09-17 09:30	call_vertical_spread	2	1	50	185450.00	long	ask	100.7200	4.8000	["80","85"]	["2.7151","2.2309"]	["84.93"]	["XISX"]	80.0000	85.0000	1	1	false	false
01a0abc0-6b5b-7923-9606-b6af18804052	AAOI	2026-09-16 15:45	call_vertical_spread	2	1	454	709148.00	unknown	—	95.8700	1.0000	["90","92"]	["0.8577","0.8281"]	[]	["XBOX"]	90.0000	92.0000	9	9	true	false	false	true
01a0a5cc-bfee-7580-acec-40304babcf1b	AAOI	2026-09-15 12:00	call_vertical_spread	2	1	90	363060.00	long	ask	96.2800	1.6000	["80","110"]	["0.9382","0.9522"]	["92.50"]	["MCRY"]	80.0000	110.0000	94	94	false	false
01a0a588-a26d-76b1-9568-15e1f242c4ba	AAOI	2026-09-15 10:46	put_calendar	2	1	33	100320.00	unknown	—	97.6500	1.5000	["110"]	["0.9837"]	[]	["XISX"]	110.0000	110.0000	3	31	false	false	true	false
01a0a133-a4e0-7080-bab2-028c9c01f021	AAOI	2026-09-14 14:35	call_vertical_spread	2	1	20	371500.00	unknown	—	98.3434	8.5000	["5","8"]	["1.5877","1.3280"]	[]	["XPHO"]	5.0000	8.0000	494	494	false	false	false	true
01a0a0b7-9328-72d0-8106-962fd721b591	AAOI	2026-09-14 12:19	iron_condor	4	1	70	102130.00	unknown	—	98.6650	1.8000	["97","98","99","100"]	["1.0231","0.9778","1.0171","0.9900"]	[]	["XMIO"]	97.0000	100.0000	4	4	false	true	false	true
01a0a08d-5e78-7ba0-bbce-0d59c0c5a04b	AAOI	2026-09-14 11:33	call_vertical_spread	2	1	100	630000.00	unknown	—	98.2850	4.0000	["130","350"]	["0.9926","0.9967"]	[]	["XMIO"]	130.0000	350.0000	641	641	false	true	false	true
01a0a08a-ce38-7e40-81bd-01f3d5254e34	AAOI	2026-09-14 11:30	call_vertical_spread	2	1	50	313250.00	unknown	—	97.8900	3.3000	["130","350"]	["0.9931","0.9979"]	[]	["XMIO"]	130.0000	350.0000	641	641	false	true	false	true
01a0a069-7af9-7a52-958e-843ff7ba8a54	AAOI	2026-09-14 10:54	put_diagonal_spread	2	8	20	105982.00	long	ask	96.8000	1.7000	["100","110"]	["0.9618","0.9499"]	[]	["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"]	100.0000	110.0000	95	186	false	false
01a0a038-aec8-7692-a5b7-f375d10bf51c	AAOI	2026-09-14 10:01	call_diagonal_spread	2	1	51	529431.00	short	bid	98.0300	5.8000	["100","105"]	["0.9751","1.0061"]	[]	["XISX"]	100.0000	105.0000	641	858	false	true
01a0a02a-62a1-7d51-90be-0da4688ef3e3	AAOI	2026-09-14 09:45	other	2	1	40	265880.00	unknown	—	98.4100	6.1000	["125","130"]	["1.0081","1.3081"]	[]	["XISX"]	125.0000	130.0000	11	95	false	false	true	true	false
01a0a021-3ec8-7d71-a706-5f5e82196ee2	AAOI	2026-09-14 09:35	call_vertical_spread	2	1	20	182600.00	unknown	—	98.1800	7.0000	["105","120"]	["0.9762","0.9806"]	[]	["XISX"]	105.0000	120.0000	641	641	false	true	false	true
01a091ed-8898-7f43-8d44-60f820e8f754	AAOI	2026-09-11 15:24	other	3	1	20	133300.00	unknown	—	105.2900	3.2000	["55","125","135"]	["0.9289","0.9274","0.9565"]	[]	["XISX"]	55.0000	135.0000	7	126	false	false	true	true
01a091a8-f9d1-7502-a279-ac8069a3fe80	AAOI	2026-09-11 14:09	put_vertical_spread	2	1	169	142636.00	long	ask	105.8400	0.7500	["95","105"]	["0.8043","0.8093"]	["101.10"]	["XISX"]	95.0000	105.0000	14	14	false	true
01a09116-df79-7e91-a475-f92acd398814	AAOI	2026-09-11 11:29	other	2	1	15	192825.00	unknown	—	105.8750	5.9000	["42","70"]	["3.5062","0.9882"]	[]	["BATO"]	42.0000	70.0000	7	644	false	false	true	true	false
01a09102-e631-7752-8e94-a20497ed22e1	AAOI	2026-09-11 11:07	call_diagonal_spread	2	1	10	128100.00	long	ask	105.3650	4.7000	["42","70"]	["3.4024","1.0045"]	[]	["XPHO"]	42.0000	70.0000	7	644	false	false
01a08c8d-4079-7540-8672-d17e0b2de92b	AAOI	2026-09-10 14:20	put_diagonal_spread	2	5	49	115060.00	short	bid	103.8900	3.2857	["101","115"]	["0.9039","1.5888"]	[]	["EMLD","SPHR","XBOX","XPHO"]	101.0000	115.0000	1	50	false	false
01a08c83-e9d9-78b0-8378-3e87f1d49edc	AAOI	2026-09-10 14:10	other	2	1	10	117800.00	unknown	—	103.4100	5.4000	["45","50"]	["3.4185","1.0410"]	[]	["MCRY"]	45.0000	50.0000	8	190	false	false	true	true	false
01a087b1-2061-7fc3-8259-f640003aeb76	AAOI	2026-09-09 15:42	other	2	2	10	108400.00	unknown	—	108.4350	4.2000	["55","70"]	["2.6776","1.0071"]	[]	["XPHO"]	55.0000	70.0000	9	281	false	false	true	true	false
01a086f7-3e71-7db3-98ff-a21fc6bb5fdf	AAOI	2026-09-09 12:19	other	2	1	18	144450.00	unknown	—	110.9200	6.7000	["120","135"]	["1.0053","0.9907"]	[]	["ARCO"]	120.0000	135.0000	191	646	false	true	true	true	false
01a0869e-7bc8-73d0-89a5-c0bef98a6ff3	AAOI	2026-09-09 10:42	call_vertical_spread	2	1	30	125400.00	unknown	—	110.8150	3.1000	["130","180"]	["1.0001","1.0134"]	[]	["XISX"]	130.0000	180.0000	191	191	false	true	false	true
01a0821f-a298-7d50-8c5d-064190ce1521	AAOI	2026-09-08 13:45	put_diagonal_spread	2	1	63	125055.00	long	ask	113.4400	1.5000	["115","118"]	["0.9447","0.9783"]	[]	["BATO"]	115.0000	118.0000	10	17	false	false
01a081e6-9909-74a2-b9da-36e4ca777730	AAOI	2026-09-08 12:42	put_calendar	2	1	20	129860.00	short	bid	114.2800	3.8000	["145"]	["1.0278"]	[]	["XPHO"]	145.0000	145.0000	10	24	false	false
01a081dd-ee48-7c00-8849-a2cfc3ccbcd7	AAOI	2026-09-08 12:33	other	4	1	64	120812.00	unknown	—	113.9083	2.4000	["109","110","115","116"]	["1.1045","1.0778","1.1067","1.1156"]	[]	["XMIO"]	109.0000	116.0000	3	3	false	false	false	true
01a08180-bed1-7f02-9be0-8e4e98e65dd0	AAOI	2026-09-08 10:51	put_calendar	2	1	45	359550.00	long	ask	116.5201	3.9000	["145"]	["1.0123"]	[]	["XISX"]	145.0000	145.0000	38	129	false	false
01a08170-b170-7b20-90e3-cbd38af400d3	AAOI	2026-09-08 10:33	put_diagonal_spread	2	1	32	113120.00	short	bid	115.6500	4.3000	["115","135"]	["1.0390","0.9690"]	[]	["SPHR"]	115.0000	135.0000	10	45	false	false
01a08163-ad68-7000-99b8-6eaf9417e9b9	AAOI	2026-09-08 10:19	other	4	4	300	357164.00	unknown	—	113.7900	3.0500	["85","105","120"]	["1.0960","1.0039","1.0373"]	[]	["C2OX","XMIO"]	85.0000	120.0000	10	101	false	false	true	true
01a06df4-eea5-7d53-b75d-18f7f20a6f8f	AAOI	2026-09-04 15:46	put_diagonal_spread_bullish	2	1	63	190890.00	long	ask	105.1900	2.2000	["118","119"]	["0.8698","0.8679"]	[]	["BATO"]	118.0000	119.0000	7	14	false	false