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 | 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 |
|---|
| 221399fa-3a43-4a14-a115-7dc10c846162 | 2026-08-31 15:34 | 2026-08-31 15:34 | 2026-08-31 15:34 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 88.4000 | 86.8000 | 89.3000 | 891.2355 | 159120.00 | 106080.00 | 53040.00 | 18 | 6 | 50 | 739 | 0.06765899864682 | 0.441134517111132 | 0.441134517111132 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 232977963316.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d7aaa7d1-bdb1-43e0-9192-c7c516742f4e | 2026-08-31 15:36 | 2026-08-31 15:36 | 2026-08-31 15:36 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 86.6100 | 84.4000 | 90.0000 | 895.5000 | 138570.00 | 43170.00 | 95400.00 | 16 | 8 | 95 | 739 | 0.128552097428958 | 0.453436511147169 | 0.441196140828737 | false | false | false | true | ||||||||||||||||
| 770d52b5-cfdc-4ce3-9aa4-b6a785579db1 | 2026-08-31 15:38 | 2026-08-31 15:37 | 2026-08-31 15:37 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 87.4000 | 86.1500 | 90.0000 | 893.2000 | 96140.00 | 0.00 | 96140.00 | 11 | 7 | 132 | 739 | 0.178619756427605 | 0.441686390153939 | 0.442841145330154 | false | false | false | true | ||||||||||||||||
| 299c56f7-820a-43e5-85cc-b0904a248490 | 2026-08-31 15:42 | 2026-08-31 15:42 | 2026-08-31 15:42 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 86.5000 | 86.5000 | 89.6000 | 894.4500 | 103800.00 | 0.00 | 103800.00 | 12 | 7 | 249 | 739 | 0.336941813261164 | 0.441709555436954 | 0.441709555436954 | false | false | false | true | ||||||||||||||||
| 0a1ca079-dc26-41d5-b0cf-e77309b97fb0 | 2026-08-31 15:45 | 2026-08-31 15:45 | 2026-08-31 15:45 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 85.5000 | 83.1000 | 86.5000 | 896.2950 | 94050.00 | 59850.00 | 34200.00 | 11 | 5 | 310 | 739 | 0.419485791610284 | 0.442668128196661 | 0.442668128196661 | false | false | false | true | ||||||||||||||||
| ead9a20a-9d36-460e-a901-51f5dc18eab7 | 2026-08-31 15:46 | 2026-08-31 15:45 | 2026-08-31 15:45 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 85.5000 | 83.6000 | 87.9000 | 896.1887 | 119700.00 | 85500.00 | 34200.00 | 14 | 5 | 324 | 739 | 0.438430311231394 | 0.442145495431829 | 0.442145495431829 | false | false | false | true | ||||||||||||||||
| a2f77534-4b2a-41ae-9805-fb772561dc3f | 2026-08-31 15:48 | 2026-08-31 15:47 | 2026-08-31 15:47 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 85.7000 | 85.7000 | 86.7000 | 895.4300 | 102840.00 | 0.00 | 102840.00 | 12 | 7 | 366 | 739 | 0.495263870094723 | 0.440031937080807 | 0.440031937080807 | false | false | false | true | ||||||||||||||||
| 5f8abd9a-7475-4dc6-bb85-2a037f2394fc | 2026-08-31 15:49 | 2026-08-31 15:49 | 2026-08-31 15:49 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 86.2000 | 84.5000 | 89.7000 | 894.1163 | 112060.00 | 0.00 | 112060.00 | 13 | 6 | 403 | 739 | 0.545331529093369 | 0.437578335354394 | 0.437578335354394 | false | false | false | true | ||||||||||||||||
| daef2b5e-c3c7-4afe-8f1f-792b0cd7e94b | 2026-08-31 15:49 | 2026-08-31 15:49 | 2026-08-31 15:49 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 86.2000 | 86.2000 | 89.6000 | 894.8000 | 68960.00 | 0.00 | 68960.00 | 8 | 6 | 413 | 739 | 0.558863328822733 | 0.440994806283899 | 0.440994806283899 | false | false | false | true | ||||||||||||||||
| 726c4e58-f960-41ba-ab9d-da248ba42b6c | 2026-08-31 15:55 | 2026-08-31 15:55 | 2026-08-31 15:55 | GEV | GEV261016P00950000 | put | 950.0000 | 2026-10-16 | 86.0000 | 86.0000 | 88.8000 | 895.2350 | 68800.00 | 0.00 | 68800.00 | 8 | 6 | 530 | 739 | 0.717185385656292 | 0.441518585942777 | 0.441518585942777 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |