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 |
|---|
| cee1b2dd-3a06-4e41-ba8e-184feb0b57b2 | 2026-09-22 12:01 | 2026-09-22 12:01 | 2026-09-22 12:01 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.7000 | 5.5500 | 5.7500 | 350.2300 | 13110.00 | 12540.00 | 0.00 | 23 | 8 | 1729 | 696 | 2.48419540229885 | 0.357420048847872 | 0.357420048847872 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1879382770000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| a7cec683-2e9e-4bca-a633-9435d9028cce | 2026-09-22 11:05 | 2026-09-22 11:05 | 2026-09-22 11:05 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 3.5500 | 3.5000 | 3.5500 | 354.3001 | 12780.00 | 12780.00 | 0.00 | 36 | 8 | 1479 | 696 | 2.125 | 0.347588670198163 | 0.347588670198163 | false | false | false | |||||||||||||||||
| 835e6e0c-37a8-4ef9-9442-8d338cfce3e3 | 2026-09-22 10:17 | 2026-09-22 10:17 | 2026-09-22 10:17 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 2.7700 | 2.7000 | 2.7700 | 356.6350 | 10526.00 | 10526.00 | 0.00 | 38 | 5 | 1168 | 696 | 1.67816091954023 | 0.35760482989068 | 0.35760482989068 | false | false | false | |||||||||||||||||
| efa2c4d8-807d-4675-8ced-940a3627240f | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 3.1000 | 3.0000 | 3.1000 | 355.7500 | 63550.00 | 63550.00 | 0.00 | 205 | 5 | 1092 | 696 | 1.56896551724138 | 0.358240009124866 | 0.358240009124866 | false | false | false | |||||||||||||||||
| 1b082a6e-3241-4aa5-9737-cb93486e8a39 | 2026-09-22 10:01 | 2026-09-22 10:01 | 2026-09-22 10:01 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 2.9200 | 2.8000 | 2.9300 | 356.4400 | 40621.00 | 38379.00 | 2242.00 | 139 | 12 | 784 | 696 | 1.1264367816092 | 0.36516695425283 | 0.36433858293825 | false | false | false | |||||||||||||||||
| 041b2127-ed7f-4c2f-b15c-77f2c0045093 | 2026-09-22 10:01 | 2026-09-22 10:01 | 2026-09-22 10:01 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 2.9200 | 2.8500 | 2.9200 | 356.4400 | 21608.00 | 21608.00 | 0.00 | 74 | 10 | 858 | 696 | 1.23275862068966 | 0.36433858293825 | 0.36433858293825 | false | false | false | |||||||||||||||||
| 91357752-2be2-4d2b-b065-1bcf20409543 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 2.6100 | 2.5400 | 2.6100 | 357.3400 | 54810.00 | 54810.00 | 0.00 | 210 | 29 | 460 | 696 | 0.660919540229885 | 0.366176253681039 | 0.364321339045602 | true | false | false | |||||||||||||||||
| 392eef97-e2b4-4ba2-a507-7c04068a1f2c | 2026-09-21 15:50 | 2026-09-21 15:50 | 2026-09-21 15:50 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.0000 | 4.8000 | 5.0000 | 352.3000 | 50000.00 | 50000.00 | 0.00 | 100 | 6 | 5083 | 325 | 15.64 | 0.33823842423797 | 0.33823842423797 | false | false | false | |||||||||||||||||
| 88a3146a-4b26-4ac7-96bb-527219896d92 | 2026-09-21 15:47 | 2026-09-21 15:47 | 2026-09-21 15:47 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.0000 | 4.9000 | 5.0500 | 352.0000 | 200000.00 | 172000.00 | 0.00 | 400 | 8 | 4982 | 325 | 15.3292307692308 | 0.330514989395767 | 0.330446688921112 | true | false | false | |||||||||||||||||
| d557310e-3439-473e-abe2-49e6e464bf2c | 2026-09-21 15:13 | 2026-09-21 15:13 | 2026-09-21 15:13 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.4200 | 5.4000 | 5.5000 | 351.3500 | 109420.00 | 0.00 | 109420.00 | 202 | 5 | 3966 | 325 | 12.2030769230769 | 0.332492198199611 | 0.333857974754672 | false | false | false | |||||||||||||||||
| 0b035067-ebca-41c9-8cc4-6300665fa019 | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.2000 | 5.0000 | 5.2500 | 351.6300 | 18200.00 | 18200.00 | 0.00 | 35 | 5 | 1653 | 325 | 5.08615384615385 | 0.33073561136631 | 0.328802684830997 | false | false | false | |||||||||||||||||
| 83088923-dbb1-4204-90f9-a41e919c822d | 2026-09-21 10:12 | 2026-09-21 10:11 | 2026-09-21 10:11 | GOOG | GOOG260925P00352500 | put | 352.5000 | 2026-09-25 | 5.6500 | 5.6500 | 5.7500 | 350.0000 | 113000.00 | 0.00 | 113000.00 | 200 | 6 | 830 | 325 | 2.55384615384615 | 0.332452272026277 | 0.332452272026277 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| 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 |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1879382770000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |