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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 342c2cda-907b-4eba-9362-71e04d834cbf | 2026-08-21 11:57 | 2026-08-21 11:57 | 2026-08-21 11:57 | TE | TE261218C00010000 | call | 10.0000 | 2026-12-18 | 0.3900 | 0.3000 | 0.4000 | 4.5850 | 14207.00 | 14207.00 | 0.00 | 360 | 20 | 367 | 1964 | 0.186863543788187 | 1.30781855469588 | 1.33134235427834 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8fae18fd-3b65-4705-a26e-14d179fce63e | 2026-08-25 14:10 | 2026-08-25 14:10 | 2026-08-25 14:10 | TE | TE280121C00010000 | call | 10.0000 | 2028-01-21 | 1.8500 | 1.8000 | 1.8500 | 4.0000 | 27157.00 | 27157.00 | 0.00 | 147 | 9 | 608 | 8370 | 0.0726403823178017 | 1.27139505064855 | 1.28080778964996 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d97f1866-7910-4786-9f07-8290b4d3df26 | 2026-08-28 11:57 | 2026-08-28 11:57 | 2026-08-28 11:57 | TE | TE280121C00005000 | call | 5.0000 | 2028-01-21 | 2.5000 | 2.5000 | 2.6500 | 4.0000 | 172032.00 | 0.00 | 172032.00 | 688 | 23 | 913 | 5915 | 0.154353338968724 | 1.23404059941273 | 1.23404059941273 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3df3c62d-5411-449e-b9dd-9943221423a4 | 2026-08-31 13:58 | 2026-08-31 13:57 | 2026-08-31 13:57 | TE | TE280121C00005000 | call | 5.0000 | 2028-01-21 | 2.3300 | 2.2500 | 2.3500 | 4.0000 | 23260.00 | 23260.00 | 0.00 | 100 | 6 | 187 | 6161 | 0.0303522155494238 | 1.25093174467213 | 1.25093174467213 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3b7c3383-7f82-42d0-8697-b1c7bb1dfe8f | 2026-09-09 14:02 | 2026-09-09 14:02 | 2026-09-09 14:02 | TE | TE261218C00022000 | call | 22.0000 | 2026-12-18 | 0.1100 | 0.0000 | 0.1500 | 4.9050 | 10956.00 | 10956.00 | 0.00 | 1000 | 5 | 1000 | 1034 | 0.967117988394584 | 1.51480705230142 | 1.51480705230142 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 64091de1-639a-4796-8d9e-1cc07c6b24f5 | 2026-09-11 13:33 | 2026-09-11 13:33 | 2026-09-11 13:33 | TE | TE260925P00005000 | put | 5.0000 | 2026-09-25 | 0.5600 | 0.5500 | 0.6500 | 4.6500 | 11106.00 | 0.00 | 11106.00 | 200 | 9 | 206 | 827 | 0.249093107617896 | 0.937742917904938 | 0.995010368158137 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1287083278.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8cc8be75-fcdc-4aa4-9ef9-a481549ab625 | 2026-09-18 11:24 | 2026-09-18 11:23 | 2026-09-18 11:23 | TE | TE261016P00004000 | put | 4.0000 | 2026-10-16 | 0.3800 | 0.3500 | 0.4000 | 4.1000 | 11292.00 | 9857.00 | 1435.00 | 300 | 7 | 452 | 6942 | 0.0651109190435033 | 0.905681408270287 | 0.996492694305145 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 1228177865.00 | 2026-11-13 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |