core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 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 |
|---|
| 01a0f830-f327-7ed2-a1d1-eda9e551ef50 | SPOT | 2026-10-01 11:59 | other | 4 | 1 | 20 | 106240.00 | unknown | bid | 490.2700 | 14.6000 | ["495","500"] | ["0.4817","0.5188"] | [] | ["XISX"] | 495.0000 | 500.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T15:59:46Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f7ca-0b66-7b40-96ab-db3e723cd2dc | SPOT | 2026-10-01 10:06 | other | 4 | 1 | 25 | 152575.00 | unknown | ask | 488.2300 | 16.5400 | ["460","480","500"] | ["0.4831","0.4820","0.6649"] | [] | ["XPHO"] | 460.0000 | 500.0000 | 1 | 50 | false | false | |||||||||||
| 01a0e98c-e33f-7fd3-8f9f-6e69d32f782e | SPOT | 2026-09-28 15:45 | other | 4 | 3 | 6 | 101084.00 | unknown | bid | 500.2900 | 21.6500 | ["570","572.5","575","577.5"] | ["0.7500","0.7735","0.6520","0.6764"] | [] | ["EMLD","SPHR","XPHO"] | 570.0000 | 577.5000 | 4 | 4 | false | false | |||||||||||
| 01a0e87c-4a17-7941-96bd-d0089d800a8a | SPOT | 2026-09-28 10:47 | other | 4 | 1 | 20 | 220400.00 | unknown | bid | 501.1800 | 19.1000 | ["500","515"] | ["0.5459","0.5667"] | [] | ["ARCO"] | 500.0000 | 515.0000 | 25 | 32 | false | true | |||||||||||
| 01a0d3db-3cdf-7633-946f-0fdb1539009b | SPOT | 2026-09-24 10:39 | other | 4 | 1 | 40 | 404240.00 | unknown | bid | 511.9600 | 16.0250 | ["490","520"] | ["0.5353","0.5274"] | [] | ["ARCO"] | 490.0000 | 520.0000 | 29 | 36 | false | true | |||||||||||
| 01a0b5df-c9b7-7613-bab3-02d89580a64d | SPOT | 2026-09-18 14:55 | other | 4 | 1 | 30 | 103770.00 | unknown | ask | 515.6550 | 10.2100 | ["515","517.5"] | ["0.6481","0.7810"] | [] | ["XMIO"] | 515.0000 | 517.5000 | 0 | 14 | false | false | |||||||||||
| 01a0b5b9-426f-7e31-99ab-bd2cab47e61f | SPOT | 2026-09-18 14:13 | other | 4 | 2 | 30 | 153120.00 | unknown | — | 515.2700 | 13.3683 | ["515","520","522.5"] | ["0.3690","0.4283","1.1061"] | [] | ["XMIO"] | 515.0000 | 522.5000 | 0 | 21 | false | false | true | true | |||||||||
| 01a0b02d-aca3-7a60-8ce6-af884a1dca23 | SPOT | 2026-09-17 12:22 | other | 2 | 4 | 4 | 194640.00 | unknown | — | 533.8100 | 10.4500 | ["540","1000"] | ["0.3852","0.6226"] | [] | ["BATO","C2OX","EMLD","SPHR"] | 540.0000 | 1000.0000 | 29 | 491 | false | false | true | true | |||||||||
| 01a0a58c-7eb6-75e0-9e4e-e97909da44e4 | SPOT | 2026-09-15 10:50 | other | 4 | 1 | 700 | 2725812.00 | unknown | — | 553.3600 | 6.5800 | ["540","580","630"] | ["0.5041","0.4392","0.3766"] | [] | ["XMIO"] | 540.0000 | 630.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a58b-07b6-7871-8b4c-3253a63324f6 | SPOT | 2026-09-15 10:49 | other | 4 | 3 | 40 | 156880.00 | unknown | — | 554.1975 | 6.1800 | ["540","580","630"] | ["0.4841","0.4291","0.3753"] | [] | ["C2OX"] | 540.0000 | 630.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a58b-07b6-7871-8b4c-324a31ce1236 | SPOT | 2026-09-15 10:49 | other | 4 | 3 | 60 | 235320.00 | unknown | — | 554.1975 | 6.1800 | ["540","580","630"] | ["0.4841","0.4291","0.3753"] | [] | ["C2OX"] | 540.0000 | 630.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a58a-966e-72f0-a732-619a4ffc9ded | SPOT | 2026-09-15 10:48 | other | 4 | 1 | 100 | 391600.00 | unknown | — | 554.2400 | 6.2800 | ["540","580","630"] | ["0.4804","0.4284","0.3752"] | [] | ["EDGO"] | 540.0000 | 630.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a05e-18e8-7bb1-8758-f8bfb57debb7 | SPOT | 2026-09-14 10:41 | other | 2 | 2 | 14 | 589120.00 | unknown | — | 545.7700 | 9.0000 | ["340"] | ["1.3980"] | [] | ["XCBO","XISX"] | 340.0000 | 340.0000 | 4 | 123 | false | false | true | false | false | ||||||||
| 01a091e5-7630-7d70-a969-804b4b4b8fe9 | SPOT | 2026-09-11 15:15 | other | 3 | 1 | 47 | 1744720.00 | unknown | — | 526.3300 | 20.4000 | ["690","720","760"] | ["1.4508","1.6125","1.8121"] | [] | ["XBOX"] | 690.0000 | 760.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a08ce1-2508-7951-a363-33791379c652 | SPOT | 2026-09-10 15:52 | other | 3 | 1 | 74 | 2924216.00 | unknown | — | 521.5250 | 16.2500 | ["690","720","760"] | ["1.1959","0.7649","0.9980"] | [] | ["XPHO"] | 690.0000 | 760.0000 | 8 | 8 | false | false | false | true | |||||||||
| 01a08c9a-9e58-7181-8de7-1ceb9b58d008 | SPOT | 2026-09-10 14:35 | other | 4 | 1 | 100 | 3781750.00 | unknown | — | 521.8200 | 26.0500 | ["690","720","740","760"] | ["1.1630","1.3056","1.4415","1.6696"] | [] | ["XBOX"] | 690.0000 | 760.0000 | 8 | 8 | true | false | false | true | |||||||||
| 01a08c94-8ba8-74a2-aece-58894bfe1bc3 | SPOT | 2026-09-10 14:28 | other | 2 | 2 | 100 | 550000.00 | unknown | — | 522.1150 | 7.2500 | ["390","430"] | ["0.4754","0.4650"] | [] | ["AMXO"] | 390.0000 | 430.0000 | 280 | 498 | false | true | true | true | |||||||||
| 01a08ba0-34e0-7e92-986c-d36b1f04dd26 | SPOT | 2026-09-10 10:02 | other | 3 | 1 | 60 | 182820.00 | unknown | — | 523.9500 | 4.8000 | ["480","520","570"] | ["0.4103","0.3908","0.3762"] | [] | ["EDGO"] | 480.0000 | 570.0000 | 36 | 36 | false | true | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:06:54Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:45:39Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:47:49Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:39:39Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:56:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:13:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:23:09Z"} |
| 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-15T14:51:00Z"} |
| 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-15T14:49:17Z"} |
| 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-15T14:49:17Z"} |
| 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-15T14:48: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-14T14:41:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:15:51Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:52:53Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:36:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:29:15Z"} |
| 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-10T14:02:13Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |