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 |
|---|
| 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 |
|---|
| d251a9bf-5dad-468d-909f-bc3cca21cb58 | 2026-09-28 15:53 | 2026-09-28 15:53 | 2026-09-28 15:53 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.2800 | 0.2500 | 0.2800 | 342.2150 | 10528.00 | 10528.00 | 0.00 | 376 | 35 | 34297 | 1334 | 25.7098950524738 | 0.825712438755102 | 0.825712438755102 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2011257000000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:57:38.151681Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| d51e8163-b729-4646-b4aa-2e0e5922d7a3 | 2026-09-28 13:14 | 2026-09-28 13:14 | 2026-09-28 13:14 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.7100 | 0.6900 | 0.7300 | 342.2800 | 44730.00 | 0.00 | 12567.00 | 630 | 7 | 26873 | 1334 | 20.1446776611694 | 0.33568860047502 | 0.33568860047502 | false | false | false | |||||||||||||||||
| 48e3433f-ddfb-4abc-b046-251ae46e3b67 | 2026-09-28 13:14 | 2026-09-28 13:14 | 2026-09-28 13:14 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.7500 | 0.7100 | 0.7500 | 342.3400 | 21150.00 | 21150.00 | 0.00 | 282 | 19 | 26242 | 1334 | 19.671664167916 | 0.347398240817734 | 0.340613036441366 | false | false | false | |||||||||||||||||
| 26bc360a-c1ba-4930-8783-b9a95a896c71 | 2026-09-28 13:11 | 2026-09-28 13:11 | 2026-09-28 13:11 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.4900 | 0.4600 | 0.4900 | 341.6100 | 10682.00 | 10682.00 | 0.00 | 218 | 5 | 25135 | 1334 | 18.8418290854573 | 0.352685586576573 | 0.352685586576573 | false | false | false | |||||||||||||||||
| 727dd16c-843d-4974-af2f-33d1eff343c5 | 2026-09-28 10:05 | 2026-09-28 10:05 | 2026-09-28 10:05 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.7300 | 0.7300 | 0.7900 | 341.2550 | 98331.00 | 0.00 | 98331.00 | 1347 | 47 | 5043 | 1334 | 3.78035982008995 | 0.353591995793045 | 0.353591995793045 | false | false | false | |||||||||||||||||
| 52d15b8e-156a-4143-93d0-0974dd9c73ff | 2026-09-28 09:37 | 2026-09-28 09:37 | 2026-09-28 09:37 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.7900 | 1.6800 | 1.8000 | 342.7800 | 10711.00 | 8938.00 | 1773.00 | 60 | 9 | 1810 | 1334 | 1.3568215892054 | 0.442485925171679 | 0.439765817047916 | false | false | false | |||||||||||||||||
| 08086073-f25e-49bd-b5d8-021918048ee0 | 2026-09-28 09:37 | 2026-09-28 09:37 | 2026-09-28 09:37 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.1100 | 2.0800 | 2.1900 | 343.2800 | 11605.00 | 0.00 | 11605.00 | 55 | 10 | 1591 | 1334 | 1.19265367316342 | 0.440049145361828 | 0.448591666411846 | true | false | false | |||||||||||||||||
| 1f92a844-bf00-4f5b-a7ce-7ca99d377ce4 | 2026-09-28 09:35 | 2026-09-28 09:35 | 2026-09-28 09:35 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.7700 | 1.7000 | 1.7700 | 342.7200 | 19470.00 | 19470.00 | 0.00 | 110 | 10 | 921 | 1334 | 0.690404797601199 | 0.447031577505519 | 0.447031577505519 | true | false | false | |||||||||||||||||
| 74f6a4d7-40e1-46bc-a11f-7154e8aec582 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.3900 | 1.3700 | 1.5500 | 341.1500 | 12100.00 | 0.00 | 12100.00 | 87 | 7 | 130 | 1334 | 0.0974512743628186 | 0.533034035607576 | 0.541419572462687 | false | false | false | |||||||||||||||||
| 614d1bd3-944d-4ab7-b509-f2953daee9b7 | 2026-09-25 14:12 | 2026-09-25 14:12 | 2026-09-25 14:12 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 3.4400 | 3.4000 | 3.5000 | 344.1100 | 24080.00 | 12728.00 | 11352.00 | 70 | 5 | 1917 | 1136 | 1.6875 | 0.200096552030496 | 0.200096552030496 | false | false | false | true | ||||||||||||||||
| bf4ced51-50e3-41e9-9610-a0326fa441d5 | 2026-09-24 11:02 | 2026-09-24 11:02 | 2026-09-24 11:02 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.4900 | 2.4500 | 2.5000 | 338.8300 | 12465.00 | 12465.00 | 0.00 | 50 | 5 | 791 | 1086 | 0.728360957642726 | 0.282428614614739 | 0.281681072434859 | false | false | false | |||||||||||||||||
| 320ca694-2b24-4dc5-993b-fbb622c94ad5 | 2026-09-24 10:29 | 2026-09-24 10:29 | 2026-09-24 10:29 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.6200 | 2.5700 | 2.7000 | 339.1600 | 20934.00 | 0.00 | 20934.00 | 80 | 6 | 543 | 1086 | 0.5 | 0.282148600123709 | 0.282148600123709 | false | false | false | true | ||||||||||||||||
| 3a5e5a4c-7359-449d-a296-a403024a6d8c | 2026-09-24 10:19 | 2026-09-24 10:19 | 2026-09-24 10:19 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.5300 | 2.5100 | 2.6200 | 338.7200 | 20493.00 | 0.00 | 20493.00 | 81 | 7 | 443 | 1086 | 0.407918968692449 | 0.282040184543429 | 0.287701843703401 | false | false | false | |||||||||||||||||
| b3d6f7e0-b0c6-4c4c-a7b6-3b89dda0b7ee | 2026-09-24 09:51 | 2026-09-24 09:51 | 2026-09-24 09:51 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.2000 | 2.2000 | 2.3200 | 337.7500 | 11880.00 | 0.00 | 11880.00 | 54 | 19 | 261 | 1086 | 0.240331491712707 | 0.285299854572175 | 0.28841310280031 | true | false | false | |||||||||||||||||
| 0273a6a6-0449-485e-b675-271eec7183c5 | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 4.5000 | 4.5000 | 4.7000 | 341.6600 | 45000.00 | 0.00 | 45000.00 | 100 | 7 | 1473 | 117 | 12.5897435897436 | 0.301854089522319 | 0.301854089522319 | false | false | false | |||||||||||||||||
| 6e1d9855-3d9c-4e73-bb98-6afd49ebaa18 | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | GOOGL | GOOGL260928C00342500 | call | 342.5000 | 2026-09-28 | 4.5100 | 4.5000 | 4.7000 | 341.7000 | 90109.00 | 0.00 | 90109.00 | 200 | 19 | 1373 | 117 | 11.7350427350427 | 0.300634669259845 | 0.300634669259845 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:11:57.740479Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:05:57.750889Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:35:57.715033Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:31:48.426973Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:21:25.715883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |