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_alerts425,429 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 |
|---|
| bd319477-608f-49c5-b64d-19acd39e39df | 2026-08-17 09:36 | 2026-08-17 09:36 | 2026-08-17 09:36 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.8400 | 0.8200 | 0.8400 | 18.5450 | 25200.00 | 25200.00 | 0.00 | 300 | 6 | 302 | 7278 | 0.0414949161857653 | 0.453351664343863 | 0.453351664343863 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 10907311404.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a3bf6ff6-9cbc-455c-8738-f3243db46c85 | 2026-08-18 13:35 | 2026-08-18 13:35 | 2026-08-18 13:35 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.7200 | 0.7200 | 0.7600 | 18.1650 | 14400.00 | 0.00 | 14400.00 | 200 | 5 | 454 | 7784 | 0.0583247687564234 | 0.464518802111263 | 0.464518802111263 | false | false | false | true | ||||||||||||||||
| ab73e1bf-3d08-45e0-b982-76ad6ad38d17 | 2026-08-20 13:23 | 2026-08-20 13:23 | 2026-08-20 13:23 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.6900 | 0.6500 | 0.6900 | 17.9050 | 13800.00 | 13800.00 | 0.00 | 200 | 7 | 908 | 8412 | 0.10794103661436 | 0.495411052118026 | 0.495411052118026 | false | false | false | true | ||||||||||||||||
| 8945ba6e-59fc-4cdb-8c85-89c234230c47 | 2026-08-25 11:39 | 2026-08-25 11:39 | 2026-08-25 11:39 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.7200 | 0.7000 | 0.7200 | 18.0000 | 14400.00 | 14400.00 | 0.00 | 200 | 8 | 662 | 11486 | 0.0576353822044228 | 0.519075397061705 | 0.519075397061705 | false | false | false | true | ||||||||||||||||
| 358a917b-4074-4a33-88eb-b0c409eb03e7 | 2026-08-31 09:32 | 2026-08-31 09:32 | 2026-08-31 09:32 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 1.0600 | 0.9400 | 1.0600 | 18.8500 | 10694.00 | 10591.00 | 103.00 | 101 | 11 | 208 | 14384 | 0.014460511679644 | 0.558271743734197 | 0.546852755293721 | true | false | false | true | ||||||||||||||||
| ff6bf4a6-3148-4928-a992-389e47737372 | 2026-08-31 09:59 | 2026-08-31 09:59 | 2026-08-31 09:59 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.9000 | 0.8400 | 0.9000 | 18.5200 | 19794.00 | 19794.00 | 0.00 | 220 | 23 | 1150 | 14384 | 0.0799499443826474 | 0.548917241382334 | 0.53703137873367 | false | false | false | true | ||||||||||||||||
| eea211cd-dd1c-4d89-839a-799ed8c149ae | 2026-08-31 15:30 | 2026-08-31 15:30 | 2026-08-31 15:30 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.7000 | 0.7000 | 0.7400 | 18.2400 | 17500.00 | 0.00 | 17500.00 | 250 | 20 | 2207 | 14384 | 0.153434371523915 | 0.509861628442222 | 0.509861628442222 | false | false | false | true | ||||||||||||||||
| e85ab45b-1007-4ea5-8cac-5b3fac25af6b | 2026-09-03 09:49 | 2026-09-03 09:49 | 2026-09-03 09:49 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 1.0800 | 1.0400 | 1.0800 | 19.1600 | 10908.00 | 10908.00 | 0.00 | 101 | 17 | 318 | 17580 | 0.0180887372013652 | 0.532826021715979 | 0.532826021715979 | false | false | false | true | ||||||||||||||||
| b7e654b7-bca5-4d24-af4c-8c8341929cb5 | 2026-09-08 10:43 | 2026-09-08 10:42 | 2026-09-08 10:42 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.7800 | 0.7600 | 0.8000 | 18.8100 | 10608.00 | 1170.00 | 0.00 | 136 | 15 | 1003 | 19198 | 0.052245025523492 | 0.505157817708386 | 0.505157817708386 | true | false | false | true | ||||||||||||||||
| 30a78954-f072-4807-b34b-d7792aa67f5e | 2026-09-08 10:43 | 2026-09-08 10:43 | 2026-09-08 10:43 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.8000 | 0.7800 | 0.8000 | 18.8400 | 16000.00 | 16000.00 | 0.00 | 200 | 7 | 1380 | 19198 | 0.0718824877591416 | 0.508626650873595 | 0.508626650873595 | false | false | false | true | ||||||||||||||||
| 8a9f4843-1624-435e-87b7-beb83b3ee4dc | 2026-09-08 10:45 | 2026-09-08 10:44 | 2026-09-08 10:44 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.7900 | 0.7800 | 0.7900 | 18.8250 | 15800.00 | 15800.00 | 0.00 | 200 | 5 | 1784 | 19198 | 0.0929263464944265 | 0.506902193283241 | 0.506902193283241 | false | false | false | true | ||||||||||||||||
| 471a6f40-eb5f-44a6-9d0a-886eb6e55067 | 2026-09-08 10:54 | 2026-09-08 10:54 | 2026-09-08 10:54 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.8400 | 0.8100 | 0.8400 | 18.9700 | 14784.00 | 14784.00 | 0.00 | 176 | 5 | 2094 | 19198 | 0.10907386186061 | 0.503234844742599 | 0.503234844742599 | false | false | false | true | ||||||||||||||||
| fb4da705-01ac-4466-8a97-5d911e4a0307 | 2026-09-09 11:14 | 2026-09-09 11:14 | 2026-09-09 11:14 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 0.9800 | 0.9600 | 1.0200 | 19.6950 | 29400.00 | 5880.00 | 17640.00 | 300 | 9 | 1719 | 22010 | 0.07810086324398 | 0.433270928042286 | 0.433270928042286 | false | false | false | |||||||||||||||||
| d45445a4-846c-4082-94f5-cc96f78b5a74 | 2026-09-09 11:43 | 2026-09-09 11:42 | 2026-09-09 11:42 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 1.2000 | 1.1700 | 1.2000 | 20.0800 | 10200.00 | 10200.00 | 0.00 | 85 | 5 | 2267 | 22010 | 0.102998636983189 | 0.440702554056506 | 0.440702554056506 | false | false | false | true | ||||||||||||||||
| b39b15e3-d269-47fa-81f6-579b6b9603f4 | 2026-09-09 14:40 | 2026-09-09 14:40 | 2026-09-09 14:40 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 1.0500 | 1.0500 | 1.1100 | 19.8550 | 21000.00 | 0.00 | 21000.00 | 200 | 8 | 3611 | 22010 | 0.164061790095411 | 0.428904830084772 | 0.428904830084772 | false | false | false | true | ||||||||||||||||
| 99d2453a-8b62-41c0-83a0-390453a05d61 | 2026-09-09 14:40 | 2026-09-09 14:40 | 2026-09-09 14:40 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 1.0700 | 1.0500 | 1.1100 | 19.8800 | 21398.00 | 0.00 | 21398.00 | 200 | 5 | 3814 | 22010 | 0.173284870513403 | 0.423755413216636 | 0.431686983977826 | false | false | false | true | ||||||||||||||||
| bb6d19ef-f94b-4f51-8feb-7b8588b51494 | 2026-09-14 12:48 | 2026-09-14 12:48 | 2026-09-14 12:48 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 2.1200 | 2.0900 | 2.1200 | 21.6750 | 31800.00 | 31800.00 | 0.00 | 150 | 9 | 1668 | 20250 | 0.0823703703703704 | 0.414617432354518 | 0.414617432354518 | true | false | false | true | ||||||||||||||||
| 1eda1c3e-7099-4362-b3e7-8a662b6c3fca | 2026-09-14 15:05 | 2026-09-14 15:05 | 2026-09-14 15:05 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 2.3000 | 2.2400 | 2.3700 | 21.8750 | 69224.00 | 0.00 | 69224.00 | 301 | 5 | 3703 | 20250 | 0.182864197530864 | 0.427177363291312 | 0.427177363291312 | true | false | false | true | ||||||||||||||||
| baf54003-849a-4684-835a-0f4ba193e519 | 2026-09-14 15:07 | 2026-09-14 15:07 | 2026-09-14 15:07 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 2.3000 | 2.2400 | 2.3500 | 21.8735 | 23000.00 | 690.00 | 22310.00 | 100 | 8 | 3813 | 20250 | 0.188296296296296 | 0.427806737560993 | 0.427806737560993 | false | false | false | |||||||||||||||||
| 7107362b-e1b3-48ae-b838-2a3968d52bcf | 2026-09-18 09:48 | 2026-09-18 09:47 | 2026-09-18 09:47 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 2.7300 | 2.6600 | 2.8000 | 22.4700 | 18837.00 | 1092.00 | 4641.00 | 69 | 5 | 209 | 19723 | 0.0105967651979922 | 0.423371731577875 | 0.423371731577875 | false | false | false | true | ||||||||||||||||
| d70a26be-6b6e-46d9-aa89-1f4bb92bb17f | 2026-09-21 10:07 | 2026-09-21 10:07 | 2026-09-21 10:07 | GME | GME261016C00020000 | call | 20.0000 | 2026-10-16 | 3.1000 | 3.0500 | 3.2500 | 22.9000 | 26660.00 | 8370.00 | 18290.00 | 86 | 7 | 782 | 19190 | 0.0407503908285565 | 0.446950646745904 | 0.446950646745904 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10907311404.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11421902414.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| 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:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |