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_alerts566,287 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 |
|---|
| 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 |
|---|
| 4f37333f-3806-4507-be70-685c337a1445 | 2026-09-17 09:30 | 2026-09-17 09:30 | 2026-09-17 09:30 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 10.0500 | 9.6500 | 10.0500 | 367.6300 | 185906.00 | 185906.00 | 0.00 | 185 | 16 | 308 | 2077 | 0.148290804044295 | 0.438569219285823 | 0.438569219285823 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1446324255683.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 446058f8-8fd9-4e75-9880-cf6396fe51e7 | 2026-09-18 14:54 | 2026-09-18 14:54 | 2026-09-18 14:54 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 7.3900 | 7.3000 | 7.4500 | 363.5000 | 185590.00 | 184110.00 | 1480.00 | 251 | 47 | 2218 | 2931 | 0.756738314568407 | 0.419418665032126 | 0.419418665032126 | false | false | false | |||||||||||||||||
| 5dd39290-b789-490e-bce5-e0389009f2dc | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 12.0900 | 11.9500 | 12.1000 | 375.3900 | 38700.00 | 38700.00 | 0.00 | 32 | 5 | 1711 | 3314 | 0.516294508147254 | 0.449725547467044 | 0.44934002321179 | true | false | false | |||||||||||||||||
| 508f083c-ea9d-45d4-911f-3e92833187ae | 2026-09-21 10:56 | 2026-09-21 10:56 | 2026-09-21 10:56 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 12.1800 | 12.1000 | 12.3000 | 375.7800 | 13396.00 | 0.00 | 13396.00 | 11 | 5 | 1760 | 3314 | 0.531080265540133 | 0.445617849949022 | 0.444846837558673 | false | false | false | |||||||||||||||||
| 83567f5f-7f64-40d2-82ec-538529eb4de0 | 2026-09-24 13:23 | 2026-09-24 13:23 | 2026-09-24 13:23 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 13.5500 | 13.5500 | 13.7000 | 381.5750 | 25753.00 | 0.00 | 25753.00 | 19 | 5 | 2058 | 3316 | 0.620627261761158 | 0.435373233013102 | 0.435373233013102 | false | false | false | |||||||||||||||||
| 887f66fa-738d-4f80-9f14-2dbf790eff37 | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 8.1600 | 8.0000 | 8.2000 | 371.3700 | 25300.00 | 20500.00 | 4800.00 | 31 | 5 | 1577 | 3353 | 0.470325082016105 | 0.471479506554267 | 0.464830015697883 | false | false | false | |||||||||||||||||
| 8a74a0ff-3a5d-428d-8e39-4679d8d7dda7 | 2026-09-25 10:11 | 2026-09-25 10:11 | 2026-09-25 10:11 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 9.0500 | 9.0500 | 9.1500 | 373.5600 | 24438.00 | 0.00 | 24438.00 | 27 | 8 | 4069 | 3353 | 1.21354011333135 | 0.466694277729782 | 0.465240493340255 | true | false | false | |||||||||||||||||
| 25f970ff-1011-4604-b0e7-1be1052dec1f | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 8.5200 | 8.4000 | 8.5500 | 373.3350 | 16195.00 | 16195.00 | 0.00 | 19 | 8 | 9088 | 3353 | 2.71040858932299 | 0.447187524569276 | 0.444903430232479 | false | false | false | |||||||||||||||||
| 0ec217be-53fe-4604-8231-ef84c9606935 | 2026-09-29 11:24 | 2026-09-29 11:23 | 2026-09-29 11:23 | TSLA | TSLA261002C00375000 | call | 375.0000 | 2026-10-02 | 0.8500 | 0.8800 | 0.9100 | 353.4700 | 24473.00 | 1246.00 | 23227.00 | 287 | 33 | 5685 | 8135 | 0.698832206515058 | 0.522582793743256 | 0.521140760375631 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1438701629212.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1482265136968.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1482265136968.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:26:09.725902Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:24:07.836531Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |