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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37f35705-3c16-4747-a53c-bf9be71c4ed0 | 2026-08-17 09:54 | 2026-08-17 09:54 | 2026-08-17 09:54 | WOLF | WOLF260918P00025000 | put | 25.0000 | 2026-09-18 | 1.2300 | 1.0500 | 1.2500 | 33.6200 | 49432.00 | 21372.00 | 28060.00 | 401 | 35 | 402 | 29906 | 0.0134421186384003 | 1.23605737452113 | 1.23605737452113 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | 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 |
| 00bded5b-f552-42d7-93ba-94a9aa907eb9 | 2026-08-17 15:15 | 2026-08-17 15:15 | 2026-08-17 15:15 | WOLF | WOLF260821C00035000 | call | 35.0000 | 2026-08-21 | 2.6500 | 2.6300 | 2.7500 | 34.4700 | 47706.00 | 3180.00 | 44526.00 | 180 | 19 | 500 | 816 | 0.612745098039216 | 2.00354069607757 | 1.98963993267209 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | 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 |
| 3aaa7e46-dced-43d0-8a09-ddbcaec3a6d1 | 2026-08-19 10:09 | 2026-08-19 10:09 | 2026-08-19 10:09 | WOLF | WOLF261218C00035000 | call | 35.0000 | 2026-12-18 | 5.0600 | 5.0500 | 6.8000 | 28.2950 | 105841.00 | 4595.00 | 101246.00 | 209 | 26 | 409 | 96 | 4.26041666666667 | 1.10067034628171 | 1.10720820599085 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6e749edb-976a-49f0-bbcb-378d9c4ae49d | 2026-08-20 11:50 | 2026-08-20 11:50 | 2026-08-20 11:50 | WOLF | WOLF270416C00080000 | call | 80.0000 | 2027-04-16 | 1.4900 | 1.2900 | 2.9500 | 24.6600 | 11468.00 | 0.00 | 11468.00 | 77 | 9 | 77 | 92 | 0.83695652173913 | 1.0249021688692 | 1.12731711544036 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf5878c3-1a4a-44ac-91e3-133a0ff15673 | 2026-08-31 13:08 | 2026-08-31 13:08 | 2026-08-31 13:08 | WOLF | WOLF261016C00030000 | call | 30.0000 | 2026-10-16 | 2.4000 | 2.2100 | 2.7000 | 26.4700 | 24000.00 | 0.00 | 24000.00 | 100 | 5 | 100 | 66 | 1.51515151515152 | 0.97064674078104 | 0.97064674078104 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47214b0d-aebf-4e07-8d1f-5465cdc67315 | 2026-09-04 14:25 | 2026-09-04 14:25 | 2026-09-04 14:25 | WOLF | WOLF261016C00030000 | call | 30.0000 | 2026-10-16 | 3.2000 | 3.0000 | 3.2000 | 28.5500 | 46333.00 | 42868.00 | 3465.00 | 145 | 27 | 691 | 185 | 3.73513513513514 | 0.969542652580417 | 0.971417038398849 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5f698b2c-1115-4825-bd31-140829532056 | 2026-09-08 09:47 | 2026-09-08 09:47 | 2026-09-08 09:47 | WOLF | WOLF260918C00029000 | call | 29.0000 | 2026-09-18 | 1.6100 | 1.5300 | 2.0900 | 28.1900 | 30608.00 | 4480.00 | 26128.00 | 190 | 7 | 193 | 539 | 0.358070500927644 | 1.04276414963066 | 1.04276414963066 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1289d51a-65a0-49cf-9081-4dcbaebf589e | 2026-09-08 10:53 | 2026-09-08 10:53 | 2026-09-08 10:53 | WOLF | WOLF260918C00028000 | call | 28.0000 | 2026-09-18 | 2.3000 | 2.2000 | 2.4400 | 28.6450 | 24199.00 | 2996.00 | 21203.00 | 105 | 11 | 727 | 961 | 0.756503642039542 | 1.04153153034438 | 1.05237377136912 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ac9d273-e400-4762-a90e-fdc107f2fefd | 2026-09-10 11:05 | 2026-09-10 11:05 | 2026-09-10 11:05 | WOLF | WOLF261120C00037500 | call | 37.5000 | 2026-11-20 | 1.9100 | 1.7600 | 1.9200 | 26.0500 | 13931.00 | 5721.00 | 8210.00 | 73 | 14 | 73 | 20 | 3.65 | 1.07553615484036 | 1.08051164933048 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 14cfee74-09dd-4354-8af8-668258ab6fa6 | 2026-09-11 11:31 | 2026-09-11 11:31 | 2026-09-11 11:31 | WOLF | WOLF280121P00025000 | put | 25.0000 | 2028-01-21 | 9.9000 | 9.5500 | 9.9000 | 26.7370 | 76220.00 | 76220.00 | 0.00 | 77 | 5 | 198 | 97 | 2.04123711340206 | 1.04007849229841 | 1.04007849229841 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d4ccaca2-6c5f-4ba6-b525-30e16667a45e | 2026-09-14 14:19 | 2026-09-14 14:19 | 2026-09-14 14:19 | WOLF | WOLF270617C00045000 | call | 45.0000 | 2027-06-17 | 4.4000 | 4.0500 | 4.4000 | 24.4400 | 25955.00 | 25955.00 | 0.00 | 59 | 6 | 164 | 24331 | 0.00674037236447331 | 1.03634132264461 | 1.04235061655839 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1269769688.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67a870be-f279-4e46-a425-f51947939641 | 2026-09-18 13:04 | 2026-09-18 13:04 | 2026-09-18 13:04 | WOLF | WOLF290119C00035000 | call | 35.0000 | 2029-01-19 | 10.9900 | 10.7500 | 11.7500 | 25.2200 | 241680.00 | 111540.00 | 130140.00 | 220 | 6 | 220 | 20 | 11 | 0.846241758212344 | 0.876090465931627 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1356152184.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |