Options 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 265b5c1e-c602-4509-97d7-5c8f7824b4ab | 2026-08-25 11:10 | 2026-08-25 11:10 | 2026-08-25 11:10 | PCG | PCG261016C00021000 | call | 21.0000 | 2026-10-16 | 0.4400 | 0.3700 | 0.4700 | 18.1880 | 14146.00 | 13857.00 | 289.00 | 322 | 38 | 1480 | 8055 | 0.183736809435133 | 0.474806356891833 | 0.465535356314624 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b217c41a-462e-4ba1-9c06-562a1a61775f | 2026-08-25 11:10 | 2026-08-25 11:09 | 2026-08-25 11:09 | PCG | PCG261016C00021000 | call | 21.0000 | 2026-10-16 | 0.4400 | 0.3300 | 0.4700 | 18.1850 | 22800.00 | 22000.00 | 800.00 | 520 | 5 | 860 | 8055 | 0.106765983860956 | 0.475148542025285 | 0.456485030428488 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 08ee7981-a795-421d-bafe-e9b16ceb2aac | 2026-08-25 11:00 | 2026-08-25 11:00 | 2026-08-25 11:00 | PCG | PCG260911C00019500 | call | 19.5000 | 2026-09-11 | 0.5800 | 0.4700 | 0.6300 | 18.2010 | 60581.00 | 57398.00 | 2878.00 | 1040 | 39 | 1040 | 199 | 5.22613065326633 | 0.713638233102446 | 0.678286181875137 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2dc02cb8-b057-4123-b412-1f0008054e94 | 2026-08-25 10:53 | 2026-08-25 10:52 | 2026-08-25 10:52 | PCG | PCG260904C00019000 | call | 19.0000 | 2026-09-04 | 0.6200 | 0.4500 | 0.6300 | 18.1750 | 10679.00 | 6253.00 | 2380.00 | 173 | 26 | 184 | 3222 | 0.0571073867163253 | 0.799958345285538 | 0.77404948824745 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9abd6da7-54d4-46d1-85bf-eb067be66021 | 2026-08-25 10:50 | 2026-08-25 10:50 | 2026-08-25 10:50 | PCG | PCG260828C00019000 | call | 19.0000 | 2026-08-28 | 0.3700 | 0.3000 | 0.3900 | 18.1610 | 78524.00 | 72703.00 | 1147.00 | 2118 | 15 | 2553 | 3865 | 0.660543337645537 | 1.07410614404417 | 1.05750675851263 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47d47020-91e9-4940-b8d6-4a4e4ea3db7e | 2026-08-24 15:40 | 2026-08-24 15:40 | 2026-08-24 15:40 | PCG | PCG260918C00022000 | call | 22.0000 | 2026-09-18 | 0.1500 | 0.1300 | 0.1900 | 18.1150 | 24970.00 | 0.00 | 24970.00 | 1620 | 19 | 1663 | 99140 | 0.0167742586241678 | 0.591872656731262 | 0.581366260034909 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 167df493-87fa-4aa5-b194-2776adf49c68 | 2026-08-21 14:28 | 2026-08-21 14:28 | 2026-08-21 14:28 | PCG | PCG280121C00015000 | call | 15.0000 | 2028-01-21 | 4.5500 | 4.4000 | 4.5500 | 17.6350 | 58671.00 | 58671.00 | 0.00 | 129 | 13 | 130 | 898 | 0.144766146993318 | 0.321833493842069 | 0.321833493842069 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ee78a7d7-225e-4f7f-a1f6-7ff59557a1ea | 2026-08-20 13:46 | 2026-08-20 13:46 | 2026-08-20 13:46 | PCG | PCG261016C00020000 | call | 20.0000 | 2026-10-16 | 0.8200 | 0.7700 | 0.8400 | 18.3500 | 18634.00 | 15066.00 | 1053.00 | 228 | 46 | 20693 | 1435 | 14.4202090592334 | 0.485355833288561 | 0.481712921568564 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | 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 |
| fda5bde8-bc80-4ecb-a60e-9cba1d547475 | 2026-08-19 14:53 | 2026-08-19 14:53 | 2026-08-19 14:53 | PCG | PCG260828C00017500 | call | 17.5000 | 2026-08-28 | 0.8800 | 0.8600 | 0.8900 | 17.6950 | 222774.00 | 118370.00 | 104404.00 | 2544 | 30 | 2709 | 312 | 8.68269230769231 | 0.708068774812999 | 0.708068774812999 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b727931-6614-4731-8e65-101351ec2213 | 2026-08-19 14:53 | 2026-08-19 14:53 | 2026-08-19 14:53 | PCG | PCG260828P00017000 | put | 17.0000 | 2026-08-28 | 0.4500 | 0.4300 | 0.4500 | 17.6950 | 14675.00 | 13815.00 | 860.00 | 327 | 32 | 1524 | 1129 | 1.34986713906112 | 0.693305850965712 | 0.693305850965712 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 152eb0cc-bebb-4cdc-a640-14dd539939a5 | 2026-08-19 11:20 | 2026-08-19 11:20 | 2026-08-19 11:20 | PCG | PCG260828P00018000 | put | 18.0000 | 2026-08-28 | 0.8700 | 0.7100 | 1.0900 | 17.7700 | 16116.00 | 11404.00 | 4712.00 | 185 | 7 | 321 | 99 | 3.24242424242424 | 0.70473294621539 | 0.668742469137737 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b9feb5b-a981-4402-9f21-eea4be211fd3 | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | PCG | PCG260918C00020000 | call | 20.0000 | 2026-09-18 | 0.4400 | 0.4100 | 0.4700 | 17.7950 | 41839.00 | 22725.00 | 4902.00 | 942 | 56 | 5468 | 298077 | 0.0183442533305153 | 0.530749871054519 | 0.525269635368368 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | 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 |