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:direction = long×strategy = call_ratio_spread×ticker = SPY×

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

01a0d996-f727-7ce3-8538-bf557594b857	SPY	2026-09-25 13:22	call_ratio_spread	2	1	2	32147.00	long	ask	770.9750	7.1800	["665","770"]	["0.1996","0.1682"]	["878.73"]	["XISX"]	665.0000	770.0000	448	448	false	false	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T17:22:47Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0d959-f5f7-7720-b6b2-98cdbdd4f821	SPY	2026-09-25 12:15	call_ratio_spread	2	1	50	109850.00	long	ask	771.5800	0.0800	["767","772"]	["0.1332","0.1280"]	["787.30"]	["XMIO"]	767.0000	772.0000	35	35	false	false	false
01a0d959-da9f-7b43-86c0-f6138dfae19b	SPY	2026-09-25 12:15	call_ratio_spread	2	1	40	94620.00	long	ask	771.4500	0.2700	["780","805"]	["0.1344","0.1231"]	["780.23","829.77"]	["XMIO"]	780.0000	805.0000	112	112	false	true	false
01a0d959-da9f-7b43-86c0-f5f96eed8072	SPY	2026-09-25 12:15	call_ratio_spread	2	8	496	1173788.00	long	ask	771.4500	0.2700	["780","805"]	["0.1345","0.1232"]	["780.23","829.77"]	["AMXO","ARCO","C2OX","EMLD","MCRY","XBOX","XISX","XPHO"]	780.0000	805.0000	112	112	false	true	false
01a0d959-da9f-7b43-86c0-f5e57c7210bd	SPY	2026-09-25 12:15	call_ratio_spread	2	2	264	625020.00	long	ask	771.4500	0.2700	["780","805"]	["0.1345","0.1232"]	["780.23","829.77"]	["EDGO","XCBO"]	780.0000	805.0000	112	112	false	true	false
01a0d959-6957-7672-b53f-90f779fa3bca	SPY	2026-09-25 12:15	call_ratio_spread	2	1	50	118375.00	long	ask	771.4800	0.2700	["780","805"]	["0.1345","0.1231"]	["780.23","829.77"]	["XMIO"]	780.0000	805.0000	112	112	false	true	false
01a0d959-2ad7-7052-ba43-d53b806654ae	SPY	2026-09-25 12:14	call_ratio_spread	2	1	50	118350.00	long	ask	771.4800	0.2600	["780","805"]	["0.1344","0.1231"]	["780.22","829.78"]	["XMIO"]	780.0000	805.0000	112	112	false	true	false
01a0d959-07af-7c21-9091-ce8c863ff44a	SPY	2026-09-25 12:14	call_ratio_spread	2	1	50	118175.00	long	ask	771.4100	0.2700	["780","805"]	["0.1344","0.1232"]	["780.23","829.77"]	["XMIO"]	780.0000	805.0000	112	112	false	true	false
01a0d958-e09f-77d0-8ace-3fac7ae0fed2	SPY	2026-09-25 12:14	call_ratio_spread	2	1	50	118000.00	long	ask	771.3200	0.2700	["780","805"]	["0.1345","0.1232"]	["780.24","829.76"]	["XMIO"]	780.0000	805.0000	112	112	false	true	false
01a0d955-13f7-7d01-8084-afce7797dbf9	SPY	2026-09-25 12:10	call_ratio_spread	2	1	52	114400.00	long	ask	771.6600	0.1000	["767","772"]	["0.1329","0.1278"]	["787.32"]	["XCBO"]	767.0000	772.0000	35	35	false	false	false
01a0d955-13f7-7d01-8084-afba6550fd92	SPY	2026-09-25 12:10	call_ratio_spread	2	1	84	184884.00	long	ask	771.6500	0.1000	["767","772"]	["0.1331","0.1278"]	["787.30"]	["XISX"]	767.0000	772.0000	35	35	false	false	false
01a0d955-13f7-7d01-8084-afa89c15d6f1	SPY	2026-09-25 12:10	call_ratio_spread	2	1	14	30828.00	long	ask	771.6500	0.1000	["767","772"]	["0.1331","0.1279"]	["787.32"]	["XISX"]	767.0000	772.0000	35	35	false	false	false
01a0d94d-6b08-77e1-92bf-87b014831217	SPY	2026-09-25 12:02	call_ratio_spread	2	1	100	25800.00	long	ask	770.6000	0.0200	["769","770"]	["0.1844","0.1770"]	["771.80"]	["XISX"]	769.0000	770.0000	0	0	false	false	false
01a0d948-0fef-77c2-88c1-41508b8a4e06	SPY	2026-09-25 11:56	call_ratio_spread	2	1	993	74806.00	long	ask	768.6300	0.0200	["773","777"]	["0.0816","0.0844"]	["773.44","784.12"]	["EDGO"]	773.0000	777.0000	3	3	false	true	false
01a0d948-0fef-77c2-88c1-4144979bda4b	SPY	2026-09-25 11:56	call_ratio_spread	2	1	1491	112322.00	long	ask	768.6600	0.0200	["773","777"]	["0.0813","0.0841"]	["773.44","784.12"]	["EDGO"]	773.0000	777.0000	3	3	false	true	false
01a0d906-9e07-7d62-a19d-062e4cccd00e	SPY	2026-09-25 10:44	call_ratio_spread	2	2	8	29120.00	long	ask	767.8095	0.2050	["840","860"]	["0.1453","0.1401"]	["894.20"]	["EMLD","SPHR"]	840.0000	860.0000	357	357	false	true	false
01a0d4b5-f50f-7ac1-aadf-cb7b5ac6655d	SPY	2026-09-24 14:38	call_ratio_spread	2	1	2	31369.00	long	ask	767.1110	9.0000	["665","770"]	["0.2001","0.1689"]	["877.35"]	["XCBO"]	665.0000	770.0000	449	449	false	false	false
01a0d44a-bbd8-7b80-a127-61ac6547af7e	SPY	2026-09-24 12:41	call_ratio_spread	2	2	72	160140.00	long	ask	768.3400	0.2500	["780","805"]	["0.1356","0.1244"]	["780.45","829.55"]	["EDGO","XISX"]	780.0000	805.0000	113	113	false	true	false
01a0d44a-b7ef-7863-9cc6-8ddebf1a4641	SPY	2026-09-24 12:40	call_ratio_spread	2	3	134	297614.00	long	ask	768.2800	0.2300	["780","805"]	["0.1356","0.1244"]	["780.46","829.54"]	["EDGO","XCBO","XISX"]	780.0000	805.0000	113	113	false	true	false
01a0d44a-b7ef-7863-9cc6-8db068ee31f5	SPY	2026-09-24 12:40	call_ratio_spread	2	1	580	1288180.00	long	ask	768.2800	0.2300	["780","805"]	["0.1356","0.1244"]	["780.46","829.54"]	["XMIO"]	780.0000	805.0000	113	113	false	true	false
01a0d44a-796f-71c1-a48a-48366fdaf62e	SPY	2026-09-24 12:40	call_ratio_spread	2	1	40	88260.00	long	ask	768.0600	0.2400	["780","805"]	["0.1355","0.1243"]	["780.49","829.51"]	["EDGO"]	780.0000	805.0000	113	113	false	true	false
01a0d44a-65e7-7f61-88a0-d2217ce05cdc	SPY	2026-09-24 12:40	call_ratio_spread	2	1	1152	640512.00	long	ask	768.0100	0.0400	["763","768"]	["0.1757","0.1548"]	["764","772.00"]	["XPHO"]	763.0000	768.0000	1	1	false	false	false
01a0d44a-65e7-7f61-88a0-d2040f6d1917	SPY	2026-09-24 12:40	call_ratio_spread	2	1	1152	640512.00	long	ask	768.0159	0.0300	["763","768"]	["0.1754","0.1546"]	["764","772.00"]	["XPHO"]	763.0000	768.0000	1	1	false	false	false
01a0d44a-65e7-7f61-88a0-d1fde22306b6	SPY	2026-09-24 12:40	call_ratio_spread	2	1	1152	640512.00	long	ask	768.0159	0.0300	["763","768"]	["0.1754","0.1546"]	["764","772.00"]	["XPHO"]	763.0000	768.0000	1	1	false	false	false
01a0d44a-65e7-7f61-88a0-d1effbc2f4e0	SPY	2026-09-24 12:40	call_ratio_spread	2	1	1152	640512.00	long	ask	768.0159	0.0400	["763","768"]	["0.1754","0.1546"]	["764","772.00"]	["XPHO"]	763.0000	768.0000	1	1	false	false	false
01a0d44a-5e17-7950-a426-cc1a885c9297	SPY	2026-09-24 12:40	call_ratio_spread	2	1	400	219200.00	long	ask	767.9500	0.0300	["763","768"]	["0.1730","0.1542"]	["764","772.00"]	["XPHO"]	763.0000	768.0000	1	1	false	false	false
01a0d44a-5e17-7950-a426-cc07edf0f90a	SPY	2026-09-24 12:40	call_ratio_spread	2	1	50	27400.00	long	ask	767.9500	0.0300	["763","768"]	["0.1730","0.1542"]	["764","772.00"]	["XBOX"]	763.0000	768.0000	1	1	false	false	false
01a0d429-f14e-72a0-a8a9-1b4ba96585e9	SPY	2026-09-24 12:05	call_ratio_spread	2	1	118	489228.00	long	ask	764.0800	0.1700	["785","835"]	["0.1532","0.1361"]	["789.04","880.96"]	["XISX"]	785.0000	835.0000	279	279	false	true	false
01a0cfcf-f1b7-7710-ab45-1f781e86f3e8	SPY	2026-09-23 15:48	call_ratio_spread	2	1	300	62900.00	long	ask	767.8650	0.0200	["770","773"]	["0.1201","0.1156"]	["770.56","777.87"]	["EDGO"]	770.0000	773.0000	2	2	false	true	false
01a0cfcd-b766-7133-8dd3-98f674bce274	SPY	2026-09-23 15:45	call_ratio_spread	2	1	2	31763.00	long	ask	767.6872	7.2200	["665","770"]	["0.2125","0.1723"]	["876.65"]	["XISX"]	665.0000	770.0000	450	450	false	false	false
01a0cfc8-c1df-7e01-ae81-50a814c13d25	SPY	2026-09-23 15:40	call_ratio_spread	2	1	2	31917.00	long	ask	768.1250	7.1800	["665","770"]	["0.2109","0.1738"]	["878.15"]	["XISX"]	665.0000	770.0000	450	450	false	false	false
01a0cfba-1fc7-7782-83c2-60af6ebd0ff8	SPY	2026-09-23 15:24	call_ratio_spread	2	1	2	31785.00	long	ask	767.6500	7.2600	["665","770"]	["0.2112","0.1732"]	["877.51"]	["XISX"]	665.0000	770.0000	450	450	false	false	false
01a0cf73-cfc7-72a2-aef9-af337b4d040d	SPY	2026-09-23 14:07	call_ratio_spread	2	1	388	82644.00	long	ask	768.3100	0.0200	["773","790"]	["0.1119","0.1066"]	["776.06","803.94"]	["ARCO"]	773.0000	790.0000	9	9	false	true	false
01a0cf64-dba6-7aa3-b9ed-d605dc4e7e8e	SPY	2026-09-23 13:51	call_ratio_spread	2	1	386	83183.00	long	ask	768.4400	0.0300	["773","790"]	["0.1123","0.1053"]	["776.15","803.85"]	["ARCO"]	773.0000	790.0000	9	9	false	true	false
01a0cf53-dfff-74d3-a701-3a520c290929	SPY	2026-09-23 13:32	call_ratio_spread	2	1	2	31545.00	long	ask	767.2900	3.4000	["665","770"]	["0.2063","0.1722"]	["877.75"]	["XPHO"]	665.0000	770.0000	450	450	false	false	false
01a0cf51-a5af-7a62-9739-7d16d8288b4e	SPY	2026-09-23 13:30	call_ratio_spread	2	1	1516	322908.00	long	ask	767.0950	0.0200	["766","771"]	["0.1413","0.1275"]	["767.54","774.46"]	["XMIO"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-a5af-7a62-9739-7d0b72649869	SPY	2026-09-23 13:30	call_ratio_spread	2	1	762	162306.00	long	ask	767.0950	0.0200	["766","771"]	["0.1413","0.1275"]	["767.54","774.46"]	["ARCO"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-9ddf-7491-a445-0875e055148d	SPY	2026-09-23 13:30	call_ratio_spread	2	1	468	99684.00	long	ask	767.0800	0.0300	["766","771"]	["0.1419","0.1278"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-9ddf-7491-a445-086d55ca0a0b	SPY	2026-09-23 13:30	call_ratio_spread	2	3	144	30672.00	long	ask	767.0800	0.0300	["766","771"]	["0.1419","0.1278"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-9ddf-7491-a445-0846054488c7	SPY	2026-09-23 13:30	call_ratio_spread	2	2	368	78384.00	long	ask	767.0800	0.0300	["766","771"]	["0.1419","0.1278"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-9ddf-7491-a445-083bc57a8cf1	SPY	2026-09-23 13:30	call_ratio_spread	2	1	156	33228.00	long	ask	767.0800	0.0300	["766","771"]	["0.1419","0.1278"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-99f7-7483-aed9-65b6a96b7705	SPY	2026-09-23 13:30	call_ratio_spread	2	1	152	32376.00	long	ask	767.1300	0.0300	["766","771"]	["0.1400","0.1269"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf51-578f-7712-a017-c50660d27f4c	SPY	2026-09-23 13:30	call_ratio_spread	2	3	240	51600.00	long	ask	767.1600	0.0200	["766","771"]	["0.1402","0.1271"]	["767.54","774.46"]	["ARCO","C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf44-b147-7fa1-bc62-27a594bd2c3c	SPY	2026-09-23 13:16	call_ratio_spread	2	1	124	26164.00	long	ask	767.0631	0.0200	["766","771"]	["0.1412","0.1273"]	["767.54","774.46"]	["C2OX"]	766.0000	771.0000	1	1	false	false	false
01a0cf44-b147-7fa1-bc62-2785d045cc8e	SPY	2026-09-23 13:16	call_ratio_spread	2	6	198	41778.00	long	ask	767.0631	0.0200	["766","771"]	["0.1412","0.1273"]	["767.54","774.46"]	["ARCO","BATO","C2OX","EMLD"]	766.0000	771.0000	1	1	false	false	false
01a0ceea-b237-7061-9d71-6d0707b0c5eb	SPY	2026-09-23 11:37	call_ratio_spread	2	2	240	1075090.00	long	ask	768.9700	0.4200	["785","835"]	["0.1541","0.1368"]	["788.18","881.82"]	["AMXO","C2OX"]	785.0000	835.0000	280	280	false	true	false
01a0ceea-b237-7061-9d71-6cf9527abd67	SPY	2026-09-23 11:37	call_ratio_spread	2	1	124	556822.00	long	ask	768.9700	0.4300	["785","835"]	["0.1544","0.1371"]	["788.13","881.87"]	["XISX"]	785.0000	835.0000	280	280	false	true	false
01a0ceea-ae4e-7481-b777-c88743f7a097	SPY	2026-09-23 11:37	call_ratio_spread	2	1	124	556760.00	long	ask	768.9700	0.4200	["785","835"]	["0.1543","0.1371"]	["788.12","881.88"]	["XISX"]	785.0000	835.0000	280	280	false	true	false
01a0ceea-ae4e-7481-b777-c87007f3b8f7	SPY	2026-09-23 11:37	call_ratio_spread	2	1	124	556760.00	long	ask	768.9700	0.4200	["785","835"]	["0.1543","0.1371"]	["788.12","881.88"]	["XISX"]	785.0000	835.0000	280	280	false	true	false
01a0cedd-fc4f-7c82-afc1-a2a6e16a02a8	SPY	2026-09-23 11:24	call_ratio_spread	2	1	130	430495.00	long	ask	769.8460	0.3100	["750","790"]	["0.1565","0.1278"]	["761.79","818.21"]	["XCBO"]	750.0000	790.0000	86	86	false	false	false