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 |
|---|
| 01a08bfe-5e58-7162-bd06-5d50f04ecf85 | PBR | 2026-09-10 11:44 | put_vertical_spread | 2 | 1 | 2500 | 232500.00 | short | bid | 21.4350 | 0.1600 | ["16","18"] | ["0.4950","0.4797"] | ["17.63"] | ["XPHO"] | 16.0000 | 18.0000 | 99 | 99 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:45:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091f2-b0e8-70d3-8e98-8b51914b913a | PBR | 2026-09-11 15:29 | call_vertical_spread | 2 | 1 | 900 | 248400.00 | short | bid | 21.0650 | 0.3300 | ["21","24"] | ["0.4901","0.4954"] | ["22.04"] | ["XBOX"] | 21.0000 | 24.0000 | 70 | 70 | false | false | false | true | |||||||||
| 01a0a59e-8fb6-7492-9a0d-46439f8f14b6 | PBR | 2026-09-15 11:10 | call_diagonal_spread | 2 | 1 | 10000 | 4510000.00 | short | ask | 21.6950 | 0.3100 | ["20","21"] | ["0.4905","0.4950"] | [] | ["SPHR"] | 20.0000 | 21.0000 | 31 | 66 | false | false | true | true | |||||||||
| 01a0a5d8-3d56-7a93-8a17-f2109449643f | PBR | 2026-09-15 12:13 | synthetic | 2 | 4 | 1102 | 562020.00 | short | ask | 21.7095 | 0.1400 | ["22"] | ["0.4168"] | ["21.71"] | ["ARCO","XBOX","XCBO","XPHO"] | 22.0000 | 22.0000 | 185 | 185 | false | false | false | false | |||||||||
| 01a0aa76-4f8b-7152-a35e-7a8a923e7069 | PBR | 2026-09-16 09:44 | call_diagonal_spread | 2 | 6 | 254 | 129418.00 | short | bid | 21.3000 | 0.3800 | ["19","20"] | ["1.1294","0.4532"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 19.0000 | 20.0000 | 2 | 93 | false | false | true | true | |||||||||
| 01a0aa76-4f8b-7152-a35e-7a761a0aaa3e | PBR | 2026-09-16 09:44 | call_diagonal_spread | 2 | 6 | 254 | 128024.00 | short | bid | 21.3000 | 0.3800 | ["19","20"] | ["1.1294","0.4461"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 19.0000 | 20.0000 | 2 | 93 | false | false | true | true | |||||||||
| 01a0aa76-4f8b-7152-a35e-7aa1e8943028 | PBR | 2026-09-16 09:44 | call_diagonal_spread | 2 | 6 | 208 | 105994.00 | short | bid | 21.3000 | 0.3800 | ["19","20"] | ["1.1303","0.4533"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 19.0000 | 20.0000 | 2 | 93 | false | false | true | true | |||||||||
| 01a0aa76-4f8b-7152-a35e-7a9e5eb0f933 | PBR | 2026-09-16 09:44 | call_diagonal_spread | 2 | 7 | 295 | 150205.00 | short | bid | 21.3000 | 0.3800 | ["19","20"] | ["1.1232","0.4527"] | [] | ["AMXO","EMLD","MCRY","XBOX","XISX","XMIO","XPHO"] | 19.0000 | 20.0000 | 2 | 93 | false | false | true | true | |||||||||
| 01a0aaaf-60eb-7cb0-b434-6b7e8d6c4eed | PBR | 2026-09-16 10:46 | strangle | 2 | 1 | 572 | 140712.00 | short | bid | 21.1000 | 0.0900 | ["20","25"] | ["0.4707","0.4243"] | ["17.54","27.46"] | ["ARCO"] | 20.0000 | 25.0000 | 121 | 121 | false | true | false | true | |||||||||
| 01a0b038-62d3-76a0-ba39-39979bf97b2e | PBR | 2026-09-17 12:34 | call_diagonal_spread | 2 | 3 | 550 | 117150.00 | short | bid | 20.9700 | 0.2260 | ["20","21"] | ["0.7178","0.4680"] | [] | ["XCBO"] | 20.0000 | 21.0000 | 1 | 29 | false | false | true | true | |||||||||
| 01a0b521-1567-7913-998c-8be1bf02f977 | PBR | 2026-09-18 11:27 | call_calendar | 2 | 1 | 424 | 253552.00 | short | bid | 20.8400 | 0.1700 | ["18"] | ["2.2499"] | [] | ["AMXO"] | 18.0000 | 18.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0c53b-7e6f-78b3-a69e-ca03291890b6 | PBR | 2026-09-21 14:30 | strangle | 2 | 1 | 1000 | 116000.00 | short | bid | 20.7750 | 0.1000 | ["15","23"] | ["0.4855","0.4321"] | ["13.84","24.16"] | ["ARCO"] | 15.0000 | 23.0000 | 88 | 88 | false | true | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:29:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:10:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:14:02Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:44:55Z"} |
| 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-16T13:44:55Z"} |
| 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-16T13:44:55Z"} |
| 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-16T13:44:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:47:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:34:46Z"} |
| 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-18T15:27:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:30:06Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |