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 |
|---|
| 01a0b04a-0673-7010-9937-3ce66ae5a887 | CRCL | 2026-09-17 12:53 | other | 4 | 1 | 10 | 100475.00 | unknown | — | 84.9000 | 7.3500 | ["60","85","140","225"] | ["0.8063","0.7919","0.7866","0.8149"] | [] | ["XMIO"] | 60.0000 | 225.0000 | 491 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:54:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa76-3433-7cc1-963c-23e609967e9f | CRCL | 2026-09-16 09:44 | other | 2 | 2 | 114 | 183084.00 | unknown | — | 84.0200 | 0.8250 | ["85","90"] | ["0.8014","1.1276"] | [] | ["AMXO","ARCO"] | 85.0000 | 90.0000 | 2 | 121 | false | false | true | true | true | mlet | |||||||
| 01a0a0b3-6ca8-7f90-a3a1-f4907e17d79a | CRCL | 2026-09-14 12:15 | other | 2 | 1 | 148 | 272764.00 | unknown | — | 94.1400 | 1.6500 | ["120","140"] | ["0.8445","0.8159"] | [] | ["ARCO"] | 120.0000 | 140.0000 | 95 | 186 | false | true | true | true | false | mlet | |||||||
| 01a091b6-24e8-7200-bdda-ac5b531f7bd2 | CRCL | 2026-09-11 14:23 | other | 2 | 1 | 120 | 234840.00 | unknown | — | 91.2590 | 2.9000 | ["100"] | ["3.7351"] | [] | ["MCRY"] | 100.0000 | 100.0000 | 0 | 7 | false | false | true | false | false | mlet | |||||||
| 01a08bb5-3bb0-7270-a446-6d69f4c1abc4 | CRCL | 2026-09-10 10:25 | other | 4 | 1 | 350 | 242200.00 | unknown | — | 92.0100 | 0.8300 | ["93","97","105","110"] | ["0.8358","0.8553","1.3104","1.4179"] | [] | ["EDGO"] | 93.0000 | 110.0000 | 1 | 8 | false | true | true | true | false | mlet | |||||||
| 01a08176-ef18-7402-88e6-f9a9276d6295 | CRCL | 2026-09-08 10:40 | other | 4 | 2 | 80 | 187252.00 | unknown | — | 98.3900 | 2.2500 | ["75","80","109","110"] | ["0.8048","0.7961","0.9431","0.9275"] | [] | ["XISX","XPHO"] | 75.0000 | 110.0000 | 3 | 38 | false | false | true | true | false | mlet | |||||||
| 01a06dd4-6685-7b52-a1a7-f2593c751107 | CRCL | 2026-09-04 15:10 | other | 2 | 1 | 100 | 491300.00 | unknown | — | 101.6400 | 2.9500 | ["75","80"] | ["15.1249","0.7242"] | [] | ["XMIO"] | 75.0000 | 80.0000 | 0 | 21 | false | false | true | true | false | mlet | |||||||
| 01a06da0-8545-7be0-b5a9-bf9d9ae692cc | CRCL | 2026-09-04 14:13 | other | 4 | 4 | 111 | 178549.00 | unknown | — | 100.9150 | 1.6700 | ["93","98","103","108"] | ["3.9641","1.6132","0.7410","0.7562"] | [] | ["AMXO","EDGO","XCBO","XPHO"] | 93.0000 | 108.0000 | 0 | 7 | false | false | true | true | false | mlet | |||||||
| 01a06da0-8545-7be0-b5a9-bf8d0d758967 | CRCL | 2026-09-04 14:13 | other | 4 | 4 | 211 | 339359.00 | unknown | — | 100.9150 | 1.6700 | ["93","98","103","108"] | ["3.9708","1.6041","0.7411","0.7557"] | [] | ["AMXO","EDGO","XCBO","XPHO"] | 93.0000 | 108.0000 | 0 | 7 | false | false | true | true | false | mlet | |||||||
| 01a06d89-9245-71f2-938d-5c075613e1b9 | CRCL | 2026-09-04 13:48 | other | 2 | 5 | 58 | 138835.00 | unknown | — | 101.2400 | 0.6500 | ["68","105"] | ["12.6133","0.7809"] | [] | ["AMXO","ARCO","XBOX","XISX","XPHO"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet | |||||||
| 01a06d89-8e5d-7510-98ea-beaa1131e2b2 | CRCL | 2026-09-04 13:48 | other | 2 | 1 | 74 | 176490.00 | unknown | — | 101.1400 | 0.5500 | ["68","105"] | ["12.8347","0.7811"] | [] | ["XBOX"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet | |||||||
| 01a06d89-8a75-7582-bbe1-c61f0aae0ab0 | CRCL | 2026-09-04 13:48 | other | 2 | 6 | 50 | 119112.00 | unknown | — | 101.1400 | 0.6000 | ["68","105"] | ["11.5126","0.7862"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet | |||||||
| 01a06d89-7ad5-78a0-8cea-7dd248128211 | CRCL | 2026-09-04 13:48 | other | 2 | 1 | 100 | 238750.00 | unknown | — | 101.1400 | 0.5000 | ["68","105"] | ["12.1000","0.7856"] | [] | ["ARCO"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet | |||||||
| 01a06d89-7ad5-78a0-8cea-7dbd56e05254 | CRCL | 2026-09-04 13:48 | other | 2 | 1 | 104 | 248560.00 | unknown | — | 101.1400 | 0.5500 | ["68","105"] | ["12.8298","0.7856"] | [] | ["ARCO"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet | |||||||
| 01a06d89-76ed-7193-89fb-fa836a023ca7 | CRCL | 2026-09-04 13:48 | other | 2 | 4 | 346 | 822103.00 | unknown | — | 101.1400 | 0.6069 | ["68","105"] | ["13.0719","0.7760"] | [] | ["AMXO","ARCO","XBOX","XPHO"] | 68.0000 | 105.0000 | 0 | 28 | false | false | true | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:44:27Z"} |
| 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-14T16:15:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:24:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:25:18Z"} |
| 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-08T14:41: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-04T19:11:00Z"} |
| 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-04T18:14:38Z"} |
| 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-04T18:14:38Z"} |
| 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-04T17:49:04Z"} |
| 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-04T17:49:04Z"} |
| 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-04T17:49:04Z"} |
| 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-04T17:49:04Z"} |
| 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-04T17:49:04Z"} |
| 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-04T17:49:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |