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_alerts658,639 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 |
|---|
| 0295245b-d99d-465d-923c-5e7ddf9cce58 | 2026-09-22 14:25 | 2026-09-22 14:24 | 2026-09-22 14:24 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 9.3000 | 9.1500 | 9.5500 | 741.1150 | 18595.00 | 12090.00 | 5580.00 | 20 | 8 | 6022 | 1552 | 3.88015463917526 | 0.567066707771769 | 0.561953791569923 | true | false | false | true | 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:29:55.439380Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 92a1be44-3081-4e72-92da-e879fee0f207 | 2026-09-22 14:35 | 2026-09-22 14:35 | 2026-09-22 14:35 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 8.4800 | 8.2000 | 8.6000 | 739.4500 | 11020.00 | 7660.00 | 3360.00 | 13 | 5 | 6244 | 1552 | 4.02319587628866 | 0.561503403707527 | 0.571883812211904 | false | false | false | true | ||||||||||||||||
| 9ca6d1d7-e0b8-44fc-9c40-6a8fcdf096bb | 2026-09-22 15:08 | 2026-09-22 15:08 | 2026-09-22 15:08 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 7.5000 | 7.5000 | 7.7500 | 738.2400 | 10504.00 | 0.00 | 10504.00 | 14 | 5 | 7477 | 1552 | 4.81765463917526 | 0.538654510348718 | 0.538654510348718 | false | false | false | true | ||||||||||||||||
| 56f7f930-423a-4b0a-be58-b3236543e1c9 | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 7.3000 | 7.1500 | 7.3000 | 737.7600 | 25550.00 | 25550.00 | 0.00 | 35 | 13 | 7712 | 1552 | 4.96907216494845 | 0.540288393954005 | 0.540288393954005 | true | false | false | true | ||||||||||||||||
| 8422835c-dd05-4b9a-ac1e-e8f51fbe8472 | 2026-09-22 15:26 | 2026-09-22 15:26 | 2026-09-22 15:26 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 8.3000 | 8.1500 | 8.3000 | 739.8200 | 25727.00 | 25727.00 | 0.00 | 31 | 5 | 8168 | 1552 | 5.26288659793814 | 0.545509378461662 | 0.540467722591865 | true | false | false | true | ||||||||||||||||
| 93818e71-b850-4ec7-8e5a-5c2de6b9bf19 | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 8.2000 | 7.8000 | 8.2000 | 739.0000 | 42629.00 | 42629.00 | 0.00 | 52 | 18 | 10108 | 1552 | 6.51288659793814 | 0.546621254275448 | 0.546621254275448 | true | false | false | true | ||||||||||||||||
| c30fba4a-a146-4915-a1fe-e05abc2a4623 | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 7.8000 | 7.8000 | 8.2000 | 737.0000 | 21840.00 | 0.00 | 21840.00 | 28 | 5 | 10138 | 1552 | 6.53221649484536 | 0.521035114917612 | 0.585614923872443 | true | false | false | true | ||||||||||||||||
| 545e4bf2-2ea6-473f-b097-48a003d3e1c8 | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 6.3700 | 6.2500 | 6.4500 | 735.0000 | 103185.00 | 102545.00 | 640.00 | 162 | 6 | 10773 | 1552 | 6.94136597938144 | 0.536859557661564 | 0.534308602551045 | false | false | false | true | ||||||||||||||||
| fe2d3ca7-94b3-4f2d-aa41-c0a8ceb8a9cb | 2026-09-23 09:41 | 2026-09-23 09:41 | 2026-09-23 09:41 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 12.9600 | 12.6000 | 13.0500 | 750.3323 | 12962.00 | 9095.00 | 3867.00 | 10 | 10 | 1245 | 2787 | 0.446716899892357 | 0.845163688898096 | 0.831012873045319 | true | false | false | true | ||||||||||||||||
| cf78cfd2-460f-464d-9794-e3c19bf4408b | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 11.8500 | 11.7500 | 11.8500 | 748.0000 | 11850.00 | 11850.00 | 0.00 | 10 | 5 | 1761 | 2787 | 0.631862217438105 | 0.831376765708906 | 0.831376765708906 | false | false | false | true | ||||||||||||||||
| 30ac12a3-a548-4f8e-9e5b-de2b307855ca | 2026-09-23 10:00 | 2026-09-23 10:00 | 2026-09-23 10:00 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 20.9800 | 20.2500 | 21.7000 | 759.9900 | 113295.00 | 109090.00 | 4205.00 | 54 | 6 | 2194 | 2787 | 0.787226408324363 | 0.97227456399267 | 0.901244338818611 | false | false | false | true | ||||||||||||||||
| d63d9f1d-4742-4117-932d-5b801362c960 | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 6.7700 | 6.7000 | 6.9500 | 741.9600 | 31825.00 | 6850.00 | 24975.00 | 47 | 9 | 2541 | 2787 | 0.911733046286329 | 0.772995719911591 | 0.769317651570887 | true | false | false | true | ||||||||||||||||
| b5aaeb93-bcd1-4e6e-acc5-b974b4003eb1 | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 7.4500 | 7.2500 | 7.4500 | 742.9550 | 12665.00 | 12665.00 | 0.00 | 17 | 11 | 2566 | 2787 | 0.92070326515967 | 0.773988977473493 | 0.773988977473493 | true | false | false | true | ||||||||||||||||
| 31e1dbb2-fb32-4ea2-b4b5-65fb74e855e9 | 2026-09-23 10:25 | 2026-09-23 10:25 | 2026-09-23 10:25 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 8.5400 | 8.4500 | 8.7500 | 745.0000 | 19650.00 | 11120.00 | 5110.00 | 23 | 7 | 2759 | 2787 | 0.989953354861859 | 0.732271140777638 | 0.717811293074601 | false | false | false | true | ||||||||||||||||
| d0d3b0fb-8e21-44cf-82b9-9cb2bb872910 | 2026-09-23 10:26 | 2026-09-23 10:26 | 2026-09-23 10:26 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 9.1300 | 8.8000 | 9.2000 | 745.7500 | 237424.00 | 43444.00 | 193980.00 | 260 | 5 | 3036 | 2787 | 1.08934337997847 | 0.779326052707247 | 0.758996614127743 | false | false | false | true | ||||||||||||||||
| 34adb3b0-f97e-4b9a-be1e-2d7be978d731 | 2026-09-23 10:34 | 2026-09-23 10:34 | 2026-09-23 10:34 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 10.0100 | 9.9000 | 10.2500 | 747.6250 | 160210.00 | 0.00 | 160210.00 | 160 | 8 | 3545 | 2787 | 1.27197703623968 | 0.711586888072066 | 0.728075684503912 | false | false | false | true | ||||||||||||||||
| c7813d17-a483-4a92-8d0a-ab1f8b0ac64c | 2026-09-23 10:38 | 2026-09-23 10:38 | 2026-09-23 10:38 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 8.9400 | 8.7000 | 9.0500 | 746.2700 | 178889.00 | 33899.00 | 144990.00 | 200 | 7 | 3823 | 2787 | 1.37172587011123 | 0.728938565712099 | 0.706644559128593 | false | false | false | true | ||||||||||||||||
| c3b70b67-608e-4d02-8389-6f45247f6e62 | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 11.1900 | 10.7000 | 11.2000 | 749.0350 | 80590.00 | 77275.00 | 3315.00 | 72 | 24 | 4821 | 2787 | 1.72981700753498 | 0.772137821330655 | 0.754799164112878 | false | false | false | true | ||||||||||||||||
| 2127e7d3-fdd5-4c4f-8132-1fd53c485b4c | 2026-09-23 11:04 | 2026-09-23 11:04 | 2026-09-23 11:04 | META | META260923C00740000 | call | 740.0000 | 2026-09-23 | 9.6900 | 9.6000 | 9.8500 | 748.0400 | 25200.00 | 970.00 | 24230.00 | 26 | 5 | 4980 | 2787 | 1.78686759956943 | 0.644669722075458 | 0.651949227733147 | false | false | false | true |
| 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:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| 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-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:26:39.791719Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:29:05.852425Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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:35:38.031989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:39:41.777134Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |