core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d90c-d3df-77b1-92ac-f062fa5f5dcf | MSFT | 2026-09-25 10:51 | straddle | 2 | 1 | 175 | 1537200.00 | long | ask | 514.9100 | 2.9500 | ["530"] | ["0.3079"] | ["442.16","617.84"] | ["XPHO"] | 530.0000 | 530.0000 | 175 | 175 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:51:50Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d90b-58f6-7051-a6bc-871ddf1d8da7 | MSFT | 2026-09-25 10:49 | straddle | 2 | 1 | 50 | 129396.00 | long | ask | 515.1200 | 1.1500 | ["515"] | ["0.2627"] | ["489.12","540.88"] | ["XISX"] | 515.0000 | 515.0000 | 21 | 21 | false | false | |||||||||||
| 01a0d8ce-0d8f-7f12-96c2-e9b60c8b8f1e | MSFT | 2026-09-25 09:42 | straddle | 2 | 1 | 28 | 186760.00 | short | bid | 512.9250 | 1.7000 | ["475"] | ["0.3026"] | ["408.30","541.70"] | ["XPHO"] | 475.0000 | 475.0000 | 84 | 84 | false | false | |||||||||||
| 01a0d8ce-0d8f-7f12-96c2-e98da2ad14c5 | MSFT | 2026-09-25 09:42 | straddle | 2 | 1 | 4 | 25856.00 | short | bid | 512.9250 | 1.7000 | ["480"] | ["0.3013"] | ["415.36","544.64"] | ["EMLD"] | 480.0000 | 480.0000 | 84 | 84 | false | false | |||||||||||
| 01a0d4cd-49b7-72c1-875a-87ae0dda0a85 | MSFT | 2026-09-24 15:03 | straddle | 2 | 1 | 85 | 204340.00 | long | ask | 496.9000 | 0.4500 | ["500"] | ["0.2461"] | ["475.96","524.04"] | ["XPHO"] | 500.0000 | 500.0000 | 22 | 22 | false | false | |||||||||||
| 01a0d3a8-2aa7-7133-87a5-dc088a029873 | MSFT | 2026-09-24 09:43 | straddle | 2 | 1 | 10 | 113340.00 | long | ask | 493.2400 | 2.3600 | ["385"] | ["0.3864"] | ["271.66","498.34"] | ["XMIO"] | 385.0000 | 385.0000 | 57 | 57 | false | false | |||||||||||
| 01a0cfd7-3ce6-7a53-bf47-2b2aa7e12885 | MSFT | 2026-09-23 15:56 | straddle | 2 | 1 | 10 | 65050.00 | unknown | — | 500.2000 | 0.8000 | ["495"] | ["0.2924"] | [] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf97-70df-7e70-891e-2b2ada8f7e0c | MSFT | 2026-09-23 14:46 | straddle | 2 | 1 | 10 | 65250.00 | long | ask | 500.6901 | 0.8500 | ["495"] | ["0.2929"] | ["429.75","560.25"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf96-097f-7380-affd-dfc9ec373362 | MSFT | 2026-09-23 14:45 | straddle | 2 | 1 | 10 | 65230.00 | long | ask | 500.6600 | 1.1500 | ["495"] | ["0.2928"] | ["429.77","560.23"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf95-bb5f-7582-9924-bf393b47de84 | MSFT | 2026-09-23 14:44 | straddle | 2 | 1 | 10 | 65240.00 | short | bid | 500.6100 | 1.2000 | ["495"] | ["0.2929"] | ["429.76","560.24"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf7d-5d17-7321-86cb-3eda318d71fb | MSFT | 2026-09-23 14:18 | straddle | 2 | 1 | 10 | 65190.00 | short | bid | 499.6200 | 0.7000 | ["495"] | ["0.2935"] | ["429.81","560.19"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf6c-2abf-7ac3-996b-7ac2bca6ee32 | MSFT | 2026-09-23 13:59 | straddle | 2 | 1 | 10 | 65300.00 | short | bid | 500.0400 | 0.4500 | ["495"] | ["0.2936"] | ["429.70","560.30"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf6b-117e-7453-9228-2d0535f74e33 | MSFT | 2026-09-23 13:58 | straddle | 2 | 1 | 10 | 65240.00 | short | bid | 499.8700 | 0.4500 | ["495"] | ["0.2935"] | ["429.76","560.24"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf47-aaff-7740-b260-67f7a646c5b3 | MSFT | 2026-09-23 13:19 | straddle | 2 | 1 | 10 | 65490.00 | short | bid | 500.1300 | 0.6000 | ["495"] | ["0.2944"] | ["429.51","560.49"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf42-53cf-7ff0-af6e-67745442ab62 | MSFT | 2026-09-23 13:13 | straddle | 2 | 2 | 10 | 65170.00 | short | bid | 499.6900 | 0.6000 | ["495"] | ["0.2933"] | ["429.83","560.17"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf36-b33f-7923-8559-142faf6cc655 | MSFT | 2026-09-23 13:01 | straddle | 2 | 1 | 10 | 65020.00 | short | bid | 499.6100 | 0.5000 | ["495"] | ["0.2927"] | ["429.98","560.02"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf36-22b7-7dc0-a31e-44e9dc23e801 | MSFT | 2026-09-23 13:00 | straddle | 2 | 1 | 10 | 64980.00 | long | ask | 499.4800 | 0.5500 | ["495"] | ["0.2926"] | ["430.02","559.98"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf27-de5e-7673-9f38-ad53e50a2176 | MSFT | 2026-09-23 12:44 | straddle | 2 | 1 | 10 | 64670.00 | short | bid | 498.4000 | 0.5000 | ["495"] | ["0.2920"] | ["430.33","559.67"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf13-77b7-7811-8018-24a4335b2939 | MSFT | 2026-09-23 12:22 | straddle | 2 | 1 | 10 | 64700.00 | long | ask | 498.6850 | 0.6500 | ["495"] | ["0.2920"] | ["430.30","559.70"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ceb1-cfb7-7bc2-aca9-ad2d97ce337f | MSFT | 2026-09-23 10:35 | straddle | 2 | 1 | 10 | 64450.00 | short | bid | 498.0300 | 1.2500 | ["495"] | ["0.2913"] | ["430.55","559.45"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ceb0-be47-73c0-8951-0f525da8b304 | MSFT | 2026-09-23 10:34 | straddle | 2 | 1 | 10 | 64740.00 | short | bid | 497.5600 | 1.8000 | ["495"] | ["0.2930"] | ["430.26","559.74"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ce7e-dcbf-7022-a0a5-a7319b6df303 | MSFT | 2026-09-23 09:40 | straddle | 2 | 1 | 3 | 26088.00 | short | bid | 507.6200 | 4.1500 | ["510"] | ["0.3105"] | ["423.04","596.96"] | ["XCBO"] | 510.0000 | 510.0000 | 177 | 177 | false | false | |||||||||||
| 01a0c999-75a6-7a10-b4df-9cbd6e81b740 | MSFT | 2026-09-22 10:51 | straddle | 2 | 1 | 10 | 25780.00 | long | ask | 497.6000 | 0.6500 | ["500"] | ["0.2528"] | ["474.22","525.78"] | ["XPHO"] | 500.0000 | 500.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c97d-7997-7562-b7f9-6f2c5b55b259 | MSFT | 2026-09-22 10:20 | straddle | 2 | 1 | 10 | 25550.00 | long | ask | 497.8900 | 1.6000 | ["500"] | ["0.2506"] | ["474.45","525.55"] | ["EDGO"] | 500.0000 | 500.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c473-2947-7dd1-982a-1916d133409b | MSFT | 2026-09-21 10:51 | straddle | 2 | 1 | 10 | 63550.00 | unknown | — | 493.6600 | 1.0000 | ["490"] | ["0.2871"] | [] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c472-df0f-7ca3-a493-92fe12902167 | MSFT | 2026-09-21 10:50 | straddle | 2 | 1 | 10 | 63400.00 | unknown | — | 493.6000 | 0.6000 | ["490"] | ["0.2865"] | [] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c471-bdfe-7803-a840-12ba6d6a36ae | MSFT | 2026-09-21 10:49 | straddle | 2 | 1 | 10 | 63520.00 | short | bid | 493.3950 | 1.1000 | ["490"] | ["0.2872"] | ["426.48","553.52"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | |||||||||||
| 01a0abcb-bdcc-7233-9869-9c0fa6bc45c9 | MSFT | 2026-09-16 15:57 | straddle | 2 | 1 | 2 | 28068.00 | unknown | — | 489.8600 | 4.3000 | ["510"] | ["0.3252"] | [] | ["XPHO"] | 510.0000 | 510.0000 | 457 | 457 | false | false | false | false | |||||||||
| 01a0a5c8-dfbe-7c11-b056-5da0af5fed9f | MSFT | 2026-09-15 11:56 | straddle | 2 | 1 | 1500 | 7801500.00 | unknown | — | 501.4900 | 1.8500 | ["500"] | ["0.3065"] | [] | ["AMXO"] | 500.0000 | 500.0000 | 66 | 66 | false | false | false | false | |||||||||
| 01a0a10e-a438-7d12-a889-30a5c17c3b29 | MSFT | 2026-09-14 13:54 | straddle | 2 | 2 | 13 | 40950.00 | short | bid | 509.7300 | 0.6000 | ["500"] | ["0.2532"] | ["468.50","531.50"] | ["XMIO"] | 500.0000 | 500.0000 | 32 | 32 | false | false | |||||||||||
| 01a091e5-85d0-7bd0-a237-40ccb0c62ef5 | MSFT | 2026-09-11 15:15 | straddle | 2 | 3 | 9 | 47133.00 | long | ask | 497.3250 | 1.4222 | ["505"] | ["0.2999"] | ["452.63","557.37"] | ["ARCO","EMLD","XBOX"] | 505.0000 | 505.0000 | 70 | 70 | false | false | |||||||||||
| 01a091da-4eb8-74c1-ae39-91f062bb6180 | MSFT | 2026-09-11 15:03 | straddle | 2 | 1 | 12 | 37176.00 | unknown | — | 496.6600 | 0.8500 | ["510"] | ["0.2385"] | [] | ["XMIO"] | 510.0000 | 510.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a087ad-6b28-7c50-9e4e-d9238beddcfe | MSFT | 2026-09-09 15:38 | straddle | 2 | 1 | 10 | 126080.00 | unknown | — | 491.4050 | 1.5500 | ["510"] | ["0.3194"] | [] | ["XMIO"] | 510.0000 | 510.0000 | 373 | 373 | false | false | false | false |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:50:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:43:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:43:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:03:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:43:34Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:56:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:47:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:45:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:44:56Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:18:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:59:48Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:58:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:19:41Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:14:12Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:01:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:00:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:45:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:22:57Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:36:00Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:34:50Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:40:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:51:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:20:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:51:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:51:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:49:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:57:32Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:57:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:54:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:15:51Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:03:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:38:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |