Multi-leg option trades

core.multileg_trades

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

541,738 rowsCSV — whole table, not this view

Sources in this table

uw_multileg541,738 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:source = uw_multileg×strategy = risk_reversal×ticker = SPY×

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

01a0e97a-071f-7ec3-9269-593f99f49580	SPY	2026-09-28 15:24	risk_reversal	2	1	6	34194.00	short	ask	765.9400	0.4000	["695","1020"]	["0.2247","0.1403"]	["675.65"]	["XCBO"]	695.0000	1020.0000	809	809	false	true	false	true	true	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-28T19:24:46Z"}	2026-09-28	2026-09-28 17:15	2026-09-28 17:15
01a0e94d-de6f-7633-8c44-46644be3c8d3	SPY	2026-09-28 14:36	risk_reversal	2	1	17	100538.00	short	ask	766.7300	0.2050	["730","840"]	["0.2015","0.1405"]	["729.32"]	["XISX"]	730.0000	840.0000	367	367	false	true	false
01a0e946-d1be-7d93-88a9-bea617ae96f9	SPY	2026-09-28 14:28	risk_reversal	2	3	4	35224.00	short	ask	766.9800	0.1500	["805","830"]	["0.1778","0.1469"]	["782.10"]	["ARCO","XISX"]	805.0000	830.0000	354	354	false	false	false
01a0e943-571f-71c2-884e-c5f66a2ddf04	SPY	2026-09-28 14:24	risk_reversal	2	2	3	26418.00	short	ask	766.8200	0.0500	["805","830"]	["0.1778","0.1469"]	["781.94"]	["XISX"]	805.0000	830.0000	354	354	false	false	false
01a0e943-4b67-75d3-96ba-68e8a375834f	SPY	2026-09-28 14:24	risk_reversal	2	2	3	26418.00	short	ask	766.8300	0.0667	["805","830"]	["0.1778","0.1469"]	["781.96"]	["ARCO","XPHO"]	805.0000	830.0000	354	354	false	false	false
01a0e943-10cf-7d21-9ade-d103780286b0	SPY	2026-09-28 14:24	risk_reversal	2	1	3	26418.00	short	ask	766.7900	0.0800	["805","830"]	["0.1778","0.1469"]	["781.92"]	["XISX"]	805.0000	830.0000	354	354	false	false	false
01a0e8a3-1f7f-7a92-83b9-be6e79678a4c	SPY	2026-09-28 11:29	risk_reversal	2	1	1000	5823000.00	long	bid	764.9300	0.3100	["727","840"]	["0.2023","0.1408"]	["725.95"]	["AMXO"]	727.0000	840.0000	367	367	true	true	false
01a0e88d-edb7-7002-a016-c8cb94c8e77f	SPY	2026-09-28 11:06	risk_reversal	2	1	3	36759.00	long	ask	764.8900	0.0800	["685","695"]	["0.2131","0.1950"]	["786.13"]	["XBOX"]	685.0000	695.0000	262	262	false	false	false
01a0e88d-edb7-7002-a016-c8a75cb21b57	SPY	2026-09-28 11:06	risk_reversal	2	1	3	36759.00	short	bid	764.8900	0.0300	["685","695"]	["0.2132","0.1950"]	["786.11"]	["XISX"]	685.0000	695.0000	262	262	false	false	false
01a0e88d-de17-7243-874a-55ef211786fc	SPY	2026-09-28 11:06	risk_reversal	2	1	21	257313.00	long	ask	764.8400	0.2500	["685","695"]	["0.2131","0.1952"]	["786.11"]	["XBOX"]	685.0000	695.0000	262	262	false	false	false
01a0e88d-da2f-7160-8257-6252800d18f7	SPY	2026-09-28 11:06	risk_reversal	2	2	11	134783.00	long	ask	764.8050	1.9500	["685","695"]	["0.2131","0.1952"]	["786.09"]	["XISX"]	685.0000	695.0000	262	262	false	false	false
01a0e88c-8657-7650-a2e3-6b51b82e98be	SPY	2026-09-28 11:05	risk_reversal	2	1	11	134783.00	long	ask	764.7500	1.9000	["685","695"]	["0.2133","0.1955"]	["786.03"]	["XISX"]	685.0000	695.0000	262	262	false	false	false
01a0e87b-f80f-70f0-9200-2b8e6fa2495a	SPY	2026-09-28 10:47	risk_reversal	2	2	31	27993.00	short	ask	764.3600	0.0210	["765","766"]	["0.1465","0.1510"]	["764.37"]	["ARCO","XPHO"]	765.0000	766.0000	4	4	false	false	false
01a0e84f-8cf7-7663-98d2-738e527a86ad	SPY	2026-09-28 09:58	risk_reversal	2	1	650	4199000.00	short	bid	768.1350	0.2700	["730","825"]	["0.1990","0.1488"]	["831.40"]	["ARCO"]	730.0000	825.0000	354	354	false	true	false
01a0e840-278f-71a1-b012-97484ba7c303	SPY	2026-09-28 09:41	risk_reversal	2	1	100	143000.00	long	bid	767.1450	0.0800	["715","825"]	["0.1911","0.1195"]	["710.76"]	["EDGO"]	715.0000	825.0000	109	109	false	true	false
01a0da1e-e407-7f71-9590-bfdab2e6e088	SPY	2026-09-25 15:50	risk_reversal	2	2	144	208656.00	short	ask	772.1300	0.1200	["715","825"]	["0.1899","0.1176"]	["712.65"]	["C2OX"]	715.0000	825.0000	112	112	false	true	false
01a0da1e-6ed7-7cf0-a2d4-e6b1667eba9e	SPY	2026-09-25 15:50	risk_reversal	2	1	123	178227.00	short	ask	772.1410	0.1100	["715","825"]	["0.1899","0.1176"]	["712.65"]	["C2OX"]	715.0000	825.0000	112	112	false	true	false
01a0da1e-6aef-74a1-9315-7dc1b79ebc45	SPY	2026-09-25 15:50	risk_reversal	2	1	378	547910.00	short	ask	772.1510	0.1300	["715","825"]	["0.1899","0.1176"]	["712.65"]	["EDGO"]	715.0000	825.0000	112	112	false	true	false
01a0da1d-f9a7-72a0-aed4-b664a51bc149	SPY	2026-09-25 15:49	risk_reversal	2	6	125	87125.00	short	ask	771.6950	0.0400	["771","774"]	["0.1092","0.1031"]	["770.51"]	["ARCO","C2OX","EMLD","XCBO","XMIO","XPHO"]	771.0000	774.0000	6	6	false	true	false
01a0da16-50b7-7701-89e3-10d29085f3f9	SPY	2026-09-25 15:41	risk_reversal	2	1	48	43200.00	long	bid	770.9100	0.0400	["770","773"]	["0.1049","0.1000"]	["770","773"]	["XPHO"]	770.0000	773.0000	10	10	false	true	false
01a0da15-8d67-7941-a511-c5ef3f6534df	SPY	2026-09-25 15:40	risk_reversal	2	1	500	158000.00	long	bid	770.7700	0.0200	["772","776"]	["0.0781","0.0736"]	["769.76"]	["XCBO"]	772.0000	776.0000	3	3	false	false	false
01a0d9ec-1c07-76e1-83c6-1f682b7f5f3d	SPY	2026-09-25 14:55	risk_reversal	3	1	4	52144.00	short	bid	770.7100	3.4400	["575","700"]	["0.2767","0.1982"]	["796.00"]	["BATO"]	575.0000	700.0000	265	265	false	false	false
01a0d9dd-2fb7-7580-adb1-902268340075	SPY	2026-09-25 14:39	risk_reversal	2	1	20	91520.00	short	ask	770.7200	0.1300	["750","900"]	["0.1921","0.1338"]	["728.40"]	["XMIO"]	750.0000	900.0000	357	357	false	true	false
01a0d9cf-879e-72a0-89f7-0d8e4fb8d75a	SPY	2026-09-25 14:24	risk_reversal	2	1	9	83052.00	short	ask	771.2850	0.0600	["790","810"]	["0.1808","0.1545"]	["788.16"]	["XBOX"]	790.0000	810.0000	357	357	false	false	false
01a0d9cf-414f-7083-a3da-32072fe1dd9a	SPY	2026-09-25 14:23	risk_reversal	2	1	5	44575.00	long	bid	771.2600	0.0400	["795","820"]	["0.1800","0.1510"]	["785.73"]	["XBOX"]	795.0000	820.0000	357	357	false	false	false
01a0d946-d76f-7f90-ac05-2eb32ff50d8a	SPY	2026-09-25 11:54	risk_reversal	3	2	10	82470.00	short	bid	768.6000	0.5000	["680","750","920"]	["0.2247","0.2041","0.1352"]	["920.63"]	["XMIO"]	680.0000	920.0000	483	483	false	true	false
01a0d923-902e-7ee0-9af5-d3226f1a1a23	SPY	2026-09-25 11:16	risk_reversal	2	7	296	723128.00	short	ask	768.8400	0.1400	["766","784"]	["0.1433","0.1277"]	["763.37"]	["AMXO","ARCO","C2OX","EMLD","MCRY","SPHR","XBOX"]	766.0000	784.0000	56	56	false	true	false
01a0d8f5-5ff7-7643-b6c6-2af62e54d629	SPY	2026-09-25 10:25	risk_reversal	2	1	1000	1141998.00	short	ask	767.7400	0.1300	["710","815"]	["0.1987","0.1186"]	["707.94"]	["XMIO"]	710.0000	815.0000	84	84	false	true	false
01a0d4ea-0148-7530-b2a0-ce84777f9a50	SPY	2026-09-24 15:34	risk_reversal	2	1	200	1608200.00	short	bid	767.7400	0.2800	["725","825"]	["0.2090","0.1528"]	["839.71"]	["AMXO"]	725.0000	825.0000	449	449	false	true	false
01a0d495-ab6e-7fe2-91c6-f65210c1f9f1	SPY	2026-09-24 14:02	risk_reversal	2	1	7	62965.00	short	ask	766.0200	0.0500	["810","835"]	["0.1792","0.1470"]	["781.63"]	["ARCO"]	810.0000	835.0000	358	358	false	false	false
01a0d495-651f-79b3-bcb8-0afa2da47e91	SPY	2026-09-24 14:02	risk_reversal	2	1	16	143920.00	short	ask	766.0800	0.0800	["810","835"]	["0.1792","0.1471"]	["781.73"]	["XBOX"]	810.0000	835.0000	358	358	false	false	false
01a0d474-5c17-7b52-87df-e0f35276b68f	SPY	2026-09-24 13:26	risk_reversal	2	1	8	71936.00	short	ask	766.8400	0.0800	["810","835"]	["0.1791","0.1472"]	["782.48"]	["XBOX"]	810.0000	835.0000	358	358	false	false	false
01a0d46f-c837-7f40-9967-2158a93fe1a9	SPY	2026-09-24 13:21	risk_reversal	2	1	17	70788.00	long	bid	767.6100	0.2200	["770","785"]	["0.1525","0.1335"]	["767.38"]	["XPHO"]	770.0000	785.0000	113	113	false	false	false
01a0d409-c307-7213-9979-066396fe8e04	SPY	2026-09-24 11:30	risk_reversal	2	2	253	294745.00	short	ask	763.6650	0.0200	["710","815"]	["0.1972","0.1211"]	["706.81"]	["EDGO","XCBO"]	710.0000	815.0000	85	85	false	true	false
01a0d409-c307-7213-9979-0650c926e755	SPY	2026-09-24 11:30	risk_reversal	2	1	39	45435.00	short	ask	763.6650	0.0256	["710","815"]	["0.1972","0.1211"]	["706.81"]	["XPHO"]	710.0000	815.0000	85	85	false	true	false
01a0d409-c307-7213-9979-064c3b596e1f	SPY	2026-09-24 11:30	risk_reversal	2	1	36	41940.00	short	ask	763.6650	0.0400	["710","815"]	["0.1972","0.1211"]	["706.81"]	["XBOX"]	710.0000	815.0000	85	85	false	true	false
01a0d409-3a4f-7481-8a86-44ab5cbd52b8	SPY	2026-09-24 11:29	risk_reversal	2	1	157	182748.00	short	ask	763.6000	0.0200	["710","815"]	["0.1971","0.1211"]	["706.80"]	["EDGO"]	710.0000	815.0000	85	85	false	true	false
01a0d409-3a4f-7481-8a86-44877b010d04	SPY	2026-09-24 11:29	risk_reversal	2	2	30	34920.00	short	ask	763.6000	0.0300	["710","815"]	["0.1971","0.1211"]	["706.80"]	["XBOX","XPHO"]	710.0000	815.0000	85	85	false	true	false
01a0d3aa-610f-7270-a42f-8c9172d76f7c	SPY	2026-09-24 09:45	risk_reversal	3	1	18	29682.00	short	bid	764.8450	0.1000	["650","700","830"]	["0.2439","0.2017","0.1188"]	["830.35"]	["XISX"]	650.0000	830.0000	113	113	false	true	false
01a0d3a6-e286-7d50-b3b2-f6fdcdee35c9	SPY	2026-09-24 09:42	risk_reversal	2	4	7	33285.00	short	bid	764.5699	0.2200	["755","765"]	["0.1600","0.1437"]	["776.25"]	["ARCO","EMLD","SPHR"]	755.0000	765.0000	113	113	false	true	false
01a0cfca-581f-7010-95ed-8b1b9baa586a	SPY	2026-09-23 15:42	risk_reversal	2	1	8	39976.00	short	bid	767.6850	0.0200	["760","765"]	["0.1565","0.1444"]	["777.89"]	["XBOX"]	760.0000	765.0000	114	114	false	false	false
01a0cfbb-0256-78f3-a945-6dc1f97152a2	SPY	2026-09-23 15:25	risk_reversal	2	1	11	54868.00	short	ask	767.8000	0.2500	["810","825"]	["0.1470","0.1188"]	["771.02"]	["XBOX"]	810.0000	825.0000	114	114	false	false	false
01a0cfbb-0256-78f3-a945-6db7d76adfd1	SPY	2026-09-23 15:25	risk_reversal	2	1	8	39904.00	short	ask	767.8000	0.2500	["810","825"]	["0.1474","0.1183"]	["770.90"]	["AMXO"]	810.0000	825.0000	114	114	false	false	false
01a0cf77-7947-7782-a5c1-742e8629ecaa	SPY	2026-09-23 14:11	risk_reversal	2	1	15	27915.00	long	ask	768.3999	0.0500	["759","769"]	["0.1339","0.1247"]	["774.23"]	["XCBO"]	759.0000	769.0000	30	30	false	true	false
01a0cf2b-2e07-7b72-ac7e-eddbdc262c91	SPY	2026-09-23 12:48	risk_reversal	3	1	40	84400.00	short	bid	767.8300	0.0900	["720","750","802"]	["0.1801","0.1518","0.1160"]	["802.80"]	["C2OX"]	720.0000	802.0000	68	68	false	true	false
01a0cf2b-2e07-7b72-ac7e-edc8b38d3fb1	SPY	2026-09-23 12:48	risk_reversal	3	1	40	84400.00	short	bid	767.8300	0.0900	["720","750","802"]	["0.1801","0.1518","0.1160"]	["802.80"]	["C2OX"]	720.0000	802.0000	68	68	false	true	false
01a0cf2b-2e07-7b72-ac7e-edb280b3ccc9	SPY	2026-09-23 12:48	risk_reversal	3	1	40	84400.00	short	bid	767.8300	0.0900	["720","750","802"]	["0.1801","0.1518","0.1160"]	["802.80"]	["C2OX"]	720.0000	802.0000	68	68	false	true	false
01a0cf2b-2e07-7b72-ac7e-ed9a2e282a2d	SPY	2026-09-23 12:48	risk_reversal	3	1	40	84400.00	short	bid	767.8300	0.0900	["720","750","802"]	["0.1801","0.1518","0.1160"]	["802.80"]	["C2OX"]	720.0000	802.0000	68	68	false	true	false
01a0cf2b-2e07-7b72-ac7e-ed8d906e52c9	SPY	2026-09-23 12:48	risk_reversal	3	2	40	84400.00	short	bid	767.8200	0.1000	["720","750","802"]	["0.1801","0.1518","0.1160"]	["802.80"]	["XISX"]	720.0000	802.0000	68	68	false	true	false
01a0cef3-707e-7212-a5ad-200e75d8148f	SPY	2026-09-23 11:47	risk_reversal	2	1	10	90100.00	short	ask	768.9200	0.0800	["815","840"]	["0.1772","0.1463"]	["784.94"]	["XBOX"]	815.0000	840.0000	359	359	false	false	false