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 |
|---|
| 01a0c9b0-7c2e-7ef3-bab5-cf1517c0dbdb | MRNA | 2026-09-22 11:16 | call_vertical_spread | 2 | 1 | 100 | 271400.00 | long | ask | 186.5600 | 3.6000 | ["175","187.5"] | ["0.8350","0.8590"] | ["181.68"] | ["XMIO"] | 175.0000 | 187.5000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:16:51Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c99c-63a7-71f3-8835-842a0857c8ca | MRNA | 2026-09-22 10:54 | call_vertical_spread | 2 | 1 | 1000 | 635000.00 | short | bid | 184.1800 | 0.3700 | ["190","195"] | ["0.9276","0.9579"] | ["191.27"] | ["EDGO"] | 190.0000 | 195.0000 | 3 | 3 | false | true | false | ||||||||||
| 01a0c998-1de7-7f82-9fe0-c03e2a7042ca | MRNA | 2026-09-22 10:49 | call_vertical_spread | 2 | 1 | 950 | 458850.00 | short | bid | 181.4450 | 0.2300 | ["190","195"] | ["0.9345","0.9653"] | ["191.01"] | ["EDGO"] | 190.0000 | 195.0000 | 3 | 3 | false | true | false | ||||||||||
| 01a0c991-4bce-7a60-8963-9a0ec00ef1c9 | MRNA | 2026-09-22 10:42 | call_vertical_spread | 2 | 1 | 30 | 515970.00 | unknown | bid | 180.8000 | 5.6000 | ["90","100"] | ["1.6927","1.5343"] | ["181.00"] | ["XCBO"] | 90.0000 | 100.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a0c98a-4ad7-7041-9ada-11d0f7eb5015 | MRNA | 2026-09-22 10:34 | call_vertical_spread | 2 | 1 | 1000 | 579000.00 | short | bid | 180.8500 | 0.4500 | ["187.5","192.5"] | ["0.9388","0.9646"] | ["188.71"] | ["EDGO"] | 187.5000 | 192.5000 | 3 | 3 | false | true | false | ||||||||||
| 01a0c985-842f-7c93-8610-571bd9b0bba3 | MRNA | 2026-09-22 10:29 | call_vertical_spread | 2 | 1 | 1000 | 653182.00 | short | bid | 181.8200 | 0.6100 | ["187.5","192.5"] | ["0.9466","0.9800"] | ["188.77"] | ["EDGO"] | 187.5000 | 192.5000 | 3 | 3 | false | true | false | ||||||||||
| 01a0c570-4a0e-7443-88d2-f13894eae0b2 | MRNA | 2026-09-21 15:27 | call_vertical_spread | 2 | 1 | 7 | 151354.00 | long | ask | 173.3700 | 5.4500 | ["60","75"] | ["1.0905","0.9897"] | ["74.08"] | ["XCBO"] | 60.0000 | 75.0000 | 116 | 116 | false | false | false | ||||||||||
| 01a0b5ff-a9e0-7c01-ba51-0181811b1159 | MRNA | 2026-09-18 15:30 | call_vertical_spread | 2 | 1 | 18 | 355338.00 | short | bid | 155.0700 | 4.7000 | ["45","70"] | ["1.3066","0.8474"] | ["68.67"] | ["XCBO"] | 45.0000 | 70.0000 | 119 | 119 | false | false | false | ||||||||||
| 01a0b5fe-0017-7711-a817-d5c0445abafb | MRNA | 2026-09-18 15:28 | call_vertical_spread | 2 | 1 | 10 | 197700.00 | long | ask | 155.0950 | 5.3000 | ["45","70"] | ["0.8294","0.8687"] | ["68.66"] | ["XCBO"] | 45.0000 | 70.0000 | 119 | 119 | false | false | false | ||||||||||
| 01a0b5e8-5537-7ba1-9539-eed73d87178d | MRNA | 2026-09-18 15:04 | call_vertical_spread | 2 | 1 | 2000 | 5624000.00 | long | ask | 154.5200 | 4.0500 | ["137","144"] | ["5.3530","3.3773"] | ["144"] | ["EDGO"] | 137.0000 | 144.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5e5-058f-74e1-8222-fe0214da9ef0 | MRNA | 2026-09-18 15:01 | call_vertical_spread | 2 | 1 | 1850 | 5468600.00 | short | bid | 154.3000 | 3.8500 | ["136","143"] | ["11.3267","6.5268"] | ["143"] | ["EDGO"] | 136.0000 | 143.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5e3-f41f-7321-9f58-4ac4096876a9 | MRNA | 2026-09-18 15:00 | call_vertical_spread | 2 | 1 | 1500 | 3891000.00 | short | bid | 154.2500 | 3.0500 | ["138","145"] | ["6.4222","4.0412"] | ["145"] | ["EDGO"] | 138.0000 | 145.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b4ce-9c20-7381-b1f2-ebe3e37ea2b4 | MRNA | 2026-09-18 09:57 | call_vertical_spread | 2 | 1 | 1000 | 786000.00 | short | bid | 156.0500 | 0.4800 | ["160","167.5"] | ["0.7708","0.8026"] | ["162.1"] | ["EDGO"] | 160.0000 | 167.5000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b0a4-e813-7cd2-aaa5-c51d84052937 | MRNA | 2026-09-17 14:33 | call_vertical_spread | 2 | 1 | 1500 | 1608000.00 | short | bid | 158.5500 | 1.0000 | ["160","167.5"] | ["0.7786","0.7955"] | ["162.64"] | ["EDGO"] | 160.0000 | 167.5000 | 8 | 8 | false | true | false | ||||||||||
| 01a0b067-4aa3-7f02-b7aa-5eeb7e21a7a7 | MRNA | 2026-09-17 13:25 | call_vertical_spread | 2 | 1 | 1000 | 1006000.00 | long | ask | 155.5200 | 1.5000 | ["157.5","165"] | ["0.7790","0.7948"] | ["160.06"] | ["EDGO"] | 157.5000 | 165.0000 | 8 | 8 | false | true | false | ||||||||||
| 01a0b032-5fc3-7822-91eb-e0d7b3b0db49 | MRNA | 2026-09-17 12:28 | call_vertical_spread | 2 | 1 | 850 | 911200.00 | unknown | — | 155.9750 | 1.9500 | ["157.5","165"] | ["0.7941","0.8122"] | [] | ["EDGO"] | 157.5000 | 165.0000 | 8 | 8 | false | true | false | true | false | ||||||||
| 01a0afa7-427b-7000-a10c-2994086feca6 | MRNA | 2026-09-17 09:56 | call_vertical_spread | 2 | 1 | 1000 | 1059000.00 | long | ask | 156.5850 | 2.0500 | ["157.5","165"] | ["0.7567","0.7769"] | ["160.17"] | ["EDGO"] | 157.5000 | 165.0000 | 8 | 8 | true | true | false | ||||||||||
| 01a0aade-19da-77d3-9540-6af44e792203 | MRNA | 2026-09-16 11:37 | call_vertical_spread | 2 | 1 | 45 | 151245.00 | long | ask | 146.3500 | 3.9000 | ["140","141"] | ["0.7359","0.7357"] | ["140.53"] | ["XCBO"] | 140.0000 | 141.0000 | 37 | 37 | false | false | false | ||||||||||
| 01a0aad0-94eb-7251-a707-3a9552fa8c3f | MRNA | 2026-09-16 11:23 | call_vertical_spread | 2 | 1 | 50 | 167000.00 | long | ask | 146.4800 | 4.9000 | ["141","142"] | ["0.7548","0.7545"] | ["141.52"] | ["XCBO"] | 141.0000 | 142.0000 | 37 | 37 | false | false | false | ||||||||||
| 01a0a6a1-fdc6-7bc3-a3ce-587d1de6075d | MRNA | 2026-09-15 15:53 | call_vertical_spread | 2 | 1 | 1800 | 398172.00 | long | ask | 142.8000 | 0.4500 | ["150","157.5"] | ["0.8066","0.8648"] | ["151.01"] | ["EDGO"] | 150.0000 | 157.5000 | 3 | 3 | false | true | false | ||||||||||
| 01a0a074-a658-7311-9375-b2dbecf99ef0 | MRNA | 2026-09-14 11:06 | call_vertical_spread | 2 | 1 | 11 | 112354.00 | unknown | — | 144.2542 | 5.5000 | ["90","95"] | ["2.7260","2.4585"] | [] | ["AMXO"] | 90.0000 | 95.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a091be-ac80-7623-90d3-aeec3f88c482 | MRNA | 2026-09-11 14:33 | call_vertical_spread | 2 | 1 | 600 | 763800.00 | short | bid | 148.2800 | 2.3500 | ["140","144"] | ["2.5698","1.5408"] | ["143.99"] | ["EDGO"] | 140.0000 | 144.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a091b7-4dc8-7363-b134-e5b91461341c | MRNA | 2026-09-11 14:25 | call_vertical_spread | 2 | 1 | 40 | 125120.00 | long | ask | 148.0500 | 4.9500 | ["146","147"] | ["0.7319","0.7325"] | ["146.46"] | ["XMIO"] | 146.0000 | 147.0000 | 42 | 42 | false | false | false | ||||||||||
| 01a090f0-d531-7a31-8d63-5bd55f8f21ac | MRNA | 2026-09-11 10:48 | call_vertical_spread | 2 | 1 | 1375 | 959750.00 | short | bid | 147.1900 | 0.4200 | ["150","157.5"] | ["0.7107","0.7388"] | ["152.18"] | ["EDGO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | ||||||||||
| 01a090e3-aa19-7730-a527-e686756136b5 | MRNA | 2026-09-11 10:33 | call_vertical_spread | 2 | 1 | 3000 | 1896000.00 | unknown | — | 146.2700 | 0.4900 | ["150","157.5"] | ["0.7106","0.7360"] | [] | ["EDGO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | true | false | ||||||||
| 01a08ce2-8881-7033-8154-115116761614 | MRNA | 2026-09-10 15:54 | call_vertical_spread | 2 | 1 | 218 | 211024.00 | long | ask | 136.5300 | 0.5300 | ["130","135"] | ["0.7441","0.7107"] | ["133.92"] | ["XMIO"] | 130.0000 | 135.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a08c76-9f80-70d3-a8ac-5178f5353ed5 | MRNA | 2026-09-10 13:56 | call_vertical_spread | 2 | 1 | 1500 | 940500.00 | short | bid | 135.3250 | 0.4500 | ["138","145"] | ["0.6587","0.6876"] | ["139.99"] | ["EDGO"] | 138.0000 | 145.0000 | 8 | 8 | true | true | false | ||||||||||
| 01a08749-d311-7502-8ee6-492aa607444b | MRNA | 2026-09-09 13:49 | call_vertical_spread | 2 | 1 | 13 | 149864.00 | short | bid | 137.8300 | 6.6000 | ["135","155"] | ["0.7017","0.7018"] | ["140.70"] | ["XCBO"] | 135.0000 | 155.0000 | 828 | 828 | false | false | false | ||||||||||
| 01a086bc-f491-7f80-b9c3-cf181008f06b | MRNA | 2026-09-09 11:15 | call_vertical_spread | 2 | 1 | 37 | 122988.00 | long | ask | 138.2900 | 6.7500 | ["134","135"] | ["0.7605","0.7613"] | ["134.48"] | ["XCBO"] | 134.0000 | 135.0000 | 44 | 44 | false | false | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:54:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:50:11Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:42:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:34:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:29:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:27:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:30:42Z"} |
| 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-18T19:28:53Z"} |
| 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-18T19:05:19Z"} |
| 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-18T19:01:25Z"} |
| 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-18T19:00:32Z"} |
| 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-18T13:57:16Z"} |
| 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-17T18:33:42Z"} |
| 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-17T17:26:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:28:32Z"} |
| 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-17T13:56:14Z"} |
| 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-16T15:38:29Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:23:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:53:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:06:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:33:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:25:43Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:48:24Z"} |
| 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-11T14:34:07Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:54:16Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:56:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:50:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:15:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |