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 |
|---|
| 01a06dd2-2465-7222-babc-1ffe45b40eb9 | DE | 2026-09-04 15:08 | call_diagonal_spread_bearish | 2 | 1 | 5 | 84900.00 | short | ask | 694.3500 | 13.4000 | ["600","740"] | ["0.4742","0.3375"] | [] | ["XISX"] | 600.0000 | 740.0000 | 14 | 286 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:08:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd0-4006-74d0-a1d9-db8dbc5bc4a5 | DE | 2026-09-04 15:05 | call_diagonal_spread_bearish | 2 | 1 | 3 | 48147.00 | long | bid | 694.2200 | 10.0000 | ["612.5","617.5"] | ["7.2480","0.4880"] | [] | ["XCBO"] | 612.5000 | 617.5000 | 0 | 7 | false | false | true | true | |||||||||
| 01a06dbb-21c5-7cf1-a13b-c957e4cb567a | DE | 2026-09-04 14:42 | other | 4 | 1 | 7 | 48832.00 | unknown | — | 694.7650 | 10.1000 | ["675","680","695","700"] | ["0.2979","0.2923","0.2393","0.2439"] | [] | ["EDGO"] | 675.0000 | 700.0000 | 7 | 14 | false | false | true | true | false | mlet | |||||||
| 01a06da5-b94d-7200-966e-414d54d51b40 | DE | 2026-09-04 14:19 | synthetic | 2 | 3 | 6 | 87474.00 | long | bid | 694.7100 | 2.3000 | ["740"] | ["0.3480"] | ["709.36"] | ["ARCO","XISX","XPHO"] | 740.0000 | 740.0000 | 196 | 196 | false | false | false | false | true | ||||||||
| 01a06d98-76c5-7890-bca5-4e637cb42ed1 | DE | 2026-09-04 14:05 | synthetic | 2 | 1 | 7 | 101892.00 | long | bid | 695.6000 | 3.3000 | ["740"] | ["0.3475"] | ["709.80"] | ["ARCO"] | 740.0000 | 740.0000 | 196 | 196 | false | false | false | false | true | ||||||||
| 01a06d98-76c5-7890-bca5-4e59475a242b | DE | 2026-09-04 14:05 | synthetic | 2 | 1 | 2 | 29112.00 | short | ask | 695.6000 | 5.0000 | ["740"] | ["0.3475"] | ["707"] | ["ARCO"] | 740.0000 | 740.0000 | 196 | 196 | false | false | false | false | true | ||||||||
| 01a06d95-4e2d-7150-b3ff-0058fa1a1176 | DE | 2026-09-04 14:01 | other | 4 | 1 | 4 | 136259.00 | unknown | — | 695.0750 | 21.4000 | ["550","560","750","820"] | ["0.3516","0.3477","0.2772","0.3413"] | [] | ["SPHR"] | 550.0000 | 820.0000 | 7 | 196 | false | false | true | true | false | mlet | |||||||
| 01a06d87-ffed-7a90-8b97-63332d706e8c | DE | 2026-09-04 13:47 | call_diagonal_spread_bearish | 2 | 1 | 5 | 51250.00 | long | ask | 694.4600 | 14.0000 | ["645","650"] | ["0.3666","0.3280"] | [] | ["XPHO"] | 645.0000 | 650.0000 | 7 | 21 | false | false | true | true | |||||||||
| 01a06d68-893d-7393-b058-dd6dc7a6ac43 | DE | 2026-09-04 13:12 | call_calendar | 2 | 1 | 2 | 28960.00 | short | ask | 696.8300 | 10.6000 | ["625"] | ["1.7334"] | [] | ["XMIO"] | 625.0000 | 625.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a06d56-9396-7943-b2af-dc3844bc3c67 | DE | 2026-09-04 12:53 | call_vertical_spread | 2 | 1 | 5 | 37585.00 | short | bid | 699.3350 | 6.8000 | ["660","675"] | ["0.3062","0.2905"] | ["672.35"] | ["BATO"] | 660.0000 | 675.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06d53-632e-7262-aed8-0c721d01577d | DE | 2026-09-04 12:49 | other | 3 | 1 | 5 | 43054.00 | unknown | — | 699.5700 | 8.1500 | ["655","660","720"] | ["1.8676","0.2674","0.2497"] | [] | ["EDGO"] | 655.0000 | 720.0000 | 0 | 7 | false | false | true | true | false | mlet | |||||||
| 01a06d23-2b6d-74e0-91c5-ed0fcc18feaa | DE | 2026-09-04 11:56 | call_vertical_spread | 2 | 1 | 6 | 47424.00 | long | ask | 698.5000 | 6.1000 | ["650","680"] | ["0.3095","0.2921"] | ["674.34"] | ["EDGO"] | 650.0000 | 680.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06d23-2b6d-74e0-91c5-ece3f6d74048 | DE | 2026-09-04 11:56 | call_vertical_spread | 2 | 2 | 7 | 55511.00 | long | ask | 698.5000 | 11.4000 | ["650","680"] | ["0.3331","0.2844"] | ["675.33"] | ["AMXO","SPHR"] | 650.0000 | 680.0000 | 14 | 14 | false | false | false | true | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:05:59Z"} |
| 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-04T18:43:03Z"} |
| 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-04T18:19:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:05:06Z"} |
| 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-04T18:05:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:01:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:47:13Z"} |
| 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-04T17:13:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:53:35Z"} |
| 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:49:50Z"} |
| 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-04T15:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:57:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |