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×net_side = ask×strategy = ratio_risk_reversal×

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

01a0d508-917f-7b42-b293-3d39c6ffcb86	SPX	2026-09-24 16:08	ratio_risk_reversal	2	1	50	1226400.00	unknown	ask	7704.1300	1.9000	["7760","7800"]	["0.1317","0.1417"]	["7603.92"]	["XCBO"]	7760.0000	7800.0000	85	85	false	false	false	true	true	cbmo	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-24T20:08:57Z"}	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
01a0d3f0-37f7-75b1-84dc-20406d510a49	SPX	2026-09-24 11:02	ratio_risk_reversal	2	1	200	503500.00	short	ask	7674.4600	0.5000	["7575","7800"]	["0.1444","0.1129"]	["7574.81"]	["XCBO"]	7575.0000	7800.0000	8	8	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
01a0cf47-1a77-7d92-aa91-98ffddca9395	SPX	2026-09-23 13:18	ratio_risk_reversal	2	1	255	243500.00	short	ask	7705.0300	0.2000	["7575","7850"]	["0.1372","0.0956"]	["7572.07"]	["XCBO"]	7575.0000	7850.0000	7	7	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
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
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
01a0caa0-5e57-72e1-97e3-d56cc19e046d	SPX	2026-09-22 15:38	ratio_risk_reversal	2	1	50	1815500.00	unknown	ask	7777.8800	1.2000	["7845","7900"]	["0.1372","0.1277"]	["7458.72","8263.10"]	["XCBO"]	7845.0000	7900.0000	87	87	false	false	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
01a0c9a5-7fae-7581-bc9c-24390df7bf67	SPX	2026-09-22 11:04	ratio_risk_reversal	2	1	20	285300.00	unknown	ask	7765.8100	1.4000	["7350","7835"]	["0.1745","0.1307"]	["7207.35","8310.50"]	["XCBO"]	7350.0000	7835.0000	87	87	false	true	false
01a0c9a5-7fae-7581-bc9c-242c799d244b	SPX	2026-09-22 11:04	ratio_risk_reversal	2	1	20	285300.00	unknown	ask	7765.8100	1.4000	["7350","7835"]	["0.1745","0.1307"]	["7207.35","8310.50"]	["XCBO"]	7350.0000	7835.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
01a0c971-d136-7a21-a2c1-f87e1a5a6dab	SPX	2026-09-22 10:07	ratio_risk_reversal	2	1	200	3563000.00	unknown	ask	7771.1700	1.5000	["7300","7835"]	["0.1799","0.1310"]	["7121.85","8191.30"]	["XCBO"]	7300.0000	7835.0000	87	87	false	true	false
01a0c971-d136-7a21-a2c1-f86a0bb93beb	SPX	2026-09-22 10:07	ratio_risk_reversal	2	1	50	890750.00	unknown	ask	7771.1700	1.5000	["7300","7835"]	["0.1799","0.1310"]	["7121.85","8191.30"]	["XCBO"]	7300.0000	7835.0000	87	87	false	true	false
01a0c968-c4cf-7ca3-a5ba-237a46327ea9	SPX	2026-09-22 09:57	ratio_risk_reversal	2	1	50	542000.00	unknown	ask	7770.6700	1.5000	["7300","7845"]	["0.1802","0.1328"]	["7191.60","8522.50"]	["XCBO"]	7300.0000	7845.0000	87	87	false	true	false
01a0c529-9c4f-7c43-b334-41c0e33f2545	SPX	2026-09-21 14:10	ratio_risk_reversal	2	1	300	931500.00	short	ask	7763.1500	0.6000	["7650","7900"]	["0.1229","0.0983"]	["7903.35"]	["XCBO"]	7650.0000	7900.0000	14	14	false	true	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
01a0c4de-b487-73e2-b2ff-301fe430e8cf	SPX	2026-09-21 12:48	ratio_risk_reversal	2	1	100	241250.00	short	ask	7751.9800	0.6000	["7660","7860"]	["0.1189","0.0972"]	["7647.12"]	["XCBO"]	7660.0000	7860.0000	8	8	false	true	false
01a0c494-41ef-7972-9429-950c2e851afd	SPX	2026-09-21 11:27	ratio_risk_reversal	2	1	50	1215460.00	unknown	ask	7730.1500	1.4000	["7800","7900"]	["0.1392","0.1276"]	["7247.52","8143.09"]	["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
01a0b616-d38f-76e1-9f5a-fbc3254f23c9	SPX	2026-09-18 15:55	ratio_risk_reversal	2	1	200	214000.00	short	ask	7648.5000	0.4000	["7400","7800"]	["0.1505","0.0803"]	["7800.50"]	["XCBO"]	7400.0000	7800.0000	12	12	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
01a0b5aa-7560-74c1-bf86-bfc097976c7f	SPX	2026-09-18 13:57	ratio_risk_reversal	2	2	600	313500.00	short	ask	7628.4700	0.2000	["7550","7700"]	["0.1094","0.0709"]	["7701.18"]	["XCBO"]	7550.0000	7700.0000	4	4	false	true	false
01a0b57a-8007-7690-8f96-b6d9f127d1d7	SPX	2026-09-18 13:04	ratio_risk_reversal	2	1	100	1747000.00	short	ask	7624.1300	1.6000	["7690","7900"]	["0.1439","0.1224"]	["7939.66"]	["XCBO"]	7690.0000	7900.0000	91	91	false	false	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
01a0b541-8618-7751-abcf-98ae6ec1989b	SPX	2026-09-18 12:02	ratio_risk_reversal	2	2	500	1646250.00	short	ask	7619.3400	0.6000	["7520","7720"]	["0.1267","0.0872"]	["7501.32"]	["XCBO"]	7520.0000	7720.0000	11	11	true	true	false
01a0b53b-f44f-7570-a8dc-30ce89374a36	SPX	2026-09-18 11:56	ratio_risk_reversal	2	1	150	400000.00	unknown	ask	7621.7700	0.4000	["7525","7700"]	["0.1303","0.0924"]	["7498.33","7740.00"]	["XCBO"]	7525.0000	7700.0000	7	7	false	true	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
01a0abc5-c674-74f3-b410-34dc47d60fcb	SPX	2026-09-16 15:50	ratio_risk_reversal	2	1	300	3011400.00	short	ask	7548.5700	2.1000	["7600","7900"]	["0.1552","0.1241"]	["7973.86"]	["XCBO"]	7600.0000	7900.0000	93	93	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
01a0aae1-9863-72e3-865c-62a1a8126944	SPX	2026-09-16 11:41	ratio_risk_reversal	2	2	250	934700.00	short	ask	7615.7000	0.4800	["7500","7750"]	["0.1655","0.1169"]	["7473.95"]	["XCBO"]	7500.0000	7750.0000	9	9	false	true	false
01a0aada-ba92-76e0-a4a3-5df122b48be1	SPX	2026-09-16 11:34	ratio_risk_reversal	2	2	500	1228000.00	short	ask	7611.7200	0.5000	["7450","7800"]	["0.1646","0.1064"]	["7443.60"]	["XCBO"]	7450.0000	7800.0000	14	14	false	true	false
01a0aac0-0a8b-70d0-9994-50cb52dae22d	SPX	2026-09-16 11:05	ratio_risk_reversal	2	1	40	1099720.00	short	ask	7616.1200	1.8000	["7680","7700"]	["0.1474","0.1375"]	["7844.73"]	["XCBO"]	7680.0000	7700.0000	93	93	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
01a0a0c3-52f8-7433-b9bc-92e3e644d1c3	SPX	2026-09-14 12:32	ratio_risk_reversal	2	1	1000	10114000.00	short	ask	7635.5700	1.6000	["7705","8000"]	["0.1473","0.1225"]	["8070.06"]	["XCBO"]	7705.0000	8000.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
01a0a029-d218-79e3-b194-12c26e4a2f8d	SPX	2026-09-14 09:44	ratio_risk_reversal	2	3	212	435437.00	short	ask	7607.4500	0.4000	["7450","7700"]	["0.2264","0.1365"]	["7446.73"]	["XCBO"]	7450.0000	7700.0000	3	3	false	true	false
01a09219-e7f8-7ef0-831b-937be8de3aa4	SPX	2026-09-11 16:12	ratio_risk_reversal	2	1	150	2594050.00	short	ask	7656.9800	1.1000	["7300","8000"]	["0.1790","0.1219"]	["7252.92"]	["XCBO"]	7300.0000	8000.0000	98	98	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
01a09138-1760-7ec0-9688-b347a26897a8	SPX	2026-09-11 12:06	ratio_risk_reversal	2	1	100	221600.00	short	ask	7675.1400	0.9000	["7675","7750"]	["0.1177","0.1009"]	["7761.82"]	["XCBO"]	7675.0000	7750.0000	7	7	false	true	false