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 |
|---|
| 01a0c9e7-a547-7922-9f5e-3615a9ebbf68 | GOOG | 2026-09-22 12:16 | call_calendar | 2 | 1 | 5 | 35740.00 | short | ask | 348.6700 | 4.1500 | ["315"] | ["0.5119"] | [] | ["XCBO"] | 315.0000 | 315.0000 | 3 | 31 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:17:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e7-2077-7b81-ba1c-2e95fd311653 | GOOG | 2026-09-22 12:16 | call_calendar | 2 | 1 | 5 | 35720.00 | short | ask | 348.4400 | 4.2500 | ["315"] | ["0.5458"] | [] | ["XCBO"] | 315.0000 | 315.0000 | 3 | 31 | false | false | true | false | |||||||||
| 01a0c9b2-d5bf-7e20-85d5-808ee064c104 | GOOG | 2026-09-22 11:18 | call_calendar | 2 | 1 | 5 | 44490.00 | short | bid | 353.7100 | 6.6000 | ["310"] | ["0.6810"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 3 | 10 | false | false | true | false | |||||||||
| 01a0c53e-0eae-7ce1-b766-b618f0871a45 | GOOG | 2026-09-21 14:32 | call_calendar | 2 | 1 | 4 | 26748.00 | short | ask | 350.8900 | 2.7500 | ["325"] | ["0.3525"] | [] | ["EDGO"] | 325.0000 | 325.0000 | 25 | 60 | false | false | true | false | |||||||||
| 01a0c534-c7af-7fe1-acd9-434409c9e3ba | GOOG | 2026-09-21 14:22 | call_calendar | 2 | 1 | 30 | 49500.00 | short | bid | 352.3700 | 0.6500 | ["370"] | ["0.3323"] | [] | ["XCBO"] | 370.0000 | 370.0000 | 32 | 39 | false | true | true | false | |||||||||
| 01a0c45c-0b4f-7fb2-8a1d-e49282c3ccf9 | GOOG | 2026-09-21 10:25 | call_calendar | 2 | 1 | 17 | 377740.00 | short | ask | 352.5003 | 3.2000 | ["250"] | ["0.3935"] | [] | ["MCRY"] | 250.0000 | 250.0000 | 88 | 269 | false | false | true | false | |||||||||
| 01a0b611-1e9f-7931-b9c7-3f1229b4918d | GOOG | 2026-09-18 15:49 | call_calendar | 2 | 1 | 3 | 28635.00 | long | ask | 347.4900 | 2.6500 | ["335"] | ["0.3418"] | [] | ["XBOX"] | 335.0000 | 335.0000 | 182 | 272 | false | false | true | false | |||||||||
| 01a0b5cc-6caf-7621-98d1-c389a65f57c0 | GOOG | 2026-09-18 14:34 | call_calendar | 2 | 1 | 16 | 438000.00 | short | bid | 347.0000 | 6.4000 | ["210"] | ["11.4202"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b5c0-762f-7c50-b406-6f818cc1db5b | GOOG | 2026-09-18 14:21 | call_calendar | 2 | 1 | 4 | 31680.00 | long | bid | 346.6600 | 1.1000 | ["360"] | ["0.3392"] | [] | ["XCBO"] | 360.0000 | 360.0000 | 119 | 455 | false | true | true | false | |||||||||
| 01a0b0de-6ea3-7302-9d05-c5fc9f2217d4 | GOOG | 2026-09-17 15:35 | call_calendar | 2 | 1 | 5 | 48155.00 | long | bid | 343.4000 | 1.0500 | ["300"] | ["0.7524"] | [] | ["XCBO"] | 300.0000 | 300.0000 | 1 | 92 | false | false | true | false | |||||||||
| 01a0b008-a043-7061-8c48-1bc271d03d10 | GOOG | 2026-09-17 11:42 | call_calendar | 2 | 1 | 6 | 77550.00 | short | ask | 343.5900 | 3.9000 | ["280"] | ["1.2565"] | [] | ["XPHO"] | 280.0000 | 280.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0afdb-817b-72c3-b49e-86f060ad72fb | GOOG | 2026-09-17 10:53 | call_calendar | 2 | 1 | 4 | 95248.00 | short | bid | 343.0900 | 6.3000 | ["225"] | ["2.3287"] | [] | ["XCBO"] | 225.0000 | 225.0000 | 1 | 36 | false | false | true | false | |||||||||
| 01a0afaa-f3cb-7b40-9cd7-20e39be14edc | GOOG | 2026-09-17 10:00 | call_calendar | 2 | 1 | 3 | 45651.00 | unknown | — | 342.0403 | 3.8500 | ["340"] | ["0.3575"] | [] | ["MCRY"] | 340.0000 | 340.0000 | 456 | 820 | false | false | true | false | false | mlat | |||||||
| 01a0abc5-8bdb-71f0-bab0-65706e03000e | GOOG | 2026-09-16 15:50 | call_calendar | 2 | 1 | 3 | 107904.00 | short | ask | 339.9755 | 5.0500 | ["160"] | ["3.2577"] | [] | ["XCBO"] | 160.0000 | 160.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0abb0-94ab-7030-b36a-9bbdb4b0533b | GOOG | 2026-09-16 15:27 | call_calendar | 2 | 3 | 297 | 127118.00 | short | bid | 337.7300 | 0.1700 | ["360"] | ["0.3517"] | [] | ["XBOX","XMIO"] | 360.0000 | 360.0000 | 2 | 30 | false | true | true | false | |||||||||
| 01a0abae-5a5b-75d3-85a1-59199f2ad466 | GOOG | 2026-09-16 15:25 | call_calendar | 2 | 1 | 3 | 56322.00 | short | ask | 338.0300 | 3.8000 | ["245"] | ["1.2165"] | [] | ["XMIO"] | 245.0000 | 245.0000 | 2 | 37 | false | false | true | false | |||||||||
| 01a0ab75-5c83-7f32-a275-7f4c30f1111a | GOOG | 2026-09-16 14:23 | call_calendar | 2 | 1 | 20 | 51880.00 | short | ask | 342.8900 | 1.1000 | ["335"] | ["0.3482"] | [] | ["XMIO"] | 335.0000 | 335.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0ab73-2233-72b0-90ef-616155880c3e | GOOG | 2026-09-16 14:20 | call_calendar | 2 | 1 | 180 | 907560.00 | short | bid | 343.0350 | 3.0000 | ["320"] | ["0.4807"] | [] | ["EDGO"] | 320.0000 | 320.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aad6-ceab-7a50-8d06-cd2b72037c56 | GOOG | 2026-09-16 11:29 | call_calendar | 2 | 1 | 3 | 50652.00 | short | bid | 342.7850 | 5.5000 | ["260"] | ["1.0116"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 2 | 65 | false | false | true | false | |||||||||
| 01a0aa95-a313-7831-bac1-fc875be0776c | GOOG | 2026-09-16 10:18 | call_calendar | 2 | 1 | 20 | 69440.00 | unknown | — | 341.5500 | 2.3500 | ["325"] | ["0.3286"] | [] | ["XCBO"] | 325.0000 | 325.0000 | 2 | 9 | false | false | true | false | false | mlat | |||||||
| 01a0a584-f8ee-7730-a837-bf2e1649b11d | GOOG | 2026-09-15 10:42 | call_calendar | 2 | 1 | 2 | 44652.00 | short | ask | 340.8600 | 5.3000 | ["230"] | ["1.3450"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 3 | 31 | false | false | true | false | |||||||||
| 01a0a111-6b28-7eb1-8e5f-6ae49868abf2 | GOOG | 2026-09-14 13:57 | call_calendar | 2 | 1 | 5 | 36270.00 | short | bid | 345.9600 | 5.2000 | ["310"] | ["0.5110"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 4 | 11 | false | false | true | false | |||||||||
| 01a0a102-7ed8-7a50-917e-eb92aadda5f2 | GOOG | 2026-09-14 13:41 | call_calendar | 2 | 1 | 174 | 692954.00 | short | ask | 345.5600 | 1.3000 | ["340"] | ["0.3182"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a09171-4be8-78c1-ab1e-cc30448c5a00 | GOOG | 2026-09-11 13:08 | call_calendar | 2 | 1 | 41 | 26527.00 | short | ask | 338.0100 | 0.5200 | ["380"] | ["0.3232"] | [] | ["XCBO"] | 380.0000 | 380.0000 | 35 | 49 | false | true | true | false | |||||||||
| 01a08c9c-d8a8-7912-849f-53b8a5231d28 | GOOG | 2026-09-10 14:38 | call_calendar | 2 | 1 | 14 | 43050.00 | long | bid | 329.6000 | 3.8500 | ["315"] | ["0.3558"] | [] | ["XCBO"] | 315.0000 | 315.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a08bf6-f3e8-75a2-bd9e-f072de99e2af | GOOG | 2026-09-10 11:36 | call_calendar | 2 | 1 | 20 | 586460.00 | short | bid | 327.8900 | 3.4500 | ["185"] | ["0.4911"] | [] | ["XMIO"] | 185.0000 | 185.0000 | 127 | 162 | false | false | true | false | |||||||||
| 01a08bb8-4508-7a60-9af4-9fb167431444 | GOOG | 2026-09-10 10:28 | call_calendar | 2 | 1 | 2 | 39560.00 | short | ask | 328.8200 | 5.4000 | ["230"] | ["1.0119"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 8 | 36 | false | false | true | false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:16:27Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:18:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:33:11Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:26:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:49:30Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:35:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:21:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:36:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:42:54Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:53:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:00:20Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:50:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:28:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:25:29Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:23:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:21:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:30:24Z"} |
| 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-16T14:19:06Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:42:37Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:58:11Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:41:59Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:08:34Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:38:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:36:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:28:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |