core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d3b7-789f-71e1-8073-c9fb8c9d2b0a | DIA | 2026-09-24 10:00 | call_vertical_spread | 2 | 1 | 150 | 46050.00 | long | ask | 512.6800 | 0.2200 | ["518","520"] | ["0.1233","0.1224"] | ["518.55"] | ["XMIO"] | 518.0000 | 520.0000 | 8 | 8 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T14:00:16Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf35-ad87-7132-b1ac-c98cf8e6d9d3 | DIA | 2026-09-23 12:59 | call_vertical_spread | 2 | 1 | 8 | 27576.00 | long | ask | 514.6600 | 7.2000 | ["515","560"] | ["0.1413","0.1304"] | ["534.13"] | ["XCBO"] | 515.0000 | 560.0000 | 189 | 189 | false | true | false | ||||||||||
| 01a0cec6-2e8f-7442-8f78-aa5202971b1d | DIA | 2026-09-23 10:58 | call_vertical_spread | 2 | 1 | 683 | 65460.00 | unknown | ask | 516.4100 | 0.1200 | ["529","531"] | ["0.1223","0.1247"] | ["529.96"] | ["XBOX"] | 529.0000 | 531.0000 | 9 | 9 | false | true | false | ||||||||||
| 01a0caa3-c956-7690-a06b-8745e15ce5ca | DIA | 2026-09-22 15:42 | call_vertical_spread | 2 | 1 | 38 | 191140.00 | long | ask | 518.7700 | 2.8500 | ["495","570"] | ["0.1499","0.1319"] | ["531.80"] | ["XISX"] | 495.0000 | 570.0000 | 190 | 190 | false | false | false | ||||||||||
| 01a0caa2-ac2f-7c81-8226-bd23ce794a41 | DIA | 2026-09-22 15:40 | call_vertical_spread | 2 | 1 | 19 | 82574.00 | long | ask | 518.9250 | 2.9500 | ["505","570"] | ["0.1475","0.1327"] | ["534.70"] | ["XISX"] | 505.0000 | 570.0000 | 190 | 190 | false | false | false | ||||||||||
| 01a0caa0-ac77-7bb2-a111-75b7fec128b2 | DIA | 2026-09-22 15:38 | call_vertical_spread | 2 | 1 | 19 | 86526.00 | long | ask | 518.8900 | 2.8500 | ["505","560"] | ["0.1464","0.1317"] | ["532.30"] | ["XISX"] | 505.0000 | 560.0000 | 190 | 190 | false | false | false | ||||||||||
| 01a0c972-521f-7ab3-9fe2-19a0771dfc45 | DIA | 2026-09-22 10:08 | call_vertical_spread | 2 | 1 | 100 | 51300.00 | unknown | ask | 518.7900 | 0.2700 | ["518","520"] | ["0.1388","0.1334"] | ["521.56"] | ["XCBO"] | 518.0000 | 520.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c972-4e36-73a2-bbe9-23c8668ec41b | DIA | 2026-09-22 10:08 | call_vertical_spread | 2 | 1 | 50 | 25550.00 | long | ask | 518.8100 | 0.2700 | ["518","520"] | ["0.1377","0.1324"] | ["519.09"] | ["XISX"] | 518.0000 | 520.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c972-4e36-73a2-bbe9-23ba1b9c78f4 | DIA | 2026-09-22 10:08 | call_vertical_spread | 2 | 2 | 100 | 51100.00 | long | ask | 518.8100 | 0.2700 | ["518","520"] | ["0.1377","0.1324"] | ["519.09"] | ["XISX"] | 518.0000 | 520.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c549-3240-7e20-8c14-e4619232e068 | DIA | 2026-09-21 14:45 | call_vertical_spread | 2 | 6 | 60 | 111368.00 | long | ask | 520.2300 | 0.7500 | ["530","560"] | ["0.1329","0.1269"] | ["540"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 530.0000 | 560.0000 | 116 | 116 | false | true | false | ||||||||||
| 01a0c45e-ed97-77c0-9e73-ddbc3cc1da1d | DIA | 2026-09-21 10:29 | call_vertical_spread | 2 | 1 | 90 | 37440.00 | long | ask | 518.3300 | 0.2300 | ["518","523"] | ["0.1314","0.1236"] | ["520.10"] | ["XISX"] | 518.0000 | 523.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0b031-32fb-77f2-bb3f-ee8983255958 | DIA | 2026-09-17 12:26 | call_vertical_spread | 2 | 1 | 7 | 33040.00 | long | ask | 518.9000 | 6.9000 | ["520","525"] | ["0.1353","0.1309"] | ["523.30"] | ["ARCO"] | 520.0000 | 525.0000 | 183 | 183 | false | true | false | ||||||||||
| 01a0a571-7ca6-7503-a9a4-5f8f899c9c7b | DIA | 2026-09-15 10:21 | call_vertical_spread | 2 | 1 | 20 | 31060.00 | long | ask | 520.0000 | 0.5500 | ["530","535"] | ["0.1307","0.1279"] | ["532.09"] | ["XISX"] | 530.0000 | 535.0000 | 66 | 66 | false | true | false | ||||||||||
| 01a0a554-730e-71c2-892a-a02d8d110635 | DIA | 2026-09-15 09:49 | call_vertical_spread | 2 | 2 | 500 | 113000.00 | long | ask | 521.1395 | 0.3200 | ["540","550"] | ["0.1170","0.1180"] | ["541.10"] | ["XCBO"] | 540.0000 | 550.0000 | 31 | 31 | false | true | false | ||||||||||
| 01a0a554-730e-71c2-892a-a01deb094249 | DIA | 2026-09-15 09:49 | call_vertical_spread | 2 | 2 | 1000 | 222000.00 | long | ask | 521.1395 | 0.3200 | ["540","550"] | ["0.1165","0.1170"] | ["541.10"] | ["AMXO"] | 540.0000 | 550.0000 | 31 | 31 | false | true | false | ||||||||||
| 01a09211-f4d0-77f1-b5b8-571966d75abd | DIA | 2026-09-11 16:04 | call_vertical_spread | 2 | 1 | 100 | 28700.00 | long | ask | 525.8600 | 0.5900 | ["524","525"] | ["1.0761","0.5564"] | [] | ["EMLD"] | 524.0000 | 525.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a087c0-b4a8-74a1-9649-20b404af1baf | DIA | 2026-09-09 15:59 | call_vertical_spread | 2 | 1 | 50 | 102650.00 | long | ask | 524.2100 | 0.5500 | ["530","535"] | ["0.1321","0.1295"] | ["532.39"] | ["XISX"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a087b8-9689-71f0-bc3a-fd7307e65c92 | DIA | 2026-09-09 15:50 | call_vertical_spread | 2 | 1 | 50 | 103250.00 | long | ask | 524.4000 | 0.5000 | ["530","535"] | ["0.1318","0.1292"] | ["532.41"] | ["XISX"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a087b4-cdc8-78a3-b39b-ccff18c72090 | DIA | 2026-09-09 15:46 | call_vertical_spread | 2 | 1 | 50 | 104000.00 | long | ask | 524.5700 | 0.4000 | ["530","535"] | ["0.1318","0.1292"] | ["532.42"] | ["XISX"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a087b0-2660-7040-b338-d6826649dcb4 | DIA | 2026-09-09 15:41 | call_vertical_spread | 2 | 1 | 50 | 104450.00 | long | ask | 524.7400 | 0.6000 | ["530","535"] | ["0.1314","0.1288"] | ["532.43"] | ["XPHO"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a087ad-d888-7912-852e-4ed37323b5d2 | DIA | 2026-09-09 15:38 | call_vertical_spread | 2 | 1 | 50 | 104550.00 | long | ask | 524.7700 | 0.6000 | ["530","535"] | ["0.1314","0.1288"] | ["532.43"] | ["XCBO"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a0827e-a6d0-7ac2-b9b0-772d1335eaf9 | DIA | 2026-09-08 15:28 | call_vertical_spread | 2 | 1 | 10 | 96950.00 | long | ask | 528.4500 | 4.6000 | ["525","535"] | ["0.1576","0.1541"] | ["531.15"] | ["XISX"] | 525.0000 | 535.0000 | 465 | 465 | false | false | false | ||||||||||
| 01a08167-2bf0-7e01-99d5-9ab138063624 | DIA | 2026-09-08 10:23 | call_vertical_spread | 2 | 1 | 60 | 218040.00 | long | ask | 527.6100 | 0.5000 | ["500","520"] | ["0.3149","0.1629"] | ["519.52"] | ["XISX"] | 500.0000 | 520.0000 | 3 | 3 | true | false | false |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:00:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:58:08Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:41:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:38:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:45:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:29:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:27:05Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:21:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:49:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:49:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T20:04:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:59:07Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:50:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:46:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:41:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:29:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:23:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |