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 |
|---|
| 01a0cab0-e0e7-7123-91b2-4096b2eba014 | LITE | 2026-09-22 15:56 | call_diagonal_spread | 2 | 1 | 4 | 248312.00 | long | ask | 945.3950 | 31.3000 | ["800","870"] | ["0.7779","0.7801"] | [] | ["EDGO"] | 800.0000 | 870.0000 | 268 | 297 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:56:40Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c97b-0c7f-74e1-9966-f6f4f15cdde6 | LITE | 2026-09-22 10:17 | call_diagonal_spread | 2 | 2 | 30 | 937770.00 | long | ask | 987.3950 | 13.6000 | ["820","1160"] | ["0.7877","0.8069"] | [] | ["EMLD","XPHO"] | 820.0000 | 1160.0000 | 59 | 87 | false | false | true | ||||||||||
| 01a0c53a-e617-7dc2-87c0-a6007599d7a6 | LITE | 2026-09-21 14:29 | call_diagonal_spread | 2 | 1 | 10 | 156170.00 | long | ask | 958.7100 | 9.7000 | ["950","965"] | ["0.7168","0.7117"] | [] | ["XCBO"] | 950.0000 | 965.0000 | 25 | 32 | false | false | true | ||||||||||
| 01a0c4ec-358f-7f42-8732-0cf5ff7dc826 | LITE | 2026-09-21 13:03 | call_diagonal_spread | 2 | 1 | 2 | 143550.00 | long | ask | 960.8450 | 32.5000 | ["1000","1020"] | ["0.7729","0.7688"] | [] | ["XMIO"] | 1000.0000 | 1020.0000 | 487 | 634 | false | true | true | ||||||||||
| 01a0c4c3-4517-7681-99ee-ed683b54a8d0 | LITE | 2026-09-21 12:18 | call_diagonal_spread | 2 | 1 | 6 | 209142.00 | long | ask | 969.9600 | 12.9000 | ["710","895"] | ["0.7784","0.7981"] | [] | ["MCRY"] | 710.0000 | 895.0000 | 4 | 25 | false | false | 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 | ||||||||||
| 01a0c451-8fb7-7b53-a96f-1338187a0959 | LITE | 2026-09-21 10:14 | call_diagonal_spread | 2 | 1 | 3 | 107160.00 | long | ask | 976.2250 | 20.4000 | ["880","900"] | ["0.7740","0.7539"] | [] | ["XMIO"] | 880.0000 | 900.0000 | 60 | 88 | 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 | ||||||||||
| 01a0b59d-947f-7c93-8bb1-f82ee911d654 | LITE | 2026-09-18 13:43 | call_diagonal_spread | 2 | 1 | 9 | 102150.00 | long | ask | 911.0850 | 5.6000 | ["860","890"] | ["2.1459","0.7086"] | [] | ["EDGO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b58f-d10f-7812-be3d-a378c368b640 | LITE | 2026-09-18 13:28 | call_diagonal_spread | 2 | 2 | 15 | 171780.00 | long | ask | 912.5600 | 7.2000 | ["860","890"] | ["2.5605","0.7014"] | [] | ["EDGO","XCBO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b58f-d10f-7812-be3d-a35314506bff | LITE | 2026-09-18 13:28 | call_diagonal_spread | 2 | 3 | 15 | 172150.00 | long | ask | 912.5600 | 6.7000 | ["860","890"] | ["2.5604","0.7032"] | [] | ["ARCO","EDGO","XCBO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b544-f117-7b82-8c46-108a6e8082e0 | LITE | 2026-09-18 12:06 | call_diagonal_spread | 2 | 2 | 11 | 128667.00 | long | ask | 914.0550 | 5.5000 | ["860","890"] | ["1.8746","0.7048"] | [] | ["C2OX","EDGO"] | 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 | ||||||||||
| 01a0b4b6-bebf-76e0-b43f-4f8a7d494804 | LITE | 2026-09-18 09:31 | call_diagonal_spread | 2 | 1 | 155 | 209250.00 | long | ask | 930.2550 | 3.8000 | ["980","1010"] | ["1.3538","0.7295"] | [] | ["XISX"] | 980.0000 | 1010.0000 | 0 | 7 | false | true | true | ||||||||||
| 01a0afc7-6123-7ae3-aadf-c508e8c116c0 | LITE | 2026-09-17 10:31 | call_diagonal_spread | 2 | 2 | 2 | 182608.00 | long | ask | 902.6100 | 22.2000 | ["400","500"] | ["1.0444","5.7414"] | [] | ["BATO","XMIO"] | 400.0000 | 500.0000 | 1 | 64 | false | false | true | ||||||||||
| 01a0afc7-41e3-72f2-889d-a8ed20d3f572 | LITE | 2026-09-17 10:31 | call_diagonal_spread | 2 | 1 | 3 | 273897.00 | long | ask | 902.8950 | 22.2000 | ["400","500"] | ["1.0262","5.5751"] | [] | ["XMIO"] | 400.0000 | 500.0000 | 1 | 64 | false | false | true | ||||||||||
| 01a0afc7-3a13-75f2-9397-85f37a4e2d97 | LITE | 2026-09-17 10:31 | call_diagonal_spread | 2 | 1 | 4 | 365176.00 | long | ask | 903.0100 | 22.3000 | ["400","500"] | ["1.0176","5.4922"] | [] | ["XMIO"] | 400.0000 | 500.0000 | 1 | 64 | false | false | true | ||||||||||
| 01a0afc6-e80b-7910-999f-cb9a5aa1bfbb | LITE | 2026-09-17 10:30 | call_diagonal_spread | 2 | 1 | 2 | 182608.00 | long | ask | 902.9300 | 22.3000 | ["400","500"] | ["1.0260","5.5669"] | [] | ["EDGO"] | 400.0000 | 500.0000 | 1 | 64 | false | false | true | ||||||||||
| 01a0afc6-e80b-7910-999f-cb88e834e3f4 | LITE | 2026-09-17 10:30 | call_diagonal_spread | 2 | 3 | 8 | 727084.00 | long | ask | 902.9300 | 22.3000 | ["400","500"] | ["1.1053","6.3141"] | [] | ["BATO","XBOX","XMIO"] | 400.0000 | 500.0000 | 1 | 64 | 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 | ||||||||||
| 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 | ||||||||||
| 01a08737-1249-7711-99be-6d1a3f2248a9 | LITE | 2026-09-09 13:28 | call_diagonal_spread | 2 | 1 | 21 | 1040046.00 | long | ask | 1008.3000 | 19.5000 | ["770","820"] | ["1.0360","0.8394"] | [] | ["XCBO"] | 770.0000 | 820.0000 | 9 | 72 | false | false | true | ||||||||||
| 01a08737-1249-7711-99be-6d0e3b821519 | LITE | 2026-09-09 13:28 | call_diagonal_spread | 2 | 5 | 25 | 1236726.00 | long | ask | 1008.3000 | 19.8440 | ["770","820"] | ["1.1146","0.8316"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 770.0000 | 820.0000 | 9 | 72 | 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 | ||||||||||
| 01a08188-f078-7b62-861e-784aeb60b945 | LITE | 2026-09-08 11:00 | call_diagonal_spread | 2 | 1 | 5 | 285600.00 | long | ask | 974.9900 | 19.7000 | ["1010","1270"] | ["0.8106","0.7987"] | [] | ["XISX"] | 1010.0000 | 1270.0000 | 311 | 500 | false | true | true | ||||||||||
| 01a08188-e8a8-70e2-8fae-cfccf3420b49 | LITE | 2026-09-08 11:00 | call_diagonal_spread | 2 | 4 | 12 | 684375.00 | long | ask | 974.0000 | 17.2000 | ["1010","1270"] | ["0.8111","0.7991"] | [] | ["EDGO","XCBO","XISX","XMIO"] | 1010.0000 | 1270.0000 | 311 | 500 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:18:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:29:36Z"} |
| 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-21T17:03:49Z"} |
| 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: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-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-21T14:14:49Z"} |
| 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 |
| mesl |
| 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:28:40Z"} |
| 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:28:40Z"} |
| 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:31: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-17T14:31:12Z"} |
| 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-17T14:31:12Z"} |
| 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-17T14:31:12Z"} |
| 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-17T14:30: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-17T14:30: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-10T16:46:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:28:54Z"} |
| 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-09T17:28:54Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:00:46Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:00:46Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |