core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f8ff-0127-7632-9b9b-19379d691677 | TSM | 2026-10-01 15:44 | call_diagonal_spread | 2 | 1 | 2 | 27370.00 | long | ask | 458.6500 | 3.2500 | ["380","500"] | ["0.3773","0.3564"] | [] | ["XPHO"] | 380.0000 | 500.0000 | 141 | 259 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:44:49Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f8e5-1087-7162-9541-9fdaae6268bf | TSM | 2026-10-01 15:15 | call_diagonal_spread | 2 | 1 | 4 | 33884.00 | unknown | ask | 458.2418 | 1.3000 | ["450","460"] | ["0.3518","0.3575"] | [] | ["EMLD"] | 450.0000 | 460.0000 | 106 | 141 | false | false | true | ||||||||||
| 01a0f8db-9aa7-70f3-bc44-537564268f3e | TSM | 2026-10-01 15:05 | call_diagonal_spread | 2 | 1 | 3 | 26655.00 | unknown | bid | 458.2950 | 3.1000 | ["380","450"] | ["0.5258","0.3860"] | [] | ["XISX"] | 380.0000 | 450.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a0f8cb-cbc7-75b2-bebd-2bd0fdc50dac | TSM | 2026-10-01 14:48 | call_diagonal_spread | 2 | 1 | 3 | 29430.00 | short | bid | 459.0895 | 1.6500 | ["450","460"] | ["0.3603","0.3642"] | [] | ["XISX"] | 450.0000 | 460.0000 | 141 | 169 | false | false | true | ||||||||||
| 01a0f8c0-c777-7263-8fbb-c7160f579435 | TSM | 2026-10-01 14:36 | call_diagonal_spread | 2 | 1 | 8 | 26320.00 | long | ask | 459.7550 | 1.9500 | ["465","470"] | ["0.3356","0.3315"] | [] | ["XISX"] | 465.0000 | 470.0000 | 29 | 43 | false | true | true | ||||||||||
| 01a0f8c0-a066-7da3-a2ab-767ac1241e6f | TSM | 2026-10-01 14:36 | call_diagonal_spread | 2 | 1 | 10 | 41570.00 | long | bid | 459.8900 | 1.3000 | ["435","455"] | ["0.6539","0.3596"] | [] | ["ARCO"] | 435.0000 | 455.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a0f8be-ac67-7420-8ba0-306fca01bb02 | TSM | 2026-10-01 14:33 | call_diagonal_spread | 2 | 1 | 4 | 40148.00 | long | bid | 459.3150 | 4.9500 | ["407.5","410"] | ["1.3137","0.4905"] | [] | ["XISX"] | 407.5000 | 410.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f8af-181f-7ad1-b2a5-69a7dd27d388 | TSM | 2026-10-01 14:16 | call_diagonal_spread | 2 | 3 | 7 | 31374.00 | long | bid | 457.8750 | 3.2500 | ["432.5","442.5"] | ["0.7996","0.3224"] | [] | ["ARCO","EMLD","SPHR"] | 432.5000 | 442.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f8a3-b9f7-7083-ab70-b811c4c734cc | TSM | 2026-10-01 14:04 | call_diagonal_spread | 2 | 1 | 5 | 59025.00 | unknown | ask | 458.7800 | 3.0000 | ["400","410"] | ["0.4718","0.3655"] | [] | ["XCBO"] | 400.0000 | 410.0000 | 15 | 50 | false | false | true | ||||||||||
| 01a0f89e-b8b7-7101-b9d4-8908a7d0c6b2 | TSM | 2026-10-01 13:59 | call_diagonal_spread | 2 | 4 | 20 | 95930.00 | unknown | bid | 459.1200 | 2.1000 | ["437.5","442.5"] | ["0.3406","0.3729"] | [] | ["XCBO","XISX","XPHO"] | 437.5000 | 442.5000 | 8 | 15 | false | false | true | ||||||||||
| 01a0f89e-b8b7-7101-b9d4-88f67a459b68 | TSM | 2026-10-01 13:59 | call_diagonal_spread | 2 | 1 | 2 | 36774.00 | long | ask | 459.1200 | 3.3000 | ["400","500"] | ["0.3496","0.4002"] | [] | ["XISX"] | 400.0000 | 500.0000 | 78 | 841 | false | false | true | ||||||||||
| 01a0f85b-e357-7073-aa8d-95765a09f95f | TSM | 2026-10-01 12:46 | call_diagonal_spread | 2 | 1 | 4 | 83780.00 | long | ask | 456.0950 | 4.5000 | ["320","435"] | ["0.3992","0.3610"] | [] | ["ARCO"] | 320.0000 | 435.0000 | 15 | 624 | false | false | true | ||||||||||
| 01a0f85b-e357-7073-aa8d-95668dbd3fa1 | TSM | 2026-10-01 12:46 | call_diagonal_spread | 2 | 1 | 4 | 83532.00 | unknown | bid | 456.1350 | 4.8000 | ["320","435"] | ["0.3965","0.3495"] | [] | ["AMXO"] | 320.0000 | 435.0000 | 15 | 624 | false | false | true | ||||||||||
| 01a0f83f-9156-7043-a62d-80b06ea6a1b7 | TSM | 2026-10-01 12:15 | call_diagonal_spread | 2 | 2 | 2 | 26452.00 | long | bid | 455.1450 | 3.1500 | ["400","430"] | ["0.3464","0.3628"] | [] | ["XCBO","XISX"] | 400.0000 | 430.0000 | 106 | 169 | false | false | true | ||||||||||
| 01a0f838-ee1f-7703-9076-343bdcae6b0c | TSM | 2026-10-01 12:07 | call_diagonal_spread | 2 | 1 | 7 | 41013.00 | long | bid | 454.5700 | 4.6000 | ["425","427.5"] | ["0.7500","0.3458"] | [] | ["XMIO"] | 425.0000 | 427.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f830-a8ee-7ea3-a6ff-cc2c80c032d4 | TSM | 2026-10-01 11:58 | call_diagonal_spread | 2 | 2 | 5 | 28921.00 | long | bid | 454.3850 | 3.6000 | ["425","427.5"] | ["0.6181","0.3297"] | [] | ["XCBO","XISX"] | 425.0000 | 427.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f82e-91c7-7d20-82f1-2a8443f9a69d | TSM | 2026-10-01 11:56 | call_diagonal_spread | 2 | 2 | 2 | 29260.00 | short | ask | 454.8050 | 2.2000 | ["380","440"] | ["0.3597","0.3569"] | [] | ["XPHO"] | 380.0000 | 440.0000 | 141 | 169 | false | false | true | ||||||||||
| 01a0f820-93bf-7c80-b290-e222aa259993 | TSM | 2026-10-01 11:41 | call_diagonal_spread | 2 | 1 | 3 | 33930.00 | short | ask | 454.1400 | 1.4500 | ["410","440"] | ["0.3407","0.3618"] | [] | ["MCRY"] | 410.0000 | 440.0000 | 78 | 169 | false | false | true | ||||||||||
| 01a0f820-93bf-7c80-b290-e20cf891c13c | TSM | 2026-10-01 11:41 | call_diagonal_spread | 2 | 1 | 5 | 56530.00 | short | ask | 454.1400 | 1.8500 | ["410","440"] | ["0.3403","0.3616"] | [] | ["BATO"] | 410.0000 | 440.0000 | 78 | 169 | false | false | true | ||||||||||
| 01a0f80a-1dbf-7e41-ac90-300757927dcd | TSM | 2026-10-01 11:16 | call_diagonal_spread | 2 | 1 | 36 | 33732.00 | long | ask | 455.1300 | 0.5500 | ["490","495"] | ["0.3426","0.3385"] | [] | ["XMIO"] | 490.0000 | 495.0000 | 22 | 29 | false | true | true | ||||||||||
| 01a0f806-d1ff-7e60-bb88-23a0af88d178 | TSM | 2026-10-01 11:13 | call_diagonal_spread | 2 | 1 | 7 | 47110.00 | long | ask | 454.5000 | 1.2500 | ["435","440"] | ["0.3419","0.3366"] | [] | ["XISX"] | 435.0000 | 440.0000 | 29 | 78 | false | false | true | ||||||||||
| 01a0f804-2a4f-70e3-9c20-3657047ebcb6 | TSM | 2026-10-01 11:10 | call_diagonal_spread | 2 | 1 | 7 | 52661.00 | short | bid | 454.2000 | 3.2000 | ["425","440"] | ["0.3598","0.3438"] | [] | ["XISX"] | 425.0000 | 440.0000 | 29 | 78 | false | false | true | ||||||||||
| 01a0f803-5f2f-75f2-b8ce-1d72c94d9416 | TSM | 2026-10-01 11:09 | call_diagonal_spread | 2 | 1 | 21 | 27510.00 | short | bid | 454.2250 | 0.7500 | ["450","457.5"] | ["0.3892","0.3068"] | [] | ["XISX"] | 450.0000 | 457.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f803-1cc7-7493-9ee8-03219a85bb26 | TSM | 2026-10-01 11:09 | call_diagonal_spread | 2 | 1 | 3 | 59505.00 | long | ask | 454.3000 | 6.0500 | ["405","410"] | ["0.4729","0.4055"] | [] | ["XPHO"] | 405.0000 | 410.0000 | 15 | 806 | false | false | true | ||||||||||
| 01a0f802-f99f-7970-91cd-3f23e9a02b01 | TSM | 2026-10-01 11:08 | call_diagonal_spread | 2 | 1 | 3 | 59499.00 | long | ask | 454.2950 | 6.1000 | ["405","410"] | ["0.4732","0.4055"] | [] | ["XISX"] | 405.0000 | 410.0000 | 15 | 806 | false | false | true | ||||||||||
| 01a0f801-059e-7db3-8946-1b50bb6f67f9 | TSM | 2026-10-01 11:06 | call_diagonal_spread | 2 | 1 | 3 | 73269.00 | long | ask | 454.8400 | 4.8000 | ["350","390"] | ["0.4067","0.5102"] | [] | ["XPHO"] | 350.0000 | 390.0000 | 15 | 806 | false | false | true | ||||||||||
| 01a0f800-ee2f-7082-90be-4d4bb447a1c2 | TSM | 2026-10-01 11:06 | call_diagonal_spread | 2 | 1 | 3 | 73230.00 | short | bid | 454.9400 | 4.9000 | ["350","390"] | ["0.4056","0.4996"] | [] | ["XISX"] | 350.0000 | 390.0000 | 15 | 806 | false | false | true | ||||||||||
| 01a0f7f4-3847-7a40-b9b5-3dcac7dd5d44 | TSM | 2026-10-01 10:52 | call_diagonal_spread | 2 | 1 | 2 | 98280.00 | long | bid | 455.4700 | 6.8000 | ["120","400"] | ["0.9997","0.4041"] | [] | ["XMIO"] | 120.0000 | 400.0000 | 106 | 841 | false | false | true | ||||||||||
| 01a0f7ed-009e-7422-a10c-235556643d11 | TSM | 2026-10-01 10:44 | call_diagonal_spread | 2 | 1 | 10 | 41260.00 | long | bid | 456.1150 | 1.9500 | ["432.5","442.5"] | ["0.6414","0.3189"] | [] | ["XCBO"] | 432.5000 | 442.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f7ec-ed17-7a52-a44e-d19a79e1f805 | TSM | 2026-10-01 10:44 | call_diagonal_spread | 2 | 1 | 4 | 35024.00 | unknown | ask | 455.9407 | 1.9500 | ["440","540"] | ["0.3485","0.3921"] | [] | ["AMXO"] | 440.0000 | 540.0000 | 22 | 477 | false | false | true | ||||||||||
| 01a0f7e3-6f67-70a2-86eb-b2880b80e8a6 | TSM | 2026-10-01 10:34 | call_diagonal_spread | 2 | 1 | 8 | 33090.00 | long | bid | 456.2500 | 2.5500 | ["432.5","442.5"] | ["0.6015","0.3174"] | [] | ["XCBO"] | 432.5000 | 442.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f7e3-6f67-70a2-86eb-b279a44f1540 | TSM | 2026-10-01 10:34 | call_diagonal_spread | 2 | 3 | 12 | 49584.00 | long | bid | 456.2500 | 2.7500 | ["432.5","442.5"] | ["0.6049","0.3150"] | [] | ["ARCO","EMLD","SPHR"] | 432.5000 | 442.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a0f7b3-bc77-7f10-9027-1703f4e80fe9 | TSM | 2026-10-01 09:42 | call_diagonal_spread | 2 | 1 | 2 | 48956.00 | short | bid | 455.3100 | 6.2000 | ["380","390"] | ["0.3940","0.3942"] | [] | ["XCBO"] | 380.0000 | 390.0000 | 351 | 477 | false | false | true | ||||||||||
| 01a0f7a8-a0b7-7ca3-862f-8267ef3f148b | TSM | 2026-10-01 09:30 | call_diagonal_spread | 2 | 2 | 15 | 63810.00 | unknown | bid | 455.6400 | 4.7500 | ["437.5","442.5"] | ["0.3493","0.3636"] | [] | ["ARCO"] | 437.5000 | 442.5000 | 8 | 15 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T19:15:56Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T19:05:56Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:48:32Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:36:31Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:36:31Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:34:06Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:17:03Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:05:05Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:59:11Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:59:11Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:46:45Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:46:05Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:15:17Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:07:56Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:58:58Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:56:49Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:41:43Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:41:43Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:17:05Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:13:18Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:10:24Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:09:35Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:09:35Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:09:02Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:06:55Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T15:06:55Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:53:05Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:45:20Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:44:53Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:34:53Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:34:53Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:42:42Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:30:20Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |