core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 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 |
|---|
| 01a08193-6ff8-71a0-8e14-d4d8ceb5064e | CAT | 2026-09-08 11:11 | call_vertical_spread | 2 | 1 | 2 | 33140.00 | short | bid | 826.6600 | 12.9000 | ["810","840"] | ["0.3889","0.3927"] | ["823.50"] | ["EMLD"] | 810.0000 | 840.0000 | 129 | 129 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:12:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08180-68e1-7e32-bfaf-b5cfe01141bd | CAT | 2026-09-08 10:51 | put_vertical_spread | 2 | 2 | 36 | 44244.00 | short | bid | 823.4950 | 1.9500 | ["710","720"] | ["0.3954","0.3925"] | ["718.75"] | ["XISX","XMIO"] | 710.0000 | 720.0000 | 38 | 38 | false | true | false | true | |||||||||
| 01a08157-0b08-7e50-9805-9d71e1f75e90 | CAT | 2026-09-08 10:05 | put_diagonal_spread | 2 | 1 | 4 | 119956.00 | short | bid | 822.1100 | 14.1250 | ["840","1100"] | ["0.4124","1.1578"] | [] | ["XPHO"] | 840.0000 | 1100.0000 | 3 | 10 | false | false | true | true | false | ||||||||
| 01a0814e-77b8-7e11-86dd-6310485ffd48 | CAT | 2026-09-08 09:56 | risk_reversal | 2 | 1 | 11 | 37598.00 | short | bid | 827.1650 | 6.0500 | ["680","1020"] | ["0.4361","0.3949"] | ["1020.10"] | ["XMIO"] | 680.0000 | 1020.0000 | 101 | 101 | false | true | false | true | true | ||||||||
| 01a08149-dc08-72f3-9aa1-7d9f12eb52f2 | CAT | 2026-09-08 09:51 | call_vertical_spread | 2 | 2 | 14 | 125804.00 | short | bid | 826.4901 | 8.3500 | ["850","900"] | ["0.4169","0.4163"] | ["868"] | ["XISX"] | 850.0000 | 900.0000 | 73 | 73 | false | true | false | true | false | ||||||||
| 01a08148-c6b0-7832-bf7d-941174e26f40 | CAT | 2026-09-08 09:50 | put_vertical_spread | 2 | 1 | 3 | 33498.00 | short | bid | 828.0000 | 11.6000 | ["780","800"] | ["0.4104","0.4085"] | ["791.50"] | ["BATO"] | 780.0000 | 800.0000 | 129 | 129 | false | true | false | true | false | ||||||||
| 01a08145-b1a0-7c81-9187-a3c89be3a613 | CAT | 2026-09-08 09:47 | put_diagonal_spread | 2 | 1 | 3 | 42990.00 | long | bid | 830.1350 | 18.5000 | ["780","840"] | ["0.4282","0.4161"] | [] | ["XISX"] | 780.0000 | 840.0000 | 129 | 164 | false | false | true | true | false | ||||||||
| 01a08139-b350-74d1-beab-5eb25d9220c9 | CAT | 2026-09-08 09:33 | call_vertical_spread | 2 | 1 | 5 | 25735.00 | short | bid | 827.0100 | 9.6000 | ["805","812.5"] | ["0.4956","0.4906"] | ["810.27"] | ["XPHO"] | 805.0000 | 812.5000 | 3 | 3 | false | false | false | true | |||||||||
| 01a08136-859b-7600-809f-cd2ad03a7584 | CAT | 2026-09-08 09:30 | put_condor | 4 | 1 | 3 | 50214.00 | short | bid | 824.0200 | 30.3250 | ["700","720","780","800"] | ["0.4073","0.4086","0.4066","0.3998"] | ["701.80","798.20"] | ["XCBO"] | 700.0000 | 800.0000 | 129 | 129 | false | true | false | true | |||||||||
| 01a06dc4-553d-7901-9747-e1abba6ef919 | CAT | 2026-09-04 14:52 | put_calendar | 2 | 1 | 4 | 27528.00 | long | bid | 810.3800 | 2.1500 | ["740"] | ["0.4084"] | [] | ["BATO"] | 740.0000 | 740.0000 | 77 | 133 | false | true | true | false | false | ||||||||
| 01a06da2-fe16-72c2-a2a8-19fe998f29a4 | CAT | 2026-09-04 14:16 | call_diagonal_spread_bearish | 2 | 1 | 5 | 432010.00 | long | bid | 810.0601 | 25.4000 | ["340","430"] | ["2.2221","0.4672"] | [] | ["XISX"] | 340.0000 | 430.0000 | 14 | 196 | false | false | true | true | |||||||||
| 01a06d8e-705e-7db3-b918-b80bb5ba7e27 | CAT | 2026-09-04 13:54 | put_vertical_spread | 2 | 1 | 25 | 40750.00 | short | bid | 809.3850 | 2.2500 | ["750","790"] | ["0.3523","0.3449"] | ["780.70"] | ["XISX"] | 750.0000 | 790.0000 | 14 | 14 | false | true | false | true | false | ||||||||
| 01a06d84-2b76-7243-b0f7-bd758126c11d | CAT | 2026-09-04 13:42 | call_vertical_spread | 2 | 2 | 40 | 150920.00 | short | bid | 809.0400 | 10.3000 | ["830","835"] | ["0.3617","0.3615"] | ["831.83"] | ["XISX"] | 830.0000 | 835.0000 | 21 | 21 | false | true | false | true | |||||||||
| 01a06d83-d96d-7de0-8d8e-1d1ee508bacd | CAT | 2026-09-04 13:42 | call_vertical_spread | 2 | 1 | 3 | 35208.00 | short | bid | 809.3150 | 9.0000 | ["800","900"] | ["0.4013","0.3993"] | ["839"] | ["XISX"] | 800.0000 | 900.0000 | 105 | 105 | false | false | false | true | |||||||||
| 01a06d77-d736-7621-9838-ff1a1127442e | CAT | 2026-09-04 13:29 | put_vertical_spread | 2 | 1 | 20 | 52900.00 | short | bid | 810.0078 | 1.7000 | ["740","750"] | ["0.3627","0.3615"] | ["747.55"] | ["XMIO"] | 740.0000 | 750.0000 | 42 | 42 | false | true | false | true | false | ||||||||
| 01a06d4d-5c35-7402-b0ad-f4ff7f219ef9 | CAT | 2026-09-04 12:42 | put_calendar | 2 | 1 | 4 | 26976.00 | long | bid | 813.1600 | 3.3000 | ["740"] | ["0.4090"] | [] | ["XPHO"] | 740.0000 | 740.0000 | 77 | 133 | false | true | true | false | false | ||||||||
| 01a06d26-34c5-7ea0-bc50-8ba6fe8ba3d4 | CAT | 2026-09-04 12:00 | call_vertical_spread | 2 | 1 | 30 | 919740.00 | short | bid | 812.7900 | 13.9500 | ["660","665"] | ["6.5018","6.3230"] | ["664.98"] | ["XMIO"] | 660.0000 | 665.0000 | 0 | 0 | true | false | false | true |
| mlet |
| 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:06:05Z"} |
| 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:56:37Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:51:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:50:42Z"} |
| 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:47:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:34:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:07Z"} |
| 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-04T18:53:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:16:55Z"} |
| 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:54:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:43:01Z"} |
| 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:43:01Z"} |
| 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:29: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:43:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:00:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |