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 |
|---|
| 6089f1b3-bdc7-4011-92c0-f518ec8c4af7 | 2026-09-22 13:23 | 2026-09-22 13:23 | 2026-09-22 13:23 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.6400 | 2.6400 | 2.6600 | 773.1200 | 124282.00 | 0.00 | 118717.00 | 470 | 13 | 21173 | 2568 | 8.24493769470405 | 0.101300707663208 | 0.10094250004953 | false | false | false | true | 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:30:55.056187Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 4ac0630c-e94d-409a-8ed9-34649376726e | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.7500 | 2.7300 | 2.7600 | 772.0900 | 54938.00 | 0.00 | 54938.00 | 200 | 9 | 2335 | 4974 | 0.469441093687173 | 0.103237649154425 | 0.102596412836704 | true | false | false | |||||||||||||||||
| bed44b19-1063-426d-aa95-08f22e9a19fd | 2026-09-25 12:08 | 2026-09-25 12:08 | 2026-09-25 12:08 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.2000 | 2.2000 | 2.2200 | 771.3000 | 31681.00 | 221.00 | 31460.00 | 144 | 6 | 11492 | 3790 | 3.03218997361478 | 0.182631213861645 | 0.180807523062305 | false | false | false | |||||||||||||||||
| 8cd3c3d6-1529-40ff-a6e2-4bf48be5e7e6 | 2026-09-25 12:09 | 2026-09-25 12:08 | 2026-09-25 12:08 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.1100 | 2.1100 | 2.1300 | 771.4499 | 46102.00 | 0.00 | 46102.00 | 218 | 7 | 11855 | 3790 | 3.12796833773087 | 0.185516864383727 | 0.185516864383727 | true | false | false | |||||||||||||||||
| 0f853848-de5d-458c-b970-9237750bcd14 | 2026-09-25 12:11 | 2026-09-25 12:11 | 2026-09-25 12:11 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 1.9500 | 1.9400 | 1.9600 | 771.0000 | 19506.00 | 19506.00 | 0.00 | 100 | 6 | 13284 | 3790 | 3.50501319261214 | 0.177928595472017 | 0.178553378379019 | false | false | false | |||||||||||||||||
| 1a1237a2-4d16-4b65-9680-d12f3df3954b | 2026-09-25 12:14 | 2026-09-25 12:14 | 2026-09-25 12:14 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.0900 | 2.0900 | 2.1100 | 771.4200 | 10470.00 | 0.00 | 10470.00 | 50 | 5 | 14120 | 3790 | 3.72559366754617 | 0.173905811306264 | 0.178625465050315 | true | false | false | |||||||||||||||||
| 3ed17c48-b524-4bb3-ad2e-828bf08d1ec7 | 2026-09-25 12:27 | 2026-09-25 12:27 | 2026-09-25 12:27 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.1300 | 2.1300 | 2.1400 | 771.0000 | 16193.00 | 1070.00 | 15123.00 | 76 | 6 | 19181 | 3790 | 5.06094986807388 | 0.182555999582054 | 0.18064018462188 | false | false | false | |||||||||||||||||
| 19fe3565-2402-4744-b1fe-b96c30171b0f | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.4300 | 2.4200 | 2.5200 | 770.8600 | 24558.00 | 0.00 | 24558.00 | 101 | 8 | 21994 | 3790 | 5.80316622691293 | 0.181379369975861 | 0.167836335310072 | true | false | false | |||||||||||||||||
| 2c5a0f4c-6302-4989-bc77-8368756ce4f8 | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.6000 | 2.5900 | 2.6400 | 770.7550 | 11429.00 | 0.00 | 11429.00 | 44 | 12 | 22089 | 3790 | 5.82823218997361 | 0.194266509058905 | 0.187661944166213 | false | false | false | |||||||||||||||||
| 9a542c31-81d6-401a-8905-50c11286c8e3 | 2026-09-25 12:36 | 2026-09-25 12:36 | 2026-09-25 12:36 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.5900 | 2.5800 | 2.6100 | 770.7000 | 12697.00 | 1305.00 | 11392.00 | 49 | 14 | 23115 | 3790 | 6.09894459102902 | 0.183464322719486 | 0.176424138201762 | false | false | false | |||||||||||||||||
| 3af6358c-ae09-4428-8252-0fc2b9540171 | 2026-09-25 12:59 | 2026-09-25 12:59 | 2026-09-25 12:59 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.9000 | 2.8600 | 2.9400 | 770.2700 | 17386.00 | 0.00 | 17386.00 | 60 | 9 | 26054 | 3790 | 6.87440633245383 | 0.17358960418379 | 0.163189790241393 | false | false | false | |||||||||||||||||
| dfc34faa-90b4-44bc-b4a6-e6162aa70ab4 | 2026-09-25 13:25 | 2026-09-25 13:25 | 2026-09-25 13:25 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.0400 | 2.0400 | 2.0500 | 771.2499 | 24685.00 | 205.00 | 24480.00 | 121 | 6 | 30559 | 3790 | 8.06306068601583 | 0.176571767579713 | 0.174061029206651 | false | false | false | |||||||||||||||||
| efe2c6a6-8750-43e0-b392-833116ff2a75 | 2026-09-25 13:45 | 2026-09-25 13:45 | 2026-09-25 13:45 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.2000 | 2.2000 | 2.2300 | 770.9400 | 13664.00 | 0.00 | 13664.00 | 62 | 7 | 33874 | 3790 | 8.9377308707124 | 0.151344974819613 | 0.158193340171732 | true | false | false | |||||||||||||||||
| dec5a83e-1a31-44d2-974d-57d2775f4ab7 | 2026-09-25 14:26 | 2026-09-25 14:26 | 2026-09-25 14:26 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.1900 | 2.0500 | 2.1900 | 770.9125 | 14903.00 | 12793.00 | 2110.00 | 68 | 7 | 41517 | 3790 | 10.9543535620053 | 0.213421169806711 | 0.124452240113026 | true | false | false | |||||||||||||||||
| 9d15b2e9-bd55-42e0-9c90-e5aa9761e5cd | 2026-09-25 14:27 | 2026-09-25 14:27 | 2026-09-25 14:27 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 2.1000 | 2.1000 | 2.1200 | 770.9400 | 10711.00 | 0.00 | 10711.00 | 51 | 5 | 42033 | 3790 | 11.0905013192612 | 0.144351566134433 | 0.137615277630494 | false | false | false | |||||||||||||||||
| 6804dc29-bd1f-4faa-8d95-ba20d97e0b5e | 2026-09-25 15:50 | 2026-09-25 15:50 | 2026-09-25 15:50 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 1.2800 | 1.2700 | 1.4400 | 771.0000 | 12779.00 | 0.00 | 12779.00 | 100 | 5 | 52011 | 3790 | 13.7232189973615 | 0.348154613987273 | 0.432692106763216 | true | false | false | |||||||||||||||||
| cd943323-9d6a-4498-ab56-e38436e0cdfb | 2026-09-25 15:59 | 2026-09-25 15:59 | 2026-09-25 15:59 | SPY | SPY260925P00773000 | put | 773.0000 | 2026-09-25 | 1.7700 | 1.7600 | 1.7900 | 771.0000 | 31792.00 | 0.00 | 31792.00 | 180 | 5 | 54373 | 3790 | 14.346437994723 | 1.50807693441173 | 1.70996178146589 | true | false | false |
| 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-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:31:25.590153Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:38:20.208952Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:31:26.314014Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |