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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7540f239-5b54-4553-83bb-49d02342410f | 2026-09-21 14:28 | 2026-09-21 14:28 | 2026-09-21 14:28 | BKR | BKR261016C00055000 | call | 55.0000 | 2026-10-16 | 4.0000 | 3.9000 | 4.0000 | 57.0000 | 14400.00 | 14400.00 | 0.00 | 36 | 12 | 988 | 1890 | 0.522751322751323 | 0.353878765839294 | 0.353878765839294 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 57406341526.00 | 2026-10-22 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 2d3a40fc-109d-4c5e-9eba-9d86086fe701 | 2026-09-21 14:13 | 2026-09-21 14:13 | 2026-09-21 14:13 | BKR | BKR261016C00055000 | call | 55.0000 | 2026-10-16 | 3.9000 | 3.8000 | 3.9000 | 57.8400 | 28464.00 | 28464.00 | 0.00 | 73 | 21 | 840 | 1890 | 0.444444444444444 | 0.348246259988872 | 0.348246259988872 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 57406341526.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 22cf615a-7c90-4225-9eea-dbd87650786a | 2026-09-16 15:49 | 2026-09-16 15:49 | 2026-09-16 15:49 | BKR | BKR261218C00060000 | call | 60.0000 | 2026-12-18 | 2.8000 | 2.6500 | 2.8000 | 56.0000 | 195429.00 | 195429.00 | 0.00 | 698 | 52 | 713 | 3271 | 0.217976154081321 | 0.366959535324146 | 0.366959535324146 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 55907403679.00 | 2026-10-22 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| c58eeec0-f212-4147-bd01-beca3a3ce082 | 2026-09-14 12:30 | 2026-09-14 12:30 | 2026-09-14 12:30 | BKR | BKR270115C00060000 | call | 60.0000 | 2027-01-15 | 3.7000 | 3.5000 | 3.7000 | 56.8400 | 188330.00 | 188330.00 | 0.00 | 509 | 24 | 534 | 1155 | 0.462337662337662 | 0.356206990174873 | 0.356206990174873 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2448d0fb-f1ac-4e80-97d4-641e033056d2 | 2026-09-09 14:08 | 2026-09-09 14:08 | 2026-09-09 14:08 | BKR | BKR261016P00065000 | put | 65.0000 | 2026-10-16 | 2.9500 | 2.9000 | 3.1000 | 64.2850 | 508285.00 | 295.00 | 507990.00 | 1723 | 62 | 2328 | 887 | 2.62457722660654 | 0.331468285050205 | 0.331468285050205 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 468f0e61-92e0-4cdf-a6f7-27f267d4bb5f | 2026-09-09 14:08 | 2026-09-09 14:08 | 2026-09-09 14:08 | BKR | BKR261016P00065000 | put | 65.0000 | 2026-10-16 | 3.0000 | 2.9500 | 3.0000 | 64.2900 | 58488.00 | 58488.00 | 0.00 | 195 | 28 | 604 | 887 | 0.680947012401353 | 0.33606990270208 | 0.337901362595161 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b5fe32c-7fdd-4c23-b04e-8e608c77c200 | 2026-09-08 14:00 | 2026-09-08 14:00 | 2026-09-08 14:00 | BKR | BKR260918C00065000 | call | 65.0000 | 2026-09-18 | 1.2500 | 1.2000 | 1.2500 | 64.0200 | 65490.00 | 65490.00 | 0.00 | 524 | 45 | 1608 | 4977 | 0.323086196503918 | 0.391533442882439 | 0.391533442882439 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | 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 |
| 3d7ca025-8c70-460a-884a-8c695ac638aa | 2026-09-04 12:52 | 2026-09-04 12:52 | 2026-09-04 12:52 | BKR | BKR260918C00065000 | call | 65.0000 | 2026-09-18 | 0.9000 | 0.8500 | 0.9000 | 63.1600 | 80349.00 | 80349.00 | 0.00 | 893 | 76 | 1003 | 4656 | 0.215420962199313 | 0.324988666008719 | 0.324988666008719 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f5cdac81-3dff-4fad-be50-506ab1c81249 | 2026-08-27 13:07 | 2026-08-27 13:07 | 2026-08-27 13:07 | BKR | BKR261016C00060000 | call | 60.0000 | 2026-10-16 | 4.1000 | 4.0000 | 4.1000 | 61.6000 | 83216.00 | 83216.00 | 0.00 | 203 | 17 | 216 | 1033 | 0.209099709583737 | 0.340798310285981 | 0.339643568518123 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 397ae335-830d-4dae-a8c5-89f84f2fe0df | 2026-08-27 13:07 | 2026-08-27 13:07 | 2026-08-27 13:07 | BKR | BKR260918P00070000 | put | 70.0000 | 2026-09-18 | 8.3000 | 8.1000 | 8.4000 | 61.6000 | 161020.00 | 13280.00 | 147740.00 | 194 | 16 | 194 | 302 | 0.642384105960265 | 0.279953773154096 | 0.279953773154096 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27432c19-4879-468d-929f-440171afb6bb | 2026-08-27 13:07 | 2026-08-27 13:07 | 2026-08-27 13:07 | BKR | BKR261016C00065000 | call | 65.0000 | 2026-10-16 | 1.7500 | 1.7000 | 1.7500 | 61.6000 | 58060.00 | 58060.00 | 0.00 | 332 | 30 | 350 | 2028 | 0.17258382642998 | 0.326268074742493 | 0.325102324121597 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 251b2371-ffb5-4d8b-bdf5-3488ede3da77 | 2026-08-27 13:07 | 2026-08-27 13:07 | 2026-08-27 13:07 | BKR | BKR261016P00070000 | put | 70.0000 | 2026-10-16 | 8.6000 | 8.5000 | 8.7000 | 61.6000 | 110962.00 | 30100.00 | 80862.00 | 129 | 20 | 129 | 13 | 9.92307692307692 | 0.31287031515295 | 0.31287031515295 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 254c88ff-3b73-4a76-b607-a016052ab1fd | 2026-08-20 15:18 | 2026-08-20 15:18 | 2026-08-20 15:18 | BKR | BKR270917C00070000 | call | 70.0000 | 2027-09-17 | 6.9000 | 6.9000 | 7.6000 | 62.8500 | 62122.00 | 0.00 | 62122.00 | 90 | 6 | 90 | 3 | 30 | 0.328667834042026 | 0.328667834042026 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf6259f2-a7d5-4d44-aca1-123f6e16aaaa | 2026-08-19 15:31 | 2026-08-19 15:30 | 2026-08-19 15:30 | BKR | BKR260821C00060000 | call | 60.0000 | 2026-08-21 | 4.5000 | 4.2000 | 4.5000 | 64.3000 | 51750.00 | 51750.00 | 0.00 | 115 | 5 | 137 | 4917 | 0.0278625177954037 | 0.765675662982163 | 0.765675662982163 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8bc8cdbf-a8ae-43a0-833f-b3feec2edbe6 | 2026-08-19 12:13 | 2026-08-19 12:13 | 2026-08-19 12:13 | BKR | BKR261016C00060000 | call | 60.0000 | 2026-10-16 | 6.1000 | 6.1000 | 6.2000 | 64.1800 | 109800.00 | 0.00 | 109800.00 | 180 | 23 | 345 | 738 | 0.467479674796748 | 0.340653248923345 | 0.340653248923345 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf3e9824-01d5-4bf6-aba4-805580e3f273 | 2026-08-18 12:14 | 2026-08-18 12:13 | 2026-08-18 12:13 | BKR | BKR280121C00080000 | call | 80.0000 | 2028-01-21 | 6.7900 | 6.4000 | 6.8000 | 64.4100 | 475518.00 | 475518.00 | 0.00 | 700 | 31 | 700 | 125 | 5.6 | 0.347219341514159 | 0.34693375715111 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 56364033751.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |