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 |
|---|
| c4032dee-4550-4744-afb5-38d4339489c9 | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 9.0000 | 8.5500 | 9.1000 | 753.0000 | 31485.00 | 26990.00 | 4495.00 | 35 | 15 | 970 | 5708 | 0.169936930623686 | 0.527159433452783 | 0.52688765135362 | true | false | false | true | 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 |
| 4c1c9496-161d-4134-8b00-cb0822c80aa9 | 2026-09-23 11:40 | 2026-09-23 11:40 | 2026-09-23 11:40 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 10.2500 | 10.1500 | 10.5500 | 754.9500 | 208151.00 | 0.00 | 208151.00 | 203 | 5 | 4677 | 5708 | 0.81937631394534 | 0.547442456974007 | 0.550257862322424 | false | false | false | |||||||||||||||||
| 96055351-e4d8-4e8e-bb08-c5a7a8e45dcc | 2026-09-23 11:56 | 2026-09-23 11:56 | 2026-09-23 11:56 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 10.3000 | 10.0500 | 10.5500 | 755.8100 | 51490.00 | 0.00 | 10290.00 | 50 | 6 | 4824 | 5708 | 0.845129642606868 | 0.545102788438293 | 0.545102788438293 | false | false | false | |||||||||||||||||
| b830946f-282f-4685-85d0-c0a0a68b8037 | 2026-09-23 13:27 | 2026-09-23 13:27 | 2026-09-23 13:27 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 7.5500 | 7.6000 | 7.9000 | 746.0000 | 77045.00 | 1530.00 | 75515.00 | 102 | 17 | 6465 | 5708 | 1.13262088297127 | 0.532149770542092 | 0.535028087673749 | true | false | false | |||||||||||||||||
| e5ffe69f-1a65-440d-b3bf-d617f5d8ed22 | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 10.4900 | 9.7000 | 10.5500 | 763.6750 | 19930.00 | 19930.00 | 0.00 | 19 | 6 | 1828 | 6312 | 0.289607097591888 | 0.52790372274958 | 0.52723866102989 | true | false | false | |||||||||||||||||
| 1737f7cb-058a-401b-a36d-fdb3fbe239c0 | 2026-09-24 10:02 | 2026-09-24 10:02 | 2026-09-24 10:02 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 9.8200 | 9.6000 | 9.9000 | 762.2700 | 12771.00 | 8846.00 | 3925.00 | 13 | 10 | 4836 | 6312 | 0.766159695817491 | 0.518221918874138 | 0.518747404861031 | false | false | false | |||||||||||||||||
| 19f020d2-e8fb-4a10-b428-a2d29e8dd936 | 2026-09-24 10:20 | 2026-09-24 10:20 | 2026-09-24 10:20 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 10.7100 | 10.5500 | 10.7500 | 765.3400 | 10706.00 | 10706.00 | 0.00 | 10 | 5 | 5691 | 6312 | 0.901615969581749 | 0.518475911968121 | 0.518475911968121 | false | false | false | |||||||||||||||||
| 4b0d85b4-d112-4311-b70b-9c5a8a4b12b1 | 2026-09-24 10:53 | 2026-09-24 10:53 | 2026-09-24 10:53 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 11.5100 | 11.5000 | 11.8000 | 768.8184 | 236015.00 | 0.00 | 236015.00 | 205 | 51 | 7229 | 6312 | 1.14527883396705 | 0.51167885265355 | 0.51340410379496 | true | false | false | |||||||||||||||||
| 75cb6477-14d0-4c1a-9a50-47c50cba8a55 | 2026-09-24 10:54 | 2026-09-24 10:54 | 2026-09-24 10:54 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 11.9800 | 11.8000 | 12.0000 | 769.7598 | 89845.00 | 89845.00 | 0.00 | 75 | 28 | 7397 | 6312 | 1.1718948035488 | 0.515308405595144 | 0.516528047405051 | false | false | false | |||||||||||||||||
| 8d6e9fd1-3d23-4ba8-95a9-e76b89956934 | 2026-09-24 11:00 | 2026-09-24 11:00 | 2026-09-24 11:00 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 11.4100 | 11.3000 | 11.7000 | 768.0600 | 14830.00 | 2285.00 | 12545.00 | 13 | 7 | 8644 | 6312 | 1.36945500633714 | 0.512865564284362 | 0.515124177731319 | true | false | false | |||||||||||||||||
| f941b2a9-47f8-488e-8331-a5b1c3b94a62 | 2026-09-24 14:12 | 2026-09-24 14:12 | 2026-09-24 14:12 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 11.9200 | 11.7500 | 12.0000 | 773.4400 | 119154.00 | 119154.00 | 0.00 | 100 | 9 | 12269 | 6312 | 1.94375792141952 | 0.484969031869897 | 0.484969031869897 | false | false | false | |||||||||||||||||
| fed491cf-9336-4016-abcd-a3364e2a10ce | 2026-09-24 15:15 | 2026-09-24 15:15 | 2026-09-24 15:15 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 13.9900 | 13.6000 | 14.0500 | 778.4800 | 30769.00 | 27979.00 | 2790.00 | 22 | 12 | 13372 | 6312 | 2.11850443599493 | 0.490939035627961 | 0.490939035627961 | true | false | false | |||||||||||||||||
| f749cc25-bf3f-4521-af90-fb4d5d127a43 | 2026-09-24 15:40 | 2026-09-24 15:40 | 2026-09-24 15:40 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 13.1500 | 12.9000 | 13.3500 | 776.0000 | 26310.00 | 26310.00 | 0.00 | 20 | 7 | 13822 | 6312 | 2.18979721166033 | 0.488777907814794 | 0.488777907814794 | false | false | false | |||||||||||||||||
| c9d7194e-c8cd-45df-b23d-42a17efc5d83 | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 5.2900 | 5.2000 | 5.3000 | 755.7600 | 11648.00 | 10598.00 | 0.00 | 22 | 8 | 2422 | 7554 | 0.320624834524755 | 0.463518103221777 | 0.46488232764132 | false | false | false | |||||||||||||||||
| a2ff15ee-9244-4198-a525-067cd2ed874f | 2026-09-25 12:13 | 2026-09-25 12:13 | 2026-09-25 12:13 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.4300 | 3.3500 | 3.4500 | 749.0000 | 68547.00 | 68547.00 | 0.00 | 200 | 16 | 15248 | 7554 | 2.01853322742918 | 0.436613120907148 | 0.438269946285055 | false | false | false | |||||||||||||||||
| c414c558-1280-4940-bb4b-194b3b41aa2f | 2026-09-25 12:16 | 2026-09-25 12:16 | 2026-09-25 12:16 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.6000 | 3.5000 | 3.6000 | 750.2050 | 179869.00 | 179869.00 | 0.00 | 500 | 48 | 15804 | 7554 | 2.09213661636219 | 0.436953390759595 | 0.438975869893087 | true | false | false | |||||||||||||||||
| 3cfb0daa-3c09-4f7d-b81e-be7e6db7a791 | 2026-09-25 12:21 | 2026-09-25 12:21 | 2026-09-25 12:21 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.3500 | 3.3500 | 3.4500 | 748.3001 | 167508.00 | 0.00 | 167508.00 | 500 | 9 | 17712 | 7554 | 2.34471803018268 | 0.44051054772809 | 0.44051054772809 | false | false | false | |||||||||||||||||
| 81e03f1b-ddff-4f01-bfd8-295d3e95fc26 | 2026-09-25 12:22 | 2026-09-25 12:22 | 2026-09-25 12:22 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.3500 | 3.3500 | 3.4500 | 748.7701 | 163568.00 | 0.00 | 163568.00 | 488 | 22 | 19215 | 7554 | 2.54368546465449 | 0.436906480588421 | 0.438452039460991 | false | false | false | |||||||||||||||||
| b518cb33-6dfa-4a8e-9d64-0b9dfd99c038 | 2026-09-25 15:56 | 2026-09-25 15:56 | 2026-09-25 15:56 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.6800 | 3.6000 | 3.7000 | 751.7900 | 166664.00 | 165207.00 | 1092.00 | 453 | 37 | 25917 | 7554 | 3.43089753772836 | 0.430556515197062 | 0.432993250109318 | true | false | false | |||||||||||||||||
| abadce54-fb7b-4f2a-9725-85d3ec555f30 | 2026-09-25 15:58 | 2026-09-25 15:58 | 2026-09-25 15:58 | META | META261002C00800000 | call | 800.0000 | 2026-10-02 | 3.7100 | 3.7000 | 3.8000 | 751.0000 | 77940.00 | 0.00 | 77940.00 | 210 | 25 | 27326 | 7554 | 3.61742123378343 | 0.433056435438288 | 0.433056435438288 | false | false | false |
| 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:41:14.023510Z"} |
| 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:00:35.931587Z"} |
| 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-23T17:31:46.460740Z"} |
| 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-24T13:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:04:09.722188Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:21:25.715883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T15:01:26.561696Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:18:06.291601Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |