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×strategy = risk_reversal×ticker = ORCL×

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

01a0f8fa-fdcf-7ba3-8d21-080c3a9e0c53	ORCL	2026-10-01 15:39	risk_reversal	2	5	24	42240.00	long	bid	138.3500	0.3208	["130","160"]	["0.5813","0.5745"]	["127.56"]	["AMXO","EMLD","MCRY","XPHO"]	130.0000	160.0000	78	78	false	true	false	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-10-01T19:40:13Z"}	2026-10-01	2026-10-01 17:15	2026-10-01 17:15
01a0f8ef-e5f6-74e1-8aaf-f4ceb405b8f2	ORCL	2026-10-01 15:27	risk_reversal	2	1	5	25380.00	long	bid	138.1700	2.1000	["140","210"]	["0.5907","0.5564"]	["126.14"]	["XCBO"]	140.0000	210.0000	477	477	false	false
01a0f8cb-2b9f-7dc2-b11d-08b6121ff197	ORCL	2026-10-01 14:47	risk_reversal	2	1	35	70560.00	long	bid	137.9000	0.6500	["125","200"]	["0.5751","0.5870"]	["118.34"]	["AMXO"]	125.0000	200.0000	169	169	false	true
01a0f8ad-a506-7f60-aee8-e30cd3d4c217	ORCL	2026-10-01 14:15	risk_reversal	2	2	19	26752.00	long	bid	138.9700	0.7500	["130","180"]	["0.5848","0.5912"]	["124.30"]	["EDGO"]	130.0000	180.0000	78	78	false	true
01a0f8ad-a506-7f60-aee8-e2ec25b60a27	ORCL	2026-10-01 14:15	risk_reversal	2	7	81	114214.00	long	bid	138.8000	0.8500	["130","180"]	["0.5828","0.5937"]	["124.3"]	["ARCO","BATO","C2OX","EMLD","SPHR"]	130.0000	180.0000	78	78	false	true
01a0f8a0-5aaf-7473-9abe-36d49082e8b2	ORCL	2026-10-01 14:00	risk_reversal	2	2	5	29850.00	short	ask	138.3100	1.0400	["155","180"]	["0.5974","0.5633"]	["136.99"]	["ARCO","XISX"]	155.0000	180.0000	379	379	false	false
01a0f8a0-56c7-7901-8660-80e5cfdc4293	ORCL	2026-10-01 14:00	risk_reversal	2	2	8	47760.00	short	ask	138.3100	1.4813	["155","180"]	["0.6052","0.5556"]	["136.14"]	["AMXO","XBOX"]	155.0000	180.0000	379	379	false	false
01a0eda4-82a6-7573-8846-15293284513c	ORCL	2026-09-29 10:49	risk_reversal	3	7	54	40437.00	short	ask	142.4061	0.2500	["125","140","170"]	["0.5414","0.5556","0.6316"]	["136.50"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	125.0000	170.0000	17	17	false
01a0eda4-82a6-7573-8846-151f84d1fe9f	ORCL	2026-09-29 10:49	risk_reversal	3	4	36	26964.00	short	ask	142.4061	0.2500	["125","140","170"]	["0.5407","0.5557","0.6324"]	["136.50"]	["AMXO","MCRY","XBOX","XPHO"]	125.0000	170.0000	17	17	false
01a0eda4-82a6-7573-8846-14f12a818597	ORCL	2026-09-29 10:49	risk_reversal	3	7	36	26989.00	short	ask	142.4061	0.2500	["125","140","170"]	["0.5411","0.5560","0.6325"]	["136.50"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	125.0000	170.0000	17	17	false
01a0eda4-7307-7fa0-bfe4-9d36bd2824c4	ORCL	2026-09-29 10:49	risk_reversal	3	8	65	48505.00	short	ask	142.5399	0.3000	["125","140","170"]	["0.5443","0.5571","0.6306"]	["136.55"]	["AMXO","ARCO","EMLD","MCRY","XCBO","XISX","XMIO","XPHO"]	125.0000	170.0000	17	17	false
01a0eda4-57af-7993-821c-0c2159963d53	ORCL	2026-09-29 10:49	risk_reversal	3	8	40	29920.00	short	ask	142.4650	0.3000	["125","140","170"]	["0.5443","0.5544","0.6338"]	["136.57"]	["ARCO","BATO","C2OX","EDGO","MCRY","XCBO","XISX","XPHO"]	125.0000	170.0000	17	17	false
01a0ed9b-5316-7c53-af06-2d696339e956	ORCL	2026-09-29 10:39	risk_reversal	3	6	36	26490.00	short	ask	143.5050	0.2000	["125","140","170"]	["0.5536","0.5708","0.6400"]	["136.89"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	125.0000	170.0000	17	17	false
01a0ed9b-5316-7c53-af06-2d3b4a973834	ORCL	2026-09-29 10:39	risk_reversal	3	6	42	30919.00	short	ask	143.5050	0.2200	["125","140","170"]	["0.5545","0.5708","0.6397"]	["136.90"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	125.0000	170.0000	17	17	false
01a0ed9b-5316-7c53-af06-2d0f2f259b06	ORCL	2026-09-29 10:39	risk_reversal	3	5	35	25632.00	short	ask	143.5330	0.3000	["125","140","170"]	["0.5548","0.5701","0.6364"]	["136.90"]	["ARCO","BATO","C2OX","EDGO","XCBO"]	125.0000	170.0000	17	17	false
01a0ed9b-5316-7c53-af06-2ce2578c0e73	ORCL	2026-09-29 10:39	risk_reversal	3	5	35	25487.00	short	ask	143.5050	0.2900	["125","140","170"]	["0.5508","0.5685","0.6348"]	["136.87"]	["AMXO","MCRY","XBOX","XISX","XPHO"]	125.0000	170.0000	17	17	false
01a0ed8d-a716-7f73-9e8f-b61c65bb1be7	ORCL	2026-09-29 10:24	risk_reversal	2	3	7	39172.00	long	bid	141.1300	1.2071	["150","175"]	["0.5914","0.5659"]	["138.46"]	["XCBO"]	150.0000	175.0000	353	353	false	false
01a0ed8c-8607-7261-9337-719bd918f595	ORCL	2026-09-29 10:23	risk_reversal	2	1	9	50184.00	short	ask	139.6600	1.5000	["150","175"]	["0.5942","0.5617"]	["136.78"]	["XMIO"]	150.0000	175.0000	353	353	false	false
01a0ed8c-5b0f-7e21-98d7-40060c919da8	ORCL	2026-09-29 10:23	risk_reversal	2	1	250	134000.00	short	ask	139.4820	0.2500	["138","142"]	["0.7020","0.7180"]	["137.74"]	["XBOX"]	138.0000	142.0000	3	3	false	true
01a0ed8c-2c2e-79d0-8b68-e3b366de9bef	ORCL	2026-09-29 10:22	risk_reversal	2	1	9	49995.00	short	ask	139.3910	4.1000	["150","175"]	["0.6012","0.5515"]	["135.61"]	["XMIO"]	150.0000	175.0000	353	353	false	false
01a0e8bb-b85f-7a20-97c2-9c50db7fb176	ORCL	2026-09-28 11:56	risk_reversal	2	3	33	59235.00	long	bid	132.4100	0.2667	["100","340"]	["0.5723","0.5873"]	["92.27"]	["AMXO","XPHO"]	100.0000	340.0000	445	445	false	true
01a0e8bb-81ae-74a1-bbc2-f200406440db	ORCL	2026-09-28 11:56	risk_reversal	2	2	26	46722.00	long	bid	132.3750	0.1000	["100","340"]	["0.5747","0.5849"]	["92.08"]	["AMXO","XISX"]	100.0000	340.0000	445	445	false	true
01a0d8f5-11d7-7810-a518-808a9a22679b	ORCL	2026-09-25 10:25	risk_reversal	2	1	6	34122.00	short	ask	138.6400	1.1000	["155","180"]	["0.5846","0.5522"]	["136.49"]	["XMIO"]	155.0000	180.0000	357	357	false	false
01a0d8c3-6317-74b3-a252-31aec70faa0f	ORCL	2026-09-25 09:31	risk_reversal	2	4	82	162724.00	long	bid	139.1650	2.7000	["125","175"]	["0.5518","0.5416"]	["122.5"]	["C2OX","EDGO","EMLD","SPHR"]	125.0000	175.0000	147	147	false	true
01a0d8c3-6317-74b3-a252-31977a5a7c19	ORCL	2026-09-25 09:31	risk_reversal	2	1	14	27860.00	long	bid	139.0500	2.7000	["125","175"]	["0.5515","0.5437"]	["122.50"]	["ARCO"]	125.0000	175.0000	147	147	false	true
01a0d465-3917-72b2-a388-9add3abc3168	ORCL	2026-09-24 13:09	risk_reversal	2	1	250	618000.00	long	ask	138.9500	0.4500	["130","150"]	["0.5567","0.5431"]	["151.42"]	["XMIO"]	130.0000	150.0000	113	113	false	true
01a0d3fe-f17f-78b0-ac01-a3703ebe5141	ORCL	2026-09-24 11:18	risk_reversal	2	1	800	1944000.00	short	ask	137.3700	0.9500	["130","190"]	["0.5732","0.5731"]	["121.84"]	["XPHO"]	130.0000	190.0000	176	176	false	true
01a0cf3d-23ae-7080-9e09-93a0500d4fe3	ORCL	2026-09-23 13:08	risk_reversal	2	1	300	42900.00	long	ask	146.3200	0.1100	["120","175"]	["0.5168","0.5399"]	["175.53"]	["XPHO"]	120.0000	175.0000	23	23	false	true
01a0cea3-ba3f-7022-9661-2ece5e73bdbe	ORCL	2026-09-23 10:20	risk_reversal	2	2	8	32848.00	long	bid	145.7266	0.9500	["135","200"]	["0.5662","0.5600"]	["130.40"]	["EDGO"]	135.0000	200.0000	359	359	false	true
01a0ca54-845e-7c83-9fba-84d24e800376	ORCL	2026-09-22 14:15	risk_reversal	2	1	18	26262.00	long	ask	149.7900	0.4000	["130","180"]	["0.5715","0.5754"]	["180.35"]	["C2OX"]	130.0000	180.0000	87	87	false	true
01a0c9b4-6bfe-7390-9d5b-cc2566d3b62e	ORCL	2026-09-22 11:20	risk_reversal	2	2	11	46506.00	long	bid	149.2850	0.4000	["150","160"]	["0.5686","0.5588"]	["148"]	["ARCO","XBOX"]	150.0000	160.0000	178	178	false	false
01a0c43a-13fe-7eb1-b92e-3b7d366423dd	ORCL	2026-09-21 09:48	risk_reversal	2	3	5	34864.00	short	bid	147.9050	1.2600	["140","145"]	["0.5739","0.5429"]	["157.60"]	["ARCO","EMLD","SPHR"]	140.0000	145.0000	487	487	false	false
01a0b614-2bdf-7b63-bbf5-222edb8f6470	ORCL	2026-09-18 15:52	risk_reversal	3	3	65	35134.00	short	ask	147.7200	0.1300	["140","148","160"]	["0.4559","0.4579","0.4851"]	["145.76"]	["EDGO","XCBO","XPHO"]	140.0000	160.0000	7	7	false
01a0b524-ca9f-7642-b68c-f8f0e92147f9	ORCL	2026-09-18 11:31	risk_reversal	2	2	10	26050.00	long	bid	145.5600	0.4000	["145","160"]	["0.5576","0.5532"]	["141.09"]	["ARCO","XBOX"]	145.0000	160.0000	91	91	false	true
01a0b4ce-944f-7700-aaec-aeacc16df43f	ORCL	2026-09-18 09:57	risk_reversal	2	1	5	25790.00	long	bid	146.0650	1.7000	["140","210"]	["0.5755","0.5557"]	["132.80"]	["XCBO"]	140.0000	210.0000	490	490	false	true
01a0af95-be1b-7131-bba7-ebded9ade8f9	ORCL	2026-09-17 09:36	risk_reversal	2	1	25	33425.00	long	bid	148.6201	0.6500	["130","190"]	["0.5690","0.5769"]	["127.97"]	["EMLD"]	130.0000	190.0000	92	92	false	true
01a0a6a7-9f2e-71e1-b631-d7b36b688fdf	ORCL	2026-09-15 15:59	risk_reversal	2	1	4	26348.00	short	bid	140.3000	1.7000	["140","150"]	["0.5763","0.5422"]	["153.09"]	["XCBO"]	140.0000	150.0000	493	493	false	true
01a0a6a7-9b46-7e33-ad52-7fbde5697c1d	ORCL	2026-09-15 15:59	risk_reversal	2	4	6	39408.00	short	bid	140.2900	1.9083	["140","150"]	["0.5771","0.5384"]	["152.80"]	["ARCO","EMLD","SPHR","XBOX"]	140.0000	150.0000	493	493	false	true
01a0a680-be0e-7a00-88c9-8e760205a793	ORCL	2026-09-15 15:17	risk_reversal	2	1	4	27228.00	short	bid	141.0400	0.8000	["140","145"]	["0.5780","0.5432"]	["150.57"]	["XCBO"]	140.0000	145.0000	493	493	false	true
01a0a680-be0e-7a00-88c9-8e63874051a4	ORCL	2026-09-15 15:17	risk_reversal	2	4	6	40850.00	short	bid	141.0400	0.8500	["140","145"]	["0.5787","0.5427"]	["150.50"]	["ARCO","EMLD","SPHR","XBOX"]	140.0000	145.0000	493	493	false	true
01a0a0d6-90c1-7ab1-bc45-03f4575ad361	ORCL	2026-09-14 12:53	risk_reversal	2	3	19	36195.00	short	ask	144.0800	0.1132	["140","155"]	["0.5229","0.5171"]	["138.60"]	["XBOX","XCBO","XISX"]	140.0000	155.0000	67	67	false	true
01a0a06c-d658-70f1-8447-bfb2f2fa3cc4	ORCL	2026-09-14 10:58	risk_reversal	2	2	29	54810.00	short	ask	143.9800	0.1000	["145","165"]	["0.5282","0.5202"]	["138.02"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false
01a0a06c-caa0-7ba2-8749-5f948d11f296	ORCL	2026-09-14 10:57	risk_reversal	2	2	24	45360.00	long	bid	143.9450	0.1000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false
01a0a06c-c6b9-7422-9115-23771f298043	ORCL	2026-09-14 10:57	risk_reversal	2	2	24	45360.00	long	bid	143.9450	0.1000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false
01a0a06c-c6b9-7422-9115-236e615d00db	ORCL	2026-09-14 10:57	risk_reversal	2	2	29	54810.00	long	bid	143.9450	0.2207	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false
01a0a06c-c6b9-7422-9115-235f8754e7f9	ORCL	2026-09-14 10:57	risk_reversal	2	2	29	54810.00	long	bid	143.9450	0.2000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false
01a0a031-9279-7d80-9ad5-65b47ae995ae	ORCL	2026-09-14 09:53	risk_reversal	3	5	42	25660.00	short	ask	144.5600	0.3100	["137","145","155"]	["0.6295","0.6425","0.6875"]	["142.96"]	["BATO","C2OX","EDGO","XCBO","XISX"]	137.0000	155.0000	4	4	false
01a0a031-9279-7d80-9ad5-659ecd3e1b9b	ORCL	2026-09-14 09:53	risk_reversal	3	5	55	33390.00	short	ask	144.5600	0.2900	["137","145","155"]	["0.6244","0.6393","0.6881"]	["142.96"]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	137.0000	155.0000	4	4	false
01a0a031-8aa8-7dc2-81f2-17cd56532878	ORCL	2026-09-14 09:53	risk_reversal	3	3	168	101116.00	short	ask	144.7234	0.2900	["137","145","155"]	["0.6314","0.6451","0.6798"]	["143.0"]	["XCBO","XMIO","XPHO"]	137.0000	155.0000	4	4	false
01a0a031-8aa8-7dc2-81f2-17a89e00de15	ORCL	2026-09-14 09:53	risk_reversal	3	6	60	36298.00	short	ask	144.7234	0.2900	["137","145","155"]	["0.6345","0.6469","0.6817"]	["143.01"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	137.0000	155.0000	4	4	false