core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d907-51b6-7611-a78d-e7b669803791 | XOP | 2026-09-25 10:45 | call_butterfly_spread | 3 | 4 | 828 | 113076.00 | unknown | bid | 181.2100 | 1.1600 | ["195","210","225"] | ["0.3411","0.3773","0.4789"] | ["195.54","224.46"] | ["ARCO","C2OX","SPHR","XBOX"] | 195.0000 | 225.0000 | 21 | 21 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:45:38Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d4f2-decf-7951-9772-2583f1d7cd92 | XOP | 2026-09-24 15:44 | put_ratio_spread | 2 | 1 | 1000 | 2270000.00 | long | bid | 184.0900 | 3.1500 | ["120","165"] | ["0.3683","0.3537"] | ["148.90"] | ["AMXO"] | 120.0000 | 165.0000 | 813 | 813 | true | true | |||||||||||
| 01a0d4e7-1b17-7823-a129-9be6a49e6adf | XOP | 2026-09-24 15:31 | put_ratio_spread | 2 | 1 | 18265 | 6127675.00 | unknown | bid | 184.2200 | 0.8500 | ["175","185"] | ["0.3520","0.3285"] | ["171.46"] | ["XMIO"] | 175.0000 | 185.0000 | 22 | 22 | false | false | |||||||||||
| 01a0cab3-afa7-7e60-af7f-b7303770b7cf | XOP | 2026-09-22 15:59 | put_vertical_spread | 2 | 1 | 700 | 2317000.00 | short | bid | 181.5950 | 5.3500 | ["125","175"] | ["0.3661","0.3605"] | ["157.90"] | ["AMXO"] | 125.0000 | 175.0000 | 815 | 815 | true | true | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0aa87-a50b-73b0-b33a-a1bfa0bd7ec2 | XOP | 2026-09-16 10:03 | call_vertical_spread | 2 | 1 | 50 | 177800.00 | short | bid | 194.5700 | 3.6000 | ["185","190"] | ["0.3314","0.3332"] | ["187.80"] | ["XMIO"] | 185.0000 | 190.0000 | 93 | 93 | false | false | |||||||||||
| 01a0a689-bad6-7bc0-9b7d-dd981e5967c6 | XOP | 2026-09-15 15:27 | call_vertical_spread | 2 | 1 | 43 | 167485.00 | short | bid | 199.2300 | 4.9000 | ["220","250"] | ["0.2911","0.2971"] | ["228.50"] | ["ARCO"] | 220.0000 | 250.0000 | 493 | 493 | true | true | |||||||||||
| 01a0a056-3d31-7733-8cba-63a412d36130 | XOP | 2026-09-14 10:33 | call_calendar | 2 | 5 | 40 | 204608.00 | short | bid | 198.2400 | 6.1500 | ["245"] | ["0.2964"] | [] | ["AMXO","C2OX","EMLD","XMIO","XPHO"] | 245.0000 | 245.0000 | 823 | 858 | false | true | |||||||||||
| 01a0a055-8d68-7fb1-b435-47bb7df1ef8e | XOP | 2026-09-14 10:32 | call_calendar | 2 | 5 | 40 | 193280.00 | short | bid | 198.2100 | 5.7200 | ["250"] | ["0.2961"] | [] | ["ARCO","C2OX","EMLD","XMIO","XPHO"] | 250.0000 | 250.0000 | 823 | 858 | true | true | |||||||||||
| 01a0a054-7fe0-7a62-9caa-ef9978742119 | XOP | 2026-09-14 10:31 | call_calendar | 2 | 11 | 80 | 371274.00 | short | bid | 198.3300 | 5.4500 | ["255"] | ["0.2985"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 255.0000 | 255.0000 | 823 | 858 | true | true | |||||||||||
| 01a086a4-c529-7050-9525-98693945cbba | XOP | 2026-09-09 10:48 | call_diagonal_spread | 2 | 3 | 321 | 1686612.00 | long | bid | 194.2200 | 4.8000 | ["180","190"] | ["0.3178","0.3086"] | [] | ["BATO","C2OX","XCBO"] | 180.0000 | 190.0000 | 191 | 281 | false | false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:45:04Z"} |
| 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-24T19:32:08Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:59:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| true |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:03:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:27:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlet |
| 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 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:32:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:31:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| 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 |