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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fe37c6b8-7a20-4610-ac24-8216096ed5e5 | 2026-08-18 09:50 | 2026-08-18 09:50 | 2026-08-18 09:50 | XLB | XLB260828P00052500 | put | 52.5000 | 2026-08-28 | 0.8200 | 0.5200 | 0.8300 | 52.0600 | 20176.00 | 20176.00 | 0.00 | 246 | 16 | 246 | 45 | 5.46666666666667 | 0.179176462119917 | 0.176185273852194 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.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 |
| bcd700e0-4d6b-4a2d-8c22-bec14c31f332 | 2026-08-21 13:12 | 2026-08-21 13:11 | 2026-08-21 13:11 | XLB | XLB261016C00051000 | call | 51.0000 | 2026-10-16 | 3.2900 | 3.2000 | 3.4000 | 53.5250 | 29638.00 | 3398.00 | 26240.00 | 90 | 7 | 96 | 0 | 0 | 0.198058373591021 | 0.178741300970819 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ebf7ee1-55e3-4876-a111-79b3e29ddfbc | 2026-09-01 12:41 | 2026-09-01 12:41 | 2026-09-01 12:41 | XLB | XLB261002C00051500 | call | 51.5000 | 2026-10-02 | 1.5400 | 1.3400 | 1.5500 | 52.2350 | 30339.00 | 30339.00 | 0.00 | 197 | 18 | 197 | 0 | 0 | 0.172028063339888 | 0.170261408330953 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17a284b0-e0d1-4fea-845c-653d4f7e34d1 | 2026-09-01 14:17 | 2026-09-01 14:16 | 2026-09-01 14:16 | XLB | XLB260925C00052500 | call | 52.5000 | 2026-09-25 | 0.8300 | 0.7100 | 1.0100 | 52.3350 | 26061.00 | 25980.00 | 81.00 | 314 | 19 | 314 | 473 | 0.66384778012685 | 0.159855182121131 | 0.154251611249504 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41ef0e15-b9b5-4f70-8ba1-8760f5e518df | 2026-09-03 12:46 | 2026-09-03 12:46 | 2026-09-03 12:46 | XLB | XLB261016C00053000 | call | 53.0000 | 2026-10-16 | 1.1700 | 1.1000 | 1.1800 | 52.7700 | 16171.00 | 16171.00 | 0.00 | 138 | 11 | 143 | 112 | 1.27678571428571 | 0.162489536353594 | 0.161104895779613 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b5617468-b856-4a7e-ad86-38c3d5bc5759 | 2026-09-04 09:45 | 2026-09-04 09:45 | 2026-09-04 09:45 | XLB | XLB260918C00052000 | call | 52.0000 | 2026-09-18 | 0.9300 | 0.7400 | 0.9400 | 52.3100 | 33854.00 | 33854.00 | 0.00 | 364 | 20 | 365 | 10 | 36.5 | 0.179440431172985 | 0.176928184478952 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ffccde6d-bf10-4969-8c88-73d9bd9388dd | 2026-09-04 13:45 | 2026-09-04 13:45 | 2026-09-04 13:45 | XLB | XLB261016P00054000 | put | 54.0000 | 2026-10-16 | 2.1300 | 1.9900 | 2.1400 | 52.5150 | 13425.00 | 13425.00 | 0.00 | 63 | 6 | 81 | 164 | 0.49390243902439 | 0.199447557953418 | 0.197969690660543 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 335f896d-2b32-4371-9f7a-24910b371ec6 | 2026-09-08 11:35 | 2026-09-08 11:35 | 2026-09-08 11:35 | XLB | XLB260925P00052000 | put | 52.0000 | 2026-09-25 | 0.7300 | 0.6100 | 0.7400 | 52.3400 | 26648.00 | 26648.00 | 0.00 | 365 | 25 | 379 | 13 | 29.1538461538462 | 0.20950633846029 | 0.207239332825638 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8238833883.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e8bbf5ef-845f-4f83-b133-6776d3bc7264 | 2026-09-16 10:05 | 2026-09-16 10:04 | 2026-09-16 10:04 | XLB | XLB261016C00051000 | call | 51.0000 | 2026-10-16 | 0.9500 | 0.9500 | 1.0700 | 50.8550 | 32226.00 | 96.00 | 32130.00 | 339 | 7 | 1055 | 1893 | 0.557316428948759 | 0.163416120992446 | 0.161696004717203 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8257890246.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| e0ae9c0c-50be-4f39-8914-0ceee4fd4847 | 2026-09-16 10:05 | 2026-09-16 10:04 | 2026-09-16 10:04 | XLB | XLB261016C00051000 | call | 51.0000 | 2026-10-16 | 0.9500 | 0.9500 | 1.0700 | 50.8550 | 11313.00 | 672.00 | 10641.00 | 119 | 9 | 1174 | 1893 | 0.620179609086107 | 0.163416120992446 | 0.161696004717203 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8257890246.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 27344781-e92d-4c58-8c2d-54c152462bce | 2026-09-18 10:39 | 2026-09-18 10:39 | 2026-09-18 10:39 | XLB | XLB261218C00053000 | call | 53.0000 | 2026-12-18 | 0.8600 | 0.7100 | 0.8600 | 50.0400 | 13669.00 | 13500.00 | 169.00 | 159 | 30 | 160 | 624 | 0.256410256410256 | 0.178540095950543 | 0.177831734943556 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8315852458.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 47e99de6-64a6-4211-8653-5f49ced09bb2 | 2026-09-21 10:32 | 2026-09-21 10:32 | 2026-09-21 10:32 | XLB | XLB261016P00048000 | put | 48.0000 | 2026-10-16 | 0.3900 | 0.3600 | 0.5000 | 49.8650 | 15286.00 | 0.00 | 15286.00 | 396 | 23 | 444 | 580 | 0.76551724137931 | 0.218596158722531 | 0.210935067209694 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 8099167640.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |