Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a091b9-41c8-7093-980f-d4ce2b68c987 | MU | 2026-09-11 14:27 | call_ratio_spread | 2 | 1 | 20 | 287870.00 | long | ask | 975.7600 | 3.6000 | ["900","950"] | ["0.5947","0.5971"] | ["1057.41"] | ["BATO"] | 900.0000 | 950.0000 | 35 | 35 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:27:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c6e-e6f0-7041-bb50-e294dbadbc41 | MU | 2026-09-10 13:47 | call_ratio_spread | 2 | 1 | 2 | 33558.00 | long | ask | 977.3250 | 9.8500 | ["1500","2500"] | ["0.6588","0.6833"] | ["1520.86","3479.14"] | ["XCBO"] | 1500.0000 | 2500.0000 | 498 | 498 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:48:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c07-bcc9-73c2-892a-05b81e0c3a4b | MU | 2026-09-10 11:55 | call_ratio_spread | 2 | 1 | 120 | 56160.00 | long | ask | 982.2731 | 0.0600 | ["1000","1050"] | ["0.7126","0.7789"] | ["1005.80","1094.20"] | ["ARCO"] | 1000.0000 | 1050.0000 | 1 | 1 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:55:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-7530-7541-859a-a32319ee7cf4 | MU | 2026-09-10 10:03 | call_ratio_spread | 2 | 1 | 2 | 40134.00 | long | ask | 992.0300 | 19.3500 | ["1360","2110"] | ["0.6648","0.6826"] | ["1360.82","2859.18"] | ["XPHO"] | 1360.0000 | 2110.0000 | 463 | 463 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:03:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087aa-bf90-78b0-8bb7-191bfa71a01c | MU | 2026-09-09 15:35 | call_ratio_spread | 2 | 1 | 2 | 26540.00 | long | ask | 1029.6300 | 8.8000 | ["920","950"] | ["8.9932","6.8216"] | ["1029.64"] | ["XCBO"] | 920.0000 | 950.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:35:16Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086dd-22d8-72e2-aa18-806ec5fd337a | MU | 2026-09-09 11:50 | call_ratio_spread | 2 | 1 | 40 | 94940.00 | long | ask | 1024.3900 | 0.9000 | ["1300","1370"] | ["0.7073","0.7223"] | ["1447.65"] | ["XMIO"] | 1300.0000 | 1370.0000 | 37 | 37 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08683-4ec0-7243-8a85-b8a6eb9c8aff | MU | 2026-09-09 10:12 | call_ratio_spread | 2 | 2 | 15 | 26430.00 | long | ask | 1037.6800 | 0.4500 | ["1055","1085"] | ["0.7439","0.7607"] | ["1059.44","1136.12"] | ["XMIO"] | 1055.0000 | 1085.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:12:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08682-0a89-7571-a37c-1d8a16547658 | MU | 2026-09-09 10:11 | call_ratio_spread | 2 | 1 | 6 | 26511.00 | long | ask | 1041.2200 | 4.9500 | ["1500","2100"] | ["0.6944","0.7486"] | ["1521.71","2678.29"] | ["ARCO"] | 1500.0000 | 2100.0000 | 128 | 128 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081e3-2250-7251-b119-9495158312c5 | MU | 2026-09-08 12:38 | call_ratio_spread | 2 | 1 | 10 | 33818.00 | long | ask | 1020.9600 | 0.4500 | ["1025","1035"] | ["0.6948","0.6933"] | ["1062.90"] | ["ARCO"] | 1025.0000 | 1035.0000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:39:25Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813a-72b8-7d02-8754-4ad4e0daa550 | MU | 2026-09-08 09:34 | call_ratio_spread | 2 | 6 | 14 | 29667.00 | long | ask | 1019.5111 | 0.6500 | ["1040","1070"] | ["0.7764","0.7899"] | ["1102.51"] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 1040.0000 | 1070.0000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813a-72b8-7d02-8754-4abe542faf14 | MU | 2026-09-08 09:34 | call_ratio_spread | 2 | 6 | 12 | 25432.00 | long | ask | 1019.5111 | 0.8000 | ["1040","1070"] | ["0.7766","0.7899"] | ["1102.50"] | ["AMXO","EMLD","XBOX","XCBO","XMIO","XPHO"] | 1040.0000 | 1070.0000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813a-72b8-7d02-8754-4a93ab6d5bb8 | MU | 2026-09-08 09:34 | call_ratio_spread | 2 | 6 | 12 | 25383.00 | unknown | — | 1019.5111 | 0.8500 | ["1040","1070"] | ["0.7755","0.7892"] | [] | ["AMXO","ARCO","EMLD","XBOX","XCBO","XPHO"] | 1040.0000 | 1070.0000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813a-72b8-7d02-8754-4a78813a0f3b | MU | 2026-09-08 09:34 | call_ratio_spread | 2 | 7 | 14 | 29586.00 | long | ask | 1019.5111 | 0.7500 | ["1040","1070"] | ["0.7751","0.7888"] | ["1102.49"] | ["AMXO","ARCO","BATO","EMLD","XBOX","XMIO","XPHO"] | 1040.0000 | 1070.0000 | 3 | 3 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d91-df45-7393-b4d8-d550bcea675b | MU | 2026-09-04 13:57 | call_ratio_spread | 2 | 1 | 6 | 32472.00 | long | ask | 999.9600 | 3.7500 | ["1300","1950"] | ["0.6635","0.7223"] | ["1338.38","2561.62"] | ["ARCO"] | 1300.0000 | 1950.0000 | 133 | 133 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:57:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d90-069d-7fb0-befd-7ecebb8626d5 | MU | 2026-09-04 13:55 | call_ratio_spread | 2 | 2 | 4 | 48983.00 | long | ask | 999.0700 | 4.5500 | ["1750","2350"] | ["0.6764","0.7027"] | ["2968.90"] | ["XPHO"] | 1750.0000 | 2350.0000 | 378 | 378 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:56:04Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d88-26fd-7653-8ee1-14db58ae9283 | MU | 2026-09-04 13:47 | call_ratio_spread | 2 | 1 | 60 | 495570.00 | long | ask | 998.2400 | 5.8000 | ["1300","2070"] | ["0.6592","0.7144"] | ["1346.59","2793.41"] | ["XPHO"] | 1300.0000 | 2070.0000 | 196 | 196 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:47:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d88-0f8d-7893-a0d6-547af9b6260e | MU | 2026-09-04 13:47 | call_ratio_spread | 2 | 1 | 60 | 495000.00 | long | ask | 998.2700 | 6.4000 | ["1300","2070"] | ["0.6579","0.7148"] | ["1346.08","2793.92"] | ["ARCO"] | 1300.0000 | 2070.0000 | 196 | 196 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:47:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |