core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rows| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| directiontext |
|---|
| 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 |
|---|
| 01a0fe33-95c7-79d3-ba54-3f1fc3eb96aa | CAPR | 2026-10-02 15:59 | call_vertical_spread | 2 | 1 | 99 | 113850.00 | long | ask | 8.9650 | 1.3000 | ["3","10"] | ["1.1905","1.2801"] | ["5.10"] | ["XISX"] | 3.0000 | 10.0000 | 476 | 476 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-02T19:59:58Z"} | 2026-10-02 | 2026-10-02 17:15 | 2026-10-02 17:15 |
| 01a0d3cf-ee57-74b2-9a50-ea9c00835c50 | CAPR | 2026-09-24 10:26 | put_vertical_spread | 2 | 1 | 50 | 140600.00 | long | ask | 8.3734 | 5.0000 | ["9","31"] | ["2.6867","2.5750"] | ["11.78"] | ["EDGO"] | 9.0000 | 31.0000 | 85 | 85 | false | false | |||||||||||
| 01a0cfb9-0e57-78e2-a12c-6d60e3633cf3 | CAPR | 2026-09-23 15:23 | put_vertical_spread | 2 | 1 | 95 | 265525.00 | long | ask | 8.5900 | 3.3000 | ["8","32"] | ["2.6310","2.4747"] | ["11.27"] | ["EDGO"] | 8.0000 | 32.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cfb8-f2ff-7f70-b4bf-45f1e30a1dde | CAPR | 2026-09-23 15:23 | put_vertical_spread | 2 | 1 | 99 | 276606.00 | long | ask | 8.5900 | 3.3000 | ["8","32"] | ["2.6233","2.4747"] | ["11.26"] | ["EDGO"] | 8.0000 | 32.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cfb8-a8c7-7ee2-a4cc-88d0a093fe6e | CAPR | 2026-09-23 15:22 | put_vertical_spread | 2 | 1 | 167 | 466932.00 | long | ask | 8.5750 | 3.3000 | ["8","32"] | ["2.6205","2.4812"] | ["11.24"] | ["EDGO"] | 8.0000 | 32.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cfb8-8987-76c2-835a-93d3f9d51952 | CAPR | 2026-09-23 15:22 | put_vertical_spread | 2 | 1 | 40 | 111880.00 | long | ask | 8.5750 | 3.3000 | ["8","32"] | ["2.6205","2.4880"] | ["11.23"] | ["XCBO"] | 8.0000 | 32.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cfb8-56be-7223-9e53-3064d2196fa6 | CAPR | 2026-09-23 15:22 | put_vertical_spread | 2 | 1 | 500 | 1384500.00 | long | ask | 8.5750 | 3.7000 | ["8","32"] | ["2.5441","2.3638"] | ["11.31"] | ["ARCO"] | 8.0000 | 32.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cf7e-7657-76e0-bee1-55d0275c3432 | CAPR | 2026-09-23 14:19 | call_vertical_spread | 2 | 1 | 500 | 267500.00 | short | bid | 8.5940 | 4.4000 | ["8","27"] | ["2.4932","2.3084"] | ["10.85"] | ["ARCO"] | 8.0000 | 27.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cf7d-b307-7481-94ac-6ba49cae3715 | CAPR | 2026-09-23 14:18 | call_vertical_spread | 2 | 1 | 300 | 148500.00 | short | bid | 8.6150 | 3.6000 | ["9","27"] | ["2.4093","2.2905"] | ["11.49"] | ["EDGO"] | 9.0000 | 27.0000 | 86 | 86 | false | true | |||||||||||
| 01a0cf7d-9f7e-7b20-a606-d7914f186360 | CAPR | 2026-09-23 14:18 | call_vertical_spread | 2 | 1 | 196 | 107212.00 | long | ask | 8.6000 | 4.4000 | ["9","27"] | ["2.5942","2.4697"] | ["11.47"] | ["EDGO"] | 9.0000 | 27.0000 | 86 | 86 | false | true | |||||||||||
| 01a0cf7d-880f-73a0-9054-969a2228f8be | CAPR | 2026-09-23 14:18 | call_vertical_spread | 2 | 1 | 500 | 272500.00 | long | ask | 8.5850 | 4.4000 | ["9","27"] | ["2.6382","2.4283"] | ["11.59"] | ["ARCO"] | 9.0000 | 27.0000 | 86 | 86 | false | true | |||||||||||
| 01a0ca6a-bfc7-7d62-8545-faaf13b33088 | CAPR | 2026-09-22 14:39 | put_vertical_spread | 2 | 1 | 104 | 158704.00 | long | ask | 9.3600 | 1.7500 | ["9","20"] | ["2.4275","2.4008"] | ["11.18"] | ["EDGO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca6a-9c9f-7110-be55-5e1c4cec33f5 | CAPR | 2026-09-22 14:39 | put_vertical_spread | 2 | 1 | 84 | 128100.00 | long | ask | 9.3600 | 1.7500 | ["9","20"] | ["2.4198","2.4008"] | ["11.17"] | ["EDGO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca6a-8917-7830-a68e-e2e8a65a87b2 | CAPR | 2026-09-22 14:39 | put_vertical_spread | 2 | 1 | 177 | 270102.00 | long | ask | 9.3600 | 1.7500 | ["9","20"] | ["2.4198","2.4078"] | ["11.16"] | ["EDGO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca6a-6207-75b3-bc90-9e0da45fb98a | CAPR | 2026-09-22 14:39 | put_vertical_spread | 2 | 1 | 400 | 606800.00 | short | bid | 9.3600 | 1.8500 | ["9","20"] | ["2.4121","2.3519"] | ["11.23"] | ["ARCO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca41-330f-7df0-8294-121bad6464a4 | CAPR | 2026-09-22 13:54 | call_vertical_spread | 2 | 1 | 300 | 148500.00 | short | bid | 9.4217 | 2.1000 | ["9","20"] | ["2.3489","2.2711"] | ["11.21"] | ["ARCO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca20-d1ff-7620-af93-bcd69a1f9138 | CAPR | 2026-09-22 13:19 | call_vertical_spread | 2 | 1 | 218 | 105076.00 | short | bid | 9.3700 | 1.8500 | ["9","20"] | ["2.2776","2.2843"] | ["11.08"] | ["EDGO"] | 9.0000 | 20.0000 | 59 | 59 | false | false | |||||||||||
| 01a0ca20-a31e-7d61-af46-df29313b2ab7 | CAPR | 2026-09-22 13:18 | call_vertical_spread | 2 | 1 | 250 | 123500.00 | unknown | bid | 9.3600 | 1.5500 | ["9","20"] | ["2.4126","2.2512"] | ["13.94"] | ["ARCO"] | 9.0000 | 20.0000 | 59 | 59 | false | ||||||||||||
| 01a0b06a-e86b-7373-b24b-3e21695628f1 | CAPR | 2026-09-17 13:29 | call_vertical_spread | 2 | 1 | 220 | 109560.00 | short | bid | 9.3886 | 1.3500 | ["9","20"] | ["2.1906","2.2822"] | ["10.96"] | ["XCBO"] | 9.0000 | 20.0000 | 64 | 64 | false | false | |||||||||||
| 01a0b066-8b3b-7562-aec2-300dded9b05b | CAPR | 2026-09-17 13:25 | call_vertical_spread | 2 | 1 | 199 | 101092.00 | short | bid | 9.3500 | 4.2000 | ["9","20"] | ["2.2834","2.2920"] | ["11.06"] | ["EDGO"] | 9.0000 | 20.0000 | 64 | 64 | false | false | |||||||||||
| 01a0b066-1223-7e91-b1ab-2e0e1a143828 | CAPR | 2026-09-17 13:24 | call_vertical_spread | 2 | 1 | 300 | 154200.00 | short | bid | 9.3600 | 4.2000 | ["9","20"] | ["2.3298","2.2827"] | ["11.14"] | ["ARCO"] | 9.0000 | 20.0000 | 64 | 64 | false | false | |||||||||||
| 01a09184-1480-7ac1-83f4-161a0bfcb9be | CAPR | 2026-09-11 13:29 | other | 2 | 1 | 70 | 179900.00 | unknown | — | 8.6600 | 5.4000 | ["20"] | ["3.5615"] | [] | ["XISX"] | 20.0000 | 20.0000 | 7 | 126 | false | false | true | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:27:22Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:24:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:23:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:23:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:23:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:22:47Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:19:49Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:19:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:19:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:19:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:40:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:40:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:40:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:40:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:54:41Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:30:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:25:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:24:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:29:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |