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_alerts609,118 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 |
|---|
| 9c87bafd-3c40-47ce-89f3-c0b15dc9ba55 | 2026-09-23 13:32 | 2026-09-23 13:32 | 2026-09-23 13:32 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 6.7300 | 6.7300 | 6.7600 | 767.2900 | 88901.00 | 675.00 | 88226.00 | 132 | 6 | 23124 | 7593 | 3.04543658632951 | 0.283935908603785 | 0.283935908603785 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 806184418262.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 755344c7-bc96-4036-a182-eb4bcbf7f031 | 2026-09-23 13:30 | 2026-09-23 13:30 | 2026-09-23 13:30 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 6.8500 | 6.8300 | 6.8800 | 767.0000 | 150591.00 | 2744.00 | 147847.00 | 220 | 9 | 22950 | 7593 | 3.02252074278941 | 0.246292448755021 | 0.286143038011394 | true | false | false | |||||||||||||||||
| 45d65e6f-b57e-4a8d-b052-72355bee949a | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.7100 | 1.7100 | 1.7200 | 773.0000 | 14712.00 | 1032.00 | 13680.00 | 86 | 6 | 95889 | 2883 | 33.2601456815817 | 0.0989695042476008 | 0.0983495373442143 | false | false | false | |||||||||||||||||
| b9a863a8-30db-4744-b02e-1f7d308e904d | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.5400 | 1.5400 | 1.5600 | 773.9600 | 154170.00 | 10540.00 | 143630.00 | 1000 | 42 | 91576 | 2883 | 31.7641345820326 | 0.0972639482952237 | 0.0966451361917065 | true | false | false | |||||||||||||||||
| af0b97e0-601e-45c6-b2d2-481e0a5d4c3a | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.3300 | 1.3200 | 1.3300 | 774.0000 | 134320.00 | 133000.00 | 1320.00 | 1010 | 14 | 88049 | 2883 | 30.5407561567811 | 0.0990088522472681 | 0.0983811270821286 | true | false | false | |||||||||||||||||
| ae255720-37a2-464a-ac70-594438bad334 | 2026-09-22 15:43 | 2026-09-22 15:43 | 2026-09-22 15:43 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.3400 | 1.3400 | 1.3500 | 774.3900 | 67138.00 | 540.00 | 66598.00 | 501 | 25 | 77969 | 2883 | 27.0443981963233 | 0.0969066524671728 | 0.0968467914655391 | true | false | false | |||||||||||||||||
| 7acae9f6-818e-407f-a528-7129041d6a6c | 2026-09-22 15:25 | 2026-09-22 15:25 | 2026-09-22 15:25 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.3700 | 1.3600 | 1.3800 | 774.3800 | 204762.00 | 0.00 | 204762.00 | 1500 | 31 | 62605 | 2883 | 21.7152271938952 | 0.0984342265877831 | 0.0978113948309511 | false | false | false | |||||||||||||||||
| 079123f1-0163-4851-8ad6-8f7c40cb718f | 2026-09-22 14:57 | 2026-09-22 14:57 | 2026-09-22 14:57 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.6700 | 1.6600 | 1.6800 | 773.8000 | 16991.00 | 167.00 | 7472.00 | 102 | 10 | 52287 | 2883 | 18.1363163371488 | 0.0997142660126141 | 0.0997142660126141 | false | false | false | |||||||||||||||||
| e07bc933-f01d-4613-abf8-46efdfab8622 | 2026-09-22 13:52 | 2026-09-22 13:52 | 2026-09-22 13:52 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.8600 | 1.8600 | 1.8800 | 773.6100 | 11139.00 | 0.00 | 11139.00 | 60 | 8 | 41279 | 2883 | 14.3180714533472 | 0.102018804967303 | 0.105376536258207 | true | false | false | |||||||||||||||||
| 3fdc8288-8d1e-4a7e-a739-bcb05d9d7b6a | 2026-09-22 11:25 | 2026-09-22 11:25 | 2026-09-22 11:25 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.8300 | 1.8100 | 1.8300 | 773.0000 | 85820.00 | 84000.00 | 1820.00 | 470 | 11 | 27998 | 2883 | 9.71141172389872 | 0.105468355469421 | 0.10484843239489 | false | false | false | |||||||||||||||||
| 464dab0a-7c7b-4ffc-944c-785d6c9cd6fc | 2026-09-22 10:39 | 2026-09-22 10:39 | 2026-09-22 10:39 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.9900 | 1.9700 | 2.0000 | 773.6100 | 20692.00 | 20692.00 | 0.00 | 104 | 5 | 21381 | 2883 | 7.4162330905307 | 0.113081703298104 | 0.112821357660609 | false | false | false | |||||||||||||||||
| 4bc0e41f-e966-46c4-8e37-432e4e09d743 | 2026-09-22 10:39 | 2026-09-22 10:39 | 2026-09-22 10:39 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.8300 | 1.8100 | 1.8900 | 773.8900 | 11545.00 | 0.00 | 11545.00 | 63 | 5 | 21062 | 2883 | 7.30558446063129 | 0.111766768855436 | 0.111195583151464 | true | false | false | |||||||||||||||||
| 83e50025-5363-40f0-9c70-903ebf958ba8 | 2026-09-22 09:55 | 2026-09-22 09:55 | 2026-09-22 09:55 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.8900 | 1.8900 | 1.9100 | 773.9300 | 11345.00 | 0.00 | 11345.00 | 60 | 6 | 9034 | 2883 | 3.1335414498786 | 0.118000709754277 | 0.117381920834326 | false | false | false | |||||||||||||||||
| a0d864dd-fd7a-4290-9226-f35e9867b430 | 2026-09-22 09:49 | 2026-09-22 09:48 | 2026-09-22 09:48 | SPY | SPY260923P00774000 | put | 774.0000 | 2026-09-23 | 1.8800 | 1.8800 | 1.8900 | 774.2800 | 192443.00 | 378.00 | 192065.00 | 1025 | 20 | 7608 | 2883 | 2.63891779396462 | 0.121024524749343 | 0.119182791562631 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:50:24.302840Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |