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_alerts474,253 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 |
|---|
| 695d3fac-bd77-4244-bf05-d65cf2bb8323 | 2026-09-21 15:52 | 2026-09-21 15:52 | 2026-09-21 15:52 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 7.2500 | 7.1500 | 7.2500 | 750.1550 | 72487.00 | 71767.00 | 0.00 | 100 | 7 | 4802 | 13 | 369.384615384615 | 0.595144414641326 | 0.593173433022001 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:52:57.186278Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b2e89979-fab6-4e3c-bc9f-2ab1f954c3e7 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 2.0000 | 1.9200 | 2.0000 | 750.0000 | 40799.00 | 40799.00 | 0.00 | 204 | 5 | 4889 | 2669 | 1.83177219932559 | 0.890438737251362 | 0.883045442602168 | false | false | false | |||||||||||||||||
| a29c9eb0-77b3-4b6e-80c1-68eb8124b36e | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 3.0000 | 2.9100 | 3.0000 | 754.0000 | 26963.00 | 23395.00 | 3568.00 | 90 | 13 | 6213 | 2669 | 2.32783814162608 | 0.862119551187458 | 0.867606693672188 | false | false | false | |||||||||||||||||
| d0ca8ed5-29f3-464f-9c73-fb8e12e847b1 | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 4.0000 | 3.8750 | 4.0000 | 757.8700 | 15994.00 | 15994.00 | 0.00 | 40 | 7 | 9566 | 2669 | 3.58411390033721 | 0.86408000218534 | 0.872220431298623 | false | false | false | |||||||||||||||||
| 25f4d86c-16dc-4326-b558-3e09df6e0447 | 2026-09-23 09:56 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 5.1300 | 5.1000 | 5.1500 | 760.8974 | 18472.00 | 17960.00 | 512.00 | 36 | 6 | 10899 | 2669 | 4.08355189209442 | 0.870908684607939 | 0.87219247650062 | false | false | false | |||||||||||||||||
| 65fbe480-b4ce-4720-b456-48f0f680ac7b | 2026-09-23 09:56 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 5.9500 | 5.8500 | 6.2500 | 762.6250 | 13695.00 | 600.00 | 13095.00 | 23 | 5 | 11370 | 2669 | 4.26002248032971 | 0.886726273861812 | 0.888272805119115 | false | false | false | |||||||||||||||||
| d700594a-e58b-490e-b627-d29f586581c6 | 2026-09-23 09:57 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 6.3200 | 6.3000 | 6.4500 | 763.3900 | 21496.00 | 2556.00 | 18940.00 | 34 | 6 | 11620 | 2669 | 4.3536905207943 | 0.881932710330268 | 0.884439098394338 | false | false | false | |||||||||||||||||
| 86486b92-d87a-4099-aea4-48b0c422de5a | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 5.8700 | 5.8500 | 6.0500 | 762.7000 | 10573.00 | 0.00 | 10573.00 | 18 | 5 | 13717 | 2669 | 5.13937804421132 | 0.882672094865289 | 0.875882440411509 | false | false | false | |||||||||||||||||
| e09d5336-2722-4323-9922-f8fc37a0fdec | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 6.0100 | 5.8500 | 6.1000 | 762.6299 | 16234.00 | 15634.00 | 600.00 | 27 | 5 | 13972 | 2669 | 5.2349194454852 | 0.896817912474136 | 0.893022135606101 | false | false | false | |||||||||||||||||
| 22481591-458b-43d4-8d7c-b0128f48f1e5 | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 2.7500 | 2.6900 | 2.7600 | 753.6600 | 14868.00 | 12420.00 | 0.00 | 54 | 7 | 16445 | 2669 | 6.16148370176096 | 0.877400116214107 | 0.887838022906372 | true | false | false | |||||||||||||||||
| 770edd55-6f55-447d-8ef3-14256529c44f | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 3.3900 | 3.2000 | 3.4000 | 755.8150 | 45420.00 | 39100.00 | 2970.00 | 134 | 19 | 16948 | 2669 | 6.34994379917572 | 0.884628452932191 | 0.878252435887644 | false | false | false | |||||||||||||||||
| 79ba03a9-8c03-469a-97a5-43df00aa7380 | 2026-09-23 11:20 | 2026-09-23 11:20 | 2026-09-23 11:20 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 1.2700 | 1.1500 | 1.3200 | 753.5450 | 13980.00 | 13854.00 | 126.00 | 110 | 19 | 34407 | 2669 | 12.8913450730611 | 0.727708140218198 | 0.74123017305272 | true | false | false | |||||||||||||||||
| 3da869cc-51ee-4cfd-b3f5-b543b19d5f63 | 2026-09-23 11:21 | 2026-09-23 11:21 | 2026-09-23 11:21 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 1.9800 | 1.9300 | 2.0000 | 756.1550 | 20608.00 | 17708.00 | 2900.00 | 104 | 9 | 35750 | 2669 | 13.3945297864369 | 0.73774759318999 | 0.755540538101782 | true | false | false | |||||||||||||||||
| a9f30df0-ee19-4fa8-b13e-a34195eab6eb | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 2.2000 | 2.1000 | 2.2200 | 757.3450 | 24663.00 | 21205.00 | 1308.00 | 112 | 8 | 39800 | 2669 | 14.9119520419633 | 0.740512958174382 | 0.735085066779834 | false | false | false | |||||||||||||||||
| 8684d5df-3d62-4a90-8191-e0c1bea24191 | 2026-09-23 12:33 | 2026-09-23 12:33 | 2026-09-23 12:33 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 1.7700 | 1.6800 | 1.8000 | 758.5550 | 27685.00 | 27511.00 | 174.00 | 156 | 20 | 54904 | 2669 | 20.5710003746722 | 0.67997228534801 | 0.708409641308982 | true | false | false | |||||||||||||||||
| 713a6b4f-1cb9-4373-8e74-f3982787467c | 2026-09-23 12:33 | 2026-09-23 12:33 | 2026-09-23 12:33 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 1.8400 | 1.7800 | 1.8600 | 758.5800 | 11226.00 | 5766.00 | 0.00 | 61 | 5 | 55054 | 2669 | 20.6272011989509 | 0.711266445521876 | 0.719189076773643 | false | false | false | |||||||||||||||||
| 6ce8936c-20d5-4b59-9d41-7e7395fa852d | 2026-09-23 12:35 | 2026-09-23 12:35 | 2026-09-23 12:35 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 2.0000 | 1.8900 | 2.0600 | 759.3000 | 19412.00 | 19211.00 | 201.00 | 97 | 26 | 55982 | 2669 | 20.9748969651555 | 0.723868598476385 | 0.71111651319773 | false | false | false | |||||||||||||||||
| 522f8257-1338-4717-896b-eb01c80144e5 | 2026-09-23 12:35 | 2026-09-23 12:35 | 2026-09-23 12:35 | META | META260923C00765000 | call | 765.0000 | 2026-09-23 | 1.8900 | 1.7500 | 1.9300 | 759.0000 | 22538.00 | 22538.00 | 0.00 | 119 | 6 | 55884 | 2669 | 20.9381790932934 | 0.719575042720538 | 0.712766854405079 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:57:01.829367Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:57:01.829367Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T13:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |