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 | 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 |
|---|
| 01a0ca29-078f-7020-9796-5ceb793bcf31 | SPXL | 2026-09-22 13:27 | put_vertical_spread | 2 | 1 | 7 | 131033.00 | long | ask | 294.1000 | 4.2000 | ["385","390"] | ["1.4529","1.4905"] | ["385.03"] | ["XISX"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:28:06Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca1d-9daf-7491-aeb4-d861c82e4264 | SPXL | 2026-09-22 13:15 | put_vertical_spread | 2 | 1 | 8 | 149752.00 | long | ask | 293.9800 | 4.2000 | ["385","390"] | ["1.3637","1.3914"] | ["385.03"] | ["XMIO"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca1c-1af7-7c22-9a3a-2925f65f1b42 | SPXL | 2026-09-22 13:13 | put_vertical_spread | 2 | 1 | 8 | 149752.00 | long | ask | 294.0200 | 4.2000 | ["385","390"] | ["1.3965","1.4283"] | ["385.03"] | ["XISX"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca13-87a6-79e3-8642-a7be9e9cb4d2 | SPXL | 2026-09-22 13:04 | put_vertical_spread | 2 | 1 | 10 | 187190.00 | long | ask | 294.1500 | 4.2000 | ["385","390"] | ["1.4838","1.5240"] | ["385.03"] | ["XMIO"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca12-436f-7f63-bf44-a253948ce139 | SPXL | 2026-09-22 13:03 | put_vertical_spread | 2 | 1 | 6 | 112314.00 | long | ask | 294.2450 | 4.2000 | ["385","390"] | ["1.5359","1.5801"] | ["385.03"] | ["XMIO"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca03-a53f-77f0-b547-e4378f462119 | SPXL | 2026-09-22 12:47 | put_vertical_spread | 2 | 1 | 10 | 187190.00 | long | ask | 293.6050 | 4.2000 | ["385","390"] | ["1.7399","1.7671"] | ["385.03"] | ["XISX"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9ff-ad9f-74d3-96ad-9ae14df7a73a | SPXL | 2026-09-22 12:42 | put_vertical_spread | 2 | 1 | 8 | 149752.00 | long | ask | 293.5700 | 4.2000 | ["385","390"] | ["1.7278","1.7538"] | ["385.03"] | ["XISX"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9f9-dd57-7e62-9b93-9042707960e1 | SPXL | 2026-09-22 12:36 | put_vertical_spread | 2 | 1 | 7 | 131033.00 | long | ask | 293.7000 | 4.2000 | ["385","390"] | ["1.7714","1.8016"] | ["385.03"] | ["XMIO"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9eb-c7df-72b2-acb6-af9b65368a10 | SPXL | 2026-09-22 12:21 | put_vertical_spread | 2 | 1 | 9 | 168489.00 | long | ask | 293.7707 | 4.2000 | ["385","390"] | ["1.0220","1.8258"] | ["385.03"] | ["BATO"] | 385.0000 | 390.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0b0eb-536b-79c3-84e8-88fe74751cc2 | SPXL | 2026-09-17 15:50 | call_vertical_spread | 2 | 1 | 20 | 273000.00 | long | ask | 280.9700 | 7.2000 | ["310","315"] | ["0.4020","0.4002"] | ["312"] | ["MCRY"] | 310.0000 | 315.0000 | 855 | 855 | false | true | false | true | |||||||||
| 01a0b054-0123-72d1-978c-345219b5c297 | SPXL | 2026-09-17 13:04 | call_vertical_spread | 2 | 1 | 63 | 812070.00 | long | ask | 280.4750 | 6.6000 | ["320","325"] | ["0.4009","0.3992"] | ["321.90"] | ["XISX"] | 320.0000 | 325.0000 | 855 | 855 | false | true | false | true | |||||||||
| 01a0ab66-58c3-77b2-95b2-af61774ee124 | SPXL | 2026-09-16 14:06 | put_calendar | 2 | 1 | 50 | 107550.00 | long | ask | 278.3400 | 3.4000 | ["130"] | ["0.6945"] | [] | ["BATO"] | 130.0000 | 130.0000 | 457 | 492 | false | true | true | false | |||||||||
| 01a0ab2e-9753-7673-b9bd-64d629ee4866 | SPXL | 2026-09-16 13:05 | call_vertical_spread | 2 | 1 | 9 | 217089.00 | long | ask | 277.2856 | 4.6000 | ["155","160"] | ["4.2106","4.0340"] | ["159.97"] | ["XCBO"] | 155.0000 | 160.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aaff-e633-7e92-b176-38565fce0adc | SPXL | 2026-09-16 12:14 | call_vertical_spread | 2 | 1 | 6 | 145386.00 | long | ask | 278.3350 | 2.4000 | ["155","160"] | ["3.6022","3.4746"] | ["159.97"] | ["BATO"] | 155.0000 | 160.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aaf8-124b-7073-b2d8-0961b028fd88 | SPXL | 2026-09-16 12:06 | put_vertical_spread | 2 | 1 | 7 | 117747.00 | long | ask | 278.4457 | 1.4000 | ["360","365"] | ["1.5280","1.5523"] | ["360.03"] | ["BATO"] | 360.0000 | 365.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aac8-578b-7072-becd-e1f6cbdba2a8 | SPXL | 2026-09-16 11:14 | put_calendar | 2 | 1 | 50 | 106050.00 | long | ask | 278.6800 | 4.4000 | ["130"] | ["0.6917"] | [] | ["BATO"] | 130.0000 | 130.0000 | 457 | 492 | false | true | true | false | |||||||||
| 01a0a17c-def8-7142-9ebb-68bcbca9e874 | SPXL | 2026-09-14 15:55 | call_diagonal_spread | 2 | 1 | 25 | 112500.00 | short | ask | 279.1500 | 3.8000 | ["280","295"] | ["0.4197","0.3896"] | [] | ["XMIO"] | 280.0000 | 295.0000 | 95 | 123 | false | true | true | true | |||||||||
| 01a0a08e-f8a0-70d0-ba70-391e655de0ff | SPXL | 2026-09-14 11:35 | call_calendar | 2 | 1 | 13 | 157222.00 | long | ask | 279.3400 | 8.1000 | ["280"] | ["0.4264"] | [] | ["XMIO"] | 280.0000 | 280.0000 | 459 | 494 | false | true | true | false | |||||||||
| 01a087bd-e200-7a73-9b97-eb8ffe9d9b54 | SPXL | 2026-09-09 15:56 | call_diagonal_spread | 2 | 6 | 9 | 114790.00 | long | ask | 281.2200 | 5.5000 | ["220","280"] | ["0.5589","0.4345"] | [] | ["ARCO","SPHR","XBOX","XISX","XPHO"] | 220.0000 | 280.0000 | 37 | 499 | false | false | true | true | |||||||||
| 01a087bd-16e0-7b01-8213-70a7a3455121 | SPXL | 2026-09-09 15:55 | call_diagonal_spread | 2 | 1 | 8 | 102032.00 | long | ask | 281.1342 | 5.5000 | ["220","280"] | ["0.5674","0.4349"] | [] | ["EMLD"] | 220.0000 | 280.0000 | 37 | 499 | false | false | true | true | |||||||||
| 01a0877c-a6c8-7772-9251-d30250c4684a | SPXL | 2026-09-09 14:44 | call_vertical_spread | 2 | 1 | 20 | 176800.00 | long | ask | 282.2000 | 3.6000 | ["325","330"] | ["0.4148","0.4116"] | ["327"] | ["XMIO"] | 325.0000 | 330.0000 | 499 | 499 | false | true | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:16:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:14:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:04:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:03:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:43:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:37:00Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:21:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:50:13Z"} |
| 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-17T17:05:19Z"} |
| 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-16T18:06:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:06:44Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:15:32Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:07:08Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:14:39Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:55:23Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:35:28Z"} |
| 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-09T19:56:07Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:55:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:44:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |