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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22189639-7af8-462e-8407-133e410b3fea | 2026-08-14 15:53 | 2026-08-14 15:53 | 2026-08-14 15:53 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.8500 | 1.8400 | 1.8600 | 174.3800 | 82510.00 | 39590.00 | 0.00 | 446 | 11 | 15062 | 19877 | 0.757760225386125 | 0.409998458968783 | 0.409998458968783 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | 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 |
| 57947383-db94-40b9-bd4f-da8ab5e3b165 | 2026-08-17 10:18 | 2026-08-17 10:18 | 2026-08-17 10:18 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 2.0000 | 2.0000 | 2.0400 | 175.6500 | 52680.00 | 0.00 | 52680.00 | 263 | 5 | 9367 | 21110 | 0.44372335386073 | 0.507059582643999 | 0.506077911364264 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 59c55937-c081-4cf2-ae9c-f1415c0bfd2e | 2026-08-17 10:26 | 2026-08-17 10:26 | 2026-08-17 10:26 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.8000 | 1.8000 | 1.8100 | 175.1000 | 145620.00 | 0.00 | 145620.00 | 809 | 17 | 11592 | 21110 | 0.549123638086215 | 0.502706790391869 | 0.502706790391869 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 31119feb-693b-4ffd-b54a-5f670d20413e | 2026-08-17 11:54 | 2026-08-17 11:54 | 2026-08-17 11:54 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.9500 | 1.9500 | 1.9700 | 175.8100 | 56160.00 | 0.00 | 56160.00 | 288 | 28 | 19983 | 21110 | 0.946612979630507 | 0.490619844092062 | 0.490619844092062 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bbada678-2a84-4d91-98b8-c166b0b2d297 | 2026-08-17 15:52 | 2026-08-17 15:52 | 2026-08-17 15:52 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.0800 | 1.0600 | 1.0800 | 172.6600 | 86400.00 | 86400.00 | 0.00 | 800 | 40 | 33244 | 21110 | 1.5747986736144 | 0.490844824666215 | 0.490025488933669 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ebd854c-f9ad-4ccf-96b2-1eeea22816b5 | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.6200 | 1.6000 | 1.6200 | 176.1800 | 226962.00 | 226962.00 | 0.00 | 1401 | 5 | 4106 | 32594 | 0.125974105663619 | 0.600502151899511 | 0.600502151899511 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe2c1d49-5746-4b11-b57d-092f2fdc8e96 | 2026-08-19 12:21 | 2026-08-19 12:21 | 2026-08-19 12:21 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.5000 | 1.4700 | 1.5400 | 176.7100 | 89886.00 | 88977.00 | 0.00 | 599 | 38 | 36301 | 32594 | 1.11373258882003 | 0.545118874102892 | 0.544568141006121 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cbe83ba2-b9fc-4745-b660-a2bd3bdc9ccc | 2026-08-19 15:49 | 2026-08-19 15:49 | 2026-08-19 15:49 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 0.8700 | 0.8500 | 0.8700 | 174.8500 | 54375.00 | 54375.00 | 0.00 | 625 | 50 | 46399 | 32594 | 1.42354421059091 | 0.513038975605081 | 0.513038975605081 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc489967-d493-44f1-83ef-eb9b1c613eef | 2026-08-21 11:51 | 2026-08-21 11:51 | 2026-08-21 11:51 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 1.0100 | 0.8000 | 1.3000 | 180.4700 | 81665.00 | 77097.00 | 2350.00 | 806 | 103 | 56924 | 34155 | 1.66663738837652 | 0.632757117129461 | 0.669569394945568 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f7ff35ef-c87c-4e10-ad23-c0d4408b2556 | 2026-08-21 11:52 | 2026-08-21 11:52 | 2026-08-21 11:52 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 2.0000 | 1.9500 | 2.1700 | 181.5500 | 174189.00 | 173993.00 | 196.00 | 871 | 19 | 58701 | 34155 | 1.71866490996926 | 0.705256244538547 | 0.636561664406477 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 04a86973-a7f1-4734-8507-83e005ed6e70 | 2026-08-21 11:52 | 2026-08-21 11:52 | 2026-08-21 11:52 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 2.0000 | 1.9400 | 2.0500 | 181.5000 | 75447.00 | 50447.00 | 3400.00 | 377 | 13 | 60316 | 34155 | 1.76594934855804 | 0.724739348542642 | 0.69514009275192 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8032c36c-caa8-4b03-aa15-58fa51f81fea | 2026-08-21 11:58 | 2026-08-21 11:58 | 2026-08-21 11:58 | PLTR | PLTR260821C00180000 | call | 180.0000 | 2026-08-21 | 2.5000 | 2.3800 | 2.5700 | 182.1400 | 70447.00 | 69456.00 | 741.00 | 282 | 29 | 64428 | 34155 | 1.88634167764603 | 0.715064375752329 | 0.694787705798399 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |