core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0c4ef-df0e-7d31-a82a-f2f3e605e6c5 | BURL | 2026-09-21 13:07 | call_diagonal_spread | 2 | 1 | 285 | 173850.00 | long | ask | 248.8100 | 4.7000 | ["265","285"] | ["0.3894","0.4595"] | [] | ["XBOX"] | 265.0000 | 285.0000 | 11 | 32 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:07:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d7-0f57-7782-93b5-e51e723580e8 | BURL | 2026-09-18 14:46 | put_vertical_spread | 2 | 1 | 3000 | 29970000.00 | unknown | ask | 238.2750 | 7.2000 | ["285","290"] | ["0.6408","0.6877"] | ["237.55"] | ["XPHO"] | 285.0000 | 290.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a0b51e-a84f-7931-a42a-a6d72322dae5 | BURL | 2026-09-18 11:24 | put_diagonal_spread | 2 | 1 | 250 | 195000.00 | unknown | bid | 237.8600 | 0.9500 | ["230","240"] | ["0.3589","0.2895"] | [] | ["SPHR"] | 230.0000 | 240.0000 | 0 | 28 | false | false | true | true | |||||||||
| 01a0b0ee-ed4b-7cd1-9227-2f78289f0870 | BURL | 2026-09-17 15:54 | put_diagonal_spread | 2 | 1 | 2100 | 26754000.00 | unknown | — | 239.5900 | 6.1000 | ["295","310"] | ["0.7064","0.6410"] | [] | ["XPHO"] | 295.0000 | 310.0000 | 15 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b0b2-49db-7b63-9dca-60308c9f50c6 | BURL | 2026-09-17 14:47 | other | 3 | 1 | 1158 | 12588900.00 | unknown | — | 238.9700 | 12.3000 | ["280","310","335"] | ["2.5914","0.7387","4.4758"] | [] | ["XBOX"] | 280.0000 | 335.0000 | 1 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b0af-2913-79a2-96f7-f4ed406059a5 | BURL | 2026-09-17 14:44 | put_vertical_spread | 2 | 1 | 254 | 1503680.00 | unknown | — | 239.0600 | 6.4000 | ["260","280"] | ["1.3780","2.5832"] | [] | ["XBOX"] | 260.0000 | 280.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0a5-b332-72b1-ac63-b0e590b2ef0f | BURL | 2026-09-17 14:34 | put_diagonal_spread | 2 | 1 | 1500 | 16470000.00 | unknown | — | 239.6550 | 7.1000 | ["280","310"] | ["2.1849","0.4979"] | [] | ["XPHO"] | 280.0000 | 310.0000 | 1 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b0a1-715b-75c2-8e94-e3e67c1c1f52 | BURL | 2026-09-17 14:29 | other | 4 | 1 | 2168 | 24636400.00 | unknown | — | 240.1800 | 15.1000 | ["280","295","310","335"] | ["2.3843","3.1420","0.7155","4.3785"] | [] | ["XBOX"] | 280.0000 | 335.0000 | 1 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b0a0-f073-7490-bf6b-0af6e7444631 | BURL | 2026-09-17 14:28 | put_ladder | 3 | 1 | 13 | 144536.00 | unknown | — | 240.0300 | 11.3000 | ["280","300","310"] | ["2.2726","3.2647","3.5950"] | [] | ["XBOX"] | 280.0000 | 310.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b079-d8a3-7543-8653-5782aa56e726 | BURL | 2026-09-17 13:46 | put_diagonal_spread | 2 | 1 | 250 | 142500.00 | long | ask | 240.5800 | 2.0000 | ["235","240"] | ["0.4008","0.5566"] | [] | ["XBOX"] | 235.0000 | 240.0000 | 1 | 8 | false | true | true | true | false | ||||||||
| 01a0a669-f21e-78d3-b41a-309aa9c27e21 | BURL | 2026-09-15 14:52 | put_diagonal_spread | 2 | 1 | 1000 | 13446000.00 | unknown | — | 227.7000 | 6.7000 | ["280","310"] | ["0.8442","0.6330"] | [] | ["XPHO"] | 280.0000 | 310.0000 | 3 | 31 | false | false | true | true | false | mlft | |||||||
| 01a08cb6-e4a0-7df0-9b02-2e801678b672 | BURL | 2026-09-10 15:06 | other | 6 | 1 | 379 | 5704240.00 | unknown | — | 237.8800 | 23.6000 | ["295","305","310","312.5","335","370"] | ["0.8784","3.4204","0.6721","3.5604","1.6395","0.6339"] | [] | ["XBOX"] | 295.0000 | 370.0000 | 1 | 127 | false | false | true | true | false | mlft |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:25:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:54:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:48:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:44:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:34:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:29:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:29:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:46:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:06:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |