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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d4fd201d-fb7b-407a-b964-5abb0d860b99 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | FISV | FISV260918C00055000 | call | 55.0000 | 2026-09-18 | 1.5000 | 1.4500 | 1.5500 | 52.5200 | 12742.00 | 0.00 | 1192.00 | 85 | 6 | 743 | 103811 | 0.00715723767230833 | 0.389944542634783 | 0.389944542634783 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec8c55b7-8475-41fb-abac-3cf1f145b4fd | 2026-09-01 10:45 | 2026-09-01 10:45 | 2026-09-01 10:45 | FISV | FISV270617C00065000 | call | 65.0000 | 2027-06-17 | 4.6500 | 4.2000 | 4.8000 | 52.6600 | 11634.00 | 11634.00 | 0.00 | 25 | 5 | 25 | 230 | 0.108695652173913 | 0.43486746931447 | 0.43486746931447 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41f49145-8d8e-4790-b990-046e0d098ee4 | 2026-09-04 10:00 | 2026-09-04 09:59 | 2026-09-04 09:59 | FISV | FISV260918P00050000 | put | 50.0000 | 2026-09-18 | 0.7000 | 0.7000 | 0.8500 | 51.7800 | 10306.00 | 0.00 | 10306.00 | 147 | 29 | 152 | 155174 | 0.000979545542423344 | 0.362807095891955 | 0.362807095891955 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 72f6e8da-46cf-41a2-b9ba-a9ea2a21273b | 2026-09-04 12:15 | 2026-09-04 12:14 | 2026-09-04 12:14 | FISV | FISV270115C00050000 | call | 50.0000 | 2027-01-15 | 7.6000 | 7.4000 | 7.6000 | 53.3100 | 30396.00 | 30396.00 | 0.00 | 40 | 6 | 161 | 1389 | 0.115910727141829 | 0.432716090872042 | 0.434425426612405 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0101e70-e966-4ef4-9d31-01fece16073d | 2026-09-09 12:59 | 2026-09-09 12:59 | 2026-09-09 12:59 | FISV | FISV270617C00050000 | call | 50.0000 | 2027-06-17 | 8.2300 | 8.1000 | 8.3000 | 49.0000 | 24684.00 | 24684.00 | 0.00 | 30 | 5 | 49 | 188 | 0.26063829787234 | 0.464817522594305 | 0.464817522594305 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be6e4556-9dba-46e4-a890-f294de92ae0e | 2026-09-10 11:44 | 2026-09-10 11:44 | 2026-09-10 11:44 | FISV | FISV261016C00055000 | call | 55.0000 | 2026-10-16 | 0.7700 | 0.7500 | 0.8500 | 49.4450 | 10376.00 | 2160.00 | 6376.00 | 135 | 42 | 975 | 1876 | 0.519722814498934 | 0.39784179145166 | 0.408523413933892 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9132819b-1f42-49f7-bcc5-7fe70b4e0de2 | 2026-09-11 14:43 | 2026-09-11 14:43 | 2026-09-11 14:43 | FISV | FISV261218C00060000 | call | 60.0000 | 2026-12-18 | 2.1000 | 2.0000 | 2.1500 | 51.3400 | 20323.00 | 20113.00 | 210.00 | 97 | 29 | 341 | 2476 | 0.137722132471729 | 0.448576143648851 | 0.452865261419514 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 27114785104.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4f2524f-f9ba-4e99-9a08-0e63721b3651 | 2026-09-16 13:21 | 2026-09-16 13:21 | 2026-09-16 13:21 | FISV | FISV280121C00090000 | call | 90.0000 | 2028-01-21 | 2.9400 | 2.8000 | 3.1000 | 49.9957 | 25250.00 | 24960.00 | 290.00 | 86 | 8 | 183 | 1123 | 0.162956366874443 | 0.458805430237576 | 0.458805430237576 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 26295864353.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 3095bc24-04d3-49a2-ac97-44d646956e2c | 2026-09-17 14:47 | 2026-09-17 14:47 | 2026-09-17 14:47 | FISV | FISV260918P00053000 | put | 53.0000 | 2026-09-18 | 3.8300 | 2.3500 | 4.0000 | 49.2000 | 15320.00 | 15320.00 | 0.00 | 40 | 6 | 40 | 148 | 0.27027027027027 | 0.767032876054767 | 0.767032876054767 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 26216099345.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| c3165b9a-4e15-45ea-a6c0-d7078303ab4a | 2026-09-21 11:47 | 2026-09-21 11:47 | 2026-09-21 11:47 | FISV | FISV270617C00055000 | call | 55.0000 | 2027-06-17 | 4.9000 | 4.7000 | 4.9000 | 46.3250 | 73498.00 | 73498.00 | 0.00 | 150 | 20 | 154 | 166 | 0.927710843373494 | 0.464507807646484 | 0.465782331159376 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 24711199525.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 09424202-3f37-4649-a419-ce8a37bb2032 | 2026-09-21 12:58 | 2026-09-21 12:58 | 2026-09-21 12:58 | FISV | FISV290119C00055000 | call | 55.0000 | 2029-01-19 | 12.5900 | 12.2000 | 12.6000 | 46.4600 | 34000.00 | 34000.00 | 0.00 | 27 | 11 | 159 | 2 | 79.5 | 0.485862530239965 | 0.489552832464884 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 24711199525.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 043b97cd-cd28-44ba-9b58-efa23140f7ae | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | FISV | FISV270617C00070000 | call | 70.0000 | 2027-06-17 | 2.0600 | 2.0000 | 2.1500 | 46.7400 | 20586.00 | 0.00 | 17101.00 | 100 | 5 | 170 | 224 | 0.758928571428571 | 0.460150059508808 | 0.461793043075689 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 24711199525.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |