core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0ee62-aa56-7dd3-bf70-a08d5028f5dd | FTNT | 2026-09-29 14:17 | call_calendar | 2 | 1 | 112 | 221534.00 | short | bid | 174.8700 | 2.0500 | ["175"] | ["0.5384"] | [] | ["XCBO"] | 175.0000 | 175.0000 | 17 | 31 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T18:17:39Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ee62-a66f-74f2-971f-3024b9a70bd7 | FTNT | 2026-09-29 14:17 | call_calendar | 2 | 4 | 106 | 212016.00 | short | bid | 174.8700 | 2.4623 | ["175"] | ["0.5450"] | [] | ["EMLD","SPHR","XBOX","XCBO"] | 175.0000 | 175.0000 | 17 | 31 | false | true | |||||||||||
| 01a0ee5f-9d16-75e2-81c0-08642f8ada27 | FTNT | 2026-09-29 14:13 | call_calendar | 2 | 3 | 169 | 332930.00 | short | bid | 175.1000 | 1.3500 | ["175"] | ["0.5289"] | [] | ["MCRY","XISX","XPHO"] | 175.0000 | 175.0000 | 17 | 31 | false | false | |||||||||||
| 01a0ee56-f256-7512-be31-7b239d8b2a2c | FTNT | 2026-09-29 14:04 | strangle | 2 | 1 | 300 | 588000.00 | short | bid | 174.6200 | 6.3000 | ["170","180"] | ["0.6025","0.5948"] | ["150.40","199.60"] | ["XMIO"] | 170.0000 | 180.0000 | 31 | 31 | false | true | |||||||||||
| 01a0ee56-84f6-7362-b89d-c7e5bf994b3a | FTNT | 2026-09-29 14:04 | call_calendar | 2 | 1 | 431 | 888291.00 | short | bid | 174.8100 | 3.6000 | ["175"] | ["0.5263"] | [] | ["XMIO"] | 175.0000 | 175.0000 | 24 | 31 | false | true | |||||||||||
| 01a0ee55-5ffe-7301-87ef-4b3ed37e935c | FTNT | 2026-09-29 14:02 | call_calendar | 2 | 1 | 300 | 490800.00 | short | bid | 174.8550 | 1.4000 | ["180"] | ["0.5278"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 24 | 31 | false | true | |||||||||||
| 01a0e920-850f-71c1-b5e3-441baf9faebf | FTNT | 2026-09-28 13:46 | straddle | 2 | 1 | 75 | 613125.00 | short | bid | 176.1900 | 5.9000 | ["155"] | ["0.5397"] | ["73.25","236.75"] | ["SPHR"] | 155.0000 | 155.0000 | 480 | 480 | false | false | |||||||||||
| 01a0e89d-1c6e-7521-a00e-8931b2066506 | FTNT | 2026-09-28 11:23 | call_calendar | 2 | 1 | 408 | 844560.00 | short | bid | 175.5900 | 2.2000 | ["175"] | ["0.5000"] | [] | ["SPHR"] | 175.0000 | 175.0000 | 25 | 32 | false | false | |||||||||||
| 01a0e898-07a7-7831-a17c-05ddbb92e94c | FTNT | 2026-09-28 11:17 | call_calendar | 2 | 1 | 996 | 2513904.00 | short | bid | 175.2350 | 2.1500 | ["170"] | ["0.4907"] | [] | ["XISX"] | 170.0000 | 170.0000 | 25 | 32 | true | false | |||||||||||
| 01a0e895-a646-76b0-b974-d5967e312f87 | FTNT | 2026-09-28 11:15 | call_calendar | 2 | 1 | 64 | 113536.00 | short | bid | 175.1200 | 2.7500 | ["175"] | ["0.4717"] | [] | ["C2OX"] | 175.0000 | 175.0000 | 18 | 32 | false | false | |||||||||||
| 01a0d8e1-33e7-7a43-98f0-4886bd646dd1 | FTNT | 2026-09-25 10:03 | call_vertical_spread | 2 | 1 | 24 | 114816.00 | unknown | bid | 174.8100 | 4.1000 | ["150","155"] | ["0.5180","0.4924"] | ["176.42"] | ["AMXO"] | 150.0000 | 155.0000 | 21 | 21 | false | false | |||||||||||
| 01a0d8d4-dbbf-7ee2-a442-e74e930d41c0 | FTNT | 2026-09-25 09:50 | call_vertical_spread | 2 | 1 | 25 | 125150.00 | short | bid | 175.4200 | 5.5000 | ["150","155"] | ["0.5939","0.5517"] | ["154.54"] | ["XMIO"] | 150.0000 | 155.0000 | 21 | 21 | false | false | |||||||||||
| 01a0d8c6-31d7-79c2-888d-f40ad57e3e64 | FTNT | 2026-09-25 09:34 | call_vertical_spread | 2 | 1 | 25 | 127225.00 | short | bid | 176.0600 | 5.9500 | ["150","155"] | ["0.5754","0.5378"] | ["154.55"] | ["XISX"] | 150.0000 | 155.0000 | 21 | 21 | false | false | |||||||||||
| 01a0d4a4-d63e-7113-a8e9-133938dd175e | FTNT | 2026-09-24 14:19 | call_diagonal_spread | 2 | 1 | 15 | 220785.00 | short | bid | 179.6900 | 5.9000 | ["110","120"] | ["0.6162","0.5716"] | [] | ["XCBO"] | 110.0000 | 120.0000 | 113 | 358 | false | false | |||||||||||
| 01a0d45d-fd87-7762-8b3b-4c77acb29e55 | FTNT | 2026-09-24 13:02 | strangle | 2 | 1 | 256 | 2419200.00 | short | bid | 179.9600 | 1.8500 | ["220","230"] | ["0.5605","0.5279"] | ["125.50","324.50"] | ["XPHO"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-ccaf93b6b22c | FTNT | 2026-09-24 12:57 | strangle | 2 | 2 | 13 | 123500.00 | short | bid | 180.1400 | 1.2000 | ["220","230"] | ["0.5596","0.5347"] | ["125","325.00"] | ["ARCO","XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cc6fd02c84c3 | FTNT | 2026-09-24 12:57 | strangle | 2 | 2 | 16 | 152000.00 | short | bid | 180.1400 | 1.2000 | ["220","230"] | ["0.5615","0.5329"] | ["125","325.00"] | ["EDGO","XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cc373bf10fa2 | FTNT | 2026-09-24 12:57 | strangle | 2 | 3 | 12 | 114000.00 | short | bid | 180.1400 | 1.2000 | ["220","230"] | ["0.5615","0.5329"] | ["125","325.00"] | ["ARCO","XISX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cc17e7500c7a | FTNT | 2026-09-24 12:57 | strangle | 2 | 4 | 12 | 114000.00 | short | bid | 180.1400 | 0.7625 | ["220","230"] | ["0.5615","0.5329"] | ["125","325.00"] | ["EDGO","XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cbc60cf3f858 | FTNT | 2026-09-24 12:57 | strangle | 2 | 3 | 23 | 218500.00 | short | bid | 180.1400 | 1.2435 | ["220","230"] | ["0.5615","0.5329"] | ["125","325.00"] | ["ARCO","EDGO","XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cba9acb6a0d4 | FTNT | 2026-09-24 12:57 | strangle | 2 | 5 | 17 | 161575.00 | short | bid | 180.1400 | 1.8353 | ["220","230"] | ["0.5621","0.5329"] | ["124.96","325.04"] | ["ARCO","EDGO","XBOX","XISX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cb891ebdcc75 | FTNT | 2026-09-24 12:57 | strangle | 2 | 3 | 15 | 142500.00 | short | bid | 180.1400 | 2.7333 | ["220","230"] | ["0.5615","0.5329"] | ["125","325.00"] | ["ARCO","EDGO","XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0d45a-1587-7f90-97b8-cb799c00127e | FTNT | 2026-09-24 12:57 | strangle | 2 | 1 | 13 | 123500.00 | short | bid | 180.0207 | 4.1500 | ["220","230"] | ["0.5676","0.5270"] | ["125","325.00"] | ["XBOX"] | 220.0000 | 230.0000 | 484 | 484 | false | false | |||||||||||
| 01a0cf43-bf16-7083-a6c0-da80b44b203f | FTNT | 2026-09-23 13:15 | call_vertical_spread | 2 | 1 | 24 | 125112.00 | short | bid | 177.3400 | 3.3000 | ["150","155"] | ["0.4650","0.4568"] | ["154.53"] | ["EDGO"] | 150.0000 | 155.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cf1b-e3f6-7c93-ad5c-2fd7ca5b916c | FTNT | 2026-09-23 12:31 | call_vertical_spread | 2 | 1 | 58 | 299628.00 | short | bid | 176.6900 | 3.4500 | ["150","155"] | ["0.5193","0.4973"] | ["154.50"] | ["XISX"] | 150.0000 | 155.0000 | 23 | 23 | false | false | |||||||||||
| 01a0ceee-6b56-76d2-9792-87b569f64665 | FTNT | 2026-09-23 11:42 | call_vertical_spread | 2 | 1 | 20 | 105660.00 | short | bid | 177.2650 | 2.9000 | ["150","155"] | ["0.5313","0.5036"] | ["154.55"] | ["BATO"] | 150.0000 | 155.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cea6-3ec7-7b11-b7e0-2e9a898d4d94 | FTNT | 2026-09-23 10:23 | call_diagonal_spread | 2 | 1 | 36 | 555156.00 | long | bid | 174.9700 | 6.3500 | ["115","145"] | ["0.5694","0.5567"] | [] | ["XCBO"] | 115.0000 | 145.0000 | 485 | 849 | false | false | |||||||||||
| 01a0b512-ade7-7881-8115-820b8bf2617f | FTNT | 2026-09-18 11:11 | call_vertical_spread | 2 | 1 | 40 | 177320.00 | short | bid | 167.7500 | 2.1500 | ["145","150"] | ["0.4497","0.4440"] | ["149.25"] | ["XMIO"] | 145.0000 | 150.0000 | 28 | 28 | false | false | |||||||||||
| 01a0afca-8da3-7c31-a047-cde136c2cd85 | FTNT | 2026-09-17 10:34 | call_calendar | 2 | 1 | 10 | 151450.00 | short | bid | 176.0950 | 5.5000 | ["100"] | ["3.7821"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 1 | 29 | false | false | |||||||||||
| 01a0ab6a-256b-7831-a87f-d6500aba56d0 | FTNT | 2026-09-16 14:10 | call_diagonal_spread | 2 | 1 | 413 | 816088.00 | short | bid | 172.3100 | 5.9000 | ["165","185"] | ["0.5446","0.5690"] | [] | ["XCBO"] | 165.0000 | 185.0000 | 2 | 65 | false | false | |||||||||||
| 01a0ab6a-256b-7831-a87f-d6462ada1463 | FTNT | 2026-09-16 14:10 | call_diagonal_spread | 2 | 1 | 104 | 200290.00 | short | bid | 172.2700 | 6.7500 | ["165","185"] | ["0.4759","0.5595"] | [] | ["XPHO"] | 165.0000 | 185.0000 | 2 | 65 | false | false | |||||||||||
| 01a08c70-a440-7c22-9c2b-2953209ca664 | FTNT | 2026-09-10 13:49 | put_calendar | 2 | 3 | 140 | 239808.00 | short | bid | 158.7401 | 0.6500 | ["155"] | ["0.4780"] | [] | ["AMXO","ARCO","EDGO"] | 155.0000 | 155.0000 | 43 | 50 | true | true |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:17:39Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:14:31Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:04:39Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:04:39Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:03:00Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:47:03Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:23:31Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:18:16Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:15:18Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:04:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:50:35Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:34:27Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:20:06Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:02:05Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:58: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-23T17:15:43Z"} |
| 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-23T16:32:08Z"} |
| 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:42:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:23:15Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:11:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:34:47Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:11:11Z"} |
| 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-16T18:11:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:50:17Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |