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 | direction |
|---|
| 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 |
|---|
| 01a0c94f-5c52-7102-8799-ea0350ee5bce | MSFT | 2026-09-22 09:30 | put_calendar | 2 | 1 | 30 | 55260.00 | short | bid | 507.2600 | 3.9000 | ["507.5"] | ["0.2631"] | [] | ["EDGO"] | 507.5000 | 507.5000 | 10 | 13 | true | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:30:09Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c51f-fb77-7b71-95f1-f6252f7480c1 | MSFT | 2026-09-21 14:00 | put_calendar | 2 | 1 | 80 | 144240.00 | short | bid | 498.9800 | 1.0500 | ["500"] | ["0.2408"] | [] | ["XMIO"] | 500.0000 | 500.0000 | 11 | 14 | false | false | true | false | |||||||||
| 01a0b527-5ec7-78f0-a33a-0c544b66859f | MSFT | 2026-09-18 11:34 | put_calendar | 2 | 1 | 25 | 34025.00 | unknown | bid | 493.6731 | 1.4500 | ["500"] | ["0.2704"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 0 | 3 | false | false | true | false | |||||||||
| 01a0b4c0-1d2f-74a1-9a00-911d20bed6cf | MSFT | 2026-09-18 09:41 | put_calendar | 2 | 1 | 28 | 35840.00 | short | bid | 493.6500 | 3.4500 | ["250"] | ["0.3677"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 819 | 854 | false | true | true | false | |||||||||
| 01a0b4bf-9c47-7641-a0e3-af75226a38a6 | MSFT | 2026-09-18 09:40 | put_calendar | 2 | 1 | 90 | 183510.00 | unknown | bid | 494.4050 | 1.9000 | ["497.5"] | ["0.2399"] | [] | ["XCBO"] | 497.5000 | 497.5000 | 12 | 14 | false | false | true | false | |||||||||
| 01a0b4bf-84d7-7a90-aca7-c76192fdee85 | MSFT | 2026-09-18 09:40 | put_calendar | 2 | 1 | 90 | 206190.00 | long | bid | 494.4800 | 2.3500 | ["500"] | ["0.2364"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 12 | 14 | false | false | true | false | |||||||||
| 01a0b097-864b-7800-929c-50aabc503e1e | MSFT | 2026-09-17 14:18 | put_calendar | 2 | 1 | 7 | 79898.00 | long | bid | 495.1700 | 2.7000 | ["500"] | ["0.3275"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 365 | 456 | false | false | true | false | |||||||||
| 01a0aba9-fd2b-7ae2-9e84-4f7a40f0ef17 | MSFT | 2026-09-16 15:20 | put_calendar | 2 | 1 | 8 | 32168.00 | unknown | — | 489.0869 | 1.0000 | ["470"] | ["0.3019"] | [] | ["AMXO"] | 470.0000 | 470.0000 | 93 | 121 | false | true | true | false | false | mlat | |||||||
| 01a0aa8e-57e3-79e1-9647-ae8926d597a9 | MSFT | 2026-09-16 10:10 | put_calendar | 2 | 1 | 10 | 29050.00 | short | bid | 493.1900 | 4.4000 | ["310"] | ["0.3561"] | [] | ["XMIO"] | 310.0000 | 310.0000 | 821 | 856 | false | true | true | false | |||||||||
| 01a0a688-bcee-7de3-a198-dbbf27785405 | MSFT | 2026-09-15 15:26 | put_calendar | 2 | 1 | 30 | 97380.00 | short | bid | 496.6900 | 2.0500 | ["320"] | ["0.3561"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a686-01b6-77e3-9c3b-5607f7d0136e | MSFT | 2026-09-15 15:23 | put_calendar | 2 | 1 | 18 | 57780.00 | short | bid | 496.6800 | 2.0500 | ["320"] | ["0.3547"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a684-7346-7583-8378-bc268d9cda91 | MSFT | 2026-09-15 15:21 | put_calendar | 2 | 1 | 30 | 84960.00 | short | bid | 496.6000 | 1.4000 | ["310"] | ["0.3553"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a684-1d55-7721-9ea5-daa35743f346 | MSFT | 2026-09-15 15:21 | put_calendar | 2 | 1 | 30 | 84930.00 | short | bid | 496.7500 | 1.4500 | ["310"] | ["0.3554"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a683-d31e-7390-8798-bb6f2c5a5a33 | MSFT | 2026-09-15 15:20 | put_calendar | 2 | 1 | 30 | 84900.00 | short | bid | 496.7450 | 1.4500 | ["310"] | ["0.3553"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a62e-7f5d-7b90-8418-45d29e1fd0b9 | MSFT | 2026-09-15 13:47 | put_calendar | 2 | 1 | 6 | 25110.00 | unknown | — | 499.3900 | 0.6500 | ["480"] | ["0.3041"] | [] | ["XCBO"] | 480.0000 | 480.0000 | 94 | 122 | false | true | true | false | false | mlat | |||||||
| 01a0a5c5-fd76-7a81-b006-f4bf5be9b2e7 | MSFT | 2026-09-15 11:53 | put_calendar | 2 | 1 | 5 | 25580.00 | short | ask | 500.4400 | 0.9000 | ["450"] | ["0.3213"] | [] | ["XCBO"] | 450.0000 | 450.0000 | 122 | 493 | false | true | true | false | |||||||||
| 01a08731-fd80-7783-a299-ad29bc45ed6b | MSFT | 2026-09-09 13:23 | put_calendar | 2 | 1 | 5 | 42215.00 | short | ask | 492.8579 | 5.3500 | ["535"] | ["0.2840"] | [] | ["EDGO"] | 535.0000 | 535.0000 | 12 | 14 | false | false | true | false | |||||||||
| 01a081b5-2cb0-7d80-afc7-b65ef3fcdb13 | MSFT | 2026-09-08 11:48 | put_calendar | 2 | 1 | 25 | 97949.00 | short | ask | 492.6100 | 3.2500 | ["512.5"] | ["0.4370"] | [] | ["XMIO"] | 512.5000 | 512.5000 | 1 | 3 | false | false | true | false | |||||||||
| 01a06dfc-840d-7ec1-9ff8-7cd6fe00ebaf | MSFT | 2026-09-04 15:54 | put_calendar | 2 | 1 | 25 | 63300.00 | short | bid | 500.5800 | 2.4500 | ["512.5"] | ["2.8112"] | [] | ["XMIO"] | 512.5000 | 512.5000 | 0 | 5 | false | false | true | false | |||||||||
| 01a06da4-0b9d-7f43-a25d-3539f6b32d6f | MSFT | 2026-09-04 14:17 | put_calendar | 2 | 1 | 30 | 125130.00 | long | bid | 500.1650 | 1.2000 | ["520"] | ["0.7168"] | [] | ["XMIO"] | 520.0000 | 520.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a06d9f-410e-74f2-beb8-2e181a74aa06 | MSFT | 2026-09-04 14:12 | put_calendar | 2 | 1 | 40 | 66560.00 | short | ask | 500.2264 | 1.8500 | ["507.5"] | ["0.4889"] | [] | ["XCBO"] | 507.5000 | 507.5000 | 0 | 5 | false | false | true | false | |||||||||
| 01a06d43-5d9d-7680-8b0a-927df4e410de | MSFT | 2026-09-04 12:32 | put_calendar | 2 | 1 | 28 | 29064.00 | long | ask | 501.0400 | 0.5500 | ["495"] | ["0.2164"] | [] | ["XCBO"] | 495.0000 | 495.0000 | 12 | 14 | false | true | true | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:00:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:34:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:41:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:19:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:20:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:26:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:23:40Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:21:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:21:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:20:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:47:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:54:09Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:23:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:49:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:29Z"} |
| 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:17:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:12:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:32:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |