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 | direction |
|---|
| 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 |
|---|
| 01a0caa3-198e-76a2-aba6-ceda1f61aaf7 | STX | 2026-09-22 15:41 | call_diagonal_spread | 2 | 1 | 5 | 80200.00 | long | ask | 923.7000 | 24.6000 | ["865","880"] | ["0.7101","0.6799"] | [] | ["XISX"] | 865.0000 | 880.0000 | 3 | 31 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:41:37Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca88-f627-7f70-b559-51f8650fe6e4 | STX | 2026-09-22 15:12 | call_diagonal_spread | 2 | 1 | 9 | 66168.00 | long | ask | 919.0650 | 15.2000 | ["900","930"] | ["0.7417","0.7055"] | [] | ["XCBO"] | 900.0000 | 930.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0ca68-df4f-7fa1-8859-e1a6af104005 | STX | 2026-09-22 14:37 | call_diagonal_spread | 2 | 1 | 2 | 32940.00 | long | ask | 910.2300 | 18.3000 | ["880","920"] | ["0.6788","0.7504"] | [] | ["XISX"] | 880.0000 | 920.0000 | 24 | 38 | false | false | true | ||||||||||
| 01a0ca2b-ce7f-70b1-9b37-18a9fe45fc94 | STX | 2026-09-22 13:31 | call_diagonal_spread | 2 | 1 | 6 | 29160.00 | long | ask | 901.6600 | 8.5000 | ["920","940"] | ["0.8315","0.7501"] | [] | ["XISX"] | 920.0000 | 940.0000 | 3 | 10 | false | true | true | ||||||||||
| 01a0c988-d7be-70e3-acbc-260449705713 | STX | 2026-09-22 10:33 | call_diagonal_spread | 2 | 1 | 3 | 46230.00 | long | ask | 911.9600 | 21.3000 | ["1020","1060"] | ["0.7600","0.7335"] | [] | ["XISX"] | 1020.0000 | 1060.0000 | 59 | 87 | false | true | true | ||||||||||
| 01a0c980-4856-7552-9570-7e348106c53e | STX | 2026-09-22 10:23 | call_diagonal_spread | 2 | 1 | 5 | 41420.00 | long | ask | 913.5700 | 22.7000 | ["890","920"] | ["0.8373","0.7381"] | [] | ["ARCO"] | 890.0000 | 920.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0b612-10cf-7dc3-910b-99c4374e27c8 | STX | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 5 | 36150.00 | long | bid | 870.9600 | 26.8000 | ["835","860"] | ["5.1297","0.6275"] | [] | ["XMIO"] | 835.0000 | 860.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b60f-d297-7432-add0-d4476baf4dc8 | STX | 2026-09-18 15:48 | call_diagonal_spread | 2 | 1 | 8 | 40752.00 | long | bid | 860.4900 | 10.3000 | ["835","870"] | ["7.4299","0.6214"] | [] | ["XMIO"] | 835.0000 | 870.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b60f-1717-7a90-8cd0-eae9604a7562 | STX | 2026-09-18 15:47 | call_diagonal_spread | 2 | 1 | 10 | 69600.00 | long | ask | 859.0600 | 11.5000 | ["830","840"] | ["3.9082","0.6270"] | [] | ["XISX"] | 830.0000 | 840.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b60e-5b97-7362-8c19-41c523b9cbc1 | STX | 2026-09-18 15:46 | call_diagonal_spread | 2 | 2 | 4 | 25358.00 | long | ask | 858.3600 | 5.9000 | ["830","850"] | ["3.7257","0.6367"] | [] | ["ARCO","XISX"] | 830.0000 | 850.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b607-2fa7-7980-9400-7c5d1dc7102e | STX | 2026-09-18 15:38 | call_diagonal_spread | 2 | 1 | 160 | 8207040.00 | long | ask | 856.5300 | 24.5000 | ["600","630"] | ["38.1950","0.6930"] | [] | ["SPHR"] | 600.0000 | 630.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5ea-166f-7432-81ff-8474ff57c39e | STX | 2026-09-18 15:06 | call_diagonal_spread | 2 | 1 | 10 | 45150.00 | long | ask | 857.4300 | 7.5000 | ["842.5","860"] | ["1.4962","0.6412"] | [] | ["XISX"] | 842.5000 | 860.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b5d7-70ff-7d70-b161-17966ccf65f2 | STX | 2026-09-18 14:46 | call_diagonal_spread | 2 | 1 | 10 | 25680.00 | long | ask | 855.7500 | 5.7000 | ["850","880"] | ["0.6994","0.6136"] | [] | ["XISX"] | 850.0000 | 880.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b5c4-1faf-74c2-b17a-708ffa52a683 | STX | 2026-09-18 14:25 | call_diagonal_spread | 2 | 1 | 5 | 28350.00 | long | ask | 850.9150 | 13.2000 | ["830","840"] | ["2.4795","0.6366"] | [] | ["XMIO"] | 830.0000 | 840.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b5a9-d537-7c32-b55a-17b63ca0cb34 | STX | 2026-09-18 13:56 | call_diagonal_spread | 2 | 1 | 4 | 58160.00 | long | ask | 851.9150 | 14.1000 | ["790","800"] | ["0.6507","0.6677"] | [] | ["XISX"] | 790.0000 | 800.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a0b5a5-aeb8-7170-bccc-d04c14fae5ca | STX | 2026-09-18 13:52 | call_diagonal_spread | 2 | 1 | 4 | 57816.00 | long | ask | 851.8201 | 18.2000 | ["790","800"] | ["0.6395","0.6614"] | [] | ["BATO"] | 790.0000 | 800.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a0b4f3-528f-7b31-a9eb-c5ef9f2cd746 | STX | 2026-09-18 10:37 | call_diagonal_spread | 2 | 1 | 22 | 2395448.00 | long | bid | 830.6446 | 23.3000 | ["280","300"] | ["20.9871","0.8826"] | [] | ["XMIO"] | 280.0000 | 300.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b023-3cc3-71e0-8a5d-977a10b64b81 | STX | 2026-09-17 12:11 | call_diagonal_spread | 2 | 1 | 2 | 95560.00 | long | ask | 801.4300 | 21.6000 | ["800","900"] | ["0.7061","0.7134"] | [] | ["AMXO"] | 800.0000 | 900.0000 | 365 | 491 | false | false | true | ||||||||||
| 01a0aa74-9623-7593-b82e-340bd97f0449 | STX | 2026-09-16 09:42 | call_diagonal_spread | 2 | 1 | 2 | 113964.00 | long | ask | 777.0700 | 32.4000 | ["750","1000"] | ["0.7182","0.7181"] | [] | ["XCBO"] | 750.0000 | 1000.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0a655-e936-73f3-b325-fa18b375fba5 | STX | 2026-09-15 14:30 | call_diagonal_spread | 2 | 1 | 2 | 33318.00 | long | ask | 762.0800 | 16.4000 | ["770","780"] | ["0.7467","0.7310"] | [] | ["XMIO"] | 770.0000 | 780.0000 | 45 | 66 | false | true | true | ||||||||||
| 01a0a572-7a8e-7810-8054-6ff69d4f169a | STX | 2026-09-15 10:22 | call_diagonal_spread | 2 | 1 | 12 | 48336.00 | long | ask | 779.9150 | 6.7250 | ["790","810"] | ["0.6650","0.7670"] | [] | ["XISX"] | 790.0000 | 810.0000 | 3 | 10 | false | true | true | ||||||||||
| 01a0a554-30a6-7882-b54a-9b52ab830de4 | STX | 2026-09-15 09:49 | call_diagonal_spread | 2 | 3 | 55 | 565503.00 | long | ask | 782.6650 | 14.0000 | ["810","820"] | ["0.6723","0.6592"] | [] | ["ARCO","C2OX"] | 810.0000 | 820.0000 | 31 | 38 | false | true | true | ||||||||||
| 01a0a554-30a6-7882-b54a-9b3971d69f0b | STX | 2026-09-15 09:49 | call_diagonal_spread | 2 | 3 | 4 | 41026.00 | long | ask | 782.6650 | 13.5000 | ["810","820"] | ["0.6701","0.6588"] | [] | ["ARCO","C2OX"] | 810.0000 | 820.0000 | 31 | 38 | false | true | true | ||||||||||
| 01a0a046-1c49-70e1-9519-8664f35bb2b3 | STX | 2026-09-14 10:15 | call_diagonal_spread | 2 | 4 | 10 | 66686.00 | long | ask | 808.8550 | 15.9200 | ["802.5","817.5"] | ["0.8175","0.7013"] | [] | ["EMLD","XISX","XMIO","XPHO"] | 802.5000 | 817.5000 | 4 | 11 | true | false | true | ||||||||||
| 01a09104-5949-7843-abb5-809dd234b6ac | STX | 2026-09-11 11:09 | call_diagonal_spread | 2 | 1 | 8 | 123416.00 | long | ask | 820.9700 | 13.0250 | ["820","880"] | ["0.7290","0.6820"] | [] | ["XISX"] | 820.0000 | 880.0000 | 35 | 70 | false | false | true | ||||||||||
| 01a090cf-bc89-7201-8977-b73590ffc579 | STX | 2026-09-11 10:12 | call_diagonal_spread | 2 | 1 | 5 | 28850.00 | long | ask | 834.5900 | 6.8000 | ["840","865"] | ["0.6453","0.6517"] | [] | ["XCBO"] | 840.0000 | 865.0000 | 7 | 14 | false | true | true | ||||||||||
| 01a086df-5170-7c51-a4a3-e0cf0a2bc4d9 | STX | 2026-09-09 11:52 | call_diagonal_spread | 2 | 1 | 3 | 98925.00 | long | ask | 909.3100 | 25.3000 | ["750","830"] | ["0.8397","0.7766"] | [] | ["XCBO"] | 750.0000 | 830.0000 | 9 | 72 | false | false | true | ||||||||||
| 01a0869e-d1b8-7fb3-b32e-be38e98d1695 | STX | 2026-09-09 10:42 | call_diagonal_spread | 2 | 1 | 10 | 385450.00 | long | ask | 911.3933 | 22.5000 | ["720","735"] | ["1.6136","0.7530"] | [] | ["XISX"] | 720.0000 | 735.0000 | 2 | 30 | false | false | true | ||||||||||
| 01a08226-2e60-7630-b983-7110cbbce813 | STX | 2026-09-08 13:52 | call_diagonal_spread | 2 | 1 | 7 | 88060.00 | long | ask | 916.1000 | 5.0500 | ["1030","1450"] | ["0.7532","1.4585"] | [] | ["ARCO"] | 1030.0000 | 1450.0000 | 3 | 129 | false | true | true | ||||||||||
| 01a0820d-e788-7b62-b3f4-d6f0a39775e6 | STX | 2026-09-08 13:25 | call_diagonal_spread | 2 | 1 | 2 | 26008.00 | long | bid | 918.7000 | 9.1000 | ["870","1000"] | ["0.7712","0.7231"] | [] | ["XMIO"] | 870.0000 | 1000.0000 | 10 | 38 | false | false | true | ||||||||||
| 01a081e2-d430-7273-a9a9-c8d2bbccffe5 | STX | 2026-09-08 12:38 | call_diagonal_spread | 2 | 1 | 10 | 74220.00 | long | ask | 895.7900 | 2.4000 | ["880","910"] | ["0.8453","0.7493"] | [] | ["XCBO"] | 880.0000 | 910.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a08148-e9d8-7813-b8ba-40e86cbe6220 | STX | 2026-09-08 09:50 | call_diagonal_spread | 2 | 1 | 2 | 40416.00 | long | bid | 875.4900 | 26.8000 | ["775","790"] | ["0.9607","0.7707"] | [] | ["BATO"] | 775.0000 | 790.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a08145-ec38-7ae3-a663-d21cc79761ea | STX | 2026-09-08 09:47 | call_diagonal_spread | 2 | 1 | 10 | 269340.00 | long | ask | 875.8500 | 20.9000 | ["750","880"] | ["0.8193","0.7311"] | [] | ["ARCO"] | 750.0000 | 880.0000 | 10 | 101 | false | false | true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:13:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:38:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:31:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:33:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:24:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:48:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:38:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:07:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:34Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:25:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:56:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:52:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:37:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:12:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:31:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:22:23Z"} |
| 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-15T13:49:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:49:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:09:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:12:25Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:52:55Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:42:33Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:52:30Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:26:12Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:50:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:47:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |