core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a06ddb-a215-7d32-bb18-00bf8ab311db | NBIS | 2026-09-04 15:18 | other | 4 | 1 | 10 | 300370.00 | unknown | — | 222.1150 | 11.0500 | ["150","220","400","440"] | ["0.8949","0.9195","0.9445","0.9047"] | [] | ["XCBO"] | 150.0000 | 440.0000 | 133 | 833 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:18:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd7-5485-76e1-b514-69aa0d3e3965 | NBIS | 2026-09-04 15:13 | other | 3 | 1 | 15 | 106395.00 | unknown | — | 221.8250 | 5.6500 | ["150","200","440"] | ["0.9303","0.8955","0.9470"] | [] | ["XCBO"] | 150.0000 | 440.0000 | 133 | 286 | false | true | true | true | true | mlat | |||||||
| 01a06dc8-e535-7242-995c-a992b8181ef3 | NBIS | 2026-09-04 14:57 | call_frontspread | 2 | 1 | 75 | 205485.00 | long | bid | 220.7300 | 1.9000 | ["220","290"] | ["0.8204","0.8671"] | ["236.15","505.39"] | ["AMXO"] | 220.0000 | 290.0000 | 42 | 42 | false | false | false | true | |||||||||
| 01a06dc5-476d-7d01-8b2c-af7c6ed59d3d | NBIS | 2026-09-04 14:53 | other | 2 | 1 | 405 | 1664550.00 | unknown | — | 220.5029 | 4.2000 | ["200","202.5"] | ["3.9648","0.7362"] | [] | ["XCBO"] | 200.0000 | 202.5000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a06dc4-ddf5-7d12-8281-e6bad7ac5840 | NBIS | 2026-09-04 14:53 | other | 4 | 1 | 45 | 293715.00 | unknown | — | 220.5518 | 6.3500 | ["210","225"] | ["0.7971","0.8154"] | [] | ["XCBO"] | 210.0000 | 225.0000 | 14 | 35 | false | false | true | true | false | mlat | |||||||
| 01a06dc3-7a7d-7591-9291-ff3fe6d19069 | NBIS | 2026-09-04 14:52 | call_diagonal_spread_bearish | 2 | 1 | 415 | 1732210.00 | long | bid | 220.9900 | 3.8000 | ["200","202.5"] | ["6.4303","0.7265"] | [] | ["XMIO"] | 200.0000 | 202.5000 | 0 | 7 | false | false | true | true | |||||||||
| 01a06da1-2185-72c0-aae7-766ac82f6ecc | NBIS | 2026-09-04 14:14 | call_vertical_spread | 2 | 1 | 100 | 116100.00 | unknown | — | 218.0800 | 0.4000 | ["225","227.5"] | ["0.7520","0.7566"] | [] | ["XCBO"] | 225.0000 | 227.5000 | 7 | 7 | false | true | false | true | false | mlat | |||||||
| 01a06d85-0e05-7d53-9d47-bea7b9dbf37b | NBIS | 2026-09-04 13:43 | other | 3 | 1 | 150 | 316351.00 | unknown | — | 218.0900 | 4.8000 | ["75","105","125"] | ["0.9794","0.9352","0.9150"] | [] | ["XCBO"] | 75.0000 | 125.0000 | 105 | 286 | false | true | true | true | false | mlat | |||||||
| 01a06d64-dfbd-71e0-b287-5f05eb259b7c | NBIS | 2026-09-04 13:08 | call_butterfly_spread | 3 | 1 | 6 | 120705.00 | long | ask | 218.1796 | 13.8500 | ["200","300","400"] | ["0.9208","0.9088","0.9028"] | ["206.71","393.29"] | ["XCBO"] | 200.0000 | 400.0000 | 833 | 833 | false | false | false | true | |||||||||
| 01a06d3c-dd8e-7be1-ab10-c1b6ec55a894 | NBIS | 2026-09-04 12:24 | put_condor | 4 | 1 | 6 | 119154.00 | unknown | — | 216.0666 | 5.9000 | ["220","230","240","250"] | ["0.8603","0.8592","0.8567","0.8572"] | [] | ["XCBO"] | 220.0000 | 250.0000 | 105 | 105 | false | false | false | true | false | mlat | |||||||
| 01a06d28-53bd-7380-aad3-5317476407fd | NBIS | 2026-09-04 12:02 | put_calendar | 2 | 1 | 19 | 400634.00 | short | ask | 215.9500 | 2.2000 | ["320"] | ["1.0045"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 14 | 42 | false | false | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:14:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:58:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:54:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:54:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:52:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:14:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:44:33Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:08:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:25:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:03:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |