core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| directiontext |
|---|
| net_sidetext |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a0cf6e-ca9e-7811-9c4f-121867692d8b | SPX | 2026-09-23 14:02 | put_backspread | 2 | 1 | 12 | 274352.00 | long | ask | 7717.3100 | 1.6000 | ["7625","7825"] | ["0.1451","0.1302"] | ["7672.77"] | ["XCBO"] | 7625.0000 | 7825.0000 | 58 | 58 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T18:02:56Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cf6e-ab5f-7fa3-a8f6-898722f190c6 | SPX | 2026-09-23 14:02 | put_backspread | 2 | 1 | 24 | 548360.00 | long | ask | 7717.4700 | 2.0000 | ["7625","7825"] | ["0.1450","0.1302"] | ["7672.78"] | ["XCBO"] | 7625.0000 | 7825.0000 | 58 | 58 | false | false | |||||||||||
| 01a0cf6e-9bbf-7883-9080-7737d028863a | SPX | 2026-09-23 14:02 | put_backspread | 2 | 1 | 24 | 548016.00 | long | ask | 7718.0100 | 1.7000 | ["7625","7825"] | ["0.1452","0.1303"] | ["7672.90"] | ["XCBO"] | 7625.0000 | 7825.0000 | 58 | 58 | false | false | |||||||||||
| 01a0cf2f-9307-7a61-9291-73afcefa5d91 | SPX | 2026-09-23 12:53 | put_backspread | 2 | 1 | 3 | 48736.00 | long | ask | 7701.1600 | 1.7000 | ["7100","7290"] | ["0.1929","0.1771"] | ["7237.93"] | ["XCBO"] | 7100.0000 | 7290.0000 | 114 | 114 | false | true | |||||||||||
| 01a0cef5-02d6-72e0-a345-b79474c6a890 | SPX | 2026-09-23 11:49 | put_backspread | 2 | 1 | 6 | 29388.00 | long | ask | 7716.0300 | 1.4000 | ["7725","7745"] | ["0.1238","0.1218"] | ["7715.60"] | ["XCBO"] | 7725.0000 | 7745.0000 | 1 | 1 | false | false | |||||||||||
| 01a0cef4-b4b7-7051-b5cf-f0aa2d075cd8 | SPX | 2026-09-23 11:48 | put_backspread | 2 | 1 | 6 | 31599.00 | long | ask | 7718.2900 | 4.8000 | ["7730","7750"] | ["0.1271","0.1265"] | ["7717.45"] | ["XCBO"] | 7730.0000 | 7750.0000 | 1 | 1 | false | false | |||||||||||
| 01a0ced9-06c6-7740-810a-fa09e2ab8492 | SPX | 2026-09-23 11:18 | put_backspread | 2 | 1 | 6 | 29370.00 | long | ask | 7725.2200 | 1.5000 | ["7735","7755"] | ["0.1196","0.1178"] | ["7725.30"] | ["XCBO"] | 7735.0000 | 7755.0000 | 1 | 1 | false | false | |||||||||||
| 01a0cea9-7ecf-7dc2-a50e-e0812d833221 | SPX | 2026-09-23 10:26 | put_backspread | 2 | 1 | 2 | 30085.00 | long | ask | 7713.9600 | 7.7000 | ["7725","7855"] | ["0.1562","0.3421"] | ["7720.75"] | ["XCBO"] | 7725.0000 | 7855.0000 | 0 | 0 | false | false | |||||||||||
| 01a0ce98-44a7-7cf1-83c4-a11893109fa4 | SPX | 2026-09-23 10:07 | put_backspread | 2 | 1 | 2 | 32090.00 | long | ask | 7732.0500 | 7.2000 | ["7740","7885"] | ["0.1285","0.3528"] | ["7738.30"] | ["XCBO"] | 7740.0000 | 7885.0000 | 0 | 0 | false | false | |||||||||||
| 01a0ce85-e19f-7e62-8cb8-c9e614873798 | SPX | 2026-09-23 09:47 | put_backspread | 2 | 1 | 2 | 27816.00 | long | ask | 7743.6700 | 1.3000 | ["7750","7875"] | ["0.1282","0.3500"] | ["7749.60"] | ["XCBO"] | 7750.0000 | 7875.0000 | 0 | 0 | false | false | |||||||||||
| 01a0c95c-93b7-7440-b90a-71594c17f10a | SPX | 2026-09-22 09:44 | put_backspread | 2 | 1 | 3 | 40792.00 | long | ask | 7777.3400 | 0.8000 | ["7650","7700"] | ["0.1405","0.1357"] | ["7662.13"] | ["XCBO"] | 7650.0000 | 7700.0000 | 38 | 38 | false | true | |||||||||||
| 01a0c483-6586-7ab1-b785-dcc10c56c994 | SPX | 2026-09-21 11:08 | put_backspread | 2 | 1 | 54 | 702486.00 | long | ask | 7726.0200 | 1.2000 | ["7250","7600"] | ["0.1802","0.1462"] | ["7518.65"] | ["XCBO"] | 7250.0000 | 7600.0000 | 60 | 60 | false | true | |||||||||||
| 01a0c43f-2cae-73a1-9d5c-6e837f3a6f27 | SPX | 2026-09-21 09:54 | put_backspread | 2 | 1 | 2 | 42988.00 | long | ask | 7705.3400 | 1.3000 | ["7520","7550"] | ["0.1586","0.1563"] | ["7427"] | ["XCBO"] | 7520.0000 | 7550.0000 | 101 | 101 | false | true | |||||||||||
| 01a0c42f-271e-73b3-a1d2-84c1dd13a14b | SPX | 2026-09-21 09:36 | put_backspread | 2 | 2 | 395 | 752159.00 | long | ask | 7695.6500 | 0.3000 | ["7610","7670"] | ["0.1415","0.1198"] | ["7657.70"] | ["XCBO"] | 7610.0000 | 7670.0000 | 2 | 2 | false | true | |||||||||||
| 01a0b603-8a0f-73c0-b7e1-9f05ae88aa76 | SPX | 2026-09-18 15:34 | put_backspread | 2 | 1 | 4 | 41188.00 | long | ask | 7637.3300 | 1.0000 | ["5800","6800"] | ["0.2917","0.2122"] | ["6729.91"] | ["XCBO"] | 5800.0000 | 6800.0000 | 154 | 154 | true | true | |||||||||||
| 01a0b541-3027-7ca1-ba9d-ed22396ccb63 | SPX | 2026-09-18 12:02 | put_backspread | 2 | 1 | 6 | 29070.00 | long | ask | 7618.4300 | 1.5000 | ["7620","7645"] | ["0.0844","0.0835"] | ["7618.70"] | ["XCBO"] | 7620.0000 | 7645.0000 | 3 | 3 | false | false | |||||||||||
| 01a0b541-2c40-7b10-8845-add13d9e00fb | SPX | 2026-09-18 12:02 | put_backspread | 2 | 1 | 6 | 29040.00 | long | ask | 7618.3800 | 1.5000 | ["7620","7645"] | ["0.0843","0.0832"] | ["7618.80"] | ["XCBO"] | 7620.0000 | 7645.0000 | 3 | 3 | false | false | |||||||||||
| 01a0b4c7-3597-76e0-a127-6b3a50b2bf60 | SPX | 2026-09-18 09:49 | put_backspread | 2 | 1 | 20 | 55540.00 | long | ask | 7636.8400 | 0.4000 | ["7635","7655"] | ["0.1423","0.1401"] | ["7637.75"] | ["XCBO"] | 7635.0000 | 7655.0000 | 0 | 0 | false | false | |||||||||||
| 01a0ab44-78e3-7390-9078-cd1ffa311f9a | SPX | 2026-09-16 13:29 | put_backspread | 2 | 1 | 5 | 273000.00 | long | ask | 7609.9000 | 2.6000 | ["7990","8000"] | ["0.1308","0.1307"] | ["7610"] | ["XCBO"] | 7990.0000 | 8000.0000 | 93 | 93 | false | false | |||||||||||
| 01a0ab15-98e3-74c3-8933-da71c573199a | SPX | 2026-09-16 12:38 | put_backspread | 2 | 2 | 192 | 244992.00 | long | ask | 7610.0800 | 0.6000 | ["7400","7500"] | ["0.2472","0.2114"] | ["7490.90"] | ["XCBO"] | 7400.0000 | 7500.0000 | 2 | 2 | false | true | |||||||||||
| 01a0ab15-98e3-74c3-8933-da6be80a5d0e | SPX | 2026-09-16 12:38 | put_backspread | 2 | 3 | 208 | 264160.00 | long | ask | 7610.0800 | 0.5000 | ["7400","7500"] | ["0.2463","0.2112"] | ["7490.90"] | ["XCBO"] | 7400.0000 | 7500.0000 | 2 | 2 | false | true | |||||||||||
| 01a08bde-1c88-7c52-b49d-8a29290ce304 | SPX | 2026-09-10 11:09 | put_backspread | 2 | 1 | 62 | 535928.00 | long | ask | 7605.2000 | 0.9000 | ["7430","7640"] | ["0.1805","0.1359"] | ["7573.60"] | ["XCBO"] | 7430.0000 | 7640.0000 | 8 | 8 | false | false | |||||||||||
| 01a08145-4440-7e92-acae-6fa7ac1a79f9 | SPX | 2026-09-08 09:46 | put_backspread | 2 | 1 | 1290 | 98810.00 | long | ask | 7691.7200 | 0.1500 | ["7415","7515"] | ["0.2931","0.2137"] | ["7514.63"] | ["XCBO"] | 7415.0000 | 7515.0000 | 1 | 1 | false | true | |||||||||||
| 01a06d53-5b5d-7101-8387-9105dc62f750 | SPX | 2026-09-04 12:49 | put_backspread | 2 | 1 | 12 | 303412.00 | long | ask | 7727.9000 | 1.5000 | ["7565","7605"] | ["0.1541","0.1513"] | ["7508.43"] | ["XCBO"] | 7565.0000 | 7605.0000 | 105 | 105 | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:02:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:02:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:53:46Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:49:44Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:49:14Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:18:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:27:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:08:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:48:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:44:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:09:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:54:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:37:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:34:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:02:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:02:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:49:14Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:30:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:39:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:39:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:09:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:46:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |