Simplify AnalyticsOptions 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0d8f4269-6896-4267-b17e-7e386da27cf9 | 2026-09-14 13:41 | 2026-09-14 13:41 | 2026-09-14 13:41 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 12.5600 | 12.4400 | 12.6300 | 712.3000 | 125626.00 | 125626.00 | 0.00 | 100 | 5 | 272 | 1136 | 0.23943661971831 | 0.17596175776785 | 0.175749834715347 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e64e71b-3c79-4b60-8594-9a1ae28fef17 | 2026-09-18 15:54 | 2026-09-18 15:54 | 2026-09-18 15:54 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 5.5000 | 5.4500 | 5.5300 | 720.0000 | 110064.00 | 36498.00 | 0.00 | 200 | 7 | 4356 | 1500 | 2.904 | 0.145052454939601 | 0.146059214418265 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 485431540564.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8583df63-5c7a-4d59-bce5-305f607e0a46 | 2026-09-21 10:19 | 2026-09-21 10:19 | 2026-09-21 10:19 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 1.3600 | 1.3500 | 1.3700 | 733.6400 | 40626.00 | 40626.00 | 0.00 | 298 | 26 | 3431 | 2860 | 1.19965034965035 | 0.194224441555473 | 0.1943908866601 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9124c0f5-d7b2-4631-a4c8-31b2295c292a | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 1.1600 | 1.1600 | 1.1700 | 735.8600 | 11484.00 | 0.00 | 11484.00 | 99 | 7 | 5036 | 2860 | 1.76083916083916 | 0.201860643041722 | 0.201860643041722 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d727a640-a6b5-482c-b5b0-0536e3cda65d | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 1.1600 | 1.1500 | 1.1600 | 735.9300 | 12296.00 | 12296.00 | 0.00 | 106 | 6 | 5143 | 2860 | 1.79825174825175 | 0.20243726466245 | 0.20243726466245 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ef4e1d7c-a3b9-4617-81ac-4f653931375a | 2026-09-21 12:09 | 2026-09-21 12:09 | 2026-09-21 12:09 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 0.9500 | 0.9400 | 0.9500 | 737.8800 | 23275.00 | 23275.00 | 0.00 | 245 | 13 | 7491 | 2860 | 2.61923076923077 | 0.205294733274064 | 0.205294733274064 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b1d239f2-01e3-4c9c-a4bc-21db6316eba2 | 2026-09-21 12:09 | 2026-09-21 12:09 | 2026-09-21 12:09 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 0.9400 | 0.9400 | 0.9500 | 737.8800 | 18800.00 | 0.00 | 18800.00 | 200 | 11 | 7692 | 2860 | 2.68951048951049 | 0.204648168571584 | 0.204648168571584 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b6292ae9-aee2-4301-9ea9-f479ebc182c9 | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 0.7800 | 0.7700 | 0.7800 | 741.2500 | 15600.00 | 15600.00 | 0.00 | 200 | 16 | 11130 | 2860 | 3.89160839160839 | 0.218813791227322 | 0.218813791227322 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 21895475-5daf-49a1-9bd0-6a3dc2e8f91f | 2026-09-21 15:57 | 2026-09-21 15:57 | 2026-09-21 15:57 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 0.7700 | 0.7600 | 0.7700 | 741.8400 | 38500.00 | 38500.00 | 0.00 | 500 | 7 | 14061 | 2860 | 4.91643356643357 | 0.222333510847145 | 0.222333510847145 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| a9b56510-4ed8-413a-8e52-520468bfb4c8 | 2026-09-21 15:57 | 2026-09-21 15:57 | 2026-09-21 15:57 | QQQ | QQQ260925P00720000 | put | 720.0000 | 2026-09-25 | 0.7800 | 0.7600 | 0.7800 | 741.7700 | 12713.00 | 12636.00 | 0.00 | 163 | 13 | 14224 | 2860 | 4.97342657342657 | 0.221827583480686 | 0.222589816251764 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 484276301501.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |