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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1a8d376a-3ea6-4ea4-bc5b-3c1796bb1580 | 2026-08-17 10:02 | 2026-08-17 10:02 | 2026-08-17 10:02 | XLF | XLF270115C00059000 | call | 59.0000 | 2027-01-15 | 2.2300 | 2.2200 | 2.2400 | 58.1097 | 90433.00 | 90433.00 | 0.00 | 405 | 5 | 405 | 2029 | 0.199605717102021 | 0.147471677449625 | 0.148143520245118 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54976867713.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 442c18c0-5ff6-488e-9651-091220684b88 | 2026-08-17 10:34 | 2026-08-17 10:34 | 2026-08-17 10:34 | XLF | XLF261120C00059000 | call | 59.0000 | 2026-11-20 | 1.5900 | 1.5800 | 1.6000 | 58.0650 | 34539.00 | 34539.00 | 0.00 | 217 | 10 | 217 | 1509 | 0.143803843605036 | 0.14816938201133 | 0.149016220809662 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54976867713.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 828b1531-16a1-4d1f-959d-3415a97fe054 | 2026-08-17 15:14 | 2026-08-17 15:14 | 2026-08-17 15:14 | XLF | XLF260918C00058000 | call | 58.0000 | 2026-09-18 | 0.8900 | 0.8900 | 0.9000 | 57.7500 | 33903.00 | 0.00 | 33903.00 | 381 | 9 | 1036 | 56220 | 0.0184276058342227 | 0.133050609836807 | 0.134516544606244 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54976867713.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4c9af731-95e7-4494-bd09-00c12641bad8 | 2026-08-18 09:51 | 2026-08-18 09:51 | 2026-08-18 09:51 | XLF | XLF260821C00056000 | call | 56.0000 | 2026-08-21 | 1.8600 | 1.8500 | 1.9500 | 57.8400 | 51609.00 | 34371.00 | 17238.00 | 277 | 12 | 480 | 55163 | 0.00870148469082537 | 0.305669819047421 | 0.194433711615584 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54976867713.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f71c380-fa76-4a8e-a991-77afe40f612a | 2026-09-08 12:30 | 2026-09-08 12:30 | 2026-09-08 12:30 | XLF | XLF281215C00070000 | call | 70.0000 | 2028-12-15 | 3.2500 | 3.1000 | 3.2500 | 57.5523 | 56177.00 | 56177.00 | 0.00 | 173 | 5 | 199 | 2198 | 0.0905368516833485 | 0.15691719457112 | 0.157218563154456 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54843778839.00 | — | — | — | 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 |
| 5dfaca84-7f50-4872-8c4d-e21585c74bf6 | 2026-09-15 15:55 | 2026-09-15 15:55 | 2026-09-15 15:55 | XLF | XLF260930P00056000 | put | 56.0000 | 2026-09-30 | 0.4900 | 0.4200 | 0.4900 | 56.0000 | 282484.00 | 282484.00 | 0.00 | 5771 | 12 | 15178 | 2227 | 6.81544678940278 | 0.1874160649372 | 0.1874160649372 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 54976867713.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 8792956d-5ef9-43c3-9156-35bf2a94528b | 2026-09-16 15:11 | 2026-09-16 15:11 | 2026-09-16 15:11 | XLF | XLF270319P00058000 | put | 58.0000 | 2027-03-19 | 3.4700 | 3.4500 | 3.6000 | 55.7300 | 156264.00 | 0.00 | 156264.00 | 450 | 8 | 2059 | 10859 | 0.18961230315867 | 0.183625610630918 | 0.186800725675632 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 55126892241.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 0d0c23b2-2c7c-4343-9b02-a0a58a053364 | 2026-09-21 13:23 | 2026-09-21 13:23 | 2026-09-21 13:23 | XLF | XLF261120P00057000 | put | 57.0000 | 2026-11-20 | 1.7400 | 1.7300 | 1.7700 | 56.0000 | 34732.00 | 0.00 | 34732.00 | 200 | 6 | 211 | 16270 | 0.0129686539643516 | 0.15465402718991 | 0.155768368707563 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 52856627577.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |