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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e201571b-9dd7-418d-b61c-436f719cbd37 | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | TEM | TEM261016P00070000 | put | 70.0000 | 2026-10-16 | 2.8700 | 2.5200 | 2.9500 | 77.0000 | 25830.00 | 25830.00 | 0.00 | 90 | 13 | 1262 | 1096 | 1.1514598540146 | 0.747167943535297 | 0.747167943535297 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 13652432871.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a7f07dd6-fac5-4389-b3a2-accbafd0d853 | 2026-09-18 09:30 | 2026-09-18 09:30 | 2026-09-18 09:30 | TEM | TEM261016P00070000 | put | 70.0000 | 2026-10-16 | 2.8500 | 2.2100 | 2.8500 | 79.7000 | 11685.00 | 11685.00 | 0.00 | 41 | 12 | 46 | 1096 | 0.041970802919708 | 0.810108002360433 | 0.810108002360433 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 13652432871.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8767a106-0849-4410-b32d-7e5ef6c021e2 | 2026-09-03 15:19 | 2026-09-03 15:19 | 2026-09-03 15:19 | TEM | TEM261016P00070000 | put | 70.0000 | 2026-10-16 | 9.7000 | 9.7000 | 9.9000 | 64.3850 | 27160.00 | 0.00 | 27160.00 | 28 | 13 | 32 | 401 | 0.0798004987531172 | 0.733161272255294 | 0.734820657648974 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10911072057.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df93d659-19b0-4e54-85c6-1bcb50dc024c | 2026-08-26 13:40 | 2026-08-26 13:39 | 2026-08-26 13:39 | TEM | TEM261016P00070000 | put | 70.0000 | 2026-10-16 | 8.0000 | 7.7000 | 8.0500 | 69.4600 | 12800.00 | 8000.00 | 4000.00 | 16 | 5 | 57 | 347 | 0.164265129682997 | 0.765812544878334 | 0.765812544878334 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10911072057.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc7a5f92-8bec-4c1a-ac39-2b5558835ab9 | 2026-08-26 13:40 | 2026-08-26 13:39 | 2026-08-26 13:39 | TEM | TEM261016P00070000 | put | 70.0000 | 2026-10-16 | 7.9400 | 7.8000 | 8.0000 | 69.4600 | 21450.00 | 19875.00 | 1575.00 | 27 | 7 | 36 | 347 | 0.103746397694524 | 0.760941816178818 | 0.760941816178818 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10911072057.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |