core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0e981-ac26-76e0-9d79-ad5cef2fe3a5 | FRMI | 2026-09-28 15:33 | call_vertical_spread | 2 | 1 | 200 | 121200.00 | short | bid | 4.2550 | 0.3500 | ["1","1.5"] | ["7.8285","5.7296"] | ["1.5"] | ["XCBO"] | 1.0000 | 1.5000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T19:33:21Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d9df-fe77-7033-96f7-90598d870d36 | FRMI | 2026-09-25 14:42 | call_vertical_spread | 2 | 1 | 392 | 213248.00 | unknown | bid | 4.4800 | 0.5000 | ["1.5","2"] | ["74.2346","56.8720"] | ["4.47"] | ["XCBO"] | 1.5000 | 2.0000 | 0 | 0 | false | false | |||||||||||
| 01a0d9d0-990f-7c21-9909-c21dc4398b02 | FRMI | 2026-09-25 14:25 | call_vertical_spread | 2 | 1 | 391 | 258060.00 | unknown | — | 4.4950 | 0.6000 | ["1","1.5"] | ["5.0483","3.7349"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 14 | 14 | false | false | false | true | |||||||||
| 01a0d990-9e26-70a0-93e1-5332eafcd02f | FRMI | 2026-09-25 13:15 | call_vertical_spread | 2 | 1 | 248 | 162440.00 | long | ask | 4.5150 | 0.7000 | ["1","1.5"] | ["3.2076","2.8494"] | ["1.49"] | ["XISX"] | 1.0000 | 1.5000 | 14 | 14 | true | false | |||||||||||
| 01a0d98d-f28e-7060-98c3-cd26131901e1 | FRMI | 2026-09-25 13:12 | call_vertical_spread | 2 | 2 | 255 | 116702.00 | long | ask | 4.5250 | 0.3500 | ["2","2.5"] | ["2.8927","2.3078"] | ["2.50"] | ["XCBO","XISX"] | 2.0000 | 2.5000 | 7 | 7 | false | false | |||||||||||
| 01a0cfca-ec8f-74e1-888e-d74397ba5aa3 | FRMI | 2026-09-23 15:42 | call_vertical_spread | 2 | 1 | 263 | 165690.00 | unknown | — | 4.8550 | 0.6000 | ["1.5","2"] | ["4.6721","3.6084"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 9 | 9 | false | false | false | true | |||||||||
| 01a0b5fe-dad7-7450-9ac9-2fbd32913cdc | FRMI | 2026-09-18 15:29 | put_vertical_spread | 2 | 1 | 188 | 216388.00 | long | ask | 5.0050 | 0.5000 | ["10.5","11"] | ["45.7514","41.7355"] | ["10.51"] | ["XISX"] | 10.5000 | 11.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b5fd-5c07-7083-bb54-827ebaae5aa6 | FRMI | 2026-09-18 15:27 | put_vertical_spread | 2 | 1 | 241 | 277391.00 | long | ask | 5.0050 | 0.5000 | ["10.5","11"] | ["44.5855","40.6728"] | ["10.51"] | ["XISX"] | 10.5000 | 11.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b5fd-2940-7063-920c-8a0d4f192a07 | FRMI | 2026-09-18 15:27 | put_vertical_spread | 2 | 1 | 240 | 276240.00 | long | ask | 5.0050 | 0.5000 | ["10.5","11"] | ["44.4245","40.5260"] | ["10.51"] | ["XISX"] | 10.5000 | 11.0000 | 0 | 0 | true | false | |||||||||||
| 01a0b4db-2327-7342-8928-c275703c2db7 | FRMI | 2026-09-18 10:10 | put_calendar | 2 | 1 | 100 | 108801.00 | short | bid | 4.9450 | 0.5000 | ["10"] | ["1.2537"] | [] | ["XPHO"] | 10.0000 | 10.0000 | 63 | 272 | false | false | |||||||||||
| 01a0b0c1-0363-7892-8874-5d6e98f2d918 | FRMI | 2026-09-17 15:03 | put_vertical_spread | 2 | 1 | 240 | 415200.00 | unknown | — | 4.8720 | 0.6000 | ["13","14"] | ["3.3187","3.5241"] | [] | ["XCBO"] | 13.0000 | 14.0000 | 8 | 8 | false | false | false | true | |||||||||
| 01a0b0a4-d873-7d82-9dff-5888b93f85ca | FRMI | 2026-09-17 14:33 | call_vertical_spread | 2 | 1 | 248 | 178560.00 | unknown | — | 4.8501 | 0.6000 | ["1","1.5"] | ["9.0563","6.7830"] | [] | ["XCBO"] | 1.0000 | 1.5000 | 8 | 8 | false | false | false | true | |||||||||
| 01a0b0a4-578b-7f91-b157-85b664c016b4 | FRMI | 2026-09-17 14:32 | call_vertical_spread | 2 | 1 | 249 | 179529.00 | unknown | — | 4.8500 | 0.6000 | ["1","1.5"] | ["9.0581","3.7350"] | [] | ["XISX"] | 1.0000 | 1.5000 | 8 | 8 | true | false | false | true | |||||||||
| 01a0b0a3-849b-7ee0-a35f-411e1bb65f83 | FRMI | 2026-09-17 14:31 | put_vertical_spread | 2 | 1 | 240 | 413040.00 | unknown | — | 4.8560 | 0.5000 | ["13","14"] | ["4.5643","3.9776"] | [] | ["XISX"] | 13.0000 | 14.0000 | 8 | 8 | true | false | false | true | |||||||||
| 01a0b070-85eb-7072-814d-c52edc347ec0 | FRMI | 2026-09-17 13:35 | put_vertical_spread | 2 | 1 | 249 | 318720.00 | unknown | — | 4.9050 | 0.4000 | ["11","11.5"] | ["3.2228","3.3561"] | [] | ["XCBO"] | 11.0000 | 11.5000 | 8 | 8 | false | false | false | true | |||||||||
| 01a0b06f-64db-7f73-a46a-d4ab7e5872b7 | FRMI | 2026-09-17 13:34 | call_vertical_spread | 2 | 1 | 297 | 163350.00 | unknown | — | 4.8950 | 0.5000 | ["2","2.5"] | ["4.7750","3.7432"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 8 | 8 | false | false | false | true | |||||||||
| 01a0b064-414a-7883-b45f-d989a9ffec04 | FRMI | 2026-09-17 13:22 | put_vertical_spread | 2 | 1 | 248 | 315208.00 | unknown | — | 4.8950 | 0.5000 | ["11","11.5"] | ["2.5119","2.2759"] | [] | ["XISX"] | 11.0000 | 11.5000 | 8 | 8 | true | false | false | true | |||||||||
| 01a0b060-97cb-7133-ad21-5eaf992b67a0 | FRMI | 2026-09-17 13:18 | call_vertical_spread | 2 | 1 | 248 | 135160.00 | long | ask | 4.9000 | 0.6000 | ["2","2.5"] | ["4.2884","3.4688"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 8 | 8 | true | false | |||||||||||
| 01a0affe-9dc3-7610-9417-f0784ddc88ef | FRMI | 2026-09-17 11:31 | put_vertical_spread | 2 | 1 | 80 | 109600.00 | unknown | — | 4.9000 | 0.4000 | ["11.5","12"] | ["5.6461","5.9134"] | [] | ["XCBO"] | 11.5000 | 12.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0aff9-3adb-71d1-8809-c0379aac8e32 | FRMI | 2026-09-17 11:25 | put_vertical_spread | 2 | 1 | 80 | 109360.00 | long | ask | 4.9000 | 0.7000 | ["11.5","12"] | ["12.3001","10.7949"] | ["11.51"] | ["XCBO"] | 11.5000 | 12.0000 | 1 | 1 | false | false | |||||||||||
| 01a0aff7-e31b-7c00-8542-a94dd1408bd9 | FRMI | 2026-09-17 11:24 | put_vertical_spread | 2 | 1 | 88 | 120208.00 | long | ask | 4.9050 | 0.7000 | ["11.5","12"] | ["12.3677","10.8965"] | ["0","11.5"] | ["XCBO"] | 11.5000 | 12.0000 | 1 | 1 | false | false | |||||||||||
| 01a0aff7-b053-76b2-985b-23acdd81d65e | FRMI | 2026-09-17 11:23 | put_vertical_spread | 2 | 1 | 88 | 119768.00 | unknown | — | 4.9050 | 0.8000 | ["11.5","12"] | ["12.3677","10.8965"] | [] | ["XMIO"] | 11.5000 | 12.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a0a677-4c16-7d73-abd7-692362864501 | FRMI | 2026-09-15 15:07 | put_vertical_spread | 2 | 1 | 167 | 325650.00 | unknown | — | 4.7500 | 0.4000 | ["14","15"] | ["4.5489","4.8265"] | [] | ["XCBO"] | 14.0000 | 15.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a675-38d6-7903-a5ac-f58c0affcd8d | FRMI | 2026-09-15 15:04 | put_vertical_spread | 2 | 1 | 80 | 156880.00 | long | ask | 4.7650 | 0.6000 | ["14","15"] | ["6.8087","6.9531"] | ["14.01"] | ["XCBO"] | 14.0000 | 15.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a672-23c6-70d0-add3-7da4b90296c7 | FRMI | 2026-09-15 15:01 | put_vertical_spread | 2 | 1 | 88 | 172920.00 | long | ask | 4.7600 | 0.5000 | ["14","15"] | ["7.0477","7.2138"] | ["14.01"] | ["XMIO"] | 14.0000 | 15.0000 | 3 | 3 | true | false | |||||||||||
| 01a0920a-76d8-7bb2-84ff-f9847126e0c4 | FRMI | 2026-09-11 15:55 | put_vertical_spread | 2 | 1 | 200 | 190000.00 | unknown | — | 5.4750 | 0.8000 | ["10","10.5"] | ["171.0024","179.8901"] | [] | ["XCBO"] | 10.0000 | 10.5000 | 0 | 0 | false | false | false | true | |||||||||
| 01a091c4-26d8-7d03-9569-3e1cef70cb31 | FRMI | 2026-09-11 14:39 | put_vertical_spread | 2 | 1 | 222 | 352758.00 | unknown | — | 5.4950 | 0.7000 | ["13","14"] | ["42.6514","45.2464"] | [] | ["XISX"] | 13.0000 | 14.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a091c1-6ba0-7d53-aed8-9394d3a1a27d | FRMI | 2026-09-11 14:36 | put_vertical_spread | 2 | 1 | 220 | 208780.00 | unknown | — | 5.4950 | 0.5000 | ["10","10.5"] | ["32.3748","34.2113"] | [] | ["XISX"] | 10.0000 | 10.5000 | 0 | 0 | true | false | false | true | |||||||||
| 01a091be-0489-7c81-9960-38784962eed0 | FRMI | 2026-09-11 14:32 | put_vertical_spread | 2 | 1 | 122 | 152378.00 | unknown | — | 5.5250 | 0.5000 | ["11.5","12"] | ["28.4936","27.6274"] | [] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a091bd-7400-7932-9f8e-5301bd1fb23c | FRMI | 2026-09-11 14:31 | put_vertical_spread | 2 | 1 | 88 | 109912.00 | unknown | — | 5.5250 | 0.5000 | ["11.5","12"] | ["28.3940","27.5309"] | [] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a091bc-e378-7202-853c-7fec3b5c623f | FRMI | 2026-09-11 14:31 | put_vertical_spread | 2 | 1 | 88 | 109912.00 | unknown | — | 5.5350 | 0.5000 | ["11.5","12"] | ["29.8342","29.5167"] | [] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | true | false | false | true | |||||||||
| 01a06de6-6015-7ed3-ae48-08ccf9f622ad | FRMI | 2026-09-04 15:30 | call_vertical_spread | 2 | 1 | 400 | 276000.00 | unknown | — | 5.1450 | 0.8000 | ["1.5","2"] | ["105.6828","82.8164"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a06dc9-6235-7fd1-b326-ed63e75085c6 | FRMI | 2026-09-04 14:58 | call_vertical_spread | 2 | 1 | 188 | 119004.00 | long | ask | 5.0350 | 1.1500 | ["1.5","2"] | ["97.4840","76.4391"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 0 | 0 | false | false | |||||||||||
| 01a06dc8-f8bd-77f1-b481-4f92a42c289e | FRMI | 2026-09-04 14:58 | call_vertical_spread | 2 | 1 | 249 | 157617.00 | long | ask | 5.0350 | 1.1500 | ["1.5","2"] | ["97.1427","76.1715"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 0 | 0 | true | false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:42:11Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:25:37Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:15:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:12:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:43:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:29:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:28:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:28:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:03:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:33:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:31:45Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:36:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:35:21Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:23:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:18:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:32:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:25:53Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:14Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:14Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:07:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:05:38Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:02:08Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:55:54Z"} |
| 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-11T18:39:35Z"} |
| 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-11T18:36:28Z"} |
| 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-11T18:32:41Z"} |
| 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-11T18:31:57Z"} |
| 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-11T18:31:13Z"} |
| 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-04T19:30:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:59:01Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:58:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |