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 | 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 |
|---|
| 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 | true | 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 |
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true |
| 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 |
| 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 |
| 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 |