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 |
|---|
| 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 |
|---|
| 01a0c4d8-7eaf-70b3-83de-6d6f801f969a | ANF | 2026-09-21 12:41 | call_vertical_spread | 2 | 3 | 31 | 147072.00 | long | ask | 138.9400 | 5.3000 | ["125","135"] | ["0.5128","0.5118"] | ["130.30"] | ["XCBO","XPHO"] | 125.0000 | 135.0000 | 151 | 151 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:42:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b9-07fe-74a3-b032-4bf0e5e37c7e | ANF | 2026-09-21 12:07 | call_vertical_spread | 2 | 3 | 29 | 136010.00 | long | ask | 138.1600 | 5.0448 | ["125","135"] | ["0.5201","0.5194"] | ["130.20"] | ["XPHO"] | 125.0000 | 135.0000 | 151 | 151 | false | false | |||||||||||
| 01a0a5b5-ffb6-7532-ba7c-a132207814fa | ANF | 2026-09-15 11:36 | call_vertical_spread | 2 | 2 | 239 | 1393370.00 | unknown | — | 136.2800 | 1.4000 | ["90","155"] | ["0.6325","0.5787"] | [] | ["XMIO"] | 90.0000 | 155.0000 | 94 | 94 | true | false | false | true | |||||||||
| 01a0a58d-cabe-7b72-ac88-a7ace5968090 | ANF | 2026-09-15 10:52 | call_vertical_spread | 2 | 3 | 40 | 151884.00 | short | bid | 135.5000 | 1.2250 | ["130","140"] | ["0.5796","0.5738"] | ["134.65"] | ["XCBO","XISX","XPHO"] | 130.0000 | 140.0000 | 122 | 122 | false | false | |||||||||||
| 01a0a580-e5f5-7bb3-88de-58a4475f5daa | ANF | 2026-09-15 10:38 | call_vertical_spread | 2 | 1 | 50 | 196550.00 | long | ask | 136.5500 | 1.4000 | ["130","140"] | ["0.5815","0.5753"] | ["134.75"] | ["XCBO"] | 130.0000 | 140.0000 | 122 | 122 | false | false | |||||||||||
| 01a0a56a-6825-7632-86e8-35aad602256f | ANF | 2026-09-15 10:13 | call_vertical_spread | 2 | 2 | 56 | 230699.00 | unknown | — | 137.2500 | 3.6000 | ["130","140"] | ["0.5990","0.5923"] | [] | ["XCBO","XISX"] | 130.0000 | 140.0000 | 122 | 122 | false | false | false | true | |||||||||
| 01a0a56a-6825-7632-86e8-359c07a5ddc0 | ANF | 2026-09-15 10:13 | call_vertical_spread | 2 | 1 | 25 | 103000.00 | unknown | — | 137.2500 | 3.8000 | ["130","140"] | ["0.5991","0.5923"] | [] | ["XPHO"] | 130.0000 | 140.0000 | 122 | 122 | false | false | false | true | |||||||||
| 01a0a112-1af0-73b2-902c-513813f83f0e | ANF | 2026-09-14 13:58 | other | 4 | 1 | 10 | 106350.00 | unknown | — | 143.5000 | 9.1000 | ["116","117","118"] | ["1.6456","0.8965","0.5311"] | [] | ["ARCO"] | 116.0000 | 118.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a111-1150-7e00-b820-7a3370f8954c | ANF | 2026-09-14 13:57 | other | 4 | 1 | 10 | 122750.00 | unknown | — | 143.5200 | 10.5000 | ["112","113","114"] | ["1.1991","1.2683","0.5765"] | [] | ["ARCO"] | 112.0000 | 114.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a110-bf48-7461-8665-f603e504d69e | ANF | 2026-09-14 13:57 | other | 4 | 1 | 10 | 114450.00 | unknown | — | 143.4600 | 9.9000 | ["114","115","116"] | ["1.7196","1.1881","0.6495"] | [] | ["ARCO"] | 114.0000 | 116.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a10f-3c90-78e3-984e-462b5cba8219 | ANF | 2026-09-14 13:55 | other | 4 | 1 | 10 | 133090.00 | unknown | — | 143.4700 | 12.2000 | ["109","110","111","112"] | ["1.1899","0.8734","1.1389","0.8704"] | [] | ["ARCO"] | 109.0000 | 112.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a10e-4290-7043-8213-a5af9188dfa9 | ANF | 2026-09-14 13:54 | other | 4 | 1 | 10 | 135050.00 | unknown | — | 143.4500 | 10.7000 | ["109","110","111"] | ["0.8695","0.8834","0.9266"] | [] | ["ARCO"] | 109.0000 | 111.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0918b-5fb0-7e20-b09f-23a872e12609 | ANF | 2026-09-11 13:37 | call_diagonal_spread | 2 | 5 | 31 | 183216.00 | short | ask | 147.1550 | 2.0000 | ["100","150"] | ["1.4745","0.4813"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 100.0000 | 150.0000 | 7 | 70 | false | false | |||||||||||
| 01a09174-93c0-7243-9a4d-b07d7eead1d9 | ANF | 2026-09-11 13:12 | call_vertical_spread | 2 | 1 | 20 | 123620.00 | unknown | — | 147.3200 | 6.2000 | ["116","117"] | ["1.0127","1.0245"] | [] | ["XISX"] | 116.0000 | 117.0000 | 14 | 14 | true | false | false | true | |||||||||
| 01a090b9-8120-73d2-bc17-d07e6b990d3d | ANF | 2026-09-11 09:47 | call_diagonal_spread | 2 | 5 | 31 | 168054.00 | short | ask | 145.1651 | 5.0000 | ["110","135"] | ["1.3424","0.4856"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 110.0000 | 135.0000 | 7 | 70 | false | false | |||||||||||
| 01a08ce4-9008-7a23-8250-3da700b5ea45 | ANF | 2026-09-10 15:56 | put_diagonal_spread | 2 | 5 | 31 | 106235.00 | short | bid | 143.0900 | 2.8581 | ["155","157.5"] | ["0.4867","0.6501"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 155.0000 | 157.5000 | 8 | 71 | false | false | |||||||||||
| 01a08cd7-3228-70f1-abec-e6d711c2dec4 | ANF | 2026-09-10 15:41 | other | 4 | 1 | 10 | 125490.00 | unknown | — | 142.9500 | 10.2000 | ["111","112","113"] | ["2.9010","1.9044","0.9718"] | [] | ["AMXO"] | 111.0000 | 113.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a08ba7-ca48-73f0-accc-5927a569c511 | ANF | 2026-09-10 10:10 | other | 4 | 2 | 10 | 119900.00 | unknown | — | 145.3900 | 11.0000 | ["115","116","117"] | ["2.7007","1.8127","1.0484"] | [] | ["XISX"] | 115.0000 | 117.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a08692-5e38-7d63-8826-49391cdb7e64 | ANF | 2026-09-09 10:28 | other | 4 | 1 | 10 | 143850.00 | unknown | — | 153.8000 | 10.1000 | ["117","118","119"] | ["1.6636","1.7592","0.8115"] | [] | ["ARCO"] | 117.0000 | 119.0000 | 2 | 9 | false | false | true | true | |||||||||
| 01a08691-6438-7e82-a608-752fb102e441 | ANF | 2026-09-09 10:27 | other | 4 | 1 | 10 | 136330.00 | unknown | — | 153.7800 | 10.8000 | ["119","120","121"] | ["1.7655","1.2756","0.8884"] | [] | ["XMIO"] | 119.0000 | 121.0000 | 2 | 9 | false | false | true | true | |||||||||
| 01a08668-73c0-76e1-bc19-b34fbc9d3b41 | ANF | 2026-09-09 09:43 | put_vertical_spread | 2 | 1 | 486 | 1126548.00 | short | bid | 154.0600 | 3.3000 | ["135","145"] | ["0.6282","0.5742"] | ["142.30"] | ["EDGO"] | 135.0000 | 145.0000 | 100 | 100 | false | true | |||||||||||
| 01a08260-2250-7a73-b243-3d7ed730d55e | ANF | 2026-09-08 14:55 | other | 4 | 1 | 10 | 118740.00 | unknown | — | 150.4400 | 9.9000 | ["119","120","121"] | ["1.5104","1.1795","0.8289"] | [] | ["ARCO"] | 119.0000 | 121.0000 | 3 | 10 | false | false | true | true | |||||||||
| 01a0825e-5948-7312-b8d6-64345555259b | ANF | 2026-09-08 14:53 | other | 4 | 1 | 10 | 127020.00 | unknown | — | 150.3400 | 11.2000 | ["117","118","119"] | ["2.0076","1.3713","0.9185"] | [] | ["XMIO"] | 117.0000 | 119.0000 | 3 | 10 | false | false | true | true | |||||||||
| 01a0825c-6160-75a1-96da-62a4486b6b6a | ANF | 2026-09-08 14:51 | other | 4 | 1 | 10 | 134410.00 | unknown | — | 150.2350 | 10.4000 | ["115","116","117"] | ["1.8595","1.4412","0.9725"] | [] | ["XMIO"] | 115.0000 | 117.0000 | 3 | 10 | false | false | true | true | |||||||||
| 01a08259-5bf0-76d2-8d24-a1e258baae8c | ANF | 2026-09-08 14:48 | other | 4 | 1 | 10 | 159310.00 | unknown | — | 150.1000 | 10.8000 | ["109","110","111"] | ["2.6862","1.7503","1.3570"] | [] | ["ARCO"] | 109.0000 | 111.0000 | 3 | 10 | false | false | true | true | |||||||||
| 01a06ddf-286d-7762-abd6-7af8156957c1 | ANF | 2026-09-04 15:22 | call_calendar | 2 | 1 | 23 | 115690.00 | short | ask | 149.7495 | 4.8000 | ["125"] | ["8.8785"] | [] | ["XPHO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | |||||||||||
| 01a06d97-cae5-7a33-a8ed-dfb1642406d5 | ANF | 2026-09-04 14:04 | call_condor | 4 | 1 | 4 | 105080.00 | unknown | — | 149.5050 | 12.0000 | ["40","70","105","145"] | ["1.4067","0.6454","0.5820","0.5430"] | [] | ["XCBO"] | 40.0000 | 145.0000 | 133 | 133 | false | false | false | true | |||||||||
| 01a06d97-693d-7eb2-bc10-7e28c6d2c0d8 | ANF | 2026-09-04 14:03 | call_condor | 4 | 1 | 5 | 131450.00 | unknown | — | 149.5150 | 12.0000 | ["40","70","105","145"] | ["0.8608","0.6704","0.5815","0.5428"] | [] | ["ARCO"] | 40.0000 | 145.0000 | 133 | 133 | false | false | false | true | |||||||||
| 01a06d81-8b95-7581-9270-dbeddea8d188 | ANF | 2026-09-04 13:39 | call_calendar | 2 | 1 | 29 | 144130.00 | short | ask | 149.8650 | 5.2000 | ["125"] | ["4.5550"] | [] | ["XPHO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | |||||||||||
| 01a06d69-3906-7321-9716-3d21c70396e2 | ANF | 2026-09-04 13:13 | call_vertical_spread | 2 | 3 | 33 | 179524.00 | long | ask | 148.1600 | 3.6000 | ["130","140"] | ["0.5537","0.5501"] | ["135.66"] | ["XCBO","XISX","XPHO"] | 130.0000 | 140.0000 | 133 | 133 | false | false | |||||||||||
| 01a06d60-e435-7330-a7da-c17d94822f00 | ANF | 2026-09-04 13:04 | call_vertical_spread | 2 | 3 | 29 | 157325.00 | unknown | — | 148.4400 | 3.9000 | ["130","140"] | ["0.5442","0.5424"] | [] | ["XPHO"] | 130.0000 | 140.0000 | 133 | 133 | false | false | false | true | |||||||||
| 01a06d5f-da95-7473-9d63-d9c4e0d21768 | ANF | 2026-09-04 13:03 | call_vertical_spread | 2 | 2 | 22 | 119218.00 | long | ask | 148.4200 | 4.0000 | ["130","140"] | ["0.5437","0.5419"] | ["135.65"] | ["XPHO"] | 130.0000 | 140.0000 | 133 | 133 | false | false | |||||||||||
| 01a06d3a-e98d-76e0-bda4-629a3ac4b0f0 | ANF | 2026-09-04 12:22 | other | 2 | 1 | 25 | 114000.00 | unknown | — | 147.4600 | 3.8000 | ["125"] | ["3.0666"] | [] | ["XPHO"] | 125.0000 | 125.0000 | 0 | 28 | false | false | true | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:07:51Z"} |
| 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-15T15:36:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:52:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:38:17Z"} |
| 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:13:43Z"} |
| 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:13:43Z"} |
| 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-14T17:58:53Z"} |
| 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-14T17:58:11Z"} |
| 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-14T17:57:21Z"} |
| 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-14T17:55: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-14T17:54:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:37:24Z"} |
| 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-11T17:12:10Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:47:53Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:56:24Z"} |
| 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-10T19:42:01Z"} |
| 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-10T14:10:41Z"} |
| 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-09T14:29:13Z"} |
| 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-09T14:27:55Z"} |
| 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-09T13:43:14Z"} |
| 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-08T18:55:53Z"} |
| 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:53:38Z"} |
| 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:51:45Z"} |
| 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:48:26Z"} |
| 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-04T19:22:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:05:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:04:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:40:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:13:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:04:36Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:03:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:23:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |