core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
uw_flow_alerts474,253 rowsrestricted — hover for the licence| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expiry |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| c3061f7c-d823-4257-b561-237f4ec20627 | 2026-08-27 10:56 | 2026-08-27 10:56 | 2026-08-27 10:56 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 11.7500 | 11.5500 | 11.8500 | 149.0600 | 54050.00 | 18800.00 | 35250.00 | 46 | 6 | 95 | 3216 | 0.0295398009950249 | 0.634416572243935 | 0.634416572243935 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b8c443bb-4ea7-416e-adca-26c4a8dda8bc | 2026-08-28 15:32 | 2026-08-28 15:32 | 2026-08-28 15:32 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 12.7500 | 12.6000 | 12.7500 | 151.7734 | 63750.00 | 63750.00 | 0.00 | 50 | 6 | 287 | 3212 | 0.0893524283935243 | 0.624459636425655 | 0.624459636425655 | false | false | false | |||||||||||||||||
| e2d541e7-d78a-48eb-8688-480dcb930805 | 2026-09-08 14:17 | 2026-09-08 14:17 | 2026-09-08 14:17 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 18.2000 | 17.9000 | 18.2000 | 162.7900 | 61879.00 | 61879.00 | 0.00 | 34 | 17 | 1326 | 3745 | 0.354072096128171 | 0.666591363781022 | 0.666591363781022 | true | false | false | |||||||||||||||||
| 78e58e86-9b96-4771-844f-fb06ec799f1d | 2026-09-11 10:16 | 2026-09-11 10:16 | 2026-09-11 10:16 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 10.2000 | 10.2000 | 10.2500 | 155.2950 | 202980.00 | 0.00 | 202980.00 | 199 | 9 | 1808 | 3609 | 0.500969797727903 | 0.511223434735237 | 0.511223434735237 | true | false | false | |||||||||||||||||
| 46347c8d-2418-475e-82fd-ed54f559a881 | 2026-09-11 10:16 | 2026-09-11 10:16 | 2026-09-11 10:16 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 10.2000 | 10.2000 | 10.2500 | 155.3400 | 426360.00 | 0.00 | 426360.00 | 418 | 13 | 1609 | 3609 | 0.445829869770019 | 0.509935421475052 | 0.509935421475052 | false | false | false | |||||||||||||||||
| 04a071db-307e-4b9b-979c-86ea9bdfb44b | 2026-09-15 11:27 | 2026-09-15 11:27 | 2026-09-15 11:27 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 4.2500 | 4.2000 | 4.2500 | 143.9600 | 121550.00 | 3825.00 | 0.00 | 286 | 61 | 1101 | 5575 | 0.197488789237668 | 0.489949545626772 | 0.489949545626772 | false | false | false | |||||||||||||||||
| b405cb10-256c-4c7c-abcd-b60adb9378d9 | 2026-09-21 12:25 | 2026-09-21 12:25 | 2026-09-21 12:25 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.3000 | 5.2500 | 5.3000 | 149.0600 | 86390.00 | 86390.00 | 0.00 | 163 | 12 | 977 | 6991 | 0.139751108568159 | 0.48923628674024 | 0.48923628674024 | false | false | false | |||||||||||||||||
| 3d5c9def-3445-4d11-b946-0b4690fb97f1 | 2026-09-21 12:25 | 2026-09-21 12:25 | 2026-09-21 12:25 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.3000 | 5.2500 | 5.3000 | 149.0600 | 42400.00 | 42400.00 | 0.00 | 80 | 5 | 1057 | 6991 | 0.151194392790731 | 0.48923628674024 | 0.48923628674024 | false | false | false | |||||||||||||||||
| 909b314c-edb2-4d50-bbe4-4bfbc2fbadf4 | 2026-09-21 12:27 | 2026-09-21 12:27 | 2026-09-21 12:27 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.2500 | 5.2000 | 5.2500 | 148.9800 | 40950.00 | 16275.00 | 0.00 | 78 | 7 | 1139 | 6991 | 0.162923759118867 | 0.488113600348337 | 0.488113600348337 | false | false | false | |||||||||||||||||
| 205bbe80-f304-48a6-9e58-75594f0fb700 | 2026-09-21 12:55 | 2026-09-21 12:55 | 2026-09-21 12:55 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.4500 | 5.4000 | 5.4500 | 149.0000 | 15260.00 | 15260.00 | 0.00 | 28 | 8 | 1324 | 6991 | 0.189386353883565 | 0.486760687995002 | 0.486760687995002 | true | false | false | |||||||||||||||||
| 264770b3-e1a8-4403-adde-f58463d2c79e | 2026-09-21 13:43 | 2026-09-21 13:43 | 2026-09-21 13:43 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.1000 | 5.1000 | 5.2000 | 148.8400 | 15300.00 | 0.00 | 15300.00 | 30 | 7 | 1511 | 6991 | 0.216135030753826 | 0.481984747513244 | 0.481984747513244 | false | false | false | |||||||||||||||||
| 56f3ffa6-cdfc-4c70-9cfc-6a87ea04eae1 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 7.3000 | 7.3000 | 7.4000 | 153.3700 | 18250.00 | 0.00 | 18250.00 | 25 | 5 | 808 | 7133 | 0.113276321323426 | 0.501755599839473 | 0.501755599839473 | true | false | false | |||||||||||||||||
| df7e17f5-3aa7-4bf7-8cc9-94491f3b3038 | 2026-09-22 10:19 | 2026-09-22 10:18 | 2026-09-22 10:18 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.8900 | 5.8500 | 5.9000 | 150.6150 | 14734.00 | 14734.00 | 0.00 | 25 | 5 | 1072 | 7133 | 0.150287396607318 | 0.495402516708652 | 0.49474690648982 | false | false | false | |||||||||||||||||
| f409d3f0-d2e6-42fd-8479-a1f40df375a8 | 2026-09-22 11:28 | 2026-09-22 11:28 | 2026-09-22 11:28 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.6000 | 5.4000 | 5.6000 | 150.0000 | 224000.00 | 224000.00 | 0.00 | 400 | 34 | 1782 | 7133 | 0.249824758166269 | 0.488780131502669 | 0.487922697820046 | false | false | false | |||||||||||||||||
| fce64416-8436-4c81-b117-e7fa1733dad8 | 2026-09-22 14:44 | 2026-09-22 14:44 | 2026-09-22 14:44 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 5.7500 | 5.7500 | 5.8500 | 150.2800 | 18400.00 | 0.00 | 18400.00 | 32 | 13 | 2457 | 7133 | 0.344455348380765 | 0.494226821473048 | 0.495233954951402 | false | false | false | |||||||||||||||||
| 73d69572-d658-49cf-bed3-e6b7320efe49 | 2026-09-24 11:30 | 2026-09-24 11:30 | 2026-09-24 11:30 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.6300 | 137.3350 | 57462.00 | 0.00 | 57462.00 | 366 | 45 | 1884 | 7331 | 0.256990860728414 | 0.498081165330179 | 0.498081165330179 | false | false | false | |||||||||||||||||
| bea31f8c-9805-43ec-9044-071b3dffe531 | 2026-09-24 11:30 | 2026-09-24 11:30 | 2026-09-24 11:30 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5700 | 1.5400 | 1.6100 | 137.3300 | 13031.00 | 5338.00 | 7693.00 | 83 | 7 | 1967 | 7331 | 0.268312644932479 | 0.498183258837272 | 0.498183258837272 | false | false | false | |||||||||||||||||
| 1127aa9c-3419-48d4-aba8-dc0cffb4b3d9 | 2026-09-25 10:49 | 2026-09-25 10:49 | 2026-09-25 10:49 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5400 | 1.5400 | 1.6100 | 138.2499 | 10626.00 | 0.00 | 10626.00 | 69 | 5 | 748 | 9809 | 0.0762564991334489 | 0.487538571870607 | 0.487538571870607 | false | false | false | |||||||||||||||||
| 1b7d4b2f-890e-4e50-97b8-54a1ec840d25 | 2026-09-25 11:45 | 2026-09-25 11:45 | 2026-09-25 11:45 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5100 | 1.4800 | 1.5100 | 137.4600 | 35312.00 | 32012.00 | 3300.00 | 234 | 14 | 5047 | 9809 | 0.51452747476807 | 0.500527258496706 | 0.499364085979273 | true | false | false | |||||||||||||||||
| 5d90736c-9026-4017-8811-9c0405960fc4 | 2026-09-25 11:52 | 2026-09-25 11:52 | 2026-09-25 11:52 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5000 | 1.4800 | 1.5000 | 137.0000 | 10783.00 | 8250.00 | 0.00 | 72 | 13 | 6690 | 9809 | 0.682026710164135 | 0.503816586565432 | 0.502644930110988 | true | false | false | |||||||||||||||||
| 2b6ecbff-492c-40cc-ac4c-a06e009d8f15 | 2026-09-25 15:03 | 2026-09-25 15:03 | 2026-09-25 15:03 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.6000 | 1.5700 | 1.6000 | 137.0000 | 31040.00 | 31040.00 | 0.00 | 194 | 6 | 9443 | 9809 | 0.962687327964115 | 0.500806481641308 | 0.500806481641308 | true | false | false | |||||||||||||||||
| bb69cf09-0063-446f-8808-87a6f4af2648 | 2026-09-25 15:31 | 2026-09-25 15:31 | 2026-09-25 15:31 | ORCL | ORCL261016C00155000 | call | 155.0000 | 2026-10-16 | 1.5900 | 1.5500 | 1.5900 | 137.4201 | 105417.00 | 105417.00 | 0.00 | 663 | 76 | 19077 | 9809 | 1.94484656947701 | 0.510577986914918 | 0.510577986914918 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:29:13.911862Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:56:11.622901Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |