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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c546614c-b50e-4569-bf61-6dbc7f25dc69 | 2026-09-18 15:24 | 2026-09-18 15:24 | 2026-09-18 15:24 | TSLA | TSLA260921C00365000 | call | 365.0000 | 2026-09-21 | 3.2300 | 3.1500 | 3.3000 | 364.0900 | 104955.00 | 0.00 | 104305.00 | 325 | 65 | 33776 | 2043 | 16.5325501713167 | 0.269374670578762 | 0.267885937949599 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1438701629212.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e7c7f9a8-04e0-46ee-8c34-5f6e088b8835 | 2026-09-17 11:25 | 2026-09-17 11:25 | 2026-09-17 11:25 | TSLA | TSLA260921C00365000 | call | 365.0000 | 2026-09-21 | 6.4000 | 6.3000 | 6.4000 | 365.9900 | 128000.00 | 128000.00 | 0.00 | 200 | 10 | 3367 | 1386 | 2.42929292929293 | 0.380589290173613 | 0.380589290173613 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1446324255683.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 1b6540c0-1c26-4fa8-8841-c9d7fec28a78 | 2026-09-16 10:41 | 2026-09-16 10:41 | 2026-09-16 10:41 | TSLA | TSLA260921C00365000 | call | 365.0000 | 2026-09-21 | 6.2800 | 6.1000 | 6.3000 | 363.3500 | 316550.00 | 316550.00 | 0.00 | 504 | 35 | 1641 | 829 | 1.9794933655006 | 0.41323059078376 | 0.411975665257344 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 1414253930844.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5ca37aba-9f0c-40c9-98fd-562e06c6e9cd | 2026-09-08 12:29 | 2026-09-08 12:29 | 2026-09-08 12:29 | TSLA | TSLA260921C00365000 | call | 365.0000 | 2026-09-21 | 13.5000 | 13.2000 | 13.5000 | 368.3100 | 135000.00 | 135000.00 | 0.00 | 100 | 11 | 537 | 0 | 0 | 0.416937730892494 | 0.416937730892494 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1417769028024.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |