core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0f3e0-1767-7011-99c4-8f277e9b3a42 | BA | 2026-09-30 15:52 | put_calendar | 2 | 1 | 30 | 175230.00 | short | ask | 186.0500 | 3.0500 | ["215"] | ["0.4118"] | [] | ["XISX"] | 215.0000 | 215.0000 | 16 | 30 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T19:52:23Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0ee5a-5587-7e92-860e-6530a715ec0a | BA | 2026-09-29 14:08 | put_calendar | 2 | 1 | 45 | 177750.00 | short | ask | 187.9900 | 3.7000 | ["207.5"] | ["0.5485"] | [] | ["XISX"] | 207.5000 | 207.5000 | 3 | 10 | false | false | |||||||||||
| 01a0eda5-ceaf-7c71-8112-26b44102edb5 | BA | 2026-09-29 10:50 | put_calendar | 2 | 2 | 77 | 269038.00 | long | ask | 189.4200 | 1.7000 | ["200"] | ["0.3560"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 52 | 108 | false | false | |||||||||||
| 01a0ed9b-f727-7e60-b0d9-aa5ad40f1a6d | BA | 2026-09-29 10:40 | put_calendar | 2 | 1 | 50 | 228300.00 | unknown | ask | 189.5296 | 2.1000 | ["210"] | ["0.3738"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 17 | 80 | false | false | |||||||||||
| 01a0e945-ef2f-7812-9194-90f08d86fdd7 | BA | 2026-09-28 14:27 | put_calendar | 2 | 1 | 199 | 1799756.00 | unknown | bid | 185.3900 | 5.5000 | ["230"] | ["0.3740"] | [] | ["XISX"] | 230.0000 | 230.0000 | 53 | 172 | false | false | |||||||||||
| 01a0e944-ed5f-7743-8c07-93e26fc3c038 | BA | 2026-09-28 14:26 | put_calendar | 2 | 1 | 10 | 136350.00 | unknown | — | 185.1000 | 11.8000 | ["250"] | ["0.4218"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 109 | 844 | false | false | true | false | |||||||||
| 01a0e8e3-fcf7-7e52-b7cd-5e52b79ea425 | BA | 2026-09-28 12:40 | put_calendar | 2 | 1 | 30 | 144930.00 | unknown | ask | 188.1800 | 3.3000 | ["210"] | ["0.3918"] | [] | ["XBOX"] | 210.0000 | 210.0000 | 18 | 81 | false | false | |||||||||||
| 01a0e8af-aa6f-7012-99f2-ba4deaa42714 | BA | 2026-09-28 11:43 | put_calendar | 2 | 2 | 10 | 105320.00 | short | bid | 188.7000 | 2.1000 | ["240"] | ["0.4004"] | [] | ["XCBO"] | 240.0000 | 240.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e8ae-db67-7d70-8664-3f60de7bb4b9 | BA | 2026-09-28 11:42 | put_calendar | 2 | 1 | 10 | 105350.00 | short | bid | 188.6108 | 2.1000 | ["240"] | ["0.3983"] | [] | ["XMIO"] | 240.0000 | 240.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e8a0-0a6e-7920-9566-a958703fcb35 | BA | 2026-09-28 11:26 | put_calendar | 2 | 1 | 9 | 111825.00 | short | bid | 188.2550 | 4.7500 | ["250"] | ["0.4234"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e89f-04b7-7dd2-9989-229cef9924ea | BA | 2026-09-28 11:25 | put_calendar | 2 | 1 | 47 | 583411.00 | short | bid | 188.4300 | 5.0500 | ["250"] | ["0.4266"] | [] | ["MCRY"] | 250.0000 | 250.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e89f-04b7-7dd2-9989-22827090f0f7 | BA | 2026-09-28 11:25 | put_calendar | 2 | 3 | 63 | 782319.00 | short | bid | 188.4300 | 5.0500 | ["250"] | ["0.4277"] | [] | ["ARCO","EMLD","SPHR"] | 250.0000 | 250.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e89d-e78e-7b82-9c45-0b315e781707 | BA | 2026-09-28 11:24 | put_calendar | 2 | 1 | 35 | 436625.00 | short | bid | 188.2850 | 2.7500 | ["250"] | ["0.4339"] | [] | ["XISX"] | 250.0000 | 250.0000 | 81 | 235 | false | false | |||||||||||
| 01a0e87e-807f-7872-8801-cb6afca1fe68 | BA | 2026-09-28 10:49 | put_calendar | 2 | 1 | 18 | 151884.00 | short | ask | 189.0700 | 5.4417 | ["230"] | ["0.3899"] | [] | ["XISX"] | 230.0000 | 230.0000 | 53 | 144 | false | false | |||||||||||
| 01a0e860-906f-7e12-a67d-b85bed1ee48d | BA | 2026-09-28 10:17 | put_calendar | 2 | 1 | 21 | 111090.00 | short | ask | 188.9536 | 4.7500 | ["215"] | ["0.6552"] | [] | ["XPHO"] | 215.0000 | 215.0000 | 4 | 39 | false | false | |||||||||||
| 01a0e84d-cfa7-7693-a30e-0b2d839f2bc3 | BA | 2026-09-28 09:56 | put_calendar | 2 | 1 | 15 | 158280.00 | long | ask | 188.2199 | 8.8500 | ["235"] | ["0.3761"] | [] | ["BATO"] | 235.0000 | 235.0000 | 354 | 480 | false | false | |||||||||||
| 01a0ceb7-982f-7172-988b-dc1d407df291 | BA | 2026-09-23 10:42 | put_calendar | 2 | 1 | 34 | 197710.00 | unknown | ask | 202.1300 | 8.4500 | ["220"] | ["0.3520"] | [] | ["AMXO"] | 220.0000 | 220.0000 | 114 | 359 | false | false | |||||||||||
| 01a0c566-ff27-7c41-8fc0-1e80588bcf8d | BA | 2026-09-21 15:17 | put_calendar | 2 | 1 | 20 | 155940.00 | short | bid | 200.8200 | 4.7500 | ["230"] | ["0.3541"] | [] | ["XMIO"] | 230.0000 | 230.0000 | 269 | 361 | false | false | |||||||||||
| 01a0b572-8128-75d0-b6c5-3edb27d301d7 | BA | 2026-09-18 12:56 | put_calendar | 2 | 1 | 20 | 239200.00 | short | bid | 197.1500 | 6.3000 | ["250"] | ["0.4031"] | [] | ["XISX"] | 250.0000 | 250.0000 | 119 | 854 | false | false | |||||||||||
| 01a0b52d-88e8-7912-91f8-aa5b7e993b74 | BA | 2026-09-18 11:40 | put_calendar | 2 | 1 | 45 | 439020.00 | unknown | ask | 195.6450 | 2.4000 | ["235"] | ["0.3739"] | [] | ["XISX"] | 235.0000 | 235.0000 | 364 | 490 | false | false | |||||||||||
| 01a0afaf-50fb-7bf2-8ccd-85ff55095398 | BA | 2026-09-17 10:04 | put_calendar | 2 | 1 | 60 | 151440.00 | short | ask | 199.8500 | 2.9500 | ["210"] | ["0.5006"] | [] | ["XPHO"] | 210.0000 | 210.0000 | 1 | 43 | false | false | |||||||||||
| 01a0af94-089b-7800-86bd-7f02faa6d4ef | BA | 2026-09-17 09:35 | put_calendar | 2 | 2 | 50 | 425250.00 | unknown | — | 201.4700 | 6.9500 | ["240"] | ["0.3900"] | [] | ["ARCO"] | 240.0000 | 240.0000 | 92 | 183 | false | false | true | false | |||||||||
| 01a0aba7-1313-7130-af8a-25cb328e4191 | BA | 2026-09-16 15:17 | put_calendar | 2 | 1 | 30 | 143040.00 | short | bid | 198.1900 | 10.2500 | ["222.5"] | ["1.1610"] | [] | ["XMIO"] | 222.5000 | 222.5000 | 2 | 9 | false | false | |||||||||||
| 01a0ab6b-daea-77f2-be52-880a5f6aa453 | BA | 2026-09-16 14:12 | put_calendar | 2 | 1 | 70 | 299950.00 | unknown | — | 207.1300 | 10.2500 | ["230"] | ["0.4877"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 9 | 23 | false | false | true | false | |||||||||
| 01a08bc3-5ce0-72a3-823b-cb7202579109 | BA | 2026-09-10 10:40 | put_calendar | 2 | 1 | 114 | 543324.00 | short | ask | 208.1100 | 3.5500 | ["230"] | ["0.3896"] | [] | ["XPHO"] | 230.0000 | 230.0000 | 8 | 71 | false | false | |||||||||||
| 01a0865d-6b88-7450-9225-beee5e6828e9 | BA | 2026-09-09 09:31 | put_calendar | 2 | 1 | 200 | 2159600.00 | short | ask | 209.9000 | 3.7500 | ["260"] | ["0.3780"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 100 | 373 | false | false | |||||||||||
| 01a06d51-3495-7162-88a5-24a2a4ec5646 | BA | 2026-09-04 12:47 | put_calendar | 2 | 1 | 37 | 116920.00 | short | bid | 210.8050 | 1.2000 | ["225"] | ["0.2979"] | [] | ["XISX"] | 225.0000 | 225.0000 | 14 | 42 | false | false |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:08:25Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:51:27Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:40:30Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:28:38Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:27:35Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:41:09Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:43:48Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:43:08Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:26:39Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:25:38Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:25:38Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:24:43Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:50:06Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:17:35Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:57:08Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:42:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:17:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:56:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:40:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:04:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:35:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:17:35Z"} |
| 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-16T18:13:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:40:31Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:31:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:47:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |