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 | 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 |
|---|
| 79c074e8-87ea-4fed-9ace-d3c721f04a84 | 2026-09-29 14:42 | 2026-09-29 14:42 | 2026-09-29 14:42 | WAL | WAL270319P00070000 | put | 70.0000 | 2027-03-19 | 4.6000 | 4.5000 | 4.8000 | 75.4900 | 34040.00 | 28060.00 | 5980.00 | 74 | 29 | 78 | 0 | 0 | 0.386403107387294 | 0.385893324719328 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 8265481457.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T18:44:56.074296Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| c38d414c-876b-404b-ba72-da1be6010916 | 2026-09-29 14:42 | 2026-09-29 14:42 | 2026-09-29 14:42 | WAL | WAL270521P00065000 | put | 65.0000 | 2027-05-21 | 4.2000 | 3.9000 | 4.2000 | 75.5200 | 41999.00 | 41999.00 | 0.00 | 100 | 25 | 1122 | 0 | 0 | 0.413387848917828 | 0.413387848917828 | false | false | false | |||||||||||||||||
| 85de73e1-5d0d-4f4d-95f4-f67f16a14e76 | 2026-09-29 12:23 | 2026-09-29 12:23 | 2026-09-29 12:23 | WAL | WAL261120P00067500 | put | 67.5000 | 2026-11-20 | 1.7000 | 1.5500 | 1.7500 | 74.4900 | 30430.00 | 30260.00 | 170.00 | 179 | 26 | 185 | 81 | 2.28395061728395 | 0.418645693469503 | 0.418645693469503 | false | false | false | |||||||||||||||||
| 92d0aaeb-2f1b-46c9-9d10-b3ac5afdcbca | 2026-09-29 12:03 | 2026-09-29 12:03 | 2026-09-29 12:03 | WAL | WAL261016P00070000 | put | 70.0000 | 2026-10-16 | 0.8500 | 0.7500 | 0.9000 | 74.0000 | 10795.00 | 10540.00 | 85.00 | 127 | 19 | 138 | 223 | 0.618834080717489 | 0.39425691733372 | 0.39425691733372 | false | false | false | |||||||||||||||||
| 897da16b-310f-4129-b6cf-228ca43a89ed | 2026-09-29 11:38 | 2026-09-29 11:38 | 2026-09-29 11:38 | WAL | WAL270115P00070000 | put | 70.0000 | 2027-01-15 | 3.6000 | 3.2000 | 3.6000 | 74.6000 | 19080.00 | 19080.00 | 0.00 | 53 | 9 | 53 | 96 | 0.552083333333333 | 0.382234534115732 | 0.382234534115732 | false | false | false | |||||||||||||||||
| 4458ea0d-59e1-479c-9fef-9d0ae39ccbed | 2026-09-17 15:01 | 2026-09-17 15:01 | 2026-09-17 15:01 | WAL | WAL261120C00082500 | call | 82.5000 | 2026-11-20 | 3.4000 | 3.2000 | 3.4000 | 79.5150 | 53040.00 | 53040.00 | 0.00 | 156 | 12 | 156 | 43 | 3.62790697674419 | 0.333575146545691 | 0.333575146545691 | false | false | false | |||||||||||||||||
| 0c898d4a-6dd4-4bd7-a1a8-8f6cf7f86a33 | 2026-09-02 11:14 | 2026-09-02 11:14 | 2026-09-02 11:14 | WAL | WAL270115P00075000 | put | 75.0000 | 2027-01-15 | 3.9000 | 3.9000 | 4.3000 | 79.6350 | 37831.00 | 0.00 | 37831.00 | 97 | 19 | 97 | 30 | 3.23333333333333 | 0.342296090078846 | 0.342296090078846 | false | false | false | |||||||||||||||||
| 88349d91-b02d-4311-b80c-13989b45c2ca | 2026-09-02 10:53 | 2026-09-02 10:53 | 2026-09-02 10:53 | WAL | WAL270115C00087500 | call | 87.5000 | 2027-01-15 | 3.6000 | 3.4000 | 3.6000 | 80.3100 | 17998.00 | 17998.00 | 0.00 | 50 | 15 | 56 | 31 | 1.80645161290323 | 0.302683953533866 | 0.302683953533866 | false | false | false | |||||||||||||||||
| 635d6af3-547b-489a-9680-efa972d662f3 | 2026-08-19 10:30 | 2026-08-19 10:29 | 2026-08-19 10:29 | WAL | WAL261120P00085000 | put | 85.0000 | 2026-11-20 | 7.3000 | 6.8000 | 7.5000 | 80.8700 | 12410.00 | 3650.00 | 8760.00 | 17 | 8 | 17 | 16 | 1.0625 | 0.331224299142416 | 0.331224299142416 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8265481457.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:44:56.074296Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8265481457.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:30:08.808043Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8265481457.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:08:27.647293Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8265481457.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:42:05.749928Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8665881628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8638606412.00 |
| 2026-10-20 |
| 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 |
| Financial Services |
| 8638606412.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8638606412.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |