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_alerts708,051 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 |
|---|
| a9234210-f36f-4a80-9844-e3d0b504d5c3 | 2026-09-24 15:41 | 2026-09-24 15:41 | 2026-09-24 15:41 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.6000 | 13.1500 | 13.8500 | 898.0000 | 20405.00 | 8160.00 | 9525.00 | 15 | 5 | 579 | 272 | 2.12867647058824 | 0.763737324938653 | 0.76320357301097 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 401215273979.00 | 2026-09-24 | postmarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| e7d7a674-c1d6-461d-801b-5a975224a6b2 | 2026-09-24 15:41 | 2026-09-24 15:41 | 2026-09-24 15:41 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5900 | 13.1500 | 13.8500 | 898.0000 | 25815.00 | 10855.00 | 9520.00 | 19 | 6 | 563 | 272 | 2.06985294117647 | 0.760153607966316 | 0.760534806457182 | false | false | false | |||||||||||||||||
| 969453ec-009e-4d58-aeab-83665860fc7b | 2026-09-24 15:41 | 2026-09-24 15:41 | 2026-09-24 15:41 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5500 | 13.3500 | 13.8500 | 898.0000 | 16260.00 | 4065.00 | 8130.00 | 12 | 5 | 523 | 272 | 1.92279411764706 | 0.763325638062449 | 0.763325638062449 | false | false | false | |||||||||||||||||
| 09486ef0-9991-4808-9604-f79aa4767a7f | 2026-09-24 15:41 | 2026-09-24 15:41 | 2026-09-24 15:41 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5800 | 13.1500 | 13.9000 | 898.0000 | 81450.00 | 10890.00 | 54285.00 | 60 | 16 | 511 | 272 | 1.87867647058824 | 0.767141877109691 | 0.759135358578318 | false | false | false | |||||||||||||||||
| ccc8f3b6-7127-45dc-be1b-e29581e3688f | 2026-09-24 15:40 | 2026-09-24 15:40 | 2026-09-24 15:40 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.7600 | 13.4000 | 13.8000 | 898.0000 | 19270.00 | 5520.00 | 2750.00 | 14 | 6 | 451 | 272 | 1.65808823529412 | 0.765718781006661 | 0.763050401579673 | false | false | false | |||||||||||||||||
| 495f19d6-44f1-4a05-a90d-819f5516df3e | 2026-09-24 15:40 | 2026-09-24 15:40 | 2026-09-24 15:40 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.8000 | 13.8000 | 14.1000 | 898.0000 | 24840.00 | 0.00 | 13800.00 | 18 | 5 | 436 | 272 | 1.60294117647059 | 0.765718781006661 | 0.765718781006661 | false | false | false | |||||||||||||||||
| 575678ec-f439-4503-b6ae-0e92fc86ee3d | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5000 | 13.1500 | 13.9500 | 898.0000 | 18900.00 | 0.00 | 14850.00 | 14 | 5 | 378 | 272 | 1.38970588235294 | 0.753539650904609 | 0.753539650904609 | false | false | false | |||||||||||||||||
| 4a7a9e89-60d4-4558-b63c-067df8af7a97 | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5500 | 13.5500 | 13.8500 | 898.0000 | 20325.00 | 0.00 | 8130.00 | 15 | 5 | 364 | 272 | 1.33823529411765 | 0.759391133402553 | 0.759391133402553 | false | false | false | |||||||||||||||||
| 2bda92f9-4b82-4f44-ac19-f3e6bc85298e | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.4500 | 13.4500 | 13.8000 | 898.0000 | 20175.00 | 0.00 | 4035.00 | 15 | 6 | 327 | 272 | 1.20220588235294 | 0.756212756084216 | 0.756212756084216 | false | false | false | |||||||||||||||||
| ce094c8e-efda-40e0-8098-b9cda845808c | 2026-09-24 15:38 | 2026-09-24 15:38 | 2026-09-24 15:38 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.4000 | 12.9500 | 13.8000 | 898.0000 | 13400.00 | 2680.00 | 8040.00 | 10 | 5 | 281 | 272 | 1.03308823529412 | 0.74565002233062 | 0.74565002233062 | false | false | false | |||||||||||||||||
| 7c243303-14bc-48c9-a520-6ea07aaf0fdc | 2026-09-24 09:47 | 2026-09-24 09:47 | 2026-09-24 09:47 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 9.7600 | 9.4000 | 10.9500 | 906.9650 | 17565.00 | 8795.00 | 8770.00 | 18 | 5 | 31 | 272 | 0.113970588235294 | 0.744013862823472 | 0.744013862823472 | true | false | false | |||||||||||||||||
| 378757ec-4ce5-481c-bf50-371b85a99b73 | 2026-09-22 15:54 | 2026-09-22 15:53 | 2026-09-22 15:53 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 12.8600 | 12.4500 | 13.7500 | 899.0000 | 11570.00 | 1285.00 | 10285.00 | 9 | 5 | 93 | 223 | 0.417040358744395 | 0.432017912695522 | 0.432017912695522 | true | false | false | |||||||||||||||||
| 22e8c5e0-1612-4c34-9919-3c7293f9e915 | 2026-09-22 13:48 | 2026-09-22 13:48 | 2026-09-22 13:48 | COST | COST260925P00897500 | put | 897.5000 | 2026-09-25 | 13.5000 | 13.0000 | 13.7500 | 898.2500 | 22958.00 | 22958.00 | 0.00 | 17 | 5 | 42 | 223 | 0.188340807174888 | 0.431973668111935 | 0.431973668111935 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 401215273979.00 |
| 2026-09-24 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:48:47.718536Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 398869271106.00 |
| 2026-09-24 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 398869271106.00 |
| 2026-09-24 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |