core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e850-3cbf-7630-9c62-b19e5a016a42 | MSFT | 2026-09-28 09:59 | synthetic | 2 | 1 | 4 | 26268.00 | long | ask | 508.6300 | 2.7500 | ["500"] | ["0.2958"] | ["514.25"] | ["ARCO"] | 500.0000 | 500.0000 | 109 | 109 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T13:59:47Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d9c8-e07f-7fc1-bec1-dd87818b60a5 | MSFT | 2026-09-25 14:16 | synthetic | 2 | 2 | 10 | 48840.00 | long | ask | 518.4920 | 2.5000 | ["490"] | ["0.3380"] | ["520.50"] | ["XISX"] | 490.0000 | 490.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a0d90f-5866-73c1-bf37-c585662c9c82 | MSFT | 2026-09-25 10:54 | synthetic | 2 | 1 | 5 | 100380.00 | long | ask | 514.1400 | 5.4500 | ["440"] | ["0.3297"] | ["552.80"] | ["XMIO"] | 440.0000 | 440.0000 | 812 | 812 | false | false | false | false | |||||||||
| 01a0d8d6-b84f-79d0-a76d-eaabc639bd25 | MSFT | 2026-09-25 09:52 | synthetic | 2 | 2 | 2 | 39119.00 | long | ask | 515.8703 | 6.6000 | ["490"] | ["0.3307"] | ["557.50"] | ["EMLD","SPHR"] | 490.0000 | 490.0000 | 812 | 812 | false | false | false | false | |||||||||
| 01a0d8ce-0d8f-7f12-96c2-e99a1545dafa | MSFT | 2026-09-25 09:42 | synthetic | 2 | 1 | 29 | 167011.00 | long | ask | 512.9250 | 1.5000 | ["480"] | ["0.3203"] | ["515.79"] | ["XMIO"] | 480.0000 | 480.0000 | 56 | 56 | false | false | false | false | |||||||||
| 01a0d4df-7226-7120-a1ac-2530bdd537c1 | MSFT | 2026-09-24 15:23 | synthetic | 2 | 2 | 12 | 67680.00 | long | ask | 497.8900 | 0.8500 | ["500"] | ["0.2950"] | ["502.00"] | ["AMXO"] | 500.0000 | 500.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0cf98-7e66-7721-b046-355ea0ec0c5d | MSFT | 2026-09-23 14:47 | synthetic | 2 | 1 | 10 | 65200.00 | long | ask | 500.8850 | 0.6000 | ["495"] | ["0.2925"] | ["506.92"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf97-f5af-7d60-8bc4-58a99ac5664f | MSFT | 2026-09-23 14:47 | synthetic | 2 | 1 | 10 | 65200.00 | long | ask | 500.8000 | 0.7000 | ["495"] | ["0.2925"] | ["506.86"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf6b-a207-7063-b4e4-214a7c1d0bb8 | MSFT | 2026-09-23 13:58 | synthetic | 2 | 1 | 10 | 65250.00 | long | ask | 499.8750 | 0.5000 | ["495"] | ["0.2935"] | ["505.91"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf5f-808f-7ee1-b595-4e5e297c6d58 | MSFT | 2026-09-23 13:45 | synthetic | 2 | 1 | 10 | 65430.00 | long | ask | 499.8400 | 0.7500 | ["495"] | ["0.2944"] | ["505.89"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf47-ddc6-7c70-9f04-bf0e5a0bb8f7 | MSFT | 2026-09-23 13:19 | synthetic | 2 | 1 | 10 | 65440.00 | long | ask | 500.2650 | 0.6000 | ["495"] | ["0.2941"] | ["506.28"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf40-38bf-73b0-921a-ffcef1406e1d | MSFT | 2026-09-23 13:11 | synthetic | 2 | 1 | 10 | 65130.00 | long | ask | 499.6400 | 0.4000 | ["495"] | ["0.2932"] | ["505.69"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf3f-b3ee-7d12-901b-b3e613f6149d | MSFT | 2026-09-23 13:10 | synthetic | 2 | 1 | 10 | 65100.00 | long | ask | 499.5800 | 0.4500 | ["495"] | ["0.2931"] | ["505.66"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf37-8246-7b53-b22d-608be417944e | MSFT | 2026-09-23 13:01 | synthetic | 2 | 1 | 10 | 65010.00 | long | ask | 499.8000 | 0.4500 | ["495"] | ["0.2925"] | ["505.85"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0cf37-3fdf-70d0-a6e6-d76634e704b9 | MSFT | 2026-09-23 13:01 | synthetic | 2 | 1 | 10 | 65040.00 | long | ask | 499.7250 | 0.5000 | ["495"] | ["0.2927"] | ["505.74"] | ["XISX"] | 495.0000 | 495.0000 | 114 | 114 | false | false | false | false | |||||||||
| 01a0c532-1c17-7bf1-ae67-7d86171a52cd | MSFT | 2026-09-21 14:19 | synthetic | 2 | 1 | 10 | 64860.00 | long | ask | 497.9400 | 0.8500 | ["490"] | ["0.2895"] | ["504.58"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c4d5-040f-7993-b1cb-f8af6358072e | MSFT | 2026-09-21 12:38 | synthetic | 2 | 1 | 10 | 63850.00 | long | ask | 494.8300 | 0.9000 | ["490"] | ["0.2876"] | ["501.33"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c49e-09d7-7412-b981-3a58be31c105 | MSFT | 2026-09-21 11:38 | synthetic | 2 | 1 | 10 | 63350.00 | long | ask | 492.5800 | 0.6500 | ["490"] | ["0.2870"] | ["498.85"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c483-6586-7ab1-b785-dc988c95e88b | MSFT | 2026-09-21 11:08 | synthetic | 2 | 1 | 10 | 63350.00 | long | ask | 493.2500 | 0.6500 | ["490"] | ["0.2865"] | ["499.37"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c47b-85e6-7342-a75d-73ad966b6c2e | MSFT | 2026-09-21 11:00 | synthetic | 2 | 1 | 10 | 63540.00 | long | ask | 493.8550 | 1.0000 | ["490"] | ["0.2869"] | ["499.98"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c472-620f-7671-aff5-5c46f6994117 | MSFT | 2026-09-21 10:50 | synthetic | 2 | 1 | 10 | 63400.00 | long | ask | 493.4800 | 1.0000 | ["490"] | ["0.2866"] | ["499.64"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c472-1bbe-7c82-bb44-3aa9411b6ffb | MSFT | 2026-09-21 10:50 | synthetic | 2 | 1 | 10 | 63410.00 | long | ask | 493.5100 | 1.0000 | ["490"] | ["0.2866"] | ["499.61"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c471-315e-7863-995e-d0d0ce0d3b83 | MSFT | 2026-09-21 10:49 | synthetic | 2 | 1 | 10 | 63390.00 | long | ask | 493.6650 | 0.5000 | ["490"] | ["0.2864"] | ["499.79"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c470-e33f-7432-b6fb-5cf028acfe2a | MSFT | 2026-09-21 10:48 | synthetic | 2 | 1 | 10 | 63350.00 | long | ask | 493.7050 | 0.7000 | ["490"] | ["0.2862"] | ["499.83"] | ["XISX"] | 490.0000 | 490.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0b0cf-d843-74a3-b3d4-663f20f166b2 | MSFT | 2026-09-17 15:20 | synthetic | 2 | 1 | 250 | 346250.00 | long | ask | 496.4750 | 0.6500 | ["495"] | ["0.2352"] | ["497.35"] | ["XBOX"] | 495.0000 | 495.0000 | 8 | 8 | false | false | false | false | |||||||||
| 01a091c0-a468-7800-85a8-51191121d97a | MSFT | 2026-09-11 14:35 | synthetic | 2 | 2 | 10 | 34340.00 | long | ask | 496.2000 | 2.3000 | ["490"] | ["0.2530"] | ["498.50"] | ["XISX"] | 490.0000 | 490.0000 | 42 | 42 | false | false | false | false | |||||||||
| 01a08cac-97e8-7d33-9685-d4d8f7467965 | MSFT | 2026-09-10 14:55 | synthetic | 2 | 3 | 9 | 41877.00 | short | ask | 491.3800 | 1.5500 | ["495"] | ["0.3205"] | ["494.64"] | ["MCRY","XISX"] | 495.0000 | 495.0000 | 50 | 50 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:17:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:54:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:52:24Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| 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 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:23:52Z"} |
| 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-23T18:48:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:59:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:46:00Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:20:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:11:42Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:11:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:02:13Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:01:46Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:19:52Z"} |
| 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-21T16:38:17Z"} |
| 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-21T15:38:18Z"} |
| 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-21T15:09:25Z"} |
| 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-21T15:00:29Z"} |
| 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:50:39Z"} |
| 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:50:13Z"} |
| 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:49:16Z"} |
| 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:48:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:20:21Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:35:38Z"} |
| 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-10T18:55:37Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |