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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 2d8b8348-bec6-4f88-86c8-e804fc3a2afc | 2026-09-25 14:42 | 2026-09-25 14:42 | 2026-09-25 14:42 | AME | AME261016C00250000 | call | 250.0000 | 2026-10-16 | 5.8000 | 5.8000 | 6.1000 | 250.7900 | 23780.00 | 0.00 | 23780.00 | 41 | 6 | 109 | 1571 | 0.0693825588796945 | 0.212606926161346 | 0.212606926161346 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 57484964321.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T18:46:04.686299Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 5d2163cf-9958-4c8b-a6ff-095be4fa28b8 | 2026-09-25 13:05 | 2026-09-25 13:05 | 2026-09-25 13:05 | AME | AME261120C00260000 | call | 260.0000 | 2026-11-20 | 7.2000 | 7.2000 | 7.8000 | 251.2650 | 23760.00 | 0.00 | 23760.00 | 33 | 10 | 97 | 2258 | 0.0429583702391497 | 0.260183052596011 | 0.260183052596011 | false | false | false | true | ||||||||||||||||
| 3e3ae517-a8b1-4e75-97b7-9c8205d2afde | 2026-09-22 11:40 | 2026-09-22 11:40 | 2026-09-22 11:40 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 9.1000 | 9.1000 | 9.5000 | 245.1800 | 55510.00 | 0.00 | 55510.00 | 61 | 19 | 150 | 2165 | 0.069284064665127 | 0.26817763609193 | 0.26817763609193 | false | false | false | true | ||||||||||||||||
| 2075bbcf-eeae-47f0-a0f9-24e689c731e6 | 2026-09-22 11:40 | 2026-09-22 11:39 | 2026-09-22 11:39 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 9.1000 | 8.8000 | 9.1000 | 245.1800 | 33670.00 | 33670.00 | 0.00 | 37 | 5 | 89 | 2165 | 0.041108545034642 | 0.26817763609193 | 0.26817763609193 | false | false | false | true | ||||||||||||||||
| 44c68397-bced-478e-96a4-23c11bcae68e | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 7.8000 | 7.8000 | 8.7000 | 242.1500 | 22620.00 | 0.00 | 22620.00 | 29 | 16 | 489 | 2664 | 0.183558558558559 | 0.26739419245241 | 0.26739419245241 | false | false | false | true | ||||||||||||||||
| abd4cb96-61f2-482d-a962-505aa952047a | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | AME | AME261016C00250000 | call | 250.0000 | 2026-10-16 | 3.0000 | 2.8000 | 3.0000 | 242.0200 | 16500.00 | 9300.00 | 0.00 | 55 | 13 | 242 | 1298 | 0.186440677966102 | 0.232089027926997 | 0.232089027926997 | false | false | false | true | ||||||||||||||||
| a2df5914-bdf3-4e4f-afd6-cb211357955a | 2026-09-17 15:51 | 2026-09-17 15:51 | 2026-09-17 15:51 | AME | AME261120C00260000 | call | 260.0000 | 2026-11-20 | 2.9000 | 2.9000 | 3.0000 | 234.0000 | 50460.00 | 0.00 | 50460.00 | 174 | 12 | 278 | 1634 | 0.170134638922889 | 0.265979112977738 | 0.265979112977738 | false | false | false | true | ||||||||||||||||
| bf34a865-3aec-477e-b018-07cb2839fc8d | 2026-09-11 12:32 | 2026-09-11 12:32 | 2026-09-11 12:32 | AME | AME260918P00240000 | put | 240.0000 | 2026-09-18 | 2.7500 | 2.5000 | 2.7500 | 241.2500 | 75075.00 | 75075.00 | 0.00 | 273 | 15 | 277 | 1077 | 0.25719591457753 | 0.257178923594581 | 0.257178923594581 | false | false | false | true | ||||||||||||||||
| 3913598b-968b-4b76-8e2e-08fe5a0cdb28 | 2026-09-04 13:18 | 2026-09-04 13:17 | 2026-09-04 13:17 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 7.0000 | 6.8000 | 7.5000 | 237.6000 | 76950.00 | 0.00 | 76260.00 | 110 | 29 | 789 | 2583 | 0.305458768873403 | 0.256440314809102 | 0.254952211338819 | false | false | false | true | ||||||||||||||||
| 8721d7d0-e164-4e1f-9c71-69696ad17d38 | 2026-09-04 12:25 | 2026-09-04 12:25 | 2026-09-04 12:25 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 7.1000 | 7.1000 | 7.5000 | 238.1500 | 166142.00 | 0.00 | 166142.00 | 234 | 35 | 554 | 2583 | 0.214479287650019 | 0.254689488097631 | 0.254689488097631 | false | false | false | true | ||||||||||||||||
| 152e2559-0cbf-4660-b276-62404a49d40c | 2026-09-03 11:35 | 2026-09-03 11:34 | 2026-09-03 11:34 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 5.9000 | 5.5000 | 6.0000 | 233.3450 | 63720.00 | 63720.00 | 0.00 | 108 | 11 | 705 | 1161 | 0.607235142118863 | 0.265679023370376 | 0.265679023370376 | false | false | false | true | ||||||||||||||||
| 03ee1766-4a82-4064-8fe8-2e9242a3d938 | 2026-09-03 11:33 | 2026-09-03 11:33 | 2026-09-03 11:33 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 5.9000 | 5.7000 | 6.0000 | 233.4650 | 120950.00 | 32450.00 | 88500.00 | 205 | 5 | 472 | 1161 | 0.406546080964686 | 0.264659414708562 | 0.264659414708562 | false | false | false | true | ||||||||||||||||
| 02313c07-b993-4bf7-82c3-bc43c710b70f | 2026-08-26 12:09 | 2026-08-26 12:08 | 2026-08-26 12:08 | AME | AME261120C00260000 | call | 260.0000 | 2026-11-20 | 7.3100 | 6.4000 | 7.8000 | 245.4650 | 92164.00 | 46604.00 | 45560.00 | 126 | 21 | 501 | 355 | 1.4112676056338 | 0.255395118831772 | 0.258098873208785 | false | false | false | true | ||||||||||||||||
| c332bf88-1f0c-45a1-a330-c8aeba5f61da | 2026-08-24 15:18 | 2026-08-24 15:18 | 2026-08-24 15:18 | AME | AME261120C00260000 | call | 260.0000 | 2026-11-20 | 6.8000 | 5.6000 | 6.8000 | 241.6743 | 53030.00 | 53030.00 | 0.00 | 78 | 5 | 158 | 175 | 0.902857142857143 | 0.269225611528859 | 0.271526690630208 | true | false | false | true | ||||||||||||||||
| ee2eaa33-4b07-4311-a210-529c91be24d9 | 2026-08-21 15:32 | 2026-08-21 15:32 | 2026-08-21 15:32 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 8.9000 | 8.7000 | 8.9000 | 238.9200 | 78320.00 | 78320.00 | 0.00 | 88 | 27 | 260 | 56 | 4.64285714285714 | 0.263770996265039 | 0.263770996265039 | false | false | false | true | ||||||||||||||||
| 0bbebbbe-5381-44d0-a781-5f2bd62c9205 | 2026-08-21 15:31 | 2026-08-21 15:31 | 2026-08-21 15:31 | AME | AME261120C00250000 | call | 250.0000 | 2026-11-20 | 8.8000 | 8.4000 | 8.9000 | 239.0600 | 142560.00 | 131120.00 | 11440.00 | 162 | 11 | 169 | 56 | 3.01785714285714 | 0.261400382637542 | 0.260368036302418 | false | false | false | true | ||||||||||||||||
| 987a9d79-2c39-4e2a-ab19-dbb523a2cd3d | 2026-08-20 13:54 | 2026-08-20 13:54 | 2026-08-20 13:54 | AME | AME261016C00240000 | call | 240.0000 | 2026-10-16 | 9.4000 | 9.0000 | 9.4000 | 239.7250 | 115620.00 | 115620.00 | 0.00 | 123 | 35 | 159 | 37 | 4.2972972972973 | 0.233852617382411 | 0.233852617382411 | false | false | false | true | ||||||||||||||||
| 493641f8-1045-4a1c-bd60-7936c6b94a27 | 2026-08-20 10:47 | 2026-08-20 10:47 | 2026-08-20 10:47 | AME | AME261120C00270000 | call | 270.0000 | 2026-11-20 | 4.0900 | 4.0000 | 4.4000 | 241.9100 | 178874.00 | 102514.00 | 65930.00 | 437 | 39 | 583 | 1634 | 0.356793145654835 | 0.254017255882039 | 0.256685214507029 | false | false | false | true | ||||||||||||||||
| 55fdb583-1b6e-4998-8aa2-1f4169d13169 | 2026-08-19 12:48 | 2026-08-19 12:48 | 2026-08-19 12:48 | AME | AME261016C00250000 | call | 250.0000 | 2026-10-16 | 6.9100 | 6.8000 | 7.4000 | 244.0700 | 214319.00 | 20421.00 | 193898.00 | 310 | 56 | 425 | 353 | 1.20396600566572 | 0.230582187025682 | 0.228227502479667 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 57484964321.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 56263001890.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 56263001890.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 55304689890.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 55304689890.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53720494694.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 53566889661.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |