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 | directiontext |
|---|
| 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 |
|---|
| 01a08138-a1e0-7d93-9f5b-be9bd9f1656b | TGT | 2026-09-08 09:32 | put_vertical_spread | 2 | 2 | 65 | 129935.00 | long | ask | 162.3000 | 2.9000 | ["160","165"] | ["0.3634","0.3631"] | ["162.45"] | ["XISX"] | 160.0000 | 165.0000 | 73 | 73 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:32:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d9-bff9-7e62-91bd-cb2c5914aec9 | TGT | 2026-09-08 12:28 | call_vertical_spread | 2 | 1 | 34 | 248574.00 | long | ask | 163.3228 | 5.6000 | ["150","180"] | ["0.2994","0.3122"] | ["162.09"] | ["ARCO"] | 150.0000 | 180.0000 | 829 | 829 | false | false | false | ||||||||||
| 01a086cc-7939-79b0-9eb5-72ddec6762dc | TGT | 2026-09-09 11:32 | other | 2 | 1 | 385 | 504735.00 | unknown | — | 160.1000 | 0.5500 | ["155","160"] | ["0.3302","0.3060"] | [] | ["XISX"] | 155.0000 | 160.0000 | 9 | 37 | false | false | true | true | false | mlet | |||||||
| 01a0870e-44f8-7153-85d3-5e63c7b8a663 | TGT | 2026-09-09 12:44 | call_calendar | 2 | 1 | 15 | 110565.00 | short | ask | 159.5550 | 4.0500 | ["130"] | ["0.5839"] | [] | ["XPHO"] | 130.0000 | 130.0000 | 9 | 464 | false | false | true | false | |||||||||
| 01a08c0b-4708-71d0-81ee-b01ddbf5f0ae | TGT | 2026-09-10 11:59 | straddle | 2 | 1 | 500 | 3760000.00 | unknown | — | 157.2500 | 4.6500 | ["190"] | ["0.3815"] | [] | ["AMXO"] | 190.0000 | 190.0000 | 827 | 827 | true | false | false | false | true | mlct | |||||||
| 01a08c92-5158-7b12-bd72-16bc07291540 | TGT | 2026-09-10 14:26 | other | 2 | 1 | 22 | 112640.00 | unknown | — | 156.2300 | 2.6000 | ["165","200"] | ["0.9475","0.3330"] | [] | ["XBOX"] | 165.0000 | 200.0000 | 1 | 36 | false | false | true | true | false | mlft | |||||||
| 01a09201-b0c1-78b1-9829-3f1a1ded4c32 | TGT | 2026-09-11 15:46 | call_calendar | 2 | 5 | 24 | 125652.00 | long | ask | 155.9600 | 3.8667 | ["130"] | ["10.4131"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0a5d7-6a66-72f2-b2ae-33157180b501 | TGT | 2026-09-15 12:12 | call_vertical_spread | 2 | 1 | 126 | 141246.00 | short | bid | 153.8800 | 0.5000 | ["150","160"] | ["0.3117","0.3070"] | ["154.73"] | ["XMIO"] | 150.0000 | 160.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a655-c9f6-7481-8a09-3b9d9742b6f1 | TGT | 2026-09-15 14:30 | call_calendar | 2 | 1 | 50 | 159850.00 | unknown | — | 155.6350 | 1.9000 | ["140"] | ["0.4213"] | [] | ["XCBO"] | 140.0000 | 140.0000 | 3 | 17 | false | false | true | false | false | mlat | |||||||
| 01a0abbc-4cab-77d2-bd90-04a50f3f97b7 | TGT | 2026-09-16 15:40 | call_diagonal_spread | 2 | 1 | 14 | 100156.00 | long | bid | 154.8400 | 6.3000 | ["135","160"] | ["0.3171","0.3096"] | [] | ["XMIO"] | 135.0000 | 160.0000 | 492 | 856 | false | false | true | true | |||||||||
| 01a0b4dc-f7e7-7d23-838e-6cf5a1504018 | TGT | 2026-09-18 10:12 | call_calendar | 2 | 3 | 23 | 128938.00 | short | ask | 157.5550 | 2.7500 | ["130"] | ["2.8064"] | [] | ["ARCO","EMLD","SPHR"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0b4ef-7a30-7c93-a963-1b4736d234da | TGT | 2026-09-18 10:33 | call_diagonal_spread | 2 | 1 | 40 | 142200.00 | long | ask | 157.6950 | 1.6500 | ["140","142"] | ["2.2548","0.3292"] | [] | ["XISX"] | 140.0000 | 142.0000 | 0 | 42 | false | false | true | true | |||||||||
| 01a0b572-0428-74d3-8f12-0427c6c5d8dc | TGT | 2026-09-18 12:55 | call_diagonal_spread | 2 | 3 | 420 | 1127700.00 | short | bid | 157.9399 | 2.2000 | ["145","150"] | ["3.6224","0.3432"] | [] | ["XCBO"] | 145.0000 | 150.0000 | 0 | 63 | false | false | true | true | |||||||||
| 01a0b592-132f-7b30-8ccf-3931877ff5f1 | TGT | 2026-09-18 13:30 | call_vertical_spread | 2 | 1 | 20 | 135980.00 | unknown | ask | 157.5700 | 1.1500 | ["100","165"] | ["0.5185","0.3274"] | ["166.50"] | ["XCBO"] | 100.0000 | 165.0000 | 119 | 119 | false | false | false | ||||||||||
| 01a0c97d-8166-70f2-b6c6-275ca0e65319 | TGT | 2026-09-22 10:20 | put_calendar | 2 | 1 | 100 | 143000.00 | unknown | ask | 159.4500 | 1.2000 | ["160"] | ["0.3367"] | [] | ["C2OX"] | 160.0000 | 160.0000 | 24 | 59 | false | false | true | false | |||||||||
| 01a0c9e8-f14f-7341-a86b-c3811fc85eba | TGT | 2026-09-22 12:17 | call_vertical_spread | 2 | 1 | 10 | 134120.00 | long | ask | 159.2750 | 1.7500 | ["90","95"] | ["3.0735","2.8448"] | ["94.98"] | ["XMIO"] | 90.0000 | 95.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ce99-3ea7-7123-9089-61c0c5b94c2b | TGT | 2026-09-23 10:09 | call_diagonal_spread | 2 | 1 | 35 | 278075.00 | short | bid | 158.1850 | 1.8000 | ["135","150"] | ["0.3075","0.3003"] | [] | ["XISX"] | 135.0000 | 150.0000 | 485 | 849 | false | false | true | ||||||||||
| 01a0ceac-49a6-7451-804c-1dbc4c26be2b | TGT | 2026-09-23 10:29 | call_vertical_spread | 2 | 1 | 10 | 151910.00 | long | ask | 158.0200 | 3.0000 | ["80","85"] | ["4.7896","4.4239"] | ["84.99"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0cec0-2f66-73b3-bf48-624591913f6c | TGT | 2026-09-23 10:51 | call_diagonal_spread | 2 | 1 | 20 | 257640.00 | long | ask | 158.1350 | 4.1500 | ["100","105"] | ["0.2747","0.2086"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 485 | 849 | false | false | true | true | |||||||||
| 01a0cec5-28d6-7be3-9fb4-bc8239dfeb4b | TGT | 2026-09-23 10:57 | call_calendar | 2 | 1 | 43 | 315534.00 | short | ask | 157.8950 | 3.9500 | ["140"] | ["0.3259"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 450 | 485 | false | false | true | false | |||||||||
| 01a0cf0a-57c7-7171-b529-086d93adbb33 | TGT | 2026-09-23 12:12 | call_vertical_spread | 2 | 1 | 9 | 117918.00 | long | ask | 157.8650 | 1.8000 | ["90","95"] | ["3.3387","3.1101"] | ["94.98"] | ["EDGO"] | 90.0000 | 95.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0d3cd-043e-7d53-801f-f924c3bb6110 | TGT | 2026-09-24 10:23 | call_vertical_spread | 2 | 1 | 7 | 106022.00 | long | ask | 158.0100 | 2.3000 | ["80","85"] | ["6.0617","5.6464"] | ["84.98"] | ["XCBO"] | 80.0000 | 85.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0d445-d5ee-7822-aa88-21ced4cadaac | TGT | 2026-09-24 12:35 | call_vertical_spread | 2 | 1 | 10 | 129810.00 | long | ask | 157.5150 | 3.8000 | ["90","95"] | ["6.4018","6.0164"] | ["94.99"] | ["XCBO"] | 90.0000 | 95.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0d9c8-adb6-71d2-adad-d87539f9fd98 | TGT | 2026-09-25 14:16 | call_calendar | 2 | 1 | 50 | 275000.00 | short | ask | 157.2850 | 3.6000 | ["130"] | ["4.6334"] | [] | ["XISX"] | 130.0000 | 130.0000 | 0 | 42 | false | false | true | false | |||||||||
| 01a0da08-1817-7693-a5b0-f24f96dd41c4 | TGT | 2026-09-25 15:25 | call_calendar | 2 | 3 | 23 | 124200.00 | short | ask | 157.0000 | 3.5000 | ["130"] | ["9.1506"] | [] | ["ARCO","EMLD","SPHR"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:29:10Z"} |
| 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-09T15:32:47Z"} |
| 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-09T16:44:51Z"} |
| 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-10T15:59:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:26:51Z"} |
| 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-11T19:46:18Z"} |
| 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-15T16:13:16Z"} |
| 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-15T18:31:21Z"} |
| 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-16T19:40:54Z"} |
| 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-18T14:13:14Z"} |
| 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-18T14:33:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:56:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:31:00Z"} |
| 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-22T14:20:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:18:10Z"} |
| 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-23T14:09:24Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:29:53Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:51:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:57:05Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:13:10Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:24:00Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:35:56Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:17:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:25:59Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |