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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 05c7575d-db3e-4256-9949-f0bd5be3edae | 2026-09-15 12:47 | 2026-09-15 12:47 | 2026-09-15 12:47 | FOUR | FOUR261016P00035000 | put | 35.0000 | 2026-10-16 | 0.4500 | 0.4500 | 0.5000 | 43.0000 | 19398.00 | 0.00 | 19398.00 | 431 | 26 | 815 | 3012 | 0.27058432934927 | 0.665826389081324 | 0.661471077617105 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 3a083bf5-3e69-4450-9dda-b6b09bf3b7d6 | 2026-09-10 11:25 | 2026-09-10 11:24 | 2026-09-10 11:24 | FOUR | FOUR280121C00095000 | call | 95.0000 | 2028-01-21 | 3.3400 | 2.0500 | 3.8000 | 42.2250 | 16683.00 | 16683.00 | 0.00 | 50 | 22 | 81 | 303 | 0.267326732673267 | 0.638091254314081 | 0.638091254314081 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3604f7f9-fdba-4505-a716-8fc35bbb6918 | 2026-09-09 11:06 | 2026-09-09 11:06 | 2026-09-09 11:06 | FOUR | FOUR280121C00050000 | call | 50.0000 | 2028-01-21 | 9.8500 | 8.8000 | 10.1000 | 41.3950 | 26600.00 | 25600.00 | 1000.00 | 27 | 7 | 137 | 1443 | 0.0949410949410949 | 0.627260921336397 | 0.621988931780883 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a571c7b7-cdd7-441b-97a3-40feeb4702b8 | 2026-09-01 12:01 | 2026-09-01 12:01 | 2026-09-01 12:01 | FOUR | FOUR260918C00040000 | call | 40.0000 | 2026-09-18 | 3.4900 | 3.4000 | 3.7000 | 42.4050 | 17460.00 | 0.00 | 17460.00 | 50 | 6 | 52 | 1114 | 0.0466786355475763 | 0.57224005022163 | 0.57224005022163 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81c7f628-9d5b-4fa8-99dc-6887a952c83a | 2026-09-01 10:53 | 2026-09-01 10:53 | 2026-09-01 10:53 | FOUR | FOUR261016C00040000 | call | 40.0000 | 2026-10-16 | 5.1000 | 4.8000 | 5.4000 | 42.8225 | 10191.00 | 4101.00 | 5580.00 | 20 | 8 | 20 | 137 | 0.145985401459854 | 0.592052284078449 | 0.592052284078449 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fcd81710-8b04-471f-9d91-620a4e58e1c5 | 2026-08-28 12:25 | 2026-08-28 12:25 | 2026-08-28 12:25 | FOUR | FOUR280121P00045000 | put | 45.0000 | 2028-01-21 | 13.5100 | 12.5000 | 14.3000 | 44.6500 | 74302.00 | 74302.00 | 0.00 | 55 | 7 | 55 | 139 | 0.39568345323741 | 0.775023612636726 | 0.721252088082044 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3578472638.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |