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 |
|---|
| 01a0f8f4-5a97-7cc0-b55c-870bb8b71206 | TSM | 2026-10-01 15:32 | call_vertical_spread | 2 | 1 | 2 | 47998.00 | unknown | bid | 458.0550 | 6.1000 | ["450","520"] | ["0.4008","0.4007"] | ["605.00"] | ["XCBO"] | 450.0000 | 520.0000 | 841 | 841 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:33:03Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f8de-daaf-7eb1-bf48-46dda6443bcf | TSM | 2026-10-01 15:09 | call_vertical_spread | 2 | 1 | 10 | 59594.00 | short | bid | 458.6000 | 0.8500 | ["450","510"] | ["0.3501","0.3515"] | ["473.38"] | ["XCBO"] | 450.0000 | 510.0000 | 106 | 106 | false | false | false | ||||||||||
| 01a0f8dc-a05f-7160-a320-029571ebe4c5 | TSM | 2026-10-01 15:06 | call_vertical_spread | 2 | 1 | 6 | 30336.00 | short | bid | 458.3500 | 0.8000 | ["430","450"] | ["0.3664","0.3552"] | ["444.40"] | ["XCBO"] | 430.0000 | 450.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0f8cc-dd37-7831-b890-77965d7b626d | TSM | 2026-10-01 14:49 | call_vertical_spread | 2 | 1 | 5 | 65070.00 | short | bid | 458.9750 | 2.1500 | ["420","440"] | ["0.3665","0.3655"] | ["431.60"] | ["XCBO"] | 420.0000 | 440.0000 | 169 | 169 | false | false | false | ||||||||||
| 01a0f8bd-f4cf-7290-9c8e-ad320c4d90b5 | TSM | 2026-10-01 14:33 | call_vertical_spread | 2 | 2 | 14 | 28000.00 | unknown | ask | 459.2100 | 0.3000 | ["455","457.5"] | ["0.3035","0.3031"] | ["466.25"] | ["ARCO"] | 455.0000 | 457.5000 | 8 | 8 | false | false | false | ||||||||||
| 01a0f8bd-c207-7d21-baf5-1236c8fc4924 | TSM | 2026-10-01 14:32 | call_vertical_spread | 2 | 1 | 20 | 39880.00 | unknown | bid | 459.1500 | 0.3000 | ["455","457.5"] | ["0.3037","0.3032"] | ["466.22"] | ["XISX"] | 455.0000 | 457.5000 | 8 | 8 | false | false | false | ||||||||||
| 01a0f8a8-da77-77b0-8678-6dd5208b4276 | TSM | 2026-10-01 14:10 | call_vertical_spread | 2 | 1 | 20 | 36420.00 | short | bid | 457.8000 | 1.1500 | ["520","530"] | ["0.3409","0.3419"] | ["521.79"] | ["XCBO"] | 520.0000 | 530.0000 | 78 | 78 | false | true | false | ||||||||||
| 01a0f898-2907-7562-a85a-4d56f8e79262 | TSM | 2026-10-01 13:51 | call_vertical_spread | 2 | 1 | 3 | 55188.00 | long | ask | 459.8250 | 3.6500 | ["380","390"] | ["0.3732","0.3703"] | ["387.74"] | ["XMIO"] | 380.0000 | 390.0000 | 141 | 141 | false | false | false | ||||||||||
| 01a0f891-ef48-7a53-b08e-dcb2e61b5636 | TSM | 2026-10-01 13:45 | call_vertical_spread | 2 | 1 | 6 | 56466.00 | short | bid | 459.7700 | 1.6500 | ["460","470"] | ["0.3629","0.3630"] | ["464.55"] | ["XCBO"] | 460.0000 | 470.0000 | 169 | 169 | false | true | false | ||||||||||
| 01a0f887-c99e-7701-b611-2db5b0446da9 | TSM | 2026-10-01 13:34 | call_vertical_spread | 2 | 1 | 2 | 50976.00 | long | ask | 460.1125 | 7.5500 | ["460","470"] | ["0.3971","0.3971"] | ["463.98"] | ["XCBO"] | 460.0000 | 470.0000 | 841 | 841 | false | false | false | ||||||||||
| 01a0f877-a0e7-7890-b28a-b93a1f0815fc | TSM | 2026-10-01 13:16 | call_vertical_spread | 2 | 1 | 2 | 47126.00 | long | ask | 455.9600 | 7.0500 | ["450","520"] | ["0.3984","0.3968"] | ["476.35"] | ["BATO"] | 450.0000 | 520.0000 | 841 | 841 | false | false | false | ||||||||||
| 01a0f86e-e29f-7f63-801a-558b06d570ca | TSM | 2026-10-01 13:06 | call_vertical_spread | 2 | 1 | 4 | 60060.00 | short | bid | 455.8650 | 4.2000 | ["470","510"] | ["0.3884","0.3888"] | ["485.15"] | ["XMIO"] | 470.0000 | 510.0000 | 442 | 442 | false | true | false | ||||||||||
| 01a0f86e-2b06-7f70-93bd-ba531201a9fd | TSM | 2026-10-01 13:06 | call_vertical_spread | 2 | 2 | 14 | 95354.00 | short | bid | 456.0200 | 0.8000 | ["420","490"] | ["0.3378","0.3346"] | ["454.94"] | ["EDGO","XISX"] | 420.0000 | 490.0000 | 78 | 78 | false | false | false | ||||||||||
| 01a0f84b-fd07-7320-893a-5cbbf430a166 | TSM | 2026-10-01 12:28 | call_vertical_spread | 2 | 1 | 4 | 58340.00 | short | bid | 456.0500 | 2.9500 | ["330","445"] | ["0.8391","0.3665"] | ["435.75"] | ["EMLD"] | 330.0000 | 445.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0f805-08f7-70b1-b196-ef5a60fb7416 | TSM | 2026-10-01 11:11 | call_vertical_spread | 2 | 1 | 14 | 45906.00 | short | bid | 453.8600 | 0.4500 | ["440","470"] | ["0.3455","0.3415"] | ["454.65"] | ["XISX"] | 440.0000 | 470.0000 | 22 | 22 | false | false | false | ||||||||||
| 01a0f7ec-77e7-7610-9039-1f18eef7d274 | TSM | 2026-10-01 10:44 | call_vertical_spread | 2 | 1 | 9 | 54135.00 | unknown | — | 456.0200 | 0.7000 | ["440","450"] | ["0.3412","0.3399"] | [] | ["XMIO"] | 440.0000 | 450.0000 | 50 | 50 | false | false | false | true | false | ||||||||
| 01a0f7da-d447-7c40-b77e-bb62d0d97c1b | TSM | 2026-10-01 10:25 | call_vertical_spread | 2 | 1 | 9 | 39843.00 | long | ask | 456.0800 | 1.7000 | ["420","480"] | ["0.3839","0.3604"] | ["454.13"] | ["XCBO"] | 420.0000 | 480.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0f7da-053e-71b0-ba91-b975420febac | TSM | 2026-10-01 10:24 | call_vertical_spread | 2 | 1 | 2 | 83328.00 | unknown | bid | 455.7900 | 5.7000 | ["245","250"] | ["3.3588","3.2118"] | ["455.82"] | ["XCBO"] | 245.0000 | 250.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7d9-e9e7-7ad2-9171-6220778e1866 | TSM | 2026-10-01 10:24 | call_vertical_spread | 2 | 1 | 2 | 89248.00 | short | bid | 455.6300 | 4.7500 | ["230","235"] | ["7.1101","6.1322"] | ["235"] | ["XMIO"] | 230.0000 | 235.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7d6-01e6-7841-b559-b274b9903f8b | TSM | 2026-10-01 10:19 | call_vertical_spread | 2 | 1 | 3 | 92328.00 | short | bid | 455.4400 | 7.2500 | ["390","400"] | ["0.4038","0.4043"] | ["394.80"] | ["XISX"] | 390.0000 | 400.0000 | 806 | 806 | false | false | false | ||||||||||
| 01a0f7cd-c86f-77d1-85fb-d67755b65ce7 | TSM | 2026-10-01 10:10 | call_vertical_spread | 2 | 1 | 2 | 91584.00 | short | bid | 457.1175 | 6.1000 | ["225","230"] | ["6.8855","6.2201"] | ["230"] | ["XCBO"] | 225.0000 | 230.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7b0-3def-7150-9c76-de5d369c5d1e | TSM | 2026-10-01 09:38 | call_vertical_spread | 2 | 1 | 5 | 67990.00 | long | ask | 456.8600 | 5.1000 | ["370","410"] | ["0.6399","0.3687"] | ["408.88"] | ["XISX"] | 370.0000 | 410.0000 | 15 | 15 | false | false | false |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T19:09:11Z"} |
| 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-01T19:07:24Z"} |
| 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-01T18:50:07Z"} |
| 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:33:29Z"} |
| 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:33:29Z"} |
| 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-01T18:10:26Z"} |
| 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-01T17:52:20Z"} |
| 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-01T17:45:31Z"} |
| 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-01T17:34:21Z"} |
| 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:16: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-01T17:06:50Z"} |
| 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:06:04Z"} |
| 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:29:04Z"} |
| 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:11:13Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:44:28Z"} |
| 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:25:29Z"} |
| 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:24:23Z"} |
| 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:24:23Z"} |
| 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:20:01Z"} |
| 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:11:15Z"} |
| 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:38:51Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |