core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0f2b6-29df-7921-8905-f829d4e94315 | NVDL | 2026-09-30 10:26 | call_diagonal_spread | 2 | 1 | 51 | 220932.00 | short | ask | 37.6000 | 3.6500 | ["18.33","20"] | ["0.6353","0.5301"] | [] | ["XCBO"] | 18.3300 | 20.0000 | 478 | 842 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T14:27:19Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f2b6-29df-7921-8905-f8193d7374d6 | NVDL | 2026-09-30 10:26 | call_diagonal_spread | 2 | 1 | 77 | 334642.00 | short | ask | 37.6000 | 3.9000 | ["18.33","20"] | ["0.6467","0.5374"] | [] | ["BATO"] | 18.3300 | 20.0000 | 478 | 842 | false | false | |||||||||||
| 01a0f2b2-9f9f-7292-b64f-aa214c5785a1 | NVDL | 2026-09-30 10:23 | call_vertical_spread | 2 | 1 | 584 | 112712.00 | short | bid | 37.6000 | 0.4700 | ["55","60"] | ["0.6476","0.6452"] | ["55.45"] | ["XMIO"] | 55.0000 | 60.0000 | 107 | 107 | false | true | |||||||||||
| 01a0ed9d-b476-7f12-ab96-e11a51665550 | NVDL | 2026-09-29 10:42 | call_diagonal_spread | 2 | 1 | 34 | 108460.00 | short | bid | 37.6050 | 0.9000 | ["29","31.67"] | ["0.5924","0.6471"] | [] | ["XMIO"] | 29.0000 | 31.6700 | 479 | 843 | false | false | |||||||||||
| 01a0ed9c-06c7-7f41-96fe-c23853a4ebce | NVDL | 2026-09-29 10:40 | call_diagonal_spread | 2 | 1 | 44 | 144760.00 | short | bid | 37.5200 | 4.4500 | ["29","30"] | ["0.5828","0.6870"] | [] | ["XPHO"] | 29.0000 | 30.0000 | 479 | 843 | false | false | |||||||||||
| 01a0e8fe-8206-79b2-a8a2-4b8bd4ba22c9 | NVDL | 2026-09-28 13:09 | put_calendar | 2 | 1 | 45 | 117945.00 | short | ask | 37.3850 | 3.4500 | ["50"] | ["0.7496"] | [] | ["XMIO"] | 50.0000 | 50.0000 | 32 | 53 | false | false | |||||||||||
| 01a0ca8a-6556-74b0-8e7f-5e7ffa3f28dc | NVDL | 2026-09-22 15:14 | call_diagonal_spread | 2 | 1 | 149 | 199064.00 | short | bid | 37.1727 | 0.5000 | ["35","37"] | ["0.6787","0.6703"] | [] | ["XPHO"] | 35.0000 | 37.0000 | 87 | 178 | false | false | |||||||||||
| 01a0c557-d06f-7251-a75f-6300ddeead22 | NVDL | 2026-09-21 15:00 | put_diagonal_spread | 2 | 1 | 450 | 172350.00 | short | bid | 36.5850 | 0.5600 | ["36","37"] | ["0.6350","0.6183"] | [] | ["XCBO"] | 36.0000 | 37.0000 | 11 | 25 | false | false | |||||||||||
| 01a0c535-19b7-7f90-bdd5-344864e0d992 | NVDL | 2026-09-21 14:23 | call_calendar | 2 | 1 | 55 | 158730.00 | short | bid | 36.5200 | 1.3000 | ["25"] | ["0.6260"] | [] | ["XPHO"] | 25.0000 | 25.0000 | 116 | 487 | false | false | |||||||||||
| 01a0b60a-11ef-7111-a53e-733cb12f4fae | NVDL | 2026-09-18 15:41 | call_diagonal_spread | 2 | 1 | 200 | 673200.00 | short | ask | 34.1200 | 0.8000 | ["15","20"] | ["76.0529","0.6934"] | [] | ["XMIO"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b524-7898-7f42-8304-07c6ef40a2ea | NVDL | 2026-09-18 11:30 | call_diagonal_spread | 2 | 1 | 33 | 116358.00 | short | ask | 34.1350 | 1.1500 | ["13.33","20"] | ["24.1003","0.6537"] | [] | ["XISX"] | 13.3300 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4fe-108f-7b10-82d4-e1fe934e66c4 | NVDL | 2026-09-18 10:49 | call_diagonal_spread | 2 | 1 | 67 | 237046.00 | short | ask | 34.0350 | 1.3500 | ["13.33","20"] | ["20.0104","0.7549"] | [] | ["XISX"] | 13.3300 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4fc-f750-7e52-805c-5888a53f3657 | NVDL | 2026-09-18 10:47 | call_diagonal_spread | 2 | 1 | 110 | 389070.00 | short | ask | 33.9603 | 1.3500 | ["13.33","20"] | ["21.7014","0.7920"] | [] | ["XPHO"] | 13.3300 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4de-5b5f-7853-b78e-04cdc97d38fc | NVDL | 2026-09-18 10:14 | call_diagonal_spread | 2 | 1 | 30 | 101340.00 | short | ask | 34.4650 | 1.4500 | ["15","20"] | ["16.4010","0.7380"] | [] | ["AMXO"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4de-5b5f-7853-b78e-04b6ab5e30cf | NVDL | 2026-09-18 10:14 | call_diagonal_spread | 2 | 2 | 60 | 202680.00 | short | ask | 34.4650 | 1.4500 | ["15","20"] | ["16.4010","0.7380"] | [] | ["AMXO"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4de-5b5f-7853-b78e-04a76c34a432 | NVDL | 2026-09-18 10:14 | call_diagonal_spread | 2 | 2 | 60 | 202680.00 | short | ask | 34.4650 | 1.4500 | ["15","20"] | ["16.4010","0.7380"] | [] | ["AMXO","XISX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4dd-ee00-7273-ae06-b8879cde6532 | NVDL | 2026-09-18 10:13 | call_diagonal_spread | 2 | 1 | 150 | 506400.00 | short | ask | 34.4350 | 1.4000 | ["15","20"] | ["15.7028","0.7549"] | [] | ["XISX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4d9-812f-76a0-801f-5d756247ab7d | NVDL | 2026-09-18 10:09 | call_diagonal_spread | 2 | 1 | 30 | 100410.00 | short | ask | 34.1099 | 0.8000 | ["15","20"] | ["16.2721","0.6237"] | [] | ["C2OX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4d9-1b9f-7963-b82f-327c1dd6cfed | NVDL | 2026-09-18 10:08 | call_diagonal_spread | 2 | 1 | 30 | 100410.00 | short | ask | 34.1076 | 0.8000 | ["15","20"] | ["16.3285","0.6257"] | [] | ["C2OX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4d9-17b8-71c2-89a0-5b14f46c3a43 | NVDL | 2026-09-18 10:08 | call_diagonal_spread | 2 | 1 | 30 | 100410.00 | short | ask | 34.1076 | 0.8000 | ["15","20"] | ["16.3285","0.6257"] | [] | ["C2OX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4d9-17b8-71c2-89a0-5b013c8b2228 | NVDL | 2026-09-18 10:08 | call_diagonal_spread | 2 | 1 | 30 | 100350.00 | short | ask | 34.1076 | 0.8000 | ["15","20"] | ["16.3285","0.6166"] | [] | ["XISX"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b4d9-17b8-71c2-89a0-5afeef5464f7 | NVDL | 2026-09-18 10:08 | call_diagonal_spread | 2 | 1 | 30 | 100350.00 | short | ask | 34.1076 | 0.8000 | ["15","20"] | ["16.3285","0.6166"] | [] | ["XPHO"] | 15.0000 | 20.0000 | 0 | 91 | false | false | |||||||||||
| 01a086b9-4ef8-7822-92cc-2df3468cdfa3 | NVDL | 2026-09-09 11:11 | put_calendar | 2 | 1 | 200 | 142800.00 | short | bid | 35.6900 | 0.4000 | ["39"] | ["0.8125"] | [] | ["EDGO"] | 39.0000 | 39.0000 | 2 | 9 | false | false | |||||||||||
| 01a086b9-2fb9-7913-908a-f20bdb4d7426 | NVDL | 2026-09-09 11:11 | put_calendar | 2 | 1 | 200 | 143200.00 | short | bid | 35.7000 | 0.1000 | ["39"] | ["0.8358"] | [] | ["MCRY"] | 39.0000 | 39.0000 | 2 | 9 | false | false | |||||||||||
| 01a086b9-1078-7d43-b969-0a1a8c33edd7 | NVDL | 2026-09-09 11:11 | put_calendar | 2 | 1 | 200 | 144000.00 | short | bid | 35.7000 | 0.7500 | ["39"] | ["0.8763"] | [] | ["C2OX"] | 39.0000 | 39.0000 | 2 | 9 | false | false | |||||||||||
| 01a086b8-9f30-7e21-b3c8-2f8b1bf322f8 | NVDL | 2026-09-09 11:10 | put_calendar | 2 | 1 | 200 | 143800.00 | short | bid | 35.7600 | 0.7500 | ["39"] | ["0.9639"] | [] | ["SPHR"] | 39.0000 | 39.0000 | 2 | 9 | false | false | |||||||||||
| 01a06dfa-130d-70c2-8530-44cd7443dc6d | NVDL | 2026-09-04 15:51 | call_diagonal_spread_bearish | 2 | 1 | 300 | 108900.00 | short | bid | 37.8050 | 0.2400 | ["39","40"] | ["0.6334","0.6380"] | [] | ["XISX"] | 39.0000 | 40.0000 | 21 | 28 | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T14:27:19Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T14:23:13Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:42:51Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:40:30Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:09:56Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:14:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:01:21Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:23:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:41:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:31:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:49:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:48:18Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:14:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:14:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:14:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:14:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:09:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:08:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:11:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:11:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:11:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:10:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:51:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |