core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 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 | true | 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 |
| 01a0a046-1c49-70e1-9519-863058ca3861 | STX | 2026-09-14 10:15 | call_diagonal_spread | 2 | 1 | 20 | 138940.00 | short | bid | 808.8550 | 12.5000 | ["800","815"] | ["0.8216","0.7050"] | [] | ["ARCO"] | 800.0000 | 815.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0a046-1860-7ff1-b67c-27f6374b98c8 | STX | 2026-09-14 10:15 | call_diagonal_spread | 2 | 1 | 6 | 41046.00 | unknown | — | 808.8550 | 13.0000 | ["800","815"] | ["0.8056","0.6955"] | [] | ["XPHO"] | 800.0000 | 815.0000 | 4 | 11 | false | false | true | true | false | mlet | |||||||
| 01a0a03f-59d1-7980-8426-7782b9dcdc43 | STX | 2026-09-14 10:08 | call_diagonal_spread | 2 | 1 | 2 | 26370.00 | short | bid | 796.5000 | 25.4000 | ["780","900"] | ["1.0317","0.6705"] | [] | ["ARCO"] | 780.0000 | 900.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a03f-32c0-7141-a72f-5974d929e601 | STX | 2026-09-14 10:08 | call_diagonal_spread | 2 | 1 | 5 | 278850.00 | short | bid | 797.2000 | 32.0000 | ["900","1010"] | ["0.7477","0.7412"] | [] | ["XCBO"] | 900.0000 | 1010.0000 | 494 | 858 | false | true | true | true | |||||||||
| 01a0a03d-65d0-79d3-9612-517e0dbb2a60 | STX | 2026-09-14 10:06 | call_diagonal_spread | 2 | 1 | 11 | 672760.00 | short | bid | 795.8100 | 9.8000 | ["820","900"] | ["0.7556","0.7477"] | [] | ["XISX"] | 820.0000 | 900.0000 | 494 | 858 | false | true | true | true | |||||||||
| 01a0a02a-4b30-7b03-82f9-56e9d37b851a | STX | 2026-09-14 09:45 | call_diagonal_spread | 2 | 1 | 2 | 107936.00 | short | bid | 791.5200 | 31.5000 | ["700","750"] | ["0.7418","0.7479"] | [] | ["XCBO"] | 700.0000 | 750.0000 | 276 | 494 | false | false | true | true | |||||||||
| 01a091bd-be38-7ec0-9d6a-d87a21b8db30 | STX | 2026-09-11 14:32 | call_diagonal_spread | 2 | 1 | 3 | 74100.00 | short | ask | 833.1500 | 21.6000 | ["700","900"] | ["0.9634","0.6941"] | [] | ["XMIO"] | 700.0000 | 900.0000 | 7 | 126 | false | false | true | true | |||||||||
| 01a09106-ce30-77f1-af88-c9d6fe6ffa26 | STX | 2026-09-11 11:12 | call_diagonal_spread | 2 | 1 | 6 | 44826.00 | short | bid | 821.0100 | 8.2000 | ["820","827.5"] | ["0.6751","0.9383"] | [] | ["SPHR"] | 820.0000 | 827.5000 | 0 | 35 | false | false | true | 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 | 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 | true | |||||||||
| 01a08b83-3ed2-77a2-85d6-7260d04b84fa | STX | 2026-09-10 09:30 | call_diagonal_spread | 2 | 1 | 3 | 458838.00 | short | ask | 855.6900 | 35.5000 | ["80","110"] | ["1.6695","1.2076"] | [] | ["XMIO"] | 80.0000 | 110.0000 | 280 | 498 | false | false | true | true | |||||||||
| 01a08764-19a1-7fb1-8fa4-1da1c43907ce | STX | 2026-09-09 14:17 | call_diagonal_spread | 2 | 1 | 2 | 51640.00 | short | ask | 905.1200 | 21.4000 | ["900","940"] | ["0.7830","0.7348"] | [] | ["XMIO"] | 900.0000 | 940.0000 | 72 | 100 | false | false | true | true | |||||||||
| 01a08744-a6d8-7f10-ad17-f9ee048fed34 | STX | 2026-09-09 13:43 | call_diagonal_spread | 2 | 1 | 10 | 400140.00 | short | ask | 905.5200 | 26.3000 | ["920","1680"] | ["0.7521","0.7555"] | [] | ["C2OX"] | 920.0000 | 1680.0000 | 281 | 499 | false | true | 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 | 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 | 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 | 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 | 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 | true | |||||||||
| 01a08153-bb60-7932-865f-75a900e4839e | STX | 2026-09-08 10:02 | call_diagonal_spread | 2 | 1 | 3 | 27978.00 | short | bid | 860.5800 | 4.0000 | ["827.5","850"] | ["0.8757","0.7204"] | [] | ["BATO"] | 827.5000 | 850.0000 | 3 | 10 | false | false | true | 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 | 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 | true | |||||||||
| 01a0813e-81c8-7211-9c7c-122be337dffc | STX | 2026-09-08 09:39 | call_diagonal_spread | 2 | 1 | 4 | 50680.00 | unknown | — | 885.1375 | 23.8000 | ["925","1100"] | ["0.7107","0.7272"] | [] | ["XPHO"] | 925.0000 | 1100.0000 | 31 | 101 | false | true | true | true | false | mlet | |||||||
| 01a08138-1159-79e1-af3d-e3960b966759 | STX | 2026-09-08 09:32 | call_diagonal_spread | 2 | 1 | 10 | 276210.00 | short | bid | 888.0000 | 23.0000 | ["750","755"] | ["1.2413","0.6300"] | [] | ["XISX"] | 750.0000 | 755.0000 | 3 | 17 | false | false | true | true |
| mlet |
| market_whale |
| 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 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:08:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:08:17Z"} |
| 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-14T14:06:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:45:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:32:41Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:12:33Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:30:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:18:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:44:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:02:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:39:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |