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 |
|---|
| 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 |
|---|
| 01a0d8f2-75df-7d71-b911-3e99e78a579d | COPX | 2026-09-25 10:22 | call_vertical_spread | 2 | 1 | 50 | 130500.00 | unknown | ask | 85.6800 | 2.8000 | ["70","86"] | ["0.4098","0.3980"] | ["91.05"] | ["XISX"] | 70.0000 | 86.0000 | 112 | 112 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:22:59Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0ced0-310f-75b0-b9e0-5ea7f736afd4 | COPX | 2026-09-23 11:09 | call_ratio_spread | 2 | 3 | 2500 | 1209000.00 | long | ask | 87.0500 | 1.1500 | ["91","100"] | ["0.4288","0.4408"] | ["91.96","112.06"] | ["XCBO"] | 91.0000 | 100.0000 | 58 | 58 | false | true | |||||||||||
| 01a0b5b5-75c8-7ad2-8955-c629e6795b5e | COPX | 2026-09-18 14:09 | put_calendar | 2 | 13 | 190 | 146736.00 | short | bid | 86.7700 | 2.9500 | ["65"] | ["0.4773"] | [] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 65.0000 | 119 | 490 | false | ||||||||||||
| 01a0b5b3-5e9f-7ef2-8d0f-d231428fe87e | COPX | 2026-09-18 14:07 | put_calendar | 2 | 12 | 308 | 237034.00 | short | bid | 86.7900 | 2.9500 | ["65"] | ["0.4765"] | [] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 65.0000 | 119 | 490 | false | ||||||||||||
| 01a0b5b3-4b17-7df2-afb0-9696e20697e6 | COPX | 2026-09-18 14:06 | put_calendar | 2 | 10 | 134 | 103382.00 | unknown | ask | 86.7900 | 1.5321 | ["65"] | ["0.4772"] | [] | ["AMXO","BATO","EMLD","MCRY","XCBO","XPHO"] | 65.0000 | 65.0000 | 119 | 490 | false | true | |||||||||||
| 01a0b5aa-ee77-7002-8829-2296fc638c3c | COPX | 2026-09-18 13:57 | call_vertical_spread | 2 | 1 | 36 | 282780.00 | unknown | — | 86.7623 | 5.7000 | ["45","50"] | ["2.0828","1.8004"] | [] | ["BATO"] | 45.0000 | 50.0000 | 21 | 21 | false | false | false | true | |||||||||
| 01a0a58e-b136-7a50-9be7-77ca7bdd3385 | COPX | 2026-09-15 10:53 | put_ratio_spread | 2 | 7 | 153 | 143070.00 | unknown | — | 83.8900 | 0.6000 | ["84","90"] | ["0.4342","0.4277"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 84.0000 | 90.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a58e-b136-7a50-9be7-77bb70d024be | COPX | 2026-09-15 10:53 | put_ratio_spread | 2 | 7 | 141 | 130250.00 | unknown | — | 83.8850 | 0.6000 | ["84","90"] | ["0.4282","0.4175"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 84.0000 | 90.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a58e-ad4e-79e2-a314-81bc9e0efd92 | COPX | 2026-09-15 10:53 | put_ratio_spread | 2 | 7 | 168 | 157076.00 | unknown | — | 83.8850 | 0.6000 | ["84","90"] | ["0.4339","0.4272"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 84.0000 | 90.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a58e-ad4e-79e2-a314-81a56b0a72c1 | COPX | 2026-09-15 10:53 | put_ratio_spread | 2 | 7 | 168 | 154788.00 | unknown | — | 83.8850 | 0.6893 | ["84","90"] | ["0.4269","0.4154"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 84.0000 | 90.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a570-7ad6-7463-b898-899c7f45ad0c | COPX | 2026-09-15 10:20 | put_calendar | 2 | 13 | 263 | 221188.00 | short | bid | 84.5000 | 3.3500 | ["65"] | ["0.4765"] | [] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","MCRY","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 65.0000 | 122 | 493 | false | ||||||||||||
| 01a0a09b-ed08-7e62-a271-444be3440073 | COPX | 2026-09-14 11:49 | call_vertical_spread | 2 | 1 | 1600 | 598400.00 | unknown | — | 85.3400 | 0.3500 | ["90","100"] | ["0.4577","0.4724"] | [] | ["XISX"] | 90.0000 | 100.0000 | 32 | 32 | false | true | false | true | |||||||||
| 01a090e4-88c1-7e92-8c23-5490c10a915f | COPX | 2026-09-11 10:34 | call_vertical_spread | 2 | 1 | 100 | 148000.00 | unknown | — | 89.0000 | 2.4000 | ["80","85"] | ["0.6951","0.5611"] | [] | ["XPHO"] | 80.0000 | 85.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a08bca-2ef8-7ab1-b877-36b0ea68e269 | COPX | 2026-09-10 10:47 | call_vertical_spread | 2 | 2 | 530 | 262566.00 | short | bid | 88.9350 | 0.6500 | ["110","120"] | ["0.4944","0.5060"] | ["111.25"] | ["ARCO","XBOX"] | 110.0000 | 120.0000 | 99 | 99 | false | ||||||||||||
| 01a08b98-0b08-79c3-ad1a-b7cef359e545 | COPX | 2026-09-10 09:53 | call_butterfly_spread | 3 | 1 | 1500 | 740000.00 | short | bid | 89.2800 | 2.0000 | ["105","120","135"] | ["0.4820","0.5052","0.5431"] | ["106.70"] | ["XCBO"] | 105.0000 | 135.0000 | 99 | 99 | true | ||||||||||||
| 01a08797-cc00-7370-acb4-75ccd0db1f51 | COPX | 2026-09-09 15:14 | call_ratio_spread | 2 | 3 | 5698 | 2454304.00 | long | ask | 95.3300 | 0.6000 | ["105","125"] | ["0.4905","0.4957"] | ["107.68","150.97"] | ["XCBO"] | 105.0000 | 125.0000 | 72 | 72 | false | ||||||||||||
| 01a08783-6940-7d02-9e6c-4c5de3edb54b | COPX | 2026-09-09 14:52 | other | 2 | 3 | 6000 | 2592000.00 | unknown | — | 95.3500 | 0.8000 | ["105","125"] | ["0.4912","0.4954"] | [] | ["XCBO"] | 105.0000 | 125.0000 | 72 | 72 | false | true | false | true | |||||||||
| 01a08755-bdd8-7780-a4f2-4e70919940fa | COPX | 2026-09-09 14:02 | call_ratio_spread | 2 | 3 | 5000 | 2270000.00 | long | ask | 95.5900 | 0.4928 | ["105","125"] | ["0.4948","0.5054"] | ["107.63","151.05"] | ["XCBO"] | 105.0000 | 125.0000 | 72 | 72 | false | ||||||||||||
| 01a08712-2140-7463-9946-c8ddd60eb040 | COPX | 2026-09-09 12:48 | call_ratio_spread | 2 | 2 | 6000 | 2575200.00 | long | ask | 95.3100 | 0.8000 | ["105","125"] | ["0.4903","0.4949"] | ["107.69","150.97"] | ["XCBO"] | 105.0000 | 125.0000 | 72 | 72 | false | ||||||||||||
| 01a08136-5ce3-7c63-8a35-6060a5447a2c | COPX | 2026-09-08 09:30 | put_vertical_spread | 2 | 1 | 89 | 168388.00 | long | ask | 93.8525 | 1.4000 | ["95","100"] | ["0.4598","0.4651"] | ["96.94"] | ["EDGO"] | 95.0000 | 100.0000 | 73 | 73 | false | false | |||||||||||
| 01a08136-5ce3-7c63-8a35-605679627729 | COPX | 2026-09-08 09:30 | put_vertical_spread | 2 | 1 | 200 | 378400.00 | long | ask | 93.8525 | 1.4000 | ["95","100"] | ["0.4598","0.4651"] | ["96.94"] | ["C2OX"] | 95.0000 | 100.0000 | 73 | 73 | true | false |
| false |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:09:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:10:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:07:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:07:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:58:04Z"} |
| 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-15T14:53:05Z"} |
| 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-15T14:53:05Z"} |
| 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-15T14:53:05Z"} |
| 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-15T14:53:05Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:20:05Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:49: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-11T14:34:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:48:23Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:53:18Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:15:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:52:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:03:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:49:01Z"} |
| 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-08T13:30:07Z"} |
| 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-08T13:30:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |