core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08773-86d9-77f0-87bc-12667c99938e | XLE | 2026-09-09 14:34 | call_vertical_spread | 2 | 1 | 18 | 33012.00 | unknown | — | 65.3350 | 0.3000 | ["55","57.5"] | ["0.5284","0.4049"] | [] | ["XCBO"] | 55.0000 | 57.5000 | 9 | 9 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:34:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08742-2251-7a92-96b6-c325722bf042 | XLE | 2026-09-09 13:40 | call_diagonal_spread | 2 | 1 | 14 | 35728.00 | unknown | — | 65.4100 | 1.0500 | ["50","57.5"] | ["0.3077","0.2074"] | [] | ["XMIO"] | 50.0000 | 57.5000 | 128 | 203 | false | false | true | true | false | mlet | |||||||
| 01a0826a-28b8-7990-b9d5-837999bb1a37 | XLE | 2026-09-08 15:06 | put_diagonal_spread | 2 | 1 | 92 | 67252.00 | unknown | — | 64.8500 | 0.4100 | ["60","63"] | ["0.2697","0.2792"] | [] | ["EDGO"] | 60.0000 | 63.0000 | 192 | 374 | false | true | true | true | false | mlet | |||||||
| 01a081f7-2369-7393-a6f4-66e268c4ffb0 | XLE | 2026-09-08 13:00 | call_vertical_spread | 2 | 1 | 15000 | 21450000.00 | unknown | — | 64.6050 | 0.3000 | ["55","65"] | ["0.1777","0.2320"] | [] | ["AMXO"] | 55.0000 | 65.0000 | 129 | 129 | false | false | false | true | false | mlct | |||||||
| 01a081ae-a8b8-7423-af61-052ae4005798 | XLE | 2026-09-08 11:41 | other | 2 | 1 | 22 | 53350.00 | unknown | — | 64.7800 | 1.9000 | ["52.5","53"] | ["0.7851","0.4630"] | [] | ["BATO"] | 52.5000 | 53.0000 | 10 | 45 | false | false | true | true | false | mlet | |||||||
| 01a08192-7210-7473-94c4-63d309e82c08 | XLE | 2026-09-08 11:10 | other | 2 | 1 | 180 | 25920.00 | unknown | — | 64.8750 | 0.0700 | ["62","63"] | ["0.2504","0.2710"] | [] | ["XMIO"] | 62.0000 | 63.0000 | 8 | 38 | false | true | true | true | false | mlet | |||||||
| 01a0818a-e091-7a72-b8c2-8d9cc94c9439 | XLE | 2026-09-08 11:02 | other | 2 | 1 | 10 | 32590.00 | unknown | — | 64.8150 | 1.7000 | ["50"] | ["0.2614"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 101 | 465 | false | false | true | false | false | mlet | |||||||
| 01a08180-b319-76c3-90e1-1a7a64940595 | XLE | 2026-09-08 10:51 | call_vertical_spread | 2 | 1 | 30 | 49800.00 | unknown | — | 64.9950 | 0.7000 | ["55","60"] | ["0.2672","0.2350"] | [] | ["XCBO"] | 55.0000 | 60.0000 | 73 | 73 | false | false | false | true | false | mlat | |||||||
| 01a08177-d1a8-7253-9a9a-bddd61407925 | XLE | 2026-09-08 10:41 | call_vertical_spread | 2 | 1 | 1000 | 1061000.00 | unknown | — | 65.1900 | 0.4000 | ["59","61"] | ["0.3085","0.2669"] | [] | ["XMIO"] | 59.0000 | 61.0000 | 10 | 10 | false | false | false | true | false | mlat | |||||||
| 01a0815f-92a1-7722-ba0c-17151c4cdc62 | XLE | 2026-09-08 10:15 | call_diagonal_spread | 2 | 1 | 40 | 86040.00 | unknown | — | 65.1600 | 1.4500 | ["55","57"] | ["0.1656","0.1857"] | [] | ["XMIO"] | 55.0000 | 57.0000 | 192 | 204 | false | false | true | true | false | mlet | |||||||
| 01a0815e-8900-7a01-af68-d9856ee83166 | XLE | 2026-09-08 10:14 | other | 2 | 1 | 189 | 113589.00 | unknown | — | 65.1700 | 0.3300 | ["62.5","64"] | ["0.2699","0.2720"] | [] | ["XMIO"] | 62.5000 | 64.0000 | 101 | 192 | false | true | true | true | false | mlat | |||||||
| 01a08147-76c0-7fb2-be64-89ffcb5d1b8b | XLE | 2026-09-08 09:48 | call_vertical_spread | 2 | 1 | 30 | 92160.00 | unknown | — | 64.9300 | 0.7000 | ["47.5","52.5"] | ["0.3397","0.1789"] | [] | ["XCBO"] | 47.5000 | 52.5000 | 129 | 129 | false | false | false | true | false | mlat | |||||||
| 01a06e01-fe65-7063-b198-81807fc29d86 | XLE | 2026-09-04 16:00 | other | 2 | 2 | 10000 | 708000.00 | unknown | — | 64.0600 | 0.4700 | ["63","65"] | ["0.1910","29.7806"] | [] | ["AMXO"] | 63.0000 | 65.0000 | 0 | 5 | false | false | true | true | false | mlft | |||||||
| 01a06dd9-061d-7b90-99c9-057f23401c71 | XLE | 2026-09-04 15:15 | other | 2 | 7 | 102 | 27836.00 | unknown | — | 63.9850 | 0.0500 | ["52.5","55"] | ["0.4474","0.2681"] | [] | ["AMXO","ARCO","BATO","EDGO","MCRY","XPHO"] | 52.5000 | 55.0000 | 14 | 469 | false | true | true | true | false | mesl | |||||||
| 01a06d46-3fe5-7ab1-84f5-dc5a0dda692e | XLE | 2026-09-04 12:35 | other | 2 | 4 | 76 | 33646.00 | unknown | — | 64.0850 | 0.2600 | ["57.5","60"] | ["0.2861","0.2678"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 57.5000 | 60.0000 | 14 | 469 | false | true | true | true | false | mlet | |||||||
| 01a06d45-7c95-7d32-96e9-32f71cb9cf0e | XLE | 2026-09-04 12:34 | other | 2 | 3 | 106 | 36781.00 | unknown | — | 64.0950 | 0.2200 | ["54","57.5"] | ["0.3778","0.2668"] | [] | ["EDGO","XBOX","XISX"] | 54.0000 | 57.5000 | 14 | 469 | false | true | true | true | false | mlet | |||||||
| 01a06d44-d49d-7ed2-9fe0-e43ad4de0778 | XLE | 2026-09-04 12:33 | other | 2 | 1 | 108 | 47898.00 | unknown | — | 64.1100 | 0.2600 | ["57.5","60"] | ["0.2840","0.2684"] | [] | ["EDGO"] | 57.5000 | 60.0000 | 14 | 469 | false | true | true | true | false | mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:41:16Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:06:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:01:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:41:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:11:10Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:02:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:51:30Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:42:14Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:15:28Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:14:20Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:49:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T20:00:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:35:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:34:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:34:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |