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 |
|---|
| 142623ee-346e-4a78-ba49-527baa0c3e97 | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 2.9600 | 2.8700 | 2.9300 | 745.4900 | 10377.00 | 10377.00 | 0.00 | 35 | 6 | 3088 | 960 | 3.21666666666667 | 0.221899741621087 | 0.330942411290413 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 500943922525.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:34:19.672703Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 3bd0360f-e944-4c97-9db6-33c6a93c781a | 2026-09-25 09:53 | 2026-09-25 09:53 | 2026-09-25 09:53 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 3.7200 | 3.7200 | 3.7600 | 744.7461 | 22345.00 | 0.00 | 21971.00 | 60 | 5 | 542 | 960 | 0.564583333333333 | 0.205249812386032 | 0.20873619929258 | false | false | false | true | ||||||||||||||||
| 75ae82e4-a0a7-4aba-8f85-cf22cbe2d70b | 2026-09-25 09:42 | 2026-09-25 09:42 | 2026-09-25 09:42 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 4.3200 | 4.2600 | 4.3200 | 744.1818 | 10802.00 | 10802.00 | 0.00 | 25 | 12 | 148 | 960 | 0.154166666666667 | 0.229185939812411 | 0.229185939812411 | true | false | false | true | ||||||||||||||||
| 1528c161-0cb0-4bfc-90fa-d55717da13f1 | 2026-09-24 13:01 | 2026-09-24 13:01 | 2026-09-24 13:01 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 7.3300 | 7.2600 | 7.3300 | 741.4750 | 44710.00 | 44710.00 | 0.00 | 61 | 6 | 723 | 693 | 1.04329004329004 | 0.198425307720968 | 0.199333709825916 | false | false | false | true | ||||||||||||||||
| e3e2b71e-5841-4266-a8ad-944037268f11 | 2026-09-24 11:13 | 2026-09-24 11:13 | 2026-09-24 11:13 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 13.0000 | 12.3100 | 13.0000 | 735.0000 | 39000.00 | 39000.00 | 0.00 | 30 | 5 | 242 | 693 | 0.349206349206349 | 0.190430646725652 | 0.190430646725652 | false | false | false | true | ||||||||||||||||
| 2d6a9040-9ed1-48c8-8e6c-4ed1fc3ad7ca | 2026-09-23 10:15 | 2026-09-23 10:15 | 2026-09-23 10:15 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 8.5400 | 8.4700 | 8.5500 | 740.4400 | 13664.00 | 13664.00 | 0.00 | 16 | 7 | 712 | 999 | 0.712712712712713 | 0.17030160719605 | 0.169815027447771 | false | false | false | true | ||||||||||||||||
| 94786ec0-143e-487a-8720-804bada0d17d | 2026-09-23 10:15 | 2026-09-23 10:15 | 2026-09-23 10:15 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 8.7100 | 8.5400 | 8.7100 | 740.3400 | 30485.00 | 30485.00 | 0.00 | 35 | 5 | 696 | 999 | 0.696696696696697 | 0.175496071809743 | 0.175496071809743 | false | false | false | true | ||||||||||||||||
| 2d760060-caf6-4ee6-816f-d59092515735 | 2026-09-22 15:57 | 2026-09-22 15:57 | 2026-09-22 15:57 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 4.4800 | 4.4600 | 4.5000 | 747.3700 | 11200.00 | 0.00 | 9408.00 | 25 | 5 | 2156 | 63 | 34.2222222222222 | 0.158443439483994 | 0.158443439483994 | true | false | false | true | ||||||||||||||||
| 740aa8b5-c451-40c1-9faa-0aa6c88f4c83 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | QQQ | QQQ260925P00748000 | put | 748.0000 | 2026-09-25 | 4.4800 | 4.4600 | 4.5000 | 747.3400 | 12992.00 | 0.00 | 11648.00 | 29 | 6 | 2105 | 63 | 33.4126984126984 | 0.158254057985205 | 0.157874833793645 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 500943922525.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:54:35.682199Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 500943922525.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:43:32.172352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 497207767216.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 497207767216.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498637580106.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 498637580106.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 495805413150.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 495805413150.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |