core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a0ca96-772e-7d83-9b70-1711ce9106e7 | BX | 2026-09-22 15:27 | put_diagonal_spread | 2 | 1 | 40 | 221440.00 | long | ask | 124.5600 | 2.7125 | ["145","150"] | ["0.4226","0.4447"] | [] | ["XISX"] | 145.0000 | 150.0000 | 87 | 268 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:28:04Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca85-fc6f-7cc2-971e-c82be3635851 | BX | 2026-09-22 15:09 | put_diagonal_spread | 2 | 1 | 30 | 144180.00 | short | bid | 124.7800 | 3.0000 | ["125","130"] | ["0.4433","0.4293"] | [] | ["XISX"] | 125.0000 | 130.0000 | 486 | 850 | false | false | true | true | false | ||||||||
| 01a0c969-d256-7e41-a245-0156dc9fbb2f | BX | 2026-09-22 09:59 | put_calendar | 2 | 1 | 55 | 152735.00 | short | bid | 125.3900 | 3.9500 | ["139"] | ["0.4384"] | [] | ["XCBO"] | 139.0000 | 139.0000 | 10 | 38 | false | false | true | false | false | mlat | |||||||
| 01a0b0b0-463b-7e80-bd52-67bdd28aca19 | BX | 2026-09-17 14:45 | other | 4 | 1 | 1158 | 3826816.00 | unknown | — | 125.8100 | 7.3000 | ["140","145","150","160"] | ["1.3581","2.2073","3.1613","3.8869"] | [] | ["XBOX"] | 140.0000 | 160.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0af-b5b3-71f1-86d5-9421c0953277 | BX | 2026-09-17 14:44 | other | 4 | 1 | 150 | 633300.00 | unknown | — | 125.7900 | 8.7500 | ["140","150","160","165"] | ["1.3369","3.1510","3.8752","4.2053"] | [] | ["XBOX"] | 140.0000 | 165.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0a1-61bb-7c13-9515-84d6fd414813 | BX | 2026-09-17 14:29 | put_ladder | 5 | 1 | 1966 | 6426780.00 | unknown | — | 126.2000 | 11.1500 | ["140","145","147","170","175"] | ["1.6291","2.4399","3.1039","4.7683","5.0756"] | [] | ["XBOX"] | 140.0000 | 175.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b07a-a3c3-7182-b252-c1fd7dbe9216 | BX | 2026-09-17 13:47 | other | 3 | 1 | 50 | 193600.00 | unknown | — | 125.8650 | 1.1500 | ["125"] | ["0.4012"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 92 | 456 | false | false | true | false | true | mlat | |||||||
| 01a0abc6-a51b-7222-ba57-1acac279a5d4 | BX | 2026-09-16 15:51 | call_diagonal_spread | 2 | 1 | 350 | 238000.00 | unknown | — | 123.6500 | 0.7800 | ["140","155"] | ["0.3590","0.3815"] | [] | ["AMXO"] | 140.0000 | 155.0000 | 93 | 121 | false | true | true | true | false | mlct | |||||||
| 01a0a163-4448-7122-b6fd-dac3e8b3eaa5 | BX | 2026-09-14 15:27 | other | 2 | 1 | 325 | 116400.00 | unknown | — | 128.2000 | 0.2800 | ["125"] | ["0.4285"] | [] | ["AMXO"] | 125.0000 | 125.0000 | 4 | 32 | false | true | true | false | false | mlft | |||||||
| 01a0a0bf-5f40-7d32-b9c8-d45aad267570 | BX | 2026-09-14 12:28 | put_calendar | 2 | 1 | 105 | 225120.00 | long | bid | 128.7200 | 1.6000 | ["139"] | ["0.4227"] | [] | ["BATO"] | 139.0000 | 139.0000 | 4 | 18 | false | false | true | false | false | mlet | |||||||
| 01a0a084-cf11-72f2-a4c7-d875ae79fee4 | BX | 2026-09-14 11:24 | call_calendar | 2 | 1 | 448 | 137984.00 | long | bid | 128.3800 | 0.3350 | ["150"] | ["0.5083"] | [] | ["XBOX"] | 150.0000 | 150.0000 | 4 | 95 | false | true | true | false | false | mlft | |||||||
| 01a08cb3-42f0-7c30-ba40-42f8d710163d | BX | 2026-09-10 15:02 | other | 4 | 1 | 308 | 1685640.00 | unknown | — | 125.3550 | 4.2000 | ["140","141","155","160"] | ["1.3274","1.3937","0.9168","1.0221"] | [] | ["XBOX"] | 140.0000 | 160.0000 | 1 | 8 | false | false | true | true | false | mlft | |||||||
| 01a08bf4-5fc0-7b51-a382-ba47107e1baf | BX | 2026-09-10 11:34 | call_calendar | 2 | 1 | 95 | 166535.00 | short | bid | 127.2700 | 1.9000 | ["150"] | ["0.3514"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 127 | 463 | false | true | true | false | false | mlat | |||||||
| 01a08ba4-e800-7913-b305-631cbc57dc4f | BX | 2026-09-10 10:07 | put_calendar | 2 | 1 | 146 | 460922.00 | short | bid | 125.5000 | 4.3500 | ["141"] | ["0.8362"] | [] | ["ARCO"] | 141.0000 | 141.0000 | 1 | 29 | false | false | true | false | false | mlet | |||||||
| 01a0879d-6d69-7fa1-b504-92d726b532be | BX | 2026-09-09 15:20 | synthetic | 2 | 1 | 300 | 1314000.00 | long | ask | 129.1000 | 6.0500 | ["130"] | ["0.3737"] | ["131.00"] | ["AMXO"] | 130.0000 | 130.0000 | 499 | 499 | false | false | false | false | true | mlft | |||||||
| 01a0879d-5210-7231-bafc-8d1d129dec9c | BX | 2026-09-09 15:20 | synthetic | 2 | 1 | 60 | 262800.00 | long | ask | 129.1400 | 6.0500 | ["130"] | ["0.3736"] | ["131.00"] | ["AMXO"] | 130.0000 | 130.0000 | 499 | 499 | false | false | false | false | true | mlft | |||||||
| 01a08765-9871-7421-bf2a-597b694922c5 | BX | 2026-09-09 14:19 | put_vertical_spread | 2 | 1 | 270 | 273510.00 | long | ask | 129.2750 | 0.5500 | ["125","130"] | ["0.3742","0.3704"] | ["127.75"] | ["XCBO"] | 125.0000 | 130.0000 | 37 | 37 | false | false | false | true | false | ||||||||
| 01a0869d-6670-7fd0-8e19-e3addcfc643f | BX | 2026-09-09 10:40 | put_vertical_spread | 2 | 2 | 55 | 157593.00 | unknown | — | 129.7400 | 1.0500 | ["115","145"] | ["0.4127","0.4124"] | [] | ["ARCO","EDGO"] | 115.0000 | 145.0000 | 163 | 163 | false | false | false | true | false | mlet | |||||||
| 01a08296-da21-7552-8ad9-ec1ee72072d2 | BX | 2026-09-08 15:55 | put_diagonal_spread | 2 | 1 | 285 | 119415.00 | short | ask | 134.1300 | 0.5000 | ["130","135"] | ["0.3935","0.4191"] | [] | ["XCBO"] | 130.0000 | 135.0000 | 3 | 10 | false | false | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:09:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:59:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:45:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:45:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:29:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:47:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:51:59Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:27:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:28:54Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:24:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:02:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:34:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:07:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:21:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:20:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:20:05Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:41:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:55:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |