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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31bb01de-aad8-4be5-a0ea-6c7239670f4d | 2026-09-18 10:22 | 2026-09-18 10:22 | 2026-09-18 10:22 | PCG | PCG261120P00011000 | put | 11.0000 | 2026-11-20 | 0.2900 | 0.2000 | 0.3300 | 13.2900 | 246500.00 | 246500.00 | 0.00 | 8500 | 1 | 8500 | 227 | 37.4449339207048 | 0.545000385571569 | 0.545000385571569 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 35377458547.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b515cbd6-c88e-49f1-8502-01b8f1be6e14 | 2026-09-18 10:05 | 2026-09-18 10:05 | 2026-09-18 10:05 | PCG | PCG261120C00018000 | call | 18.0000 | 2026-11-20 | 0.2200 | 0.1100 | 0.3400 | 13.3050 | 91652.00 | 0.00 | 91652.00 | 4166 | 2 | 4169 | 4703 | 0.886455453965554 | 0.598644790443828 | 0.598644790443828 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 35377458547.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 4b45fccb-6af5-43e1-8c02-5c447ee1fe44 | 2026-09-11 12:44 | 2026-09-11 12:44 | 2026-09-11 12:44 | PCG | PCG270917P00013000 | put | 13.0000 | 2027-09-17 | 1.8300 | 1.6800 | 2.0600 | 13.8599 | 458048.00 | 0.00 | 458048.00 | 2500 | 2 | 2500 | 7052 | 0.354509359047079 | 0.473029135598675 | 0.473029135598675 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 703902e3-be6c-4b88-a07d-00c19e11e4ff | 2026-09-10 13:06 | 2026-09-10 13:06 | 2026-09-10 13:06 | PCG | PCG261218C00015000 | call | 15.0000 | 2026-12-18 | 1.5700 | 1.5200 | 1.6000 | 14.2900 | 785000.00 | 785000.00 | 0.00 | 5000 | 2 | 50791 | 29603 | 1.71573826976996 | 0.609451189967164 | 0.609451189967164 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cb94e949-fd52-48e2-a140-ddaa0fb62676 | 2026-09-04 15:19 | 2026-09-04 15:19 | 2026-09-04 15:19 | PCG | PCG260918P00014500 | put | 14.5000 | 2026-09-18 | 0.9000 | 0.8700 | 1.0000 | 14.0100 | 180000.00 | 0.00 | 180000.00 | 2000 | 1 | 2030 | 42 | 48.3333333333333 | 0.573853876881369 | 0.573853876881369 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf1e2198-7f1d-4888-805a-2329ba39dcbc | 2026-09-04 09:53 | 2026-09-04 09:52 | 2026-09-04 09:52 | PCG | PCG270115C00016000 | call | 16.0000 | 2027-01-15 | 1.2500 | 1.0700 | 1.4400 | 13.8950 | 3750000.00 | 0.00 | 3750000.00 | 30000 | 1 | 30000 | 6755 | 4.44115470022206 | 0.578486220173751 | 0.578486220173751 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 683b24f6-6ad3-4953-9df3-1a7670aae6b6 | 2026-09-03 12:57 | 2026-09-03 12:57 | 2026-09-03 12:57 | PCG | PCG260918C00017500 | call | 17.5000 | 2026-09-18 | 0.0700 | 0.0600 | 0.1500 | 13.9250 | 150150.00 | 0.00 | 150150.00 | 21450 | 1 | 21747 | 42570 | 0.510852713178295 | 0.74871037589255 | 0.74871037589255 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 98c67b0e-4968-4c0e-a978-34ee31a2c52d | 2026-08-28 14:46 | 2026-08-28 14:45 | 2026-08-28 14:45 | PCG | PCG260904C00017000 | call | 17.0000 | 2026-09-04 | 0.4700 | 0.3500 | 0.4700 | 16.6150 | 141000.00 | 141000.00 | 0.00 | 3000 | 2 | 6453 | 1501 | 4.29913391072618 | 0.688786721978329 | 0.688786721978329 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 61af0278-2536-4b0a-b048-d5b8f5bb9c23 | 2026-08-18 14:16 | 2026-08-18 14:16 | 2026-08-18 14:16 | PCG | PCG260918C00019000 | call | 19.0000 | 2026-09-18 | 0.7400 | 0.6800 | 0.7500 | 17.8300 | 191364.00 | 191364.00 | 0.00 | 2586 | 2 | 3299 | 152889 | 0.0215777459464056 | 0.569082001948589 | 0.569082001948589 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |