core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d998-eb27-7550-9dfe-7931557fbfa3 | SPCH | 2026-09-25 13:24 | call_vertical_spread | 2 | 1 | 188 | 311892.00 | long | ask | 9.7699 | 0.6000 | ["1","2"] | ["7.8288","5.7484"] | ["1.99"] | ["XISX"] | 1.0000 | 2.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T17:24:48Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d998-a0ef-77c0-b857-9eb963d6eee0 | SPCH | 2026-09-25 13:24 | call_vertical_spread | 2 | 1 | 188 | 311892.00 | long | ask | 9.7650 | 0.6000 | ["1","2"] | ["8.1069","5.8979"] | ["1.99"] | ["XISX"] | 1.0000 | 2.0000 | 7 | 7 | true | false | |||||||||||
| 01a0d998-338f-73e0-a207-c0a0ad942ab9 | SPCH | 2026-09-25 13:23 | call_vertical_spread | 2 | 1 | 88 | 145640.00 | long | ask | 9.7650 | 0.6000 | ["1","2"] | ["6.4261","5.1406"] | ["1.99"] | ["XISX"] | 1.0000 | 2.0000 | 7 | 7 | true | false | |||||||||||
| 01a0d995-2266-7331-b442-4519465cd51c | SPCH | 2026-09-25 13:20 | put_vertical_spread | 2 | 1 | 88 | 126632.00 | long | ask | 9.7668 | 0.6000 | ["16.5","17.5"] | ["21.3308","18.9808"] | ["16.51"] | ["XISX"] | 16.5000 | 17.5000 | 0 | 0 | false | false | |||||||||||
| 01a0d995-0327-7873-9d9a-c9d62ac2dfef | SPCH | 2026-09-25 13:20 | put_vertical_spread | 2 | 1 | 188 | 270532.00 | long | ask | 9.7699 | 0.6000 | ["16.5","17.5"] | ["21.4074","19.1252"] | ["16.51"] | ["XISX"] | 16.5000 | 17.5000 | 0 | 0 | true | false | |||||||||||
| 01a0d994-c4a7-73d2-9f32-c7ee4ce61bcc | SPCH | 2026-09-25 13:19 | put_vertical_spread | 2 | 1 | 80 | 115120.00 | long | ask | 9.7706 | 0.6000 | ["16.5","17.5"] | ["21.4087","19.1431"] | ["16.51"] | ["XISX"] | 16.5000 | 17.5000 | 0 | 0 | true | false | |||||||||||
| 01a0d4e5-426e-7692-a0d9-802982a13dd6 | SPCH | 2026-09-24 15:29 | call_vertical_spread | 2 | 1 | 80 | 141680.00 | long | ask | 9.5450 | 0.5000 | ["0.5","1"] | ["33.4903","25.4600"] | ["0.99"] | ["XISX"] | 0.5000 | 1.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d4e3-bfb7-7df1-997e-cb76e2f5b5d6 | SPCH | 2026-09-24 15:28 | call_vertical_spread | 2 | 1 | 88 | 155848.00 | long | ask | 9.5600 | 0.5000 | ["0.5","1"] | ["31.3651","24.1721"] | ["0.99"] | ["XISX"] | 0.5000 | 1.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d434-e9e7-7d93-9a5b-9db7184c6d26 | SPCH | 2026-09-24 12:17 | call_vertical_spread | 2 | 1 | 200 | 355200.00 | long | ask | 9.7550 | 0.7000 | ["0.5","1"] | ["32.2464","23.8331"] | ["1"] | ["XCBO"] | 0.5000 | 1.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d430-698f-7c61-938d-1d1c526c7ea1 | SPCH | 2026-09-24 12:12 | call_vertical_spread | 2 | 1 | 99 | 176121.00 | long | ask | 9.7050 | 0.7000 | ["0.5","1"] | ["38.3075","27.7918"] | ["0.99"] | ["XISX"] | 0.5000 | 1.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d430-32df-75c2-84c2-96340bb0342a | SPCH | 2026-09-24 12:12 | call_vertical_spread | 2 | 1 | 99 | 176121.00 | long | ask | 9.6950 | 0.7000 | ["0.5","1"] | ["39.3571","28.4481"] | ["0.99"] | ["XISX"] | 0.5000 | 1.0000 | 1 | 1 | false | false | |||||||||||
| 01a0cfac-ba17-7991-9cb9-2ad7521e4c05 | SPCH | 2026-09-23 15:09 | call_vertical_spread | 2 | 1 | 99 | 181269.00 | long | ask | 9.8850 | 0.5000 | ["0.5","1"] | ["18.8610","15.2742"] | ["0.99"] | ["XISX"] | 0.5000 | 1.0000 | 2 | 2 | false | false | |||||||||||
| 01a0c9fe-7137-7400-a8b9-a5993e849639 | SPCH | 2026-09-22 12:41 | call_vertical_spread | 2 | 1 | 150 | 133500.00 | long | ask | 10.4105 | 4.0000 | ["18","20"] | ["0.9660","0.9753"] | ["18.20"] | ["XCBO"] | 18.0000 | 20.0000 | 850 | 850 | false | true | |||||||||||
| 01a0c99d-136f-7c41-8bb4-31e83830b72b | SPCH | 2026-09-22 10:55 | call_vertical_spread | 2 | 1 | 200 | 181800.00 | long | ask | 10.6393 | 3.6000 | ["18","20"] | ["0.9602","0.9622"] | ["18.25"] | ["XISX"] | 18.0000 | 20.0000 | 850 | 850 | true | true | |||||||||||
| 01a0b5f8-8d90-79d1-b0c7-555bbdeff197 | SPCH | 2026-09-18 15:22 | call_vertical_spread | 2 | 1 | 220 | 375980.00 | long | ask | 10.3699 | 0.9000 | ["1.5","2"] | ["9.3228","7.8861"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 7 | 7 | false | false | |||||||||||
| 01a0b5f7-8bc0-7981-a9dc-e610039a7b7e | SPCH | 2026-09-18 15:21 | call_vertical_spread | 2 | 1 | 245 | 416255.00 | long | ask | 10.3480 | 0.7000 | ["1.5","2"] | ["7.6630","6.4987"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 7 | 7 | true | false | |||||||||||
| 01a0b5f5-1ac0-7812-9759-8314f21437cc | SPCH | 2026-09-18 15:18 | call_vertical_spread | 2 | 1 | 245 | 389795.00 | long | ask | 10.3250 | 0.9000 | ["2","2.5"] | ["109.5767","114.9518"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 0 | 0 | false | false | |||||||||||
| 01a0b5f4-6af7-7752-9a8a-1fc7fd36098f | SPCH | 2026-09-18 15:18 | call_vertical_spread | 2 | 1 | 248 | 394568.00 | long | ask | 10.3450 | 0.9000 | ["2","2.5"] | ["102.3557","110.5968"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 0 | 0 | true | false | |||||||||||
| 01a0b5f3-9038-72e2-9cee-d962df4ec6e3 | SPCH | 2026-09-18 15:17 | put_vertical_spread | 2 | 1 | 244 | 500444.00 | long | ask | 10.3500 | 0.7000 | ["20","21"] | ["43.6998","45.2366"] | ["20.01"] | ["XISX"] | 20.0000 | 21.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b5f0-f057-7e33-b0fd-c4f55ef23f29 | SPCH | 2026-09-18 15:14 | put_vertical_spread | 2 | 1 | 249 | 510699.00 | long | ask | 10.3102 | 0.7000 | ["20","21"] | ["39.0640","40.1750"] | ["20.01"] | ["XISX"] | 20.0000 | 21.0000 | 0 | 0 | true | false | |||||||||||
| 01a0b5db-83f7-7be1-ad98-fe808e4c2f30 | SPCH | 2026-09-18 14:50 | call_vertical_spread | 2 | 1 | 89 | 114009.00 | long | ask | 10.1150 | 0.7000 | ["3.5","4"] | ["48.5654","44.8389"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b5d7-4dd8-7a41-84ec-bfb89c446236 | SPCH | 2026-09-18 14:46 | call_vertical_spread | 2 | 1 | 249 | 318969.00 | long | ask | 10.1233 | 0.7000 | ["3.5","4"] | ["45.0012","41.8973"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b5d6-d4bf-79e1-8be9-3c0357ac15e6 | SPCH | 2026-09-18 14:45 | call_vertical_spread | 2 | 1 | 80 | 102480.00 | long | ask | 10.1150 | 0.7000 | ["3.5","4"] | ["46.8555","43.2602"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b011-acab-7af0-bde3-255ea6c150a5 | SPCH | 2026-09-17 11:52 | call_vertical_spread | 2 | 1 | 80 | 113200.00 | long | ask | 10.5601 | 0.3000 | ["3","4"] | ["10.2770","8.8628"] | ["3.99"] | ["XMIO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | |||||||||||
| 01a0b010-58d2-7d81-8e55-5d8cbbbe1db2 | SPCH | 2026-09-17 11:50 | call_vertical_spread | 2 | 1 | 80 | 113360.00 | long | ask | 10.5600 | 0.3000 | ["3","4"] | ["11.3363","9.4575"] | ["3.99"] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | |||||||||||
| 01a0b00e-ce4b-75f3-8479-6dcaac2e98d8 | SPCH | 2026-09-17 11:49 | call_vertical_spread | 2 | 1 | 88 | 124696.00 | long | ask | 10.5600 | 0.3000 | ["3","4"] | ["11.3363","9.4575"] | ["3.99"] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | |||||||||||
| 01a08743-eb58-7040-a91b-66f4cf7e8d96 | SPCH | 2026-09-09 13:42 | call_vertical_spread | 2 | 1 | 99 | 156123.00 | long | ask | 9.6400 | 0.9000 | ["1.5","2"] | ["17.9854","17.3091"] | ["1.99"] | ["XCBO"] | 1.5000 | 2.0000 | 2 | 2 | false | false | |||||||||||
| 01a08685-b7f0-7f51-9399-7c59d766968a | SPCH | 2026-09-09 10:15 | call_vertical_spread | 2 | 1 | 88 | 150920.00 | long | ask | 10.3079 | 0.5000 | ["1.5","2"] | ["11.3944","10.5571"] | ["1.99"] | ["XMIO"] | 1.5000 | 2.0000 | 2 | 2 | true | false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:24:48Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:24:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:20:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:20:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:20:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:30:12Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:28:22Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:17:21Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:12:18Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:12:18Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:10:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:41:54Z"} |
| 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-22T14:55:18Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:22:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:21:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:18:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:18:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:17:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:14:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:52:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:51:08Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:49:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:43:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:15:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |