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 |
|---|
| 01a0da13-37bf-7003-ac10-95eb113a6291 | IBM | 2026-09-25 15:38 | put_vertical_spread | 2 | 1 | 25 | 256150.00 | short | bid | 225.6714 | 7.1500 | ["275","280"] | ["0.3220","0.3593"] | ["0","275"] | ["XPHO"] | 275.0000 | 280.0000 | 21 | 21 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:38:17Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d4c7-b407-7731-84c4-c269abb0940f | IBM | 2026-09-24 14:57 | ratio_risk_reversal | 2 | 1 | 100 | 317801.00 | short | ask | 227.6300 | 3.1000 | ["220","325"] | ["0.4252","0.3644"] | ["219.32"] | ["EDGO"] | 220.0000 | 325.0000 | 484 | 484 | false | true | |||||||||||
| 01a0d3d6-530f-79d1-a080-0826783b1689 | IBM | 2026-09-24 10:33 | synthetic | 2 | 1 | 115 | 887800.00 | short | bid | 227.0700 | 6.3500 | ["220"] | ["0.3820"] | ["230.70"] | ["XBOX"] | 220.0000 | 220.0000 | 484 | 484 | false | false | |||||||||||
| 01a0cef3-31ff-75f0-8cfb-d778384730d5 | IBM | 2026-09-23 11:47 | put_condor | 4 | 2 | 96 | 406332.00 | short | bid | 236.2300 | 1.5500 | ["190","200","225","235"] | ["0.4082","0.4052","0.3979","0.3966"] | ["192.56","232.44"] | ["EDGO","XISX"] | 190.0000 | 235.0000 | 114 | 114 | false | true | |||||||||||
| 01a0cef3-31ff-75f0-8cfb-d7615f301f2b | IBM | 2026-09-23 11:47 | put_condor | 4 | 1 | 103 | 436308.00 | short | bid | 236.2300 | 1.7000 | ["190","200","225","235"] | ["0.4098","0.4053","0.3982","0.3961"] | ["192.56","232.44"] | ["EDGO"] | 190.0000 | 235.0000 | 114 | 114 | false | true | |||||||||||
| 01a0c433-c2cf-74a2-8289-b6f3c7920c11 | IBM | 2026-09-21 09:41 | straddle | 2 | 3 | 38 | 118845.00 | short | bid | 232.1400 | 2.6500 | ["230"] | ["0.4184"] | ["198.72","261.28"] | ["EDGO","XISX","XMIO"] | 230.0000 | 230.0000 | 60 | 60 | false | false | |||||||||||
| 01a0b56a-0547-7672-aed9-e0476ed612fd | IBM | 2026-09-18 12:46 | put_vertical_spread | 2 | 3 | 170 | 103360.00 | short | bid | 229.8050 | 2.0200 | ["230","235"] | ["0.4039","0.7345"] | ["230.54"] | ["EMLD","MCRY","XISX"] | 230.0000 | 235.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b4e2-5eb8-7192-96c7-6486e3caaabc | IBM | 2026-09-18 10:18 | call_calendar | 2 | 1 | 100 | 639500.00 | short | ask | 229.9200 | 2.5000 | ["200"] | ["1.9346"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 0 | 42 | false | false | |||||||||||
| 01a0b0ec-ca6b-78b3-90e7-c1e7c3b3d968 | IBM | 2026-09-17 15:51 | put_vertical_spread | 2 | 1 | 50 | 188100.00 | short | bid | 237.9700 | 2.6500 | ["220","230"] | ["0.4171","0.4135"] | ["225.80"] | ["SPHR"] | 220.0000 | 230.0000 | 183 | 183 | false | true | |||||||||||
| 01a0a6a6-4387-7073-8501-c56b50b451cb | IBM | 2026-09-15 15:58 | put_calendar | 2 | 3 | 120 | 195640.00 | short | bid | 248.1000 | 3.1500 | ["160"] | ["0.4427"] | [] | ["EDGO","XCBO","XISX"] | 160.0000 | 160.0000 | 458 | 493 | false | true | |||||||||||
| 01a0a6a6-4387-7073-8501-c557809c6067 | IBM | 2026-09-15 15:58 | put_calendar | 2 | 7 | 280 | 456880.00 | short | bid | 248.1000 | 3.1500 | ["160"] | ["0.4428"] | [] | ["AMXO","ARCO","C2OX","EMLD","MCRY","XMIO","XPHO"] | 160.0000 | 160.0000 | 458 | 493 | false | true | |||||||||||
| 01a0a5a3-e2fe-7722-b4b9-c384b32bd3be | IBM | 2026-09-15 11:16 | put_calendar | 2 | 2 | 82 | 205820.00 | short | ask | 248.9101 | 3.1000 | ["245"] | ["0.4517"] | [] | ["EDGO","XISX"] | 245.0000 | 245.0000 | 38 | 45 | true | true | |||||||||||
| 01a0a0d4-c3d0-78a0-9a20-1c0e4197ddb3 | IBM | 2026-09-14 12:51 | call_vertical_spread | 2 | 1 | 150 | 1222050.00 | short | bid | 250.8050 | 6.4000 | ["310","320"] | ["0.3417","0.3427"] | ["312.65"] | ["BATO"] | 310.0000 | 320.0000 | 858 | 858 | true | true | |||||||||||
| 01a0a09e-fa48-7761-9bfc-1e1a0f81cded | IBM | 2026-09-14 11:52 | call_vertical_spread | 2 | 2 | 190 | 115520.00 | short | bid | 248.6410 | 0.5466 | ["260","265"] | ["0.3509","0.3529"] | ["261.16"] | ["XMIO"] | 260.0000 | 265.0000 | 18 | 18 | false | true | |||||||||||
| 01a087ac-f9e0-7072-9c4a-79de23ca0761 | IBM | 2026-09-09 15:37 | call_vertical_spread | 2 | 1 | 250 | 105500.00 | short | bid | 241.0000 | 0.2400 | ["250","255"] | ["0.3905","0.4001"] | ["251"] | ["XCBO"] | 250.0000 | 255.0000 | 9 | 9 | false | true | |||||||||||
| 01a08797-0c98-7682-a499-7b25c23bfd3a | IBM | 2026-09-09 15:13 | call_vertical_spread | 2 | 1 | 30 | 192090.00 | short | bid | 238.6000 | 2.4500 | ["200","250"] | ["0.3724","0.3717"] | ["228.97"] | ["XMIO"] | 200.0000 | 250.0000 | 128 | 128 | false | false | |||||||||||
| 01a06d64-dfbd-71e0-b287-5ea91d200ddf | IBM | 2026-09-04 13:08 | straddle | 2 | 2 | 250 | 2150000.00 | short | bid | 235.3500 | 6.9000 | ["290"] | ["0.3827"] | ["204","376.00"] | ["AMXO"] | 290.0000 | 290.0000 | 378 | 378 | true | false |
| true |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:57:49Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:33:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:47:24Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:47:24Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:42:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:47:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:19:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:51:53Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:58:37Z"} |
| 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-15T19:58:37Z"} |
| 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-15T15:16:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:51:56Z"} |
| 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-14T15:53:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:37:53Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:14:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:08:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |