core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0ee2c-1d7f-7001-8429-fdb1ead9a702 | SPGI | 2026-09-29 13:17 | put_vertical_spread | 2 | 1 | 100 | 121200.00 | long | ask | 389.5520 | 2.0000 | ["385","390"] | ["0.2800","0.2788"] | ["387.76"] | ["C2OX"] | 385.0000 | 390.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T17:18:30Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ed76-bfce-7883-8d0c-f03ebeb78b9f | SPGI | 2026-09-29 09:59 | put_vertical_spread | 2 | 1 | 29 | 137979.00 | long | ask | 390.6100 | 7.0000 | ["390","400"] | ["0.2851","0.2828"] | ["395.00"] | ["C2OX"] | 390.0000 | 400.0000 | 108 | 108 | false | false | false | true | |||||||||
| 01a0e875-e176-7010-8ddc-c749a0f1d346 | SPGI | 2026-09-28 10:40 | other | 3 | 3 | 40 | 116100.00 | unknown | ask | 399.7700 | 12.8000 | ["375","410","415"] | ["0.3288","0.2984","0.3094"] | ["367.10"] | ["ARCO","XISX","XPHO"] | 375.0000 | 415.0000 | 39 | 39 | true | true | false | true | |||||||||
| 01a0d422-82f7-72c1-a7d0-cd2434cedd83 | SPGI | 2026-09-24 11:57 | risk_reversal | 2 | 1 | 300 | 3292500.00 | long | bid | 401.6500 | 8.7000 | ["440","450"] | ["0.3177","0.2900"] | ["420.31"] | ["AMXO"] | 440.0000 | 450.0000 | 484 | 484 | true | false | false | true | |||||||||
| 01a0b0ba-eccb-7d90-845e-1988861c8e73 | SPGI | 2026-09-17 14:57 | put_vertical_spread | 2 | 1 | 94 | 594080.00 | unknown | — | 405.6300 | 11.2500 | ["430","440"] | ["1.1591","1.4391"] | [] | ["XBOX"] | 430.0000 | 440.0000 | 1 | 1 | true | false | false | true | false | mlft | |||||||
| 01a0aac9-b71b-78a1-8e67-2865aaddc448 | SPGI | 2026-09-16 11:15 | other | 4 | 1 | 51 | 156621.00 | unknown | — | 411.6400 | 19.8000 | ["420","440","447.5","457.5"] | ["0.2860","0.2850","1.6688","1.9103"] | [] | ["AMXO"] | 420.0000 | 457.5000 | 2 | 30 | false | true | true | true | false | mlat | |||||||
| 01a0a6a4-e00f-72b3-8389-5510cf6cf769 | SPGI | 2026-09-15 15:56 | put_diagonal_spread | 2 | 1 | 65 | 344500.00 | short | bid | 411.6800 | 5.4000 | ["420","445"] | ["0.2956","0.2935"] | [] | ["XMIO"] | 420.0000 | 445.0000 | 24 | 38 | false | false | true | true | |||||||||
| 01a0a6a0-bd76-7a81-819b-251199465d25 | SPGI | 2026-09-15 15:52 | put_diagonal_spread | 2 | 1 | 55 | 270820.00 | long | ask | 412.3000 | 7.2000 | ["420","445"] | ["0.2587","0.2579"] | [] | ["C2OX"] | 420.0000 | 445.0000 | 24 | 38 | false | false | true | true | |||||||||
| 01a0a030-32e9-7c11-89b0-ff8569415ff4 | SPGI | 2026-09-14 09:51 | put_calendar | 2 | 1 | 15 | 325890.00 | short | ask | 421.0250 | 12.6000 | ["510"] | ["0.3487"] | [] | ["XCBO"] | 510.0000 | 510.0000 | 494 | 858 | false | false | true | false | |||||||||
| 01a0826f-3998-7e41-87f2-9e38dad0a0e6 | SPGI | 2026-09-08 15:12 | put_diagonal_spread | 2 | 6 | 105 | 274338.00 | short | bid | 431.0600 | 4.7857 | ["420","445"] | ["0.3744","0.2908"] | [] | ["ARCO","XMIO"] | 420.0000 | 445.0000 | 3 | 45 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:59:43Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:40:43Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:57:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:57:49Z"} |
| 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-16T15:16:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:52:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:51:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:12:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |