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 |
|---|
| 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 | 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 |
| 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 | |||||||||
| 01a0d4c2-60bf-7240-bdb3-3d090290f7de | FRMI | 2026-09-24 14:51 | put_butterfly_spread | 3 | 1 | 1086 | 281440.00 | unknown | ask | 4.5850 | 0.5500 | ["5.5","6","6.5"] | ["3.3975","3.6405","6.3429"] | ["4.51"] | ["XBOX"] | 5.5000 | 6.5000 | 1 | 1 | 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 01a0a5ec-e665-7420-ba0d-fedb82e07794 | FRMI | 2026-09-15 12:35 | other | 4 | 1 | 57 | 120555.00 | unknown | — | 4.7900 | 1.3500 | ["5","7","10","12"] | ["1.0247","1.0699","1.1031","1.1775"] | [] | ["C2OX"] | 5.0000 | 12.0000 | 822 | 857 | false | false | true | true | |||||||||
| 01a0a5ec-d6c6-79e1-9030-720d7c9b9679 | FRMI | 2026-09-15 12:35 | other | 4 | 4 | 107 | 226121.00 | unknown | — | 4.7900 | 1.3500 | ["5","7","10","12"] | ["1.0281","1.0659","1.1034","1.1716"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 5.0000 | 12.0000 | 822 | 857 | false | false | true | true | |||||||||
| 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 | |||||||||
| 01a08c30-8248-7af1-8dac-bb3a0fa43d1c | FRMI | 2026-09-10 12:39 | other | 2 | 3 | 762 | 180486.00 | unknown | — | 5.3950 | 0.2500 | ["6.5"] | ["1.7619"] | [] | ["EDGO","XCBO","XISX"] | 6.5000 | 6.5000 | 1 | 15 | false | false | true | false | |||||||||
| 01a0825f-3020-7833-81e6-9c63c3286bd8 | FRMI | 2026-09-08 14:54 | other | 4 | 1 | 69 | 103707.00 | unknown | — | 5.8800 | 1.1500 | ["7","7.5","12","22"] | ["1.0870","1.0535","1.1306","1.0557"] | [] | ["C2OX"] | 7.0000 | 22.0000 | 500 | 829 | false | false | true | 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 |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:52:12Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 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 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:36:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:36:48Z"} |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:39:50Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:55:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |