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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87810f13-34fc-406b-9e49-838f99af3154 | 2026-08-25 09:30 | 2026-08-25 09:30 | 2026-08-25 09:30 | PR | PR261016C00025000 | call | 25.0000 | 2026-10-16 | 0.7500 | 0.6500 | 0.8000 | 23.1900 | 12542.00 | 7200.00 | 4362.00 | 167 | 16 | 167 | 35847 | 0.00465868831422434 | 0.416804789186362 | 0.412446462563379 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f634ab22-fe5f-467d-b546-8326e5e3ed68 | 2026-08-24 10:43 | 2026-08-24 10:43 | 2026-08-24 10:43 | PR | PR261016C00025000 | call | 25.0000 | 2026-10-16 | 0.8600 | 0.8500 | 0.9000 | 23.6150 | 11630.00 | 0.00 | 11630.00 | 136 | 8 | 737 | 34317 | 0.021476236267739 | 0.382151326331511 | 0.376351056060256 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37fd5c83-c787-4d3c-8776-ba1e8c355998 | 2026-08-19 13:42 | 2026-08-19 13:42 | 2026-08-19 13:42 | PR | PR261016C00025000 | call | 25.0000 | 2026-10-16 | 0.7100 | 0.7000 | 0.7500 | 22.9800 | 22212.00 | 0.00 | 20882.00 | 315 | 18 | 28824 | 4632 | 6.22279792746114 | 0.386887350824951 | 0.380873113823904 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 860ed8ab-a1c6-4ed5-a6c1-216d48849eba | 2026-08-19 13:29 | 2026-08-19 13:29 | 2026-08-19 13:29 | PR | PR261016C00025000 | call | 25.0000 | 2026-10-16 | 0.6900 | 0.6500 | 0.7000 | 22.8650 | 10355.00 | 10355.00 | 0.00 | 151 | 13 | 26821 | 4632 | 5.7903713298791 | 0.392291891676832 | 0.389240139946815 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9c2e5f96-a37b-4060-bcba-28c6550a2d89 | 2026-08-19 13:05 | 2026-08-19 13:05 | 2026-08-19 13:05 | PR | PR261016C00025000 | call | 25.0000 | 2026-10-16 | 0.7100 | 0.6500 | 0.7500 | 23.0500 | 18248.00 | 730.00 | 14228.00 | 257 | 22 | 18205 | 4632 | 3.9302677029361 | 0.379364584414888 | 0.382844330886366 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89f34a89-3ae6-4b29-9fc0-03003dddb454 | 2026-08-14 15:53 | 2026-08-14 15:53 | 2026-08-14 15:53 | PR | PR260821P00021000 | put | 21.0000 | 2026-08-21 | 0.3000 | 0.1500 | 0.3000 | 21.4800 | 29978.00 | 29978.00 | 0.00 | 1000 | 71 | 1001 | 1206 | 0.830016583747927 | 0.434697227142214 | 0.434697227142214 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19900355009.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |