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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3b371f1d-a99d-4652-afe9-70dea1a87056 | 2026-09-18 15:46 | 2026-09-18 15:46 | 2026-09-18 15:46 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 0.9500 | 0.9000 | 0.9500 | 36.4950 | 37430.00 | 37430.00 | 0.00 | 394 | 30 | 1206 | 9725 | 0.12401028277635 | 0.330608979750787 | 0.330608979750787 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 19384288943.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a1bfd346-723d-4c65-9f12-ac11295262b5 | 2026-09-08 10:23 | 2026-09-08 10:23 | 2026-09-08 10:23 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 1.5100 | 1.4500 | 1.5500 | 37.1550 | 16170.00 | 15420.00 | 0.00 | 107 | 5 | 148 | 1678 | 0.0882002383790226 | 0.343175011842601 | 0.334811301057768 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84f0c096-118e-4c75-abf6-f4fa8d5a780d | 2026-09-03 14:27 | 2026-09-03 14:27 | 2026-09-03 14:27 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 2.6500 | 2.6500 | 2.7500 | 39.1200 | 42422.00 | 0.00 | 42422.00 | 160 | 7 | 821 | 1680 | 0.488690476190476 | 0.307420410871092 | 0.307420410871092 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e6afff3-b207-4776-a129-72017cea0793 | 2026-09-03 10:38 | 2026-09-03 10:38 | 2026-09-03 10:38 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 2.5500 | 2.5000 | 2.6000 | 38.9100 | 51000.00 | 45900.00 | 5100.00 | 200 | 7 | 207 | 1680 | 0.123214285714286 | 0.314267782724577 | 0.314267782724577 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 56c9c68b-11eb-433f-97ef-f6816235540e | 2026-08-25 15:15 | 2026-08-25 15:15 | 2026-08-25 15:15 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 3.3900 | 3.3000 | 3.5000 | 39.9300 | 13224.00 | 0.00 | 12204.00 | 39 | 5 | 444 | 2136 | 0.207865168539326 | 0.30491340338006 | 0.30491340338006 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0d4f294b-9664-4e2e-9f37-d1a4e57de1db | 2026-08-17 15:30 | 2026-08-17 15:30 | 2026-08-17 15:30 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 2.3500 | 2.3500 | 2.4000 | 38.1410 | 10105.00 | 0.00 | 10105.00 | 43 | 5 | 139 | 2149 | 0.0646812470916705 | 0.308507907771739 | 0.308507907771739 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |