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_alerts425,429 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 |
|---|
| 1c9150f6-ab06-4acb-b16c-2b1f22e58966 | 2026-08-19 10:13 | 2026-08-19 10:12 | 2026-08-19 10:12 | NTAP | NTAP260821P00195000 | put | 195.0000 | 2026-08-21 | 2.8500 | 2.7500 | 3.2000 | 196.2550 | 32765.00 | 32480.00 | 285.00 | 115 | 25 | 116 | 714 | 0.162464985994398 | 0.598886154197449 | 0.598886154197449 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 36980788166.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0867ffc2-bd94-4081-b2e6-502d5499805b | 2026-08-19 15:42 | 2026-08-19 15:42 | 2026-08-19 15:42 | NTAP | NTAP270115C00220000 | call | 220.0000 | 2027-01-15 | 18.4000 | 17.8000 | 18.8000 | 195.9200 | 184036.00 | 184036.00 | 0.00 | 100 | 5 | 130 | 270 | 0.481481481481481 | 0.526304536517721 | 0.526304536517721 | false | false | false | |||||||||||||||||
| 22ea04d7-a9c0-4b81-86a1-8444274da437 | 2026-08-20 14:33 | 2026-08-20 14:33 | 2026-08-20 14:33 | NTAP | NTAP261016C00220000 | call | 220.0000 | 2026-10-16 | 8.7000 | 8.2000 | 9.0000 | 194.7150 | 47848.00 | 26098.00 | 21750.00 | 55 | 17 | 55 | 50 | 1.1 | 0.561400449748834 | 0.561400449748834 | true | false | false | true | ||||||||||||||||
| 6cccf1f4-4c42-48d9-94fd-7dd2f3dd91d0 | 2026-08-21 09:50 | 2026-08-21 09:50 | 2026-08-21 09:50 | NTAP | NTAP260918C00250000 | call | 250.0000 | 2026-09-18 | 1.4400 | 1.3000 | 1.5500 | 193.6900 | 14425.00 | 12685.00 | 1740.00 | 100 | 8 | 100 | 1028 | 0.0972762645914397 | 0.650875999665015 | 0.64977309846497 | false | false | false | |||||||||||||||||
| 0fbb9558-afef-4944-a623-cdd1fcd5b4ad | 2026-08-27 14:43 | 2026-08-27 14:43 | 2026-08-27 14:43 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 3.2000 | 2.6500 | 3.5000 | 188.6000 | 173437.00 | 38718.00 | 103999.00 | 542 | 24 | 574 | 6830 | 0.0840409956076135 | 0.66951427299286 | 0.668511784345791 | false | false | false | |||||||||||||||||
| 6243df46-bd22-44f0-8a4b-3a3ff5488066 | 2026-08-31 13:54 | 2026-08-31 13:54 | 2026-08-31 13:54 | NTAP | NTAP270319P00185000 | put | 185.0000 | 2027-03-19 | 25.3200 | 24.3000 | 25.4000 | 186.0000 | 15190.00 | 12670.00 | 2520.00 | 6 | 6 | 6 | 36 | 0.166666666666667 | 0.523872266826988 | 0.521988274846978 | false | false | false | true | ||||||||||||||||
| d8e9b782-cbf2-4fb2-8e93-8e955071c485 | 2026-09-02 13:55 | 2026-09-02 13:55 | 2026-09-02 13:55 | NTAP | NTAP261016C00180000 | call | 180.0000 | 2026-10-16 | 16.0400 | 15.4000 | 16.2000 | 182.5900 | 12830.00 | 8050.00 | 4780.00 | 8 | 8 | 78 | 309 | 0.252427184466019 | 0.572479626410349 | 0.564420172838362 | false | false | false | |||||||||||||||||
| 5841eafd-6677-4078-a13b-82c0bdc795d0 | 2026-09-03 11:04 | 2026-09-03 11:04 | 2026-09-03 11:04 | NTAP | NTAP260918C00210000 | call | 210.0000 | 2026-09-18 | 1.2500 | 1.0000 | 1.3000 | 184.7206 | 12482.00 | 12482.00 | 0.00 | 100 | 11 | 964 | 1152 | 0.836805555555556 | 0.537896776953212 | 0.529149990646467 | false | false | false | |||||||||||||||||
| d1701ca6-f3c2-458d-a5be-5cda7a5c1b1c | 2026-09-08 15:37 | 2026-09-08 15:37 | 2026-09-08 15:37 | NTAP | NTAP261016C00210000 | call | 210.0000 | 2026-10-16 | 4.8000 | 4.6000 | 4.8000 | 189.2500 | 15353.00 | 15353.00 | 0.00 | 32 | 8 | 435 | 381 | 1.14173228346457 | 0.481057267526189 | 0.476855794839849 | false | false | false | true | ||||||||||||||||
| d4ceb1d5-40ec-4c04-9d72-2696028906f2 | 2026-09-18 11:07 | 2026-09-18 11:06 | 2026-09-18 11:06 | NTAP | NTAP261016C00210000 | call | 210.0000 | 2026-10-16 | 4.1000 | 3.9000 | 4.2000 | 194.0900 | 113564.00 | 102904.00 | 0.00 | 277 | 32 | 742 | 2443 | 0.303724928366762 | 0.445627112448147 | 0.445627112448147 | false | false | false | |||||||||||||||||
| a39586c7-d10a-4891-8cd7-02509431c867 | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | NTAP | NTAP261218P00210000 | put | 210.0000 | 2026-12-18 | 27.3000 | 26.3000 | 27.3000 | 196.0000 | 496850.00 | 496850.00 | 0.00 | 182 | 48 | 182 | 323 | 0.563467492260062 | 0.52956341070059 | 0.52956341070059 | false | false | false | |||||||||||||||||
| 53c3163e-0eca-40b1-b9cd-d3e27c22c203 | 2026-09-21 15:31 | 2026-09-21 15:31 | 2026-09-21 15:31 | NTAP | NTAP261120P00195000 | put | 195.0000 | 2026-11-20 | 13.1300 | 12.8000 | 13.3000 | 197.0000 | 15760.00 | 7860.00 | 7900.00 | 12 | 6 | 70 | 22 | 3.18181818181818 | 0.470355688866471 | 0.467163743754459 | false | false | false | true | ||||||||||||||||
| 625b41a2-3d40-41a1-8a38-2e3bea6f07bb | 2026-09-22 12:05 | 2026-09-22 12:05 | 2026-09-22 12:05 | NTAP | NTAP261016C00210000 | call | 210.0000 | 2026-10-16 | 3.0900 | 3.0000 | 3.1000 | 192.5300 | 15749.00 | 12707.00 | 1212.00 | 51 | 13 | 516 | 3069 | 0.168132942326491 | 0.447317024179783 | 0.447317024179783 | false | false | false | |||||||||||||||||
| 19ed26a6-4278-46fe-a790-59fdfce92051 | 2026-09-22 12:06 | 2026-09-22 12:06 | 2026-09-22 12:06 | NTAP | NTAP261016C00210000 | call | 210.0000 | 2026-10-16 | 3.0800 | 2.9500 | 3.4000 | 192.5300 | 10455.00 | 7045.00 | 3410.00 | 34 | 11 | 613 | 3069 | 0.199739328771587 | 0.447792693707988 | 0.447317024179783 | false | false | false | |||||||||||||||||
| 5fa45798-2e31-4fce-9e23-a0c1960eafd8 | 2026-09-23 14:00 | 2026-09-23 14:00 | 2026-09-23 14:00 | NTAP | NTAP261218P00185000 | put | 185.0000 | 2026-12-18 | 13.3900 | 12.8000 | 13.9000 | 196.9600 | 68310.00 | 64320.00 | 2660.00 | 51 | 21 | 51 | 41 | 1.24390243902439 | 0.533819847752828 | 0.529026405985469 | false | false | false | |||||||||||||||||
| 12cafa03-7ee4-4f76-bbe1-bd8fd2b3c1cd | 2026-09-24 10:08 | 2026-09-24 10:08 | 2026-09-24 10:08 | NTAP | NTAP261016C00200000 | call | 200.0000 | 2026-10-16 | 10.6300 | 9.5000 | 10.7000 | 202.3200 | 62729.00 | 53369.00 | 9360.00 | 59 | 10 | 69 | 579 | 0.119170984455959 | 0.469416834758662 | 0.454031191989207 | true | false | false | |||||||||||||||||
| a614383b-d7a6-4e72-9aeb-b12301eb46bd | 2026-09-24 13:43 | 2026-09-24 13:43 | 2026-09-24 13:43 | NTAP | NTAP261120P00200000 | put | 200.0000 | 2026-11-20 | 15.3300 | 14.9000 | 15.5000 | 198.0800 | 13800.00 | 6120.00 | 7680.00 | 9 | 5 | 21 | 114 | 0.184210526315789 | 0.482724373076527 | 0.479512343457887 | false | false | false | true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38849714999.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38920425841.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38920425841.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 37891190255.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 37891190255.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38562943252.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:04:42.135923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38562943252.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 38562943252.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |