Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 353ec7f0-38da-479f-a8ba-93fc5f4ad9d4 | 2026-09-17 09:30 | 2026-09-17 09:30 | 2026-09-17 09:30 | PSX | PSX260918C00230000 | call | 230.0000 | 2026-09-18 | 34.6300 | 29.6500 | 34.6500 | 261.1100 | 110800.00 | 110800.00 | 0.00 | 32 | 12 | 37 | 490 | 0.0755102040816327 | 2.69481352445989 | 2.69481352445989 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 109415525376.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| f0b100de-a025-4de8-bcc1-e09d7eb33d1f | 2026-09-17 15:25 | 2026-09-17 15:25 | 2026-09-17 15:25 | PSX | PSX261120P00270000 | put | 270.0000 | 2026-11-20 | 18.3000 | 17.8000 | 18.8000 | 272.2700 | 65880.00 | 64050.00 | 1830.00 | 36 | 10 | 165 | 122 | 1.35245901639344 | 0.451409077652092 | 0.451409077652092 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 109415525376.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 65276bbf-3341-4e19-a798-55fa0ffe200b | 2026-09-18 13:46 | 2026-09-18 13:46 | 2026-09-18 13:46 | PSX | PSX261120C00270000 | call | 270.0000 | 2026-11-20 | 21.5000 | 20.7000 | 21.5000 | 271.7400 | 51593.00 | 51593.00 | 0.00 | 24 | 12 | 39 | 297 | 0.131313131313131 | 0.439170796997983 | 0.439170796997983 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 108984582787.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f240acd8-d02f-4b0a-8eef-4bc96058d740 | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | PSX | PSX260925C00275000 | call | 275.0000 | 2026-09-25 | 2.4000 | 2.4000 | 2.6500 | 267.7450 | 12960.00 | 0.00 | 12960.00 | 54 | 11 | 119 | 116 | 1.02586206896552 | 0.459755218619182 | 0.459755218619182 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 625582e3-aec2-4ae2-a08b-c91562e93f71 | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | PSX | PSX260925C00280000 | call | 280.0000 | 2026-09-25 | 1.4000 | 1.3000 | 1.8000 | 268.2970 | 11480.00 | 1680.00 | 8400.00 | 82 | 13 | 654 | 553 | 1.18264014466546 | 0.462518026111492 | 0.462518026111492 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 2cae9d63-3937-4252-a487-eeb2a4f7be5b | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | PSX | PSX260925P00250000 | put | 250.0000 | 2026-09-25 | 0.8000 | 0.7000 | 1.0000 | 266.9800 | 48560.00 | 0.00 | 40960.00 | 607 | 50 | 613 | 104 | 5.89423076923077 | 0.526833857306581 | 0.526833857306581 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 2bd04150-1293-4612-a33f-dce231896663 | 2026-09-21 12:22 | 2026-09-21 12:21 | 2026-09-21 12:21 | PSX | PSX261218C00290000 | call | 290.0000 | 2026-12-18 | 14.1500 | 13.8000 | 14.4000 | 265.7550 | 42450.00 | 25470.00 | 0.00 | 30 | 5 | 49 | 600 | 0.0816666666666667 | 0.431115289483578 | 0.431115289483578 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| c4c9cd10-aef7-404d-b528-347a9d7135b5 | 2026-09-21 14:02 | 2026-09-21 14:02 | 2026-09-21 14:02 | PSX | PSX260925P00250000 | put | 250.0000 | 2026-09-25 | 0.6300 | 0.4500 | 0.9500 | 265.0000 | 20003.00 | 943.00 | 19060.00 | 317 | 64 | 1337 | 104 | 12.8557692307692 | 0.476239012534961 | 0.465915487540837 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:05:09.858972Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9f44e4cc-e8ac-4de2-9a8f-0de6ebd1e31c | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | PSX | PSX261016P00245000 | put | 245.0000 | 2026-10-16 | 5.2000 | 4.7000 | 5.2000 | 259.0000 | 28080.00 | 28080.00 | 0.00 | 54 | 8 | 72 | 0 | 0 | 0.431109913558331 | 0.430325894037313 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 50007b6f-ff04-499e-9788-818a9d313c54 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | PSX | PSX261002P00257500 | put | 257.5000 | 2026-10-02 | 6.7000 | 5.9000 | 6.7000 | 259.0000 | 11390.00 | 11390.00 | 0.00 | 17 | 5 | 18 | 8 | 2.25 | 0.447165059803619 | 0.445586481247176 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 104443724763.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |