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 | direction |
|---|
| 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 |
|---|
| 01a0d420-19c7-7011-b5fb-5fc24650ad98 | CRWD | 2026-09-24 11:54 | call_diagonal_spread | 2 | 1 | 80 | 1397600.00 | unknown | ask | 261.2900 | 4.0500 | ["280","370"] | ["0.6335","0.6231"] | [] | ["XCBO"] | 280.0000 | 370.0000 | 813 | 848 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:54:59Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf0b-4227-7712-ba12-ff5af03bdeeb | CRWD | 2026-09-23 12:13 | put_vertical_spread | 2 | 1 | 300 | 1549500.00 | short | bid | 260.9000 | 0.9500 | ["240","255"] | ["0.5989","0.5923"] | ["248.15"] | ["XISX"] | 240.0000 | 255.0000 | 114 | 114 | false | true | false | ||||||||||
| 01a0ca6f-8a57-7f51-829e-b46f7940fcd3 | CRWD | 2026-09-22 14:45 | call_diagonal_spread | 2 | 1 | 9 | 183870.00 | unknown | ask | 249.9850 | 6.8000 | ["150","160"] | ["0.6675","0.6324"] | [] | ["XCBO"] | 150.0000 | 160.0000 | 115 | 178 | false | false | true | ||||||||||
| 01a0ca0e-ad77-7cc2-9a1e-208c5acd5759 | CRWD | 2026-09-22 12:59 | call_diagonal_spread | 2 | 1 | 30 | 318150.00 | long | ask | 248.4100 | 1.9000 | ["150","250"] | ["0.6666","0.5960"] | [] | ["XISX"] | 150.0000 | 250.0000 | 3 | 87 | false | false | true | ||||||||||
| 01a0c51f-95e7-73a0-acc1-957c7d0802f9 | CRWD | 2026-09-21 13:59 | call_vertical_spread | 2 | 1 | 25 | 215375.00 | long | ask | 248.2400 | 1.3000 | ["205","210"] | ["0.5730","0.5566"] | ["209.55"] | ["C2OX"] | 205.0000 | 210.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0b5d9-8057-7800-ae9f-9d33bbca5bd8 | CRWD | 2026-09-18 14:48 | call_diagonal_spread | 2 | 1 | 36 | 131940.00 | unknown | bid | 239.4100 | 2.5500 | ["225","240"] | ["3.8359","0.5389"] | [] | ["C2OX"] | 225.0000 | 240.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b564-aa2f-7892-8c9e-e0efb0b2945e | CRWD | 2026-09-18 12:41 | call_diagonal_spread | 2 | 2 | 12 | 123930.00 | short | bid | 237.5300 | 3.0750 | ["187.5","200"] | ["5.1009","0.5827"] | [] | ["XCBO"] | 187.5000 | 200.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b54e-1cbf-7c60-ae48-5b32b20e4f2a | CRWD | 2026-09-18 12:16 | call_diagonal_spread | 2 | 1 | 36 | 816660.00 | short | ask | 238.0500 | 7.5000 | ["125","130"] | ["21.1785","0.4674"] | [] | ["EDGO"] | 125.0000 | 130.0000 | 0 | 182 | false | false | true | ||||||||||
| 01a0b534-5330-7573-bbcb-c8ea10efec80 | CRWD | 2026-09-18 11:48 | other | 2 | 1 | 6 | 138780.00 | unknown | bid | 238.3300 | 2.4000 | ["85","310"] | ["22.6355","0.6176"] | [] | ["XISX"] | 85.0000 | 310.0000 | 0 | 91 | false | false | true | true | |||||||||
| 01a0b509-b8ef-7a63-a1f6-afa1a04500c1 | CRWD | 2026-09-18 11:01 | call_diagonal_spread | 2 | 2 | 8 | 130480.00 | short | ask | 237.0050 | 5.8500 | ["160","180"] | ["0.6439","0.6162"] | [] | ["XCBO"] | 160.0000 | 180.0000 | 91 | 272 | false | false | true | ||||||||||
| 01a0b4ee-0ee7-7993-b4cd-1105beb91c7a | CRWD | 2026-09-18 10:31 | call_diagonal_spread | 2 | 1 | 20 | 345500.00 | short | ask | 237.2000 | 10.1500 | ["125","260"] | ["16.0546","0.5964"] | [] | ["C2OX"] | 125.0000 | 260.0000 | 0 | 455 | false | false | true | ||||||||||
| 01a0b0b5-a922-7bd3-9755-b295d8197ad4 | CRWD | 2026-09-17 14:51 | call_calendar | 2 | 2 | 4 | 112040.00 | unknown | — | 247.3300 | 6.2500 | ["107.5"] | ["4.2059"] | [] | ["XCBO"] | 107.5000 | 107.5000 | 1 | 29 | false | false | true | false | false | ||||||||
| 01a0b0a0-6f8a-7511-b3f0-1e12ed339ae5 | CRWD | 2026-09-17 14:28 | call_calendar | 2 | 2 | 3 | 114930.00 | long | bid | 246.1550 | 9.1500 | ["55"] | ["6.4343"] | [] | ["XCBO"] | 55.0000 | 55.0000 | 1 | 120 | false | false | true | false | |||||||||
| 01a0b065-3b4b-76c0-9d2f-3b495ce78d7d | CRWD | 2026-09-17 13:23 | call_diagonal_spread | 2 | 1 | 18 | 524700.00 | short | bid | 247.3700 | 10.6500 | ["105","110"] | ["9.2421","0.5831"] | [] | ["XCBO"] | 105.0000 | 110.0000 | 1 | 456 | false | false | true | ||||||||||
| 01a0affc-6372-74b2-b1f3-ee40beaf35e0 | CRWD | 2026-09-17 11:29 | other | 2 | 1 | 6 | 188670.00 | unknown | — | 245.0800 | 6.1000 | ["38.75","350"] | ["13.8380","0.6437"] | [] | ["XISX"] | 38.7500 | 350.0000 | 1 | 92 | false | false | true | true | true | mesl | |||||||
| 01a0afeb-aa33-7c42-a614-56352db267b6 | CRWD | 2026-09-17 11:10 | call_diagonal_spread | 2 | 1 | 4 | 104240.00 | short | ask | 246.0600 | 6.3500 | ["117.5","120"] | ["9.7801","0.6310"] | [] | ["XISX"] | 117.5000 | 120.0000 | 1 | 155 | false | false | true | ||||||||||
| 01a0afd8-261b-7f11-a075-2cb2a603415a | CRWD | 2026-09-17 10:49 | put_vertical_spread | 2 | 1 | 26 | 238680.00 | short | bid | 247.2500 | 3.7000 | ["190","200"] | ["0.6354","0.6344"] | ["195.20"] | ["XCBO"] | 190.0000 | 200.0000 | 820 | 820 | false | true | false | ||||||||||
| 01a0aae1-a033-7513-9323-e4f171b0f446 | CRWD | 2026-09-16 11:41 | call_diagonal_spread | 2 | 2 | 18 | 122520.00 | long | bid | 244.1400 | 1.4722 | ["187.5","245"] | ["2.1718","0.5755"] | [] | ["XCBO"] | 187.5000 | 245.0000 | 2 | 16 | false | false | true | ||||||||||
| 01a0a5d4-16d6-7aa0-91e8-dea88d03b8e1 | CRWD | 2026-09-15 12:08 | call_vertical_spread | 2 | 2 | 4 | 134900.00 | short | bid | 239.9116 | 10.8000 | ["60","85"] | ["1.7302","0.9408"] | ["83.55"] | ["XCBO"] | 60.0000 | 85.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a5be-4cb6-7041-9c18-75ed706b4b7a | CRWD | 2026-09-15 11:45 | call_diagonal_spread | 2 | 1 | 15 | 198665.00 | short | bid | 240.4926 | 4.1933 | ["140","265"] | ["0.6271","0.5740"] | [] | ["XCBO"] | 140.0000 | 265.0000 | 38 | 493 | false | false | true | ||||||||||
| 01a0a092-e0a1-7a81-84b8-bb39df6b0722 | CRWD | 2026-09-14 11:39 | other | 3 | 1 | 22 | 101750.00 | unknown | — | 237.5900 | 1.7500 | ["200","230","240"] | ["0.9556","0.7379","0.7319"] | [] | ["XCBO"] | 200.0000 | 240.0000 | 4 | 4 | false | false | false | true | true | ||||||||
| 01a0a08d-f6d0-7762-a571-15f3e42ae352 | CRWD | 2026-09-14 11:34 | other | 2 | 1 | 46 | 595470.00 | unknown | — | 237.3150 | 6.4500 | ["175","200"] | ["0.6216","0.5920"] | [] | ["C2OX"] | 175.0000 | 200.0000 | 123 | 158 | false | false | true | true | false | mesl | |||||||
| 01a0a08d-ef00-7e10-ae19-8809bac2a01e | CRWD | 2026-09-14 11:34 | other | 2 | 1 | 300 | 1291500.00 | unknown | — | 237.3150 | 2.0500 | ["220","225"] | ["0.6018","0.5853"] | [] | ["C2OX"] | 220.0000 | 225.0000 | 95 | 123 | false | true | true | true | false | mesl | |||||||
| 01a08249-9cb0-7091-b303-e7943ca55d12 | CRWD | 2026-09-08 14:30 | call_diagonal_spread | 2 | 2 | 10 | 179450.00 | short | bid | 209.8900 | 6.0500 | ["150","180"] | ["0.6270","0.5909"] | [] | ["XPHO"] | 150.0000 | 180.0000 | 465 | 829 | false | false | true | ||||||||||
| 01a08249-9cb0-7091-b303-e789208a9edb | CRWD | 2026-09-08 14:30 | call_diagonal_spread | 2 | 2 | 18 | 323010.00 | short | bid | 209.8900 | 6.0500 | ["150","180"] | ["0.6274","0.5906"] | [] | ["XPHO"] | 150.0000 | 180.0000 | 465 | 829 | false | false | true | ||||||||||
| 01a08181-2c30-72e0-8edf-4a36a4f6cf09 | CRWD | 2026-09-08 10:51 | other | 2 | 1 | 21 | 202650.00 | unknown | — | 208.0950 | 9.4500 | ["160","165"] | ["1.4531","0.5413"] | [] | ["XCBO"] | 160.0000 | 165.0000 | 3 | 73 | false | false | true | true | false | mesl | |||||||
| 01a08171-d280-7ac3-953d-fc2ac5bd9b19 | CRWD | 2026-09-08 10:35 | call_diagonal_spread | 2 | 1 | 10 | 127200.00 | short | ask | 207.6250 | 7.0000 | ["125","250"] | ["1.6294","0.5595"] | [] | ["C2OX"] | 125.0000 | 250.0000 | 10 | 500 | false | false | true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:14:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:45:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:59:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:00:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:48:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:41:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:17:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:48:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:01:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:31:40Z"} |
| 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-17T18:51:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:28:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:24:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:29:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:10:50Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:49:52Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:42:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:09:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:45:21Z"} |
| 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:39:46Z"} |
| 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-14T15:34:16Z"} |
| 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-14T15:34:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:31:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:31:18Z"} |
| 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-08T14:52:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:35:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |