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_alerts566,287 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 |
|---|
| 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 |
|---|
| ba962cb5-c666-442a-922a-54d229db4164 | 2026-09-28 12:19 | 2026-09-28 12:19 | 2026-09-28 12:19 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 10.2000 | 10.2000 | 10.3500 | 116.7501 | 20400.00 | 0.00 | 20400.00 | 20 | 5 | 89 | 6777 | 0.0131326545669175 | 0.607738331686259 | 0.607738331686259 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 92076797052.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T16:20:11.729471Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| f3efb677-f89a-4515-b1d3-05c8979f687a | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 15.3500 | 15.3500 | 15.6500 | 122.0000 | 46050.00 | 0.00 | 46050.00 | 30 | 13 | 209 | 6911 | 0.0302416437563305 | 0.606234446586529 | 0.606234446586529 | false | false | false | |||||||||||||||||
| bfe1674b-419c-4e49-86e4-b4b6bff1d6dd | 2026-09-16 11:07 | 2026-09-16 11:07 | 2026-09-16 11:07 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 6.0500 | 5.9500 | 6.1000 | 106.3900 | 84095.00 | 84095.00 | 0.00 | 139 | 6 | 787 | 5715 | 0.137707786526684 | 0.613289507167456 | 0.613289507167456 | false | false | false | |||||||||||||||||
| b2dc817e-acb3-4a77-8cab-8150a7c1de2f | 2026-09-02 10:38 | 2026-09-02 10:38 | 2026-09-02 10:38 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 7.4000 | 7.3000 | 7.4000 | 106.1200 | 100640.00 | 100640.00 | 0.00 | 136 | 18 | 661 | 5164 | 0.128001549186677 | 0.604152148382822 | 0.602707687561962 | true | false | false | |||||||||||||||||
| 19e16c47-354f-4096-a61d-06d460d3fdde | 2026-09-02 10:11 | 2026-09-02 10:11 | 2026-09-02 10:11 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 7.3500 | 7.2500 | 7.4500 | 106.0350 | 110979.00 | 7344.00 | 78645.00 | 151 | 23 | 253 | 5164 | 0.0489930286599535 | 0.602776908569402 | 0.602089038249661 | true | false | false | |||||||||||||||||
| 6cf9e0be-23fa-4902-93f5-3017a3a44cf3 | 2026-08-24 11:31 | 2026-08-24 11:31 | 2026-08-24 11:31 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 10.4500 | 10.3000 | 10.4500 | 108.9700 | 86735.00 | 86735.00 | 0.00 | 83 | 6 | 448 | 4212 | 0.10636277302944 | 0.643757294221552 | 0.64392199229895 | true | false | false | |||||||||||||||||
| 5c3105b0-0362-44c9-924b-81eb63c1e29b | 2026-08-20 12:41 | 2026-08-20 12:41 | 2026-08-20 12:41 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 4.4500 | 4.2500 | 4.6500 | 95.2850 | 93462.00 | 445.00 | 93017.00 | 210 | 9 | 1355 | 3438 | 0.39412449098313 | 0.618208449590732 | 0.623045682429364 | false | false | false | |||||||||||||||||
| b6282748-511a-4a6b-99b5-35bdf8d961f5 | 2026-08-20 10:29 | 2026-08-20 10:29 | 2026-08-20 10:29 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 4.2500 | 4.2000 | 4.5000 | 94.6550 | 316645.00 | 0.00 | 316645.00 | 745 | 45 | 963 | 3438 | 0.280104712041885 | 0.618993321209108 | 0.618993321209108 | false | false | false | |||||||||||||||||
| 86b2c70b-81cf-46f3-883c-c2fbea6f33ac | 2026-08-19 11:01 | 2026-08-19 11:01 | 2026-08-19 11:01 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 5.2000 | 5.0000 | 5.2000 | 97.2100 | 215800.00 | 215800.00 | 0.00 | 415 | 37 | 1952 | 2382 | 0.819479429051218 | 0.619002970020802 | 0.619002970020802 | false | false | false | |||||||||||||||||
| 73bcff87-07cb-4a4d-93d9-11600f81f00b | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | HOOD | HOOD261016C00110000 | call | 110.0000 | 2026-10-16 | 3.9500 | 3.6000 | 3.9500 | 94.0750 | 351920.00 | 350750.00 | 1170.00 | 891 | 53 | 910 | 2382 | 0.382031905961377 | 0.604555378869402 | 0.600757624410191 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |