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_alerts658,639 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 | expirydate |
|---|
| 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 |
|---|
| 000f6290-abdd-4037-9f55-78c16ac230a1 | 2026-09-30 15:50 | 2026-09-30 15:50 | 2026-09-30 15:50 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 25.0500 | 25.0000 | 25.4500 | 348.2750 | 157820.00 | 77665.00 | 80155.00 | 63 | 11 | 437 | 1876 | 0.232942430703625 | 0.338115773878819 | 0.338904470909684 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 2000518560000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:50:15.606466Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 3a45ab70-9568-4ff1-a85f-28f4ca7c8b26 | 2026-09-30 13:51 | 2026-09-30 13:51 | 2026-09-30 13:51 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 26.0500 | 26.0250 | 26.3000 | 349.9800 | 18235.00 | 0.00 | 18235.00 | 7 | 5 | 304 | 1876 | 0.162046908315565 | 0.338967339171633 | 0.338967339171633 | false | false | false | true | ||||||||||||||||
| 78ff4a5f-4010-49f5-94ca-6c0f8730ab40 | 2026-09-30 09:54 | 2026-09-30 09:54 | 2026-09-30 09:54 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 25.0400 | 25.0000 | 25.7000 | 348.3200 | 90160.00 | 0.00 | 90160.00 | 36 | 5 | 169 | 1876 | 0.0900852878464819 | 0.337705245924799 | 0.338493976576919 | false | false | false | true | ||||||||||||||||
| a3d4090b-2810-4a1a-9c2f-a934195fea7d | 2026-09-30 09:44 | 2026-09-30 09:44 | 2026-09-30 09:44 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 24.8200 | 24.7000 | 24.9500 | 347.0000 | 124114.00 | 72034.00 | 52080.00 | 50 | 5 | 110 | 1876 | 0.05863539445629 | 0.342144790149763 | 0.340094991281112 | false | false | false | true | ||||||||||||||||
| 57859594-6f6f-4e00-9e74-b1c52b620e83 | 2026-09-30 09:44 | 2026-09-30 09:44 | 2026-09-30 09:44 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 24.8500 | 24.5000 | 25.3500 | 347.0000 | 84495.00 | 32315.00 | 37240.00 | 34 | 8 | 60 | 1876 | 0.0319829424307036 | 0.340185501298192 | 0.340094991281112 | true | false | false | true | ||||||||||||||||
| c13a7fa2-004c-4bb4-a862-6c73664e148c | 2026-09-29 15:47 | 2026-09-29 15:47 | 2026-09-29 15:47 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 21.2500 | 20.5000 | 21.3000 | 341.5150 | 23375.00 | 21250.00 | 2125.00 | 11 | 10 | 216 | 1826 | 0.11829134720701 | 0.335428932400169 | 0.335428932400169 | false | false | false | true | ||||||||||||||||
| 9fb6b720-1c75-4f3f-9ad5-7a175e2f6566 | 2026-09-28 13:36 | 2026-09-28 13:36 | 2026-09-28 13:36 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 22.0000 | 21.4500 | 22.0500 | 342.0000 | 74795.00 | 70400.00 | 4395.00 | 34 | 11 | 111 | 1803 | 0.0615640599001664 | 0.337586113107038 | 0.337586113107038 | true | false | false | true | ||||||||||||||||
| 4261ab55-2603-4d7e-9399-1f8b43a0d78c | 2026-09-28 09:38 | 2026-09-28 09:38 | 2026-09-28 09:38 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 21.9700 | 21.8500 | 22.5000 | 342.3200 | 17575.00 | 2195.00 | 13185.00 | 8 | 6 | 24 | 1803 | 0.0133111480865225 | 0.337516853730421 | 0.337516853730421 | true | false | false | true | ||||||||||||||||
| 775a96f3-fe7a-4165-b494-a91d43150df1 | 2026-09-24 09:40 | 2026-09-24 09:40 | 2026-09-24 09:40 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 21.2000 | 21.2000 | 21.8500 | 338.4400 | 14840.00 | 0.00 | 14840.00 | 7 | 5 | 21 | 1773 | 0.011844331641286 | 0.348215852778725 | 0.348215852778725 | false | false | false | true | ||||||||||||||||
| 5f77cc5b-d205-441e-acb0-9461026d740b | 2026-09-22 13:55 | 2026-09-22 13:55 | 2026-09-22 13:55 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 29.9500 | 29.3000 | 29.9500 | 353.0950 | 62893.00 | 62893.00 | 0.00 | 21 | 5 | 159 | 1659 | 0.0958408679927667 | 0.351285272637165 | 0.351587619215397 | false | false | false | true | ||||||||||||||||
| d3292f7d-5dd0-4d67-adc2-306509167280 | 2026-09-22 13:55 | 2026-09-22 13:55 | 2026-09-22 13:55 | GOOGL | GOOGL261218C00345000 | call | 345.0000 | 2026-12-18 | 29.7500 | 29.3000 | 29.7500 | 352.7700 | 47600.00 | 47600.00 | 0.00 | 16 | 10 | 122 | 1659 | 0.0735382760699216 | 0.351555231835163 | 0.351555231835163 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:55:15.856475Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:55:07.630767Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:46:07.580767Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:46:07.580767Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:48:27.886669Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |