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 | strike |
|---|
| 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 |
|---|
| c5055128-64eb-4600-a4ad-f61b01073159 | 2026-09-25 15:57 | 2026-09-25 15:57 | 2026-09-25 15:57 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 34.6000 | 34.4000 | 34.6000 | 751.6050 | 69200.00 | 69200.00 | 0.00 | 20 | 8 | 530 | 1873 | 0.282968499733049 | 0.393711621093699 | 0.392070443046746 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 1856dfdb-e629-4789-9684-abb14616283c | 2026-09-25 15:56 | 2026-09-25 15:56 | 2026-09-25 15:56 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 34.6500 | 33.8500 | 34.6500 | 751.7801 | 235620.00 | 235620.00 | 0.00 | 68 | 22 | 510 | 1873 | 0.272290443139349 | 0.394106969963993 | 0.394106969963993 | true | false | false | |||||||||||||||||
| 59e093d7-a79d-48d5-8556-2da021c8d31a | 2026-09-25 15:28 | 2026-09-25 15:28 | 2026-09-25 15:28 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 34.9500 | 34.7000 | 34.9500 | 751.3164 | 55918.00 | 55918.00 | 0.00 | 16 | 7 | 424 | 1873 | 0.226374799786439 | 0.394761717267629 | 0.39462163735261 | true | false | false | |||||||||||||||||
| b18803dc-3b9e-4d20-a5fd-fcbc3d2fc863 | 2026-09-25 13:42 | 2026-09-25 13:41 | 2026-09-25 13:41 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 35.6000 | 35.3500 | 35.6500 | 749.1811 | 17800.00 | 10685.00 | 7115.00 | 5 | 5 | 377 | 1873 | 0.201281366791244 | 0.390723116328193 | 0.387264053853976 | false | false | false | |||||||||||||||||
| f355b20a-54ec-491c-b30c-532e49a4c517 | 2026-09-25 12:20 | 2026-09-25 12:20 | 2026-09-25 12:20 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 36.5000 | 36.3500 | 36.5500 | 748.7700 | 18250.00 | 10950.00 | 7300.00 | 5 | 5 | 330 | 1873 | 0.176187933796049 | 0.396714240704038 | 0.396714240704038 | false | false | false | |||||||||||||||||
| 9f484caa-9086-46df-b28f-63308a66bb89 | 2026-09-25 10:36 | 2026-09-25 10:36 | 2026-09-25 10:36 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 35.1500 | 34.9000 | 35.5500 | 751.9300 | 17575.00 | 3515.00 | 14060.00 | 5 | 5 | 226 | 1873 | 0.120662039508809 | 0.400681283772415 | 0.402237944084848 | true | false | false | |||||||||||||||||
| 6e3a9b99-95e0-4b8c-89a0-59946dfc5f25 | 2026-09-25 10:19 | 2026-09-25 10:19 | 2026-09-25 10:19 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 35.2100 | 35.1000 | 35.4500 | 751.9700 | 31690.00 | 10575.00 | 21115.00 | 9 | 5 | 206 | 1873 | 0.109983982915109 | 0.403938540768628 | 0.403239824907273 | true | false | false | |||||||||||||||||
| 58d77d5f-0210-4fd5-8b70-aa647b0084c1 | 2026-09-25 09:45 | 2026-09-25 09:45 | 2026-09-25 09:45 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 34.3500 | 34.1000 | 34.4500 | 755.3700 | 34350.00 | 27480.00 | 6870.00 | 10 | 7 | 122 | 1873 | 0.0651361452215697 | 0.416558376175785 | 0.416558376175785 | false | false | false | |||||||||||||||||
| 3e25ed31-f66a-4cc9-8731-eeb928c685be | 2026-09-25 09:45 | 2026-09-25 09:44 | 2026-09-25 09:45 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 33.9700 | 33.7500 | 34.3500 | 755.9300 | 16985.00 | 10190.00 | 6795.00 | 5 | 5 | 111 | 1873 | 0.0592632140950347 | 0.415303446714922 | 0.416436205607667 | false | false | false | |||||||||||||||||
| ba1285f9-1208-4eba-9b67-750e84278ff9 | 2026-09-25 09:32 | 2026-09-25 09:32 | 2026-09-25 09:32 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 33.9100 | 33.8500 | 34.3500 | 756.4500 | 193300.00 | 13565.00 | 179735.00 | 57 | 8 | 85 | 1873 | 0.0453817405232248 | 0.417388802789672 | 0.417388802789672 | false | false | false | |||||||||||||||||
| 7bfe18c1-c6a8-4eb7-af55-cee98560a515 | 2026-09-24 14:39 | 2026-09-24 14:39 | 2026-09-24 14:39 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 27.0000 | 27.0000 | 27.5000 | 776.3900 | 13500.00 | 0.00 | 13500.00 | 5 | 5 | 2201 | 181 | 12.1602209944751 | 0.440512620830806 | 0.440512620830806 | true | false | false | |||||||||||||||||
| c8d7c94e-fbdb-4957-a0dc-8d94eef4229a | 2026-09-24 14:11 | 2026-09-24 14:11 | 2026-09-24 14:11 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 28.1500 | 28.1500 | 28.6500 | 772.7818 | 47855.00 | 0.00 | 47855.00 | 17 | 13 | 2118 | 181 | 11.7016574585635 | 0.435415906171715 | 0.435415906171715 | true | false | false | |||||||||||||||||
| 2e888f4b-dbad-43d7-b683-351dc2c34a04 | 2026-09-24 13:06 | 2026-09-24 13:06 | 2026-09-24 13:06 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 28.7000 | 28.7000 | 29.0500 | 773.0000 | 83230.00 | 0.00 | 83230.00 | 29 | 8 | 2067 | 181 | 11.4198895027624 | 0.44405246722855 | 0.44405246722855 | false | false | false | |||||||||||||||||
| 1f2e10c8-9898-4ccd-981e-d7dbb1b586ed | 2026-09-23 14:16 | 2026-09-23 14:16 | 2026-09-23 14:16 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 42.2500 | 42.2000 | 42.4500 | 749.9399 | 50700.00 | 0.00 | 46475.00 | 12 | 8 | 279 | 41 | 6.80487804878049 | 0.466038563275005 | 0.466038563275005 | true | false | false | |||||||||||||||||
| 852f31db-0b96-4a98-95e2-9028dc964623 | 2026-09-23 13:39 | 2026-09-23 13:39 | 2026-09-23 13:39 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 42.6100 | 42.4000 | 42.6500 | 748.0000 | 21305.00 | 17045.00 | 4260.00 | 5 | 5 | 265 | 41 | 6.46341463414634 | 0.463951642850953 | 0.463752673857236 | false | false | false | |||||||||||||||||
| 50a07e64-1619-4f90-ac03-afd5666d1ef7 | 2026-09-23 12:32 | 2026-09-23 12:32 | 2026-09-23 12:32 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 38.3500 | 38.3500 | 38.6000 | 757.8150 | 34515.00 | 0.00 | 34515.00 | 9 | 9 | 245 | 41 | 5.97560975609756 | 0.468409643737745 | 0.468409643737745 | false | false | false | |||||||||||||||||
| 37be4099-bd3a-4ee7-98e0-3bbe2feca54e | 2026-09-23 10:17 | 2026-09-23 10:17 | 2026-09-23 10:17 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 45.2000 | 44.9500 | 45.3500 | 744.1590 | 140120.00 | 140120.00 | 0.00 | 31 | 20 | 176 | 41 | 4.29268292682927 | 0.462702547711482 | 0.463000851354748 | true | false | false | |||||||||||||||||
| d7de200f-6dfa-4179-9990-d0fbade8933e | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 35.6500 | 35.4000 | 35.7000 | 762.7550 | 57040.00 | 46345.00 | 10695.00 | 16 | 5 | 114 | 41 | 2.78048780487805 | 0.465217128605987 | 0.464684407164268 | false | false | false | |||||||||||||||||
| 7fe1d57e-abbe-4e2d-b69c-a682b2ad57a5 | 2026-09-23 09:56 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 35.8500 | 35.5500 | 35.9000 | 761.3300 | 32265.00 | 32265.00 | 0.00 | 9 | 6 | 54 | 41 | 1.31707317073171 | 0.458304930764999 | 0.458304930764999 | true | false | false | |||||||||||||||||
| c3c77141-989d-4b4c-8576-3a7a45ea1134 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 40.6000 | 40.5500 | 40.6000 | 750.0000 | 52780.00 | 52780.00 | 0.00 | 13 | 5 | 31 | 41 | 0.75609756097561 | 0.450003206637245 | 0.450003206637245 | false | false | false | |||||||||||||||||
| 4d9a96ce-eee6-44cc-8d63-a4bc48ab546a | 2026-09-21 15:48 | 2026-09-21 15:48 | 2026-09-21 15:48 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 44.7500 | 44.1000 | 44.8500 | 747.0000 | 53705.00 | 26870.00 | 26835.00 | 12 | 11 | 80 | 5 | 16 | 0.461467184349721 | 0.461179826123324 | true | false | false | |||||||||||||||||
| 6270d546-54c6-4d7b-9b1d-d38f836f6f1a | 2026-09-21 14:16 | 2026-09-21 14:15 | 2026-09-21 14:15 | META | META261016P00765000 | put | 765.0000 | 2026-10-16 | 46.5000 | 46.4000 | 46.5500 | 744.2799 | 23250.00 | 18600.00 | 4650.00 | 5 | 5 | 42 | 5 | 8.4 | 0.463207128109098 | 0.463207128109098 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:30:11.536652Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:45:37.818098Z"} |
| 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-25T13:32:31.841243Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-24T18:42:17.809304Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T17:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-23T18:19:20.444616Z"} |
| 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-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-23T14:18:11.787457Z"} |
| 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-23T13:58:49.832976Z"} |
| 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-23T13:57:01.829367Z"} |
| 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-23T13:47:39.692401Z"} |
| 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 |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 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-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |