core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d4f9-37ce-7883-b5dc-e4b38e345124 | XSP | 2026-09-24 15:51 | put_vertical_spread | 2 | 1 | 99 | 33303.60 | unknown | bid | 770.9600 | 2.5000 | ["787","789"] | ["0.1084","0.1163"] | ["771.18"] | ["XCBO"] | 787.0000 | 789.0000 | 4 | 4 | true | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:51:43Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4d2-bc3f-7b31-90fa-9b06a18d363a | XSP | 2026-09-24 15:09 | other | 4 | 1 | 26 | 29218.80 | unknown | bid | 770.4700 | 3.6400 | ["740","745"] | ["1.0767","1.1999"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | |||||||||
| 01a0d3d3-1ebe-7c33-9f25-a73833d6f1dc | XSP | 2026-09-24 10:30 | iron_butterfly | 4 | 1 | 71 | 32063.60 | unknown | bid | 768.9400 | 1.2700 | ["750","756","757"] | ["0.1499","0.1386","0.1346"] | ["730.42","779.08"] | ["XCBO"] | 750.0000 | 757.0000 | 21 | 21 | true | false | false | ||||||||||
| 01a0cfd9-1976-7460-9f1f-e7093015b869 | XSP | 2026-09-23 15:58 | call_vertical_spread | 2 | 1 | 100 | 40980.00 | unknown | bid | 770.4500 | 0.4600 | ["770","785"] | ["0.1388","0.1296"] | ["797.99"] | ["XCBO"] | 770.0000 | 785.0000 | 86 | 86 | false | false | false | true | |||||||||
| 01a0cfb5-64d6-7961-a6fd-79c17b267a17 | XSP | 2026-09-23 15:19 | other | 4 | 1 | 26 | 29551.60 | unknown | bid | 770.8400 | 1.5300 | ["740","745"] | ["0.9976","1.2133"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | |||||||||
| 01a0cf5b-2746-7e40-81cb-44a584480a0b | XSP | 2026-09-23 13:40 | iron_condor | 4 | 1 | 500 | 35750.00 | unknown | bid | 770.3500 | 0.7700 | ["690","700","820","830"] | ["0.2247","0.2126","0.1118","0.1121"] | ["692.85","827.15"] | ["XCBO"] | 690.0000 | 830.0000 | 51 | 51 | true | true | false | ||||||||||
| 01a0cf20-a6b7-7c00-8659-94bec31ce85a | XSP | 2026-09-23 12:36 | put_calendar | 2 | 2 | 640 | 877107.20 | unknown | bid | 771.4800 | 2.4500 | ["890"] | ["0.1631"] | [] | ["XCBO"] | 890.0000 | 890.0000 | 450 | 814 | false | false | true | false | |||||||||
| 01a0ceee-adbf-73a0-b4c1-61e67595a468 | XSP | 2026-09-23 11:42 | put_vertical_spread | 2 | 1 | 648 | 102513.60 | unknown | bid | 771.8700 | 0.2100 | ["490","720"] | ["0.3639","0.1878"] | ["704.18"] | ["XCBO"] | 490.0000 | 720.0000 | 177 | 177 | false | true | false | true | |||||||||
| 01a0ce8d-d4c7-7c50-ae23-f67806143154 | XSP | 2026-09-23 09:56 | other | 4 | 1 | 70 | 65436.00 | unknown | bid | 773.6900 | 1.6000 | ["800","810"] | ["0.1368","0.1332"] | [] | ["XCBO"] | 800.0000 | 810.0000 | 177 | 189 | false | true | true | true | |||||||||
| 01a0ce8d-731f-7732-a51b-9afa3aaea5eb | XSP | 2026-09-23 09:56 | other | 4 | 1 | 70 | 65310.00 | unknown | bid | 773.5600 | 1.4500 | ["800","810"] | ["0.1369","0.1333"] | [] | ["XCBO"] | 800.0000 | 810.0000 | 177 | 189 | false | true | true | true | |||||||||
| 01a0ca90-dd97-7b22-8c32-5dcf52f8078e | XSP | 2026-09-22 15:21 | call_vertical_spread | 2 | 1 | 100 | 43890.00 | unknown | bid | 777.1900 | 0.5300 | ["780","790"] | ["0.1333","0.1283"] | ["806.94"] | ["XCBO"] | 780.0000 | 790.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a0ca8d-c49e-7a13-be6c-fba6efa94e82 | XSP | 2026-09-22 15:18 | call_vertical_spread | 2 | 1 | 100 | 46030.00 | unknown | bid | 777.2000 | 0.5600 | ["781","785"] | ["0.1327","0.1306"] | ["806.02"] | ["XCBO"] | 781.0000 | 785.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a0c526-bdee-7f93-8fd6-8ed8c6b913f7 | XSP | 2026-09-21 14:07 | other | 4 | 1 | 26 | 35183.20 | unknown | bid | 776.3300 | 3.2000 | ["740","745"] | ["1.1843","0.9818"] | [] | ["XCBO"] | 740.0000 | 745.0000 | 0 | 1 | false | false | true | true | |||||||||
| 01a0c4ba-290f-7210-8867-efdc69bf82db | XSP | 2026-09-21 12:08 | put_vertical_spread | 2 | 1 | 196 | 25107.60 | unknown | bid | 774.3300 | 0.2700 | ["635","745"] | ["0.2711","0.1662"] | ["732.19"] | ["XCBO"] | 635.0000 | 745.0000 | 88 | 88 | false | true | false | true | |||||||||
| 01a0c489-1a77-7640-9519-8780b5291869 | XSP | 2026-09-21 11:15 | other | 4 | 1 | 100 | 44740.00 | unknown | bid | 772.9000 | 1.0400 | ["766","770","785"] | ["0.1105","0.1356","0.1101"] | [] | ["XCBO"] | 766.0000 | 785.0000 | 9 | 60 | false | false | true | true | |||||||||
| 01a0c461-721f-7be3-b23a-26b42cb229e1 | XSP | 2026-09-21 10:31 | call_vertical_spread | 2 | 1 | 112 | 45673.60 | unknown | bid | 772.2100 | 0.8700 | ["810","815"] | ["0.1334","0.1318"] | ["832.89"] | ["XCBO"] | 810.0000 | 815.0000 | 191 | 191 | true | true | false | true | |||||||||
| 01a0c45b-fbae-7400-a019-4e7d3407167b | XSP | 2026-09-21 10:25 | put_vertical_spread | 2 | 1 | 80 | 25696.00 | unknown | bid | 772.1600 | 0.5500 | ["755","760"] | ["0.1577","0.1541"] | ["741.44"] | ["XCBO"] | 755.0000 | 760.0000 | 116 | 116 | false | true | false | true | |||||||||
| 01a0c42e-7f27-7fc2-9833-5fc4c8295fb6 | XSP | 2026-09-21 09:36 | call_vertical_spread | 2 | 1 | 300 | 114060.00 | unknown | bid | 769.6500 | 0.6000 | ["781","785"] | ["0.1310","0.1288"] | ["802.01"] | ["XCBO"] | 781.0000 | 785.0000 | 101 | 101 | false | true | false | ||||||||||
| 01a0b585-595f-7bd1-9875-49d2e6a13c40 | XSP | 2026-09-18 13:16 | other | 4 | 1 | 45 | 25479.00 | unknown | bid | 762.3600 | 6.0900 | ["750","755","760"] | ["0.1220","0.1256","0.1264"] | [] | ["XCBO"] | 750.0000 | 760.0000 | 7 | 35 | false | false | true | true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:10:10Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:30:22Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:58:27Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:20:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:40:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:37:21Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:42:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:56:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:56:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:21:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:18:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:07:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:08:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:15:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:32:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:26:01Z"} |
| 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-21T13:36:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:16:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |