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 |
|---|
| 01a0d958-4077-7f71-a38b-d15c6d3cbf73 | SCHW | 2026-09-25 12:13 | put_vertical_spread | 2 | 1 | 130 | 107250.00 | unknown | — | 99.3700 | 0.4000 | ["92.5","95"] | ["0.2976","0.2940"] | [] | ["XISX"] | 92.5000 | 95.0000 | 147 | 147 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:14:15Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d4b8-eec7-7cd2-a5b0-162032614f79 | SCHW | 2026-09-24 14:41 | put_vertical_spread | 2 | 1 | 918 | 844560.00 | unknown | bid | 99.6107 | 4.2500 | ["104","105"] | ["1.6388","1.9002"] | ["99.90"] | ["XBOX"] | 104.0000 | 105.0000 | 1 | 1 | true | ||||||||||||
| 01a0d3ea-bd9f-76c3-9382-707e7bfb1135 | SCHW | 2026-09-24 10:56 | synthetic | 2 | 1 | 500 | 971000.00 | short | bid | 98.6650 | 0.9500 | ["100"] | ["0.2916"] | ["100.72"] | ["XBOX"] | 100.0000 | 100.0000 | 266 | 266 | false | false | |||||||||||
| 01a0cf6f-ef97-7e10-99e7-6a07bdc34c9d | SCHW | 2026-09-23 14:03 | call_diagonal_spread | 2 | 1 | 564 | 118440.00 | short | bid | 100.3100 | 0.4800 | ["105","109"] | ["0.2926","0.2753"] | [] | ["ARCO"] | 105.0000 | 109.0000 | 9 | 37 | false | true | |||||||||||
| 01a0ca29-cadf-71e3-b5c0-f4f1c7e2409d | SCHW | 2026-09-22 13:28 | straddle | 2 | 2 | 144 | 177552.00 | short | bid | 101.0500 | 0.5000 | ["100"] | ["0.2727"] | ["87.67","112.33"] | ["MCRY","SPHR"] | 100.0000 | 100.0000 | 115 | 115 | false | false | |||||||||||
| 01a0ca09-4a8f-7531-8f3d-5bcba45d3d61 | SCHW | 2026-09-22 12:53 | put_vertical_spread | 2 | 1 | 262 | 110564.00 | short | bid | 100.8201 | 0.2600 | ["101","102"] | ["0.2725","0.2667"] | ["101.48"] | ["XMIO"] | 101.0000 | 102.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca08-e8e7-7d11-83e4-ec2215d22385 | SCHW | 2026-09-22 12:52 | put_vertical_spread | 2 | 2 | 500 | 210000.00 | short | bid | 100.8550 | 0.2300 | ["101","102"] | ["0.2751","0.2667"] | ["101.50"] | ["XMIO"] | 101.0000 | 102.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca07-8186-7300-b763-494ecb157351 | SCHW | 2026-09-22 12:51 | put_vertical_spread | 2 | 1 | 500 | 472500.00 | unknown | — | 100.8850 | 0.6000 | ["105","106"] | ["0.3523","0.3772"] | [] | ["XPHO"] | 105.0000 | 106.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca01-6ed7-7e81-bb44-7be9b23b8323 | SCHW | 2026-09-22 12:44 | put_ratio_spread | 2 | 3 | 312 | 175142.00 | unknown | bid | 100.7700 | 0.6495 | ["90","110"] | ["0.2889","0.2784"] | ["93.16"] | ["ARCO","SPHR","XBOX"] | 90.0000 | 110.0000 | 115 | 115 | false | ||||||||||||
| 01a0ca01-47c7-71f2-8c1c-ddc6365b3d61 | SCHW | 2026-09-22 12:44 | put_frontspread | 2 | 3 | 207 | 115554.00 | long | ask | 100.7700 | 1.1000 | ["90","110"] | ["0.2879","0.2762"] | ["82.70","104.6"] | ["EDGO","XBOX","XCBO"] | 90.0000 | 110.0000 | 115 | 115 | false | ||||||||||||
| 01a0c9dd-317e-79f0-9c98-5b506b20ff27 | SCHW | 2026-09-22 12:05 | put_ratio_spread | 2 | 1 | 2000 | 1578000.00 | unknown | bid | 100.4000 | 1.0900 | ["90","110"] | ["0.2992","0.2846"] | ["77.20","102.80"] | ["AMXO"] | 90.0000 | 110.0000 | 115 | 115 | false | ||||||||||||
| 01a0c9d0-3547-75e3-938b-abf10c1588da | SCHW | 2026-09-22 11:50 | call_diagonal_spread | 2 | 1 | 100 | 221500.00 | short | ask | 100.5200 | 0.4000 | ["100","105"] | ["0.2769","0.2729"] | [] | ["XISX"] | 100.0000 | 105.0000 | 268 | 360 | false | false | |||||||||||
| 01a0c9ce-e16e-7102-ab85-9215b36e6e53 | SCHW | 2026-09-22 11:49 | call_diagonal_spread | 2 | 1 | 100 | 222290.00 | short | ask | 100.5700 | 0.5500 | ["100","105"] | ["0.2771","0.2733"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 268 | 360 | false | false | |||||||||||
| 01a0c96e-71ef-71c0-bcb1-283695aa8cf2 | SCHW | 2026-09-22 10:04 | call_vertical_spread | 2 | 11 | 100 | 113858.00 | unknown | bid | 102.6500 | 1.0135 | ["95","125"] | ["0.2820","0.2843"] | ["106.39"] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 95.0000 | 125.0000 | 87 | 87 | false | ||||||||||||
| 01a0b5d4-3caf-7153-a6c2-7bf70ff9c910 | SCHW | 2026-09-18 14:42 | put_diagonal_spread | 2 | 3 | 107 | 206836.00 | unknown | ask | 105.2800 | 0.4000 | ["105","110"] | ["0.2799","0.2958"] | [] | ["AMXO","XCBO","XPHO"] | 105.0000 | 110.0000 | 182 | 364 | false | ||||||||||||
| 01a0b573-4c48-7893-9038-7d9c894abd36 | SCHW | 2026-09-18 12:57 | synthetic | 2 | 1 | 750 | 471000.00 | long | ask | 104.9000 | 0.3000 | ["105"] | ["0.2711"] | ["105.30"] | ["XPHO"] | 105.0000 | 105.0000 | 28 | 28 | false | false | |||||||||||
| 01a0b0c8-f2a3-7c43-addd-9469db425759 | SCHW | 2026-09-17 15:12 | put_vertical_spread | 2 | 1 | 396 | 181368.00 | unknown | — | 104.8250 | 0.1800 | ["100","105"] | ["0.2937","0.2757"] | [] | ["XISX"] | 100.0000 | 105.0000 | 29 | 29 | false | false | false | true | |||||||||
| 01a0b0b5-b0f3-7b61-8ce1-19f46d733f4b | SCHW | 2026-09-17 14:51 | other | 4 | 1 | 531 | 509588.00 | unknown | — | 104.8300 | 8.2000 | ["109","110","111","115"] | ["0.4668","1.1268","1.9032","2.5645"] | [] | ["XBOX"] | 109.0000 | 115.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0abc9-3943-78a0-b502-dbebae87754d | SCHW | 2026-09-16 15:54 | call_diagonal_spread | 2 | 1 | 1250 | 362500.00 | unknown | — | 105.1200 | 0.4000 | ["105","106"] | ["0.3150","0.2476"] | [] | ["AMXO"] | 105.0000 | 106.0000 | 2 | 16 | false | false | true | true | |||||||||
| 01a0abad-411b-7e81-810a-2a1b8cef0eec | SCHW | 2026-09-16 15:24 | call_calendar | 2 | 1 | 688 | 117648.00 | short | ask | 103.8850 | 0.3100 | ["110"] | ["0.3399"] | [] | ["EDGO"] | 110.0000 | 110.0000 | 2 | 37 | false | true | |||||||||||
| 01a0ab99-1123-7ea3-b84e-bd56ba56d472 | SCHW | 2026-09-16 15:02 | put_vertical_spread | 2 | 1 | 25 | 136900.00 | long | ask | 104.6838 | 6.5500 | ["110","140"] | ["0.3330","0.3721"] | ["120"] | ["XISX"] | 110.0000 | 140.0000 | 821 | 821 | true | false | |||||||||||
| 01a0aaf4-b6eb-7041-9dbd-327cd864a3a2 | SCHW | 2026-09-16 12:02 | call_vertical_spread | 2 | 1 | 69 | 276069.00 | long | ask | 106.3000 | 3.5000 | ["85","87.5"] | ["2.3577","2.1603"] | ["87.47"] | ["XCBO"] | 85.0000 | 87.5000 | 2 | 2 | false | false | |||||||||||
| 01a0aae0-09f3-7e23-b7d0-6ee572fb06d5 | SCHW | 2026-09-16 11:40 | put_vertical_spread | 2 | 2 | 850 | 144500.00 | unknown | — | 105.7600 | 0.3500 | ["105","106"] | ["0.3156","0.3031"] | [] | ["XISX"] | 105.0000 | 106.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aada-0eb3-7790-b5e1-eaa43f1a9b5c | SCHW | 2026-09-16 11:33 | call_diagonal_spread | 2 | 1 | 333 | 136197.00 | long | ask | 106.5500 | 0.3500 | ["105","110"] | ["0.3330","0.2756"] | [] | ["XISX"] | 105.0000 | 110.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aacf-067b-7cd1-be74-432881d4359e | SCHW | 2026-09-16 11:21 | risk_reversal | 2 | 1 | 350 | 140000.00 | short | bid | 107.0300 | 0.4400 | ["106","107"] | ["0.2663","0.2331"] | ["107.38"] | ["XPHO"] | 106.0000 | 107.0000 | 16 | 16 | true | false | |||||||||||
| 01a0aa84-8c14-7052-a1f7-f1251d3a5773 | SCHW | 2026-09-16 10:00 | call_diagonal_spread | 2 | 2 | 40 | 209120.00 | short | ask | 106.7600 | 3.9500 | ["80","87.5"] | ["0.3453","0.2902"] | [] | ["ARCO"] | 80.0000 | 87.5000 | 93 | 274 | false | false | |||||||||||
| 01a0aa83-ad6b-78f0-b0f1-5809cf23b6e6 | SCHW | 2026-09-16 09:59 | call_diagonal_spread | 2 | 1 | 71 | 385086.00 | short | ask | 106.8400 | 3.9500 | ["80","85"] | ["0.3177","0.2886"] | [] | ["XMIO"] | 80.0000 | 85.0000 | 93 | 274 | false | false | |||||||||||
| 01a0aa72-772b-77a2-b520-e67a5c94ac03 | SCHW | 2026-09-16 09:40 | call_diagonal_spread | 2 | 1 | 4300 | 1823200.00 | unknown | — | 106.5950 | 0.5300 | ["105","110"] | ["0.3624","0.2776"] | [] | ["XPHO"] | 105.0000 | 110.0000 | 2 | 30 | false | false | true | true | |||||||||
| 01a0a688-0d26-7a43-a0e2-d894ca700420 | SCHW | 2026-09-15 15:25 | other | 3 | 3 | 104 | 125113.00 | unknown | — | 108.3200 | 0.7500 | ["100","110","115"] | ["0.5066","0.2685","0.2631"] | [] | ["XISX"] | 100.0000 | 115.0000 | 3 | 94 | false | false | true | true | |||||||||
| 01a091bc-7618-7962-9700-dfeba1dbeaad | SCHW | 2026-09-11 14:30 | other | 3 | 1 | 1086 | 113058.00 | unknown | — | 106.9000 | 0.4600 | ["99","104","108"] | ["0.2984","0.2485","0.6127"] | [] | ["AMXO"] | 99.0000 | 108.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0911a-4a78-7ba0-a0eb-63badef43b2a | SCHW | 2026-09-11 11:33 | call_diagonal_spread | 2 | 1 | 565 | 341260.00 | short | bid | 106.5000 | 0.2300 | ["105","115"] | ["0.2475","0.2548"] | [] | ["XPHO"] | 105.0000 | 115.0000 | 7 | 126 | false | false | |||||||||||
| 01a08773-1978-7941-b8cc-ef7fecfdb970 | SCHW | 2026-09-09 14:34 | strangle | 2 | 1 | 1000 | 228000.00 | short | bid | 106.9150 | 0.2900 | ["106","108"] | ["0.2333","0.2415"] | ["103.72","110.28"] | ["ARCO"] | 106.0000 | 108.0000 | 9 | 9 | true | true | |||||||||||
| 01a08271-e918-7f00-aceb-6ad0923def42 | SCHW | 2026-09-08 15:14 | other | 2 | 1 | 600 | 233400.00 | unknown | — | 108.0790 | 0.3900 | ["105","108"] | ["0.2721","0.2460"] | [] | ["XISX"] | 105.0000 | 108.0000 | 10 | 38 | false | true | true | true |
| false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:41:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:56:35Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:04:15Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:28:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:53:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:53:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:51:35Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:45:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:45:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:51:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:49:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:04:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:43:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:57:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:12:37Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:51:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:54:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:24:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:02:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:02:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:40:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:33:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:21:48Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:00:19Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:59:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:40:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:26:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:31:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:33:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:34:54Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:15:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |