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 |
|---|
| 01a0a147-b598-7022-936d-87e440fbabe9 | BAC | 2026-09-14 14:57 | call_vertical_spread | 2 | 1 | 600 | 378600.00 | unknown | — | 59.1350 | 0.3900 | ["55","70"] | ["0.2582","0.2445"] | [] | ["XBOX"] | 55.0000 | 70.0000 | 95 | 95 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:57:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a54b-c466-7482-9b13-5d725c02e52d | BAC | 2026-09-15 09:39 | call_vertical_spread | 2 | 1 | 200 | 259000.00 | unknown | — | 59.0200 | 0.6000 | ["52.5","57.5"] | ["0.2823","0.2611"] | [] | ["XCBO"] | 52.5000 | 57.5000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0a55c-048e-7840-9cff-1d6df5e9100c | BAC | 2026-09-15 09:57 | call_vertical_spread | 2 | 1 | 200 | 204400.00 | long | ask | 59.5100 | 0.2500 | ["55","60"] | ["0.2674","0.2502"] | ["58.14"] | ["XMIO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a560-427e-7e73-b431-b3e4e089ae42 | BAC | 2026-09-15 10:02 | call_vertical_spread | 2 | 1 | 120 | 126720.00 | long | ask | 59.7200 | 0.3000 | ["55","60"] | ["0.2704","0.2528"] | ["58.18"] | ["XCBO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a565-5746-7241-9e9e-f7257291f558 | BAC | 2026-09-15 10:07 | call_vertical_spread | 2 | 1 | 200 | 210200.00 | short | bid | 59.6850 | 0.5000 | ["55","60"] | ["0.2701","0.2527"] | ["58.17"] | ["XMIO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a569-df6e-71e0-8d0e-b31e6ae42842 | BAC | 2026-09-15 10:12 | call_vertical_spread | 2 | 1 | 120 | 125760.00 | unknown | — | 59.7550 | 0.2500 | ["55","60"] | ["0.2643","0.2484"] | [] | ["XCBO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0a56c-4c86-7a00-a02c-531f67cb1336 | BAC | 2026-09-15 10:15 | call_vertical_spread | 2 | 1 | 120 | 125760.00 | unknown | — | 59.7425 | 0.2500 | ["55","60"] | ["0.2652","0.2489"] | [] | ["XCBO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0a56d-7d36-75e1-b6a5-8117826e1e5c | BAC | 2026-09-15 10:16 | call_vertical_spread | 2 | 1 | 160 | 166560.00 | unknown | — | 59.6500 | 0.3500 | ["55","60"] | ["0.2679","0.2505"] | [] | ["XCBO"] | 55.0000 | 60.0000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0a56f-c726-75f1-aee6-7a530d956642 | BAC | 2026-09-15 10:19 | call_vertical_spread | 2 | 1 | 200 | 275600.00 | short | bid | 59.5900 | 0.6500 | ["52.5","57.5"] | ["0.2817","0.2615"] | ["56.14"] | ["XCBO"] | 52.5000 | 57.5000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a574-3bc6-7d61-b0ed-c671b96dabaf | BAC | 2026-09-15 10:24 | call_vertical_spread | 2 | 1 | 200 | 273400.00 | short | bid | 59.4950 | 0.9000 | ["52.5","57.5"] | ["0.2837","0.2624"] | ["56.13"] | ["XCBO"] | 52.5000 | 57.5000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a68b-0eae-7333-b46a-16f29d75ed3f | BAC | 2026-09-15 15:28 | call_vertical_spread | 2 | 1 | 72 | 181656.00 | long | ask | 59.6150 | 0.4500 | ["50","55"] | ["0.2669","0.2622"] | ["53.25"] | ["XCBO"] | 50.0000 | 55.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0aab6-90c3-7430-ae77-f1892bb3cedf | BAC | 2026-09-16 10:54 | call_vertical_spread | 2 | 1 | 200 | 248000.00 | unknown | — | 58.6700 | 0.4500 | ["52.5","57.5"] | ["0.2719","0.2569"] | [] | ["XCBO"] | 52.5000 | 57.5000 | 121 | 121 | false | false | false | true | false | ||||||||
| 01a0aab9-924b-7550-ba0c-f479be32020f | BAC | 2026-09-16 10:58 | call_vertical_spread | 2 | 2 | 200 | 247800.00 | long | ask | 58.6350 | 0.5000 | ["52.5","57.5"] | ["0.2793","0.2547"] | ["56.05"] | ["XMIO"] | 52.5000 | 57.5000 | 121 | 121 | false | false | false | ||||||||||
| 01a0aabb-8e1b-7131-a682-b120eb90a65f | BAC | 2026-09-16 11:00 | call_vertical_spread | 2 | 1 | 200 | 247000.00 | long | ask | 58.7050 | 0.4000 | ["52.5","57.5"] | ["0.2710","0.2498"] | ["56.05"] | ["XMIO"] | 52.5000 | 57.5000 | 121 | 121 | false | false | false | ||||||||||
| 01a0aabe-1e5b-7642-9efd-87401fff68ac | BAC | 2026-09-16 11:02 | call_vertical_spread | 2 | 1 | 200 | 248200.00 | long | ask | 58.8150 | 0.5500 | ["52.5","57.5"] | ["0.2644","0.2467"] | ["56.05"] | ["XMIO"] | 52.5000 | 57.5000 | 121 | 121 | false | false | false | ||||||||||
| 01a0abae-df2b-7f13-a7e4-9bdd14063743 | BAC | 2026-09-16 15:25 | call_vertical_spread | 2 | 1 | 500 | 386500.00 | unknown | — | 57.2250 | 0.3800 | ["57.5","67.5"] | ["0.2499","0.2408"] | [] | ["EDGO"] | 57.5000 | 67.5000 | 274 | 274 | false | true | false | true | false | ||||||||
| 01a0abae-f69b-7a81-bfb1-46931794b23b | BAC | 2026-09-16 15:26 | call_vertical_spread | 2 | 1 | 500 | 386500.00 | unknown | — | 57.2199 | 0.3800 | ["57.5","67.5"] | ["0.2500","0.2409"] | [] | ["EDGO"] | 57.5000 | 67.5000 | 274 | 274 | false | true | false | true | false | ||||||||
| 01a0abb0-7953-7912-9d5b-c202235aba26 | BAC | 2026-09-16 15:27 | call_vertical_spread | 2 | 2 | 164 | 127428.00 | unknown | — | 57.3001 | 0.2900 | ["57.5","67.5"] | ["0.2491","0.2401"] | [] | ["AMXO","XCBO"] | 57.5000 | 67.5000 | 274 | 274 | false | true | false | true | false | ||||||||
| 01a0abb0-cb5b-7eb2-adfc-89b05006e5c3 | BAC | 2026-09-16 15:28 | call_vertical_spread | 2 | 1 | 500 | 388000.00 | long | ask | 57.3050 | 0.2800 | ["57.5","67.5"] | ["0.2490","0.2394"] | ["61.2"] | ["EDGO"] | 57.5000 | 67.5000 | 274 | 274 | false | true | false | ||||||||||
| 01a0abb1-38bb-76a0-82db-0836f43ac132 | BAC | 2026-09-16 15:28 | call_vertical_spread | 2 | 1 | 500 | 388000.00 | long | ask | 57.2950 | 0.2800 | ["57.5","67.5"] | ["0.2493","0.2396"] | ["61.2"] | ["EDGO"] | 57.5000 | 67.5000 | 274 | 274 | false | true | false | ||||||||||
| 01a0afb4-69ab-7420-87a5-119e2578702f | BAC | 2026-09-17 10:10 | call_vertical_spread | 2 | 1 | 284 | 222656.00 | long | ask | 57.5700 | 0.0600 | ["55","60"] | ["0.2635","0.2465"] | ["57.74"] | ["MCRY"] | 55.0000 | 60.0000 | 120 | 120 | false | false | false | ||||||||||
| 01a0c47b-4767-7621-a70a-fd54406c52e5 | BAC | 2026-09-21 11:00 | call_vertical_spread | 2 | 2 | 80 | 156000.00 | unknown | bid | 57.8400 | 0.4000 | ["50","60"] | ["0.2295","0.2328"] | ["64.75"] | ["AMXO","XISX"] | 50.0000 | 60.0000 | 487 | 487 | false | false | false | ||||||||||
| 01a0c47f-2797-7122-af13-a39c724fc0a1 | BAC | 2026-09-21 11:04 | call_vertical_spread | 2 | 3 | 87 | 168780.00 | unknown | — | 57.7800 | 0.4000 | ["50","60"] | ["0.2294","0.2322"] | [] | ["AMXO"] | 50.0000 | 60.0000 | 487 | 487 | false | false | false | true | false | ||||||||
| 01a0c47f-2797-7122-af13-a388a27b7484 | BAC | 2026-09-21 11:04 | call_vertical_spread | 2 | 2 | 80 | 155200.00 | unknown | — | 57.7800 | 0.4500 | ["50","60"] | ["0.2294","0.2322"] | [] | ["AMXO","XISX"] | 50.0000 | 60.0000 | 487 | 487 | false | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:40:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:57:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:02:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:08:12Z"} |
| 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-15T14:13:18Z"} |
| 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-15T14:15:48Z"} |
| 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-15T14:17:04Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:19:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:24:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:29: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-16T14:55:21Z"} |
| 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-16T14:58:01Z"} |
| 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-16T15:00:17Z"} |
| 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-16T15:03:21Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:26:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:26:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:27:43Z"} |
| 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-16T19:28:19Z"} |
| 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-16T19:28:41Z"} |
| 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-17T14:10:43Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:04:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:04:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |