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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5d009129-a540-4f12-8459-c814c728c3b3 | 2026-09-16 13:53 | 2026-09-16 13:53 | 2026-09-16 13:53 | PSNL | PSNL270115C00020000 | call | 20.0000 | 2027-01-15 | 0.3500 | 0.2000 | 0.4000 | 16.0000 | 15469.00 | 15469.00 | 0.00 | 442 | 32 | 3192 | 9478 | 0.336779911373708 | 0.369921650150476 | 0.369921650150476 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1720545938.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1273cff2-2341-45d9-9686-065adfe8dca3 | 2026-09-15 15:42 | 2026-09-15 15:42 | 2026-09-15 15:42 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 0.7000 | 0.6000 | 1.3500 | 16.0300 | 140000.00 | 17500.00 | 122500.00 | 2000 | 6 | 2656 | 13993 | 0.18980919030944 | 0.320350068229058 | 0.320350068229058 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 35c391d9-b195-4768-815c-08af6a9a3bac | 2026-09-02 13:27 | 2026-09-02 13:27 | 2026-09-02 13:27 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.3000 | 1.1000 | 1.5500 | 16.8600 | 26000.00 | 17160.00 | 8840.00 | 200 | 6 | 800 | 15717 | 0.0509002990392569 | 0.359349615160096 | 0.359349615160096 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d1d0015e-b185-42ee-b86f-ecea9003b34c | 2026-09-01 10:19 | 2026-09-01 10:19 | 2026-09-01 10:19 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.1000 | 0.9000 | 1.7500 | 17.0650 | 17380.00 | 1540.00 | 14300.00 | 158 | 15 | 865 | 14881 | 0.0581278139909952 | 0.284350495608863 | 0.284350495608863 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 522f1d5f-c580-4e44-8789-c61b8b5212c6 | 2026-09-01 10:19 | 2026-09-01 10:19 | 2026-09-01 10:19 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.2000 | 1.0000 | 1.2000 | 17.0750 | 11520.00 | 5280.00 | 0.00 | 96 | 7 | 707 | 14881 | 0.0475102479672065 | 0.307184857423771 | 0.307184857423771 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 646321de-48a7-4d4f-8a13-96c3e85680f0 | 2026-08-31 15:28 | 2026-08-31 15:28 | 2026-08-31 15:28 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.1000 | 0.9000 | 1.1000 | 16.7800 | 30800.00 | 30800.00 | 0.00 | 280 | 5 | 996 | 13881 | 0.071752755565161 | 0.317149826756924 | 0.317149826756924 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | 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 |
| 0e5e26f6-ae2e-46cd-959c-354f8cdafdd5 | 2026-08-31 13:50 | 2026-08-31 13:50 | 2026-08-31 13:50 | PSNL | PSNL270115C00020000 | call | 20.0000 | 2027-01-15 | 0.5000 | 0.5000 | 0.6500 | 16.0000 | 28300.00 | 0.00 | 28300.00 | 566 | 7 | 2502 | 7250 | 0.345103448275862 | 0.349749716836471 | 0.349749716836471 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 64055478-4177-4fdd-bc5a-dd497a5db89e | 2026-08-28 15:55 | 2026-08-28 15:55 | 2026-08-28 15:55 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.2500 | 1.1500 | 1.9000 | 17.0200 | 14627.00 | 0.00 | 14627.00 | 117 | 18 | 133 | 13721 | 0.00969317105167262 | 0.323192080697928 | 0.323192080697928 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8da4ec97-db35-4540-9c7d-fcba2920ac15 | 2026-08-27 15:19 | 2026-08-27 15:19 | 2026-08-27 15:19 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.0000 | 1.0000 | 1.3500 | 16.0000 | 10000.00 | 0.00 | 10000.00 | 100 | 12 | 3334 | 10400 | 0.320576923076923 | 0.296730785446208 | 0.296730785446208 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 59a81ffe-c1b7-4e79-9439-4cf8df895382 | 2026-08-25 11:28 | 2026-08-25 11:28 | 2026-08-25 11:28 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 1.7000 | 1.7000 | 1.8000 | 17.4400 | 20740.00 | 0.00 | 20740.00 | 122 | 13 | 445 | 9334 | 0.0476751660595672 | 0.368850711051601 | 0.368850711051601 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70287683-e8b9-4b5b-ac75-f05b658f6c73 | 2026-08-21 15:06 | 2026-08-21 15:06 | 2026-08-21 15:06 | PSNL | PSNL270115C00017500 | call | 17.5000 | 2027-01-15 | 2.7500 | 2.7500 | 3.4000 | 18.2400 | 13751.00 | 0.00 | 13751.00 | 50 | 16 | 1329 | 5689 | 0.233608718579715 | 0.493332465433903 | 0.493332465433903 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be9ba78a-0577-4d47-b83c-9874b32f4c4b | 2026-08-21 11:29 | 2026-08-21 11:29 | 2026-08-21 11:29 | PSNL | PSNL260918C00022500 | call | 22.5000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7000 | 18.6700 | 14000.00 | 14000.00 | 0.00 | 200 | 16 | 301 | 1 | 301 | 0.910826623472842 | 0.910826623472842 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 468894e8-1b61-4c09-9686-a83b2beb4c40 | 2026-08-20 14:48 | 2026-08-20 14:48 | 2026-08-20 14:48 | PSNL | PSNL260918C00017500 | call | 17.5000 | 2026-09-18 | 0.8500 | 0.6000 | 0.8500 | 16.5350 | 12580.00 | 12580.00 | 0.00 | 148 | 17 | 2122 | 143 | 14.8391608391608 | 0.657317327825863 | 0.657317327825863 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bc7c935e-bafc-4cbb-9756-772f356db5e8 | 2026-08-20 11:47 | 2026-08-20 11:47 | 2026-08-20 11:47 | PSNL | PSNL260918C00017500 | call | 17.5000 | 2026-09-18 | 0.8000 | 0.6500 | 0.8500 | 16.7200 | 10240.00 | 10160.00 | 80.00 | 128 | 18 | 697 | 143 | 4.87412587412587 | 0.587214860072894 | 0.587214860072894 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9699b33a-2490-40ca-ab22-e8775114a6b9 | 2026-08-19 15:06 | 2026-08-19 15:06 | 2026-08-19 15:06 | PSNL | PSNL260821C00015000 | call | 15.0000 | 2026-08-21 | 0.8500 | 0.8000 | 0.8500 | 15.8650 | 11730.00 | 11730.00 | 0.00 | 138 | 15 | 1571 | 1451 | 1.08270158511371 | 0.224116076858002 | 0.224116076858002 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1739769915.00 | 2026-11-03 | 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 |