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_alerts609,118 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 |
|---|
| fed319bb-fe7b-4577-98a1-24af45502e7d | 2026-09-02 14:23 | 2026-09-02 14:23 | 2026-09-02 14:23 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 2.2000 | 1.9000 | 2.2000 | 183.5100 | 10558.00 | 10558.00 | 0.00 | 48 | 7 | 1864 | 4050 | 0.460246913580247 | 0.774058341459556 | 0.775163539779713 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:39:55.300995Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e6e6c31f-2276-4c9b-b5a9-f52c53cf101d | 2026-09-02 14:05 | 2026-09-02 14:05 | 2026-09-02 14:05 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 2.1500 | 1.9500 | 2.2500 | 183.0900 | 11180.00 | 8815.00 | 2365.00 | 52 | 11 | 1794 | 4050 | 0.442962962962963 | 0.776659962260421 | 0.776659962260421 | false | false | false | |||||||||||||||||
| 3174c528-e484-4065-a2df-20294e95f7a1 | 2026-09-02 12:03 | 2026-09-02 12:03 | 2026-09-02 12:03 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 2.0500 | 2.0500 | 2.2500 | 182.6500 | 12710.00 | 0.00 | 12710.00 | 62 | 13 | 163 | 4050 | 0.0402469135802469 | 0.77266808057203 | 0.77266808057203 | false | false | false | |||||||||||||||||
| 04e89acf-185f-41d2-9456-55c9c7cdc58b | 2026-08-27 14:44 | 2026-08-27 14:44 | 2026-08-27 14:44 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 3.4000 | 3.4000 | 3.6000 | 189.2900 | 19040.00 | 0.00 | 9520.00 | 56 | 13 | 1159 | 6830 | 0.169692532942899 | 0.67880525960154 | 0.673026713465455 | false | false | false | |||||||||||||||||
| 3e0f9160-2e73-454b-9aa0-11def0432444 | 2026-08-27 14:43 | 2026-08-27 14:43 | 2026-08-27 14:43 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 3.4000 | 2.4000 | 3.5000 | 188.9200 | 65620.00 | 63920.00 | 1700.00 | 193 | 11 | 1093 | 6830 | 0.160029282576867 | 0.67880525960154 | 0.67880525960154 | false | false | false | |||||||||||||||||
| 81c9a38b-2eb3-48b9-a5d2-38d5da620122 | 2026-08-27 14:43 | 2026-08-27 14:43 | 2026-08-27 14:43 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 3.3000 | 2.0500 | 3.6000 | 188.9200 | 47190.00 | 18810.00 | 1320.00 | 143 | 22 | 900 | 6830 | 0.131771595900439 | 0.671226460764106 | 0.671226460764106 | 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 | |||||||||||||||||
| 1d4ca07b-5655-4517-81bb-268916926bf3 | 2026-08-26 15:18 | 2026-08-26 15:17 | 2026-08-26 15:17 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 4.7000 | 4.4000 | 4.7000 | 194.4100 | 23500.00 | 23500.00 | 0.00 | 50 | 21 | 169 | 6885 | 0.0245461147421932 | 0.664979302297291 | 0.664979302297291 | false | false | false | |||||||||||||||||
| 6c21a188-6681-4022-bd1d-01f72e6a4017 | 2026-08-26 15:17 | 2026-08-26 15:17 | 2026-08-26 15:17 | NTAP | NTAP260918C00220000 | call | 220.0000 | 2026-09-18 | 4.6000 | 4.5000 | 4.7000 | 194.4100 | 24380.00 | 23920.00 | 460.00 | 53 | 17 | 100 | 6885 | 0.0145243282498184 | 0.660282515614209 | 0.658647509970687 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 36980788166.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |