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_alerts523,327 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 |
|---|
| 41e3b2d7-ca96-48f9-9b28-73681dd47692 | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 24.0100 | 23.4000 | 24.6500 | 751.4150 | 14405.00 | 4805.00 | 9600.00 | 6 | 6 | 56 | 192 | 0.291666666666667 | 0.506727349776329 | 0.506727349776329 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1624286634087.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:41:44.035284Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| cdb1f702-d3e8-4468-b32d-d5e0f918f16b | 2026-09-22 10:15 | 2026-09-22 10:15 | 2026-09-22 10:15 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 21.4000 | 21.4000 | 22.2500 | 754.2000 | 214028.00 | 0.00 | 214028.00 | 100 | 9 | 210 | 192 | 1.09375 | 0.480472858162964 | 0.480068189551393 | false | false | false | true | ||||||||||||||||
| 7701299f-c181-4f8b-88fa-54fee847580c | 2026-09-23 10:51 | 2026-09-23 10:51 | 2026-09-23 10:51 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 24.3600 | 24.2500 | 24.7500 | 748.4200 | 19485.00 | 9765.00 | 9720.00 | 8 | 7 | 224 | 337 | 0.664688427299703 | 0.509066653802049 | 0.510133459378862 | false | false | false | true | ||||||||||||||||
| df297d80-bee6-49fe-bcf4-cbcc5f99d3a4 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 18.5300 | 18.4000 | 19.3500 | 756.5550 | 20380.00 | 9285.00 | 11095.00 | 11 | 7 | 274 | 491 | 0.558044806517312 | 0.489745198091856 | 0.494083914141903 | false | false | false | true | ||||||||||||||||
| 9a83fb94-ad6f-4305-a79a-9cc89903feab | 2026-09-24 15:15 | 2026-09-24 15:15 | 2026-09-24 15:15 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 10.3000 | 10.3000 | 10.5000 | 778.2600 | 38110.00 | 0.00 | 38110.00 | 37 | 5 | 1787 | 491 | 3.63951120162933 | 0.482766802375074 | 0.482766802375074 | false | false | false | true | ||||||||||||||||
| 03389e05-9a4f-4ec8-8cad-4e13bf16e823 | 2026-09-24 15:34 | 2026-09-24 15:34 | 2026-09-24 15:34 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 10.5500 | 10.3500 | 10.8000 | 776.8205 | 244766.00 | 2115.00 | 242651.00 | 232 | 41 | 2179 | 491 | 4.43788187372709 | 0.47911859572164 | 0.478782238009833 | false | false | false | true | ||||||||||||||||
| 1fe4774b-f70c-47d8-9659-2bd4782013f9 | 2026-09-25 09:33 | 2026-09-25 09:33 | 2026-09-25 09:33 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 14.5500 | 14.5500 | 14.8500 | 758.5600 | 267720.00 | 0.00 | 267720.00 | 184 | 6 | 451 | 1408 | 0.3203125 | 0.450561614303321 | 0.450561614303321 | true | false | false | true | ||||||||||||||||
| a6cbc827-cdd3-4d78-ae7d-de8a71942dfa | 2026-09-25 09:34 | 2026-09-25 09:33 | 2026-09-25 09:33 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 15.1000 | 14.9000 | 15.3500 | 756.0000 | 28690.00 | 6040.00 | 22650.00 | 19 | 13 | 542 | 1408 | 0.384943181818182 | 0.44271856323888 | 0.440624553205007 | true | false | false | true | ||||||||||||||||
| aababb03-023c-47db-86ed-967f9ce77dcc | 2026-09-25 09:48 | 2026-09-25 09:48 | 2026-09-25 09:48 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 14.6500 | 14.6500 | 14.9000 | 756.9250 | 17580.00 | 0.00 | 17580.00 | 12 | 6 | 709 | 1408 | 0.503551136363636 | 0.436365092910833 | 0.436365092910833 | false | false | false | true | ||||||||||||||||
| fd483446-9fe2-472a-b366-241e9aceee85 | 2026-09-25 14:43 | 2026-09-25 14:43 | 2026-09-25 14:43 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 15.1000 | 14.8500 | 15.1500 | 752.5000 | 33218.00 | 33218.00 | 0.00 | 22 | 7 | 2017 | 1408 | 1.43252840909091 | 0.40236196154371 | 0.401197983085433 | false | false | false | true | ||||||||||||||||
| 7784dfcd-a48f-45e1-a410-fc3a78fc450e | 2026-09-25 15:56 | 2026-09-25 15:56 | 2026-09-25 15:56 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 15.4000 | 15.2000 | 15.4000 | 752.5650 | 23100.00 | 23100.00 | 0.00 | 15 | 5 | 2412 | 1408 | 1.71306818181818 | 0.407964436415919 | 0.407964436415919 | true | false | false | true | ||||||||||||||||
| 9687c864-b464-453b-bf97-7ab0622af798 | 2026-09-28 09:33 | 2026-09-28 09:33 | 2026-09-28 09:33 | META | META261002P00750000 | put | 750.0000 | 2026-10-02 | 28.9800 | 28.1500 | 29.0500 | 729.0400 | 46365.00 | 26100.00 | 20265.00 | 16 | 5 | 72 | 1667 | 0.0431913617276545 | 0.542626892451819 | 0.542719901464757 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:53:23.630136Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:37:02.882742Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:33:47.828400Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:46:04.686299Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:34:45.644461Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |