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 | 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 |
|---|
| 01a0c96f-ae57-77b3-aa14-ba52af91981f | XOP | 2026-09-22 10:05 | put_vertical_spread | 2 | 3 | 93 | 109957.00 | unknown | bid | 182.7200 | 0.8800 | ["170","190"] | ["0.3455","0.3209"] | ["178.18"] | ["AMXO","XCBO","XISX"] | 170.0000 | 190.0000 | 24 | 24 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:05:39Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b58e-3eb7-76f3-b71f-976781dfa383 | XOP | 2026-09-18 13:26 | put_vertical_spread | 2 | 1 | 500 | 1005000.00 | unknown | bid | 191.0500 | 2.5500 | ["125","175"] | ["0.3543","0.3430"] | ["154.90"] | ["XBOX"] | 125.0000 | 175.0000 | 490 | 490 | false | true | false | ||||||||||
| 01a0b0c3-6c93-7323-bd66-ef7c171784d0 | XOP | 2026-09-17 15:06 | call_vertical_spread | 2 | 1 | 48 | 239472.00 | unknown | — | 192.8100 | 3.0000 | ["165","170"] | ["1.8302","1.5419"] | [] | ["MCRY"] | 165.0000 | 170.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b059-834b-7901-b969-b4d3201021c0 | XOP | 2026-09-17 13:10 | call_vertical_spread | 2 | 1 | 33 | 162492.00 | unknown | — | 192.3900 | 2.3000 | ["165","170"] | ["1.7246","1.4457"] | [] | ["XCBO"] | 165.0000 | 170.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0a614-5bf6-7c52-8acd-20640fd47502 | XOP | 2026-09-15 13:19 | call_ratio_spread | 2 | 1 | 2500 | 816000.00 | unknown | — | 199.6200 | 0.7400 | ["200","205"] | ["0.4007","0.4118"] | [] | ["ARCO"] | 200.0000 | 205.0000 | 3 | 3 | false | true | false | true | false | ||||||||
| 01a0a056-3561-7fb1-af81-93fb26ae0f7e | XOP | 2026-09-14 10:33 | other | 2 | 6 | 40 | 204088.00 | unknown | — | 198.2400 | 6.3300 | ["245"] | ["0.2959"] | [] | ["AMXO","C2OX","EMLD","XMIO","XPHO"] | 245.0000 | 245.0000 | 823 | 858 | true | true | true | false | false | ||||||||
| 01a090d8-9240-7a60-b359-1c14988c71a8 | XOP | 2026-09-11 10:21 | call_vertical_spread | 2 | 1 | 56 | 112896.00 | unknown | — | 195.9500 | 3.1000 | ["185","190"] | ["0.4462","0.3997"] | [] | ["XPHO"] | 185.0000 | 190.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a08caf-e790-7113-a672-9cea45aaa532 | XOP | 2026-09-10 14:58 | call_vertical_spread | 2 | 1 | 23 | 133998.00 | unknown | — | 196.5500 | 5.9000 | ["225","230"] | ["0.2795","0.2798"] | [] | ["XMIO"] | 225.0000 | 230.0000 | 827 | 827 | false | true | false | true | false | ||||||||
| 01a086a4-c529-7050-9525-9851d523d029 | XOP | 2026-09-09 10:48 | other | 2 | 2 | 164 | 878860.00 | unknown | — | 194.2200 | 4.8043 | ["180","190"] | ["0.3287","0.3166"] | [] | ["XBOX","XPHO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | true | true | false | mlet | |||||||
| 01a086a4-c529-7050-9525-983936b838a9 | XOP | 2026-09-09 10:48 | other | 2 | 5 | 236 | 1234430.00 | unknown | — | 194.2200 | 5.0000 | ["180","190"] | ["0.3156","0.3066"] | [] | ["EMLD","SPHR","XBOX","XPHO"] | 180.0000 | 190.0000 | 191 | 281 | false | false | true | true | false | ||||||||
| 01a081d4-f181-7e82-8713-36bdc8af3044 | XOP | 2026-09-08 12:23 | call_condor | 4 | 3 | 10 | 139840.00 | unknown | — | 193.9600 | 13.7000 | ["190","205","210","220"] | ["0.2659","0.2706","0.2767","0.2765"] | [] | ["AMXO"] | 190.0000 | 220.0000 | 829 | 829 | false | false | false | true | false | ||||||||
| 01a08185-d780-7f53-a194-f98d496aebf6 | XOP | 2026-09-08 10:57 | other | 2 | 1 | 5000 | 3367500.00 | unknown | — | 194.5550 | 1.9200 | ["165","185"] | ["0.3376","0.3312"] | [] | ["ARCO"] | 165.0000 | 185.0000 | 101 | 101 | false | true | false | true | false | mlct | |||||||
| 01a08181-e7b1-72b1-afbe-9246c7d429eb | XOP | 2026-09-08 10:52 | call_vertical_spread | 2 | 6 | 12 | 101970.00 | unknown | — | 194.5451 | 3.1833 | ["150","155"] | ["0.8940","0.7972"] | [] | ["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"] | 150.0000 | 155.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0813b-f958-7353-bc21-b4a4c42890e8 | XOP | 2026-09-08 09:36 | call_vertical_spread | 2 | 1 | 17 | 145928.00 | unknown | — | 195.1500 | 1.5000 | ["150","155"] | ["0.7389","0.6536"] | [] | ["EDGO"] | 150.0000 | 155.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0813b-eda1-7c40-a947-e834abcd6942 | XOP | 2026-09-08 09:36 | call_vertical_spread | 2 | 3 | 12 | 102958.00 | unknown | — | 195.1500 | 1.0000 | ["150","155"] | ["0.7186","0.6345"] | [] | ["BATO","C2OX","EDGO"] | 150.0000 | 155.0000 | 10 | 10 | false | false | false | true | false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:26:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:06:31Z"} |
| 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-17T17:11:24Z"} |
| 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-15T17:19:56Z"} |
| 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:33:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:22:03Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:59:46Z"} |
| 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-09T14:49:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:49:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:24:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:57:23Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:52:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:36:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:36:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |