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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| af9ce1b3-1616-4abe-a48f-98e879cbf12a | 2026-08-18 10:53 | 2026-08-18 10:53 | 2026-08-18 10:53 | FLEX | FLEX261016C00145000 | call | 145.0000 | 2026-10-16 | 4.9000 | 4.5000 | 4.9000 | 120.8100 | 180803.00 | 180803.00 | 0.00 | 369 | 44 | 369 | 500 | 0.738 | 0.637005104650213 | 0.637005104650213 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| beb100c6-86be-4fd7-8362-05c41cf554bf | 2026-08-19 09:34 | 2026-08-19 09:33 | 2026-08-19 09:33 | FLEX | FLEX280121C00120000 | call | 120.0000 | 2028-01-21 | 41.9900 | 39.3000 | 42.0000 | 118.7250 | 281310.00 | 20910.00 | 0.00 | 67 | 5 | 67 | 68 | 0.985294117647059 | 0.731176698519066 | 0.727184832453567 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9164d811-4cad-4539-a1e5-ba1a2d536376 | 2026-08-19 10:14 | 2026-08-19 10:14 | 2026-08-19 10:14 | FLEX | FLEX280121C00100000 | call | 100.0000 | 2028-01-21 | 43.1300 | 43.1000 | 47.6000 | 113.1400 | 224270.00 | 0.00 | 224270.00 | 52 | 6 | 56 | 412 | 0.135922330097087 | 0.686386369282319 | 0.686386369282319 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ddcd072-57fe-43b5-9137-3fa910609220 | 2026-08-21 10:16 | 2026-08-21 10:16 | 2026-08-21 10:16 | FLEX | FLEX261016P00100000 | put | 100.0000 | 2026-10-16 | 6.6000 | 6.3000 | 6.6000 | 108.3850 | 80516.00 | 80516.00 | 0.00 | 122 | 31 | 122 | 137 | 0.89051094890511 | 0.647472714414054 | 0.647472714414054 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 95369db7-d4b2-49e2-9a32-560c64763a45 | 2026-08-24 15:55 | 2026-08-24 15:55 | 2026-08-24 15:55 | FLEX | FLEX261016P00110000 | put | 110.0000 | 2026-10-16 | 11.8100 | 11.0000 | 12.3000 | 106.2750 | 23620.00 | 3560.00 | 20060.00 | 20 | 20 | 135 | 534 | 0.252808988764045 | 0.629403913759763 | 0.621512562076059 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff9fd856-c1d7-4217-af2d-27e9437afff5 | 2026-08-26 12:19 | 2026-08-26 12:19 | 2026-08-26 12:19 | FLEX | FLEX260918C00130000 | call | 130.0000 | 2026-09-18 | 1.5800 | 1.5000 | 1.9000 | 111.1500 | 11672.00 | 1085.00 | 10587.00 | 74 | 11 | 133 | 998 | 0.133266533066132 | 0.62271028646374 | 0.610371755229298 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 69b25c27-cba8-4e95-9b43-fd843175c315 | 2026-09-03 14:53 | 2026-09-03 14:53 | 2026-09-03 14:53 | FLEX | FLEX260918P00110000 | put | 110.0000 | 2026-09-18 | 6.1500 | 5.9000 | 6.2000 | 107.8800 | 69550.00 | 57350.00 | 6100.00 | 113 | 22 | 553 | 1453 | 0.380591878871301 | 0.587125685804332 | 0.575923146588523 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 18ebb212-5853-48d3-aa7c-df5ba9aa6773 | 2026-09-04 10:14 | 2026-09-04 10:14 | 2026-09-04 10:14 | FLEX | FLEX270115C00120000 | call | 120.0000 | 2027-01-15 | 13.5100 | 10.5000 | 15.6000 | 110.2800 | 405436.00 | 405436.00 | 0.00 | 300 | 8 | 300 | 1121 | 0.267618198037467 | 0.631504170281116 | 0.631504170281116 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f13d15ab-d719-40bd-83ec-10ddfebf3984 | 2026-09-11 10:21 | 2026-09-11 10:21 | 2026-09-11 10:21 | FLEX | FLEX261016C00135000 | call | 135.0000 | 2026-10-16 | 2.8500 | 2.8000 | 3.0000 | 115.5800 | 33010.00 | 25080.00 | 3085.00 | 116 | 13 | 393 | 3409 | 0.115283074215312 | 0.613839913634602 | 0.613839913634602 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 938b663c-4412-4d6d-9dbe-8daa8a2d3465 | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | FLEX | FLEX261016P00115000 | put | 115.0000 | 2026-10-16 | 10.0200 | 9.9000 | 10.5000 | 110.6800 | 34052.00 | 0.00 | 34052.00 | 34 | 6 | 58 | 459 | 0.12636165577342 | 0.595364337597035 | 0.595364337597035 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a31a954-abe2-4d88-9870-e35f099e8bcc | 2026-09-17 14:03 | 2026-09-17 14:02 | 2026-09-17 14:02 | FLEX | FLEX270219P00125000 | put | 125.0000 | 2027-02-19 | 26.1700 | 26.1000 | 27.1000 | 110.6550 | 18320.00 | 10480.00 | 7840.00 | 7 | 6 | 23 | 3 | 7.66666666666667 | 0.641912493113668 | 0.638432515347937 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40272312662.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 6ff4fe13-0530-4ada-883b-a52670bd22fd | 2026-09-18 15:42 | 2026-09-18 15:42 | 2026-09-18 15:42 | FLEX | FLEX260918P00120000 | put | 120.0000 | 2026-09-18 | 11.5700 | 11.4000 | 12.3000 | 108.3500 | 42795.00 | 13920.00 | 4620.00 | 37 | 6 | 973 | 1298 | 0.749614791987673 | 7.19414989164845 | 7.19414989164845 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 40083917143.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |