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 | net_side |
|---|
| 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 |
|---|
| 01a08232-ad98-74a2-8bab-b49d6547ecdb | XLF | 2026-09-08 14:05 | call_calendar | 2 | 1 | 177 | 262668.00 | short | bid | 57.5300 | 0.8500 | ["51"] | ["0.3133"] | [] | ["XCBO"] | 51.0000 | 51.0000 | 10 | 192 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:06:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0a697-340e-7d10-9714-170b980ab3ea | XLF | 2026-09-15 15:41 | call_calendar | 2 | 1 | 25 | 27075.00 | long | bid | 56.8550 | 0.2000 | ["52"] | ["0.1826"] | [] | ["XCBO"] | 52.0000 | 52.0000 | 15 | 122 | false | false | true | false | |||||||||
| 01a0ab03-5133-77c0-8059-3e6bc636ef00 | XLF | 2026-09-16 12:18 | call_calendar | 2 | 1 | 78 | 55068.00 | unknown | — | 56.4800 | 0.2500 | ["56"] | ["0.1603"] | [] | ["AMXO"] | 56.0000 | 56.0000 | 184 | 196 | false | false | true | false | false | mlet | |||||||
| 01a0ab03-5ceb-7312-b3e8-402e0c3233a0 | XLF | 2026-09-16 12:18 | call_calendar | 2 | 2 | 140 | 99120.00 | short | ask | 56.4800 | 0.2500 | ["56"] | ["0.1610"] | [] | ["EDGO","XCBO"] | 56.0000 | 56.0000 | 184 | 196 | false | false | true | false | |||||||||
| 01a0ab03-5ceb-7312-b3e8-401eb1473f66 | XLF | 2026-09-16 12:18 | call_calendar | 2 | 5 | 347 | 245122.00 | short | ask | 56.4800 | 0.2500 | ["56"] | ["0.1605"] | [] | ["C2OX","EMLD","MCRY","XMIO","XPHO"] | 56.0000 | 56.0000 | 184 | 196 | false | false | true | false | |||||||||
| 01a0b082-48ca-7b42-a8ed-ffc061670995 | XLF | 2026-09-17 13:55 | call_calendar | 2 | 1 | 33 | 30558.00 | long | bid | 56.0399 | 0.2000 | ["52"] | ["0.1350"] | [] | ["XPHO"] | 52.0000 | 52.0000 | 13 | 120 | false | false | true | false | |||||||||
| 01a0b4c5-93a0-7ac0-805c-37c78351cdbe | XLF | 2026-09-18 09:47 | call_calendar | 2 | 1 | 92 | 368276.00 | short | ask | 55.6650 | 1.1500 | ["36"] | ["0.3443"] | [] | ["XCBO"] | 36.0000 | 36.0000 | 91 | 182 | false | false | true | false | |||||||||
| 01a0b4c5-93a0-7ac0-805c-37bb529df3ce | XLF | 2026-09-18 09:47 | call_calendar | 2 | 1 | 10 | 40060.00 | unknown | ask | 55.6650 | 2.8500 | ["36"] | ["0.4888"] | [] | ["XISX"] | 36.0000 | 36.0000 | 91 | 182 | false | false | true | false | |||||||||
| 01a0b4c8-6a30-7e61-93e7-85e1362ad98c | XLF | 2026-09-18 09:50 | call_calendar | 2 | 1 | 184 | 628360.00 | short | bid | 55.5900 | 0.6500 | ["39"] | ["0.2800"] | [] | ["XCBO"] | 39.0000 | 39.0000 | 91 | 182 | false | false | true | false | |||||||||
| 01a0b4c8-6a30-7e61-93e7-85d6c841bfde | XLF | 2026-09-18 09:50 | call_calendar | 2 | 1 | 21 | 71631.00 | short | bid | 55.5900 | 0.7500 | ["39"] | ["0.2800"] | [] | ["XISX"] | 39.0000 | 39.0000 | 91 | 182 | false | false | true | false | |||||||||
| 01a0c487-97bf-72c1-8205-01d25a49372b | XLF | 2026-09-21 11:13 | call_calendar | 2 | 2 | 79 | 27414.00 | short | bid | 55.8150 | 0.1400 | ["61"] | ["0.1561"] | [] | ["XCBO","XPHO"] | 61.0000 | 61.0000 | 179 | 361 | false | true | true | false | |||||||||
| 01a0c49e-6f67-7222-b3ad-991ea297e563 | XLF | 2026-09-21 11:38 | call_calendar | 2 | 2 | 80 | 27840.00 | unknown | bid | 55.8650 | 0.1600 | ["61"] | ["0.1554"] | [] | ["AMXO","XPHO"] | 61.0000 | 61.0000 | 179 | 361 | false | true | true | false | |||||||||
| 01a0c4d1-00b7-7d02-be56-06825b926931 | XLF | 2026-09-21 12:33 | call_calendar | 2 | 2 | 80 | 28080.00 | unknown | — | 55.9100 | 0.1400 | ["61"] | ["0.1554"] | [] | ["AMXO","XPHO"] | 61.0000 | 61.0000 | 179 | 361 | false | true | true | false | false | mlet |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:42:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:18:49Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:18:49Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:18:49Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:56:03Z"} |
| 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-18T13:47:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:47:37Z"} |
| 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-18T13:50:29Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:50:29Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:13:35Z"} |
| 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-21T15:38:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:33:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |