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 | directiontext |
|---|
| 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 |
|---|
| 01a0821d-b668-7833-b05e-45ff7aa800e0 | FOUR | 2026-09-08 13:42 | put_calendar | 2 | 1 | 15 | 103560.00 | long | bid | 42.1000 | 4.2000 | ["75"] | ["1.5966"] | [] | ["XCBO"] | 75.0000 | 75.0000 | 10 | 500 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:43:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08cdc-1bf8-7db2-b8e3-c8804a1288c7 | FOUR | 2026-09-10 15:47 | other | 3 | 1 | 350 | 1876900.00 | unknown | — | 42.9600 | 7.6000 | ["65","70","75"] | ["2.4572","1.7925","2.3400"] | [] | ["XPHO"] | 65.0000 | 75.0000 | 8 | 8 | true | false | false | true | false | mlft | |||||||
| 01a0aba8-b122-7400-bf43-5042e21d3fb9 | FOUR | 2026-09-16 15:19 | other | 4 | 1 | 140 | 735840.00 | unknown | — | 41.8300 | 9.8000 | ["55","65","70","75"] | ["2.1767","3.1753","3.5968","5.7971"] | [] | ["XBOX"] | 55.0000 | 75.0000 | 2 | 2 | false | false | false | true | false | mlft | |||||||
| 01a0b0a6-e3e3-7771-8301-75b701b5a5d1 | FOUR | 2026-09-17 14:35 | put_ladder | 3 | 1 | 294 | 925500.00 | unknown | — | 41.7250 | 5.7000 | ["50","55","70"] | ["2.1982","4.4277","6.2730"] | [] | ["XBOX"] | 50.0000 | 70.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0aa-7dc3-7023-a4ba-c9a37d4c5605 | FOUR | 2026-09-17 14:39 | put_ladder | 3 | 1 | 416 | 1312000.00 | unknown | — | 41.7150 | 5.7000 | ["50","55","70"] | ["2.1636","4.4100","6.2442"] | [] | ["XBOX"] | 50.0000 | 70.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b5e3-28ff-7890-a31c-2898902af883 | FOUR | 2026-09-18 14:59 | call_calendar | 2 | 1 | 50 | 220800.00 | unknown | ask | 39.8799 | 2.4000 | ["25"] | ["0.6409"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5ef-b7d7-7c91-a09e-fba32796df29 | FOUR | 2026-09-18 15:12 | call_calendar | 2 | 1 | 50 | 218200.00 | unknown | ask | 39.7050 | 1.8000 | ["25"] | ["0.6327"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f1-dab8-76e3-8cb7-a880dd0c2962 | FOUR | 2026-09-18 15:15 | call_calendar | 2 | 1 | 50 | 217750.00 | unknown | ask | 39.7150 | 2.9000 | ["25"] | ["0.6287"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f6-66c8-7673-b4b3-08f9794b1c7f | FOUR | 2026-09-18 15:20 | call_calendar | 2 | 1 | 50 | 163625.00 | unknown | ask | 39.7600 | 2.7000 | ["25"] | ["0.6260"] | [] | ["XPHO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f8-2fcf-7c33-9a78-f66a22773242 | FOUR | 2026-09-18 15:22 | call_calendar | 2 | 1 | 50 | 163625.00 | unknown | ask | 39.7900 | 2.6000 | ["25"] | ["0.6241"] | [] | ["AMXO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f8-f320-7a81-88f1-48c037f54b46 | FOUR | 2026-09-18 15:23 | call_calendar | 2 | 1 | 25 | 109000.00 | unknown | ask | 39.6950 | 2.7000 | ["25"] | ["0.6318"] | [] | ["AMXO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5fa-0877-7473-8d5e-1ce825bf90df | FOUR | 2026-09-18 15:24 | call_calendar | 2 | 1 | 50 | 163375.00 | unknown | ask | 39.6750 | 2.4000 | ["25"] | ["0.6290"] | [] | ["AMXO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5fa-a0cf-78f2-b404-178dae970c3b | FOUR | 2026-09-18 15:24 | call_calendar | 2 | 1 | 25 | 109000.00 | unknown | ask | 39.7200 | 2.5000 | ["25"] | ["0.6303"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0c43d-501f-7371-9fd9-8cdb2fc23da0 | FOUR | 2026-09-21 09:52 | other | 3 | 1 | 30 | 199050.00 | unknown | ask | 39.3400 | 7.0000 | ["20","22.5","25"] | ["0.6399","0.5970","0.6571"] | [] | ["XMIO"] | 20.0000 | 25.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0c466-adf7-7cd1-a06d-e25e8febb9f9 | FOUR | 2026-09-21 10:37 | other | 3 | 1 | 20 | 131720.00 | unknown | ask | 39.2300 | 4.0000 | ["20","22.5","25"] | ["0.6200","0.6428","0.6116"] | [] | ["XMIO"] | 20.0000 | 25.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0c467-b796-7ef2-9ab5-398b59d284f3 | FOUR | 2026-09-21 10:38 | other | 3 | 1 | 25 | 164550.00 | unknown | ask | 39.3000 | 4.0000 | ["20","22.5","25"] | ["0.6151","0.6344","0.6048"] | [] | ["XMIO"] | 20.0000 | 25.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0c480-40d7-7180-8da8-a511d33ff0a8 | FOUR | 2026-09-21 11:05 | call_diagonal_spread | 2 | 1 | 50 | 220750.00 | unknown | ask | 39.1700 | 3.1000 | ["22.5","25"] | ["0.6422","0.6365"] | [] | ["XMIO"] | 22.5000 | 25.0000 | 816 | 851 | false | false | true | ||||||||||
| 01a0c485-ceb7-7102-b4f1-8251ac1bbda6 | FOUR | 2026-09-21 11:11 | call_diagonal_spread | 2 | 1 | 41 | 178350.00 | unknown | — | 39.2450 | 2.6000 | ["22.5","25"] | ["0.6117","0.6053"] | [] | ["AMXO"] | 22.5000 | 25.0000 | 816 | 851 | false | false | true | true | false | ||||||||
| 01a0c4d5-793f-7b20-b38d-311084e2959c | FOUR | 2026-09-21 12:38 | straddle | 2 | 1 | 40 | 100000.00 | long | ask | 39.5950 | 1.7000 | ["20"] | ["0.7072"] | ["45.00"] | ["XCBO"] | 20.0000 | 20.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c4df-c9df-74a0-9ce7-34e46d056c03 | FOUR | 2026-09-21 12:49 | other | 3 | 1 | 50 | 115500.00 | unknown | bid | 39.6700 | 1.7000 | ["20","30","35"] | ["0.7731","0.7504","0.7669"] | [] | ["XMIO"] | 20.0000 | 35.0000 | 487 | 851 | false | true | true | true | |||||||||
| 01a0c9b5-46be-7731-9760-3fa7d2e2e8d5 | FOUR | 2026-09-22 11:21 | call_vertical_spread | 2 | 1 | 40 | 162400.00 | unknown | ask | 39.2400 | 4.2000 | ["25","30"] | ["0.6400","0.6437"] | ["47.80"] | ["AMXO"] | 25.0000 | 30.0000 | 815 | 815 | false | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:47:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:19:22Z"} |
| 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-17T18:35:42Z"} |
| 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-17T18:39:43Z"} |
| 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-18T18:59:36Z"} |
| 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-18T19:12:59Z"} |
| 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-18T19:15:21Z"} |
| 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-18T19:20:42Z"} |
| 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-18T19:22:42Z"} |
| 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-18T19:23:13Z"} |
| 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-18T19:24:15Z"} |
| 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-18T19:25:07Z"} |
| 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-21T13:52:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:37:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:38:57Z"} |
| 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-21T15:05:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:11:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:38:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:50:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:22:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |