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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 097d5b96-d6a3-47aa-a6d7-2201108f7699 | 2026-08-17 09:32 | 2026-08-17 09:31 | 2026-08-17 09:31 | DK | DK260918C00062500 | call | 62.5000 | 2026-09-18 | 5.8000 | 5.3000 | 6.4000 | 64.3350 | 12761.00 | 0.00 | 6661.00 | 22 | 5 | 25 | 12 | 2.08333333333333 | 0.759368349098686 | 0.575872954958831 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | 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 |
| b84aaa5b-f913-457d-bc02-e4b8faa1ab8a | 2026-08-21 15:49 | 2026-08-21 15:48 | 2026-08-21 15:48 | DK | DK261016C00065000 | call | 65.0000 | 2026-10-16 | 10.5100 | 10.4000 | 11.4000 | 71.1550 | 23128.00 | 0.00 | 23128.00 | 22 | 6 | 110 | 243 | 0.452674897119342 | 0.642240211547909 | 0.642240211547909 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6685f12b-1082-4a87-a1c0-bd37c8f620d2 | 2026-08-26 13:12 | 2026-08-26 13:11 | 2026-08-26 13:11 | DK | DK261016P00067500 | put | 67.5000 | 2026-10-16 | 5.2500 | 5.2000 | 5.4000 | 71.2000 | 74580.00 | 31800.00 | 36020.00 | 142 | 22 | 142 | 6 | 23.6666666666667 | 0.694934012879576 | 0.694934012879576 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 307ddf83-a6ce-4ad1-b099-d64812eec2f7 | 2026-08-26 13:12 | 2026-08-26 13:11 | 2026-08-26 13:11 | DK | DK261016C00072500 | call | 72.5000 | 2026-10-16 | 6.8600 | 6.8000 | 6.9000 | 71.2000 | 39770.00 | 22770.00 | 8160.00 | 58 | 10 | 86 | 10 | 8.6 | 0.689634345720592 | 0.689634345720592 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c219a8a8-8dca-4278-bf73-cb5d96169ea3 | 2026-08-31 14:51 | 2026-08-31 14:51 | 2026-08-31 14:51 | DK | DK260918C00072500 | call | 72.5000 | 2026-09-18 | 3.8700 | 3.8000 | 4.1000 | 70.3700 | 22470.00 | 16770.00 | 5700.00 | 58 | 12 | 186 | 3029 | 0.0614064047540442 | 0.766587103005 | 0.748985906878341 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a8bc817d-6f66-462e-b29b-627e1ded5c62 | 2026-08-31 14:52 | 2026-08-31 14:52 | 2026-08-31 14:52 | DK | DK261016C00070000 | call | 70.0000 | 2026-10-16 | 7.6800 | 7.6000 | 7.8000 | 70.6300 | 40694.00 | 32334.00 | 8360.00 | 53 | 12 | 64 | 171 | 0.374269005847953 | 0.727263049791306 | 0.717098927996313 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5574573-b412-48a7-b55e-bcc85fb03f88 | 2026-09-01 09:39 | 2026-09-01 09:39 | 2026-09-01 09:39 | DK | DK260918C00070000 | call | 70.0000 | 2026-09-18 | 6.7300 | 6.3000 | 8.4000 | 73.7400 | 16824.00 | 0.00 | 16824.00 | 25 | 8 | 53 | 682 | 0.0777126099706745 | 0.743520850740497 | 0.743520850740497 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 45f8ea1a-e862-46f7-92d0-5c5357711cc1 | 2026-09-11 10:49 | 2026-09-11 10:49 | 2026-09-11 10:49 | DK | DK260918C00070000 | call | 70.0000 | 2026-09-18 | 7.7000 | 6.8000 | 8.6000 | 76.8950 | 46198.00 | 21558.00 | 13090.00 | 60 | 6 | 61 | 674 | 0.0905044510385757 | 0.751662868917628 | 0.747917085782016 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 4559959998.00 | 2026-11-06 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |