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_alerts523,327 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 |
|---|
| 0699a968-621e-4058-9502-3cc4b586643a | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 4.7700 | 4.7500 | 4.8500 | 760.7700 | 85930.00 | 0.00 | 85930.00 | 180 | 6 | 2991 | 4415 | 0.677463193657984 | 0.50779094774141 | 0.506349822281088 | false | false | false | true | false | 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 |
| 4c56bdcf-01a0-41d6-8034-8bb57c112492 | 2026-09-23 11:31 | 2026-09-23 11:31 | 2026-09-23 11:31 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 4.3900 | 4.3500 | 4.4500 | 754.9400 | 115345.00 | 0.00 | 79705.00 | 263 | 7 | 9549 | 4415 | 2.16285390713477 | 0.513816101839644 | 0.512314114981803 | false | false | false | |||||||||||||||||
| c1203a0b-5813-4e0f-928b-b4245f59d21c | 2026-09-23 12:14 | 2026-09-23 12:14 | 2026-09-23 12:14 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 4.0000 | 3.9500 | 4.0500 | 753.1750 | 80382.00 | 34782.00 | 45600.00 | 201 | 17 | 11716 | 4415 | 2.65368063420159 | 0.506426357992046 | 0.506796902566677 | true | false | false | |||||||||||||||||
| ec81fbd9-e185-41e6-9ae9-1b8ce0a872fd | 2026-09-23 12:14 | 2026-09-23 12:14 | 2026-09-23 12:14 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 4.0500 | 3.9500 | 4.1000 | 753.2676 | 250281.00 | 225981.00 | 24300.00 | 618 | 63 | 12716 | 4415 | 2.880181200453 | 0.507998154807303 | 0.508094399178033 | true | false | false | |||||||||||||||||
| 030feacc-09f0-4414-9881-f6fd576e3f3d | 2026-09-23 12:41 | 2026-09-23 12:41 | 2026-09-23 12:41 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 4.3200 | 4.2500 | 4.4000 | 756.0000 | 12089.00 | 6062.00 | 6027.00 | 28 | 8 | 12808 | 4415 | 2.90101925254813 | 0.507508694368988 | 0.507508694368988 | false | false | false | |||||||||||||||||
| 7ad744dd-85ee-40a1-b305-cf09794aa1de | 2026-09-25 11:09 | 2026-09-25 11:09 | 2026-09-25 11:09 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.6500 | 1.5800 | 1.6800 | 752.2100 | 312178.00 | 105433.00 | 132495.00 | 1892 | 40 | 3691 | 26269 | 0.140507822909132 | 0.438828592904898 | 0.438828592904898 | true | false | false | |||||||||||||||||
| 6176f57e-8ee3-4b5e-943b-48b81aedf65c | 2026-09-25 11:13 | 2026-09-25 11:13 | 2026-09-25 11:13 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.8900 | 1.8700 | 1.9400 | 754.0056 | 64044.00 | 17484.00 | 46560.00 | 339 | 27 | 13142 | 26269 | 0.500285507632571 | 0.446468664067641 | 0.445503695860545 | false | false | false | |||||||||||||||||
| e75d97ee-91d7-4a75-8a0d-a79610effdcf | 2026-09-25 11:14 | 2026-09-25 11:14 | 2026-09-25 11:14 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.7400 | 1.7300 | 1.7900 | 753.7150 | 65144.00 | 55748.00 | 9396.00 | 374 | 7 | 15662 | 26269 | 0.59621607217633 | 0.439432075108939 | 0.439376988772766 | false | false | false | |||||||||||||||||
| c2b65fb1-d8cf-4713-b0c2-6e6fd1645aa9 | 2026-09-25 11:14 | 2026-09-25 11:14 | 2026-09-25 11:14 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.7400 | 1.7300 | 1.7800 | 753.7150 | 37626.00 | 17922.00 | 19704.00 | 216 | 10 | 15277 | 26269 | 0.581560013704366 | 0.439881706289379 | 0.439376988772766 | false | false | false | |||||||||||||||||
| 1b5c384e-cbf4-48bd-a4ba-ec0b39a9dfd7 | 2026-09-25 11:15 | 2026-09-25 11:15 | 2026-09-25 11:15 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.6900 | 1.6900 | 1.7300 | 753.3700 | 35256.00 | 17510.00 | 17746.00 | 208 | 11 | 16366 | 26269 | 0.623015721953634 | 0.438278241372192 | 0.438278241372192 | false | false | false | |||||||||||||||||
| 906c871d-e8cd-4849-9500-c19169099b36 | 2026-09-25 14:44 | 2026-09-25 14:44 | 2026-09-25 14:44 | META | META261016C00900000 | call | 900.0000 | 2026-10-16 | 1.6300 | 1.5700 | 1.6400 | 752.3000 | 14048.00 | 14048.00 | 0.00 | 86 | 13 | 18251 | 26269 | 0.694773306939739 | 0.438060392769845 | 0.436475092110537 | true | false | false |
| false |
| 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-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T16:19:07.705108Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T16:19:07.705108Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-25T15:11:41.812883Z"} |
| 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-25T15:15:19.758010Z"} |
| 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-25T15:15:19.758010Z"} |
| 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-25T15:15:19.758010Z"} |
| 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-25T15:19:48.264136Z"} |
| 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-25T18:46:04.686299Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |