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 |
|---|
| 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 |
|---|
| 01a0da0c-32df-7c90-b299-23b8691fa8a2 | BAC | 2026-09-25 15:30 | call_diagonal_spread | 2 | 1 | 600 | 247200.00 | short | bid | 56.5950 | 0.1700 | ["55","65"] | ["0.2555","0.2411"] | [] | ["XCBO"] | 55.0000 | 65.0000 | 56 | 84 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:30:35Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0da01-6927-7161-abd1-3fe4ac10de4b | BAC | 2026-09-25 15:18 | strangle | 2 | 1 | 2500 | 1357500.00 | short | bid | 56.7250 | 0.1400 | ["55","57.5"] | ["0.2789","0.2481"] | ["49.57","62.93"] | ["AMXO"] | 55.0000 | 57.5000 | 112 | 112 | false | true | |||||||||||
| 01a0d8e3-4ef7-7531-9d3a-91b759360848 | BAC | 2026-09-25 10:06 | other | 4 | 1 | 8051 | 346193.00 | unknown | bid | 55.8850 | 0.1100 | ["57","58"] | ["0.3301","0.4775"] | [] | ["XPHO"] | 57.0000 | 58.0000 | 0 | 7 | false | true | true | ||||||||||
| 01a0d482-989f-7f22-9117-0f6f7b15c5b2 | BAC | 2026-09-24 13:42 | call_diagonal_spread | 2 | 1 | 510 | 577320.00 | short | bid | 55.9400 | 0.2500 | ["60","67.5"] | ["0.2357","0.2280"] | [] | ["XMIO"] | 60.0000 | 67.5000 | 449 | 813 | false | true | |||||||||||
| 01a0cf49-f4ef-7413-9851-bb70182298dd | BAC | 2026-09-23 13:22 | put_diagonal_spread | 2 | 3 | 302 | 363532.00 | unknown | bid | 55.8800 | 0.2000 | ["57.5","60"] | ["0.2932","0.2714"] | [] | ["BATO","C2OX","XCBO"] | 57.5000 | 60.0000 | 149 | 450 | false | false | |||||||||||
| 01a0cf49-f4ef-7413-9851-bb6b4befea3f | BAC | 2026-09-23 13:22 | put_diagonal_spread | 2 | 1 | 132 | 159192.00 | short | bid | 55.8800 | 0.2000 | ["57.5","60"] | ["0.2937","0.2722"] | [] | ["MCRY"] | 57.5000 | 60.0000 | 149 | 450 | false | false | |||||||||||
| 01a0cf49-f4ef-7413-9851-bb5303a55b0f | BAC | 2026-09-23 13:22 | put_diagonal_spread | 2 | 9 | 560 | 674982.00 | short | bid | 55.8800 | 0.2000 | ["57.5","60"] | ["0.2936","0.2720"] | [] | ["AMXO","ARCO","EMLD","MCRY","SPHR","XISX","XMIO","XPHO"] | 57.5000 | 60.0000 | 149 | 450 | false | false | |||||||||||
| 01a0cf04-29bf-7e52-a3e9-ac81743b831a | BAC | 2026-09-23 12:05 | put_diagonal_spread | 2 | 1 | 200 | 101200.00 | unknown | bid | 55.8000 | 0.0900 | ["50","55"] | ["0.2890","0.2731"] | [] | ["XISX"] | 50.0000 | 55.0000 | 114 | 296 | false | true | |||||||||||
| 01a0cec4-cb17-7b41-a5ac-223bf976d02e | BAC | 2026-09-23 10:56 | call_diagonal_spread | 2 | 1 | 51 | 132294.00 | unknown | bid | 56.1550 | 0.8500 | ["45","50"] | ["0.3034","0.2211"] | [] | ["XISX"] | 45.0000 | 50.0000 | 114 | 849 | false | false | |||||||||||
| 01a0ca73-ef57-7902-bf8d-0211a890edb2 | BAC | 2026-09-22 14:49 | synthetic | 2 | 1 | 400 | 264800.00 | long | bid | 56.5750 | 0.3500 | ["57.5"] | ["0.2611"] | ["57.14"] | ["XPHO"] | 57.5000 | 57.5000 | 115 | 115 | false | false | false | ||||||||||
| 01a0ca0f-6127-7f32-9797-733ef5afe7e4 | BAC | 2026-09-22 12:59 | call_condor | 4 | 1 | 7823 | 289451.00 | unknown | bid | 56.3700 | 0.0500 | ["57","58","59","60"] | ["0.2534","0.2431","0.2757","0.3575"] | ["57.33"] | ["XPHO"] | 57.0000 | 60.0000 | 3 | 3 | false | true | |||||||||||
| 01a0c98e-55ff-72a2-ba16-f397aadbd22a | BAC | 2026-09-22 10:39 | call_diagonal_spread | 2 | 1 | 100 | 327700.00 | short | bid | 56.7900 | 4.8500 | ["42","42.5"] | ["0.5834","0.3723"] | [] | ["XMIO"] | 42.0000 | 42.5000 | 87 | 241 | 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 | |||||||||||
| 01a0a597-aa15-7fb0-9809-9dfb6cde27ad | BAC | 2026-09-15 11:02 | call_calendar | 2 | 1 | 60 | 104400.00 | short | bid | 59.4250 | 0.4000 | ["55"] | ["0.2632"] | [] | ["XPHO"] | 55.0000 | 55.0000 | 122 | 493 | 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0a0f0-fa78-7830-b66b-fc97de69e097 | BAC | 2026-09-14 13:22 | call_diagonal_spread | 2 | 1 | 95 | 117135.00 | long | bid | 60.4000 | 0.4000 | ["55","57.5"] | ["0.2907","0.2607"] | [] | ["MCRY"] | 55.0000 | 57.5000 | 67 | 123 | false | false | |||||||||||
| 01a0a07a-3c08-7b12-900c-03c2cdda7faa | BAC | 2026-09-14 11:12 | put_calendar | 2 | 1 | 800 | 263200.00 | short | bid | 61.7850 | 0.0600 | ["62.5"] | ["0.2716"] | [] | ["XBOX"] | 62.5000 | 62.5000 | 4 | 32 | false | false | true | ||||||||||
| 01a06d67-1625-72a0-aa2a-c1e83663dc98 | BAC | 2026-09-04 13:11 | call_diagonal_spread_bullish | 2 | 2 | 49 | 228737.00 | short | bid | 62.5950 | 0.9000 | ["20","59"] | ["0.9803","0.2453"] | [] | ["XBOX","XISX"] | 20.0000 | 59.0000 | 14 | 133 | false | false |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:19:04Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:06:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:42:17Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:22:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:22:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:22:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:06:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:56:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:50:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:00:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:39:15Z"} |
| 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-21T15:00:29Z"} |
| 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-15T15:03:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| 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 |
| true |
| 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 |
| true |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:23:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:13:01Z"} |
| 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-04T17:11:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |