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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c940d793-60d1-4038-b283-20584a7a8feb | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | NRG | NRG260918C00140000 | call | 140.0000 | 2026-09-18 | 2.5100 | 2.1000 | 3.0000 | 127.4200 | 502032.00 | 526.00 | 500996.00 | 2000 | 6 | 2000 | 11214 | 0.178348492955235 | 0.451173102903396 | 0.451173102903396 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9a14450f-f623-48a2-83d5-bbc72cee2c34 | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | NRG | NRG260821C00137000 | call | 137.0000 | 2026-08-21 | 0.2100 | 0.1500 | 0.5000 | 125.2500 | 17984.00 | 2400.00 | 15584.00 | 861 | 29 | 861 | 20 | 43.05 | 0.563244997899476 | 0.580337439592066 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b990bc9b-f291-4c55-aa9c-fe3bcbf9a1e5 | 2026-08-20 13:40 | 2026-08-20 13:40 | 2026-08-20 13:40 | NRG | NRG261218P00120000 | put | 120.0000 | 2026-12-18 | 13.5600 | 13.4000 | 14.6000 | 116.7600 | 36616.00 | 0.00 | 36616.00 | 27 | 5 | 57 | 66 | 0.863636363636364 | 0.473564216991443 | 0.473564216991443 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3d086542-4b89-4e7d-a55e-89780f0c058d | 2026-09-01 11:21 | 2026-09-01 11:21 | 2026-09-01 11:21 | NRG | NRG260904C00111000 | call | 111.0000 | 2026-09-04 | 2.2900 | 2.1000 | 2.5000 | 111.5200 | 10996.00 | 0.00 | 10076.00 | 48 | 5 | 106 | 113 | 0.938053097345133 | 0.499682603283331 | 0.499682603283331 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | 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 |
| 0ae920e6-8992-42ae-8364-4cba2efa1cd2 | 2026-09-04 14:13 | 2026-09-04 14:13 | 2026-09-04 14:13 | NRG | NRG261218C00145000 | call | 145.0000 | 2026-12-18 | 4.5100 | 4.4000 | 4.8000 | 119.1800 | 39644.00 | 2710.00 | 36934.00 | 88 | 22 | 374 | 26048 | 0.0143581081081081 | 0.478977926365889 | 0.474288886502287 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 002f0d7e-0f40-4e7f-898b-83083c9fc2d1 | 2026-09-08 09:33 | 2026-09-08 09:33 | 2026-09-08 09:33 | NRG | NRG260911C00128000 | call | 128.0000 | 2026-09-11 | 0.4100 | 0.3000 | 0.4500 | 120.6450 | 16350.00 | 5665.00 | 10640.00 | 395 | 13 | 485 | 4 | 121.25 | 0.587767842622248 | 0.566814035014283 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 256341ef-8a46-47cc-8484-282ae9dca3c5 | 2026-09-11 09:51 | 2026-09-11 09:51 | 2026-09-11 09:51 | NRG | NRG270115C00125000 | call | 125.0000 | 2027-01-15 | 8.7300 | 7.6000 | 9.7000 | 113.0000 | 21822.00 | 21822.00 | 0.00 | 25 | 12 | 50 | 77 | 0.649350649350649 | 0.479694492220961 | 0.479694492220961 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4e86a679-e509-4184-86af-499a035c5454 | 2026-09-14 10:38 | 2026-09-14 10:38 | 2026-09-14 10:38 | NRG | NRG260918P00105000 | put | 105.0000 | 2026-09-18 | 1.2700 | 1.2000 | 1.5500 | 108.2492 | 22215.00 | 15585.00 | 6630.00 | 175 | 20 | 245 | 430 | 0.569767441860465 | 0.589731295660812 | 0.589731295660812 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54c58b4a-c9b1-44a1-9b7d-110f0ad384ee | 2026-09-15 15:56 | 2026-09-15 15:56 | 2026-09-15 15:56 | NRG | NRG261016C00125000 | call | 125.0000 | 2026-10-16 | 1.3900 | 1.1000 | 1.3500 | 105.0000 | 556741.00 | 556611.00 | 130.00 | 4001 | 50 | 5337 | 11490 | 0.464490861618799 | 0.534413271386088 | 0.540892931664657 | true | true | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 22801531091.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 22b8b13b-4bf3-44da-aa7f-eb2542cebb4f | 2026-09-18 13:22 | 2026-09-18 13:22 | 2026-09-18 13:22 | NRG | NRG261120C00105000 | call | 105.0000 | 2026-11-20 | 8.8900 | 8.8000 | 9.3000 | 104.5000 | 25781.00 | 13350.00 | 1781.00 | 29 | 9 | 105 | 0 | 0 | 0.51150556764204 | 0.50889511571102 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 21790418668.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |