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_alerts375,978 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 |
|---|
| 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 |
|---|
| 4404ccb9-13cb-4e87-ad1e-9f0bf6f8fbd7 | 2026-09-23 14:59 | 2026-09-23 14:59 | 2026-09-23 14:59 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 9.4500 | 9.4000 | 9.4500 | 748.7300 | 10395.00 | 10395.00 | 0.00 | 11 | 7 | 4934 | 1759 | 2.80500284252416 | 0.703533957342977 | 0.703533957342977 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1640836123547.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 52dcc3e1-bcbe-4e2f-9fba-2f7fc8b13008 | 2026-09-23 13:41 | 2026-09-23 13:40 | 2026-09-23 13:40 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 9.5500 | 9.3500 | 9.5500 | 749.0000 | 14325.00 | 14325.00 | 0.00 | 15 | 6 | 4523 | 1759 | 2.57134735645253 | 0.732426324533678 | 0.726966159460915 | true | false | false | |||||||||||||||||
| 3d8f0f83-a16e-4476-92c5-a001fd0b4c82 | 2026-09-23 12:37 | 2026-09-23 12:37 | 2026-09-23 12:37 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 7.1500 | 7.1500 | 7.3000 | 759.2450 | 25740.00 | 0.00 | 25740.00 | 36 | 9 | 4131 | 1759 | 2.34849346219443 | 0.751351893632808 | 0.751351893632808 | false | false | false | |||||||||||||||||
| a5da362b-4e34-4392-8583-454fcd81e762 | 2026-09-23 12:33 | 2026-09-23 12:33 | 2026-09-23 12:33 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 7.5000 | 7.4000 | 7.5500 | 758.5800 | 29250.00 | 29250.00 | 0.00 | 39 | 5 | 3978 | 1759 | 2.26151222285389 | 0.760376823474322 | 0.760376823474322 | true | false | false | |||||||||||||||||
| 6b045271-99ce-4b6a-b4a5-386d840ec235 | 2026-09-23 12:15 | 2026-09-23 12:15 | 2026-09-23 12:15 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 8.6500 | 8.5500 | 8.6500 | 753.8100 | 35465.00 | 35465.00 | 0.00 | 41 | 23 | 3845 | 1759 | 2.18590108015918 | 0.747214107564981 | 0.747214107564981 | true | false | false | |||||||||||||||||
| 05fc6a0d-3f93-448a-a538-661e403e9c8c | 2026-09-23 12:12 | 2026-09-23 12:12 | 2026-09-23 12:12 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 8.7000 | 8.6000 | 8.7000 | 753.9400 | 20880.00 | 20880.00 | 0.00 | 24 | 5 | 3799 | 1759 | 2.15974985787379 | 0.751801309049244 | 0.751801309049244 | false | false | false | |||||||||||||||||
| b41f7e03-cd9b-49ad-a7ed-c362681155c9 | 2026-09-23 11:51 | 2026-09-23 11:51 | 2026-09-23 11:51 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 8.3000 | 8.1500 | 8.3000 | 754.0000 | 30710.00 | 30710.00 | 0.00 | 37 | 17 | 3732 | 1759 | 2.12166003411029 | 0.746483214555324 | 0.746483214555324 | true | false | false | |||||||||||||||||
| db77a0e8-323e-4fab-8bb7-ab0c0cd9bb12 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 13.8000 | 13.6500 | 13.8000 | 739.8200 | 19320.00 | 19320.00 | 0.00 | 14 | 6 | 4802 | 221 | 21.7285067873303 | 0.607739684301597 | 0.607739684301597 | true | false | false | |||||||||||||||||
| 3ab6423d-c1a8-4486-94b7-50752bb6e3d3 | 2026-09-22 14:20 | 2026-09-22 14:20 | 2026-09-22 14:20 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 13.5000 | 12.9500 | 13.5000 | 740.6800 | 82350.00 | 82350.00 | 0.00 | 61 | 29 | 4464 | 221 | 20.1990950226244 | 0.615940418576881 | 0.61056058543585 | true | false | false | |||||||||||||||||
| b6c61993-61c0-44fb-b75c-7196ee9159c1 | 2026-09-22 12:11 | 2026-09-22 12:11 | 2026-09-22 12:11 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 10.4000 | 9.9500 | 10.4000 | 748.4500 | 15600.00 | 15600.00 | 0.00 | 15 | 5 | 3372 | 221 | 15.2579185520362 | 0.60930227640923 | 0.60930227640923 | false | false | false | |||||||||||||||||
| 279698f7-2f42-48d5-a11a-b9aaec521e37 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 11.0000 | 10.8000 | 11.2000 | 749.4900 | 20906.00 | 9920.00 | 10986.00 | 19 | 6 | 113 | 221 | 0.51131221719457 | 0.642122999042591 | 0.649623839267918 | false | false | false | |||||||||||||||||
| 062d7537-980d-4774-9187-16f03bcae3e5 | 2026-09-21 15:31 | 2026-09-21 15:31 | 2026-09-21 15:31 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 12.7500 | 12.7500 | 12.9000 | 747.0000 | 17855.00 | 0.00 | 16575.00 | 14 | 6 | 1106 | 4 | 276.5 | 0.600796170403776 | 0.600796170403776 | false | false | false | |||||||||||||||||
| 9f7fbdb6-5da8-46a9-abee-de9878a59b9b | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 13.4500 | 13.4500 | 13.6000 | 745.3300 | 16140.00 | 0.00 | 16140.00 | 12 | 12 | 1076 | 4 | 269 | 0.591706187179295 | 0.591706187179295 | false | false | false | |||||||||||||||||
| b3ec2d39-7b2f-49e7-adc3-3f7af7d47307 | 2026-09-21 15:20 | 2026-09-21 15:20 | 2026-09-21 15:20 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 13.8500 | 13.7500 | 13.9000 | 743.9900 | 30470.00 | 29085.00 | 1385.00 | 22 | 8 | 1056 | 4 | 264 | 0.588541014184262 | 0.587128427561686 | true | false | false | |||||||||||||||||
| 4af5ee75-1143-40d5-b584-8f6e70c81d8e | 2026-09-21 13:50 | 2026-09-21 13:49 | 2026-09-21 13:49 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 16.0000 | 15.8000 | 16.0500 | 740.4800 | 16000.00 | 14400.00 | 1600.00 | 10 | 7 | 704 | 4 | 176 | 0.609037438863518 | 0.609037438863518 | false | false | false | |||||||||||||||||
| 4dc8b3c8-e3ae-48cd-afe0-2c823f404b9a | 2026-09-21 13:48 | 2026-09-21 13:47 | 2026-09-21 13:47 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 15.5000 | 15.3000 | 15.5000 | 742.1700 | 17050.00 | 17050.00 | 0.00 | 11 | 7 | 675 | 4 | 168.75 | 0.618299586970424 | 0.616556664902532 | true | false | false | |||||||||||||||||
| 92d8616e-2863-437b-bce9-e13399a8df29 | 2026-09-21 13:24 | 2026-09-21 13:24 | 2026-09-21 13:24 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 17.1000 | 16.9500 | 17.1000 | 736.0000 | 17100.00 | 17100.00 | 0.00 | 10 | 10 | 396 | 4 | 99 | 0.588931767404807 | 0.588931767404807 | false | false | false | |||||||||||||||||
| 4cbe0309-6c25-4067-b5a2-cea534c12908 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 17.9500 | 17.9500 | 18.1000 | 734.6259 | 32310.00 | 0.00 | 32310.00 | 18 | 7 | 227 | 4 | 56.75 | 0.584248162126705 | 0.584248162126705 | true | false | false | |||||||||||||||||
| 9052c158-a541-4bcb-92af-df4de63246ce | 2026-09-21 13:10 | 2026-09-21 13:10 | 2026-09-21 13:10 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 18.4500 | 18.3000 | 18.4500 | 733.6750 | 12915.00 | 12915.00 | 0.00 | 7 | 7 | 197 | 4 | 49.25 | 0.585281964571616 | 0.585281964571616 | false | false | false | |||||||||||||||||
| a6e5d3c2-3d17-4bab-b056-87b389d8580b | 2026-09-21 12:41 | 2026-09-21 12:41 | 2026-09-21 12:41 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 20.5000 | 20.3000 | 21.1000 | 728.5600 | 22550.00 | 4100.00 | 18450.00 | 11 | 7 | 94 | 4 | 23.5 | 0.565218574730331 | 0.565218574730331 | true | false | false | |||||||||||||||||
| b00d6387-ea7d-4b73-bf13-4fb1dcc55b43 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 22.4500 | 22.4250 | 22.6000 | 724.5000 | 22450.00 | 0.00 | 22450.00 | 10 | 10 | 71 | 4 | 17.75 | 0.552969583365328 | 0.553858146940043 | false | false | false | |||||||||||||||||
| 85aad44d-777f-40e4-a7ab-6c78cacdf1ca | 2026-09-21 10:20 | 2026-09-21 10:20 | 2026-09-21 10:20 | META | META260925P00735000 | put | 735.0000 | 2026-09-25 | 30.4600 | 30.3500 | 30.6500 | 711.3950 | 15230.00 | 3045.00 | 12185.00 | 5 | 5 | 26 | 4 | 6.5 | 0.537175163109733 | 0.537175163109733 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:43:03.709156Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:19:07.705108Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:54:47.930702Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:55:32.885478Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |