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 | 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 |
|---|
| 01a0da07-f4ef-7300-98c0-688b25be4b8b | AA | 2026-09-25 15:25 | put_frontspread | 2 | 1 | 750 | 275751.00 | long | ask | 42.9300 | 0.4800 | ["42","45"] | ["0.4909","0.5019"] | ["37.91","44.04"] | ["XCBO"] | 42.0000 | 45.0000 | 21 | 21 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:25:59Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8f7-53f7-7d53-8ae0-01c90bff0434 | AA | 2026-09-25 10:28 | call_vertical_spread | 2 | 2 | 310 | 101990.00 | short | bid | 42.9400 | 0.6000 | ["41.5","42.5"] | ["0.4724","0.4437"] | ["42.19"] | ["SPHR"] | 41.5000 | 42.5000 | 7 | 7 | false | false | false | ||||||||||
| 01a0d8f7-53f7-7d53-8ae0-01ad5d022080 | AA | 2026-09-25 10:28 | call_vertical_spread | 2 | 2 | 390 | 128310.00 | short | bid | 42.9400 | 0.6000 | ["41.5","42.5"] | ["0.4724","0.4437"] | ["42.19"] | ["EMLD","SPHR"] | 41.5000 | 42.5000 | 7 | 7 | true | false | false | ||||||||||
| 01a0d4d8-695e-7670-805c-1bf1573b281d | AA | 2026-09-24 15:15 | put_ladder | 8 | 1 | 151 | 264730.00 | unknown | ask | 42.4000 | 11.4000 | ["48","49","49.5","50","52","53","54","59"] | ["1.9603","2.4016","2.4074","2.1073","2.6561","3.5777","5.0127","5.1353"] | ["42.25"] | ["XBOX"] | 48.0000 | 59.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d4c3-acc7-7da2-9932-3f9defbc86f7 | AA | 2026-09-24 14:53 | put_ladder | 8 | 1 | 522 | 700440.00 | unknown | bid | 42.4300 | 6.8500 | ["46","46.5","47","47.5","48","48.5","49","50"] | ["1.2111","1.4459","1.5631","1.8981","2.0166","2.2366","1.8556","2.0502"] | ["43.15"] | ["XBOX"] | 46.0000 | 50.0000 | 1 | 1 | true | false | |||||||||||
| 01a0b5c8-0b97-7f73-969c-e52e82cbda99 | AA | 2026-09-18 14:29 | call_vertical_spread | 2 | 1 | 5000 | 590000.00 | long | ask | 44.6100 | 0.0700 | ["50","55"] | ["0.5334","0.5337"] | ["50.64"] | ["AMXO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b5c5-3507-7163-837b-5a7ef828f24a | AA | 2026-09-18 14:26 | call_vertical_spread | 2 | 1 | 1000 | 118000.00 | long | ask | 44.6800 | 0.0900 | ["50","55"] | ["0.5289","0.5305"] | ["50.64"] | ["XMIO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b5c4-eacf-7fc0-b282-b449028962bd | AA | 2026-09-18 14:26 | call_vertical_spread | 2 | 1 | 1000 | 118000.00 | long | ask | 44.6800 | 0.0900 | ["50","55"] | ["0.5289","0.5305"] | ["50.64"] | ["XMIO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b5c4-42d7-7a50-94ba-1027ce4a0442 | AA | 2026-09-18 14:25 | call_vertical_spread | 2 | 1 | 1000 | 118000.00 | long | ask | 44.7200 | 0.1100 | ["50","55"] | ["0.5264","0.5287"] | ["50.64"] | ["XMIO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b5c3-e130-7053-b96c-c1de787041e7 | AA | 2026-09-18 14:25 | call_vertical_spread | 2 | 1 | 1000 | 118000.00 | long | ask | 44.7000 | 0.1100 | ["50","55"] | ["0.5277","0.5296"] | ["50.64"] | ["XMIO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b5c3-8b3f-78a1-a73c-d8c28157573d | AA | 2026-09-18 14:24 | call_vertical_spread | 2 | 1 | 1000 | 117000.00 | long | ask | 44.6700 | 0.1000 | ["50","55"] | ["0.5270","0.5310"] | ["50.63"] | ["XMIO"] | 50.0000 | 55.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b57f-1bb7-74e1-8c10-bb7c579d8564 | AA | 2026-09-18 13:09 | call_vertical_spread | 2 | 1 | 900 | 419400.00 | long | ask | 44.6900 | 0.6700 | ["42.5","43.5"] | ["0.5446","0.5112"] | ["43.26"] | ["XPHO"] | 42.5000 | 43.5000 | 7 | 7 | true | false | false | ||||||||||
| 01a0a5cd-a27e-7e12-9fb7-56f451289686 | AA | 2026-09-15 12:01 | call_diagonal_spread | 2 | 1 | 200 | 258000.00 | long | bid | 46.1700 | 0.7500 | ["35","46.5"] | ["2.0425","0.5355"] | [] | ["SPHR"] | 35.0000 | 46.5000 | 3 | 10 | false | false | true | ||||||||||
| 01a08c9d-26c8-7710-8bd2-0187f3ff054f | AA | 2026-09-10 14:38 | other | 5 | 1 | 526 | 1233920.00 | unknown | — | 48.7600 | 7.6000 | ["55","56","60","65","70"] | ["1.8664","2.1608","1.0114","1.6217","1.6321"] | [] | ["XBOX"] | 55.0000 | 70.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08be6-6d70-7102-a505-d124458ac849 | AA | 2026-09-10 11:18 | put_diagonal_spread | 2 | 1 | 30 | 140790.00 | short | ask | 49.7597 | 1.2500 | ["70","75"] | ["0.5401","0.6000"] | [] | ["EMLD"] | 70.0000 | 75.0000 | 99 | 190 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:28:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:28:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:15:59Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:53:36Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:29:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:26:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:26:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:26:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:25:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:24:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:10:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:02:07Z"} |
| 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-10T18:38:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:18:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |