core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0cac0-36af-76c3-aecb-8f56c0039985 | QQQ | 2026-09-22 16:13 | synthetic | 2 | 1 | 2500 | 7120000.00 | long | ask | 747.3600 | 0.2900 | ["740"] | ["0.1809"] | ["749.50"] | ["AMXO"] | 740.0000 | 740.0000 | 24 | 24 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T20:14:11Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0cab8-011e-71e3-a31d-272947e19637 | QQQ | 2026-09-22 16:04 | synthetic | 2 | 1 | 15000 | 3480000.00 | long | ask | 747.2500 | 0.0900 | ["745"] | ["0.6725"] | ["747.28"] | ["AMXO"] | 745.0000 | 745.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0cab5-1707-7240-ab3f-33a112efdf9a | QQQ | 2026-09-22 16:00 | other | 2 | 1 | 40000 | 44600000.00 | unknown | ask | 747.3300 | 0.1100 | ["730","760"] | ["0.1906","0.1674"] | [] | ["AMXO"] | 730.0000 | 760.0000 | 10 | 24 | false | true | true | true | |||||||||
| 01a0ca82-5ea7-7dc0-aa2c-90aa0fcaa5b5 | QQQ | 2026-09-22 15:05 | put_frontspread | 2 | 1 | 5000 | 2267500.00 | long | ask | 746.4200 | 0.0600 | ["600","680"] | ["0.3311","0.2461"] | ["522.43","677.57"] | ["ARCO"] | 600.0000 | 680.0000 | 59 | 59 | false | true | false | true | |||||||||
| 01a0c9e1-9e4f-72a0-b852-22864c834af9 | QQQ | 2026-09-22 12:09 | call_ratio_spread | 2 | 1 | 2625 | 9165000.00 | long | ask | 744.8900 | 0.9000 | ["755","875"] | ["0.2119","0.1931"] | ["787.00","992.33"] | ["AMXO"] | 755.0000 | 875.0000 | 178 | 178 | false | true | false | true | |||||||||
| 01a0c9b0-e98e-7b10-863a-013d5ca175ef | QQQ | 2026-09-22 11:16 | put_vertical_spread | 2 | 1 | 1000 | 3932000.00 | long | ask | 745.1150 | 0.3600 | ["550","700"] | ["0.3106","0.2427"] | ["677.06"] | ["AMXO"] | 550.0000 | 700.0000 | 268 | 268 | false | true | false | true | |||||||||
| 01a0c9a1-0ef7-72e1-8422-a87e03784d4b | QQQ | 2026-09-22 10:59 | put_diagonal_spread | 2 | 1 | 1300 | 2168400.00 | long | ask | 744.7600 | 0.3000 | ["610","635"] | ["0.2785","0.2924"] | [] | ["AMXO"] | 610.0000 | 635.0000 | 59 | 268 | false | true | true | true | |||||||||
| 01a0c984-343f-76d2-8488-8d6853c7205b | QQQ | 2026-09-22 10:27 | put_butterfly_spread | 3 | 1 | 3400 | 6114900.00 | long | ask | 745.7300 | 0.2000 | ["605","670","720"] | ["0.3087","0.2507","0.2171"] | ["624.85","715.15"] | ["ARCO"] | 605.0000 | 720.0000 | 87 | 87 | false | true | false | true | |||||||||
| 01a0c978-0af7-7110-b492-7c052abbedea | QQQ | 2026-09-22 10:14 | call_ratio_spread | 2 | 1 | 2000 | 3265000.00 | long | ask | 745.6000 | 0.3000 | ["810","910"] | ["0.1980","0.1951"] | ["822.85","997.15"] | ["AMXO"] | 810.0000 | 910.0000 | 178 | 178 | false | true | false | true | |||||||||
| 01a0c595-5e3f-7890-8c95-ba8ee10e6cbf | QQQ | 2026-09-21 16:08 | other | 2 | 1 | 20000 | 29500000.00 | unknown | ask | 741.1469 | 0.1800 | ["725","775"] | ["0.1951","0.1851"] | [] | ["AMXO"] | 725.0000 | 775.0000 | 11 | 60 | true | true | true | true | |||||||||
| 01a0c559-7e1f-74f0-b05a-3d96866bc592 | QQQ | 2026-09-21 15:02 | synthetic | 2 | 1 | 3000 | 4944000.00 | long | ask | 741.3600 | 0.1200 | ["740"] | ["0.1676"] | ["742.10"] | ["AMXO"] | 740.0000 | 740.0000 | 10 | 10 | true | false | false | false | |||||||||
| 01a0c51e-9417-7c11-b043-12bb063ae3d4 | QQQ | 2026-09-21 13:58 | synthetic | 2 | 1 | 1200 | 1292400.00 | long | ask | 739.6850 | 0.1400 | ["729"] | ["0.4619"] | ["739.73"] | ["AMXO"] | 729.0000 | 729.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0c51a-e2c6-7e03-b95c-67a3955a5345 | QQQ | 2026-09-21 13:54 | risk_reversal | 2 | 1 | 2000 | 1202000.00 | short | ask | 739.7794 | 0.0300 | ["700","775"] | ["0.2191","0.1650"] | ["699.29"] | ["AMXO"] | 700.0000 | 775.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c4ed-5e6e-7f72-9c72-fc2205dabadb | QQQ | 2026-09-21 13:04 | call_ratio_spread | 2 | 1 | 6000 | 7788000.00 | long | ask | 738.9752 | 0.1800 | ["775","825"] | ["0.1913","0.1853"] | ["781.60","868.40"] | ["AMXO"] | 775.0000 | 825.0000 | 88 | 88 | false | true | false | true | |||||||||
| 01a0c4b3-33cf-7320-8480-a0bb7eb80dd1 | QQQ | 2026-09-21 12:01 | call_ratio_spread | 2 | 1 | 4500 | 9267000.00 | long | ask | 737.0700 | 0.3400 | ["750","810"] | ["0.2002","0.1846"] | ["751.84","839.08"] | ["SPHR"] | 750.0000 | 810.0000 | 116 | 116 | false | true | false | true | |||||||||
| 01a0c491-9e27-7ec3-8bbc-fe8c50ef7fa8 | QQQ | 2026-09-21 11:24 | call_ratio_spread | 2 | 1 | 2000 | 4904000.00 | long | ask | 736.3000 | 0.3600 | ["730","810"] | ["0.2069","0.1809"] | ["754.60","865.40"] | ["AMXO"] | 730.0000 | 810.0000 | 88 | 88 | false | false | false | true | |||||||||
| 01a0b624-c1f7-79f1-a578-6b4a849600b7 | QQQ | 2026-09-18 16:10 | straddle | 2 | 1 | 1000 | 462000.00 | long | ask | 722.6297 | 0.2000 | ["718"] | ["0.7500"] | ["713.38","722.62"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b614-4b20-77a0-a319-f316260357af | QQQ | 2026-09-18 15:52 | synthetic | 2 | 1 | 1420 | 99400.00 | short | ask | 720.0100 | 0.0200 | ["720"] | ["0.3319"] | ["719.98"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b5f8-1477-78f3-a94c-fa9622b945ef | QQQ | 2026-09-18 15:22 | straddle | 2 | 1 | 1400 | 149800.00 | long | ask | 719.3700 | 0.0300 | ["720"] | ["0.1927"] | ["718.93","721.07"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b5b6-6fc7-7890-af72-5e39c2cd3429 | QQQ | 2026-09-18 14:10 | put_vertical_spread | 2 | 1 | 1300 | 2282800.00 | long | ask | 717.4600 | 0.2100 | ["600","650"] | ["0.2835","0.2471"] | ["644.50"] | ["ARCO"] | 600.0000 | 650.0000 | 119 | 119 | false | true | false | true | |||||||||
| 01a0b4be-5fe0-7363-bba6-142d117d09bf | QQQ | 2026-09-18 09:39 | put_vertical_spread | 2 | 1 | 1000 | 719000.00 | long | ask | 719.3050 | 0.0700 | ["550","700"] | ["0.4259","0.1956"] | ["693.35"] | ["ARCO"] | 550.0000 | 700.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a06df9-3c35-79d3-b36a-cdd73a6fe68a | QQQ | 2026-09-04 15:50 | straddle | 2 | 1 | 1000 | 98000.00 | long | ask | 718.8800 | 0.0400 | ["718"] | ["0.2564"] | ["717.02","718.98"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a06df8-0b85-7bd2-b42c-8c21f65d7ebd | QQQ | 2026-09-04 15:49 | straddle | 2 | 1 | 1000 | 82000.00 | long | ask | 718.4900 | 0.0300 | ["718"] | ["0.2780"] | ["717.18","718.82"] | ["AMXO"] | 718.0000 | 718.0000 | 0 | 0 | false | false | false | false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T20:04:14Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T20:02:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:06:14Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:10:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:16:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:00:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:28:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:14:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T20:09:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:02:57Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:58:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:54:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:05:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:01:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:24:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T20:11:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:53:10Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:22:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:10:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:39:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:50:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlct |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:49:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |