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 |
|---|
| 01a0b5b2-4178-75c0-82b4-6e9d9956ceb2 | NEM | 2026-09-18 14:05 | call_vertical_spread | 2 | 1 | 23 | 165462.00 | long | ask | 123.4650 | 4.7000 | ["85","90"] | ["1.9636","1.7615"] | ["89.98"] | ["XISX"] | 85.0000 | 90.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:06:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ac-f9e7-7c13-be8e-57d1ddc07db2 | NEM | 2026-09-18 14:00 | call_vertical_spread | 2 | 1 | 13 | 106340.00 | long | ask | 123.6050 | 4.8000 | ["80","85"] | ["2.1228","1.9256"] | ["84.98"] | ["XPHO"] | 80.0000 | 85.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a0b548-b208-7e92-b7c7-35e38b5af641 | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 15 | 256470.00 | short | bid | 122.7300 | 5.4500 | ["37.5"] | ["1.4192"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b548-92c7-7062-9d4f-1c6e2a62e0cf | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 10 | 170980.00 | short | bid | 122.7835 | 5.4500 | ["37.5"] | ["1.4053"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b548-6f9f-7921-985c-9c76728cdd8d | NEM | 2026-09-18 12:10 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.7900 | 5.4500 | ["37.5"] | ["1.4036"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b548-0df7-7cd0-9c7f-e770809b3203 | NEM | 2026-09-18 12:09 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.7900 | 5.4500 | ["37.5"] | ["1.4036"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b546-0287-7631-93d9-37fd4fa989a5 | NEM | 2026-09-18 12:07 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.8262 | 5.4500 | ["37.5"] | ["1.3939"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b545-0888-77b2-a089-738a01766728 | NEM | 2026-09-18 12:06 | call_calendar | 2 | 1 | 6 | 102588.00 | short | bid | 122.8200 | 5.4500 | ["37.5"] | ["1.3956"] | [] | ["XMIO"] | 37.5000 | 37.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b511-17a7-7710-8478-baacbbbca746 | NEM | 2026-09-18 11:09 | call_diagonal_spread | 2 | 1 | 13 | 107822.00 | long | bid | 121.8900 | 2.2500 | ["80","85"] | ["10.4651","0.4586"] | [] | ["XISX"] | 80.0000 | 85.0000 | 0 | 182 | false | false | true | ||||||||||
| 01a0b4bf-80f0-7d13-83c5-2f069fc01a9e | NEM | 2026-09-18 09:40 | put_calendar | 2 | 2 | 200 | 174393.00 | short | ask | 122.9150 | 2.6800 | ["125"] | ["0.5753"] | [] | ["AMXO","XCBO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4bf-80f0-7d13-83c5-2eff0e565fba | NEM | 2026-09-18 09:40 | put_calendar | 2 | 3 | 500 | 443437.00 | short | bid | 122.9150 | 2.6800 | ["125"] | ["0.6550"] | [] | ["ARCO","EDGO","XISX"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b4bf-80f0-7d13-83c5-2ee49fd6c744 | NEM | 2026-09-18 09:40 | put_calendar | 2 | 5 | 250 | 217926.00 | unknown | bid | 122.9150 | 2.3100 | ["125"] | ["0.6646"] | [] | ["EMLD","MCRY","XBOX","XMIO","XPHO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0aae3-616b-79c0-ab24-e1be1b484bfc | NEM | 2026-09-16 11:43 | call_diagonal_spread | 2 | 2 | 17 | 126633.00 | unknown | — | 123.4600 | 2.1000 | ["105","120"] | ["0.4283","0.4259"] | [] | ["XISX"] | 105.0000 | 120.0000 | 492 | 856 | false | false | true | true | false | ||||||||
| 01a0aaaa-0da2-71d0-b3bd-e42a6de72642 | NEM | 2026-09-16 10:41 | call_calendar | 2 | 1 | 10 | 116540.00 | short | bid | 123.0200 | 5.1000 | ["65"] | ["2.5911"] | [] | ["XCBO"] | 65.0000 | 65.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aaa2-f53b-7b91-abc1-ebd2ad980ed8 | NEM | 2026-09-16 10:33 | call_diagonal_spread | 2 | 3 | 49 | 133461.00 | short | bid | 122.7300 | 0.6000 | ["110","120"] | ["0.8215","0.4371"] | [] | ["C2OX","EDGO","XCBO"] | 110.0000 | 120.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0a5f2-e1a6-7ea0-95d8-cd411a7237d5 | NEM | 2026-09-15 12:42 | call_diagonal_spread | 2 | 1 | 26 | 177970.00 | unknown | — | 122.6250 | 2.6000 | ["110","130"] | ["0.4443","0.4380"] | [] | ["XISX"] | 110.0000 | 130.0000 | 493 | 857 | false | false | true | true | false | ||||||||
| 01a0a073-3340-7771-bb6b-26062f130f83 | NEM | 2026-09-14 11:04 | other | 2 | 11 | 886 | 127058.00 | unknown | — | 122.3175 | 0.1060 | ["135","140"] | ["0.5644","0.4286"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"] | 135.0000 | 140.0000 | 4 | 32 | false | true | true | true | false | ||||||||
| 01a0a04c-9488-7992-8ba7-bdf4729bc2cc | NEM | 2026-09-14 10:22 | other | 2 | 1 | 39 | 196755.00 | unknown | — | 121.9800 | 5.5000 | ["155"] | ["0.4275"] | [] | ["XBOX"] | 155.0000 | 155.0000 | 823 | 858 | false | true | true | false | false | mlet | |||||||
| 01a0a035-a189-79c2-9400-e271f45d72a8 | NEM | 2026-09-14 09:57 | other | 2 | 1 | 15 | 144285.00 | unknown | — | 122.2000 | 5.5500 | ["75"] | ["1.2950"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 18 | 25 | false | false | true | false | false | mlet | |||||||
| 01a091e0-8490-7713-a316-dba7cfbd487a | NEM | 2026-09-11 15:10 | other | 4 | 1 | 20 | 120680.00 | unknown | — | 126.3900 | 7.9000 | ["130","134","140","160"] | ["2.6811","3.5159","0.4218","0.4675"] | [] | ["XPHO"] | 130.0000 | 160.0000 | 0 | 35 | false | false | true | true | false | ||||||||
| 01a09105-dc00-77b1-b7bc-eb1e75bd4f1f | NEM | 2026-09-11 11:11 | call_diagonal_spread | 2 | 2 | 300 | 339500.00 | short | ask | 126.6750 | 1.0500 | ["120","130"] | ["1.3612","0.4183"] | [] | ["XCBO","XISX"] | 120.0000 | 130.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a09105-dc00-77b1-b7bc-eb0a0fc0b0a5 | NEM | 2026-09-11 11:11 | call_diagonal_spread | 2 | 2 | 200 | 229200.00 | long | bid | 126.6750 | 1.9625 | ["120","130"] | ["1.5725","0.4229"] | [] | ["AMXO","XPHO"] | 120.0000 | 130.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a08c0f-aff0-7da0-a369-a90d836daf92 | NEM | 2026-09-10 12:03 | call_diagonal_spread | 2 | 1 | 9 | 102510.00 | short | ask | 126.4700 | 6.3000 | ["65","80"] | ["0.8982","0.3972"] | [] | ["ARCO"] | 65.0000 | 80.0000 | 99 | 372 | false | false | true | ||||||||||
| 01a086d2-5920-7503-959b-c68729a14745 | NEM | 2026-09-09 11:38 | call_calendar | 2 | 1 | 17 | 198832.00 | short | ask | 128.5850 | 5.7500 | ["70"] | ["3.4541"] | [] | ["SPHR"] | 70.0000 | 70.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a086d2-5920-7503-959b-c679319e0171 | NEM | 2026-09-09 11:38 | other | 2 | 4 | 22 | 257868.00 | unknown | — | 128.5850 | 6.3227 | ["70"] | ["3.4915"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 70.0000 | 70.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a086d1-bce0-7533-8f43-533db1a4c134 | NEM | 2026-09-09 11:38 | call_calendar | 2 | 1 | 13 | 152171.00 | short | bid | 128.5950 | 6.6500 | ["70"] | ["3.5135"] | [] | ["EDGO"] | 70.0000 | 70.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a086d1-bce0-7533-8f43-5315605726e1 | NEM | 2026-09-09 11:38 | call_calendar | 2 | 1 | 9 | 105300.00 | unknown | — | 128.5950 | 6.6500 | ["70"] | ["3.5135"] | [] | ["ARCO"] | 70.0000 | 70.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0865c-8e66-7ec3-b9d0-39d5b2858a5a | NEM | 2026-09-09 09:30 | call_vertical_spread | 2 | 1 | 50 | 177850.00 | long | ask | 128.7250 | 4.4500 | ["120","125"] | ["0.4581","0.4550"] | ["122.75"] | ["XCBO"] | 120.0000 | 125.0000 | 128 | 128 | false | false | false | ||||||||||
| 01a0865c-815f-7d03-a924-a61df9e98f2b | NEM | 2026-09-09 09:30 | call_vertical_spread | 2 | 1 | 50 | 164000.00 | unknown | — | 128.7500 | 4.8000 | ["120","125"] | ["0.4681","0.4688"] | [] | ["XCBO"] | 120.0000 | 125.0000 | 100 | 100 | false | false | false | true | false | ||||||||
| 01a08189-2729-7752-a4e2-9c354ab60660 | NEM | 2026-09-08 11:00 | other | 2 | 1 | 15 | 128010.00 | unknown | — | 129.6100 | 5.8000 | ["85","90"] | ["0.9301","0.3567"] | [] | ["ARCO"] | 85.0000 | 90.0000 | 38 | 101 | false | false | true | true | false | mlet | |||||||
| 01a06d80-b4bd-7893-9eb4-d14f74bcffe1 | NEM | 2026-09-04 13:39 | other | 2 | 3 | 175 | 123898.00 | unknown | — | 128.4050 | 0.6331 | ["130","134"] | ["0.4009","0.4108"] | [] | ["EDGO","XCBO","XPHO"] | 130.0000 | 134.0000 | 14 | 28 | false | true | true | true | false | mlet |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:00:14Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:10:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:10:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:07:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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-18T15:09:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:40:53Z"} |
| 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:40:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:44:18Z"} |
| 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-16T14:41:29Z"} |
| 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-16T14:33:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:42:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:05:33Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:22:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:57:59Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:10:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:04:08Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:49Z"} |
| 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-09T15:38:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:12Z"} |
| 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-09T13:30:03Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:03Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:39:30Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |