Multi-leg option trades

core.multileg_trades

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

403,968 rowsCSV — whole table, not this view

Sources in this table

uw_multileg403,968 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:code = cbmo×strategy = ratio_risk_reversal×sorted by executed_at ↑×

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

01a06d54-7c6d-72a0-a87e-089f7ee6d969	SPX	2026-09-04 12:50	ratio_risk_reversal	2	1	50	143950.00	short	bid	7727.8900	1.0000	["7550","7730"]	["0.1310","0.0966"]	["7543.89"]	["XCBO"]	7550.0000	7730.0000	14	14	false	true	false	true	true	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-04T16:50:58Z"}	2026-09-04	2026-09-07 00:53	2026-09-07 00:53
01a06d88-f9ed-7a11-9565-0e367e4fd3f0	SPX	2026-09-04 13:48	ratio_risk_reversal	2	1	100	184200.00	short	ask	7709.7100	0.8000	["7715","7875"]	["0.1104","0.0915"]	["7875.64"]	["XCBO"]	7715.0000	7875.0000	14	14	false	false	false
01a06d95-b7a5-71b3-9844-d7db4789d0c9	SPX	2026-09-04 14:02	ratio_risk_reversal	2	1	1500	9285750.00	long	ask	7708.2900	0.9000	["7600","7715"]	["0.1221","0.1016"]	["7725.20"]	["XCBO"]	7600.0000	7715.0000	14	14	false	true	false
01a06d95-b7a5-71b3-9844-d7cd11a9951c	SPX	2026-09-04 14:02	ratio_risk_reversal	2	1	1500	8861250.00	long	bid	7708.2900	0.9000	["7715","7800"]	["0.1076","0.0948"]	["7701.46"]	["XCBO"]	7715.0000	7800.0000	14	14	false	false	false
01a06dbc-7d6d-7343-9524-daed6d16ff4b	SPX	2026-09-04 14:44	ratio_risk_reversal	2	1	50	408100.00	short	bid	7716.9900	1.1000	["7700","7720"]	["0.1101","0.0958"]	["7675.42"]	["XCBO"]	7700.0000	7720.0000	14	14	false	true	false
01a06dfb-66e5-7e42-9e5e-990c82a97d13	SPX	2026-09-04 15:53	ratio_risk_reversal	2	2	200	228100.00	long	ask	7718.3500	0.3000	["7500","7800"]	["0.1355","0.0825"]	["7807.84"]	["XCBO"]	7500.0000	7800.0000	7	7	false	true	false
01a06e03-3eb5-7e03-b1d9-3bb8c4eed689	SPX	2026-09-04 16:01	ratio_risk_reversal	2	1	44	396400.00	long	ask	7718.3700	0.9000	["7300","7800"]	["0.1704","0.1054"]	["7847.40"]	["XCBO"]	7300.0000	7800.0000	33	33	true	true	false
01a08162-74e8-7632-82a7-9514628c376d	SPX	2026-09-08 10:18	ratio_risk_reversal	2	1	140	592000.00	long	ask	7678.5400	1.1000	["7600","7685"]	["0.1390","0.1208"]	["7571.89"]	["XCBO"]	7600.0000	7685.0000	10	10	false	true	false
01a0816a-9ec0-7ed2-8120-40edeaa98f53	SPX	2026-09-08 10:27	ratio_risk_reversal	2	1	40	116320.00	long	bid	7680.8500	1.2000	["7685","7800"]	["0.1231","0.1092"]	["7804.88"]	["XCBO"]	7685.0000	7800.0000	10	10	false	false	false
01a0816a-9ec0-7ed2-8120-40db8f9dc4b0	SPX	2026-09-08 10:27	ratio_risk_reversal	2	1	40	116320.00	long	bid	7680.8500	1.2000	["7685","7800"]	["0.1231","0.1092"]	["7804.88"]	["XCBO"]	7685.0000	7800.0000	10	10	false	false	false
01a08176-acb0-75d0-b80a-3ce5e16197ce	SPX	2026-09-08 10:40	ratio_risk_reversal	2	1	10	79430.00	long	bid	7684.9200	1.2000	["7685","7700"]	["0.1240","0.1168"]	["7732.23"]	["XCBO"]	7685.0000	7700.0000	10	10	false	false	false
01a0817e-51b9-7a00-95ed-21e7da6568ee	SPX	2026-09-08 10:48	ratio_risk_reversal	2	1	150	128550.00	short	bid	7685.5800	0.7500	["7100","7690"]	["0.2471","0.1177"]	["7721.18"]	["XCBO"]	7100.0000	7690.0000	10	10	false	true	false
01a081b9-1898-7623-bb09-a7c24163bc09	SPX	2026-09-08 11:53	ratio_risk_reversal	2	1	150	970800.00	short	bid	7691.8000	1.1000	["7650","7695"]	["0.1280","0.1144"]	["7628.84"]	["XCBO"]	7650.0000	7695.0000	10	10	false	true	false
01a081b9-1898-7623-bb09-a7beefbf278b	SPX	2026-09-08 11:53	ratio_risk_reversal	2	1	50	323600.00	short	bid	7691.8000	1.1000	["7650","7695"]	["0.1280","0.1144"]	["7628.84"]	["XCBO"]	7650.0000	7695.0000	10	10	false	true	false
01a081d7-3b70-7ee3-b8d7-84d7225aae1f	SPX	2026-09-08 12:25	ratio_risk_reversal	2	3	175	826525.00	short	bid	7691.0600	0.8000	["7300","7800"]	["0.1782","0.1091"]	["7815.07"]	["XCBO"]	7300.0000	7800.0000	24	24	false	true	false
01a0825f-0529-7cd0-bbaf-d318395e0feb	SPX	2026-09-08 14:54	ratio_risk_reversal	2	2	300	2647600.00	short	bid	7684.9700	1.1000	["7605","7610"]	["0.1394","0.1277"]	["7649.29"]	["XCBO"]	7605.0000	7610.0000	10	10	false	false	false
01a08266-f851-71d3-8137-1220a0c1b456	SPX	2026-09-08 15:02	ratio_risk_reversal	2	1	100	28070.00	short	bid	7683.0100	0.7500	["7000","7685"]	["0.2720","0.1157"]	["6998.43"]	["XCBO"]	7000.0000	7685.0000	10	10	false	true	false
01a082a2-9dd9-7f10-b8d5-a9f205d85746	SPX	2026-09-08 16:08	ratio_risk_reversal	2	1	100	682100.00	short	bid	7673.5200	1.4000	["7575","7680"]	["0.1439","0.1160"]	["7688.98"]	["XCBO"]	7575.0000	7680.0000	10	10	false	true	false
01a082a2-9dd9-7f10-b8d5-a9e395ada011	SPX	2026-09-08 16:08	ratio_risk_reversal	2	1	100	682100.00	short	bid	7673.5200	1.4000	["7575","7680"]	["0.1439","0.1160"]	["7688.98"]	["XCBO"]	7575.0000	7680.0000	10	10	false	true	false
01a082a3-9bc0-7751-a3c0-10e1e0258180	SPX	2026-09-08 16:09	ratio_risk_reversal	2	1	100	683700.00	short	bid	7673.5200	1.6000	["7575","7680"]	["0.1436","0.1169"]	["7689.73"]	["XCBO"]	7575.0000	7680.0000	10	10	false	true	false
01a08665-6e50-78c3-93e7-70b0f3d386b7	SPX	2026-09-09 09:39	ratio_risk_reversal	2	1	200	292800.00	long	bid	7651.3400	1.2000	["7660","7850"]	["0.1278","0.1071"]	["7622.12"]	["XCBO"]	7660.0000	7850.0000	9	9	false	false	false
01a08665-6e50-78c3-93e7-70a93a5c99d3	SPX	2026-09-09 09:39	ratio_risk_reversal	2	1	200	292800.00	long	bid	7651.3400	1.2000	["7660","7850"]	["0.1278","0.1071"]	["7622.12"]	["XCBO"]	7660.0000	7850.0000	9	9	false	false	false
01a08665-6e50-78c3-93e7-709cfe0cf453	SPX	2026-09-09 09:39	ratio_risk_reversal	2	1	200	292800.00	long	bid	7651.3400	1.2000	["7660","7850"]	["0.1278","0.1071"]	["7622.12"]	["XCBO"]	7660.0000	7850.0000	9	9	false	false	false
01a08692-b810-78b3-b9b0-0dba98b389e8	SPX	2026-09-09 10:29	ratio_risk_reversal	2	1	30	177740.00	short	ask	7653.7400	1.0000	["7650","7700"]	["0.1390","0.1125"]	["7714.29"]	["XCBO"]	7650.0000	7700.0000	9	9	false	true	false
01a086b5-7a81-7050-990f-5b0f66f051c1	SPX	2026-09-09 11:07	ratio_risk_reversal	2	1	100	168400.00	long	bid	7640.8900	1.1000	["7650","7800"]	["0.1296","0.1107"]	["7800.46"]	["XCBO"]	7650.0000	7800.0000	9	9	false	false	false
01a086b8-1678-7662-af94-e0c0036aa512	SPX	2026-09-09 11:10	ratio_risk_reversal	2	3	1500	9187600.00	long	bid	7636.3300	0.9000	["7525","7850"]	["0.1433","0.1072"]	["7481.85"]	["XCBO"]	7525.0000	7850.0000	21	21	false	true	false
01a086cf-9230-7a40-b347-71e5958fa2d3	SPX	2026-09-09 11:35	ratio_risk_reversal	2	1	200	410000.00	short	bid	7635.5400	1.1000	["7400","7635"]	["0.1820","0.1298"]	["7392.70"]	["XCBO"]	7400.0000	7635.0000	9	9	false	false	false
01a086d9-6da0-7f51-8f2d-5b19e1a57350	SPX	2026-09-09 11:46	ratio_risk_reversal	2	1	40	86040.00	long	ask	7635.2800	0.9000	["7400","7640"]	["0.1803","0.1312"]	["7394.49"]	["XCBO"]	7400.0000	7640.0000	9	9	false	true	false
01a086e7-0231-7781-aeb6-02468f26d664	SPX	2026-09-09 12:01	ratio_risk_reversal	2	1	80	147120.00	long	ask	7635.7100	0.8000	["7400","7640"]	["0.1808","0.1308"]	["7391.21"]	["XCBO"]	7400.0000	7640.0000	9	9	false	true	false
01a08726-2258-7ca0-a08a-8316b61e559d	SPX	2026-09-09 13:10	ratio_risk_reversal	2	1	108	400848.00	long	ask	7640.4800	0.4000	["7380","7645"]	["0.1843","0.1263"]	["7685.85"]	["XCBO"]	7380.0000	7645.0000	7	7	false	true	false
01a087a7-c5d8-7591-9ea2-2fafb7c0ffd5	SPX	2026-09-09 15:31	ratio_risk_reversal	2	1	80	586240.00	long	bid	7645.0000	0.9000	["7650","7700"]	["0.1286","0.1202"]	["7700.68"]	["XCBO"]	7650.0000	7700.0000	9	9	false	false	false
01a08b8b-1e70-7920-bca6-7a5380853767	SPX	2026-09-10 09:39	ratio_risk_reversal	2	1	100	322400.00	short	bid	7595.0800	1.0000	["7400","7600"]	["0.1943","0.1456"]	["7391.52"]	["XCBO"]	7400.0000	7600.0000	8	8	false	true	false
01a08b8b-1e70-7920-bca6-7a73c1e92fe8	SPX	2026-09-10 09:39	ratio_risk_reversal	2	1	100	322400.00	short	bid	7595.0800	1.0000	["7400","7600"]	["0.1943","0.1456"]	["7391.52"]	["XCBO"]	7400.0000	7600.0000	8	8	false	true	false
01a08b96-8468-7120-8311-f5eefeee0d2a	SPX	2026-09-10 09:51	ratio_risk_reversal	2	1	25	89700.00	long	bid	7590.2900	1.3000	["7605","7700"]	["0.1414","0.1340"]	["7708.80"]	["XCBO"]	7605.0000	7700.0000	8	8	false	false	false
01a08b99-bca0-7f51-98c1-30a82d5f98a3	SPX	2026-09-10 09:55	ratio_risk_reversal	2	1	60	101680.00	long	ask	7586.2400	1.0000	["7300","7600"]	["0.2165","0.1509"]	["7291.59"]	["XCBO"]	7300.0000	7600.0000	8	8	false	true	false
01a08bc3-2e00-7b63-affb-ab3f0959c838	SPX	2026-09-10 10:40	ratio_risk_reversal	2	2	190	2478120.00	long	ask	7605.3200	2.2000	["7560","7610"]	["0.1473","0.1364"]	["7537.47"]	["XCBO"]	7560.0000	7610.0000	20	20	false	true	false
01a08bc4-33b9-70a1-9ae3-24dd653ca664	SPX	2026-09-10 10:41	ratio_risk_reversal	2	1	50	314580.00	short	bid	7605.8900	1.0000	["7600","7610"]	["0.1476","0.1420"]	["7542.28"]	["XCBO"]	7600.0000	7610.0000	8	8	false	true	false
01a08bc4-33b9-70a1-9ae3-24ce65e9b95a	SPX	2026-09-10 10:41	ratio_risk_reversal	2	1	100	622670.00	short	bid	7605.8900	1.0000	["7600","7610"]	["0.1476","0.1420"]	["7541.63"]	["XCBO"]	7600.0000	7610.0000	8	8	false	true	false
01a08c0c-aa80-71f3-9557-b300f841fc2b	SPX	2026-09-10 12:00	ratio_risk_reversal	2	1	40	233180.00	short	ask	7599.7200	1.3000	["7605","7700"]	["0.1471","0.1271"]	["7579.99"]	["XCBO"]	7605.0000	7700.0000	8	8	false	false	false
01a08c0e-f471-73a2-9e56-b4dfa0917c77	SPX	2026-09-10 12:03	ratio_risk_reversal	2	1	20	70100.00	long	bid	7599.8500	1.0000	["7600","7700"]	["0.1472","0.1275"]	["7709.85"]	["XCBO"]	7600.0000	7700.0000	8	8	false	false	false
01a08c43-e720-7092-95c1-506bb3b2c6ef	SPX	2026-09-10 13:00	ratio_risk_reversal	2	1	96	192360.00	short	bid	7605.1400	0.9000	["6825","7925"]	["0.2462","0.1085"]	["7934.34"]	["XCBO"]	6825.0000	7925.0000	32	32	false	true	false
01a08c43-e720-7092-95c1-505b0b4c0396	SPX	2026-09-10 13:00	ratio_risk_reversal	2	2	384	769440.00	short	bid	7605.1400	0.9000	["6825","7925"]	["0.2462","0.1085"]	["7934.34"]	["XCBO"]	6825.0000	7925.0000	32	32	true	true	false
01a08c58-51b0-7f82-a66f-3b84ae5befeb	SPX	2026-09-10 13:23	ratio_risk_reversal	2	1	50	455900.00	long	ask	7601.5700	1.1000	["7600","7610"]	["0.1439","0.1437"]	["7569.78"]	["XCBO"]	7600.0000	7610.0000	8	8	false	true	false
01a08c8a-d748-7e63-bfb2-15b9ede8d8c2	SPX	2026-09-10 14:18	ratio_risk_reversal	2	1	100	177000.00	long	ask	7589.0300	0.8000	["7300","7600"]	["0.2114","0.1467"]	["7295"]	["XCBO"]	7300.0000	7600.0000	8	8	false	true	false
01a08c8c-a438-78b0-ab51-255871e9cd1e	SPX	2026-09-10 14:20	ratio_risk_reversal	2	4	1250	14315000.00	short	bid	7591.5900	0.8000	["7200","7800"]	["0.1940","0.1285"]	["7839.88"]	["XCBO"]	7200.0000	7800.0000	50	50	false	true	false
01a08c95-9931-7eb0-963c-be27ef9514f9	SPX	2026-09-10 14:30	ratio_risk_reversal	2	1	50	68940.00	long	ask	7589.1500	0.9000	["7300","7600"]	["0.2106","0.1504"]	["7291.43"]	["XCBO"]	7300.0000	7600.0000	8	8	false	true	false
01a08cac-da50-7c73-9101-e288478c268a	SPX	2026-09-10 14:55	ratio_risk_reversal	2	1	65	191900.00	long	bid	7592.7400	1.3000	["7595","7700"]	["0.1450","0.1279"]	["7712.08"]	["XCBO"]	7595.0000	7700.0000	8	8	false	false	false
01a08cd8-6e90-7601-9b66-c2413d4b9f7e	SPX	2026-09-10 15:43	ratio_risk_reversal	2	1	25	35875.00	short	bid	7594.5600	0.8000	["7300","7600"]	["0.2161","0.1450"]	["7290.89"]	["XCBO"]	7300.0000	7600.0000	8	8	false	true	false
01a08ced-a829-7640-b0e9-29d8b9ef93da	SPX	2026-09-10 16:06	ratio_risk_reversal	2	2	36	395400.00	short	bid	7591.7000	1.0000	["7150","7675"]	["0.2086","0.1349"]	["7741.17"]	["XCBO"]	7150.0000	7675.0000	29	29	false	true	false
01a090d8-8a70-70c1-8739-26235eebaaa6	SPX	2026-09-11 10:21	ratio_risk_reversal	2	1	12	67056.00	short	ask	7671.0500	1.1000	["7665","7700"]	["0.1239","0.1109"]	["7716.88"]	["XCBO"]	7665.0000	7700.0000	7	7	false	true	false