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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cffc724c-8390-4507-b054-810a74579f9b | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GOOGL | GOOGL260925P00350000 | put | 350.0000 | 2026-09-25 | 5.7000 | 5.7000 | 5.9500 | 349.0000 | 114000.00 | 0.00 | 114000.00 | 200 | 6 | 1658 | 449 | 3.69265033407572 | 0.281017273145549 | 0.281017273145549 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2051100720000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| ed98975c-3fff-4767-8391-a87c9b5cf134 | 2026-09-21 11:13 | 2026-09-21 11:13 | 2026-09-21 11:13 | GOOGL | GOOGL260925P00350000 | put | 350.0000 | 2026-09-25 | 2.9100 | 2.8600 | 2.9500 | 354.7800 | 14550.00 | 4947.00 | 9603.00 | 50 | 7 | 1139 | 1070 | 1.06448598130841 | 0.339390988568933 | 0.339390988568933 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2082963960000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| a35ac971-2327-4275-bbe3-72c185304307 | 2026-09-21 11:59 | 2026-09-21 11:59 | 2026-09-21 11:59 | GOOGL | GOOGL260925P00350000 | put | 350.0000 | 2026-09-25 | 2.2700 | 2.2700 | 2.3500 | 356.9385 | 92843.00 | 0.00 | 92843.00 | 409 | 36 | 1746 | 1070 | 1.63177570093458 | 0.341656267395961 | 0.341656267395961 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2082963960000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d455c09e-e2d3-4754-a565-17cf7db6dfa6 | 2026-09-21 12:00 | 2026-09-21 11:59 | 2026-09-21 11:59 | GOOGL | GOOGL260925P00350000 | put | 350.0000 | 2026-09-25 | 2.2700 | 2.2700 | 2.3500 | 356.9600 | 22700.00 | 0.00 | 22700.00 | 100 | 10 | 1846 | 1070 | 1.72523364485981 | 0.342135889956772 | 0.342135889956772 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2082963960000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:04:05.802260Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d9beff01-9563-403f-a341-605ee59caeac | 2026-09-21 13:38 | 2026-09-21 13:38 | 2026-09-21 13:38 | GOOGL | GOOGL260925P00350000 | put | 350.0000 | 2026-09-25 | 2.4400 | 2.4400 | 2.5300 | 356.0000 | 18544.00 | 0.00 | 18544.00 | 76 | 11 | 2138 | 1070 | 1.9981308411215 | 0.335983677844295 | 0.335983677844295 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2082963960000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |