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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0f268af5-eb62-47de-9901-67e92679c512 | 2026-09-16 15:25 | 2026-09-16 15:25 | 2026-09-16 15:25 | VST | VST260925C00180000 | call | 180.0000 | 2026-09-25 | 0.0700 | 0.0000 | 0.2900 | 139.8950 | 7000.00 | 0.00 | 7000.00 | 1000 | 1 | 1000 | 93 | 10.752688172043 | 0.704395615499214 | 0.704395615499214 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47119825026.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 46d9fae1-05b1-4d23-bf0d-800d40231cba | 2026-09-16 15:23 | 2026-09-16 15:22 | 2026-09-16 15:22 | VST | VST260925P00120000 | put | 120.0000 | 2026-09-25 | 0.1000 | 0.0000 | 0.1400 | 139.7850 | 10000.00 | 10000.00 | 0.00 | 1000 | 1 | 1020 | 231 | 4.41558441558442 | 0.502544581271436 | 0.502544581271436 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47119825026.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1ad45dd9-90f0-479d-ad41-82dcecc2ef63 | 2026-09-15 12:25 | 2026-09-15 12:25 | 2026-09-15 12:25 | VST | VST270917P00100000 | put | 100.0000 | 2027-09-17 | 7.0000 | 6.6000 | 7.5000 | 140.0000 | 280000.00 | 0.00 | 280000.00 | 400 | 1 | 400 | 146 | 2.73972602739726 | 0.494883908057957 | 0.494883908057957 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 5c75a9df-a688-4324-8130-7513938e24ed | 2026-09-15 12:07 | 2026-09-15 12:07 | 2026-09-15 12:07 | VST | VST290119P00140000 | put | 140.0000 | 2029-01-19 | 33.5500 | 33.5000 | 34.9500 | 140.4600 | 872300.00 | 0.00 | 872300.00 | 260 | 1 | 260 | 2 | 130 | 0.512601787068589 | 0.512601787068589 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| b7dfc3cd-6694-482d-82c4-a6396b147b1e | 2026-09-11 10:57 | 2026-09-11 10:57 | 2026-09-11 10:57 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.0000 | 3.8000 | 4.1500 | 148.2950 | 880000.00 | 880000.00 | 0.00 | 2200 | 1 | 2534 | 2547 | 0.994895956026698 | 0.442911649284253 | 0.442911649284253 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 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 |
| a4270869-455d-42ce-aa61-225817fef7b8 | 2026-08-31 10:02 | 2026-08-31 10:02 | 2026-08-31 10:02 | VST | VST270115P00110000 | put | 110.0000 | 2027-01-15 | 3.7500 | 3.6500 | 4.2000 | 136.2700 | 187500.00 | 0.00 | 187500.00 | 500 | 1 | 500 | 2547 | 0.196309383588536 | 0.448247476762536 | 0.448247476762536 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e26ac17e-7b31-495b-9bf0-3c5011c459f2 | 2026-08-24 11:54 | 2026-08-24 11:54 | 2026-08-24 11:54 | VST | VST270416P00095000 | put | 95.0000 | 2027-04-16 | 3.5300 | 3.3500 | 4.1500 | 136.3100 | 176500.00 | 0.00 | 176500.00 | 500 | 2 | 500 | 1 | 500 | 0.480947744549859 | 0.480947744549859 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 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:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3c0c8c5e-35a8-410a-b973-eec81469553e | 2026-08-19 14:13 | 2026-08-19 14:13 | 2026-08-19 14:13 | VST | VST260918P00140000 | put | 140.0000 | 2026-09-18 | 6.0300 | 5.8500 | 6.2500 | 140.9400 | 603000.00 | 0.00 | 603000.00 | 1000 | 2 | 6902 | 8936 | 0.772381378692927 | 0.417597825835767 | 0.417597825835767 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70f2bd33-aae3-4290-9954-4a667f81c136 | 2026-08-19 13:31 | 2026-08-19 13:30 | 2026-08-19 13:30 | VST | VST260918P00140000 | put | 140.0000 | 2026-09-18 | 5.6500 | 5.6500 | 6.0000 | 141.5100 | 678000.00 | 0.00 | 678000.00 | 1200 | 1 | 5764 | 8936 | 0.64503133393017 | 0.409383411112202 | 0.409383411112202 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 770dbd0f-94eb-43e3-b004-36a500809fad | 2026-08-19 10:40 | 2026-08-19 10:40 | 2026-08-19 10:40 | VST | VST260918P00140000 | put | 140.0000 | 2026-09-18 | 6.8000 | 6.8000 | 7.2000 | 139.6200 | 476000.00 | 0.00 | 476000.00 | 700 | 8 | 1445 | 8936 | 0.161705461056401 | 0.427879543575914 | 0.427879543575914 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 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 |
| c15ccd6d-1eff-49c0-aebf-8090a17e3987 | 2026-08-19 09:46 | 2026-08-19 09:46 | 2026-08-19 09:46 | VST | VST260918P00140000 | put | 140.0000 | 2026-09-18 | 6.5500 | 6.5500 | 7.2000 | 140.0350 | 458500.00 | 0.00 | 458500.00 | 700 | 8 | 711 | 8936 | 0.0795658012533572 | 0.424421343938923 | 0.424421343938923 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6db4cf7d-7d75-474a-b292-9cca2b9e1024 | 2026-08-17 15:19 | 2026-08-17 15:19 | 2026-08-17 15:19 | VST | VST260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2500 | 4.0500 | 4.2500 | 146.8375 | 425000.00 | 425000.00 | 0.00 | 1000 | 7 | 4456 | 2012 | 2.21471172962227 | 0.433799456269121 | 0.433799456269121 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 47233940992.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |