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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| ca806a4e-2012-461a-b36a-6fb9b1e8f401 | 2026-08-27 12:55 | 2026-08-27 12:55 | 2026-08-27 12:55 | WMB | WMB261120P00070000 | put | 70.0000 | 2026-11-20 | 2.2500 | 2.1500 | 2.3000 | 74.6300 | 147137.00 | 146912.00 | 0.00 | 654 | 64 | 1598 | 1375 | 1.16218181818182 | 0.316157737381021 | 0.316157737381021 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 88006899610.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1f2a2cf-2039-471d-a76b-62b2149c596e | 2026-08-27 10:47 | 2026-08-27 10:47 | 2026-08-27 10:47 | WMB | WMB270219C00080000 | call | 80.0000 | 2027-02-19 | 3.2000 | 3.2000 | 3.5000 | 73.3050 | 62119.00 | 0.00 | 62119.00 | 194 | 23 | 198 | 194 | 1.02061855670103 | 0.257401500823226 | 0.257401500823226 | false | false | false | true | ||||||||||||||||
| 93834006-4823-4b0a-bab3-440866adc61d | 2026-08-26 15:54 | 2026-08-26 15:54 | 2026-08-26 15:54 | WMB | WMB261016C00070000 | call | 70.0000 | 2026-10-16 | 5.8000 | 5.6000 | 5.8000 | 74.4600 | 172257.00 | 172257.00 | 0.00 | 297 | 17 | 433 | 366 | 1.18306010928962 | 0.2544559877389 | 0.2544559877389 | false | false | false | true | ||||||||||||||||
| a575cfa6-9bff-4996-8135-09906fd46fc9 | 2026-08-26 10:09 | 2026-08-26 10:09 | 2026-08-26 10:09 | WMB | WMB260828C00074000 | call | 74.0000 | 2026-08-28 | 0.9500 | 0.7500 | 0.9500 | 74.0400 | 212677.00 | 212677.00 | 0.00 | 2239 | 67 | 2289 | 157 | 14.5796178343949 | 0.42188166034448 | 0.42188166034448 | false | false | false | true | ||||||||||||||||
| ba01355f-c9a6-4859-8407-17cc62171705 | 2026-08-24 14:12 | 2026-08-24 14:11 | 2026-08-24 14:11 | WMB | WMB261016C00080000 | call | 80.0000 | 2026-10-16 | 0.4600 | 0.4500 | 0.6500 | 71.0800 | 141486.00 | 0.00 | 141486.00 | 3089 | 53 | 3682 | 1699 | 2.16715715126545 | 0.258791469857266 | 0.255937698503037 | false | false | false | true | ||||||||||||||||
| b39cc85f-2634-4779-8e48-5d0283e2c427 | 2026-08-21 11:59 | 2026-08-21 11:59 | 2026-08-21 11:59 | WMB | WMB260904P00070000 | put | 70.0000 | 2026-09-04 | 1.1500 | 1.1000 | 1.2500 | 70.7400 | 64400.00 | 64285.00 | 115.00 | 560 | 6 | 623 | 311 | 2.0032154340836 | 0.279309264774569 | 0.279309264774569 | false | false | false | true | ||||||||||||||||
| 1928e258-d08c-4346-91f6-add3bd095ff7 | 2026-08-21 10:36 | 2026-08-21 10:36 | 2026-08-21 10:36 | WMB | WMB270319P00075000 | put | 75.0000 | 2027-03-19 | 8.4000 | 8.2000 | 8.4000 | 70.6700 | 68880.00 | 68880.00 | 0.00 | 82 | 6 | 91 | 156 | 0.583333333333333 | 0.322553385652284 | 0.322553385652284 | false | false | false | true | ||||||||||||||||
| 30860d18-f02d-4293-9394-978f7e78075e | 2026-08-19 14:03 | 2026-08-19 14:03 | 2026-08-19 14:03 | WMB | WMB261016P00070000 | put | 70.0000 | 2026-10-16 | 1.7000 | 1.6500 | 1.7500 | 73.5800 | 134130.00 | 170.00 | 133960.00 | 789 | 14 | 845 | 1327 | 0.636774679728711 | 0.292382044488284 | 0.292382044488284 | false | false | false | true | ||||||||||||||||
| f899cf0b-0cbe-4aba-b9f0-8cd1e84d07d8 | 2026-08-18 12:05 | 2026-08-18 12:05 | 2026-08-18 12:05 | WMB | WMB260918P00075000 | put | 75.0000 | 2026-09-18 | 2.4000 | 2.3000 | 2.4000 | 75.1250 | 85680.00 | 85680.00 | 0.00 | 357 | 41 | 420 | 1536 | 0.2734375 | 0.296180387207497 | 0.296180387207497 | false | false | false | true | ||||||||||||||||
| 22ea0675-06b7-4c14-bd31-f176af51d50f | 2026-08-17 13:34 | 2026-08-17 13:34 | 2026-08-17 13:34 | WMB | WMB260918P00075000 | put | 75.0000 | 2026-09-18 | 2.7500 | 2.6500 | 2.8000 | 74.3700 | 128951.00 | 128676.00 | 275.00 | 469 | 48 | 624 | 1139 | 0.547848990342406 | 0.290252650896072 | 0.290252650896072 | false | false | false | true | ||||||||||||||||
| 4c6638e3-b63a-4e23-bab9-6e8648b55994 | 2026-08-17 10:01 | 2026-08-17 10:01 | 2026-08-17 10:01 | WMB | WMB270115C00075000 | call | 75.0000 | 2027-01-15 | 5.6700 | 4.9000 | 5.8000 | 75.0400 | 1700220.00 | 453300.00 | 1246920.00 | 2996 | 83 | 3022 | 1442 | 2.09570041608877 | 0.252548419423905 | 0.264668265866278 | true | false | false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 88006899610.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |