Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8a3da8b2-cc94-4977-ad10-fe7e4fc76f28 | 2026-09-02 15:56 | 2026-09-02 15:56 | 2026-09-02 15:56 | ASHR | ASHR260904C00033000 | call | 33.0000 | 2026-09-04 | 1.0400 | 1.0300 | 1.0400 | 34.0005 | 26200.00 | 25376.00 | 824.00 | 252 | 10 | 1688 | 0 | 0 | 0.306000165074098 | 0.279486605945105 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 1114374024.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8e9fda67-1d89-40d7-984f-d2dd7725c826 | 2026-09-10 09:56 | 2026-09-10 09:56 | 2026-09-10 09:56 | ASHR | ASHR261218P00033000 | put | 33.0000 | 2026-12-18 | 1.1400 | 1.1400 | 1.2300 | 33.7650 | 112293.00 | 117.00 | 112176.00 | 985 | 26 | 1012 | 1542 | 0.656290531776913 | 0.242739712476886 | 0.238218751151115 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 1114374024.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |