core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0ed83-eae7-73c1-b3d4-530c4afe1935 | GOOG | 2026-09-29 10:13 | synthetic | 2 | 4 | 38 | 33068.00 | short | bid | 336.8000 | 0.3000 | ["335"] | ["0.3526"] | ["337.00"] | ["ARCO","EDGO","EMLD","SPHR"] | 335.0000 | 335.0000 | 3 | 3 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T14:14:26Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ed76-238f-7b81-a1c2-36a6d96f6b65 | GOOG | 2026-09-29 09:58 | synthetic | 2 | 1 | 34 | 29614.00 | long | ask | 336.8301 | 0.2000 | ["335"] | ["0.3528"] | ["337.07"] | ["EDGO"] | 335.0000 | 335.0000 | 3 | 3 | false | false | false | false | |||||||||
| 01a0ed69-fa47-7de0-ab5d-cf70473a080b | GOOG | 2026-09-29 09:45 | synthetic | 2 | 2 | 21 | 74844.00 | long | ask | 337.8450 | 0.1857 | ["335"] | ["0.3510"] | ["340.01"] | ["MCRY","XISX"] | 335.0000 | 335.0000 | 52 | 52 | false | false | false | ||||||||||
| 01a0d91f-5627-7830-9bb8-7659eb8da1a0 | GOOG | 2026-09-25 11:11 | synthetic | 2 | 1 | 10 | 64410.00 | short | ask | 340.0500 | 1.2000 | ["350"] | ["0.3421"] | ["347.21"] | ["XCBO"] | 350.0000 | 350.0000 | 175 | 175 | false | false | false | ||||||||||
| 01a0d91e-f867-7423-9fa8-0ddea2781807 | GOOG | 2026-09-25 11:11 | synthetic | 2 | 1 | 10 | 64910.00 | long | bid | 340.3200 | 2.2500 | ["350"] | ["0.3446"] | ["347.47"] | ["XCBO"] | 350.0000 | 350.0000 | 175 | 175 | false | false | false | false | |||||||||
| 01a0cfc6-21ff-7a52-93f7-6646bf8afe97 | GOOG | 2026-09-23 15:37 | synthetic | 2 | 4 | 37 | 115868.00 | long | ask | 335.3649 | 0.7500 | ["335"] | ["0.3684"] | ["337.00"] | ["ARCO","EDGO","EMLD","SPHR"] | 335.0000 | 335.0000 | 37 | 37 | false | false | false | ||||||||||
| 01a0cfc6-1e17-75c3-adde-c68948338560 | GOOG | 2026-09-23 15:37 | synthetic | 2 | 1 | 9 | 27666.00 | short | bid | 335.4100 | 1.8500 | ["335"] | ["0.3615"] | ["337.00"] | ["C2OX"] | 335.0000 | 335.0000 | 37 | 37 | false | false | false | false | |||||||||
| 01a0ceb9-557f-7952-8fe1-ffb4109a1faa | GOOG | 2026-09-23 10:44 | synthetic | 2 | 1 | 2 | 28848.00 | short | bid | 338.0440 | 2.0000 | ["300"] | ["0.3745"] | ["368.40"] | ["XCBO"] | 300.0000 | 300.0000 | 814 | 814 | false | false | false | false | |||||||||
| 01a0c53c-ed9f-7d22-8710-66d6c5740439 | GOOG | 2026-09-21 14:31 | synthetic | 2 | 1 | 2 | 29596.00 | short | bid | 351.4650 | 3.5500 | ["330"] | ["0.3710"] | ["383.10"] | ["EMLD"] | 330.0000 | 330.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c534-f68f-7003-80c0-a98e5c28a4f7 | GOOG | 2026-09-21 14:22 | synthetic | 2 | 1 | 4 | 59432.00 | long | ask | 352.3750 | 3.1500 | ["330"] | ["0.3715"] | ["384.22"] | ["XCBO"] | 330.0000 | 330.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0b519-129f-7a83-9e1c-cd65958761bf | GOOG | 2026-09-18 11:18 | synthetic | 2 | 1 | 3 | 44136.00 | short | bid | 345.8160 | 2.5000 | ["300"] | ["0.3698"] | ["375.68"] | ["XCBO"] | 300.0000 | 300.0000 | 819 | 819 | false | false | false | ||||||||||
| 01a0aba5-0f73-7a43-a284-91023770150a | GOOG | 2026-09-16 15:15 | synthetic | 2 | 5 | 47 | 33203.00 | long | ask | 338.4650 | 0.4600 | ["337.5"] | ["0.3515"] | ["338.65"] | ["ARCO","BATO","C2OX","EMLD","SPHR"] | 337.5000 | 337.5000 | 2 | 2 | false | false | false | ||||||||||
| 01a0ab98-9423-7791-b701-5ba810f8c212 | GOOG | 2026-09-16 15:01 | synthetic | 2 | 11 | 43 | 30374.00 | short | ask | 339.6200 | 0.3500 | ["340"] | ["0.3518"] | ["339.8"] | ["AMXO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 340.0000 | 340.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0a0f8-a368-7073-b785-de7642aca4ca | GOOG | 2026-09-14 13:30 | synthetic | 2 | 4 | 12 | 65328.00 | unknown | — | 345.2025 | 0.1500 | ["365"] | ["0.3259"] | [] | ["MCRY","XISX","XPHO"] | 365.0000 | 365.0000 | 123 | 123 | false | false | false | false | true | ||||||||
| 01a0a023-32c8-7a70-a4e9-c3d9f7bf6527 | GOOG | 2026-09-14 09:37 | synthetic | 2 | 1 | 4 | 57780.00 | long | ask | 340.0650 | 6.1000 | ["330"] | ["0.3729"] | ["371.77"] | ["XCBO"] | 330.0000 | 330.0000 | 823 | 823 | false | false | false | false | |||||||||
| 01a09121-a930-7ca0-aa88-c19d3438f921 | GOOG | 2026-09-11 11:41 | synthetic | 2 | 1 | 3 | 33225.00 | long | ask | 338.8901 | 2.3000 | ["320"] | ["0.3605"] | ["358.01"] | ["XMIO"] | 320.0000 | 320.0000 | 497 | 497 | false | false | false | false | |||||||||
| 01a08c31-12d0-7aa0-9f86-5ff5d2a6cd35 | GOOG | 2026-09-10 12:40 | synthetic | 2 | 3 | 9 | 59085.00 | long | bid | 328.3450 | 0.3000 | ["340"] | ["0.3454"] | ["335.71"] | ["EMLD","XISX","XPHO"] | 340.0000 | 340.0000 | 190 | 190 | false | false | false | ||||||||||
| 01a0868d-9f60-78d2-a2a9-20e3cb610830 | GOOG | 2026-09-09 10:23 | synthetic | 2 | 1 | 3 | 41958.00 | short | bid | 327.9432 | 3.2500 | ["320"] | ["0.3730"] | ["357.74"] | ["XISX"] | 320.0000 | 320.0000 | 828 | 828 | false | false | false | ||||||||||
| 01a0815a-cbf9-7da2-986f-d26bbd9f9a26 | GOOG | 2026-09-08 10:10 | synthetic | 2 | 1 | 2 | 28160.00 | short | bid | 331.2203 | 3.8000 | ["330"] | ["0.3692"] | ["361.62"] | ["XMIO"] | 330.0000 | 330.0000 | 829 | 829 | false | false | false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:59:12Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:45:45Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:11:51Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:11:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:37:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:37:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:44:32Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:31:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:22:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:18:44Z"} |
| 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-16T19:15:19Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:02:02Z"} |
| 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-14T17:30:59Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:37:44Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:41:55Z"} |
| 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-10T16:40:34Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:24:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:10:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |