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 | 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 |
|---|
| 11055b43-f868-4675-8972-8f4f1bfa187a | 2026-09-18 09:30 | 2026-09-18 09:30 | 2026-09-18 09:30 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 2.0000 | 1.3000 | 2.0000 | 13.6500 | 14000.00 | 8200.00 | 0.00 | 70 | 8 | 70 | 2378 | 0.0294365012615643 | 0.653023738974866 | 0.653023738974866 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 2787531742.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a48ea8bc-c853-4cfc-9cb8-76c079fa1843 | 2026-09-11 15:47 | 2026-09-11 15:47 | 2026-09-11 15:47 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.3000 | 1.1500 | 1.3000 | 11.6200 | 18850.00 | 18850.00 | 0.00 | 145 | 9 | 447 | 2072 | 0.215733590733591 | 1.00741527445975 | 1.00741527445975 | false | false | false | |||||||||||||||||
| 7643dc17-114c-4658-bea7-451b80eeaeb1 | 2026-09-01 14:17 | 2026-09-01 14:17 | 2026-09-01 14:17 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.3000 | 1.3000 | 1.4500 | 11.1750 | 13000.00 | 0.00 | 13000.00 | 100 | 6 | 204 | 1671 | 0.122082585278276 | 1.02846401913892 | 1.02846401913892 | false | false | false | |||||||||||||||||
| 0aa77f4a-e972-49aa-8bd7-2c6621a35e7b | 2026-08-28 12:26 | 2026-08-28 12:26 | 2026-08-28 12:26 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.7500 | 1.7500 | 1.9500 | 12.0600 | 15925.00 | 0.00 | 15925.00 | 91 | 10 | 339 | 1709 | 0.19836161497952 | 0.967844151567755 | 0.967844151567755 | false | false | false | |||||||||||||||||
| c58ca826-12a0-42b3-8506-3770126d9f0a | 2026-08-28 12:24 | 2026-08-28 12:24 | 2026-08-28 12:24 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.7500 | 1.7500 | 1.9500 | 12.0750 | 35072.00 | 0.00 | 35072.00 | 200 | 7 | 237 | 1709 | 0.13867758923347 | 0.974369614279288 | 0.962787073619151 | false | false | false | |||||||||||||||||
| 069ca6a7-15ff-472f-bba0-c9eb3f122679 | 2026-08-24 13:51 | 2026-08-24 13:51 | 2026-08-24 13:51 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.4300 | 1.3500 | 1.4500 | 10.7450 | 14300.00 | 14300.00 | 0.00 | 100 | 5 | 1613 | 1347 | 1.19747587230883 | 1.15162337259847 | 1.15162337259847 | false | false | false | |||||||||||||||||
| 8405fdcf-895f-4f15-9c25-e758793f43ec | 2026-08-24 11:59 | 2026-08-24 11:58 | 2026-08-24 11:58 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.4000 | 1.3000 | 1.5000 | 10.8400 | 107100.00 | 26880.00 | 53480.00 | 765 | 6 | 1344 | 1347 | 0.997772828507795 | 1.1048142424995 | 1.1048142424995 | false | false | false | |||||||||||||||||
| 32144da1-a676-4fbd-9aae-cbdc0d375b32 | 2026-08-24 09:31 | 2026-08-24 09:31 | 2026-08-24 09:31 | PURR | PURR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.5000 | 1.5000 | 1.7500 | 10.7200 | 10500.00 | 0.00 | 10500.00 | 70 | 12 | 81 | 1347 | 0.0601336302895323 | 1.20211703878873 | 1.20211703878873 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |