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 |
|---|
| 01a0da14-58cf-7ca0-9b23-817942663689 | IBM | 2026-09-25 15:39 | other | 4 | 1 | 100 | 104200.00 | unknown | bid | 225.7750 | 1.7100 | ["222.5","225","227.5"] | ["0.3090","0.4209","1.7852"] | [] | ["XPHO"] | 222.5000 | 227.5000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:39:37Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 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 | |||||||||||
| 01a0d4c1-8217-7262-af5e-a20f146f78fe | IBM | 2026-09-24 14:50 | other | 8 | 1 | 293 | 3278220.00 | unknown | bid | 227.6100 | 15.8000 | ["242.5","247.5","250","252.5","275","280","290","325"] | ["0.9823","1.4341","1.5880","1.7778","0.5888","0.6200","0.7475","1.0127"] | [] | ["XBOX"] | 242.5000 | 325.0000 | 1 | 22 | false | ||||||||||||
| 01a0d423-7526-7b73-ae9b-941464819c03 | IBM | 2026-09-24 11:58 | put_vertical_spread | 2 | 1 | 10 | 150930.00 | unknown | bid | 227.1100 | 5.1000 | ["300","305"] | ["2.3043","2.3941"] | ["227.04"] | ["XCBO"] | 300.0000 | 305.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d3e0-6147-7b32-b953-c80fc5e644f9 | IBM | 2026-09-24 10:44 | put_diagonal_spread | 2 | 1 | 7 | 109116.00 | long | bid | 227.0100 | 5.4000 | ["300","305"] | ["0.4713","0.5671"] | [] | ["XCBO"] | 300.0000 | 305.0000 | 57 | 176 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0b5c0-37b0-72e2-8db1-ec16b413241f | IBM | 2026-09-18 14:21 | other | 2 | 3 | 18 | 161910.00 | unknown | bid | 230.7100 | 2.3556 | ["225","300"] | ["0.3857","0.5015"] | [] | ["AMXO","EMLD","XBOX"] | 225.0000 | 300.0000 | 63 | 91 | 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 | |||||||||||
| 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 | |||||||||||
| 01a0a174-0170-7cd1-b514-6a820ddb2bea | IBM | 2026-09-14 15:45 | call_calendar | 2 | 1 | 50 | 193500.00 | long | bid | 249.8500 | 1.7000 | ["240"] | ["0.3649"] | [] | ["XMIO"] | 240.0000 | 240.0000 | 32 | 67 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0a045-c658-7db0-aa6a-27ee4dda9fa9 | IBM | 2026-09-14 10:15 | call_diagonal_spread | 2 | 2 | 15 | 103230.00 | long | bid | 244.8800 | 3.6000 | ["200","225"] | ["1.4568","0.4053"] | [] | ["BATO"] | 200.0000 | 225.0000 | 4 | 32 | false | false | |||||||||||
| 01a0a041-49e8-7bf2-bbab-ae436511d648 | IBM | 2026-09-14 10:10 | put_diagonal_spread | 2 | 1 | 10 | 106270.00 | long | bid | 245.5700 | 3.8000 | ["275","300"] | ["0.4191","0.4366"] | [] | ["EDGO"] | 275.0000 | 300.0000 | 95 | 276 | false | false | |||||||||||
| 01a0a027-6501-7a93-b2a9-cac6d588a517 | IBM | 2026-09-14 09:42 | call_backspread | 2 | 2 | 1482 | 926949.00 | long | bid | 244.7600 | 0.6900 | ["250","275"] | ["0.3484","0.3694"] | ["253.69","296.31"] | ["ARCO","XPHO"] | 250.0000 | 275.0000 | 32 | 32 | 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 |
| 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 |
| true |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:51:19Z"} |
| 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-24T15:58:41Z"} |
| 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-24T14:45:05Z"} |
| 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 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:21:10Z"} |
| 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-18T16:47:15Z"} |
| 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-14T19:45:44Z"} |
| 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-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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:15:33Z"} |
| 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-14T14:10:43Z"} |
| 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-14T13:42:19Z"} |
| 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 |