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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3b768bd9-4257-4971-9ff5-fedb1ffb090c | 2026-08-17 11:00 | 2026-08-17 11:00 | 2026-08-17 11:00 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 6.3000 | 6.0500 | 6.4000 | 146.8950 | 21416.00 | 4410.00 | 17006.00 | 34 | 10 | 933 | 2936 | 0.317779291553134 | 0.431922405942506 | 0.431922405942506 | 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-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 303af3b5-18e2-4023-ac16-2429ff69df5e | 2026-08-17 11:00 | 2026-08-17 10:59 | 2026-08-17 10:59 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 6.3000 | 5.9500 | 6.3500 | 146.8950 | 324415.00 | 100145.00 | 224270.00 | 515 | 31 | 555 | 2936 | 0.189032697547684 | 0.431922405942506 | 0.431922405942506 | true | 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 |
| 061b2ead-ff48-48ab-9506-1569a6b9e0b3 | 2026-08-17 11:37 | 2026-08-17 11:37 | 2026-08-17 11:37 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 6.7500 | 6.3500 | 6.7500 | 145.6150 | 315224.00 | 315224.00 | 0.00 | 467 | 13 | 1415 | 2936 | 0.481948228882834 | 0.425481079002839 | 0.425481079002839 | 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-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a022cf98-0dee-4599-b17b-86f0f7b7ecff | 2026-08-18 13:51 | 2026-08-18 13:50 | 2026-08-18 13:50 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 8.0500 | 7.7500 | 8.0500 | 142.4950 | 150535.00 | 150535.00 | 0.00 | 187 | 6 | 365 | 3920 | 0.0931122448979592 | 0.418910104084781 | 0.418910104084781 | true | 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-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c75c772f-59f2-4bb2-a0c7-6ce052ce0968 | 2026-08-18 14:13 | 2026-08-18 14:13 | 2026-08-18 14:13 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 8.9000 | 8.6000 | 9.0500 | 141.1450 | 14240.00 | 7120.00 | 7120.00 | 16 | 9 | 466 | 3920 | 0.118877551020408 | 0.4265579583672 | 0.4265579583672 | 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 |
| 5cf1ff4d-8a12-4436-8db5-de81f5faf5ae | 2026-08-19 10:39 | 2026-08-19 10:39 | 2026-08-19 10:39 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 9.7500 | 9.6500 | 10.0500 | 139.6000 | 85800.00 | 25350.00 | 60450.00 | 88 | 7 | 111 | 3825 | 0.0290196078431373 | 0.432108709658792 | 0.430979830884162 | 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-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5e9acc35-8df4-4e08-a93e-e72b6dca8938 | 2026-08-19 11:04 | 2026-08-19 11:04 | 2026-08-19 11:04 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 9.1000 | 8.9500 | 9.4500 | 140.6369 | 230225.00 | 68235.00 | 161990.00 | 253 | 16 | 409 | 3825 | 0.106928104575163 | 0.427019277051774 | 0.42447037498549 | 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-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d099722e-88de-4a0a-a561-3602bed19421 | 2026-09-09 11:36 | 2026-09-09 11:36 | 2026-09-09 11:36 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 2.3400 | 2.3400 | 2.5200 | 149.6700 | 82134.00 | 0.00 | 82134.00 | 351 | 44 | 525 | 3931 | 0.133553803103536 | 0.467431794122241 | 0.468943947905706 | 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-09T15:51:30.246262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1cadfb8d-0def-4c59-8220-bb7574473b8d | 2026-09-11 10:47 | 2026-09-11 10:47 | 2026-09-11 10:47 | VST | VST260918P00145000 | put | 145.0000 | 2026-09-18 | 2.1800 | 2.1000 | 2.2500 | 148.1800 | 65182.00 | 65182.00 | 0.00 | 299 | 36 | 344 | 4368 | 0.0787545787545788 | 0.443166991352269 | 0.443166991352269 | 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-11T15:05:41.395170Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |