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_alerts609,118 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 |
|---|
| a4ff1709-7ed1-40ec-893c-ed1317a81031 | 2026-09-30 10:26 | 2026-09-30 10:26 | 2026-09-30 10:26 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 3.4000 | 3.2500 | 3.4000 | 349.6500 | 10540.00 | 10540.00 | 0.00 | 31 | 6 | 1922 | 2904 | 0.661845730027548 | 0.330403484756268 | 0.330403484756268 | false | false | false | true | false | 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-30T14:27:44.285455Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| c5f05faa-7336-4420-8116-8e81e45626b3 | 2026-09-30 10:07 | 2026-09-30 10:07 | 2026-09-30 10:07 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 3.9000 | 3.9000 | 4.0500 | 351.0000 | 33150.00 | 0.00 | 33150.00 | 85 | 9 | 1649 | 2904 | 0.567837465564738 | 0.325202583548916 | 0.325202583548916 | false | false | false | true | ||||||||||||||||
| 3e794feb-bb69-43e3-80ca-4b4d966c1507 | 2026-09-30 10:07 | 2026-09-30 10:07 | 2026-09-30 10:07 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 3.9500 | 3.9000 | 3.9500 | 351.0000 | 123240.00 | 123240.00 | 0.00 | 312 | 6 | 1564 | 2904 | 0.538567493112948 | 0.327765283370364 | 0.327765283370364 | false | false | false | true | ||||||||||||||||
| 15958e2a-22c8-4f59-884d-66d1647356b5 | 2026-09-30 09:49 | 2026-09-30 09:49 | 2026-09-30 09:49 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.9600 | 2.9600 | 3.1000 | 348.0000 | 16280.00 | 0.00 | 16280.00 | 55 | 5 | 655 | 2904 | 0.225550964187328 | 0.329160932813788 | 0.329160932813788 | false | false | false | true | ||||||||||||||||
| d20a1720-8eac-4b9a-9444-f27bcfccc4d6 | 2026-09-29 11:48 | 2026-09-29 11:48 | 2026-09-29 11:48 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 1.3000 | 1.2400 | 1.3500 | 338.7299 | 20150.00 | 9750.00 | 10400.00 | 155 | 5 | 2896 | 2118 | 1.36732766761095 | 0.328287267487002 | 0.328287267487002 | false | false | false | true | ||||||||||||||||
| b73a5bb7-c05f-4e30-9e03-b38ee71d860c | 2026-09-29 10:52 | 2026-09-29 10:52 | 2026-09-29 10:52 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 1.4500 | 1.4500 | 1.5000 | 339.8250 | 13775.00 | 0.00 | 13775.00 | 95 | 12 | 2443 | 2118 | 1.15344664778093 | 0.327354372973588 | 0.327354372973588 | false | false | false | true | ||||||||||||||||
| 55da5ae3-4da1-4572-bddc-e62431c2ab68 | 2026-09-29 10:11 | 2026-09-29 10:11 | 2026-09-29 10:11 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 1.4500 | 1.3700 | 1.4500 | 339.0000 | 191320.00 | 191177.00 | 143.00 | 1322 | 68 | 1618 | 2118 | 0.763928234183192 | 0.32499140462408 | 0.326198607026633 | true | false | false | true | ||||||||||||||||
| 2ae306fc-2c4e-4ce2-86f0-2b2fc2488960 | 2026-09-24 10:27 | 2026-09-24 10:27 | 2026-09-24 10:27 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.4500 | 2.4500 | 2.7300 | 339.4700 | 25725.00 | 0.00 | 25725.00 | 105 | 10 | 992 | 1568 | 0.63265306122449 | 0.324091732793312 | 0.324665101018292 | false | false | false | true | ||||||||||||||||
| 4db8ad0c-37ed-49c2-83c6-0c526fa8bd91 | 2026-09-24 09:40 | 2026-09-24 09:40 | 2026-09-24 09:40 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.5200 | 2.3200 | 2.5800 | 338.4750 | 15133.00 | 3289.00 | 11844.00 | 60 | 15 | 814 | 1568 | 0.519132653061224 | 0.337252632984247 | 0.339179565141028 | true | false | false | true | ||||||||||||||||
| e7e1b20b-01ca-4d7d-9a27-b5ec1cd9177b | 2026-09-24 09:40 | 2026-09-24 09:40 | 2026-09-24 09:40 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.5200 | 2.5200 | 2.6800 | 338.6800 | 17136.00 | 0.00 | 17136.00 | 68 | 8 | 689 | 1568 | 0.439413265306122 | 0.336522429407123 | 0.336522429407123 | false | false | false | true | ||||||||||||||||
| 9bc3cd57-44f7-444f-80ce-a2fbfacdbd38 | 2026-09-24 09:40 | 2026-09-24 09:40 | 2026-09-24 09:40 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.4800 | 2.4800 | 2.5300 | 338.4900 | 31744.00 | 0.00 | 31744.00 | 128 | 25 | 598 | 1568 | 0.381377551020408 | 0.334913061079085 | 0.336420199006946 | true | false | false | true | ||||||||||||||||
| b0a22713-aee3-4533-9928-1325d328ad50 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.4700 | 2.4700 | 2.5100 | 338.6200 | 21736.00 | 0.00 | 21736.00 | 88 | 15 | 385 | 1568 | 0.245535714285714 | 0.334443761127754 | 0.334547655158232 | true | false | false | true | ||||||||||||||||
| ebb4c859-ae83-460f-b72d-e55e3776032e | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 2.4600 | 2.4600 | 2.5100 | 338.7650 | 17220.00 | 0.00 | 17220.00 | 70 | 8 | 151 | 1568 | 0.0963010204081633 | 0.332519825132342 | 0.332519825132342 | false | false | false | true | ||||||||||||||||
| 2d2639ff-b352-43d2-b61e-41f279ddb3df | 2026-09-23 09:52 | 2026-09-23 09:51 | 2026-09-23 09:51 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 3.9500 | 3.9500 | 4.0500 | 345.8100 | 58065.00 | 0.00 | 58065.00 | 147 | 5 | 984 | 1811 | 0.54334621755936 | 0.311872564341407 | 0.311872564341407 | true | false | false | true | ||||||||||||||||
| 113b8bbf-82bf-4907-a221-21b2b6760813 | 2026-09-22 15:48 | 2026-09-22 15:48 | 2026-09-22 15:48 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 6.6500 | 6.3000 | 6.6500 | 352.3900 | 45885.00 | 45885.00 | 0.00 | 69 | 12 | 527 | 1757 | 0.299943084803643 | 0.318369832940957 | 0.317688010632945 | false | false | false | true | ||||||||||||||||
| 6321006d-e9fc-4d8b-877d-2a0dc1e4cbf2 | 2026-09-21 12:56 | 2026-09-21 12:56 | 2026-09-21 12:56 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 8.0000 | 7.8000 | 8.1000 | 355.0000 | 17600.00 | 17600.00 | 0.00 | 22 | 6 | 374 | 1759 | 0.212620807276862 | 0.309982559649905 | 0.30926037353799 | false | false | false | true | ||||||||||||||||
| 855d5c23-1790-4d3a-af67-78448bc560d1 | 2026-09-17 09:32 | 2026-09-17 09:32 | 2026-09-17 09:32 | GOOGL | GOOGL261009C00360000 | call | 360.0000 | 2026-10-09 | 5.2500 | 4.6500 | 5.6500 | 347.6300 | 105078.00 | 105078.00 | 0.00 | 200 | 13 | 267 | 1003 | 0.266201395812562 | 0.289951336374278 | 0.289951336374278 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-30T14:09:43.877107Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:09:43.877107Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:50:15.846728Z"} |
| 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-29T15:50:54.243467Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T14:54:53.700318Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T14:13:29.737020Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-23T13:52:21.829557Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 2038132440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |