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 | strike |
|---|
| 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 |
|---|
| 13217469-f472-4d93-bf64-8f176c471e2f | 2026-10-01 14:03 | 2026-10-01 14:03 | 2026-10-01 14:03 | DHR | DHR261016P00207500 | put | 207.5000 | 2026-10-16 | 2.9700 | 2.9500 | 3.2000 | 212.8100 | 80789.00 | 7039.00 | 73750.00 | 272 | 10 | 272 | 42 | 6.47619047619048 | 0.328448341064312 | 0.328448341064312 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 148864326795.00 | 2026-10-21 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T18:04:50.859752Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 78fc035c-9f4e-42f4-b1a9-ba1828aee981 | 2026-09-28 13:13 | 2026-09-28 13:13 | 2026-09-28 13:13 | DHR | DHR270115C00290000 | call | 290.0000 | 2027-01-15 | 2.4000 | 1.8000 | 2.6000 | 227.9900 | 63099.00 | 59999.00 | 1920.00 | 263 | 46 | 263 | 134 | 1.96268656716418 | 0.335809815020333 | 0.335371199910074 | true | false | ||||||||||||||||||
| 9578d268-ddca-43a9-820d-a13f5f310b9c | 2026-09-28 13:12 | 2026-09-28 13:12 | 2026-09-28 13:12 | DHR | DHR261218P00240000 | put | 240.0000 | 2026-12-18 | 20.5100 | 20.5000 | 21.1000 | 227.9750 | 45112.00 | 0.00 | 45112.00 | 22 | 5 | 308 | 6 | 51.3333333333333 | 0.346189735575941 | 0.346189735575941 | false | false | ||||||||||||||||||
| 805973dc-f9fa-4dba-b84b-9ff0b7159a2f | 2026-09-24 15:57 | 2026-09-24 15:57 | 2026-09-24 15:57 | DHR | DHR261023C00235000 | call | 235.0000 | 2026-10-23 | 5.2800 | 4.5000 | 5.3000 | 223.5000 | 193939.00 | 192899.00 | 1040.00 | 367 | 57 | 437 | 28 | 15.6071428571429 | 0.379770451668199 | 0.374729106507665 | true | false | ||||||||||||||||||
| 59f2d32c-78d6-4744-9cbe-75cd7731e0f8 | 2026-09-24 15:09 | 2026-09-24 15:09 | 2026-09-24 15:09 | DHR | DHR261016C00230000 | call | 230.0000 | 2026-10-16 | 4.2000 | 3.8000 | 4.2000 | 224.0000 | 167998.00 | 167998.00 | 0.00 | 400 | 45 | 622 | 960 | 0.647916666666667 | 0.295828436804591 | 0.295828436804591 | false | false | ||||||||||||||||||
| 631d78e2-26f6-4cd2-aa69-87a0004d639e | 2026-09-22 11:29 | 2026-09-22 11:29 | 2026-09-22 11:29 | DHR | DHR261218P00230000 | put | 230.0000 | 2026-12-18 | 18.6600 | 18.4000 | 19.0000 | 220.0000 | 57832.00 | 3800.00 | 54032.00 | 31 | 7 | 65 | 5 | 13 | 0.346424059014497 | 0.337521215377475 | false | false | ||||||||||||||||||
| ec85e5b4-0786-4dd4-a5f0-0d31f15e04c8 | 2026-09-18 10:49 | 2026-09-18 10:48 | 2026-09-18 10:48 | DHR | DHR261218P00220000 | put | 220.0000 | 2026-12-18 | 17.3800 | 17.0000 | 17.4000 | 212.5400 | 55610.00 | 55610.00 | 0.00 | 32 | 8 | 287 | 51 | 5.62745098039216 | 0.343028075176531 | 0.340662529219799 | false | false | ||||||||||||||||||
| 578bb0df-8ecc-4ede-9473-bf154d17a378 | 2026-09-15 10:06 | 2026-09-15 10:06 | 2026-09-15 10:06 | DHR | DHR261016P00210000 | put | 210.0000 | 2026-10-16 | 8.4000 | 8.0000 | 9.1000 | 207.1650 | 124306.00 | 123466.00 | 840.00 | 148 | 32 | 148 | 134 | 1.1044776119403 | 0.301452794935496 | 0.301452794935496 | false | false | ||||||||||||||||||
| 5525958b-b768-4177-b6ae-92aa622f58a3 | 2026-08-17 11:49 | 2026-08-17 11:49 | 2026-08-17 11:49 | DHR | DHR261120C00220000 | call | 220.0000 | 2026-11-20 | 6.9000 | 6.6000 | 6.9000 | 201.9800 | 167650.00 | 167650.00 | 0.00 | 243 | 34 | 248 | 0 | 0 | 0.31278761738988 | 0.31278761738988 | false | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 159809819656.00 |
| 2026-10-21 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 159809819656.00 |
| 2026-10-21 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:12:47.848498Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 155753590124.00 |
| 2026-10-21 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 155753590124.00 |
| 2026-10-21 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 155423186679.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 148899476098.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 142881915476.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 142881915476.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |