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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 78caabf8-9a83-4a04-b598-e8fc53b1baa7 | 2026-08-18 14:18 | 2026-08-18 14:17 | 2026-08-18 14:17 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.7000 | 0.6000 | 0.7000 | 34.9350 | 37520.00 | 37520.00 | 0.00 | 536 | 44 | 667 | 14585 | 0.0457319163524169 | 0.29589460639369 | 0.29589460639369 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1114374024.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5327bcce-b165-484c-bd6e-d6057a2d98f7 | 2026-08-21 13:09 | 2026-08-21 13:08 | 2026-08-21 13:08 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.8100 | 0.6600 | 0.8100 | 34.4950 | 15714.00 | 15714.00 | 0.00 | 194 | 37 | 196 | 15139 | 0.0129466939692186 | 0.302237900935287 | 0.302237900935287 | false | false | false | |||||||||||||||||
| 5dfe43bf-44c0-4799-bc85-4064d19114e6 | 2026-08-27 13:45 | 2026-08-27 13:44 | 2026-08-27 13:44 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.8000 | 0.6700 | 0.8000 | 34.5750 | 33674.00 | 33674.00 | 0.00 | 421 | 47 | 428 | 15325 | 0.0279282218597064 | 0.298831298563544 | 0.309568882806997 | false | false | false | |||||||||||||||||
| c1c06393-a6d3-4e88-a703-294bea367437 | 2026-09-03 09:37 | 2026-09-03 09:37 | 2026-09-03 09:37 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.6300 | 0.6300 | 0.7800 | 33.9500 | 37485.00 | 0.00 | 37485.00 | 595 | 39 | 595 | 15612 | 0.0381117089418396 | 0.263682058440681 | 0.263682058440681 | false | false | false | |||||||||||||||||
| 053f1be3-c2a8-434c-8386-2ddc06101a22 | 2026-09-03 15:41 | 2026-09-03 15:41 | 2026-09-03 15:41 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.5400 | 0.5400 | 0.6400 | 34.0950 | 12258.00 | 0.00 | 12258.00 | 227 | 37 | 825 | 15612 | 0.0528439661798616 | 0.252125216879264 | 0.252125216879264 | false | false | false | |||||||||||||||||
| 0506503f-e856-427b-961f-7ef04bafe915 | 2026-09-14 15:48 | 2026-09-14 15:48 | 2026-09-14 15:48 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.6500 | 0.5400 | 0.6500 | 33.0000 | 15600.00 | 15600.00 | 0.00 | 240 | 24 | 242 | 15273 | 0.0158449551496104 | 0.258114234882684 | 0.258114234882684 | false | false | false | |||||||||||||||||
| 8d9f04fb-dcb2-4adf-a552-aeb914bf436c | 2026-09-21 14:55 | 2026-09-21 14:54 | 2026-09-21 14:54 | ASHR | ASHR261218P00031000 | put | 31.0000 | 2026-12-18 | 0.5200 | 0.4200 | 0.5300 | 34.2050 | 76908.00 | 76856.00 | 52.00 | 1479 | 47 | 1481 | 15598 | 0.0949480702654186 | 0.27458040921561 | 0.274375484172663 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 1114374024.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |