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.
uw_flow_alerts375,978 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 | expiry |
|---|
| 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 |
|---|
| 561b7c69-f92a-49cb-b005-a0fec8f41288 | 2026-09-23 15:22 | 2026-09-23 15:21 | 2026-09-23 15:21 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 0.7000 | 0.7000 | 0.8000 | 138.1300 | 686000.00 | 0.00 | 686000.00 | 9800 | 1 | 12436 | 14072 | 0.883740761796475 | 0.434691347138972 | 0.434691347138972 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Utilities | 46307587854.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:25:57.460829Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| e7818458-052b-441b-b5ce-4d666fdc6563 | 2026-09-18 11:12 | 2026-09-18 11:07 | 2026-09-18 11:12 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 1.6500 | 0.0000 | 0.0000 | 142.1200 | 793358.00 | 791273.00 | 2085.00 | 4810 | 43 | 7680 | 8582 | 0.89489629457003 | 0 | 0 | true | true | false | true | ||||||||||||||||
| e0c02ec4-cd2e-4c5d-a7b4-2c0b50c217d2 | 2026-09-18 11:08 | 2026-09-18 11:07 | 2026-09-18 11:07 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 1.6500 | 1.6400 | 1.7000 | 141.9600 | 12174.00 | 5775.00 | 6399.00 | 74 | 8 | 3003 | 8582 | 0.349918433931485 | 0.438441117143921 | 0.440347825566986 | true | false | false | true | ||||||||||||||||
| dd65623b-765d-4f94-8c90-4999f30fa553 | 2026-09-18 11:08 | 2026-09-18 11:07 | 2026-09-18 11:07 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 1.6200 | 1.5500 | 1.7000 | 141.8300 | 22732.00 | 22573.00 | 159.00 | 140 | 41 | 2839 | 8582 | 0.330808669307854 | 0.436881014122679 | 0.435914126875875 | true | false | false | true | ||||||||||||||||
| 32a5eb2c-9b56-47f3-989a-6fe79ee40d64 | 2026-09-18 11:08 | 2026-09-18 11:07 | 2026-09-18 11:07 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 1.6400 | 1.5500 | 1.6700 | 141.9600 | 12300.00 | 984.00 | 11316.00 | 75 | 15 | 2929 | 8582 | 0.341295735259846 | 0.438441117143921 | 0.438441117143921 | false | false | false | true | ||||||||||||||||
| f167fc32-85ac-4998-8ad1-75673bb4762a | 2026-09-16 15:14 | 2026-09-16 15:14 | 2026-09-16 15:14 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 1.5700 | 1.5700 | 1.6600 | 140.1500 | 55264.00 | 0.00 | 55264.00 | 352 | 29 | 746 | 9022 | 0.0826867656838838 | 0.447120437908162 | 0.447120437908162 | false | false | false | true | ||||||||||||||||
| a66234e9-15e1-4696-8746-8f92015aff16 | 2026-09-11 14:19 | 2026-09-11 14:19 | 2026-09-11 14:19 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.1500 | 4.0500 | 4.1500 | 148.6150 | 16595.00 | 16185.00 | 410.00 | 40 | 6 | 6479 | 2547 | 2.54377699254024 | 0.445641638626597 | 0.442641469069628 | false | false | false | true | ||||||||||||||||
| d2ed7c51-3480-4f0b-a6bd-523f0c83e534 | 2026-09-11 14:17 | 2026-09-11 14:17 | 2026-09-11 14:17 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.0500 | 3.9000 | 4.0500 | 148.5800 | 34830.00 | 34830.00 | 0.00 | 86 | 12 | 6298 | 2547 | 2.47271299568119 | 0.44032628775712 | 0.44032628775712 | false | false | false | true | ||||||||||||||||
| 28e09ce5-2f57-4ac3-81dc-4500646eab3a | 2026-09-11 13:46 | 2026-09-11 13:46 | 2026-09-11 13:46 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 3.9500 | 3.8000 | 3.9500 | 148.1900 | 41465.00 | 40685.00 | 780.00 | 105 | 10 | 5332 | 2547 | 2.09344326658814 | 0.441932291209766 | 0.438888031486461 | false | false | false | true | ||||||||||||||||
| 03c0eee1-debe-4810-b6f1-93c73453d7e4 | 2026-09-11 13:46 | 2026-09-11 13:46 | 2026-09-11 13:46 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 3.9500 | 3.8000 | 3.9500 | 148.1900 | 29608.00 | 29218.00 | 390.00 | 75 | 9 | 5407 | 2547 | 2.12288967412642 | 0.441932291209766 | 0.438888031486461 | false | false | false | true | ||||||||||||||||
| 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 | ||||||||||||||||
| 014fc3a6-7701-42fd-ba49-1c4619910b01 | 2026-09-11 10:36 | 2026-09-11 10:36 | 2026-09-11 10:36 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.0000 | 4.0000 | 4.1000 | 147.9805 | 10400.00 | 0.00 | 10400.00 | 26 | 12 | 215 | 2547 | 0.0844130349430703 | 0.449073906114609 | 0.449073906114609 | false | false | false | true | ||||||||||||||||
| 203b380d-a84d-4cf5-ad58-ffc3832e5636 | 2026-09-11 10:31 | 2026-09-11 10:31 | 2026-09-11 10:31 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.0000 | 4.0000 | 4.1500 | 148.1455 | 23200.00 | 0.00 | 23200.00 | 58 | 14 | 103 | 2547 | 0.0404397330192383 | 0.445842848887538 | 0.445842848887538 | true | false | false | true | ||||||||||||||||
| 2a999906-5d5b-4c07-bb67-976c225d79b9 | 2026-09-04 12:58 | 2026-09-04 12:58 | 2026-09-04 12:58 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.7000 | 4.6500 | 4.7000 | 148.6400 | 107134.00 | 105724.00 | 0.00 | 228 | 37 | 673 | 2088 | 0.322318007662835 | 0.436409118241653 | 0.43454844995097 | false | false | false | true | ||||||||||||||||
| 74c87716-31e5-47d9-a980-5a65b68f47b1 | 2026-09-04 12:49 | 2026-09-04 12:49 | 2026-09-04 12:49 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.6000 | 4.4000 | 4.6500 | 148.7600 | 23000.00 | 14260.00 | 4600.00 | 50 | 22 | 443 | 2088 | 0.212164750957854 | 0.426940945904657 | 0.426940945904657 | false | false | false | true | ||||||||||||||||
| af8b0b48-8ab5-41c8-b11f-be848d9780ba | 2026-08-24 11:53 | 2026-08-24 11:53 | 2026-08-24 11:53 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 2.4300 | 2.3900 | 2.5700 | 136.3700 | 17010.00 | 0.00 | 17010.00 | 70 | 7 | 289 | 1186 | 0.243676222596965 | 0.443081589714895 | 0.443081589714895 | false | false | false | true | ||||||||||||||||
| 0787e7bd-2d33-4270-9426-3526a36e028e | 2026-08-24 11:46 | 2026-08-24 11:46 | 2026-08-24 11:46 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 2.3600 | 2.3300 | 2.5900 | 136.3750 | 32997.00 | 0.00 | 32997.00 | 140 | 8 | 205 | 1186 | 0.172849915682968 | 0.436164967270492 | 0.445049448340328 | false | false | false | true | ||||||||||||||||
| f6e1af3d-891b-491b-8057-9a73722e2ed4 | 2026-08-19 14:03 | 2026-08-19 14:03 | 2026-08-19 14:03 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 4.0000 | 3.8000 | 4.0500 | 141.6000 | 40000.00 | 40000.00 | 0.00 | 100 | 10 | 122 | 939 | 0.129925452609159 | 0.439965367880054 | 0.439965367880054 | false | false | false | true | ||||||||||||||||
| cffa6ac1-42ad-4458-a081-325ab85db33f | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 5.3500 | 5.3000 | 5.5500 | 145.3300 | 25680.00 | 0.00 | 25680.00 | 48 | 5 | 203 | 737 | 0.275440976933514 | 0.438083203124589 | 0.441390985216862 | false | false | false | true | ||||||||||||||||
| e3bd5445-ce8a-41e3-8bfb-37f77a2118c8 | 2026-08-17 11:37 | 2026-08-17 11:37 | 2026-08-17 11:37 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 5.3500 | 5.3000 | 5.5000 | 145.4400 | 14980.00 | 0.00 | 14980.00 | 28 | 7 | 136 | 737 | 0.184531886024423 | 0.436901044829078 | 0.439658748473421 | false | false | false | true | ||||||||||||||||
| add2a1d0-7141-41c6-9b82-2c4449915a1d | 2026-08-17 11:31 | 2026-08-17 11:31 | 2026-08-17 11:31 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 5.5200 | 5.3000 | 5.5500 | 145.8700 | 33122.00 | 33122.00 | 0.00 | 60 | 6 | 105 | 737 | 0.14246947082768 | 0.440220178173152 | 0.440220178173152 | false | false | false | true |
| SweepsFollowedByFloor |
| 36cb34b2-bfec-40a0-b347-859cae1cf152 |
| 1 |
| Common Stock |
| Utilities |
| 47213802881.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47213802881.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47213802881.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 47213802881.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| 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-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |