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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3575bbfb-7a69-4c50-9a3c-3ffba9594f89 | 2026-08-17 10:05 | 2026-08-17 10:05 | 2026-08-17 10:05 | VIST | VIST270319P00070000 | put | 70.0000 | 2027-03-19 | 8.2000 | 7.7000 | 8.2000 | 71.5200 | 12300.00 | 820.00 | 0.00 | 15 | 15 | 20 | 7 | 2.85714285714286 | 0.455690558586994 | 0.455690558586994 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | 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 |
| 9aeeec40-74ad-4e94-8bce-5e51a5f08c96 | 2026-08-17 10:38 | 2026-08-17 10:38 | 2026-08-17 10:38 | VIST | VIST261120C00080000 | call | 80.0000 | 2026-11-20 | 4.1000 | 3.9000 | 4.1000 | 72.1500 | 24600.00 | 24600.00 | 0.00 | 60 | 6 | 302 | 1152 | 0.262152777777778 | 0.460537216404401 | 0.460537216404401 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | 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 |
| cf245e2b-d367-44b4-9867-b1c72ed56eaf | 2026-08-17 11:12 | 2026-08-17 11:12 | 2026-08-17 11:12 | VIST | VIST261120C00080000 | call | 80.0000 | 2026-11-20 | 4.0000 | 3.7000 | 4.0000 | 71.7350 | 20800.00 | 20800.00 | 0.00 | 52 | 7 | 803 | 1152 | 0.697048611111111 | 0.464832691439088 | 0.464832691439088 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b45218c5-11e3-40de-8de0-01eb40bc5f57 | 2026-08-18 09:42 | 2026-08-18 09:42 | 2026-08-18 09:42 | VIST | VIST261218C00085000 | call | 85.0000 | 2026-12-18 | 3.6000 | 3.2000 | 3.6000 | 71.0000 | 161993.00 | 161993.00 | 0.00 | 450 | 40 | 900 | 172 | 5.23255813953488 | 0.462727468311097 | 0.462727468311097 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2411d43-ca31-450b-a73b-3d060585c21f | 2026-08-19 12:52 | 2026-08-19 12:52 | 2026-08-19 12:52 | VIST | VIST270319C00070000 | call | 70.0000 | 2027-03-19 | 10.0000 | 10.0000 | 10.7000 | 69.7150 | 12000.00 | 0.00 | 12000.00 | 12 | 9 | 45 | 34 | 1.32352941176471 | 0.446335565286826 | 0.446335565286826 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 05d5a82e-935d-48ab-a2fe-90b41b649ef5 | 2026-08-21 12:00 | 2026-08-21 12:00 | 2026-08-21 12:00 | VIST | VIST261218C00085000 | call | 85.0000 | 2026-12-18 | 2.9000 | 2.5000 | 3.3000 | 69.7600 | 46690.00 | 39150.00 | 7540.00 | 161 | 5 | 617 | 1395 | 0.442293906810036 | 0.464608127024215 | 0.464608127024215 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6d68a584-e6f8-4300-a488-00a3b707d9c7 | 2026-08-24 13:37 | 2026-08-24 13:37 | 2026-08-24 13:37 | VIST | VIST270319C00075000 | call | 75.0000 | 2027-03-19 | 8.4000 | 8.0000 | 8.4000 | 70.3500 | 16800.00 | 16800.00 | 0.00 | 20 | 5 | 39 | 122 | 0.319672131147541 | 0.456759915958627 | 0.456759915958627 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 01c890a5-fae4-4716-b601-80398eb3e065 | 2026-08-25 11:08 | 2026-08-25 11:08 | 2026-08-25 11:08 | VIST | VIST260918P00070000 | put | 70.0000 | 2026-09-18 | 4.0000 | 3.7000 | 4.8000 | 68.2300 | 245200.00 | 20400.00 | 224800.00 | 613 | 22 | 865 | 120 | 7.20833333333333 | 0.444609997595006 | 0.444609997595006 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e20cde19-1e1d-4134-9708-0ef3fffb2127 | 2026-08-25 11:12 | 2026-08-25 11:12 | 2026-08-25 11:12 | VIST | VIST260918P00070000 | put | 70.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.0000 | 68.0500 | 22000.00 | 22000.00 | 0.00 | 55 | 5 | 966 | 120 | 8.05 | 0.429843881605361 | 0.429843881605361 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5f11fcf-fd4a-4175-af1e-8a34b1c31e0a | 2026-08-25 11:43 | 2026-08-25 11:43 | 2026-08-25 11:43 | VIST | VIST260918P00070000 | put | 70.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.0000 | 67.9950 | 40000.00 | 40000.00 | 0.00 | 100 | 11 | 1612 | 120 | 13.4333333333333 | 0.425238262414011 | 0.425238262414011 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 156ac31b-1d4d-4856-a829-6268bc06f6d8 | 2026-09-01 11:37 | 2026-09-01 11:37 | 2026-09-01 11:37 | VIST | VIST260918P00070000 | put | 70.0000 | 2026-09-18 | 1.0000 | 0.7000 | 1.0000 | 74.6300 | 339700.00 | 339700.00 | 0.00 | 3397 | 2 | 4006 | 2162 | 1.85291396854764 | 0.442008918286474 | 0.442008918286474 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4e1bab60-7ed0-480a-b5cd-dd1402037a56 | 2026-09-02 10:43 | 2026-09-02 10:43 | 2026-09-02 10:43 | VIST | VIST261120C00080000 | call | 80.0000 | 2026-11-20 | 5.1500 | 4.7000 | 5.2000 | 75.6450 | 51500.00 | 25235.00 | 0.00 | 100 | 9 | 102 | 3811 | 0.0267646287063763 | 0.476164446516657 | 0.476164446516657 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2f1405e4-3530-4690-bba9-f252a437c377 | 2026-09-08 12:58 | 2026-09-08 12:58 | 2026-09-08 12:58 | VIST | VIST261120C00080000 | call | 80.0000 | 2026-11-20 | 4.5000 | 4.5000 | 4.7000 | 75.0900 | 22500.00 | 0.00 | 22500.00 | 50 | 12 | 53 | 3807 | 0.0139217231415813 | 0.466650056497736 | 0.466650056497736 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e5c729a6-2e64-4fc5-aa26-07c4a1963f9c | 2026-09-08 13:42 | 2026-09-08 13:42 | 2026-09-08 13:42 | VIST | VIST261120C00080000 | call | 80.0000 | 2026-11-20 | 4.9000 | 4.4000 | 5.1000 | 75.7150 | 24500.00 | 2940.00 | 18620.00 | 50 | 6 | 127 | 3807 | 0.0333596007354873 | 0.475800216917043 | 0.475800216917043 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 118e9198-5e07-469a-94f2-204acab6121b | 2026-09-10 12:09 | 2026-09-10 12:09 | 2026-09-10 12:09 | VIST | VIST260918C00080000 | call | 80.0000 | 2026-09-18 | 1.9100 | 0.9500 | 2.2000 | 79.4700 | 30410.00 | 30410.00 | 0.00 | 159 | 6 | 186 | 2092 | 0.0889101338432122 | 0.452735516926362 | 0.455472086350298 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 243b9bd7-c90a-4c6c-9d4c-19e92a869e0f | 2026-09-15 11:25 | 2026-09-15 11:25 | 2026-09-15 11:25 | VIST | VIST261120C00100000 | call | 100.0000 | 2026-11-20 | 1.0600 | 1.0000 | 1.1500 | 79.4650 | 14060.00 | 6880.00 | 4010.00 | 133 | 41 | 196 | 73 | 2.68493150684932 | 0.446536851602381 | 0.459523830657634 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Energy | 7969540306.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 57d78803-cb7a-4fc8-9f02-edd119b733f1 | 2026-09-17 12:15 | 2026-09-17 12:15 | 2026-09-17 12:15 | VIST | VIST261016C00075000 | call | 75.0000 | 2026-10-16 | 3.0600 | 3.0000 | 3.3000 | 73.5500 | 48414.00 | 0.00 | 48414.00 | 158 | 10 | 168 | 178 | 0.943820224719101 | 0.441029627332615 | 0.4361812258814 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Energy | 7646211227.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 7a4a43d3-ae2b-4edc-babe-39f39cae2df6 | 2026-09-17 13:34 | 2026-09-17 13:33 | 2026-09-17 13:33 | VIST | VIST261016P00075000 | put | 75.0000 | 2026-10-16 | 4.2000 | 4.1000 | 4.6000 | 73.6400 | 187740.00 | 30660.00 | 154560.00 | 447 | 21 | 464 | 68 | 6.82352941176471 | 0.428766046992042 | 0.432913925552551 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7646211227.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 26d68832-31f3-4758-a5b5-e01c9cc113ca | 2026-09-17 13:34 | 2026-09-17 13:34 | 2026-09-17 13:34 | VIST | VIST261016P00075000 | put | 75.0000 | 2026-10-16 | 4.2000 | 4.1000 | 4.6000 | 73.4575 | 29400.00 | 3360.00 | 26040.00 | 70 | 24 | 534 | 68 | 7.85294117647059 | 0.421177767742883 | 0.421177767742883 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7646211227.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b693eeff-3109-429f-a359-416d3d89adb2 | 2026-09-17 13:34 | 2026-09-17 13:34 | 2026-09-17 13:34 | VIST | VIST261016P00075000 | put | 75.0000 | 2026-10-16 | 4.1000 | 4.0000 | 4.6000 | 73.4575 | 170562.00 | 410.00 | 170152.00 | 416 | 32 | 950 | 68 | 13.9705882352941 | 0.409020138270547 | 0.409020138270547 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7646211227.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5588e03e-90a3-4741-94e0-b60121d65376 | 2026-09-17 13:34 | 2026-09-17 13:34 | 2026-09-17 13:34 | VIST | VIST261016P00075000 | put | 75.0000 | 2026-10-16 | 4.1000 | 4.1000 | 4.5000 | 73.4750 | 58630.00 | 0.00 | 58630.00 | 143 | 6 | 1093 | 68 | 16.0735294117647 | 0.410163638402453 | 0.410163638402453 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 7646211227.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |