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 |
|---|
| 01a0d9e5-039f-7333-bd45-b43fbbe9919a | SMH | 2026-09-25 14:47 | call_calendar | 2 | 1 | 2 | 73308.00 | unknown | bid | 606.6500 | 7.0000 | ["425"] | ["0.6470"] | [] | ["XCBO"] | 425.0000 | 425.0000 | 21 | 28 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:47:49Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d93c-bd7f-7a33-b22e-3ec87a3ea7b7 | SMH | 2026-09-25 11:43 | call_calendar | 2 | 1 | 10 | 228140.00 | unknown | bid | 603.5400 | 7.2000 | ["490"] | ["0.6758"] | [] | ["XCBO"] | 490.0000 | 490.0000 | 6 | 7 | false | false | true | false | |||||||||
| 01a0d8e2-ba87-7243-a026-844ae915974c | SMH | 2026-09-25 10:05 | call_calendar | 2 | 1 | 2 | 43120.00 | unknown | ask | 605.6000 | 6.7000 | ["500"] | ["2.8780"] | [] | ["XBOX"] | 500.0000 | 500.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d8e2-7fef-7563-b191-a4c890993447 | SMH | 2026-09-25 10:05 | call_calendar | 2 | 1 | 20 | 101320.00 | unknown | ask | 605.9750 | 4.8000 | ["585"] | ["0.9701"] | [] | ["XBOX"] | 585.0000 | 585.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0d8df-efaf-7c31-8f42-609bc0507ec4 | SMH | 2026-09-25 10:02 | call_calendar | 2 | 1 | 650 | 2925000.00 | unknown | bid | 607.5600 | 2.7000 | ["640"] | ["0.3374"] | [] | ["XPHO"] | 640.0000 | 640.0000 | 21 | 112 | false | true | true | false | |||||||||
| 01a0d8c4-0727-7d33-8e95-576927c6995d | SMH | 2026-09-25 09:31 | call_calendar | 2 | 2 | 2 | 41972.00 | unknown | ask | 604.8200 | 7.7000 | ["500"] | ["2.0009"] | [] | ["XMIO"] | 500.0000 | 500.0000 | 0 | 3 | false | false | true | false | |||||||||
| 01a0d446-4b1f-7ae1-b0c1-a1ad74328901 | SMH | 2026-09-24 12:36 | call_calendar | 2 | 3 | 9 | 25326.00 | unknown | bid | 598.1100 | 1.5000 | ["595"] | ["0.3448"] | [] | ["XCBO","XPHO"] | 595.0000 | 595.0000 | 1 | 22 | false | false | true | false | |||||||||
| 01a0cfb1-6567-77f1-ab35-6f2a242e0540 | SMH | 2026-09-23 15:15 | call_calendar | 2 | 1 | 4 | 42056.00 | unknown | bid | 599.9300 | 4.5000 | ["547.5"] | ["2.5683"] | [] | ["XCBO"] | 547.5000 | 547.5000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0ca56-41af-7fc1-90ac-eeb50b2ff511 | SMH | 2026-09-22 14:17 | call_calendar | 2 | 1 | 20 | 25042.00 | unknown | bid | 605.1000 | 0.6000 | ["635"] | ["0.3176"] | [] | ["XCBO"] | 635.0000 | 635.0000 | 10 | 24 | false | true | true | false | |||||||||
| 01a0c58c-59a6-7a80-a54e-0e2e7250622b | SMH | 2026-09-21 15:58 | call_calendar | 2 | 2 | 20 | 30360.00 | unknown | bid | 596.7600 | 1.9000 | ["590"] | ["2.3777"] | [] | ["AMXO"] | 590.0000 | 590.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0c514-f33f-7832-b790-bccc8c699dcc | SMH | 2026-09-21 13:47 | call_calendar | 2 | 1 | 5 | 28200.00 | unknown | — | 593.3400 | 0.9000 | ["625"] | ["0.3409"] | [] | ["AMXO"] | 625.0000 | 625.0000 | 32 | 151 | false | true | true | false | false | mlet | |||||||
| 01a0b5f5-ab47-7473-86d4-281565421fa6 | SMH | 2026-09-18 15:19 | call_calendar | 2 | 1 | 2 | 89440.00 | unknown | bid | 565.7200 | 8.6000 | ["430"] | ["0.3995"] | [] | ["XISX"] | 430.0000 | 430.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f4-0568-7813-ae74-4a2541a63911 | SMH | 2026-09-18 15:17 | call_calendar | 2 | 1 | 3 | 132840.00 | unknown | bid | 565.7400 | 8.8000 | ["430"] | ["0.3894"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b5f3-1338-7522-abd9-8c5664605560 | SMH | 2026-09-18 15:16 | call_calendar | 2 | 1 | 3 | 132795.00 | unknown | bid | 565.5300 | 9.1000 | ["430"] | ["0.3899"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 819 | 854 | false | false | true | false | |||||||||
| 01a0b558-07cf-7d23-ae9c-3233221e6d5e | SMH | 2026-09-18 12:27 | call_calendar | 2 | 2 | 23 | 49828.00 | unknown | ask | 563.0600 | 3.3826 | ["555"] | ["0.5157"] | [] | ["EMLD","MCRY"] | 555.0000 | 555.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0b0f2-c993-7020-adf5-c0c78d92faaf | SMH | 2026-09-17 15:58 | call_calendar | 2 | 1 | 3 | 220500.00 | unknown | — | 560.9200 | 6.5000 | ["195"] | ["3.7978"] | [] | ["XPHO"] | 195.0000 | 195.0000 | 1 | 183 | false | false | true | false | false | mlat | |||||||
| 01a0b050-dc73-7d71-86cb-e670c4c623f8 | SMH | 2026-09-17 13:01 | call_calendar | 2 | 1 | 10 | 562170.00 | unknown | — | 561.0600 | 5.6000 | ["280"] | ["3.7918"] | [] | ["ARCO"] | 280.0000 | 280.0000 | 1 | 29 | false | false | true | false | false | mlet | |||||||
| 01a0abc6-763b-72b3-8333-83742adc9091 | SMH | 2026-09-16 15:51 | call_calendar | 2 | 1 | 4 | 164612.00 | unknown | — | 544.7400 | 6.4500 | ["340"] | ["1.0020"] | [] | ["XPHO"] | 340.0000 | 340.0000 | 9 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aba3-ea7b-7690-a141-40fdb970fb60 | SMH | 2026-09-16 15:13 | call_calendar | 2 | 1 | 5 | 83025.00 | unknown | — | 540.8850 | 6.4000 | ["460"] | ["0.6854"] | [] | ["XISX"] | 460.0000 | 460.0000 | 2 | 30 | false | false | true | false | false | mesl | |||||||
| 01a0a689-39ee-7f82-9bdc-2b11a9246809 | SMH | 2026-09-15 15:26 | call_calendar | 2 | 1 | 12 | 43500.00 | unknown | — | 541.7550 | 0.8000 | ["610"] | ["0.3367"] | [] | ["XPHO"] | 610.0000 | 610.0000 | 94 | 122 | false | true | true | false | false | mlet | |||||||
| 01a08bab-c1e8-7d92-af0a-7cc1a4a1b387 | SMH | 2026-09-10 10:14 | call_calendar | 2 | 1 | 8 | 26304.00 | unknown | — | 559.7100 | 0.5000 | ["565"] | ["0.3546"] | [] | ["EDGO"] | 565.0000 | 565.0000 | 8 | 36 | false | true | true | false | false | mlet | |||||||
| 01a08b9f-13d0-7c53-9d53-74fa8e9dc499 | SMH | 2026-09-10 10:00 | call_calendar | 2 | 1 | 2 | 31000.00 | unknown | — | 558.2400 | 6.3000 | ["575"] | ["0.3738"] | [] | ["XISX"] | 575.0000 | 575.0000 | 15 | 827 | false | true | true | false | false | mlet | |||||||
| 01a08694-c768-7a32-85d1-d52f6ba760b2 | SMH | 2026-09-09 10:31 | call_calendar | 2 | 1 | 500 | 390455.00 | unknown | — | 575.9200 | 0.7800 | ["600"] | ["0.3521"] | [] | ["XCBO"] | 600.0000 | 600.0000 | 7 | 9 | false | true | true | false | false | mlat | |||||||
| 01a081a8-1521-7c83-b105-0d74303931ae | SMH | 2026-09-08 11:34 | call_calendar | 2 | 1 | 2 | 51950.00 | unknown | — | 577.0300 | 3.1500 | ["450"] | ["0.5554"] | [] | ["XISX"] | 450.0000 | 450.0000 | 24 | 31 | false | false | true | false | false | mlet | |||||||
| 01a08179-ae38-71e2-95cb-663672a5b18b | SMH | 2026-09-08 10:43 | call_calendar | 2 | 1 | 21 | 35007.00 | unknown | — | 574.1300 | 0.7000 | ["610"] | ["0.3634"] | [] | ["XPHO"] | 610.0000 | 610.0000 | 10 | 38 | false | true | true | false | false | mlet | |||||||
| 01a08179-ae38-71e2-95cb-662972e8f3c8 | SMH | 2026-09-08 10:43 | call_calendar | 2 | 1 | 27 | 45009.00 | unknown | — | 574.1650 | 0.7000 | ["610"] | ["0.3631"] | [] | ["XPHO"] | 610.0000 | 610.0000 | 10 | 38 | false | true | true | false | false | mlet |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:44:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:05:34Z"} |
| 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-25T14:05:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:02:30Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:32:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:36:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:15:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:17:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:58:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:48:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:19:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:17:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:16:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:27:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:58:28Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:01:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:51:59Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:14:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:27:04Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:00:57Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:31:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:34:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:43:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:43:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |