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 | 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 |
|---|
| 6811ac13-b30a-4fe2-afe6-10d7f577a9f3 | 2026-08-18 09:34 | 2026-08-18 09:34 | 2026-08-18 09:34 | SPY | SPY260819P00769000 | put | 769.0000 | 2026-08-19 | 2.6400 | 2.6200 | 2.6600 | 768.1400 | 112464.00 | 75504.00 | 36960.00 | 426 | 12 | 3554 | 2315 | 1.53520518358531 | 0.138846461359872 | 0.138846461359872 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4c274620-9526-4a34-9aca-ccd52ebaf497 | 2026-08-19 10:17 | 2026-08-19 10:17 | 2026-08-19 10:17 | SPY | SPY260819P00769000 | put | 769.0000 | 2026-08-19 | 0.9200 | 0.9000 | 0.9400 | 769.6295 | 158005.00 | 86673.00 | 70872.00 | 1716 | 316 | 147028 | 5708 | 25.7582340574632 | 0.153975308564088 | 0.156693237984404 | true | false | false | true | ||||||||||||||||
| c531a70b-0cfd-4774-99e5-e08be00e0145 | 2026-08-19 10:22 | 2026-08-19 10:22 | 2026-08-19 10:22 | SPY | SPY260819P00769000 | put | 769.0000 | 2026-08-19 | 1.0100 | 0.9900 | 1.0000 | 769.4399 | 109153.00 | 103510.00 | 5643.00 | 1085 | 24 | 167026 | 5708 | 29.2617379117029 | 0.155208378997577 | 0.15501229651786 | true | false | false | true | ||||||||||||||||
| 22e189c3-9861-44f8-b159-a5f8899745ba | 2026-08-19 14:07 | 2026-08-19 14:07 | 2026-08-19 14:07 | SPY | SPY260819P00769000 | put | 769.0000 | 2026-08-19 | 0.6000 | 0.5900 | 0.6200 | 769.2000 | 122033.00 | 120263.00 | 1770.00 | 2034 | 33 | 532826 | 5708 | 93.3472319551507 | 0.163609876687592 | 0.160099341877642 | true | false | false | true | ||||||||||||||||
| d6620a4f-7756-4426-b62c-e025e337348e | 2026-08-19 15:45 | 2026-08-19 15:45 | 2026-08-19 15:45 | SPY | SPY260819P00769000 | put | 769.0000 | 2026-08-19 | 0.3000 | 0.2900 | 0.3200 | 769.0600 | 121860.00 | 95781.00 | 26079.00 | 4014 | 164 | 755314 | 5708 | 132.325508058865 | 0.212699829446568 | 0.208329491508473 | false | false | false | true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |