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 |
|---|
| 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 |
|---|
| c362e0cb-c7e5-42ae-960b-e0dfc6626a1b | 2026-09-30 12:03 | 2026-09-30 12:02 | 2026-09-30 12:02 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 1.9600 | 1.8500 | 1.9800 | 736.3501 | 10762.00 | 10762.00 | 0.00 | 55 | 7 | 36762 | 3183 | 11.5494816211122 | 0.55292218930474 | 0.55292218930474 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1629126891164.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T16:05:51.935455Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 0434ab3e-a29b-4ac6-8fd8-0239fb31b479 | 2026-09-30 12:03 | 2026-09-30 12:03 | 2026-09-30 12:03 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 2.0400 | 1.9500 | 2.1000 | 737.1650 | 11010.00 | 11010.00 | 0.00 | 54 | 6 | 36980 | 3183 | 11.6179704681118 | 0.532513429365164 | 0.531918379237954 | false | false | false | true | ||||||||||||||||
| e65e397d-afa0-45bd-b4d1-9890838103c7 | 2026-09-30 12:04 | 2026-09-30 12:04 | 2026-09-30 12:04 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 2.2300 | 2.1700 | 2.2500 | 737.4900 | 27648.00 | 27648.00 | 0.00 | 124 | 10 | 37183 | 3183 | 11.6817467797675 | 0.528375714524653 | 0.536751156980746 | true | false | false | true | ||||||||||||||||
| f8b6e020-b6ea-4700-98fc-432938ba5b21 | 2026-09-30 12:10 | 2026-09-30 12:10 | 2026-09-30 12:10 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 2.2400 | 2.1500 | 2.2900 | 737.7400 | 12795.00 | 8315.00 | 4480.00 | 57 | 6 | 38479 | 3183 | 12.0889098334904 | 0.525650895921741 | 0.52733623683363 | false | false | false | true | ||||||||||||||||
| ed44b500-50dd-4f56-a1a9-238c3f890927 | 2026-09-30 12:15 | 2026-09-30 12:15 | 2026-09-30 12:15 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 1.8100 | 1.7700 | 1.8800 | 736.9500 | 27332.00 | 182.00 | 27150.00 | 151 | 33 | 39606 | 3183 | 12.4429783223374 | 0.508031211675245 | 0.508031211675245 | true | false | false | true | ||||||||||||||||
| 4d61e3c7-8577-4541-a8fe-882c0715208d | 2026-09-30 12:23 | 2026-09-30 12:23 | 2026-09-30 12:23 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 2.0400 | 1.9100 | 2.0600 | 737.6000 | 12018.00 | 12018.00 | 0.00 | 59 | 6 | 41236 | 3183 | 12.9550738297204 | 0.534020318131248 | 0.520173666667537 | false | false | false | true | ||||||||||||||||
| 08406bdf-07db-466d-94e3-a9ab18398e1b | 2026-09-30 13:03 | 2026-09-30 13:03 | 2026-09-30 13:03 | META | META260930C00740000 | call | 740.0000 | 2026-09-30 | 1.5000 | 1.4500 | 1.5000 | 736.9500 | 17100.00 | 17100.00 | 0.00 | 114 | 5 | 44954 | 3183 | 14.1231542569903 | 0.510221416154673 | 0.510221416154673 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:05:51.935455Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:05:51.935455Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:20:05.111203Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:28:12.605453Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:09:03.599351Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |