Simplify AnalyticsOptions 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 rowsrestricted — hover for the licence
active:ticker = VICR×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1e9e472d-7a34-4e53-8347-bb0fd4f14148 | 2026-08-26 15:38 | 2026-08-26 15:37 | 2026-08-26 15:37 | VICR | VICR260918P00200000 | put | 200.0000 | 2026-09-18 | 17.0000 | 17.0000 | 18.5000 | 197.5400 | 15300.00 | 0.00 | 15300.00 | 9 | 5 | 57 | 238 | 0.239495798319328 | 0.805576367486299 | 0.805576367486299 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff15e0c8-464d-4876-9aeb-55081f23a04e | 2026-08-24 15:48 | 2026-08-24 15:48 | 2026-08-24 15:48 | VICR | VICR260918P00165000 | put | 165.0000 | 2026-09-18 | 6.5000 | 6.5000 | 7.0000 | 189.5500 | 32500.00 | 0.00 | 32500.00 | 50 | 5 | 1012 | 237 | 4.27004219409283 | 0.867660055923713 | 0.867660055923713 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27024b64-4579-4452-b9ec-bd550a25984b | 2026-08-24 15:27 | 2026-08-24 15:27 | 2026-08-24 15:27 | VICR | VICR260918P00165000 | put | 165.0000 | 2026-09-18 | 6.0000 | 6.0000 | 6.5000 | 190.8600 | 35400.00 | 0.00 | 35400.00 | 59 | 5 | 343 | 237 | 1.44725738396624 | 0.853918096983559 | 0.853918096983559 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b276df94-d293-432d-8265-847d7f57fdea | 2026-08-24 15:27 | 2026-08-24 15:27 | 2026-08-24 15:27 | VICR | VICR260918P00165000 | put | 165.0000 | 2026-09-18 | 6.0000 | 5.7000 | 6.4000 | 190.9200 | 32400.00 | 4200.00 | 28200.00 | 54 | 5 | 284 | 237 | 1.19831223628692 | 0.854808870587516 | 0.854808870587516 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c973fdcf-a4aa-4480-ad42-44adf4f49d30 | 2026-08-24 11:07 | 2026-08-24 11:07 | 2026-08-24 11:07 | VICR | VICR261120C00280000 | call | 280.0000 | 2026-11-20 | 12.2000 | 12.2000 | 13.7000 | 189.9950 | 196420.00 | 0.00 | 196420.00 | 161 | 28 | 162 | 81 | 2 | 0.943093944590441 | 0.943093944590441 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0338e85b-b9bd-4721-9435-1297316c4b6f | 2026-08-19 14:25 | 2026-08-19 14:25 | 2026-08-19 14:25 | VICR | VICR261120C00320000 | call | 320.0000 | 2026-11-20 | 13.2000 | 13.2000 | 15.9000 | 210.8700 | 95040.00 | 0.00 | 95040.00 | 72 | 19 | 72 | 23 | 3.1304347826087 | 0.943791645232942 | 0.943791645232942 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |
| d637b0a7-1e78-43e9-ac49-994703deefa5 | 2026-08-19 11:39 | 2026-08-19 11:39 | 2026-08-19 11:39 | VICR | VICR260918P00165000 | put | 165.0000 | 2026-09-18 | 3.0000 | 2.1000 | 3.0000 | 219.1900 | 18900.00 | 18900.00 | 0.00 | 63 | 21 | 92 | 131 | 0.702290076335878 | 0.877181512155335 | 0.877181512155335 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8020eed3-9b4b-4537-a805-fb1630271f0d | 2026-08-19 10:42 | 2026-08-19 10:42 | 2026-08-19 10:42 | VICR | VICR260821P00220000 | put | 220.0000 | 2026-08-21 | 5.5000 | 3.7000 | 8.5000 | 223.2650 | 29700.00 | 18700.00 | 11000.00 | 54 | 7 | 70 | 641 | 0.109204368174727 | 1.0747563181596 | 1.0747563181596 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |
| fd59a713-6284-40d7-b11b-d68283acdacc | 2026-08-19 10:39 | 2026-08-19 10:39 | 2026-08-19 10:39 | VICR | VICR261120C00390000 | call | 390.0000 | 2026-11-20 | 9.5000 | 6.8000 | 12.2000 | 225.7400 | 14250.00 | 8550.00 | 2850.00 | 15 | 5 | 15 | 5 | 3 | 0.960621832907619 | 0.960621832907619 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |
| 0373a4fa-4891-48cf-af7e-a25b513420d0 | 2026-08-18 14:10 | 2026-08-18 14:10 | 2026-08-18 14:10 | VICR | VICR260821C00200000 | call | 200.0000 | 2026-08-21 | 34.1700 | 34.1000 | 36.2000 | 233.7800 | 102500.00 | 0.00 | 102500.00 | 30 | 8 | 264 | 100 | 2.64 | 1.01151501255069 | 0.951562680083477 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |
| 0fed004e-5d9f-436c-aebe-1486c6380c36 | 2026-08-18 14:00 | 2026-08-18 13:59 | 2026-08-18 13:59 | VICR | VICR260918P00200000 | put | 200.0000 | 2026-09-18 | 8.7000 | 7.8000 | 8.7000 | 233.2300 | 53940.00 | 53940.00 | 0.00 | 62 | 20 | 75 | 143 | 0.524475524475524 | 0.860216729241043 | 0.860216729241043 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |
| 1fd4a35d-65a9-4f4b-8caf-cc652f2dc367 | 2026-08-18 13:52 | 2026-08-18 13:52 | 2026-08-18 13:52 | VICR | VICR260821C00200000 | call | 200.0000 | 2026-08-21 | 35.3900 | 35.0000 | 36.8000 | 234.4500 | 38928.00 | 24768.00 | 14160.00 | 11 | 8 | 153 | 100 | 1.53 | 1.24971604821057 | 1.23582623984065 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 6352682556.00 | 2026-10-20 | 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 |