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×net_side = bid×strategy = other×

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

01a0f936-cda5-7640-937b-cc1e1c79f35d	SPX	2026-10-01 16:45	other	3	1	6	75792.00	unknown	bid	7666.4500	4.1000	["7450","7800","7825"]	["0.1573","0.1149","0.1134"]	["7220.60","7679.40","7945.60"]	["XCBO"]	7450.0000	7825.0000	21	21	false	false	false	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500}	2026-10-01	2026-10-01 17:15	2026-10-01 17:15
01a0f936-cda5-7640-937b-cc074d70ee1a	SPX	2026-10-01 16:45	other	3	3	24	302592.00	unknown	bid	7666.4500	4.8917	["7450","7800","7825"]	["0.1570","0.1145","0.1134"]	["7220.6","7679.4","7945.60"]	["XCBO"]	7450.0000	7825.0000	21	21	false	false
01a0f936-cda5-7640-937b-cbf0171822d0	SPX	2026-10-01 16:45	other	3	2	20	252160.00	unknown	bid	7666.4500	6.2000	["7450","7800","7825"]	["0.1570","0.1144","0.1135"]	["7220.60","7679.40","7945.60"]	["XCBO"]	7450.0000	7825.0000	21	21	false	false
01a0f936-cda5-7640-937b-cbe7db15cd52	SPX	2026-10-01 16:45	other	3	2	20	252160.00	unknown	bid	7666.4500	6.2000	["7450","7800","7825"]	["0.1570","0.1144","0.1135"]	["7220.60","7679.40","7945.60"]	["XCBO"]	7450.0000	7825.0000	21	21	false	false
01a0f91a-f566-7462-b4f6-3ba93503fdf3	QQQ	2026-10-01 16:14	other	4	1	39	64272.00	unknown	bid	742.9510	0.2500	["732","745"]	["0.1816","0.1670"]	[]	["XPHO"]	732.0000	745.0000	4	8	false	true
01a0f919-fb67-7eb2-a3f3-cbd5b999dc0c	SMH	2026-10-01 16:13	other	3	4	18	32119.00	unknown	bid	617.5000	4.7000	["550","607.5"]	["0.3868","0.3212"]	["479.21","620.79"]	["AMXO","ARCO","XCBO","XISX"]	550.0000	607.5000	15	15	false	false
01a0f919-fb67-7eb2-a3f3-cb1c191bee55	SMH	2026-10-01 16:13	other	3	6	26	46386.00	unknown	bid	617.1010	4.7000	["550","607.5"]	["0.3852","0.3222"]	["479.24","620.76"]	["AMXO","ARCO","XCBO","XISX","XPHO"]	550.0000	607.5000	15	15	false	false
01a0f919-95d7-7150-97be-aeab80070b65	SPX	2026-10-01 16:13	other	6	1	2	60574.00	unknown	bid	7666.4500	4.7000	["7650","7665","7675","7700","7800"]	["0.1983","0.1374","0.1316","0.1449","0.1420"]	[]	["XCBO"]	7650.0000	7800.0000	1	78	false	false
01a0f916-6d3f-7093-9a29-769309f6498b	SPX	2026-10-01 16:09	other	2	1	1000	11628000.00	unknown	bid	7666.4500	2.0000	["7730","7750"]	["0.1421","0.1206"]	[]	["XCBO"]	7730.0000	7750.0000	15	78	false	false
01a0f916-6d3f-7093-9a29-768cb7594074	SPX	2026-10-01 16:09	other	3	3	1600	37137600.00	unknown	bid	7666.4500	3.0000	["7730","7750"]	["0.1396","0.1206"]	[]	["XCBO"]	7730.0000	7750.0000	15	78	false	false
01a0f915-f80f-7601-a2b0-a84d361ede98	QQQ	2026-10-01 16:09	other	4	4	286	150268.00	unknown	bid	742.7000	0.3500	["724","730","741","743"]	["0.2722","0.2539","0.3992","0.2301"]	[]	["ARCO","XBOX","XMIO"]	724.0000	743.0000	0	1	false	false
01a0f914-810e-7122-a0b6-31ea1d69b2e8	SPX	2026-10-01 16:07	other	4	1	2	37335.00	unknown	bid	7666.4500	1.6000	["7600","7650","7675"]	["0.1494","0.1191","0.1008"]	[]	["XCBO"]	7600.0000	7675.0000	4	50	false	false
01a0f913-b5ee-7be0-a328-b59a5c18ccdc	QQQ	2026-10-01 16:06	other	4	1	180	123900.00	unknown	bid	742.5401	0.1700	["744","746"]	["0.2967","0.2191"]	[]	["XCBO"]	744.0000	746.0000	0	1	false	false
01a0f913-4c77-7450-9fc8-f7315bd8f07d	SPX	2026-10-01 16:06	other	6	2	30	226622.00	unknown	bid	7666.4500	1.2000	["7650","7685","7700","7710","7720","7730"]	["0.1259","0.1185","0.1678","0.1639","0.1608","0.1580"]	[]	["XCBO"]	7650.0000	7730.0000	1	5	false	false
01a0f913-2566-7110-bf05-f36da5fe179d	SPX	2026-10-01 16:06	other	3	1	5	27160.00	unknown	bid	7666.4500	1.1000	["7320","7470","7560"]	["0.1773","0.1553","0.1304"]	[]	["XCBO"]	7320.0000	7560.0000	11	29	false	true
01a0f912-4aa7-7e21-b45b-ee56ffc06e2d	SPX	2026-10-01 16:05	other	4	1	54	90090.00	unknown	bid	7666.4500	0.9500	["7250","7350","7950"]	["0.1833","0.1657","0.1001"]	[]	["XCBO"]	7250.0000	7950.0000	11	25	false	true
01a0f912-277f-7831-a7b1-476e0dd81fe1	SPX	2026-10-01 16:05	other	4	1	15	25025.00	unknown	bid	7666.4500	1.0500	["7250","7350","7950"]	["0.1833","0.1657","0.1001"]	[]	["XCBO"]	7250.0000	7950.0000	11	25	false	true
01a0f90f-1e27-7352-8ee9-2c2f665f1456	SPX	2026-10-01 16:01	other	2	1	50	779800.00	unknown	bid	7666.6900	1.9000	["7500","7725"]	["0.1595","0.1363"]	[]	["XCBO"]	7500.0000	7725.0000	50	78	false	true
01a0f90f-1e27-7352-8ee9-2c157ca74f1c	SPX	2026-10-01 16:01	other	2	1	100	1539800.00	unknown	bid	7666.6900	1.9000	["7500","7725"]	["0.1595","0.1363"]	[]	["XCBO"]	7500.0000	7725.0000	50	78	false	true
01a0f90f-1e27-7352-8ee9-2c0af75c51e6	SPX	2026-10-01 16:01	other	2	1	100	1539800.00	unknown	bid	7666.6900	1.9000	["7500","7725"]	["0.1595","0.1363"]	[]	["XCBO"]	7500.0000	7725.0000	50	78	false	true
01a0f90f-1e27-7352-8ee9-2bfa38a70324	SPX	2026-10-01 16:01	other	2	1	100	1539800.00	unknown	bid	7666.6900	1.9000	["7500","7725"]	["0.1595","0.1363"]	[]	["XCBO"]	7500.0000	7725.0000	50	78	false	true
01a0f90f-1e27-7352-8ee9-2be7d502d575	SPX	2026-10-01 16:01	other	2	1	500	7699000.00	unknown	bid	7666.6900	2.1000	["7500","7725"]	["0.1595","0.1363"]	[]	["XCBO"]	7500.0000	7725.0000	50	78	false	true
01a0f90d-31f6-7bf3-a59e-e9b6d2824edb	SPX	2026-10-01 15:59	other	7	2	6	114982.00	unknown	bid	7665.2600	11.9000	["7485","7530","7770","7775","7950"]	["0.1554","0.1458","0.1145","0.1141","0.1205"]	[]	["XCBO"]	7485.0000	7950.0000	15	50	false	false
01a0f90d-263f-7113-b21b-f2d49984580a	SPX	2026-10-01 15:59	other	5	1	6	144545.00	unknown	bid	7665.5200	11.3000	["7445","7465","7955"]	["0.1622","0.1591","0.1202"]	["7026.88","7743.75","8166.25"]	["XCBO"]	7445.0000	7955.0000	50	50	false	false
01a0f90c-dc07-7a31-a321-18f1ee8c7abd	SPX	2026-10-01 15:59	other	7	3	7	103081.00	unknown	bid	7663.7200	4.9500	["7500","7525","7630","7660","7670","7675","7725"]	["0.1851","0.1745","0.1359","0.4168",null,"0.1313","0.1265"]	[]	["XCBO"]	7500.0000	7725.0000	0	32	false	false
01a0f90c-dc07-7a31-a321-181deabf61b5	MU	2026-10-01 15:59	other	4	1	7	1177456.00	unknown	bid	1098.1300	48.3500	["800","820","900","960"]	["0.5646","0.5565","0.5612","0.5572"]	[]	["BATO"]	800.0000	960.0000	442	624	false	false
01a0f90c-d436-70a3-99ab-513cbae28d1c	SPX	2026-10-01 15:59	other	4	1	52	238452.00	unknown	bid	7664.4800	0.7500	["7570","7585","7670","7675"]	["0.1678","0.1673","0.1649","0.1634"]	["7672.47"]	["XCBO"]	7570.0000	7675.0000	1	1	false	true
01a0f90c-cc67-7923-bcde-20a2b89016b9	AVGO	2026-10-01 15:59	other	4	1	10	28510.00	unknown	bid	343.6900	1.0000	["330","350"]	["0.3428","0.3307"]	[]	["XBOX"]	330.0000	350.0000	8	15	false	false
01a0f90c-cc66-7023-aa2b-7447d294d3b1	SPX	2026-10-01 15:59	other	4	1	3	347350.00	unknown	bid	7665.0100	12.3000	["7200","7400","7450"]	["0.1794","0.1634","0.1611"]	[]	["XCBO"]	7200.0000	7450.0000	50	106	false	false
01a0f90c-c87f-7d00-b68b-35b56af9dcb7	SPX	2026-10-01 15:59	other	4	1	15	76605.00	unknown	bid	7665.0100	0.9000	["7665","7675"]	["0.3873","0.3465"]	[]	["XCBO"]	7665.0000	7675.0000	0	1	false	false
01a0f90c-c87f-7d00-b68b-3512c17e33ba	SPX	2026-10-01 15:59	other	4	1	3	347457.00	unknown	bid	7664.7600	11.4000	["7200","7400","7450"]	["0.1798","0.1638","0.1613"]	[]	["XCBO"]	7200.0000	7450.0000	50	106	false	false
01a0f90c-c0af-76c0-8294-34794ffaa82e	SPX	2026-10-01 15:59	other	3	1	24	31904.00	unknown	bid	7665.7900	0.6000	["7720","7745","7750"]	["0.1535","0.0987","0.0983"]	[]	["XCBO"]	7720.0000	7750.0000	1	4	false	true
01a0f90c-b4f7-7bf1-be1c-252ed9a6310b	SPX	2026-10-01 15:59	other	4	1	3	90481.00	unknown	bid	7666.1000	6.1000	["7400","7525","7550"]	["0.1683","0.1463","0.1548"]	[]	["XCBO"]	7400.0000	7550.0000	15	50	false	false
01a0f90c-a93f-71e0-b2be-31a973e0898b	SPX	2026-10-01 15:59	other	5	3	6	124661.00	unknown	bid	7666.1400	10.2000	["7670","7675","7680","7790"]	["0.4871","0.4994","0.6371","0.1246"]	[]	["XCBO"]	7670.0000	7790.0000	0	8	false	false
01a0f90c-95b7-70a0-93d5-5fb478d4501b	MU	2026-10-01 15:59	other	7	2	14	108893.00	unknown	bid	1098.2800	10.7600	["1125","1130","1135","1140","1145","1155"]	["0.6810","0.6887","0.7007","0.6043","0.5296","0.7538"]	[]	["XISX"]	1125.0000	1155.0000	1	29	false	true
01a0f90c-8de7-7bc0-948a-39c6004a5909	RUT	2026-10-01 15:59	other	4	1	15	60995.00	unknown	bid	2806.9316	5.4500	["2765","2810","2850"]	["0.2976","0.1986","0.2608"]	[]	["XCBO"]	2765.0000	2850.0000	1	4	false	false
01a0f90c-8de7-7bc0-948a-37be3ec95118	SPX	2026-10-01 15:59	other	3	1	18	2106330.00	unknown	bid	7664.6100	5.5000	["7700","7900"]	["0.1712","0.1491"]	[]	["XCBO"]	7700.0000	7900.0000	259	351	false	false
01a0f90c-66d6-7950-880d-dc7bdb108678	SPX	2026-10-01 15:58	other	8	2	4	150700.00	unknown	bid	7666.7900	16.9000	["7445","7450","7455","8005","8015"]	["0.1622","0.1616","0.1611","0.1183","0.1181"]	["7117.27","7782.73","8179.20"]	["XCBO"]	7445.0000	8015.0000	50	50	false
01a0f90c-534e-7cf2-b7b3-ddfbe34297c4	SPX	2026-10-01 15:58	other	4	1	3	90170.00	unknown	bid	7667.8200	8.3000	["7450","7525","7650"]	["0.1633","0.1464","0.1293"]	[]	["XCBO"]	7450.0000	7650.0000	15	50	false	false
01a0f90c-0147-7853-aefa-ef8a58e3733a	SPX	2026-10-01 15:58	other	4	1	15	113640.00	unknown	bid	7668.1000	1.3500	["7650","7680"]	["0.3556","0.1073"]	[]	["XCBO"]	7650.0000	7680.0000	0	4	false	false
01a0f90b-fd5f-7921-8311-3a6e70564752	MU	2026-10-01 15:58	other	4	2	3	46100.00	unknown	bid	1096.0301	6.5000	["1075","1110","1160","1200"]	["0.5385","0.5416","0.5391","0.5514"]	[]	["MCRY","XCBO"]	1075.0000	1200.0000	15	29	false	false
01a0f90b-f977-77a3-aa08-b13d5f342e71	GS	2026-10-01 15:58	other	4	1	120	281280.00	unknown	bid	896.0100	9.7500	["845","850","890","895"]	["0.3804","0.3794","0.3859","0.3899"]	[]	["XCBO"]	845.0000	895.0000	1	15	false	true
01a0f90b-f1a7-7ba0-be8e-ce8099b03985	SPX	2026-10-01 15:58	other	3	1	6	63695.00	unknown	bid	7667.7400	5.2000	["7745","7760","7770"]	["0.1163","0.1157","0.1147"]	["7554.35","7851.16"]	["XCBO"]	7745.0000	7770.0000	15	15	false	false
01a0f90b-e5ee-7590-ac36-e2e50c6089b8	GS	2026-10-01 15:58	other	4	1	80	187480.00	unknown	bid	895.8100	9.7500	["845","850","890","895"]	["0.3807","0.3770","0.3817","0.3875"]	[]	["XMIO"]	845.0000	895.0000	1	15	false	true
01a0f90b-d267-7dd3-a44b-73e1598cfb47	NDX	2026-10-01 15:58	other	5	2	2	54898.00	unknown	bid	0.0000	45.2000	["30480","30500","30510","30520","30530"]	["0.2236","0.2227","0.2221","0.1535","0.1468"]	[]	["XISX","XPHO"]	30480.0000	30530.0000	0	1	false	false
01a0f90b-6cd6-71f1-8bbc-034dce36b471	SPX	2026-10-01 15:57	other	3	1	300	3728100.00	unknown	bid	7668.4200	2.2500	["7735","8000"]	["0.1397","0.1053"]	[]	["XCBO"]	7735.0000	8000.0000	15	78	false	false
01a0f90b-594f-7cf1-8856-d0603022a36a	SPX	2026-10-01 15:57	other	4	1	31	29080.00	unknown	bid	7668.2100	0.4145	["7670","7675"]	["0.2488","0.3641"]	["7671.20"]	["XCBO"]	7670.0000	7675.0000	0	0	false	false
01a0f90b-4d97-7ff2-84e2-a2558a2fd829	SPX	2026-10-01 15:57	other	4	1	20	480360.00	unknown	bid	7668.8100	1.7000	["7660","7670","8100","8150"]	["0.6658","0.3624","0.1302","0.1186"]	[]	["XCBO"]	7660.0000	8150.0000	0	181	false	false
01a0f90b-4d97-7ff2-84e2-a193529a2748	SPX	2026-10-01 15:57	other	2	1	50	1972500.00	unknown	bid	7668.8100	2.8000	["7700","7735"]	["0.1679","0.1355"]	[]	["XCBO"]	7700.0000	7735.0000	78	232	false	false
01a0f90a-c8c6-7592-86dd-47933ab4fb23	META	2026-10-01 15:57	other	4	1	500	1463250.00	unknown	bid	725.7250	0.5200	["625","675","725","745"]	["0.4153","0.3738","0.3650","0.3643"]	["727.35"]	["XBOX"]	625.0000	745.0000	15	15	false	false