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 |
|---|
| 14a0a295-ce45-421f-b477-31610ab68e50 | 2026-08-28 13:14 | 2026-08-28 13:14 | 2026-08-28 13:14 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 1.1500 | 0.9900 | 1.1600 | 16.3350 | 16737.00 | 8855.00 | 6962.00 | 146 | 18 | 303 | 23407 | 0.0129448455590208 | 0.374740173072501 | 0.371968575495286 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c0b3b7c-238d-48ba-8c6e-b643c4c2ee83 | 2026-09-02 11:07 | 2026-09-02 11:07 | 2026-09-02 11:07 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3000 | 0.2500 | 0.3400 | 12.8900 | 45810.00 | 7740.00 | 38070.00 | 1527 | 8 | 1690 | 22416 | 0.0753925767309065 | 0.477334196706265 | 0.477334196706265 | false | false | false | |||||||||||||||||
| f189c0ac-7c26-472b-8b15-f4b0d4f68ba6 | 2026-09-02 11:11 | 2026-09-02 11:11 | 2026-09-02 11:11 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3200 | 0.2500 | 0.3300 | 12.8650 | 60416.00 | 57536.00 | 2880.00 | 1888 | 22 | 3578 | 22416 | 0.159618129907209 | 0.490469410219492 | 0.490469410219492 | false | false | false | |||||||||||||||||
| 3fdd36cc-0c82-4188-8ceb-1c87efd51ae1 | 2026-09-02 11:18 | 2026-09-02 11:18 | 2026-09-02 11:18 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3300 | 0.3200 | 0.3400 | 12.8750 | 30558.00 | 24750.00 | 0.00 | 926 | 8 | 4713 | 22416 | 0.210251605995717 | 0.494694682893859 | 0.494694682893859 | false | false | false | |||||||||||||||||
| 64f1da90-549e-478e-9039-6fa0038ebf72 | 2026-09-02 11:23 | 2026-09-02 11:23 | 2026-09-02 11:23 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3500 | 0.3300 | 0.3700 | 12.9291 | 18480.00 | 140.00 | 6160.00 | 528 | 8 | 5241 | 22416 | 0.233806209850107 | 0.499452611846753 | 0.499452611846753 | false | false | false | |||||||||||||||||
| 16dc27fd-2d94-4394-9abc-153fc8bfc2ba | 2026-09-02 11:29 | 2026-09-02 11:29 | 2026-09-02 11:29 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3600 | 0.3500 | 0.3700 | 12.9250 | 25092.00 | 6372.00 | 11520.00 | 697 | 12 | 6340 | 22416 | 0.282833690221271 | 0.504922223175912 | 0.504922223175912 | false | false | false | |||||||||||||||||
| 1e293806-a6a9-4c8a-b6d1-1c6a5b440bd2 | 2026-09-02 11:31 | 2026-09-02 11:31 | 2026-09-02 11:31 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.3700 | 0.3600 | 0.3700 | 12.9250 | 106005.00 | 106005.00 | 0.00 | 2865 | 8 | 9380 | 22416 | 0.418451106352605 | 0.509926420403629 | 0.509926420403629 | false | false | false | |||||||||||||||||
| 152beb7b-35e0-4895-a6be-4223b5d7ed1c | 2026-09-03 12:48 | 2026-09-03 12:48 | 2026-09-03 12:48 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.7500 | 0.6700 | 0.7700 | 13.9800 | 122496.00 | 102280.00 | 20216.00 | 1625 | 48 | 1797 | 27976 | 0.0642336288247069 | 0.555572295620855 | 0.558680858153495 | false | false | false | |||||||||||||||||
| ebc140f6-f74f-4b90-9d44-fab739fa08bb | 2026-09-03 12:49 | 2026-09-03 12:49 | 2026-09-03 12:49 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.7600 | 0.6900 | 0.7700 | 13.9673 | 29412.00 | 21812.00 | 7600.00 | 387 | 9 | 2287 | 27976 | 0.0817486416928796 | 0.56019678507371 | 0.56019678507371 | true | false | false | |||||||||||||||||
| 66e6bc30-7c43-4589-9f98-e6a4cbc5083a | 2026-09-03 12:49 | 2026-09-03 12:49 | 2026-09-03 12:49 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.7600 | 0.7100 | 0.7700 | 13.9700 | 20672.00 | 4408.00 | 16264.00 | 272 | 13 | 2748 | 27976 | 0.0982270517586503 | 0.559277627280428 | 0.559874464507063 | true | false | false | |||||||||||||||||
| 3f80b93c-41fd-4fa6-b908-36e109bd6d43 | 2026-09-04 12:32 | 2026-09-04 12:32 | 2026-09-04 12:32 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.9800 | 0.9100 | 0.9800 | 14.0690 | 97902.00 | 97902.00 | 0.00 | 999 | 18 | 11037 | 30354 | 0.363609408974106 | 0.631590524578807 | 0.631590524578807 | true | false | false | |||||||||||||||||
| 9e2a8d00-0cde-4836-af55-0fdefac4b372 | 2026-09-11 15:06 | 2026-09-11 15:06 | 2026-09-11 15:06 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.5900 | 0.5800 | 0.6600 | 13.7850 | 31594.00 | 3900.00 | 27694.00 | 533 | 9 | 554 | 46219 | 0.0119864125143339 | 0.543549070307129 | 0.543549070307129 | false | false | false | |||||||||||||||||
| e86d4715-7620-45b0-bc9d-cbe897ab565d | 2026-10-01 12:08 | 2026-10-01 12:08 | 2026-10-01 12:08 | PCG | PCG261218C00017000 | call | 17.0000 | 2026-12-18 | 0.1100 | 0.1100 | 0.1500 | 12.0400 | 81642.00 | 0.00 | 81642.00 | 7422 | 45 | 7424 | 47222 | 0.157214857481682 | 0.503699215177388 | 0.503699215177388 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 32616944736.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:13:55.967811Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |