Multi-leg option trades

core.multileg_trades

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

473,794 rowsCSV — whole table, not this view

Sources in this table

uw_multileg473,794 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:code = cbmo×direction = long×strategy = ratio_risk_reversal×

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

01a0d47f-6c1f-7612-aaaa-26a67d1b1101	SPX	2026-09-24 13:38	ratio_risk_reversal	2	1	120	2776770.00	long	bid	7697.0200	1.7000	["7765","7875"]	["0.1425","0.1296"]	["7937.10"]	["XCBO"]	7765.0000	7875.0000	85	85	false	false	false	true	true	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-24T17:38:50Z"}	2026-09-24	2026-09-24 17:15	2026-09-24 17:15
01a0d466-2376-7f21-b598-bcf684340c04	SPX	2026-09-24 13:10	ratio_risk_reversal	2	1	175	1092330.00	long	ask	7708.5100	1.0000	["7350","7800"]	["0.1696","0.1173"]	["7818.74"]	["XCBO"]	7350.0000	7800.0000	29	29	false	true	false
01a0d3c2-9076-70f3-bfe8-d606675752a7	SPX	2026-09-24 10:12	ratio_risk_reversal	2	1	150	1353000.00	long	ask	7689.5400	1.3000	["6900","7750"]	["0.2161","0.1356"]	["6893"]	["XCBO"]	6900.0000	7750.0000	85	85	false	true	false
01a0cf36-3256-7810-95b6-4bb02c5c4f4b	SPX	2026-09-23 13:00	ratio_risk_reversal	2	1	100	1628730.00	long	ask	7705.3300	1.4000	["7300","7775"]	["0.1762","0.1332"]	["7294.45"]	["XCBO"]	7300.0000	7775.0000	86	86	false	true	false
01a0cf34-22ff-7de1-a6c1-75f40f9ab66c	SPX	2026-09-23 12:58	ratio_risk_reversal	2	1	60	586100.00	long	ask	7701.0500	1.3000	["7100","7765"]	["0.1964","0.1333"]	["7070.48"]	["XCBO"]	7100.0000	7765.0000	86	86	false	true	false
01a0ceff-66ff-7c12-969b-bcfcb8315f70	SPX	2026-09-23 12:00	ratio_risk_reversal	2	2	100	1431000.00	long	bid	7714.9200	1.0000	["7425","8125"]	["0.1660","0.1182"]	["8131.42"]	["XCBO"]	7425.0000	8125.0000	99	99	false	true	false
01a0ceb3-ac47-7951-b3d9-3c799ade41b2	SPX	2026-09-23 10:37	ratio_risk_reversal	2	1	70	1084100.00	long	bid	7725.7600	1.8000	["7800","8000"]	["0.1343","0.1244"]	["8057.73"]	["XCBO"]	7800.0000	8000.0000	86	86	false	false	false
01a0ceb3-ac47-7951-b3d9-3c61477755cd	SPX	2026-09-23 10:37	ratio_risk_reversal	2	1	70	1064100.00	long	bid	7725.7600	1.8000	["7800","8000"]	["0.1343","0.1244"]	["8060.59"]	["XCBO"]	7800.0000	8000.0000	86	86	false	false	false
01a0cea2-db97-78c3-bd69-b29c76891a57	SPX	2026-09-23 10:19	ratio_risk_reversal	2	1	20	58510.00	long	ask	7721.0900	1.3000	["6200","7790"]	["0.2843","0.1338"]	["6191.10"]	["XCBO"]	6200.0000	7790.0000	86	86	false	true	false
01a0cea2-db97-78c3-bd69-b28ab76e879d	SPX	2026-09-23 10:19	ratio_risk_reversal	2	1	40	117020.00	long	ask	7721.0900	1.3000	["6200","7790"]	["0.2843","0.1338"]	["6191.10"]	["XCBO"]	6200.0000	7790.0000	86	86	false	true	false
01a0ce90-5567-7a52-b9de-95556acd0588	SPX	2026-09-23 09:59	ratio_risk_reversal	2	1	300	1914500.00	long	bid	7738.1600	0.7000	["7500","8000"]	["0.1499","0.1106"]	["7499.22"]	["XCBO"]	7500.0000	8000.0000	37	37	false	true	false
01a0cab1-3ea7-7a73-a649-65266bb473e7	SPX	2026-09-22 15:56	ratio_risk_reversal	2	1	77	573720.00	long	ask	7767.0400	1.1000	["7350","7875"]	["0.1655","0.1086"]	["7915.60"]	["XCBO"]	7350.0000	7875.0000	30	30	true	true	false
01a0caaf-17df-73b3-89fd-48e911687a1b	SPX	2026-09-22 15:54	ratio_risk_reversal	2	1	73	1518945.00	long	ask	7774.7600	1.7000	["5775","7845"]	["0.3287","0.1308"]	["8040.33"]	["XCBO"]	5775.0000	7845.0000	87	87	false	true	false
01a0c9e1-4476-7603-8e4d-e7f61ac9c8b7	SPX	2026-09-22 12:09	ratio_risk_reversal	2	1	50	70650.00	long	ask	7764.2700	1.1000	["5600","7825"]	["0.3486","0.1305"]	["5594.09"]	["XCBO"]	5600.0000	7825.0000	87	87	false	true	false
01a0c9a0-c4bf-79f0-b60f-f2304be6871f	SPX	2026-09-22 10:59	ratio_risk_reversal	2	1	100	819300.00	long	ask	7764.4500	1.4000	["7250","7830"]	["0.1831","0.1310"]	["7192.55"]	["XCBO"]	7250.0000	7830.0000	87	87	false	true	false
01a0c9a0-c4bf-79f0-b60f-f22d34909398	SPX	2026-09-22 10:59	ratio_risk_reversal	2	1	50	409650.00	long	ask	7764.4500	1.4000	["7250","7830"]	["0.1831","0.1310"]	["7192.55"]	["XCBO"]	7250.0000	7830.0000	87	87	false	true	false
01a0c95d-3bae-7061-82c3-cddda3ac63ca	SPX	2026-09-22 09:45	ratio_risk_reversal	2	4	2500	3744000.00	long	bid	7773.2900	0.3500	["7760","7925"]	["0.0939","0.1013"]	["7739.76"]	["XCBO"]	7760.0000	7925.0000	6	6	false	true	false
01a0c58f-4b8f-7771-8373-bbc1674681be	SPX	2026-09-21 16:01	ratio_risk_reversal	2	1	100	1280800.00	long	bid	7764.8000	1.8000	["7835","8250"]	["0.1380","0.1191"]	["7760.05"]	["XCBO"]	7835.0000	8250.0000	88	88	false	false	false
01a0c4df-d1ae-7571-86ab-43af116e5216	SPX	2026-09-21 12:49	ratio_risk_reversal	2	1	50	199500.00	long	ask	7752.3200	1.4000	["6500","7820"]	["0.2568","0.1331"]	["6484.94"]	["XCBO"]	6500.0000	7820.0000	88	88	false	true	false
01a0c497-a137-7e72-a820-cb9f043771e6	SPX	2026-09-21 11:31	ratio_risk_reversal	2	1	100	2410240.00	long	bid	7729.5600	1.4000	["7800","7900"]	["0.1390","0.1278"]	["7963.18"]	["XCBO"]	7800.0000	7900.0000	88	88	false	false	false
01a0c449-c787-7893-b6b5-0655fcfbc990	SPX	2026-09-21 10:06	ratio_risk_reversal	2	1	200	1916536.00	long	ask	7702.7200	1.4000	["7305","7770"]	["0.1759","0.1336"]	["7225.69"]	["XCBO"]	7305.0000	7770.0000	88	88	false	true	false
01a0b619-c18f-7691-9d20-94313b2c8bb0	SPX	2026-09-18 15:58	ratio_risk_reversal	2	1	40	539490.00	long	bid	7646.1900	1.7000	["7710","8000"]	["0.1406","0.1177"]	["8021.85"]	["XCBO"]	7710.0000	8000.0000	91	91	false	false	false
01a0b5ff-e08f-7da0-a263-74c974d393b5	SPX	2026-09-18 15:30	ratio_risk_reversal	2	2	70	602150.00	long	bid	7638.1900	0.9000	["7550","7750"]	["0.1322","0.1054"]	["7764.72"]	["XCBO"]	7550.0000	7750.0000	27	27	false	true	false
01a0b5ea-ce07-7610-bc0c-63aa749246aa	SPX	2026-09-18 15:07	ratio_risk_reversal	2	1	150	643500.00	long	ask	7641.4500	0.7000	["7450","7750"]	["0.1428","0.0986"]	["7775.50"]	["XCBO"]	7450.0000	7750.0000	20	20	false	true	false
01a0b55f-9567-7322-9a33-61c6943badbf	SPX	2026-09-18 12:35	ratio_risk_reversal	2	1	196	4223828.00	long	ask	7621.4900	1.6000	["7680","7685"]	["0.1443","0.1341"]	["7479.64"]	["XCBO"]	7680.0000	7685.0000	91	91	false	false	false
01a0b4cd-251f-74f3-8b0b-958c8712bfad	SPX	2026-09-18 09:55	ratio_risk_reversal	2	1	140	2418200.00	long	ask	7630.3400	1.4000	["7350","7705"]	["0.1704","0.1349"]	["7296.13"]	["XCBO"]	7350.0000	7705.0000	91	91	false	true	false
01a0b4bc-f497-7c21-b429-255502a0e2a0	SPX	2026-09-18 09:37	ratio_risk_reversal	2	1	200	1754200.00	long	ask	7641.3500	1.8000	["7100","7710"]	["0.1935","0.1340"]	["7037.49"]	["XCBO"]	7100.0000	7710.0000	91	91	false	true	false
01a0b0fa-b4eb-7a93-9bc2-1c086137621c	SPX	2026-09-17 16:06	ratio_risk_reversal	2	1	38	32249.00	long	ask	7637.7600	0.5000	["7070","7825"]	["0.2241","0.0922"]	["7828.47"]	["XCBO"]	7070.0000	7825.0000	13	13	false	true	false
01a0b0ed-e793-7e43-8e8d-f5bb7545fc4e	SPX	2026-09-17 15:52	ratio_risk_reversal	2	1	387	3195935.00	long	ask	7643.9600	1.6000	["6875","7710"]	["0.2146","0.1341"]	["6847.48"]	["XCBO"]	6875.0000	7710.0000	92	92	false	true	false
01a0afd4-49d3-70e2-b4ef-b4c2d873dfe7	SPX	2026-09-17 10:45	ratio_risk_reversal	2	1	100	131400.00	long	bid	7630.0200	1.2000	["7700","8500"]	["0.1427","0.1153"]	["8504.66"]	["XCBO"]	7700.0000	8500.0000	92	92	false	false	false
01a0af9b-82ab-7822-8f29-c1d3bff88542	SPX	2026-09-17 09:43	ratio_risk_reversal	2	1	750	7815500.00	long	bid	7621.4300	1.4000	["7695","8200"]	["0.1427","0.1159"]	["7580.62"]	["XCBO"]	7695.0000	8200.0000	92	92	false	false	false
01a0ab80-e98b-7e13-9eab-bfa960b3e2d0	SPX	2026-09-16 14:35	ratio_risk_reversal	2	1	80	949000.00	long	ask	7580.4700	2.8000	["7000","7650"]	["0.2049","0.1450"]	["6960.82"]	["XCBO"]	7000.0000	7650.0000	93	93	false	true	false
01a0ab51-3a83-7e53-9d6d-bbfb465ddcde	SPX	2026-09-16 13:43	ratio_risk_reversal	2	1	100	1802700.00	long	ask	7605.3300	1.6000	["7000","7680"]	["0.2059","0.1402"]	["7740.44"]	["XCBO"]	7000.0000	7680.0000	93	93	false	true	false
01a0ab51-3a83-7e53-9d6d-bbe0bd3678d5	SPX	2026-09-16 13:43	ratio_risk_reversal	2	1	100	1802700.00	long	ask	7605.3300	1.6000	["7000","7680"]	["0.2059","0.1402"]	["7740.44"]	["XCBO"]	7000.0000	7680.0000	93	93	false	true	false
01a0a69c-fc86-7760-8480-48562de41a1b	SPX	2026-09-15 15:48	ratio_risk_reversal	2	1	200	829000.00	long	bid	7579.8500	1.2000	["7650","8250"]	["0.1486","0.1168"]	["8255.93"]	["XCBO"]	7650.0000	8250.0000	94	94	false	false	false
01a0a69c-fc86-7760-8480-484fa46a7db2	SPX	2026-09-15 15:48	ratio_risk_reversal	2	1	100	414500.00	long	bid	7579.8500	1.2000	["7650","8250"]	["0.1486","0.1168"]	["8255.93"]	["XCBO"]	7650.0000	8250.0000	94	94	false	false	false
01a0a657-e8ee-7530-bf8a-e76e2ed00f70	SPX	2026-09-15 14:32	ratio_risk_reversal	2	2	500	2172500.00	long	bid	7584.1600	0.6000	["7500","7850"]	["0.1616","0.1084"]	["7458.25"]	["XCBO"]	7500.0000	7850.0000	10	10	false	true	false
01a0a5c7-1a9d-70c0-bc44-0c174487ad4d	SPX	2026-09-15 11:54	ratio_risk_reversal	2	2	500	1574000.00	long	bid	7582.6200	0.5000	["7350","7850"]	["0.1824","0.1057"]	["7324.68"]	["XCBO"]	7350.0000	7850.0000	15	15	false	true	false
01a0a58c-1d0e-7b70-ab79-edc96d409418	SPX	2026-09-15 10:50	ratio_risk_reversal	2	1	200	2541000.00	long	bid	7579.0600	1.4000	["7655","8000"]	["0.1487","0.1238"]	["8014.55"]	["XCBO"]	7655.0000	8000.0000	94	94	false	false	false
01a0a560-909e-7a01-8d61-a07fec7c2123	SPX	2026-09-15 10:02	ratio_risk_reversal	2	1	100	2247200.00	long	ask	7602.9200	1.7000	["7600","7675"]	["0.1524","0.1417"]	["7437.72"]	["XCBO"]	7600.0000	7675.0000	94	94	false	true	false
01a0a0e6-f411-7ee0-ba10-0648f88b809f	SPX	2026-09-14 13:11	ratio_risk_reversal	2	1	100	2695000.00	long	bid	7638.1900	1.5000	["7720","7900"]	["0.1439","0.1292"]	["7695.09"]	["XCBO"]	7720.0000	7900.0000	95	95	false	false	false
01a0a0e6-f411-7ee0-ba10-06388ba2542e	SPX	2026-09-14 13:11	ratio_risk_reversal	2	2	200	5390000.00	long	bid	7638.1900	1.5000	["7720","7900"]	["0.1439","0.1292"]	["7695.09"]	["XCBO"]	7720.0000	7900.0000	95	95	false	false	false
01a0a09b-d598-7bf0-b20f-4e4ea98311b3	SPX	2026-09-14 11:49	ratio_risk_reversal	2	1	50	945350.00	long	bid	7630.5400	1.5000	["7700","8050"]	["0.1464","0.1213"]	["7609.13"]	["XCBO"]	7700.0000	8050.0000	95	95	false	false	false
01a0a09b-d598-7bf0-b20f-4e308b2a110f	SPX	2026-09-14 11:49	ratio_risk_reversal	2	1	50	1243100.00	long	ask	7630.5400	1.9000	["7375","7700"]	["0.1726","0.1398"]	["7367.76"]	["XCBO"]	7375.0000	7700.0000	95	95	false	true	false
01a0a04f-f3d0-7791-a545-3f5cd3a5f69b	SPX	2026-09-14 10:26	ratio_risk_reversal	2	1	30	746700.00	long	bid	7597.0900	2.2000	["7680","7800"]	["0.1493","0.1353"]	["7864.10"]	["XCBO"]	7680.0000	7800.0000	95	95	false	false	false
01a09183-c278-73a1-ae86-1e233ea3159a	SPX	2026-09-11 13:28	ratio_risk_reversal	2	1	200	254400.00	long	bid	7673.3200	0.4000	["7460","7800"]	["0.1690","0.1003"]	["7454.30"]	["XCBO"]	7460.0000	7800.0000	7	7	false	true	false
01a09162-86a8-7011-b4f9-606c5c449354	SPX	2026-09-11 12:52	ratio_risk_reversal	2	1	100	449000.00	long	ask	7666.6500	0.9000	["7610","7670"]	["0.1292","0.1152"]	["7597.10"]	["XCBO"]	7610.0000	7670.0000	7	7	false	true	false
01a0913f-56d8-71e1-8510-cc068b16ac82	SPX	2026-09-11 12:13	ratio_risk_reversal	2	1	15	89940.00	long	bid	7669.2300	1.0000	["7675","7690"]	["0.1149","0.1122"]	["7711.00"]	["XCBO"]	7675.0000	7690.0000	7	7	false	false	false
01a0913f-56d8-71e1-8510-cbf6abfe7744	SPX	2026-09-11 12:13	ratio_risk_reversal	2	1	15	89940.00	long	bid	7669.2300	1.0000	["7675","7690"]	["0.1149","0.1122"]	["7711.00"]	["XCBO"]	7675.0000	7690.0000	7	7	false	false	false
01a0913f-56d8-71e1-8510-cbe67459113f	SPX	2026-09-11 12:13	ratio_risk_reversal	2	1	30	175010.00	long	bid	7669.2800	1.0000	["7675","7690"]	["0.1150","0.1122"]	["7712.62"]	["XCBO"]	7675.0000	7690.0000	7	7	false	false	false