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 | expirydate |
|---|
| 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 |
|---|
| 536c424b-24d9-4571-a3b8-c30a576865ec | 2026-08-28 09:33 | 2026-08-28 09:33 | 2026-08-28 09:33 | NXPI | NXPI270319C00270000 | call | 270.0000 | 2027-03-19 | 16.9000 | 16.9000 | 17.2000 | 225.4200 | 241670.00 | 0.00 | 27040.00 | 143 | 20 | 295 | 17 | 17.3529411764706 | 0.451172992985377 | 0.451172992985377 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56542772736.00 | 2026-10-27 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff76954b-f284-4ff0-b9d2-5896abb1e9a5 | 2026-08-28 09:33 | 2026-08-28 09:33 | 2026-08-28 09:33 | NXPI | NXPI270319C00270000 | call | 270.0000 | 2027-03-19 | 16.6000 | 16.6000 | 17.1000 | 225.4200 | 179280.00 | 0.00 | 97940.00 | 108 | 20 | 152 | 17 | 8.94117647058824 | 0.446487336581964 | 0.446487336581964 | false | false | false | true | ||||||||||||||||
| 7e052079-d1e7-4005-93fa-1ddbcc19c6c1 | 2026-08-28 09:33 | 2026-08-28 09:33 | 2026-08-28 09:33 | NXPI | NXPI270319C00270000 | call | 270.0000 | 2027-03-19 | 16.4000 | 16.4000 | 17.4000 | 225.0300 | 59040.00 | 0.00 | 13120.00 | 36 | 9 | 36 | 17 | 2.11764705882353 | 0.445662699593772 | 0.445662699593772 | false | false | false | true | ||||||||||||||||
| 36c9a069-312d-4192-bd35-bc62c55993cd | 2026-08-27 11:31 | 2026-08-27 11:31 | 2026-08-27 11:31 | NXPI | NXPI261218C00240000 | call | 240.0000 | 2026-12-18 | 18.1000 | 17.5000 | 18.1000 | 227.1700 | 123080.00 | 123080.00 | 0.00 | 68 | 26 | 92 | 45 | 2.04444444444444 | 0.443547567438635 | 0.443547567438635 | false | false | false | true | ||||||||||||||||
| dc6ebc6c-e733-4cad-934b-ae6a63d47002 | 2026-08-20 13:57 | 2026-08-20 13:57 | 2026-08-20 13:57 | NXPI | NXPI261016P00230000 | put | 230.0000 | 2026-10-16 | 17.8000 | 17.8000 | 17.9000 | 224.4150 | 87220.00 | 0.00 | 87220.00 | 49 | 8 | 205 | 592 | 0.346283783783784 | 0.437350341351084 | 0.437350341351084 | false | false | false | true | ||||||||||||||||
| 62be72c5-b07c-4242-a866-7530d6bf4f30 | 2026-08-20 12:57 | 2026-08-20 12:57 | 2026-08-20 12:57 | NXPI | NXPI261016P00230000 | put | 230.0000 | 2026-10-16 | 17.8000 | 17.8000 | 18.3000 | 224.6200 | 58740.00 | 0.00 | 58740.00 | 33 | 12 | 149 | 592 | 0.251689189189189 | 0.440288499841002 | 0.440288499841002 | false | false | false | true | ||||||||||||||||
| 9a969052-2715-4035-b887-af5c38a91f52 | 2026-08-20 11:55 | 2026-08-20 11:55 | 2026-08-20 11:55 | NXPI | NXPI261016P00230000 | put | 230.0000 | 2026-10-16 | 17.6000 | 17.5000 | 17.8000 | 225.1700 | 63360.00 | 8800.00 | 54560.00 | 36 | 8 | 81 | 592 | 0.136824324324324 | 0.442449553793124 | 0.442449553793124 | false | false | false | true | ||||||||||||||||
| 495d1801-82f6-4434-99e5-3797ce51a2ad | 2026-08-19 14:30 | 2026-08-19 14:30 | 2026-08-19 14:30 | NXPI | NXPI270617P00250000 | put | 250.0000 | 2027-06-17 | 50.4000 | 49.9000 | 50.4000 | 226.7150 | 70559.00 | 70559.00 | 0.00 | 14 | 5 | 19 | 26 | 0.730769230769231 | 0.503048573399891 | 0.503048573399891 | false | false | false | true | ||||||||||||||||
| d3bc846f-6664-44ee-90dc-5c2a7f576629 | 2026-08-19 13:55 | 2026-08-19 13:55 | 2026-08-19 13:55 | NXPI | NXPI280121C00290000 | call | 290.0000 | 2028-01-21 | 33.0000 | 31.5000 | 34.5000 | 226.9500 | 151800.00 | 115500.00 | 36300.00 | 46 | 12 | 47 | 216 | 0.217592592592593 | 0.451251590687871 | 0.451251590687871 | false | false | false | true | ||||||||||||||||
| c978a775-8d71-4468-a3ca-55d0f8b22944 | 2026-08-19 13:55 | 2026-08-19 13:55 | 2026-08-19 13:55 | NXPI | NXPI280121P00260000 | put | 260.0000 | 2028-01-21 | 66.1700 | 63.5000 | 66.7000 | 226.9500 | 238219.00 | 172019.00 | 66200.00 | 36 | 9 | 36 | 27 | 1.33333333333333 | 0.51323492673758 | 0.513329004170534 | false | false | false | true | ||||||||||||||||
| 6ef50452-b7d3-44bb-8149-a4104d8e8a3c | 2026-08-19 13:55 | 2026-08-19 13:55 | 2026-08-19 13:55 | NXPI | NXPI280121C00310000 | call | 310.0000 | 2028-01-21 | 28.4000 | 27.2000 | 28.4000 | 226.9500 | 107920.00 | 107920.00 | 0.00 | 38 | 10 | 48 | 538 | 0.0892193308550186 | 0.452218192199841 | 0.452218192199841 | false | false | false | true | ||||||||||||||||
| 6d10549c-65cf-471c-9eea-bf2f40be64fd | 2026-08-19 13:55 | 2026-08-19 13:55 | 2026-08-19 13:55 | NXPI | NXPI280121C00280000 | call | 280.0000 | 2028-01-21 | 35.6000 | 34.0000 | 35.6000 | 226.9500 | 117480.00 | 117480.00 | 0.00 | 33 | 6 | 43 | 13 | 3.30769230769231 | 0.450852418885804 | 0.450852418885804 | false | false | false | true | ||||||||||||||||
| 000d8207-14c6-4e98-adbe-79db1eceb5f8 | 2026-08-19 13:55 | 2026-08-19 13:55 | 2026-08-19 13:55 | NXPI | NXPI280121C00300000 | call | 300.0000 | 2028-01-21 | 30.6000 | 29.4000 | 30.6000 | 226.9500 | 143820.00 | 143820.00 | 0.00 | 47 | 13 | 53 | 34 | 1.55882352941176 | 0.451660303848944 | 0.451660303848944 | false | false | false | true | ||||||||||||||||
| 21793dc9-67ee-4adc-acbb-b6cacadd4920 | 2026-08-19 13:22 | 2026-08-19 13:21 | 2026-08-19 13:21 | NXPI | NXPI261016P00240000 | put | 240.0000 | 2026-10-16 | 22.8000 | 22.8000 | 23.5000 | 227.3300 | 72960.00 | 0.00 | 72960.00 | 32 | 11 | 37 | 156 | 0.237179487179487 | 0.448562716127034 | 0.448562716127034 | false | false | false | true | ||||||||||||||||
| ee756167-b7a5-4997-9d3b-1069e34099e2 | 2026-08-18 11:51 | 2026-08-18 11:50 | 2026-08-18 11:50 | NXPI | NXPI280121P00185000 | put | 185.0000 | 2028-01-21 | 25.0000 | 24.8000 | 26.4000 | 224.8000 | 80000.00 | 2500.00 | 40000.00 | 32 | 18 | 48 | 37 | 1.2972972972973 | 0.492382669626067 | 0.492382669626067 | true | false | false | true | ||||||||||||||||
| d0e28459-e145-4b72-a23e-4fcb8ace49c9 | 2026-08-18 09:50 | 2026-08-18 09:50 | 2026-08-18 09:50 | NXPI | NXPI261218P00190000 | put | 190.0000 | 2026-12-18 | 10.2000 | 7.6000 | 10.3000 | 223.0000 | 247844.00 | 242754.00 | 5090.00 | 243 | 52 | 243 | 329 | 0.738601823708207 | 0.51156612366606 | 0.51156612366606 | false | false | false | true | ||||||||||||||||
| 63dc5cd6-d57c-4444-9a9c-0face0f83b25 | 2026-08-18 09:37 | 2026-08-18 09:37 | 2026-08-18 09:37 | NXPI | NXPI260918P00200000 | put | 200.0000 | 2026-09-18 | 2.5000 | 2.0000 | 2.5000 | 226.9600 | 50250.00 | 50250.00 | 0.00 | 201 | 37 | 226 | 396 | 0.570707070707071 | 0.458514216846717 | 0.458514216846717 | false | false | false | true | ||||||||||||||||
| 2c8bc1d4-5a41-4aeb-a084-ba26bf22b75e | 2026-08-17 11:48 | 2026-08-17 11:48 | 2026-08-17 11:48 | NXPI | NXPI261016P00230000 | put | 230.0000 | 2026-10-16 | 13.1000 | 13.1000 | 13.6000 | 236.4650 | 90400.00 | 1320.00 | 89080.00 | 69 | 28 | 73 | 663 | 0.110105580693816 | 0.44615470773363 | 0.448872263349063 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56542772736.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |