core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 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 |
|---|
| 01a0f8e8-f887-77c1-9f2a-8f5785e293db | JPM | 2026-10-01 15:20 | call_calendar | 2 | 2 | 76 | 101574.00 | short | bid | 332.7400 | 0.3700 | ["345"] | ["0.2525"] | [] | ["ARCO","XISX"] | 345.0000 | 345.0000 | 15 | 78 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:20:30Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f896-d916-7340-8aae-42b48738a2e0 | JPM | 2026-10-01 13:50 | call_calendar | 2 | 1 | 10 | 212950.00 | long | bid | 332.0600 | 1.5000 | ["230"] | ["0.3951"] | [] | ["XISX"] | 230.0000 | 230.0000 | 169 | 259 | false | false | true | false | |||||||||
| 01a0f872-7c7e-7873-9dc0-0cb4f597a915 | JPM | 2026-10-01 13:10 | call_calendar | 2 | 1 | 10 | 208450.00 | unknown | bid | 331.5200 | 5.4500 | ["230"] | ["0.3909"] | [] | ["XBOX"] | 230.0000 | 230.0000 | 106 | 259 | false | false | true | false | |||||||||
| 01a0f84b-f537-77e0-add3-bc4f9453d2bc | JPM | 2026-10-01 12:28 | call_calendar | 2 | 1 | 31 | 108314.00 | unknown | bid | 330.5150 | 0.5000 | ["330"] | ["0.2345"] | [] | ["XPHO"] | 330.0000 | 330.0000 | 78 | 106 | false | false | true | false | |||||||||
| 01a0f7ac-4a37-73a2-8390-3c38e2bb7479 | JPM | 2026-10-01 09:34 | call_calendar | 2 | 2 | 104 | 186888.00 | short | bid | 332.2150 | 2.5500 | ["350"] | ["0.2209"] | [] | ["ARCO","XPHO"] | 350.0000 | 350.0000 | 78 | 106 | false | true | true | false | |||||||||
| 01a0f31e-712f-75b3-8ea4-6dc80d37d3e6 | JPM | 2026-09-30 12:20 | call_calendar | 2 | 1 | 9 | 210834.00 | long | bid | 333.1850 | 4.3500 | ["220"] | ["0.4175"] | [] | ["ARCO"] | 220.0000 | 220.0000 | 170 | 260 | false | false | true | false | |||||||||
| 01a0f2ed-d3df-7581-b380-01b1685f00c2 | JPM | 2026-09-30 11:27 | call_calendar | 2 | 1 | 18 | 649656.00 | long | bid | 333.1900 | 7.3000 | ["155"] | ["0.4701"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 260 | 443 | false | false | true | false | |||||||||
| 01a0ed76-fe4f-7fb1-b2c9-a7a018ff0417 | JPM | 2026-09-29 09:59 | call_calendar | 2 | 3 | 91 | 109465.00 | short | bid | 335.1750 | 2.0500 | ["345"] | ["0.2638"] | [] | ["AMXO","ARCO"] | 345.0000 | 345.0000 | 24 | 31 | false | true | true | false | |||||||||
| 01a0cf86-426e-7913-936a-ccf70e9e9e8c | JPM | 2026-09-23 14:27 | call_calendar | 2 | 1 | 21 | 169071.00 | long | bid | 337.9450 | 3.8000 | ["340"] | ["0.2339"] | [] | ["XISX"] | 340.0000 | 340.0000 | 359 | 450 | false | true | true | false | |||||||||
| 01a0c973-0d9f-77f1-b687-6ce0e3f00aa6 | JPM | 2026-09-22 10:09 | call_calendar | 2 | 4 | 174 | 1129426.00 | short | bid | 343.4000 | 1.0000 | ["350"] | ["0.2321"] | [] | ["C2OX","EDGO","XCBO","XPHO"] | 350.0000 | 350.0000 | 268 | 360 | false | true | true | false | |||||||||
| 01a0b4d7-5e50-7971-a2a2-2d1c8055a95f | JPM | 2026-09-18 10:06 | call_calendar | 2 | 1 | 20 | 389120.00 | long | bid | 346.8500 | 6.1000 | ["250"] | ["3.6683"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 0 | 91 | false | false | true | false | |||||||||
| 01a0a5e6-4ee6-74a3-a412-d245c116851e | JPM | 2026-09-15 12:28 | call_calendar | 2 | 1 | 9 | 218970.00 | short | bid | 344.7200 | 6.2000 | ["225"] | ["0.4456"] | [] | ["XPHO"] | 225.0000 | 225.0000 | 94 | 185 | false | false | true | false | |||||||||
| 01a08bce-fd70-7870-8abc-c4c163babd0c | JPM | 2026-09-10 10:53 | call_calendar | 2 | 1 | 17 | 655656.00 | short | bid | 352.7500 | 6.4500 | ["160"] | ["1.8978"] | [] | ["ARCO"] | 160.0000 | 160.0000 | 8 | 71 | false | false | true | false | |||||||||
| 01a08723-a1b8-7251-8f5b-84c2a1e0ddbb | JPM | 2026-09-09 13:07 | call_calendar | 2 | 1 | 156 | 138528.00 | short | bid | 355.0609 | 0.8000 | ["375"] | ["0.2342"] | [] | ["BATO"] | 375.0000 | 375.0000 | 37 | 44 | false | true | true | false | |||||||||
| 01a06d95-7d0d-7ad0-a143-d83e9a5c2686 | JPM | 2026-09-04 14:01 | call_calendar | 2 | 1 | 200 | 4007000.00 | long | bid | 358.7700 | 3.9000 | ["260"] | ["0.4176"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 42 | 105 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:50:38Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:11:28Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:29:04Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:34:21Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:21:17Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:27:59Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:00:06Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:28:34Z"} |
| 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-22T14:09:19Z"} |
| 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-18T14:06:48Z"} |
| 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-15T16:29:00Z"} |
| 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-10T14:53:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:08:17Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:01:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |