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 |
|---|
| 01a0c9bf-e966-7083-86aa-3eb8b1f3ce30 | CRM | 2026-09-22 11:33 | call_diagonal_spread | 2 | 1 | 26 | 191568.00 | short | ask | 230.7500 | 4.0000 | ["195","200"] | ["0.5146","0.4351"] | [] | ["BATO"] | 195.0000 | 200.0000 | 24 | 59 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:33:42Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c962-aa4f-7083-8d63-c0da4d6a8daa | CRM | 2026-09-22 09:51 | call_diagonal_spread | 2 | 1 | 25 | 295025.00 | short | ask | 236.2400 | 6.7500 | ["185","230"] | ["0.4655","0.4526"] | [] | ["XCBO"] | 185.0000 | 230.0000 | 268 | 360 | false | false | true | true | |||||||||
| 01a0c95a-9017-7f60-ac80-81c0b475dfd6 | CRM | 2026-09-22 09:42 | call_diagonal_spread | 2 | 1 | 25 | 300825.00 | short | ask | 237.8950 | 6.4000 | ["185","230"] | ["0.4642","0.4522"] | [] | ["XCBO"] | 185.0000 | 230.0000 | 268 | 360 | false | false | true | true | |||||||||
| 01a0c58a-986f-7fc1-8d4c-3b2ea5eb2186 | CRM | 2026-09-21 15:56 | call_diagonal_spread | 2 | 2 | 50 | 591950.00 | short | ask | 236.4400 | 4.1500 | ["185","230"] | ["0.4650","0.4527"] | [] | ["XCBO"] | 185.0000 | 230.0000 | 269 | 361 | false | false | true | true | |||||||||
| 01a0b5d8-e418-7dc1-aede-da742434f10c | CRM | 2026-09-18 14:48 | call_diagonal_spread | 2 | 2 | 92 | 175352.00 | short | bid | 239.4700 | 1.1500 | ["240","250"] | ["0.3936","0.3772"] | [] | ["EDGO","XCBO"] | 240.0000 | 250.0000 | 28 | 42 | false | true | true | true | |||||||||
| 01a0b4d1-20a7-7ad1-8d74-7c11c80118a3 | CRM | 2026-09-18 09:59 | put_vertical_spread | 2 | 1 | 100 | 120800.00 | short | bid | 239.3400 | 1.8000 | ["242.5","247.5"] | ["0.6903","0.8738"] | ["242.92"] | ["XISX"] | 242.5000 | 247.5000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0b0be-ec3b-7c72-b80b-f61aaee3d03f | CRM | 2026-09-17 15:01 | put_vertical_spread | 2 | 1 | 50 | 1125000.00 | short | bid | 245.0000 | 6.0000 | ["340","350"] | ["0.5097","0.5115"] | ["342.50"] | ["AMXO"] | 340.0000 | 350.0000 | 491 | 491 | true | false | false | true | |||||||||
| 01a0afce-bfdb-7190-9490-87a493d2219d | CRM | 2026-09-17 10:39 | call_diagonal_spread | 2 | 2 | 54 | 375327.00 | short | ask | 242.3300 | 4.1000 | ["210","240"] | ["0.4775","0.4535"] | [] | ["C2OX","XPHO"] | 210.0000 | 240.0000 | 29 | 183 | false | false | true | true | |||||||||
| 01a0afa2-54c3-7473-811c-a9ff156d1d7a | CRM | 2026-09-17 09:50 | call_vertical_spread | 2 | 1 | 65 | 953940.00 | short | bid | 243.2900 | 6.5000 | ["170","260"] | ["0.4604","0.4550"] | ["216"] | ["XMIO"] | 170.0000 | 260.0000 | 491 | 491 | false | false | false | true | |||||||||
| 01a0af96-4abb-71f3-9adc-9bc0391f30e0 | CRM | 2026-09-17 09:37 | put_condor | 4 | 1 | 48 | 128784.00 | short | bid | 243.7050 | 5.7800 | ["242.5","245","247.5","257.5"] | ["0.6400","0.6581","0.6714","0.9016"] | ["250.03"] | ["BATO"] | 242.5000 | 257.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0aba1-e2f3-7d92-b291-f83903c5a166 | CRM | 2026-09-16 15:11 | call_vertical_spread | 2 | 1 | 20 | 161560.00 | short | bid | 251.1300 | 3.6000 | ["210","212.5"] | ["1.4433","1.3527"] | [] | ["ARCO"] | 210.0000 | 212.5000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aa83-5b63-7912-96bc-2c1bfbb561b6 | CRM | 2026-09-16 09:58 | call_calendar | 2 | 6 | 11 | 142596.00 | short | bid | 254.5100 | 3.9909 | ["190"] | ["1.2519"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 190.0000 | 190.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a588-062e-73c3-b782-e4a935774903 | CRM | 2026-09-15 10:45 | time_butterfly | 3 | 4 | 138 | 232368.00 | short | bid | 256.3300 | 2.0700 | ["230","265","330"] | ["0.4141","0.4330","0.4191"] | [] | ["AMXO","MCRY","XISX","XPHO"] | 230.0000 | 330.0000 | 10 | 66 | false | false | true | true | |||||||||
| 01a0a588-062e-73c3-b782-e49a3ccce42f | CRM | 2026-09-15 10:45 | time_butterfly | 3 | 6 | 102 | 172488.00 | short | bid | 256.3300 | 2.1141 | ["230","265","330"] | ["0.4151","0.4354","0.4210"] | [] | ["MCRY","SPHR","XBOX","XISX","XPHO"] | 230.0000 | 330.0000 | 10 | 66 | false | false | true | ||||||||||
| 01a0a587-bbf6-7051-b3e8-dc294f036b13 | CRM | 2026-09-15 10:45 | time_butterfly | 3 | 2 | 60 | 101680.00 | short | bid | 256.1350 | 3.0600 | ["230","265","330"] | ["0.4146","0.4403","0.4283"] | [] | ["BATO","EDGO"] | 230.0000 | 330.0000 | 10 | 66 | false | false | true | true | |||||||||
| 01a0a131-f731-7f50-89fc-41bb82de645a | CRM | 2026-09-14 14:33 | call_diagonal_spread | 2 | 1 | 46 | 495328.00 | short | bid | 259.0850 | 3.5000 | ["195","220"] | ["0.4598","0.7456"] | [] | ["EDGO"] | 195.0000 | 220.0000 | 4 | 95 | false | false | true | true | |||||||||
| 01a0a09c-0090-7020-9732-95a0f3e5c88f | CRM | 2026-09-14 11:49 | put_vertical_spread | 2 | 1 | 8 | 271112.00 | short | bid | 256.9600 | 3.6000 | ["290","550"] | ["0.4468","0.9257"] | ["301.55"] | ["ARCO"] | 290.0000 | 550.0000 | 123 | 123 | false | false | false | true | |||||||||
| 01a0a07f-f0f9-7bb1-b22b-4ef5befde26a | CRM | 2026-09-14 11:18 | call_diagonal_spread | 2 | 1 | 10 | 109400.00 | short | ask | 255.6400 | 4.4000 | ["200","220"] | ["1.4749","0.4489"] | [] | ["ARCO"] | 200.0000 | 220.0000 | 4 | 186 | false | false | true | true | |||||||||
| 01a0a043-bed0-7da2-8354-dd50a4096728 | CRM | 2026-09-14 10:13 | call_calendar | 2 | 1 | 11 | 183810.00 | short | bid | 253.0850 | 4.3000 | ["170"] | ["1.4176"] | [] | ["ARCO"] | 170.0000 | 170.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a090ea-3db1-7433-a72b-5bb65f82e26f | CRM | 2026-09-11 10:41 | call_vertical_spread | 2 | 2 | 10 | 119900.00 | short | bid | 247.7800 | 2.5000 | ["185","190"] | ["5.9330","5.4618"] | [] | ["EMLD","XISX"] | 185.0000 | 190.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0879b-3318-7bd0-ab50-337767d4ab6d | CRM | 2026-09-09 15:18 | call_calendar | 2 | 2 | 166 | 537010.00 | short | bid | 244.0500 | 2.8500 | ["230"] | ["0.5623"] | [] | ["AMXO","XISX"] | 230.0000 | 230.0000 | 2 | 16 | false | false | true | false | |||||||||
| 01a0879b-3318-7bd0-ab50-3369e79dd9ba | CRM | 2026-09-09 15:18 | call_calendar | 2 | 1 | 83 | 268754.00 | short | bid | 244.0500 | 2.8500 | ["230"] | ["0.5653"] | [] | ["XMIO"] | 230.0000 | 230.0000 | 2 | 16 | false | false | true | false | |||||||||
| 01a0828c-52d0-7050-9197-7bef519de711 | CRM | 2026-09-08 15:43 | call_calendar | 2 | 1 | 10 | 156000.00 | short | ask | 249.2850 | 5.3500 | ["220"] | ["0.4454"] | [] | ["XISX"] | 220.0000 | 220.0000 | 465 | 829 | false | false | true | false | |||||||||
| 01a0824d-f5f9-7e73-a210-482be5b16eb9 | CRM | 2026-09-08 14:35 | call_vertical_spread | 2 | 1 | 30 | 108780.00 | short | bid | 245.9900 | 4.8000 | ["227.5","230"] | ["0.6970","0.6480"] | ["229.9"] | ["XISX"] | 227.5000 | 230.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a06db5-74a5-78a3-8697-c9926b0510b9 | CRM | 2026-09-04 14:36 | call_calendar | 2 | 4 | 58 | 160368.00 | short | bid | 260.4750 | 4.1621 | ["247.5"] | ["1.9604"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 247.5000 | 247.5000 | 0 | 7 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:51:28Z"} |
| 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-22T13:42:33Z"} |
| 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-21T19:56:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:48:07Z"} |
| 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-18T14:00: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-17T19:01:49Z"} |
| 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-17T14:39:22Z"} |
| 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-17T13:50:47Z"} |
| 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-17T13:37:51Z"} |
| 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-16T19:11:47Z"} |
| 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-16T13:59:05Z"} |
| 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-15T14:46:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:46:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:46:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:33:27Z"} |
| 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:49:47Z"} |
| 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:19:03Z"} |
| 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-14T14:13:31Z"} |
| 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-11T14:41:04Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:18:25Z"} |
| 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:18:25Z"} |
| 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-08T19:44:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:36:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:37:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |