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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1d299cbf-336f-4dfd-b439-9de1f26ce8f1 | 2026-08-17 11:02 | 2026-08-17 11:01 | 2026-08-17 11:01 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 1.6400 | 1.4600 | 1.6400 | 146.6300 | 10000.00 | 10000.00 | 0.00 | 61 | 15 | 133 | 4480 | 0.0296875 | 0.439704325414979 | 0.439704325414979 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc8f76c0-2778-406c-9801-b792d2956805 | 2026-08-18 14:14 | 2026-08-18 14:14 | 2026-08-18 14:14 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.6500 | 2.6500 | 2.7300 | 141.0100 | 12985.00 | 0.00 | 12985.00 | 49 | 5 | 553 | 4616 | 0.119800693240901 | 0.440096045094198 | 0.440096045094198 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7dfc6801-4f44-4e78-8f35-d6dc16382284 | 2026-08-18 14:14 | 2026-08-18 14:14 | 2026-08-18 14:14 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.6500 | 2.5600 | 2.7400 | 141.1450 | 23320.00 | 10600.00 | 12720.00 | 88 | 12 | 464 | 4616 | 0.10051993067591 | 0.440096045094198 | 0.442602887530419 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17e39321-701d-4504-acd2-683509a0d2fd | 2026-08-18 14:14 | 2026-08-18 14:14 | 2026-08-18 14:14 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.6500 | 2.4800 | 2.6500 | 141.0000 | 23850.00 | 23850.00 | 0.00 | 90 | 6 | 643 | 4616 | 0.139298093587522 | 0.440096045094198 | 0.43991002079565 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b6c2e8d-056b-422e-bd0b-264de325a12b | 2026-08-18 14:18 | 2026-08-18 14:18 | 2026-08-18 14:18 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.6500 | 2.5000 | 2.6900 | 141.2000 | 38675.00 | 37349.00 | 1326.00 | 146 | 27 | 849 | 4616 | 0.18392547660312 | 0.441453642781875 | 0.444416035028174 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be770551-947e-4e84-8943-0f2024c397d7 | 2026-08-18 14:37 | 2026-08-18 14:37 | 2026-08-18 14:37 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.9800 | 2.8900 | 3.0500 | 140.0250 | 12216.00 | 4172.00 | 8044.00 | 41 | 10 | 1079 | 4616 | 0.233752166377816 | 0.4470205601321 | 0.446256466547366 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81022ad4-9df1-4ccf-8c56-8fae6efa7e2e | 2026-08-18 14:52 | 2026-08-18 14:48 | 2026-08-18 14:52 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 3.1500 | 0.0000 | 0.0000 | 139.4350 | 300580.00 | 283500.00 | 17080.00 | 956 | 15 | 2085 | 4616 | 0.451689774696707 | 0 | 0 | true | true | false | true | false | SweepsFollowedByFloor | 36cb34b2-bfec-40a0-b347-859cae1cf152 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ee13148-3d2a-4ee9-a7bc-8ef594f8f413 | 2026-08-19 12:07 | 2026-08-19 12:07 | 2026-08-19 12:07 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.4800 | 2.3800 | 2.6500 | 141.0504 | 12129.00 | 5979.00 | 6150.00 | 49 | 5 | 712 | 4368 | 0.163003663003663 | 0.432314371976321 | 0.436397027344331 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89e36d04-e7ec-42ff-9626-536b2cb0548b | 2026-08-19 12:07 | 2026-08-19 12:07 | 2026-08-19 12:07 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.4600 | 2.3800 | 2.7300 | 140.9850 | 138770.00 | 23787.00 | 114983.00 | 563 | 43 | 663 | 4368 | 0.151785714285714 | 0.431092920768933 | 0.431092920768933 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3671c957-e5a2-4d26-bf8d-85d38b531cc9 | 2026-08-24 12:32 | 2026-08-24 12:32 | 2026-08-24 12:32 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 3.0500 | 2.9300 | 3.0500 | 136.6600 | 12505.00 | 12505.00 | 0.00 | 41 | 13 | 213 | 4845 | 0.0439628482972136 | 0.424723663947133 | 0.424723663947133 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c04d1190-16c4-49ad-ad75-8a7f89222318 | 2026-08-25 14:51 | 2026-08-25 14:51 | 2026-08-25 14:51 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.1000 | 2.1000 | 2.1600 | 139.3000 | 19950.00 | 0.00 | 19950.00 | 95 | 16 | 192 | 4974 | 0.0386007237635706 | 0.411527056125382 | 0.411527056125382 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 375fcca4-3418-48c8-ab44-3ac387b6a628 | 2026-08-26 12:38 | 2026-08-26 12:38 | 2026-08-26 12:38 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 2.0100 | 2.0100 | 2.0500 | 139.9300 | 19899.00 | 0.00 | 19899.00 | 99 | 6 | 195 | 5019 | 0.0388523610280932 | 0.42506985526464 | 0.42506985526464 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d7a82177-62aa-4d17-a070-dfbedc99ed56 | 2026-09-04 12:29 | 2026-09-04 12:28 | 2026-09-04 12:28 | VST | VST260918P00130000 | put | 130.0000 | 2026-09-18 | 0.2700 | 0.2700 | 0.3300 | 148.2550 | 10746.00 | 0.00 | 10746.00 | 398 | 15 | 874 | 4928 | 0.177353896103896 | 0.424819052284441 | 0.424819052284441 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |