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:net_side = ask×strategy = other×ticker = SPY×

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

01a0da2d-cc6f-7aa0-bba7-2485312cce5c	SPY	2026-09-25 16:07	other	3	1	143	80652.00	unknown	ask	771.4300	0.0300	["766","771","776"]	["0.1102","0.1045","0.0740"]	[]	["XISX"]	766.0000	776.0000	3	5	false	true	true	true	true	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T20:09:07Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0da2b-3847-7bf2-a163-f591b0315f82	SPY	2026-09-25 16:04	other	4	2	20	26108.00	unknown	ask	771.4500	0.0500	["765","766","777","784"]	["1.3966","1.0943","0.1091","0.1076"]	[]	["XMIO"]	765.0000	784.0000	0	7	false	false	true	true
01a0da25-a297-7e01-844c-cc9a3b756c8e	SPY	2026-09-25 15:58	other	3	1	3	66996.00	unknown	ask	771.5950	7.2900	["600","810","830"]	["49.1108","0.1742","0.2155"]	[]	["C2OX"]	600.0000	830.0000	0	21	false	false	true	true
01a0da24-d777-76d1-b702-14774a38cb6e	SPY	2026-09-25 15:57	other	3	1	132	72600.00	unknown	ask	771.5650	0.0400	["766","771","776"]	["0.1095","0.1037","0.0731"]	[]	["EDGO"]	766.0000	776.0000	3	5	false	true	true	true
01a0da21-aaf7-7960-be71-a844b7ace4bd	SPY	2026-09-25 15:53	other	4	1	7	25053.00	unknown	ask	771.9800	1.0500	["758","771","800","810"]	["0.1329","0.1268","0.1039","0.1098"]	[]	["XPHO"]	758.0000	810.0000	21	35	false	false	true	true
01a0da20-3faf-7890-8922-d0bb11f462b2	SPY	2026-09-25 15:52	other	4	1	3	30034.00	unknown	ask	772.0050	0.6400	["750","760","770","780"]	["0.1155","0.1100","0.1507","0.1455"]	[]	["XMIO"]	750.0000	780.0000	5	175	false	false	true	true
01a0da1d-d67f-76a2-9ceb-c67ead3338c3	SPY	2026-09-25 15:49	other	4	1	35	57764.00	unknown	ask	771.6850	0.1800	["720","722","758","772"]	["0.1913","0.1833","0.1345","0.1367"]	[]	["XISX"]	720.0000	772.0000	21	56	false	false	true	true
01a0da1d-b357-7ea2-afa3-fa278a2a0cb5	SPY	2026-09-25 15:49	other	4	1	60	303000.00	unknown	ask	771.7400	0.4500	["766","771"]	["0.1251","0.1194"]	[]	["XCBO"]	766.0000	771.0000	21	28	false	false	true	true
01a0da1d-5597-7381-8058-24e17682d700	SPY	2026-09-25 15:49	other	8	3	962	134225.00	unknown	ask	771.7101	0.1700	["760","769","770","772","776","786"]	["0.7304","0.2714","0.3583","0.3140","0.5578","0.1230"]	[]	["C2OX","XMIO"]	760.0000	786.0000	0	4	false	false	true	true
01a0da1b-ea4f-7812-8787-68c904d3c683	SPY	2026-09-25 15:47	other	4	1	20	101420.00	unknown	ask	771.8000	0.3600	["766","771"]	["0.1254","0.1195"]	[]	["XISX"]	766.0000	771.0000	21	28	false	false	true	true
01a0da1a-2147-7582-9415-26297cf1b98c	SPY	2026-09-25 15:45	other	4	2	300	71736.00	unknown	ask	771.5800	0.0400	["770","771","775","780"]	["0.2925","0.2518","0.4455","0.8698"]	["770.87"]	["XCBO","XMIO"]	770.0000	780.0000	0	0	false	false	false	true
01a0da18-d53f-7083-8f53-d5f7c30a4079	SPY	2026-09-25 15:44	other	4	1	56	25088.00	unknown	ask	771.2750	0.0400	["761","770"]	["0.5489","0.1663"]	[]	["XCBO"]	761.0000	770.0000	0	3	false	false	true	true
01a0d9fc-fc57-7fa3-a1ae-d3867705f00d	SPY	2026-09-25 15:13	other	4	1	20	44560.00	unknown	ask	770.9500	0.0500	["762","765","767","770"]	["0.5556","0.0817","0.2754","0.0755"]	[]	["XISX"]	762.0000	770.0000	0	3	false	false	true	true
01a0d9f5-8a17-7321-9e4e-492e59d74b8e	SPY	2026-09-25 15:05	other	5	1	10	38430.00	unknown	ask	770.6401	0.1500	["767","775","785","795","800"]	["0.1180","0.1331","0.1092","0.1210","0.1190"]	[]	["MCRY"]	767.0000	800.0000	14	56	false	true	true	true
01a0d9d4-07f7-7543-a323-f46c36a954a8	SPY	2026-09-25 14:29	other	4	2	11	93512.00	unknown	ask	770.5600	1.3800	["728","729","770","776"]	["0.3660","0.2772","0.1709","0.1103"]	[]	["XISX","XMIO"]	728.0000	776.0000	0	7	false	false	true	true
01a0d9d1-c9c1-76f0-a156-3e594fcf5e2c	SPY	2026-09-25 14:26	other	7	2	40	26061.00	unknown	ask	770.9900	0.2500	["766","767","769","770","772","815"]	["0.3090","0.1084","0.1917","0.1158","0.1373","0.1181"]	[]	["XMIO","XPHO"]	766.0000	815.0000	0	97	false	false	true	true
01a0d9cf-8f6e-7e52-b1a0-348996e9f9e4	SPY	2026-09-25 14:24	other	4	2	133	65339.00	unknown	ask	771.2900	0.0800	["785","790","810"]	["0.3117","0.1808","0.1545"]	[]	["XBOX","XISX"]	785.0000	810.0000	0	357	false	false	true	true
01a0d9ca-2c87-78c1-a693-d8e4f1fae977	SPY	2026-09-25 14:18	other	6	2	47	45146.00	unknown	ask	771.4500	0.0800	["700","740","755","774","790"]	["0.2091","0.1658","0.1286","0.0906","0.1011"]	[]	["XMIO"]	700.0000	790.0000	4	56	false	false	true	true
01a0d9c9-f5d7-7903-a676-4418a1e74ea3	SPY	2026-09-25 14:18	other	4	1	90	89280.00	unknown	ask	771.4000	0.0500	["769","770","771","772"]	["0.1473","0.1298","0.0766","0.0988"]	[]	["XCBO"]	769.0000	772.0000	0	5	false	false	true	true
01a0d9a1-b140-70e2-81a5-ff3900f740bd	SPY	2026-09-25 13:34	other	4	1	31	62010.00	unknown	ask	770.7815	0.2100	["764","774"]	["0.2112","0.1404"]	[]	["XISX"]	764.0000	774.0000	0	7	false	false	true	true
01a0d990-1d3f-7db0-93e8-797c5de91111	SPY	2026-09-25 13:14	other	4	1	10	31460.00	unknown	ask	771.1400	0.3000	["766","768","769","772"]	["0.1275","0.1250","0.1751","0.1594"]	[]	["XISX"]	766.0000	772.0000	0	28	false	false	true	true
01a0d94c-4610-7a02-bacb-0413dfeb9764	SPY	2026-09-25 12:00	other	5	2	62	40056.00	unknown	ask	770.3800	0.1200	["765","770","775","799","809"]	["0.0999","0.0833","0.0822","0.1034","0.1045"]	[]	["C2OX","XISX"]	765.0000	809.0000	3	28	false	false	true	true
01a0d94c-03a8-7f80-91e7-e55f5625babd	SPY	2026-09-25 12:00	other	4	1	12	25656.00	unknown	ask	770.0700	0.0900	["760","775"]	["0.2102","0.1308"]	[]	["XISX"]	760.0000	775.0000	0	3	false	false	true	true
01a0d933-fb4f-7042-9ce7-548ee3684089	SPY	2026-09-25 11:34	other	4	2	150	132106.00	unknown	ask	769.6600	0.0400	["650","730","764","767"]	["0.2567","0.1793","0.1957","0.1755"]	[]	["XISX"]	650.0000	767.0000	0	84	false	false	true	true
01a0d932-1307-7952-bef9-618d2c74023a	SPY	2026-09-25 11:32	other	4	1	3	54552.00	unknown	ask	769.6700	0.4100	["700","715","748","761"]	["0.1864","0.1756","0.4970","0.1914"]	[]	["XISX"]	700.0000	761.0000	0	97	false	false	true	true
01a0d906-4fe6-7ab2-a334-f6027ca0df29	SPY	2026-09-25 10:44	other	4	2	2	88325.00	unknown	ask	767.6100	7.7200	["300","380","773"]	["1.9605","1.5076","0.1566"]	[]	["XCBO"]	300.0000	773.0000	0	21	false	false	true	true
01a0d8de-e60f-7a81-a34b-742b474d8dae	SPY	2026-09-25 10:01	other	4	1	100	52700.00	unknown	ask	768.9500	0.0400	["778","782","786"]	["0.1099","0.1046","0.1002"]	[]	["XMIO"]	778.0000	786.0000	7	13	false	true	true	true
01a0d8d7-d95f-7ef1-94f1-aad64161a85a	SPY	2026-09-25 09:53	other	4	2	60	33165.00	unknown	ask	769.8700	0.0500	["768","769","770","771"]	["0.1570","0.1535","0.1486","0.1472"]	["770.67"]	["XMIO","XPHO"]	768.0000	771.0000	0	0	false	false	false	true
01a0d8cc-b9b8-7022-a9dd-95c93b093786	SPY	2026-09-25 09:41	other	6	3	84	78680.00	unknown	ask	769.9100	0.0600	["765","766","767","768","772","775"]	["0.1602","0.1625","0.1055","0.0830","0.0807","0.0980"]	[]	["XISX","XPHO"]	765.0000	775.0000	0	5	false	false	true	true
01a0d8c7-6e3f-76f2-97e1-2f841ca4f780	SPY	2026-09-25 09:35	other	6	3	29	26769.00	unknown	ask	769.6700	0.0600	["746","756","765","766","769","770"]	["0.1557","0.1276","0.1953","0.1894","0.0848","0.0843"]	[]	["XISX","XMIO"]	746.0000	770.0000	0	4	false	false	true	true
01a0d8c6-7827-7482-951d-697b47576aaa	SPY	2026-09-25 09:34	other	3	1	7	27333.00	unknown	ask	769.3900	0.1300	["750","753","771"]	["0.3838","0.1144","0.0899"]	[]	["XISX"]	750.0000	771.0000	0	4	false	false	true	true
01a0d4fa-9376-7082-be91-967dbcadd69d	SPY	2026-09-24 15:53	other	6	2	4898	388166.00	unknown	ask	767.8900	0.0600	["750","757","760","766","771"]	["0.1380","0.1201","1.2013","0.5189","0.5332"]	[]	["XBOX","XCBO"]	750.0000	771.0000	0	4	false	false	true	true
01a0d4f7-c4ba-7211-90b5-075cb1d4db2f	SPY	2026-09-24 15:50	other	4	3	200	163406.00	unknown	ask	767.5100	0.5200	["770","771","774"]	["0.5073","0.1275","0.1258"]	[]	["XISX","XMIO"]	770.0000	774.0000	0	7	false	false	true	true
01a0d4f7-c4ba-7211-90b5-07245d46219a	SPY	2026-09-24 15:50	other	4	3	70	58802.00	unknown	ask	767.5100	0.6100	["766","768","770"]	["0.2405","0.2977","0.3205"]	[]	["ARCO","XISX","XPHO"]	766.0000	770.0000	0	7	false	false	true	true
01a0d4e7-cec7-7a00-b183-844c9a1e64f6	SPY	2026-09-24 15:32	other	4	2	30	841178.00	unknown	ask	767.4500	8.7900	["768","769","905","910"]	["0.2344","0.2480","0.2436","0.2481"]	[]	["XMIO"]	768.0000	910.0000	0	848	false	false	true	true
01a0d4dd-5ee7-71a0-96ea-04ee43334edd	SPY	2026-09-24 15:21	other	6	2	130	35606.00	unknown	ask	767.5400	0.0900	["766","767","770","775","780"]	["0.2458","0.2282","0.1218","0.1173","0.1146"]	[]	["XISX","XMIO"]	766.0000	780.0000	0	22	false	false	true	true
01a0d4d8-07b7-7eb1-aa13-433a0aaa098d	SPY	2026-09-24 15:15	other	3	1	2	39497.00	unknown	ask	767.3800	8.0800	["600","795","800"]	["10.5262","0.1572","0.1798"]	[]	["C2OX"]	600.0000	800.0000	0	8	false	false	true	true
01a0d4d7-f817-74c0-927f-eb7c9291a709	SPY	2026-09-24 15:15	other	5	2	2	40547.00	unknown	ask	767.3850	8.1000	["600","766","771","795","800"]	["10.4660","0.2567","0.2602","0.1575","0.1802"]	[]	["C2OX","XISX"]	600.0000	800.0000	0	8	false	false	true	true
01a0d4d6-4e4e-7532-b8aa-865fafa5bc1d	SPY	2026-09-24 15:13	other	3	1	2	55997.00	unknown	ask	767.3900	7.7300	["550","810","850"]	["12.6263","0.1738","0.2865"]	[]	["C2OX"]	550.0000	850.0000	0	22	false	false	true	true
01a0d4d6-467f-7931-b1c8-7b31c3f0b468	SPY	2026-09-24 15:13	other	3	1	2	55997.00	unknown	ask	767.3700	7.7700	["550","810","850"]	["13.1530","0.1733","0.2851"]	[]	["C2OX"]	550.0000	850.0000	0	22	false	false	true	true
01a0d4d1-e567-76b2-ae37-9ab499e46530	SPY	2026-09-24 15:08	other	3	1	3	31578.00	unknown	ask	767.4900	2.7100	["715","796"]	["1.6888","0.2545"]	[]	["XISX"]	715.0000	796.0000	0	1	false	false	true	true
01a0d4ce-6eae-72b1-962c-59930ea7cb03	SPY	2026-09-24 15:04	other	4	1	40	27120.00	unknown	ask	767.1100	0.0500	["766","768"]	["0.2040","0.1877"]	[]	["XISX"]	766.0000	768.0000	0	1	false	false	true	true
01a0d4cc-dc57-7831-8633-5f6cad73a451	SPY	2026-09-24 15:03	other	3	1	10	129650.00	unknown	ask	767.2750	4.9800	["740","800","810"]	["0.1710","0.1734","0.1229"]	[]	["XISX"]	740.0000	810.0000	113	848	false	true	true	true
01a0d4cc-a1be-7f51-9fff-eb8f912172e7	SPY	2026-09-24 15:02	other	4	1	56	45584.00	unknown	ask	767.2900	0.0500	["766","767"]	["0.2019","0.1887"]	[]	["XISX"]	766.0000	767.0000	0	1	false	false	true	true
01a0d4ca-0d97-7de3-97fe-be128c762a87	SPY	2026-09-24 15:00	other	4	1	40	105040.00	unknown	ask	768.0400	0.3900	["760","762","765","767"]	["0.2840","0.1258","0.2450","0.1178"]	[]	["XCBO"]	760.0000	767.0000	0	7	false	false	true	true
01a0d4c1-9988-7b52-a776-83adbce35274	SPY	2026-09-24 14:50	other	4	1	10	34410.00	unknown	ask	767.8300	0.5400	["757","760","762","765"]	["0.4773","0.1298","0.3131","0.1213"]	[]	["XMIO"]	757.0000	765.0000	0	7	false	false	true	true
01a0d4b3-0327-7c53-a8d5-c8e039deef78	SPY	2026-09-24 14:34	other	4	1	50	73100.00	unknown	ask	767.1300	0.1000	["765","770","775","780"]	["0.1046","0.1196","0.0960","0.1098"]	[]	["XISX"]	765.0000	780.0000	4	15	false	false	true	true
01a0d4aa-3d10-7e02-9a08-45a185603862	SPY	2026-09-24 14:25	other	8	4	60	49440.00	unknown	ask	767.3400	0.0800	["761","764","766","767","768","770","771"]	["0.3550","0.1603","0.2271","0.1668","0.2061","0.2314","0.2491"]	[]	["XISX","XPHO"]	761.0000	771.0000	0	1	false	false	true
01a0d486-0b6f-7480-8272-4111c42da7cf	SPY	2026-09-24 13:45	other	3	3	85	80681.00	unknown	ask	766.1450	0.0600	["730","759","765"]	["0.1779","0.1170","0.1294"]	[]	["XBOX","XISX","XPHO"]	730.0000	765.0000	4	22	false	true	true	true
01a0d486-0b6f-7480-8272-40f4293f04b9	SPY	2026-09-24 13:45	other	3	4	270	256032.00	unknown	ask	766.1450	0.0600	["730","759","765"]	["0.1777","0.1170","0.1293"]	[]	["EDGO","XCBO","XMIO","XPHO"]	730.0000	765.0000	4	22	false	true	true	true