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_alerts566,287 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 | expiry |
|---|
| 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 |
|---|
| 56a29153-9f95-4f4d-8128-c36b34e1ba2d | 2026-09-17 09:47 | 2026-09-17 09:47 | 2026-09-17 09:47 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 0.5000 | 0.4800 | 0.5200 | 22.2000 | 12450.00 | 7550.00 | 1500.00 | 249 | 8 | 1023 | 2333 | 0.438491213030433 | 0.477826964212443 | 0.477826964212443 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 11487487542.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 32ed1195-1741-4ba5-a353-8e511e121705 | 2026-09-17 14:29 | 2026-09-17 14:29 | 2026-09-17 14:29 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 0.6700 | 0.6500 | 0.6700 | 22.5100 | 11055.00 | 11055.00 | 0.00 | 165 | 5 | 6062 | 2333 | 2.59837119588513 | 0.493204938658017 | 0.493204938658017 | false | false | false | true | ||||||||||||||||
| fab4d4fc-f8bc-43c1-8dae-2f1b0f3b431b | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 0.6500 | 0.6100 | 0.6500 | 22.0000 | 19500.00 | 19500.00 | 0.00 | 300 | 7 | 7246 | 4130 | 1.7544794188862 | 0.446708943734232 | 0.446708943734232 | false | false | false | true | ||||||||||||||||
| abec7814-ca84-46be-9dbd-ba8a4ae01f78 | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 0.6200 | 0.6200 | 0.6600 | 22.7750 | 12400.00 | 0.00 | 12400.00 | 200 | 7 | 2153 | 6565 | 0.327951256664128 | 0.490701752424586 | 0.490701752424586 | false | false | false | true | ||||||||||||||||
| 2de7aead-fce6-4a9d-b58d-e56d47fdaf4f | 2026-09-22 13:05 | 2026-09-22 13:05 | 2026-09-22 13:05 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 1.5000 | 1.4700 | 1.5000 | 23.0000 | 20400.00 | 20400.00 | 0.00 | 136 | 5 | 2919 | 5973 | 0.48869914615771 | 0.6191982688189 | 0.6191982688189 | true | false | false | true | ||||||||||||||||
| 3c31640c-563a-4bcc-acee-3fa4898af172 | 2026-09-24 09:33 | 2026-09-24 09:33 | 2026-09-24 09:33 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 1.4200 | 1.4200 | 1.5000 | 23.9150 | 19770.00 | 0.00 | 19770.00 | 139 | 6 | 196 | 4231 | 0.0463247459229497 | 0.661657235024687 | 0.661657235024687 | false | false | false | true | ||||||||||||||||
| 357cfc4d-8571-498c-88b9-55378e150fe9 | 2026-09-24 13:16 | 2026-09-24 13:16 | 2026-09-24 13:16 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 2.2500 | 2.1500 | 2.3200 | 24.7621 | 11025.00 | 11025.00 | 0.00 | 49 | 6 | 860 | 4231 | 0.203261640274167 | 1.2877838019636 | 1.2877838019636 | false | false | false | true | ||||||||||||||||
| 23e3e3ff-8a08-48b9-b92e-fa9a88174e0a | 2026-09-24 13:36 | 2026-09-24 13:36 | 2026-09-24 13:36 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 2.2400 | 2.2400 | 2.3700 | 24.7850 | 17920.00 | 0.00 | 17920.00 | 80 | 5 | 1248 | 4231 | 0.294965729142047 | 1.43479492196703 | 1.43479492196703 | false | false | false | true | ||||||||||||||||
| eeb2e960-849a-40dc-aec8-baf3e2d2e643 | 2026-09-25 14:09 | 2026-09-25 14:09 | 2026-09-25 14:09 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 1.0000 | 0.9400 | 1.0000 | 23.0000 | 35200.00 | 35200.00 | 0.00 | 352 | 9 | 2888 | 4220 | 0.68436018957346 | 1.71928828134213 | 0.9466966962253 | false | false | false | true | ||||||||||||||||
| ed17d018-e8cf-422d-a273-648edff6f8cb | 2026-09-25 15:38 | 2026-09-25 15:38 | 2026-09-25 15:38 | GME | GME260925C00022500 | call | 22.5000 | 2026-09-25 | 0.7300 | 0.6800 | 0.9300 | 23.0000 | 36500.00 | 0.00 | 36500.00 | 500 | 14 | 4433 | 4220 | 1.05047393364929 | 7.77203858417217 | 8.18193879802202 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11487487542.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11421902414.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11482442532.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12123158790.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12208923958.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12208923958.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:20:10.992675Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12208923958.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:37:15.785672Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11800278156.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11800278156.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:39:29.889694Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |