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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00e8e460-35ff-4391-9207-2d0cb4763b8e | 2026-08-18 12:54 | 2026-08-18 12:54 | 2026-08-18 12:54 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 6.8000 | 6.8000 | 6.9500 | 143.8350 | 390389.00 | 0.00 | 390389.00 | 574 | 30 | 755 | 10276 | 0.0734721681588167 | 0.64293689181228 | 0.64293689181228 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| f4c2d4c1-d9b8-4771-9190-0879b14ca7df | 2026-09-03 14:19 | 2026-09-03 14:19 | 2026-09-03 14:19 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 8.4500 | 8.0000 | 8.4500 | 156.2600 | 81950.00 | 81950.00 | 0.00 | 97 | 5 | 599 | 13467 | 0.0444790970520532 | 0.626104164125507 | 0.625761900462786 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a357127e-4715-4619-b112-f7aa82977580 | 2026-09-04 10:45 | 2026-09-04 10:45 | 2026-09-04 10:45 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 8.7500 | 8.7500 | 9.0000 | 158.1850 | 386750.00 | 0.00 | 384125.00 | 442 | 32 | 582 | 13305 | 0.0437429537767756 | 0.620962172516954 | 0.620962172516954 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dba52579-3371-46db-88cc-59f4b751c1af | 2026-09-04 15:47 | 2026-09-04 15:47 | 2026-09-04 15:47 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 8.8500 | 8.8000 | 8.9000 | 157.3750 | 87615.00 | 42480.00 | 45135.00 | 99 | 12 | 843 | 13305 | 0.0633596392333709 | 0.63268557360967 | 0.63268557360967 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8399f789-6483-4c2d-86dc-1d4e0cfd0867 | 2026-09-08 09:41 | 2026-09-08 09:41 | 2026-09-08 09:41 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 12.2500 | 12.2500 | 12.7500 | 168.2150 | 122530.00 | 0.00 | 122530.00 | 100 | 5 | 294 | 12858 | 0.0228651423238451 | 0.635013207369797 | 0.635013207369797 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| 7b2d26b6-b22c-4926-9bb6-51a4f8e70fc1 | 2026-09-08 12:54 | 2026-09-08 12:54 | 2026-09-08 12:54 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 10.6500 | 10.6500 | 10.7500 | 162.9650 | 407904.00 | 0.00 | 407904.00 | 383 | 44 | 933 | 12858 | 0.0725618292113859 | 0.643817430954137 | 0.643817430954137 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| 2057e371-2470-4f2f-bf82-61f920f2d9c2 | 2026-09-11 11:07 | 2026-09-11 11:07 | 2026-09-11 11:07 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 5.4900 | 5.4000 | 5.5000 | 152.9500 | 84616.00 | 84616.00 | 0.00 | 154 | 6 | 1184 | 18852 | 0.0628050074262678 | 0.575322098199589 | 0.574912838085955 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fcba1417-a901-4f5c-b26e-9516cdd68bd6 | 2026-09-14 09:44 | 2026-09-14 09:44 | 2026-09-14 09:44 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 3.4500 | 3.4500 | 3.5500 | 142.0000 | 61410.00 | 0.00 | 61410.00 | 178 | 24 | 409 | 19519 | 0.0209539423126185 | 0.585884931380093 | 0.585884931380093 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0551629-a294-490a-8b42-b0c105a78fdf | 2026-09-16 12:47 | 2026-09-16 12:47 | 2026-09-16 12:47 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 3.5000 | 3.3500 | 3.5000 | 143.8500 | 76546.00 | 76546.00 | 0.00 | 219 | 11 | 921 | 19778 | 0.0465668925068258 | 0.583297212739197 | 0.582226360411674 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 432878045760.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 962ce75b-209f-49ba-bd0f-9216981ed2a3 | 2026-09-21 12:21 | 2026-09-21 12:21 | 2026-09-21 12:21 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 3.9500 | 3.8500 | 4.0500 | 148.5900 | 35550.00 | 31205.00 | 4345.00 | 90 | 10 | 876 | 19852 | 0.0441265363691316 | 0.578474230539787 | 0.578474230539787 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 449206220160.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 301cf0bf-3762-46e4-bcef-bb559fe6bc6b | 2026-09-21 14:06 | 2026-09-21 14:06 | 2026-09-21 14:06 | ORCL | ORCL261218C00200000 | call | 200.0000 | 2026-12-18 | 4.1000 | 4.0500 | 4.1500 | 149.0000 | 41000.00 | 13530.00 | 27060.00 | 100 | 9 | 1269 | 19852 | 0.0639230304251461 | 0.58118397479615 | 0.58118397479615 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 449206220160.00 | 2026-12-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |