Simplify AnalyticsOptions 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 04e85042-4d74-423e-aa20-2e1ebb653e7e | 2026-09-15 14:04 | 2026-09-15 14:03 | 2026-09-15 14:03 | PG | PG261016C00145000 | call | 145.0000 | 2026-10-16 | 4.8500 | 4.7000 | 4.8500 | 147.0800 | 64491.00 | 64491.00 | 0.00 | 133 | 29 | 211 | 3214 | 0.0656502800248911 | 0.20098796171764 | 0.20098796171764 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 339669403058.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| d24aee2a-b2c0-4aa0-8f7e-724f1adcd283 | 2026-09-17 15:56 | 2026-09-17 15:56 | 2026-09-17 15:56 | PG | PG261016C00150000 | call | 150.0000 | 2026-10-16 | 2.2300 | 2.2200 | 2.2500 | 147.0000 | 60954.00 | 26100.00 | 34854.00 | 273 | 22 | 575 | 5095 | 0.112855740922473 | 0.184224655274106 | 0.184224655274106 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 342970098003.00 | 2026-10-23 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 78417598-d1ee-4015-b2c3-597406398554 | 2026-09-18 13:19 | 2026-09-18 13:19 | 2026-09-18 13:19 | PG | PG261009P00146000 | put | 146.0000 | 2026-10-09 | 2.2000 | 2.1600 | 2.3400 | 146.2800 | 53706.00 | 21536.00 | 32170.00 | 244 | 11 | 334 | 10 | 33.4 | 0.177880731226035 | 0.175721979322638 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 340273755653.00 | 2026-10-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |