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 |
|---|
| c012c567-2648-4aef-aa56-6f093799db43 | 2026-09-21 10:20 | 2026-09-21 10:20 | 2026-09-21 10:20 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 5.8200 | 5.8000 | 6.0000 | 607.6000 | 36676.00 | 4776.00 | 31900.00 | 63 | 16 | 4360 | 0 | 0 | 0.758757310797022 | 0.730606608220869 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1004821037852.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 774b7cfb-c866-4019-88a8-f0ebd4c6a69f | 2026-09-21 10:27 | 2026-09-21 10:27 | 2026-09-21 10:27 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 4.5000 | 4.4500 | 4.7000 | 609.9200 | 56711.00 | 53550.00 | 3161.00 | 126 | 126 | 5237 | 0 | 0 | 0.738047544275883 | 0.72987857723462 | false | false | false | |||||||||||||||||
| fbef8166-432e-43cf-9aab-c2434570b4e4 | 2026-09-21 10:41 | 2026-09-21 10:41 | 2026-09-21 10:41 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 4.4600 | 4.4000 | 4.5500 | 608.8800 | 16950.00 | 0.00 | 16950.00 | 38 | 5 | 6528 | 0 | 0 | 0.650467729630627 | 0.650467729630627 | false | false | false | |||||||||||||||||
| 4a3ffd9f-d6aa-46ab-a00a-9a2cc36c3ab5 | 2026-09-21 11:05 | 2026-09-21 11:04 | 2026-09-21 11:04 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 1.9300 | 1.9100 | 1.9500 | 614.7000 | 23403.00 | 5413.00 | 9112.00 | 121 | 24 | 10863 | 0 | 0 | 0.664461939875145 | 0.662514209863948 | false | false | false | |||||||||||||||||
| 9e5140e0-e810-43d7-9bbd-0015e1eb9020 | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 3.3000 | 3.2000 | 3.3500 | 609.8699 | 16824.00 | 15180.00 | 1644.00 | 51 | 6 | 19240 | 0 | 0 | 0.604401211153364 | 0.602535828382227 | false | false | false | |||||||||||||||||
| 41f30f59-d3b1-499b-98cd-e59c4f672b05 | 2026-09-21 12:23 | 2026-09-21 12:23 | 2026-09-21 12:23 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 2.0000 | 1.9900 | 2.1200 | 611.7700 | 11399.00 | 0.00 | 11399.00 | 57 | 12 | 23566 | 0 | 0 | 0.568254341719113 | 0.564078771227458 | false | false | false | |||||||||||||||||
| 2a3fbbe9-99d0-4137-a2b5-46b4c2e369ba | 2026-09-21 12:49 | 2026-09-21 12:49 | 2026-09-21 12:49 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 2.3400 | 2.3100 | 2.4200 | 610.3900 | 12624.00 | 0.00 | 12624.00 | 54 | 5 | 26990 | 0 | 0 | 0.547367795424147 | 0.547367795424147 | false | false | false | |||||||||||||||||
| a94b0c97-0d3c-4895-b610-a0ff5bc1d250 | 2026-09-21 14:31 | 2026-09-21 14:31 | 2026-09-21 14:31 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 2.3900 | 2.3200 | 2.4100 | 609.0000 | 11946.00 | 11946.00 | 0.00 | 50 | 7 | 33548 | 0 | 0 | 0.624358221518852 | 0.611517333535222 | false | false | false | |||||||||||||||||
| 34a779a2-cd2e-4805-bc07-5faa7b22498f | 2026-09-21 15:05 | 2026-09-21 15:05 | 2026-09-21 15:05 | AMD | AMD260921P00610000 | put | 610.0000 | 2026-09-21 | 1.0500 | 1.0000 | 1.0600 | 611.0000 | 15080.00 | 0.00 | 15080.00 | 144 | 54 | 36636 | 0 | 0 | 0.69972668041282 | 0.687948448012165 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |