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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77131043-80ed-4fcc-b57a-0387c4b31be5 | 2026-09-18 12:03 | 2026-09-18 12:03 | 2026-09-18 12:03 | DB | DB261016P00039000 | put | 39.0000 | 2026-10-16 | 1.9000 | 1.9000 | 2.0000 | 37.0000 | 60802.00 | 0.00 | 60802.00 | 320 | 18 | 700 | 619 | 1.13085621970921 | 0.309823061268844 | 0.305599440506006 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 72271126567.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e7a345c7-21c0-4d88-b1f6-d75b9d2bc205 | 2026-09-14 13:14 | 2026-09-14 13:14 | 2026-09-14 13:14 | DB | DB260918C00034000 | call | 34.0000 | 2026-09-18 | 5.2000 | 5.0000 | 5.3000 | 39.3100 | 120132.00 | 24960.00 | 95172.00 | 231 | 15 | 255 | 116 | 2.19827586206897 | 0.416959116059995 | 0.416959116059995 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 30239d07-d288-45a6-9c42-22953e34ff6b | 2026-09-14 13:14 | 2026-09-14 13:14 | 2026-09-14 13:14 | DB | DB260918C00035000 | call | 35.0000 | 2026-09-18 | 4.2000 | 3.9000 | 4.3000 | 39.2050 | 153738.00 | 70140.00 | 83598.00 | 366 | 19 | 368 | 206 | 1.78640776699029 | 0.416959116059995 | 0 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ca0dc8dd-2db9-4625-b6cb-f238bf717e9f | 2026-09-14 11:09 | 2026-09-14 11:09 | 2026-09-14 11:09 | DB | DB260918P00040000 | put | 40.0000 | 2026-09-18 | 1.0000 | 1.0000 | 1.1000 | 39.2800 | 52000.00 | 0.00 | 52000.00 | 520 | 10 | 534 | 2323 | 0.229875161429186 | 0.351904954410725 | 0.351904954410725 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f69b66e6-0bfe-4013-b8b7-1e336ef2e684 | 2026-08-31 12:42 | 2026-08-31 12:41 | 2026-08-31 12:41 | DB | DB261016C00041000 | call | 41.0000 | 2026-10-16 | 1.4500 | 1.4000 | 1.5000 | 40.1701 | 66845.00 | 0.00 | 66700.00 | 461 | 19 | 499 | 794 | 0.628463476070529 | 0.30490365030495 | 0.30490365030495 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.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 |
| 773e29de-8826-4766-83d4-cf49c05146ab | 2026-08-31 10:32 | 2026-08-31 10:32 | 2026-08-31 10:32 | DB | DB270115C00045000 | call | 45.0000 | 2027-01-15 | 2.0400 | 2.0000 | 2.0500 | 40.1600 | 66461.00 | 58823.00 | 7638.00 | 325 | 15 | 629 | 7281 | 0.0863892322483175 | 0.362171096747288 | 0.366475154526072 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c23d71b9-177d-4764-9892-37097844e9d0 | 2026-08-28 10:36 | 2026-08-28 10:36 | 2026-08-28 10:36 | DB | DB261016C00040000 | call | 40.0000 | 2026-10-16 | 2.1500 | 2.1000 | 2.2000 | 40.4800 | 205325.00 | 116960.00 | 88365.00 | 955 | 19 | 1053 | 1138 | 0.92530755711775 | 0.304778801402002 | 0.304778801402002 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 46a9c837-7246-4663-ae9b-30e111b3facd | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | DB | DB270115C00040000 | call | 40.0000 | 2027-01-15 | 4.1900 | 4.0000 | 4.2000 | 40.5100 | 176914.00 | 176914.00 | 0.00 | 422 | 34 | 445 | 7529 | 0.0591047947934653 | 0.355617456262754 | 0.364194800410867 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d2173e67-1b00-45fe-903d-e1ea9497fb78 | 2026-08-25 15:30 | 2026-08-25 15:29 | 2026-08-25 15:29 | DB | DB260918C00040000 | call | 40.0000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7000 | 38.9600 | 59080.00 | 59080.00 | 0.00 | 844 | 20 | 903 | 1782 | 0.506734006734007 | 0.274575061821568 | 0.274575061821568 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 351d607c-99d9-47b9-b15c-5f48da641c6b | 2026-08-24 13:28 | 2026-08-24 13:28 | 2026-08-24 13:28 | DB | DB261016C00038000 | call | 38.0000 | 2026-10-16 | 2.2000 | 2.1500 | 2.2500 | 38.4100 | 54968.00 | 54748.00 | 0.00 | 250 | 17 | 250 | 698 | 0.358166189111748 | 0.324799652367053 | 0.323794291351486 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | 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 |
| b331a8b0-3e2b-41bb-ac01-1752033f4589 | 2026-08-21 09:33 | 2026-08-21 09:32 | 2026-08-21 09:32 | DB | DB270115C00040000 | call | 40.0000 | 2027-01-15 | 2.6500 | 2.5000 | 2.6500 | 37.6500 | 132500.00 | 132500.00 | 0.00 | 500 | 6 | 500 | 7350 | 0.0680272108843537 | 0.353827024026657 | 0.353827024026657 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41acbafe-468d-4ed9-b32a-1ffbfb2cf04a | 2026-08-20 10:46 | 2026-08-20 10:46 | 2026-08-20 10:46 | DB | DB270115C00039000 | call | 39.0000 | 2027-01-15 | 3.1900 | 3.0000 | 3.2000 | 37.8500 | 127408.00 | 127408.00 | 0.00 | 400 | 14 | 400 | 1137 | 0.351802990325418 | 0.354932176900496 | 0.358056448281552 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0acc40b3-d224-450b-823c-eb653b799a96 | 2026-08-18 13:04 | 2026-08-18 13:04 | 2026-08-18 13:04 | DB | DB270115C00040000 | call | 40.0000 | 2027-01-15 | 2.8000 | 2.7000 | 2.9000 | 38.0500 | 51485.00 | 47565.00 | 3920.00 | 184 | 31 | 186 | 7024 | 0.0264806378132118 | 0.34677146865087 | 0.345578687244369 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 544ae395-33b0-490e-a21a-92d40c4f542a | 2026-08-17 11:29 | 2026-08-17 11:29 | 2026-08-17 11:29 | DB | DB270115C00040000 | call | 40.0000 | 2027-01-15 | 3.0000 | 2.8000 | 3.0000 | 38.3200 | 89999.00 | 89999.00 | 0.00 | 300 | 36 | 403 | 6730 | 0.0598811292719168 | 0.351146322593579 | 0.351146322593579 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 16c0b2f2-bbc3-4c70-8bd8-fc3d48366230 | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | DB | DB280121P00028000 | put | 28.0000 | 2028-01-21 | 2.5400 | 2.1000 | 2.8500 | 38.1350 | 127240.00 | 127240.00 | 0.00 | 500 | 25 | 500 | 1127 | 0.443655723158829 | 0.45418765345726 | 0.45418765345726 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 74916120404.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |