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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f0bbc6eb-15c1-4f89-af13-95b15a7c5260 | 2026-08-19 10:06 | 2026-08-19 10:06 | 2026-08-19 10:06 | RGTI | RGTI260828C00017500 | call | 17.5000 | 2026-08-28 | 0.6800 | 0.5800 | 0.6800 | 16.9800 | 11884.00 | 9674.00 | 66.00 | 176 | 14 | 190 | 253 | 0.75098814229249 | 0.843434594806327 | 0.824396930752825 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | 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 |
| 2c41d753-e813-4905-bd14-aaf80f15cba5 | 2026-08-19 11:53 | 2026-08-19 11:53 | 2026-08-19 11:53 | RGTI | RGTI270219P00017000 | put | 17.0000 | 2027-02-19 | 3.7000 | 3.7000 | 3.9000 | 17.2050 | 106290.00 | 0.00 | 106290.00 | 287 | 8 | 337 | 163 | 2.06748466257669 | 0.841343799571192 | 0.839160599920881 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 99d00940-1b59-4b5e-ab51-2eca539abe41 | 2026-08-19 15:40 | 2026-08-19 15:40 | 2026-08-19 15:40 | RGTI | RGTI261218C00026000 | call | 26.0000 | 2026-12-18 | 1.2200 | 1.1400 | 1.2200 | 16.8600 | 47822.00 | 47822.00 | 0.00 | 392 | 42 | 393 | 298 | 1.31879194630872 | 0.892894808900818 | 0.892026071349899 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | 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 |
| bc4ae36a-6d59-499d-9327-4822d5c88fa6 | 2026-08-21 10:59 | 2026-08-21 10:59 | 2026-08-21 10:59 | RGTI | RGTI261218P00016000 | put | 16.0000 | 2026-12-18 | 2.5700 | 2.4900 | 2.6300 | 17.1800 | 196337.00 | 95604.00 | 97661.00 | 765 | 9 | 771 | 249 | 3.09638554216867 | 0.866131509059128 | 0.861931215127235 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 820036c3-b4ca-4ece-9a0d-f9f41a5ba2c5 | 2026-08-26 11:02 | 2026-08-26 11:02 | 2026-08-26 11:02 | RGTI | RGTI260918C00017000 | call | 17.0000 | 2026-09-18 | 0.9000 | 0.8800 | 0.9200 | 16.1850 | 46867.00 | 6704.00 | 25313.00 | 519 | 25 | 684 | 5315 | 0.128692380056444 | 0.760210862810805 | 0.753970562693887 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| abd6b7c0-fa27-47b9-8631-06229e676679 | 2026-08-31 15:20 | 2026-08-31 15:20 | 2026-08-31 15:20 | RGTI | RGTI280121C00030000 | call | 30.0000 | 2028-01-21 | 3.6900 | 3.6000 | 3.7000 | 15.6100 | 25809.00 | 21090.00 | 4719.00 | 70 | 6 | 99 | 2338 | 0.0423438836612489 | 0.900563510409727 | 0.89102694833744 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b5c5f0b-4083-4f56-ba18-cc1b3b9d69ee | 2026-09-08 09:38 | 2026-09-08 09:38 | 2026-09-08 09:38 | RGTI | RGTI260918C00016500 | call | 16.5000 | 2026-09-18 | 1.2200 | 1.0900 | 1.2300 | 16.8099 | 61075.00 | 61075.00 | 0.00 | 500 | 17 | 565 | 2296 | 0.246080139372822 | 0.978698707977494 | 0.954775221751026 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 362236f7-4e8c-4737-8135-3f47b75d88b5 | 2026-09-08 09:38 | 2026-09-08 09:38 | 2026-09-08 09:38 | RGTI | RGTI260918C00016500 | call | 16.5000 | 2026-09-18 | 1.2100 | 1.0900 | 1.2400 | 16.8200 | 32371.00 | 30232.00 | 2139.00 | 268 | 37 | 915 | 2296 | 0.398519163763066 | 0.945524332367446 | 0.930973927779603 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd1f659b-0d1d-429f-a68f-0e07ef11354e | 2026-09-08 10:22 | 2026-09-08 10:22 | 2026-09-08 10:22 | RGTI | RGTI260911C00016500 | call | 16.5000 | 2026-09-11 | 0.5000 | 0.4800 | 0.5100 | 16.3150 | 21519.00 | 13080.00 | 4421.00 | 433 | 46 | 2882 | 784 | 3.67602040816327 | 1.00819138584916 | 0.98720373550341 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8e4a0713-7979-4525-b0f5-cc92bb597efe | 2026-09-09 10:15 | 2026-09-09 10:15 | 2026-09-09 10:15 | RGTI | RGTI270319P00013000 | put | 13.0000 | 2027-03-19 | 1.9700 | 1.8500 | 2.0100 | 15.5930 | 71906.00 | 395.00 | 71511.00 | 365 | 8 | 365 | 1316 | 0.277355623100304 | 0.8004364341613 | 0.797706986398605 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e73af587-294c-4fa2-843f-b51bc03de678 | 2026-09-11 10:20 | 2026-09-11 10:20 | 2026-09-11 10:20 | RGTI | RGTI260911C00015000 | call | 15.0000 | 2026-09-11 | 0.5600 | 0.5400 | 0.6000 | 15.5600 | 10480.00 | 0.00 | 10205.00 | 187 | 57 | 706 | 1077 | 0.65552460538533 | 1.13836177962655 | 1.36584738402086 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d67fa8c9-a8d7-4651-8ac9-f816dbc96730 | 2026-09-14 14:18 | 2026-09-14 14:18 | 2026-09-14 14:18 | RGTI | RGTI270115C00017000 | call | 17.0000 | 2027-01-15 | 2.2200 | 2.2000 | 2.2600 | 15.3150 | 284823.00 | 443.00 | 284380.00 | 1283 | 18 | 1325 | 2663 | 0.497559143822756 | 0.784567901265342 | 0.784567901265342 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5096648767.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d4e45c5f-592f-432f-8029-c61ee2b1e940 | 2026-09-18 10:59 | 2026-09-18 10:59 | 2026-09-18 10:59 | RGTI | RGTI261016C00021000 | call | 21.0000 | 2026-10-16 | 0.1700 | 0.1300 | 0.1700 | 15.1600 | 17751.00 | 17095.00 | 656.00 | 1054 | 63 | 1073 | 1676 | 0.640214797136038 | 0.859504729969353 | 0.84603734710522 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5260195453.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0ecc3c76-e6b5-4c09-a48c-ce6888a7158e | 2026-09-18 13:44 | 2026-09-18 13:44 | 2026-09-18 13:44 | RGTI | RGTI261120P00014000 | put | 14.0000 | 2026-11-20 | 1.1700 | 1.1300 | 1.2500 | 15.2600 | 144174.00 | 0.00 | 144174.00 | 1231 | 36 | 2630 | 616 | 4.26948051948052 | 0.73613058753297 | 0.734587207871324 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 5260195453.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |