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 | 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 |
|---|
| 01a0ca7e-b13f-7241-8ce3-2d33964db14c | LITE | 2026-09-22 15:01 | call_diagonal_spread | 2 | 1 | 2 | 108184.00 | unknown | bid | 941.9700 | 17.2000 | ["400","700"] | ["4.5441","0.7993"] | [] | ["XISX"] | 400.0000 | 700.0000 | 3 | 59 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:01:50Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca03-c47f-7a03-9cc2-8659f5e52f36 | LITE | 2026-09-22 12:47 | call_diagonal_spread | 2 | 1 | 150 | 6038801.00 | unknown | bid | 948.9600 | 26.3000 | ["1000","1030"] | ["0.7550","0.7629"] | [] | ["XBOX"] | 1000.0000 | 1030.0000 | 178 | 268 | false | true | true | ||||||||||
| 01a0c4c3-48ff-78e0-807b-887d68731063 | LITE | 2026-09-21 12:18 | call_diagonal_spread | 2 | 1 | 3 | 108564.00 | short | bid | 969.9600 | 17.8000 | ["700","890"] | ["0.7770","0.7941"] | [] | ["XISX"] | 700.0000 | 890.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0c4c2-db9f-7240-83c7-bd0681df74ca | LITE | 2026-09-21 12:18 | call_diagonal_spread | 2 | 1 | 25 | 535345.00 | unknown | bid | 969.8572 | 18.3000 | ["1140","1260"] | ["0.7503","0.7739"] | [] | ["BATO"] | 1140.0000 | 1260.0000 | 116 | 269 | false | true | true | ||||||||||
| 01a0c49c-7f4f-7d20-860c-80dd2aa120d7 | LITE | 2026-09-21 11:36 | call_diagonal_spread | 2 | 1 | 10 | 173890.00 | long | bid | 970.5500 | 15.6000 | ["910","930"] | ["0.7799","0.7510"] | [] | ["XISX"] | 910.0000 | 930.0000 | 11 | 18 | false | false | true | ||||||||||
| 01a0b5b5-623f-7cb3-93ad-07140244423e | LITE | 2026-09-18 14:09 | call_diagonal_spread | 2 | 1 | 3 | 463980.00 | long | bid | 914.4400 | 28.4000 | ["105","200"] | ["63.7617","0.8743"] | [] | ["XMIO"] | 105.0000 | 200.0000 | 0 | 490 | false | false | true | ||||||||||
| 01a0b59f-fdaf-7872-b343-5360971fd35a | LITE | 2026-09-18 13:45 | call_diagonal_spread | 2 | 4 | 44 | 494028.00 | unknown | bid | 911.4800 | 4.6636 | ["860","890"] | ["2.1809","0.6962"] | [] | ["C2OX","XBOX","XCBO","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b59d-947f-7c93-8bb1-f817165c6a68 | LITE | 2026-09-18 13:43 | call_diagonal_spread | 2 | 3 | 52 | 586464.00 | short | bid | 911.0850 | 3.7846 | ["860","890"] | ["2.6972","0.7030"] | [] | ["ARCO","XBOX","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b592-6150-7af1-8ed6-45d80fe8a7d1 | LITE | 2026-09-18 13:31 | call_diagonal_spread | 2 | 2 | 20 | 224620.00 | unknown | bid | 910.5750 | 4.8000 | ["860","890"] | ["1.8193","0.7071"] | [] | ["ARCO","XCBO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b591-01c0-7d90-a344-beb1e1a9853d | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 3 | 37 | 417870.00 | short | bid | 911.4050 | 3.0000 | ["860","890"] | ["1.7299","0.7026"] | [] | ["ARCO","XCBO","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b590-ea50-7351-818c-96d10d2ba75d | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 4 | 11 | 124391.00 | short | bid | 911.4050 | 5.8000 | ["860","890"] | ["2.4678","0.7043"] | [] | ["ARCO","EDGO","XCBO","XPHO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b590-daaf-7393-b042-9a25deb2477c | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 3 | 18 | 204170.00 | short | bid | 911.4050 | 6.6000 | ["860","890"] | ["1.6752","0.7068"] | [] | ["EDGO","XCBO","XPHO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b571-6fb8-7fa3-b40a-4125e7e4935c | LITE | 2026-09-18 12:55 | call_diagonal_spread | 2 | 3 | 10 | 112668.00 | short | bid | 911.5000 | 12.5100 | ["860","890"] | ["2.8942","0.6992"] | [] | ["ARCO","MCRY","XCBO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b556-1b9f-72f3-ac27-b630cf816577 | LITE | 2026-09-18 12:25 | call_diagonal_spread | 2 | 4 | 50 | 543472.00 | unknown | bid | 909.3600 | 5.9000 | ["860","890"] | ["1.6196","0.6970"] | [] | ["C2OX","EDGO","XBOX","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b556-17b7-71f1-bf2b-6d2f3f9d215b | LITE | 2026-09-18 12:25 | call_diagonal_spread | 2 | 4 | 35 | 381174.00 | unknown | bid | 909.1034 | 5.9000 | ["860","890"] | ["1.6971","0.7007"] | [] | ["ARCO","C2OX","EDGO","XBOX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b544-e947-7c21-81f3-73d971b26304 | LITE | 2026-09-18 12:06 | call_diagonal_spread | 2 | 3 | 20 | 234448.00 | short | bid | 914.0000 | 6.7000 | ["860","890"] | ["1.8969","0.7071"] | [] | ["EDGO","XCBO","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b4f0-ed47-7d23-bfa2-6e88c139c625 | LITE | 2026-09-18 10:34 | call_diagonal_spread | 2 | 1 | 6 | 335082.00 | long | bid | 907.5000 | 22.4000 | ["620","700"] | ["10.6464","0.7566"] | [] | ["XISX"] | 620.0000 | 700.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b4c4-c498-7a90-ac13-d2e7b6135fbf | LITE | 2026-09-18 09:46 | call_diagonal_spread | 2 | 1 | 7 | 324548.00 | long | bid | 934.5603 | 25.9000 | ["650","770"] | ["8.6541","0.7248"] | [] | ["XMIO"] | 650.0000 | 770.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b4b8-ca30-7b00-b69a-91b35b61fd86 | LITE | 2026-09-18 09:33 | call_diagonal_spread | 2 | 1 | 120 | 138720.00 | short | bid | 934.4350 | 3.9000 | ["1000","1020"] | ["1.2287","0.7464"] | [] | ["XPHO"] | 1000.0000 | 1020.0000 | 0 | 7 | false | true | true | ||||||||||
| 01a0b041-5bb2-7663-b7c7-15614d03931f | LITE | 2026-09-17 12:44 | call_diagonal_spread | 2 | 2 | 2 | 112052.00 | short | bid | 917.5100 | 23.7000 | ["700","1100"] | ["0.7639","0.7782"] | [] | ["BATO","C2OX"] | 700.0000 | 1100.0000 | 120 | 491 | false | false | true | ||||||||||
| 01a0aacc-4f2b-7423-a1e3-05fdb229113a | LITE | 2026-09-16 11:18 | call_diagonal_spread | 2 | 2 | 6 | 467766.00 | long | bid | 900.4900 | 18.0500 | ["450","600"] | ["3.6150","0.7889"] | [] | ["XISX"] | 450.0000 | 600.0000 | 2 | 93 | false | false | true | ||||||||||
| 01a0a5c7-ed8e-77f1-9952-7b4a327b59d5 | LITE | 2026-09-15 11:55 | call_diagonal_spread | 2 | 2 | 18 | 154890.00 | short | bid | 842.5200 | 3.7000 | ["820","830"] | ["0.8304","0.7439"] | [] | ["EDGO","XISX"] | 820.0000 | 830.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0a172-1159-7760-bf96-81c20a704113 | LITE | 2026-09-14 15:43 | call_diagonal_spread | 2 | 1 | 2 | 102840.00 | short | bid | 835.4000 | 23.3000 | ["600","650"] | ["0.8502","0.7936"] | [] | ["XCBO"] | 600.0000 | 650.0000 | 32 | 158 | false | false | true | ||||||||||
| 01a0a051-0d10-7783-a4b3-a2352b04fce5 | LITE | 2026-09-14 10:27 | call_diagonal_spread | 2 | 1 | 3 | 107922.00 | short | bid | 857.1400 | 22.3000 | ["950","1000"] | ["0.7926","0.7966"] | [] | ["XCBO"] | 950.0000 | 1000.0000 | 186 | 276 | false | true | true | ||||||||||
| 01a08c36-b438-7ae2-a376-133ca370a818 | LITE | 2026-09-10 12:46 | call_diagonal_spread | 2 | 1 | 12 | 180960.00 | long | bid | 938.9299 | 9.2000 | ["970","1020"] | ["0.7472","0.7561"] | [] | ["SPHR"] | 970.0000 | 1020.0000 | 36 | 50 | false | true | true | ||||||||||
| 01a086b7-0120-7f41-9a2e-7a86381a17db | LITE | 2026-09-09 11:08 | call_diagonal_spread | 2 | 2 | 6 | 164208.00 | short | bid | 1020.5000 | 21.9000 | ["915","920"] | ["0.8268","0.8109"] | [] | ["ARCO","XISX"] | 915.0000 | 920.0000 | 16 | 23 | false | false | true | ||||||||||
| 01a0820f-ef10-71e2-bc5e-0ed6bbf4d268 | LITE | 2026-09-08 13:27 | call_diagonal_spread | 2 | 1 | 30 | 945870.00 | short | bid | 991.7701 | 20.1000 | ["890","920"] | ["0.8284","0.8408"] | [] | ["XISX"] | 890.0000 | 920.0000 | 17 | 73 | false | false | true | ||||||||||
| 01a0820a-5960-7db1-9005-136c9a7c1acb | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 3 | 103614.00 | long | bid | 993.9450 | 22.6000 | ["1000","1140"] | ["0.8268","0.8254"] | [] | ["XCBO"] | 1000.0000 | 1140.0000 | 101 | 164 | false | true | true | ||||||||||
| 01a08209-b551-7502-9133-48080d2dfb6d | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 50 | 3011500.00 | short | bid | 993.0000 | 28.9000 | ["1300","1500"] | ["0.8048","0.8082"] | [] | ["XCBO"] | 1300.0000 | 1500.0000 | 500 | 647 | false | true | true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:47:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:19:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:18:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:36:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:09:21Z"} |
| 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:46:22Z"} |
| 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:43:46Z"} |
| 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:31:41Z"} |
| 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:29:57Z"} |
| 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:29:57Z"} |
| 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:29:57Z"} |
| 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-18T16:55:15Z"} |
| 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-18T16:25:23Z"} |
| 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-18T16:25:23Z"} |
| 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-18T16:06:38Z"} |
| 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-18T14:34:49Z"} |
| 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-18T13:46:44Z"} |
| 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-18T13:33:32Z"} |
| 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-17T16:44:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:19:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:55:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:43:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:27:44Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:46:47Z"} |
| 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-09T15:08:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:28:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:22:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:21:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |