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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5d891e2a-b7b1-45c7-8cca-8c423e69655f | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | PLAB | PLAB261218C00035000 | call | 35.0000 | 2026-12-18 | 1.5500 | 1.3500 | 1.5500 | 29.0000 | 37975.00 | 37975.00 | 0.00 | 245 | 13 | 328 | 1649 | 0.198908429351122 | 0.578923136770101 | 0.578923136770101 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1717407531.00 | 2026-12-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 225d210e-96c3-459b-842d-e3b2da023d17 | 2026-09-18 10:45 | 2026-09-18 10:45 | 2026-09-18 10:45 | PLAB | PLAB261218P00030000 | put | 30.0000 | 2026-12-18 | 4.0000 | 3.8000 | 4.1000 | 28.5350 | 24000.00 | 7600.00 | 16400.00 | 60 | 18 | 60 | 1334 | 0.0449775112443778 | 0.587461422658804 | 0.587461422658804 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1717407531.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e2795eb0-e24f-421e-b604-bf367f4f0ee5 | 2026-09-18 10:36 | 2026-09-18 10:36 | 2026-09-18 10:36 | PLAB | PLAB261218C00030000 | call | 30.0000 | 2026-12-18 | 2.9500 | 2.8500 | 3.0000 | 28.6300 | 11505.00 | 7080.00 | 4130.00 | 39 | 12 | 54 | 1337 | 0.0403889304412865 | 0.596602403418855 | 0.596602403418855 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1717407531.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 817e7a01-9ef0-4b9d-b373-d9d7fb69eebb | 2026-09-17 12:50 | 2026-09-17 12:50 | 2026-09-17 12:50 | PLAB | PLAB261218C00030000 | call | 30.0000 | 2026-12-18 | 2.9000 | 2.7500 | 2.9500 | 28.4900 | 10150.00 | 6960.00 | 3190.00 | 35 | 8 | 122 | 1215 | 0.100411522633745 | 0.596760238007171 | 0.596760238007171 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1682009231.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b7a979f9-bf2e-405f-98b8-b59e172cfd9e | 2026-09-17 10:26 | 2026-09-17 10:26 | 2026-09-17 10:26 | PLAB | PLAB261218C00030000 | call | 30.0000 | 2026-12-18 | 2.7500 | 2.6500 | 2.8000 | 28.1500 | 22275.00 | 825.00 | 21175.00 | 81 | 8 | 81 | 1215 | 0.0666666666666667 | 0.60014270918704 | 0.60014270918704 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1682009231.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 52aa65c6-786c-4304-bf61-8ed0ceea2164 | 2026-09-15 14:18 | 2026-09-15 14:18 | 2026-09-15 14:18 | PLAB | PLAB290119C00040000 | call | 40.0000 | 2029-01-19 | 7.8000 | 7.5000 | 9.2000 | 27.1500 | 17940.00 | 8580.00 | 5460.00 | 23 | 6 | 66 | 0 | 0 | 0.632187193372145 | 0.632187193372145 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| bdc0bf35-c5e8-45b3-a2cd-54a5301c03f7 | 2026-09-01 12:31 | 2026-09-01 12:31 | 2026-09-01 12:31 | PLAB | PLAB261218P00030000 | put | 30.0000 | 2026-12-18 | 5.0000 | 4.7000 | 5.2000 | 27.2200 | 16500.00 | 500.00 | 16000.00 | 33 | 11 | 84 | 1023 | 0.0821114369501466 | 0.595585728920301 | 0.595585728920301 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cde4176a-9e8f-4dc4-a376-9828acda4f80 | 2026-08-26 11:24 | 2026-08-26 11:23 | 2026-08-26 11:23 | PLAB | PLAB260918C00030000 | call | 30.0000 | 2026-09-18 | 2.2000 | 2.0500 | 2.2000 | 30.5843 | 24860.00 | 24860.00 | 0.00 | 113 | 20 | 898 | 1210 | 0.742148760330579 | 0.612384115041983 | 0.612384115041983 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2ba1ccb-04f0-4615-9411-fc11f6688ba7 | 2026-08-26 10:20 | 2026-08-26 10:20 | 2026-08-26 10:20 | PLAB | PLAB260918P00025000 | put | 25.0000 | 2026-09-18 | 0.2000 | 0.1000 | 0.2500 | 31.5999 | 25288.00 | 18928.00 | 1180.00 | 1265 | 22 | 2068 | 3493 | 0.592041225307758 | 0.69772123463964 | 0.697714553278386 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8db51b15-c0d0-4811-b8cb-feb3722bf623 | 2026-08-26 10:19 | 2026-08-26 10:19 | 2026-08-26 10:19 | PLAB | PLAB261218C00040000 | call | 40.0000 | 2026-12-18 | 2.0500 | 1.9500 | 2.0500 | 31.6471 | 25010.00 | 16400.00 | 0.00 | 122 | 7 | 253 | 1197 | 0.211361737677527 | 0.64093575173778 | 0.64093575173778 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 647d84a2-fe1d-45eb-8a80-397819b431f9 | 2026-08-26 10:19 | 2026-08-26 10:19 | 2026-08-26 10:19 | PLAB | PLAB261218C00040000 | call | 40.0000 | 2026-12-18 | 2.1000 | 1.9000 | 2.1000 | 31.6200 | 21000.00 | 21000.00 | 0.00 | 100 | 5 | 131 | 1197 | 0.109440267335004 | 0.650133434975225 | 0.650133434975225 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 770a3ca9-0961-4de1-ae98-2eeb01325c4e | 2026-08-26 09:49 | 2026-08-26 09:49 | 2026-08-26 09:49 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.6500 | 1.6000 | 1.6500 | 30.5850 | 11715.00 | 11715.00 | 0.00 | 71 | 8 | 3001 | 2006 | 1.49601196410768 | 0.639985224410437 | 0.639985224410437 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89856179-3342-4ede-b064-42ba2ab36319 | 2026-08-26 09:48 | 2026-08-26 09:48 | 2026-08-26 09:48 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.6500 | 1.5500 | 2.4000 | 30.8600 | 43230.00 | 4620.00 | 38610.00 | 262 | 19 | 2896 | 2006 | 1.44366899302094 | 0.650920913374751 | 0.651798216744409 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ebf0bcc-e472-42a1-8994-5b1f449227fc | 2026-08-26 09:46 | 2026-08-26 09:46 | 2026-08-26 09:46 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.6500 | 1.6000 | 1.8500 | 30.9635 | 13530.00 | 5610.00 | 7920.00 | 82 | 10 | 2565 | 2006 | 1.27866400797607 | 0.656187777836255 | 0.656187777836255 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a5410a4-f146-4e3a-9eba-2e7ff2dc81fb | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.5500 | 1.5000 | 1.9000 | 31.5900 | 19840.00 | 0.00 | 19375.00 | 128 | 22 | 1961 | 2006 | 0.977567298105683 | 0.664711159607807 | 0.661874452464007 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c98650cc-c35c-4881-a0e5-e20ed65855fd | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.6000 | 1.6000 | 1.9000 | 31.3001 | 56326.00 | 0.00 | 56326.00 | 352 | 40 | 1833 | 2006 | 0.913758723828514 | 0.66020418858003 | 0.66020418858003 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e516933b-8fbb-4e51-9147-7a09d9273af2 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.6500 | 1.6500 | 1.9000 | 31.3700 | 20460.00 | 0.00 | 20460.00 | 124 | 5 | 1245 | 2006 | 0.620638085742772 | 0.673141318059428 | 0.673141318059428 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 68ba6491-6f2d-4177-89ef-10b89e6753c0 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.7000 | 1.6500 | 1.7000 | 31.3700 | 26860.00 | 26860.00 | 0.00 | 158 | 12 | 1121 | 2006 | 0.558823529411765 | 0.683150842903961 | 0.683150842903961 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bb99ea46-ae60-4057-be7d-067e76731688 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.7000 | 1.6500 | 1.7000 | 31.3700 | 26690.00 | 4080.00 | 0.00 | 157 | 5 | 963 | 2006 | 0.480059820538385 | 0.683150842903961 | 0.683150842903961 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a142281-cb5a-4388-b698-e4b9a6e09fe1 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.7000 | 1.6500 | 1.9000 | 31.4291 | 32985.00 | 1875.00 | 31110.00 | 194 | 9 | 806 | 2006 | 0.401794616151545 | 0.685587641106945 | 0.685587641106945 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1de6fec8-0296-43ae-b318-67a5904b6709 | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.7500 | 1.6500 | 1.7500 | 31.4291 | 19600.00 | 19600.00 | 0.00 | 112 | 9 | 612 | 2006 | 0.305084745762712 | 0.69555379646085 | 0.69555379646085 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa4b4562-1bfb-4218-96cb-c380946ff8ec | 2026-08-26 09:42 | 2026-08-26 09:42 | 2026-08-26 09:42 | PLAB | PLAB261218P00025000 | put | 25.0000 | 2026-12-18 | 1.7500 | 1.0500 | 1.7500 | 31.1350 | 83825.00 | 7000.00 | 0.00 | 479 | 5 | 479 | 2006 | 0.238783649052841 | 0.683292340836061 | 0.683292340836061 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1bed50a5-d9a8-47c5-bb23-24f5f3412e99 | 2026-08-26 09:31 | 2026-08-26 09:31 | 2026-08-26 09:31 | PLAB | PLAB260918C00035000 | call | 35.0000 | 2026-09-18 | 2.3500 | 1.6500 | 2.3500 | 34.8450 | 29610.00 | 29610.00 | 0.00 | 126 | 18 | 516 | 2847 | 0.181243414120126 | 0.683777112908739 | 0.683777112908739 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 24b2e521-3099-47f1-bdea-bed1147cb74e | 2026-08-20 11:09 | 2026-08-20 11:09 | 2026-08-20 11:09 | PLAB | PLAB260918C00040000 | call | 40.0000 | 2026-09-18 | 0.6500 | 0.5500 | 0.7000 | 30.1600 | 13000.00 | 11440.00 | 1560.00 | 200 | 5 | 405 | 1192 | 0.339765100671141 | 0.91925160446028 | 0.923765105799486 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1602363056.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |