core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cf60-5f37-7643-8139-46be251d0bce | BABA | 2026-09-23 13:46 | call_calendar | 2 | 1 | 500 | 139000.00 | short | ask | 111.0950 | 0.2300 | ["125"] | ["0.4342"] | [] | ["XCBO"] | 125.0000 | 125.0000 | 23 | 37 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T17:47:04Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cecd-23cf-7f30-8d8e-87bbc6140588 | BABA | 2026-09-23 11:05 | call_vertical_spread | 2 | 1 | 16 | 103520.00 | short | bid | 111.8000 | 2.1000 | ["110","115"] | ["0.4288","0.4291"] | ["111.94"] | ["XPHO"] | 110.0000 | 115.0000 | 814 | 814 | false | false | |||||||||||
| 01a0ce97-df17-7931-8f9f-1fee3389577d | BABA | 2026-09-23 10:07 | call_vertical_spread | 2 | 1 | 125 | 106953.00 | short | bid | 111.1400 | 0.2500 | ["110","115"] | ["0.4150","0.4249"] | ["112.10"] | ["XCBO"] | 110.0000 | 115.0000 | 23 | 23 | false | false | |||||||||||
| 01a0ca20-261f-7b03-b9af-00aed91ff733 | BABA | 2026-09-22 13:18 | call_diagonal_spread | 2 | 1 | 150 | 242700.00 | short | ask | 116.5350 | 0.7500 | ["110","115"] | ["0.4190","0.4115"] | [] | ["XCBO"] | 110.0000 | 115.0000 | 24 | 38 | false | false | |||||||||||
| 01a0ca11-be9f-70e1-b4b0-7f9c0b6018cd | BABA | 2026-09-22 13:02 | call_butterfly_spread | 3 | 4 | 288 | 132048.00 | short | bid | 116.4700 | 0.3700 | ["135","155","175"] | ["0.4615","0.4817","0.5091"] | ["136.75","173.25"] | ["AMXO","ARCO","C2OX","XCBO"] | 135.0000 | 175.0000 | 87 | 87 | false | ||||||||||||
| 01a0c9a8-4a86-7521-97be-c9e6fa5e24c5 | BABA | 2026-09-22 11:07 | call_vertical_spread | 2 | 1 | 600 | 434400.00 | short | bid | 116.6300 | 0.4500 | ["135","150"] | ["0.4665","0.4827"] | ["137.34"] | ["XMIO"] | 135.0000 | 150.0000 | 87 | 87 | false | true | |||||||||||
| 01a0c97e-0a1f-7ea0-a807-ba236664443b | BABA | 2026-09-22 10:21 | call_vertical_spread | 2 | 2 | 250 | 195250.00 | short | bid | 118.0213 | 0.7000 | ["135","150"] | ["0.4619","0.4797"] | ["137.48"] | ["XMIO","XPHO"] | 135.0000 | 150.0000 | 87 | 87 | false | true | |||||||||||
| 01a0c48e-370f-7100-b910-8b912257c1f9 | BABA | 2026-09-21 11:20 | straddle | 2 | 1 | 400 | 912000.00 | short | bid | 114.4200 | 0.9000 | ["115"] | ["0.4458"] | ["92.20","137.80"] | ["XPHO"] | 115.0000 | 115.0000 | 116 | 116 | false | false | |||||||||||
| 01a0c47b-85e7-7c61-8ca5-290277b9048d | BABA | 2026-09-21 11:00 | put_calendar | 2 | 3 | 58 | 136706.00 | short | ask | 114.0050 | 1.3500 | ["125"] | ["0.5803"] | [] | ["ARCO","EMLD","SPHR"] | 125.0000 | 125.0000 | 4 | 18 | false | false | |||||||||||
| 01a0c44c-ffbf-7093-9202-fb97c2cf79ce | BABA | 2026-09-21 10:09 | call_diagonal_spread | 2 | 1 | 100 | 100200.00 | short | ask | 114.1200 | 0.4500 | ["110","113"] | ["0.6205","0.4977"] | [] | ["SPHR"] | 110.0000 | 113.0000 | 4 | 11 | false | false | |||||||||||
| 01a0b606-4547-7852-a46d-d227b510cc5e | BABA | 2026-09-18 15:37 | call_vertical_spread | 2 | 1 | 25 | 116075.00 | short | bid | 113.0650 | 1.2000 | ["105","170"] | ["0.4356","0.4419"] | ["124.05"] | ["EDGO"] | 105.0000 | 170.0000 | 637 | 637 | false | false | |||||||||||
| 01a0b0c0-4013-77c1-9a22-d2ae9d93e03b | BABA | 2026-09-17 15:03 | straddle | 2 | 5 | 74 | 116315.00 | short | bid | 108.4999 | 0.4000 | ["110"] | ["0.4323"] | ["94.28","125.72"] | ["AMXO","EDGO","MCRY","XISX","XPHO"] | 110.0000 | 110.0000 | 64 | 64 | false | false | |||||||||||
| 01a0afe8-27c3-7e73-bec8-533ba36a093a | BABA | 2026-09-17 11:06 | put_calendar | 2 | 1 | 100 | 152800.00 | short | ask | 107.7100 | 0.8500 | ["115"] | ["0.5880"] | [] | ["EDGO"] | 115.0000 | 115.0000 | 1 | 8 | false | false | |||||||||||
| 01a0afa5-d34b-7a00-b661-3203767edcaa | BABA | 2026-09-17 09:54 | put_vertical_spread | 2 | 1 | 110 | 210760.00 | short | bid | 107.6800 | 1.0000 | ["105","110"] | ["0.4239","0.4248"] | ["107.40"] | ["XMIO"] | 105.0000 | 110.0000 | 120 | 120 | false | false | |||||||||||
| 01a0afa4-e8ec-7b31-b0ae-d87842d0ea84 | BABA | 2026-09-17 09:53 | put_vertical_spread | 2 | 1 | 110 | 158950.00 | short | bid | 107.8350 | 1.1000 | ["105","110"] | ["0.4282","0.4280"] | ["107.45"] | ["XMIO"] | 105.0000 | 110.0000 | 64 | 64 | false | false | |||||||||||
| 01a0ab9b-91c3-7fb3-a134-e90592e4f179 | BABA | 2026-09-16 15:04 | call_vertical_spread | 2 | 1 | 30 | 194820.00 | short | bid | 107.5400 | 2.0000 | ["80","90"] | ["0.4226","0.4239"] | ["86.40"] | ["XCBO"] | 80.0000 | 90.0000 | 366 | 366 | false | false | |||||||||||
| 01a0ab9a-8823-7413-b85d-adfdfaf84856 | BABA | 2026-09-16 15:03 | call_vertical_spread | 2 | 1 | 39 | 145860.00 | short | bid | 107.5600 | 1.2500 | ["90","100"] | ["0.4417","0.4370"] | ["96.62"] | ["XCBO"] | 90.0000 | 100.0000 | 121 | 121 | false | false | |||||||||||
| 01a0aa86-68a2-7361-b58b-3155df65cfde | BABA | 2026-09-16 10:02 | put_vertical_spread | 2 | 1 | 75 | 164100.00 | short | bid | 107.6104 | 1.8500 | ["115","120"] | ["0.4607","0.4915"] | ["115.72"] | ["XCBO"] | 115.0000 | 120.0000 | 16 | 16 | false | false | |||||||||||
| 01a0aa84-6cd3-71d0-9a1f-67d9b7a83ab5 | BABA | 2026-09-16 09:59 | put_vertical_spread | 2 | 1 | 150 | 163350.00 | short | bid | 107.5010 | 1.3500 | ["105","110"] | ["0.4081","0.4107"] | ["107.41"] | ["XCBO"] | 105.0000 | 110.0000 | 37 | 37 | true | false | |||||||||||
| 01a0aa81-4ff3-7083-b308-bbecdf129efc | BABA | 2026-09-16 09:56 | put_vertical_spread | 2 | 1 | 200 | 183200.00 | short | bid | 107.4741 | 0.7000 | ["105","110"] | ["0.4262","0.4284"] | ["107.42"] | ["XCBO"] | 105.0000 | 110.0000 | 23 | 23 | false | false | |||||||||||
| 01a0a640-9446-7c33-8dd1-f9ccc71a2a59 | BABA | 2026-09-15 14:07 | straddle | 2 | 1 | 70 | 140700.00 | short | bid | 110.0264 | 0.4500 | ["115"] | ["0.4396"] | ["94.90","135.10"] | ["AMXO"] | 115.0000 | 115.0000 | 94 | 94 | false | false | |||||||||||
| 01a0913f-2fc8-7c40-8390-c1f6576b2812 | BABA | 2026-09-11 12:13 | put_calendar | 2 | 1 | 10 | 102200.00 | short | bid | 109.4025 | 1.1000 | ["160"] | ["0.5653"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 70 | 189 | false | false | |||||||||||
| 01a08c7d-c3a0-7d00-9636-c46bce4ad88b | BABA | 2026-09-10 14:04 | call_vertical_spread | 2 | 1 | 200 | 284200.00 | short | bid | 108.7700 | 0.4500 | ["110","115"] | ["0.4321","0.4363"] | ["111.95"] | ["XCBO"] | 110.0000 | 115.0000 | 71 | 71 | false | true | |||||||||||
| 01a08bd9-1f30-70c0-ba94-2a96cd4b181e | BABA | 2026-09-10 11:04 | put_calendar | 2 | 1 | 2540 | 4622800.00 | short | bid | 108.9150 | 1.1000 | ["118"] | ["0.5254"] | [] | ["XPHO"] | 118.0000 | 118.0000 | 1 | 8 | false | false | |||||||||||
| 01a08bd0-5530-74a2-86c0-215984fcaa08 | BABA | 2026-09-10 10:54 | put_calendar | 2 | 1 | 39 | 206544.00 | short | ask | 108.8300 | 1.7500 | ["135"] | ["0.7008"] | [] | ["XISX"] | 135.0000 | 135.0000 | 8 | 36 | false | false | |||||||||||
| 01a08bae-6d80-7413-a290-334955fdb39a | BABA | 2026-09-10 10:17 | put_vertical_spread | 2 | 1 | 53 | 257474.00 | short | bid | 107.7600 | 3.1000 | ["132","133"] | ["2.1152","2.7189"] | ["0","132"] | ["XCBO"] | 132.0000 | 133.0000 | 1 | 1 | false | false | |||||||||||
| 01a086e8-4669-7c31-b48b-a5d2f907152a | BABA | 2026-09-09 12:02 | put_diagonal_spread | 2 | 1 | 32 | 134400.00 | short | bid | 109.8700 | 1.1000 | ["125","130"] | ["0.4442","0.5805"] | [] | ["XMIO"] | 125.0000 | 130.0000 | 9 | 191 | false | false | |||||||||||
| 01a086b0-1799-7eb2-958c-b4fabd646202 | BABA | 2026-09-09 11:01 | put_vertical_spread | 2 | 1 | 21 | 131628.00 | short | bid | 109.9700 | 2.9000 | ["141","142"] | ["2.2339","2.2378"] | ["0","141"] | ["XCBO"] | 141.0000 | 142.0000 | 2 | 2 | false | false | |||||||||||
| 01a08208-a3e0-7d93-9d46-382e5742cb1f | BABA | 2026-09-08 13:19 | call_vertical_spread | 2 | 4 | 263 | 148414.00 | short | bid | 112.4900 | 0.2700 | ["140","150"] | ["0.4663","0.4818"] | ["141.10"] | ["ARCO","EMLD","SPHR","XBOX"] | 140.0000 | 150.0000 | 101 | 101 | false | true | |||||||||||
| 01a08204-71a8-78a3-a2f1-71d5fb5f2fc5 | BABA | 2026-09-08 13:15 | call_vertical_spread | 2 | 4 | 349 | 196192.00 | short | bid | 112.4900 | 0.2700 | ["140","150"] | ["0.4658","0.4811"] | ["141.10"] | ["ARCO","EMLD","SPHR","XBOX"] | 140.0000 | 150.0000 | 101 | 101 | false | true | |||||||||||
| 01a08184-1e18-7843-8012-619aeeadda2a | BABA | 2026-09-08 10:55 | call_vertical_spread | 2 | 1 | 100 | 101400.00 | short | bid | 112.2799 | 0.4000 | ["120","150"] | ["0.4455","0.4841"] | ["125.60"] | ["XMIO"] | 120.0000 | 150.0000 | 101 | 101 | false | true | |||||||||||
| 01a08141-3149-7c71-8c0c-ff9652f49808 | BABA | 2026-09-08 09:42 | put_calendar | 2 | 4 | 58 | 154320.00 | short | ask | 112.2350 | 1.5000 | ["125"] | ["0.4841"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 125.0000 | 125.0000 | 10 | 17 | false | false | |||||||||||
| 01a0813f-2da8-7ca3-acf6-03c65a2be04e | BABA | 2026-09-08 09:39 | put_calendar | 2 | 4 | 58 | 102454.00 | short | ask | 112.4050 | 1.8259 | ["120"] | ["0.4576"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 120.0000 | 120.0000 | 10 | 17 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:05:51Z"} |
| 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-23T14:07:32Z"} |
| 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-22T17:18:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:07:50Z"} |
| 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:21:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:21:11Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:00:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:09:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:37:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:03:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:07:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:54:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:53:42Z"} |
| 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-16T19:05:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:02:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:00:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:56:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:07:24Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:14:10Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:04:17Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:04:37Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:55:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:17:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:03:27Z"} |
| 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-09T15:01:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:20:23Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:16:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:55:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:42:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:40:06Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |