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_alerts658,639 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 |
|---|
| e5f3f884-a9f9-4401-be09-c35f2a088443 | 2026-09-02 10:51 | 2026-09-02 10:51 | 2026-09-02 10:51 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.5800 | 5.5000 | 5.7000 | 7672.7300 | 125020.00 | 0.00 | 123900.00 | 224 | 39 | 22522 | 703 | 32.0369843527738 | 0.146533665097411 | 0.145021012926283 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 91a07ebc-5d96-4b80-b7b1-dfea9c271832 | 2026-09-02 10:53 | 2026-09-02 10:52 | 2026-09-02 10:52 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.3100 | 5.2000 | 5.5000 | 7672.7900 | 103610.00 | 10070.00 | 93540.00 | 195 | 38 | 23024 | 703 | 32.75106685633 | 0.144071492683348 | 0.144071492683348 | false | false | false | |||||||||||||||||
| f44cb6b7-a2f2-4b54-b025-3af955cee229 | 2026-09-02 10:53 | 2026-09-02 10:53 | 2026-09-02 10:53 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.6700 | 5.6000 | 5.8000 | 7671.5400 | 114480.00 | 0.00 | 114480.00 | 202 | 43 | 23528 | 703 | 33.4679943100996 | 0.142692648053431 | 0.142692648053431 | true | false | false | |||||||||||||||||
| 5adad556-a969-4447-8630-586657adb246 | 2026-09-02 10:54 | 2026-09-02 10:54 | 2026-09-02 10:54 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.7600 | 5.7000 | 5.9000 | 7671.3300 | 115840.00 | 590.00 | 113510.00 | 201 | 35 | 24582 | 703 | 34.9672830725462 | 0.143370842570659 | 0.141878984135427 | true | false | false | |||||||||||||||||
| 20705e83-7928-4a7a-a823-11e77f95ba38 | 2026-09-02 10:55 | 2026-09-02 10:54 | 2026-09-02 10:54 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.9500 | 5.8000 | 6.1000 | 7669.9600 | 221240.00 | 91210.00 | 106920.00 | 372 | 120 | 25257 | 703 | 35.927453769559 | 0.139555500666262 | 0.13809158964836 | true | false | false | |||||||||||||||||
| 15c540bc-cc99-4853-963f-9372f2f997eb | 2026-09-02 10:55 | 2026-09-02 10:55 | 2026-09-02 10:55 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.5600 | 5.5000 | 5.7000 | 7671.7500 | 111160.00 | 0.00 | 94360.00 | 200 | 32 | 25619 | 703 | 36.4423897581792 | 0.143705661036421 | 0.141125905637078 | true | false | false | |||||||||||||||||
| 26b35f9c-9683-467e-8fc8-eb69191d6555 | 2026-09-02 10:55 | 2026-09-02 10:55 | 2026-09-02 10:55 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.5000 | 5.4000 | 5.7000 | 7671.9200 | 111070.00 | 0.00 | 105000.00 | 202 | 42 | 26095 | 703 | 37.1194879089616 | 0.143559105871534 | 0.140535405989472 | true | false | false | |||||||||||||||||
| a88af62f-5adc-47a8-adb4-93aa7d16b56a | 2026-09-02 10:56 | 2026-09-02 10:55 | 2026-09-02 10:55 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.5600 | 5.5000 | 5.7000 | 7672.2300 | 115110.00 | 560.00 | 103350.00 | 207 | 43 | 26331 | 703 | 37.4551920341394 | 0.145107011624369 | 0.145107011624369 | false | false | false | |||||||||||||||||
| 74c620fc-dff0-441a-bfed-d5c509858913 | 2026-09-02 11:23 | 2026-09-02 11:23 | 2026-09-02 11:23 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 3.5700 | 3.5000 | 3.8000 | 7675.9600 | 107040.00 | 0.00 | 103340.00 | 300 | 44 | 34953 | 703 | 49.7197724039829 | 0.138206844441729 | 0.136427544696477 | false | false | false | |||||||||||||||||
| 9dd1786d-3d61-4db4-a5fd-f557aac52f86 | 2026-09-02 11:51 | 2026-09-02 11:51 | 2026-09-02 11:51 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.0900 | 5.0000 | 5.3000 | 7668.8300 | 130910.00 | 1040.00 | 123210.00 | 257 | 37 | 46526 | 703 | 66.1820768136558 | 0.13344780847683 | 0.13344780847683 | true | false | false | |||||||||||||||||
| 471af764-453b-4ac3-a662-fb7ef20a0927 | 2026-09-02 11:51 | 2026-09-02 11:51 | 2026-09-02 11:51 | SPXW | SPXW260902P07660000 | put | 7660.0000 | 2026-09-02 | 5.2200 | 5.0000 | 5.4000 | 7668.8300 | 191550.00 | 5840.00 | 164760.00 | 367 | 66 | 46269 | 703 | 65.8165007112376 | 0.136699815991181 | 0.136704346659236 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |