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 | 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 |
|---|
| 01a0c433-bee7-75f0-a992-afc0e41d7530 | GOOG | 2026-09-21 09:41 | risk_reversal | 2 | 1 | 10 | 30620.00 | short | ask | 349.1200 | 2.8500 | ["345","405"] | ["0.3273","0.3289"] | ["333.20"] | ["XMIO"] | 345.0000 | 405.0000 | 116 | 116 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:42:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4fd-9f47-76d3-84d6-5584eda57d6e | GOOG | 2026-09-18 10:48 | risk_reversal | 2 | 2 | 30 | 30060.00 | short | bid | 346.9000 | 0.4500 | ["330","365"] | ["0.3069","0.3054"] | ["365.70"] | ["XMIO"] | 330.0000 | 365.0000 | 28 | 28 | false | true | false | true | |||||||||
| 01a0b4ed-fb5f-7121-890a-9fe52eac7054 | GOOG | 2026-09-18 10:31 | risk_reversal | 2 | 1 | 4 | 34712.00 | long | bid | 346.2130 | 3.0000 | ["375","410"] | ["0.3477","0.3517"] | ["351.40"] | ["XMIO"] | 375.0000 | 410.0000 | 364 | 364 | false | false | false | true | |||||||||
| 01a0b4ec-49c7-77b3-8eb2-b3750d661467 | GOOG | 2026-09-18 10:29 | risk_reversal | 3 | 2 | 2 | 41696.00 | long | ask | 346.5900 | 9.0500 | ["280","300","400"] | ["0.3674","0.3708","0.3599"] | ["315.80"] | ["BATO","C2OX"] | 280.0000 | 400.0000 | 819 | 819 | false | false | false | ||||||||||
| 01a0b4eb-6b1f-7772-a1f1-5b9eaf1d938f | GOOG | 2026-09-18 10:28 | risk_reversal | 3 | 2 | 2 | 41568.00 | long | ask | 346.9100 | 10.3000 | ["280","300","400"] | ["0.3642","0.3672","0.3600"] | ["315.80"] | ["BATO","C2OX"] | 280.0000 | 400.0000 | 819 | 819 | false | false | false | ||||||||||
| 01a0b012-aa93-7ef1-99ba-7ae3ab37a183 | GOOG | 2026-09-17 11:53 | risk_reversal | 2 | 1 | 6 | 50718.00 | long | bid | 342.0450 | 2.1000 | ["365","400"] | ["0.3518","0.3505"] | ["345.79"] | ["XCBO"] | 365.0000 | 400.0000 | 365 | 365 | false | false | false | true | |||||||||
| 01a0a697-246e-7880-b144-d66434ae5721 | GOOG | 2026-09-15 15:41 | risk_reversal | 2 | 1 | 40 | 86160.00 | short | bid | 340.4600 | 0.5500 | ["290","420"] | ["0.3462","0.3409"] | ["420.56"] | ["ARCO"] | 290.0000 | 420.0000 | 185 | 185 | false | true | false | true | |||||||||
| 01a0a646-8b9d-7003-b1fd-40591f20715b | GOOG | 2026-09-15 14:13 | risk_reversal | 2 | 2 | 37 | 50616.00 | long | bid | 340.5488 | 0.9000 | ["310","385"] | ["0.3506","0.3459"] | ["309.32"] | ["XCBO"] | 310.0000 | 385.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0a5e5-9366-7f52-b8c9-0069f0f01ca5 | GOOG | 2026-09-15 12:27 | risk_reversal | 2 | 1 | 33 | 48543.00 | short | bid | 340.9500 | 0.4500 | ["310","380"] | ["0.3506","0.3456"] | ["380.53"] | ["XCBO"] | 310.0000 | 380.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0a02c-9cf1-7e20-8077-ec3c8df79f66 | GOOG | 2026-09-14 09:47 | risk_reversal | 2 | 6 | 47 | 178356.00 | long | ask | 342.0300 | 2.1330 | ["335","340"] | ["0.3451","0.3466"] | ["347.00"] | ["ARCO","BATO","C2OX","EMLD","SPHR","XBOX"] | 335.0000 | 340.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a091a3-a688-7e70-90c5-cd4162b7ca8c | GOOG | 2026-09-11 14:03 | risk_reversal | 2 | 1 | 10 | 60240.00 | long | ask | 337.4400 | 0.7500 | ["300","420"] | ["0.3596","0.3545"] | ["425.96"] | ["C2OX"] | 300.0000 | 420.0000 | 462 | 462 | false | true | false | true | |||||||||
| 01a091a3-a688-7e70-90c5-cd3b49b450a0 | GOOG | 2026-09-11 14:03 | risk_reversal | 2 | 1 | 10 | 60240.00 | long | ask | 337.4400 | 0.7500 | ["300","420"] | ["0.3596","0.3545"] | ["425.96"] | ["C2OX"] | 300.0000 | 420.0000 | 462 | 462 | false | true | false | true | |||||||||
| 01a090fe-4e68-7b11-9568-0feadbbc7a16 | GOOG | 2026-09-11 11:02 | risk_reversal | 2 | 1 | 3 | 25524.00 | long | bid | 337.4700 | 1.6000 | ["360","395"] | ["0.3609","0.3507"] | ["340.40"] | ["XPHO"] | 360.0000 | 395.0000 | 371 | 371 | false | false | false | true | |||||||||
| 01a08ce5-2860-7621-877d-79eaa84d167e | GOOG | 2026-09-10 15:57 | risk_reversal | 2 | 1 | 12 | 37512.00 | long | bid | 330.5300 | 1.8500 | ["325","345"] | ["0.3461","0.3471"] | ["324.04"] | ["ARCO"] | 325.0000 | 345.0000 | 71 | 71 | false | true | false | true | |||||||||
| 01a08786-3800-7540-b95a-8d78c4eb4597 | GOOG | 2026-09-09 14:55 | risk_reversal | 2 | 2 | 44 | 154088.00 | short | ask | 328.1000 | 0.5500 | ["320","360"] | ["0.3316","0.3350"] | ["316.24"] | ["EMLD","XBOX"] | 320.0000 | 360.0000 | 128 | 128 | false | true | false | ||||||||||
| 01a0866c-2ce1-74b1-986a-5362f956ad2d | GOOG | 2026-09-09 09:47 | risk_reversal | 3 | 5 | 7 | 35824.00 | long | bid | 327.0900 | 2.0500 | ["320","330","375"] | ["0.3416","0.3447","0.3502"] | ["316.5"] | ["ARCO","BATO","EMLD","SPHR","XBOX"] | 320.0000 | 375.0000 | 100 | 100 | false | true | false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:48:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:31:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:29:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:29:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:53:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:42:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:14:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:28:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:47:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:03:48Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:03:48Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:03:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:57:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:55:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:47:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |