core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rows| 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 |
|---|
| 01a0fe2b-f0bf-7b82-86f7-6615e783c6b2 | XLF | 2026-10-02 15:51 | put_calendar | 2 | 1 | 1600 | 176000.00 | unknown | bid | 53.4738 | 0.2500 | ["54"] | ["1.9172"] | [] | ["XBOX"] | 54.0000 | 54.0000 | 0 | 3 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-02T19:51:30Z"} | 2026-10-02 | 2026-10-02 17:15 | 2026-10-02 17:15 |
| 01a0f31c-07ff-7fb2-9913-4e358f07abed | XLF | 2026-09-30 12:18 | put_calendar | 2 | 1 | 6000 | 1284000.00 | short | bid | 53.7300 | 0.1100 | ["54"] | ["0.1664"] | [] | ["AMXO"] | 54.0000 | 54.0000 | 16 | 51 | false | false | true | false | |||||||||
| 01a0ede2-7dd7-7c30-8333-009753db506b | XLF | 2026-09-29 11:57 | put_calendar | 2 | 1 | 76 | 30704.00 | unknown | bid | 53.8051 | 0.0900 | ["54"] | ["0.1795"] | [] | ["MCRY"] | 54.0000 | 54.0000 | 108 | 171 | false | false | true | false | |||||||||
| 01a0d45d-e22e-7f50-96fa-24a77028413d | XLF | 2026-09-24 13:01 | put_calendar | 2 | 1 | 143 | 51337.00 | unknown | bid | 54.4300 | 0.2600 | ["54"] | ["0.1793"] | [] | ["XPHO"] | 54.0000 | 54.0000 | 113 | 176 | false | true | true | false | |||||||||
| 01a0c512-247f-7003-b68a-3b0007688c0b | XLF | 2026-09-21 13:44 | put_calendar | 2 | 1 | 199 | 63680.00 | unknown | bid | 55.9150 | 0.0600 | ["55"] | ["0.1737"] | [] | ["XPHO"] | 55.0000 | 55.0000 | 116 | 179 | false | true | true | false | |||||||||
| 01a0c511-806f-7cf3-94b1-a5460a2b7fd4 | XLF | 2026-09-21 13:44 | put_calendar | 2 | 1 | 166 | 53120.00 | unknown | bid | 55.9200 | 0.0800 | ["55"] | ["0.1739"] | [] | ["XCBO"] | 55.0000 | 55.0000 | 116 | 179 | false | true | true | false | |||||||||
| 01a0c466-09e7-7af1-9581-6d94cf5c0ed1 | XLF | 2026-09-21 10:36 | put_calendar | 2 | 1 | 178 | 57494.00 | unknown | bid | 55.8300 | 0.0700 | ["55"] | ["0.1726"] | [] | ["ARCO"] | 55.0000 | 55.0000 | 116 | 179 | false | true | true | false | |||||||||
| 01a0c464-ecbe-7db3-9eee-8d6cf3f2a239 | XLF | 2026-09-21 10:35 | put_calendar | 2 | 1 | 81 | 25920.00 | unknown | bid | 55.8600 | 0.1100 | ["55"] | ["0.1723"] | [] | ["AMXO"] | 55.0000 | 55.0000 | 116 | 179 | false | true | true | false | |||||||||
| 01a0b0c6-a0e3-7d91-bcf9-0fd7c80a7030 | XLF | 2026-09-17 15:09 | put_calendar | 2 | 1 | 130 | 53950.00 | short | bid | 55.9950 | 0.2600 | ["58"] | ["0.3640"] | [] | ["XMIO"] | 58.0000 | 58.0000 | 1 | 8 | false | false | true | false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:18:37Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:58:03Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:02:05Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:45:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:44:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:37:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:35:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:10:21Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |