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 | direction |
|---|
| 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 |
|---|
| 01a0da15-0898-7f91-9309-f054ce220a61 | HOOD | 2026-09-25 15:40 | call_calendar | 2 | 1 | 37 | 120361.00 | short | bid | 119.0501 | 0.5500 | ["103"] | ["6.3690"] | [] | ["XMIO"] | 103.0000 | 103.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:40:06Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9f2-1b2f-7a80-b8b3-8ae40831c351 | HOOD | 2026-09-25 15:01 | call_calendar | 2 | 1 | 44 | 433180.00 | short | ask | 119.1850 | 0.8500 | ["70"] | ["13.5605"] | [] | ["XISX"] | 70.0000 | 70.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d9e8-eb9f-7f90-a223-4deb700fd84f | HOOD | 2026-09-25 14:51 | call_calendar | 2 | 1 | 18 | 123660.00 | short | bid | 119.3150 | 0.5500 | ["85"] | ["5.6427"] | [] | ["BATO"] | 85.0000 | 85.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d8d8-cb8f-7511-a2c3-f2fcd1033fd9 | HOOD | 2026-09-25 09:54 | call_calendar | 2 | 1 | 69 | 168440.00 | short | bid | 119.9400 | 0.4000 | ["108"] | ["1.0649"] | [] | ["XISX"] | 108.0000 | 108.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d441-a79f-72e1-b9fb-bf85f8996ebd | HOOD | 2026-09-24 12:31 | call_calendar | 2 | 1 | 41 | 204098.00 | short | bid | 121.7250 | 0.8500 | ["97"] | ["1.4711"] | [] | ["XMIO"] | 97.0000 | 97.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0cfac-f0c7-72e1-af6d-b5fa7ac245ee | HOOD | 2026-09-23 15:10 | call_calendar | 2 | 1 | 20 | 157000.00 | short | bid | 124.2200 | 0.6500 | ["85"] | ["1.8312"] | [] | ["XCBO"] | 85.0000 | 85.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0c95d-5aee-7a92-9a63-c16d0e1704a6 | HOOD | 2026-09-22 09:45 | call_calendar | 2 | 1 | 20 | 220940.00 | short | bid | 125.1100 | 1.0000 | ["70"] | ["2.1123"] | [] | ["BATO"] | 70.0000 | 70.0000 | 3 | 10 | false | false | true | false | |||||||||
| 01a0b5fb-ecd8-7303-8517-0cc90d71e029 | HOOD | 2026-09-18 15:26 | call_calendar | 2 | 2 | 18 | 124236.00 | short | ask | 119.4150 | 0.6500 | ["85"] | ["9.7933"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0b5f1-ee3f-7c32-af13-cb0bd2abb723 | HOOD | 2026-09-18 15:15 | call_calendar | 2 | 1 | 16 | 119344.00 | short | ask | 119.5400 | 2.2500 | ["175"] | ["0.6798"] | [] | ["XCBO"] | 175.0000 | 175.0000 | 819 | 854 | false | true | true | false | |||||||||
| 01a0b5e5-3c40-71c1-89ff-c120d7d9e491 | HOOD | 2026-09-18 15:01 | call_calendar | 2 | 1 | 6 | 103500.00 | short | ask | 119.3800 | 1.7500 | ["40"] | ["0.7429"] | [] | ["XISX"] | 40.0000 | 40.0000 | 490 | 854 | false | false | true | false | |||||||||
| 01a0b5c3-dd47-7102-b76a-dc3a905c7a50 | HOOD | 2026-09-18 14:25 | call_calendar | 2 | 1 | 77 | 889658.00 | short | ask | 119.0303 | 2.3500 | ["100"] | ["0.6939"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b51c-cfa7-7ef2-bdb4-7da6df76fcbc | HOOD | 2026-09-18 11:22 | call_calendar | 2 | 1 | 40 | 101560.00 | short | bid | 118.4800 | 0.6000 | ["107"] | ["0.6396"] | [] | ["BATO"] | 107.0000 | 107.0000 | 7 | 14 | false | false | true | false | |||||||||
| 01a0b500-3b40-7de0-84a7-2336f729ec68 | HOOD | 2026-09-18 10:51 | call_calendar | 2 | 1 | 86 | 874448.00 | short | bid | 118.0977 | 2.1500 | ["100"] | ["0.6795"] | [] | ["BATO"] | 100.0000 | 100.0000 | 490 | 819 | false | false | true | false | |||||||||
| 01a0afad-60e3-7ee0-b93b-190ecea3ae42 | HOOD | 2026-09-17 10:02 | call_calendar | 2 | 1 | 450 | 101700.00 | short | bid | 107.4300 | 0.1300 | ["113"] | ["0.7617"] | [] | ["XPHO"] | 113.0000 | 113.0000 | 1 | 8 | false | true | true | false | |||||||||
| 01a0aa8e-7b0b-7c23-b4ca-190a34935cd2 | HOOD | 2026-09-16 10:10 | call_calendar | 2 | 1 | 10 | 134900.00 | short | bid | 106.5910 | 2.5000 | ["55"] | ["0.7180"] | [] | ["XISX"] | 55.0000 | 55.0000 | 821 | 856 | false | false | true | false | |||||||||
| 01a0a05e-1119-75e2-b1a9-39a2d15b71b8 | HOOD | 2026-09-14 10:41 | call_calendar | 2 | 1 | 20 | 199180.00 | short | ask | 113.1900 | 2.4000 | ["110"] | ["0.6895"] | [] | ["XISX"] | 110.0000 | 110.0000 | 823 | 858 | false | false | true | false | |||||||||
| 01a091d5-f958-7b03-abd1-3db2aecd37b0 | HOOD | 2026-09-11 14:58 | call_calendar | 2 | 1 | 20 | 109320.00 | short | ask | 112.1300 | 0.8000 | ["85"] | ["0.8369"] | [] | ["XISX"] | 85.0000 | 85.0000 | 7 | 14 | false | false | true | false | |||||||||
| 01a08c0e-0241-7b42-8f71-a2788a3f4111 | HOOD | 2026-09-10 12:02 | call_calendar | 2 | 1 | 75 | 105750.00 | short | ask | 114.3500 | 0.4000 | ["110"] | ["0.7189"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 1 | 22 | false | false | true | false | |||||||||
| 01a06e00-a6a6-72f1-a65a-fa671470762d | HOOD | 2026-09-04 15:58 | call_calendar | 2 | 1 | 109 | 270647.00 | short | bid | 122.1300 | 0.4000 | ["110"] | ["16.3824"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d8c-f575-7b40-a411-ee5eb4b63c13 | HOOD | 2026-09-04 13:52 | call_calendar | 2 | 1 | 29 | 134676.00 | short | bid | 123.0850 | 0.8000 | ["100"] | ["3.6411"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d6e-edf6-76d1-95f5-689509275531 | HOOD | 2026-09-04 13:19 | call_calendar | 2 | 1 | 100 | 179400.00 | short | bid | 123.3600 | 0.7500 | ["115"] | ["1.3916"] | [] | ["XPHO"] | 115.0000 | 115.0000 | 0 | 7 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:02:22Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:52:17Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:54:42Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:31:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:10:49Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:45:46Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:26:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:15:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:01:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:25:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:22:43Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:51:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:02:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:11:10Z"} |
| 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-14T14:41:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:59:05Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:02:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:59:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:53:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:20:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |