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 |
|---|
| 01a0ca80-f35f-7af0-9f79-1eb6d82fe3ce | LRCX | 2026-09-22 15:04 | call_vertical_spread | 2 | 1 | 90 | 243450.00 | short | bid | 308.0250 | 2.1000 | ["310","330"] | ["0.5630","0.5698"] | ["317.31"] | ["XMIO"] | 310.0000 | 330.0000 | 24 | 24 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:04:45Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca58-58d7-7883-bf62-965b59e7ea87 | LRCX | 2026-09-22 14:19 | call_vertical_spread | 2 | 1 | 2074 | 12427570.00 | long | ask | 308.7550 | 4.6500 | ["275","282.5"] | ["0.9560","0.3292"] | ["282.22"] | ["AMXO"] | 275.0000 | 282.5000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c977-d05e-7452-bbf4-ba1b43d3b1e1 | LRCX | 2026-09-22 10:14 | call_vertical_spread | 2 | 1 | 45 | 231660.00 | short | bid | 305.5450 | 2.7000 | ["300","340"] | ["0.6103","0.6152"] | ["315.28"] | ["XCBO"] | 300.0000 | 340.0000 | 59 | 59 | false | false | false | ||||||||||
| 01a0c959-dc67-78b0-a20c-74845cbc2424 | LRCX | 2026-09-22 09:41 | call_vertical_spread | 2 | 1 | 49 | 101097.00 | short | bid | 301.4950 | 2.1500 | ["292.5","300"] | ["0.6656","0.6635"] | ["297.05"] | ["XCBO"] | 292.5000 | 300.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c57b-bbbf-7ed1-a410-7d86a287f0c3 | LRCX | 2026-09-21 15:40 | call_vertical_spread | 2 | 1 | 20 | 107620.00 | long | ask | 305.5800 | 0.8000 | ["300","340"] | ["0.6291","0.6334"] | ["315.33"] | ["XCBO"] | 300.0000 | 340.0000 | 60 | 60 | false | false | false | ||||||||||
| 01a0c573-4b97-7fa2-840b-75c1c0775ab0 | LRCX | 2026-09-21 15:31 | call_vertical_spread | 2 | 1 | 2074 | 2069852.00 | short | bid | 303.9400 | 0.6000 | ["307.5","315"] | ["0.6146","0.6223"] | ["310.02"] | ["XPHO"] | 307.5000 | 315.0000 | 4 | 4 | true | true | false | ||||||||||
| 01a0c551-2d37-7681-a7ab-426d52e485ad | LRCX | 2026-09-21 14:53 | call_vertical_spread | 2 | 1 | 50 | 183250.00 | long | ask | 302.3500 | 1.8000 | ["282.5","290"] | ["0.6056","0.6085"] | ["288.45"] | ["XMIO"] | 282.5000 | 290.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0b598-aaaf-78a3-8f24-e9a9f18fcbbc | LRCX | 2026-09-18 13:37 | call_vertical_spread | 2 | 1 | 33 | 195756.00 | short | bid | 282.7200 | 2.3500 | ["280","310"] | ["0.5885","0.5885"] | ["291.88"] | ["XCBO"] | 280.0000 | 310.0000 | 91 | 91 | false | false | false | ||||||||||
| 01a0b4bc-9abf-7422-b3ef-663334b7cc10 | LRCX | 2026-09-18 09:37 | call_vertical_spread | 2 | 1 | 10 | 130360.00 | short | bid | 277.3200 | 5.2500 | ["200","240"] | ["0.6019","0.5863"] | ["232.04"] | ["XCBO"] | 200.0000 | 240.0000 | 63 | 63 | false | false | false | ||||||||||
| 01a0b0c9-350b-7cf0-9df7-5cf33f33d5e0 | LRCX | 2026-09-17 15:12 | call_vertical_spread | 2 | 1 | 3 | 103290.00 | unknown | — | 269.8600 | 6.4000 | ["95","100"] | ["11.2301","10.7206"] | [] | ["XCBO"] | 95.0000 | 100.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b049-81a3-7190-8348-11025e929120 | LRCX | 2026-09-17 12:53 | call_vertical_spread | 2 | 1 | 27 | 592002.00 | long | ask | 267.7600 | 6.0500 | ["100","400"] | ["0.6535","0.6003"] | ["234.86"] | ["XCBO"] | 100.0000 | 400.0000 | 491 | 491 | false | false | false | ||||||||||
| 01a0b01b-5d23-7bf2-b9ad-dc571e939b55 | LRCX | 2026-09-17 12:02 | call_vertical_spread | 2 | 1 | 375 | 1254000.00 | long | ask | 268.5450 | 0.8500 | ["320","340"] | ["0.5725","0.5754"] | ["324.30"] | ["XCBO"] | 320.0000 | 340.0000 | 120 | 120 | false | true | false | ||||||||||
| 01a0ab31-4ea3-7c51-805d-60eb225393f8 | LRCX | 2026-09-16 13:08 | call_vertical_spread | 2 | 1 | 9 | 322641.00 | short | bid | 271.4000 | 7.3000 | ["90","95"] | ["6.6390","6.3552"] | ["94.99"] | ["XCBO"] | 90.0000 | 95.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0ab1d-0f0b-7f41-83da-cca6f4e87b09 | LRCX | 2026-09-16 12:46 | call_vertical_spread | 2 | 1 | 9 | 314145.00 | short | bid | 272.0450 | 4.0500 | ["95","100"] | ["7.4542","7.2408"] | ["99.99"] | ["XCBO"] | 95.0000 | 100.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0ab0f-91ea-7670-b981-de0d72ba90e9 | LRCX | 2026-09-16 12:31 | call_vertical_spread | 2 | 1 | 3 | 113973.00 | long | ask | 271.9800 | 6.8000 | ["80","85"] | ["7.6790","7.3374"] | ["84.99"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0aaa5-6253-7da2-891e-93e605e1149a | LRCX | 2026-09-16 10:35 | call_vertical_spread | 2 | 1 | 3 | 132327.00 | unknown | — | 272.8050 | 7.6000 | ["50","55"] | ["9.6107","9.1200"] | [] | ["XCBO"] | 50.0000 | 55.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0aa9b-8acb-7241-9fa4-67b53355120d | LRCX | 2026-09-16 10:25 | call_vertical_spread | 2 | 1 | 4 | 172924.00 | long | ask | 273.5200 | 7.8000 | ["55","60"] | ["8.4315","8.0461"] | ["59.99"] | ["XCBO"] | 55.0000 | 60.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0a5e3-1e7e-7bd1-b431-fb5e59b6e326 | LRCX | 2026-09-15 12:25 | call_vertical_spread | 2 | 1 | 3 | 113529.00 | long | ask | 266.5500 | 6.1500 | ["75","80"] | ["5.5766","5.3401"] | ["79.99"] | ["XCBO"] | 75.0000 | 80.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a575-9386-74d2-810f-07218e2a068f | LRCX | 2026-09-15 10:25 | call_vertical_spread | 2 | 1 | 50 | 1036594.00 | unknown | — | 269.8600 | 5.8500 | ["170","175"] | ["0.6509","0.6457"] | [] | ["XCBO"] | 170.0000 | 175.0000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0a0dc-7c61-76a2-b750-2a0f2869e675 | LRCX | 2026-09-14 12:59 | call_vertical_spread | 2 | 1 | 27 | 257499.00 | unknown | — | 276.9050 | 3.9000 | ["240","250"] | ["0.6238","0.6203"] | [] | ["XCBO"] | 240.0000 | 250.0000 | 67 | 67 | false | false | false | true | false | ||||||||
| 01a0a09d-48b0-72b0-85c9-beeb782c4e57 | LRCX | 2026-09-14 11:50 | call_vertical_spread | 2 | 1 | 5 | 224785.00 | short | bid | 277.0550 | 7.4000 | ["50","55"] | ["6.7641","6.4203"] | ["54.99"] | ["XCBO"] | 50.0000 | 55.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a091a6-84e8-78f1-bc6f-178483a30ecb | LRCX | 2026-09-11 14:06 | call_vertical_spread | 2 | 1 | 30 | 340110.00 | long | ask | 301.4500 | 6.3000 | ["240","250"] | ["0.4109","0.6076"] | ["249.89"] | ["XCBO"] | 240.0000 | 250.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a08c0c-c5d8-7701-a378-e1297a180930 | LRCX | 2026-09-10 12:00 | call_vertical_spread | 2 | 1 | 500 | 3898500.00 | long | ask | 303.0050 | 5.4500 | ["270","280"] | ["0.5938","0.5891"] | ["276.85"] | ["XMIO"] | 270.0000 | 280.0000 | 36 | 36 | true | false | false | ||||||||||
| 01a08bf7-d678-77e3-8560-2df91aaf15f1 | LRCX | 2026-09-10 11:37 | call_vertical_spread | 2 | 1 | 2026 | 6695930.00 | long | ask | 304.6350 | 2.6500 | ["285","292.5"] | ["0.8024","0.7547"] | ["291.87"] | ["XCBO"] | 285.0000 | 292.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a08222-bf78-7d20-8b87-7e96e2e95713 | LRCX | 2026-09-08 13:48 | call_vertical_spread | 2 | 1 | 10 | 122900.00 | short | bid | 320.0700 | 6.4500 | ["260","270"] | ["0.6280","0.6222"] | ["268.14"] | ["XCBO"] | 260.0000 | 270.0000 | 38 | 38 | false | false | false | ||||||||||
| 01a0820a-fd70-7b82-a7ac-b7bfeae85bfa | LRCX | 2026-09-08 13:22 | call_vertical_spread | 2 | 1 | 2026 | 2593604.00 | unknown | — | 320.6800 | 2.1500 | ["335","345"] | ["0.6270","0.6344"] | [] | ["XPHO"] | 335.0000 | 345.0000 | 10 | 10 | true | true | false | true | false | ||||||||
| 01a081bb-4f01-7082-94fe-9b016ebc3c0f | LRCX | 2026-09-08 11:55 | call_vertical_spread | 2 | 1 | 4 | 130284.00 | long | ask | 319.9875 | 7.2000 | ["155","160"] | ["3.5761","3.4449"] | ["159.99"] | ["XCBO"] | 155.0000 | 160.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a081b8-eda0-7270-96f6-e127d83263ab | LRCX | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 3 | 100773.00 | short | bid | 320.0600 | 6.9500 | ["150","155"] | ["3.7701","3.6324"] | ["154.99"] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 3 | false | false | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:01Z"} |
| 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:14:33Z"} |
| 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-22T13:41:56Z"} |
| 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:40:19Z"} |
| 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-21T19:31:13Z"} |
| 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-21T18:54:01Z"} |
| 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-18T17:38:04Z"} |
| 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:37:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:13:24Z"} |
| 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-17T16:53:27Z"} |
| 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-17T16:03:29Z"} |
| 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-16T17:09:01Z"} |
| 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-16T16:46:51Z"} |
| 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-16T16:32:09Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:36:16Z"} |
| 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-16T14:25:37Z"} |
| 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-15T16:25:47Z"} |
| 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-15T14:25:54Z"} |
| 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-14T17:00:24Z"} |
| 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-14T15:51:28Z"} |
| 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:07: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-10T16:00:56Z"} |
| 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-10T15:37:56Z"} |
| 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-08T17:48:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:23:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:55:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:52:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |