Multi-leg option trades

core.multileg_trades

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

508,354 rowsCSV — whole table, not this view

Sources in this table

uw_multileg508,354 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×strategy = other×ticker = ORCL×

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

01a0da25-40ee-7262-b929-107f3e72210e	ORCL	2026-09-25 15:57	other	2	1	167	89178.00	unknown	ask	137.2200	0.4900	["70","200"]	["0.6021","0.5999"]	[]	["ARCO"]	70.0000	200.0000	84	357	false	true	true	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T19:57:53Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0da23-357e-7fb2-a969-4b627bb8d4ac	ORCL	2026-09-25 15:55	other	4	1	20	32320.00	unknown	—	137.1399	0.5900	["132","135","138","140"]	["0.4870","0.4935","0.4661","0.4784"]	[]	["XMIO"]	132.0000	140.0000	7	14	false	false	true	true
01a0da12-babf-7fa2-88f9-dcea9e0e515e	ORCL	2026-09-25 15:37	other	4	2	100	35127.00	unknown	ask	137.4475	0.7300	["136","138","140"]	["0.4625","0.4776","1.6783"]	[]	["XISX","XPHO"]	136.0000	140.0000	0	7	false	false
01a0da10-caa7-7060-8e53-a091a636a2f2	ORCL	2026-09-25 15:35	other	4	1	20	34530.00	unknown	bid	137.4150	0.6300	["130","140","180","220"]	["0.5244","0.5293","0.5592","0.5862"]	[]	["XISX"]	130.0000	220.0000	56	112	false	false
01a0da01-9807-7831-8eb5-4f6f4fe4a292	ORCL	2026-09-25 15:18	other	7	3	12	59354.00	unknown	—	137.9075	0.9500	["130","139","140","141","152.5","175","180"]	["0.4854","0.7789","0.4644","0.4988","0.4954","0.5483","0.5502"]	[]	["EMLD","SPHR","XISX"]	130.0000	180.0000	0	812	false	false	true	true
01a0d9fe-197f-7f31-b1c1-8a4e1da57f08	ORCL	2026-09-25 15:15	other	4	1	2	69736.00	unknown	—	137.9000	6.9500	["220","230"]	["0.6855","0.7020"]	[]	["EMLD"]	220.0000	230.0000	84	112	false	false	true	true	false
01a0d9f2-7cd7-7dc2-95e8-723cc0ca74bf	ORCL	2026-09-25 15:02	other	4	1	80	53488.00	unknown	—	137.9500	0.9300	["135","140","142","148"]	["0.4570","1.1094","1.7881","2.1122"]	[]	["XISX"]	135.0000	148.0000	0	7	false	false	true	true
01a0d9cb-5d36-7fd2-87f5-c507431036ea	ORCL	2026-09-25 14:19	other	6	2	32	35040.00	unknown	ask	138.6400	0.6800	["134","140","141","143","149"]	["0.4576","0.5765","0.4680","1.2847","0.5058"]	[]	["EMLD","SPHR"]	134.0000	149.0000	0	7	false	false
01a0d9a3-206f-7131-b629-9b5614fa5bfe	ORCL	2026-09-25 13:35	other	3	5	45	54469.00	unknown	bid	138.0600	0.4900	["140"]	["0.4579"]	[]	["ARCO","EMLD","SPHR","XPHO"]	140.0000	140.0000	7	21	false	true
01a0d9a3-1c86-70e3-8b8e-2b2cecb782dc	ORCL	2026-09-25 13:35	other	3	2	27	32724.00	unknown	—	138.0600	0.4900	["140"]	["0.4584"]	[]	["C2OX","EDGO"]	140.0000	140.0000	7	21	false	true	true	false	false
01a0d990-a20f-7be2-9897-4dc0704940cf	ORCL	2026-09-25 13:15	other	3	1	50	25300.00	unknown	bid	138.4099	0.2900	["131","138","139"]	["0.4598","0.4598","0.5690"]	[]	["XISX"]	131.0000	139.0000	0	7	false	false
01a0d972-92bf-7c20-8fed-1cb54dcfee12	ORCL	2026-09-25 12:42	other	4	1	10	60630.00	unknown	—	139.0550	1.4500	["130","135","140"]	["0.5408","0.5198","0.5012"]	[]	["XPHO"]	130.0000	140.0000	56	84	false	false	true	true
01a0d96c-f926-7561-ac07-10c0148abf9d	ORCL	2026-09-25 12:36	other	4	1	4	59564.00	unknown	—	138.8700	3.0500	["125","140","200"]	["0.5498","0.5236","0.6606"]	[]	["XISX"]	125.0000	200.0000	56	147	false	false	true	true
01a0d96b-7e3f-7af0-9064-b733ba227459	ORCL	2026-09-25 12:34	other	4	1	6	118170.00	unknown	—	138.6600	6.4000	["130","140","220"]	["0.5668","0.5655","0.7148"]	[]	["XMIO"]	130.0000	220.0000	84	175	false	false	true	true
01a0d951-faff-7140-ad90-2fdb66d7d9ba	ORCL	2026-09-25 12:07	other	4	4	90	184396.00	unknown	—	138.2450	1.0600	["138","140","148"]	["0.4680","0.5716","1.1620"]	[]	["XISX","XPHO"]	138.0000	148.0000	0	7	false	false	true	true
01a0d949-6b96-7451-a91d-ef8656e91961	ORCL	2026-09-25 11:57	other	4	1	3	28833.00	unknown	ask	137.6050	1.3500	["160","162.5"]	["0.6316","0.6666"]	[]	["AMXO"]	160.0000	162.5000	7	14	false	false
01a0d93f-6917-7362-bc77-11b8d60fd75f	ORCL	2026-09-25 11:46	other	4	1	3	30831.00	unknown	ask	137.5900	3.3500	["100","110","180"]	["0.5686","0.5679","0.5961"]	[]	["ARCO"]	100.0000	180.0000	84	175	false	false
01a0d909-0f07-7a81-bf1b-28af76b2ce4f	ORCL	2026-09-25 10:47	other	4	1	167	264593.00	unknown	—	138.3250	0.9000	["135","138","142","145"]	["0.4710","0.4668","0.6844","1.1562"]	[]	["XPHO"]	135.0000	145.0000	0	7	false	false	true	true
01a0d8e0-ed97-79b3-9c66-0aafb50b604f	ORCL	2026-09-25 10:03	other	6	4	11	51480.00	unknown	ask	138.5150	1.9682	["125","130","135","137","138","140"]	["0.4813","1.1840","0.5669","0.6434","0.6242","0.5679"]	[]	["EDGO","XISX","XPHO"]	125.0000	140.0000	0	265	false	false
01a0d8d9-1d97-7842-8704-d702d608e5c0	ORCL	2026-09-25 09:55	other	4	1	10	31360.00	unknown	—	140.0800	1.4000	["140","150"]	["0.4788","0.5119"]	[]	["XISX"]	140.0000	150.0000	7	14	false	false	true	true	false
01a0d8cf-d2af-7150-b210-b20ffcbd7240	ORCL	2026-09-25 09:44	other	5	2	36	53634.00	unknown	ask	139.2500	5.6500	["90","130","135","160","200"]	["0.5874","0.5202","0.5283","0.5473","0.5518"]	[]	["BATO","C2OX"]	90.0000	200.0000	35	448	false	true
01a0d4e4-5427-7563-96c6-3c31ae194716	ORCL	2026-09-24 15:28	other	2	1	30	64380.00	unknown	ask	139.2750	1.2500	["145","150"]	["0.5564","0.5881"]	[]	["XISX"]	145.0000	150.0000	176	484	false	false
01a0d4da-0f3f-79f1-b049-7155136c12a8	ORCL	2026-09-24 15:17	other	7	1	1530	11179900.00	unknown	bid	139.8900	2.3000	["155","157.5","160","162.5","165","175","180"]	["1.1441","1.3555","1.4968","1.6197","1.7659","0.8713","0.9595"]	[]	["XBOX"]	155.0000	180.0000	1	8	false	false
01a0d4cd-8c1e-7681-b4c7-c7a6e7d7a07d	ORCL	2026-09-24 15:03	other	3	7	74	26772.00	unknown	bid	139.3894	0.3300	["130","140","152.5"]	["0.4959","0.5620","0.5408"]	[]	["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]	130.0000	152.5000	1	8	false	false
01a0d4c2-7447-75c1-a0cf-425c220b00dc	ORCL	2026-09-24 14:51	other	3	2	40	31080.00	unknown	bid	139.7500	0.3900	["131","135"]	["0.4940","0.5063"]	["141.27"]	["XISX","XMIO"]	131.0000	135.0000	8	8	false	false
01a0d4be-9416-7331-bfe4-1c1cc534d71e	ORCL	2026-09-24 14:47	other	7	1	1238	6360548.00	unknown	ask	140.3100	4.9000	["152.5","155","160","162.5","165","185","310"]	["1.0911","0.9370","1.5576","1.6999","1.8377","1.0699","1.2109"]	[]	["XBOX"]	152.5000	310.0000	1	85	false	false
01a0d4bc-e666-7ea3-90ee-bcc9e1c4acd6	ORCL	2026-09-24 14:45	other	4	3	25	34574.00	unknown	bid	140.1500	0.8700	["150","155","170"]	["0.5910","0.5071","0.5664"]	[]	["XISX","XMIO"]	150.0000	170.0000	1	15	false	false
01a0d4bc-b787-7702-8bca-df54e8d08ba9	ORCL	2026-09-24 14:45	other	4	1	840	2548500.00	unknown	bid	140.0962	1.7000	["152.5","157.5","160","167.5"]	["1.0999","1.4097","1.5557","1.9663"]	["140.26"]	["XBOX"]	152.5000	167.5000	1	1	false	false
01a0d4ad-2b0f-7f73-b7c9-203c4f4041b7	ORCL	2026-09-24 14:28	other	3	1	100	26050.00	unknown	—	139.1850	0.1200	["140","145","146"]	["0.5728","0.4906","0.6398"]	[]	["XCBO"]	140.0000	146.0000	1	8	false	true	true	true
01a0d496-2c57-76d2-99a3-abed4590d318	ORCL	2026-09-24 14:03	other	4	1	5	85475.00	unknown	—	138.1700	3.2000	["160","175","180","195"]	["0.5782","0.6700","0.6005","0.8420"]	[]	["XPHO"]	160.0000	195.0000	22	113	false	false	true	true
01a0d47a-cc86-7230-aabc-947b6a3f9f9f	ORCL	2026-09-24 13:33	other	4	1	10	65330.00	unknown	—	138.5000	1.0500	["165","170"]	["0.5575","0.5651"]	[]	["XCBO"]	165.0000	170.0000	22	57	false	false	true	true	true
01a0d477-6187-7fe1-9f13-538642cbc68f	ORCL	2026-09-24 13:29	other	4	2	12	36228.00	unknown	ask	138.5750	0.4800	["100","140","150","250"]	["0.5723","0.5514","0.5154","0.5923"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-537ac5a55a30	ORCL	2026-09-24 13:29	other	4	6	24	72576.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5723","0.5520","0.5176","0.5931"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-536cdf1b40db	ORCL	2026-09-24 13:29	other	4	4	16	48328.00	unknown	—	138.5701	0.4800	["100","140","150","250"]	["0.5720","0.5517","0.5195","0.5918"]	[]	["AMXO","MCRY","XBOX","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-6187-7fe1-9f13-53518fda2694	ORCL	2026-09-24 13:29	other	4	2	18	54329.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5721","0.5515","0.5156","0.5921"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-534abcf0cdb0	ORCL	2026-09-24 13:29	other	4	6	30	90740.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5724","0.5520","0.5176","0.5935"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-5332538093da	ORCL	2026-09-24 13:29	other	4	4	20	60360.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5716","0.5515","0.5185","0.5916"]	[]	["AMXO","MCRY","XBOX","XPHO"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-5322ca27c9cb	ORCL	2026-09-24 13:29	other	4	2	15	45305.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5725","0.5515","0.5156","0.5926"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-5319f2fcf8a2	ORCL	2026-09-24 13:29	other	4	5	25	75638.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5723","0.5521","0.5180","0.5937"]	[]	["BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-6187-7fe1-9f13-53047c260248	ORCL	2026-09-24 13:29	other	4	5	25	75480.00	unknown	ask	138.5767	0.4800	["100","140","150","250"]	["0.5717","0.5517","0.5177","0.5916"]	[]	["AMXO","ARCO","MCRY","XBOX","XPHO"]	100.0000	250.0000	8	176	false	true
01a0d477-55ce-7022-a2a1-8b250fd4dbe4	ORCL	2026-09-24 13:29	other	4	3	11	33281.00	unknown	ask	138.5500	0.4800	["100","140","150","250"]	["0.5731","0.5520","0.5189","0.5935"]	[]	["ARCO","EDGO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-51e6-7363-83cd-a730898dee61	ORCL	2026-09-24 13:29	other	4	4	15	45335.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5725","0.5518","0.5205","0.5930"]	[]	["AMXO","MCRY","XPHO"]	100.0000	250.0000	8	176	false	true
01a0d477-51e6-7363-83cd-a72e9d046c9e	ORCL	2026-09-24 13:29	other	4	4	21	63462.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5728","0.5518","0.5165","0.5933"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-51e6-7363-83cd-a71966682d25	ORCL	2026-09-24 13:29	other	4	8	49	148176.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5728","0.5520","0.5194","0.5933"]	[]	["ARCO","BATO","C2OX","EDGO","XBOX","XCBO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-51e6-7363-83cd-a70ad1de0ebd	ORCL	2026-09-24 13:29	other	4	4	21	63364.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5719","0.5512","0.5198","0.5923"]	[]	["AMXO","MCRY","XPHO"]	100.0000	250.0000	8	176	false	true
01a0d477-4dff-7723-a1ed-c6263adbe840	ORCL	2026-09-24 13:29	other	4	2	12	36180.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5503","0.5149","0.5920"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-4dff-7723-a1ed-c6163a82b802	ORCL	2026-09-24 13:29	other	4	6	33	99867.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5729","0.5518","0.5171","0.5935"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true
01a0d477-4dfe-73a3-b068-7ef89fba3050	ORCL	2026-09-24 13:29	other	4	2	12	36252.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5511","0.5159","0.5933"]	[]	["MCRY","XPHO"]	100.0000	250.0000	8	176	false	true
01a0d477-4dfe-73a3-b068-7eede95a7740	ORCL	2026-09-24 13:29	other	4	2	17	51268.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5505","0.5149","0.5920"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true
01a0d477-4dfe-73a3-b068-7ed86d438f1d	ORCL	2026-09-24 13:29	other	4	5	20	60536.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5729","0.5519","0.5165","0.5937"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO"]	100.0000	250.0000	8	176	false	true