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.
Simplify Analyticsuw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| d3bfe906-4bf9-4fdc-8c26-79ba5b0ecac6 | 2026-09-01 14:07 | 2026-09-01 14:07 | 2026-09-01 14:07 | VICR | VICR261120P00165000 | put | 165.0000 | 2026-11-20 | 22.2100 | 21.0000 | 23.4000 | 177.2900 | 424238.00 | 355108.00 | 69130.00 | 191 | 9 | 215 | 304 | 0.707236842105263 | 0.90810146301453 | 0.891197406255819 | 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-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 084222c8-ec20-483b-8e00-196649062212 | 2026-08-31 13:59 | 2026-08-31 13:58 | 2026-08-31 13:58 | VICR | VICR261120C00210000 | call | 210.0000 | 2026-11-20 | 23.8000 | 22.3000 | 24.9000 | 187.0000 | 11900.00 | 2380.00 | 9520.00 | 5 | 5 | 5 | 48 | 0.104166666666667 | 0.901520047374923 | 0.901520047374923 | false | false | false | true | ||||||||||||||||
| 2f772ea6-d7c5-4635-a9a3-51e2db0c2524 | 2026-08-31 12:50 | 2026-08-31 12:50 | 2026-08-31 12:50 | VICR | VICR260918C00190000 | call | 190.0000 | 2026-09-18 | 11.1000 | 11.1000 | 12.2000 | 185.2200 | 15540.00 | 0.00 | 15540.00 | 14 | 11 | 14 | 12 | 1.16666666666667 | 0.795562867992838 | 0.795562867992838 | false | false | false | true | ||||||||||||||||
| 90db37f1-974f-41ef-8572-b4ae8676675d | 2026-08-28 12:01 | 2026-08-28 12:01 | 2026-08-28 12:01 | VICR | VICR260918P00155000 | put | 155.0000 | 2026-09-18 | 2.0500 | 2.0000 | 3.7000 | 191.0000 | 16196.00 | 5330.00 | 10866.00 | 79 | 17 | 88 | 74 | 1.18918918918919 | 0.787487827173921 | 0.786320961171486 | false | false | false | true | ||||||||||||||||
| d7c94916-bad2-4637-8cb3-350d8d4aa45a | 2026-08-27 15:43 | 2026-08-27 15:43 | 2026-08-27 15:43 | VICR | VICR280121C00220000 | call | 220.0000 | 2028-01-21 | 84.0000 | 82.6000 | 89.4000 | 201.8800 | 184800.00 | 176400.00 | 8400.00 | 22 | 6 | 26 | 21 | 1.23809523809524 | 0.944138540759611 | 0.944138540759611 | false | false | false | true | ||||||||||||||||
| 87fb7ac6-5cd8-4fb4-8758-22d04c3b4d59 | 2026-08-27 15:28 | 2026-08-27 15:28 | 2026-08-27 15:28 | VICR | VICR260918C00250000 | call | 250.0000 | 2026-09-18 | 2.9000 | 2.8500 | 3.0000 | 202.0000 | 14500.00 | 2900.00 | 11600.00 | 50 | 5 | 236 | 84 | 2.80952380952381 | 0.770199981892543 | 0.770199981892543 | false | false | false | true | ||||||||||||||||
| 58d23873-6a81-4461-96a9-11b88ca3e14c | 2026-08-26 15:38 | 2026-08-26 15:38 | 2026-08-26 15:38 | VICR | VICR260918C00220000 | call | 220.0000 | 2026-09-18 | 7.9000 | 7.9000 | 8.1000 | 197.8600 | 67150.00 | 0.00 | 67150.00 | 85 | 20 | 158 | 87 | 1.81609195402299 | 0.791828532261517 | 0.791828532261517 | false | false | false | true | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | |||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6352682556.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6352682556.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 6352682556.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |