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_alerts474,253 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 |
|---|
| 29ee5bc6-2c61-455a-a45a-f12083607ac4 | 2026-09-25 15:39 | 2026-09-25 15:39 | 2026-09-25 15:39 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.2100 | 8.2000 | 8.6000 | 516.0000 | 228960.00 | 0.00 | 228960.00 | 279 | 14 | 5980 | 1697 | 3.52386564525633 | 0.257471223027217 | 0.261906406184769 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 3832843816089.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 55cc3084-f859-455d-b299-c703bc6405a1 | 2026-09-25 15:24 | 2026-09-25 15:24 | 2026-09-25 15:24 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.2000 | 8.2000 | 8.3000 | 515.8500 | 27060.00 | 0.00 | 27060.00 | 33 | 17 | 5645 | 1697 | 3.326458456099 | 0.265629507113365 | 0.265629507113365 | true | false | false | true | ||||||||||||||||
| f51d9acd-34db-4c01-8f6b-0d14ad2638d0 | 2026-09-25 15:18 | 2026-09-25 15:18 | 2026-09-25 15:18 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.6000 | 8.6000 | 8.7500 | 516.4400 | 12900.00 | 0.00 | 12900.00 | 15 | 11 | 5584 | 1697 | 3.29051266941662 | 0.26850764519297 | 0.26850764519297 | true | false | false | true | ||||||||||||||||
| dafb766a-4a69-44a7-95d9-f3ce77064c53 | 2026-09-25 13:47 | 2026-09-25 13:47 | 2026-09-25 13:47 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.0500 | 8.0500 | 8.2500 | 515.8051 | 20125.00 | 0.00 | 20125.00 | 25 | 9 | 5217 | 1697 | 3.07424867413082 | 0.26119071601588 | 0.26119071601588 | false | false | false | true | ||||||||||||||||
| d1cf9d90-c00b-4ee2-8caf-45de9dcc7d13 | 2026-09-25 10:49 | 2026-09-25 10:49 | 2026-09-25 10:49 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.0000 | 7.5500 | 8.0000 | 515.2100 | 20000.00 | 20000.00 | 0.00 | 25 | 5 | 3285 | 1697 | 1.93576900412493 | 0.27045427000365 | 0.27045427000365 | false | false | false | true | ||||||||||||||||
| a201cbfd-5ca7-42b5-af1b-f88dfa54a110 | 2026-09-25 10:42 | 2026-09-25 10:42 | 2026-09-25 10:42 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 7.5000 | 7.3000 | 7.5500 | 514.0050 | 30000.00 | 30000.00 | 0.00 | 40 | 5 | 3228 | 1697 | 1.9021803182086 | 0.274383860323128 | 0.274383860323128 | true | false | false | true | ||||||||||||||||
| 36c46c48-c4e6-4daf-b66b-37f38127f775 | 2026-09-25 10:40 | 2026-09-25 10:40 | 2026-09-25 10:40 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 7.7500 | 7.5000 | 7.8500 | 514.7100 | 41075.00 | 31000.00 | 10075.00 | 53 | 6 | 3026 | 1697 | 1.78314672952269 | 0.270715118738658 | 0.270715118738658 | false | false | false | true | ||||||||||||||||
| 48235e24-31a3-4ab2-942b-fc3e81c258aa | 2026-09-25 10:17 | 2026-09-25 10:17 | 2026-09-25 10:17 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 5.9500 | 5.8500 | 6.2000 | 510.7600 | 14865.00 | 0.00 | 14865.00 | 25 | 6 | 2605 | 1697 | 1.53506187389511 | 0.273302342322775 | 0.273302342322775 | false | false | false | true | ||||||||||||||||
| f342b3a2-f325-42ba-9344-401bd7d8a114 | 2026-09-25 09:51 | 2026-09-25 09:51 | 2026-09-25 09:51 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.4100 | 8.3500 | 8.5500 | 515.8351 | 49596.00 | 0.00 | 49596.00 | 59 | 5 | 1602 | 1697 | 0.944018856806129 | 0.27095448423779 | 0.273655419190135 | false | false | false | true | ||||||||||||||||
| 7632d2a5-90c0-45be-8fbc-27366729ab5b | 2026-09-25 09:51 | 2026-09-25 09:51 | 2026-09-25 09:51 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 8.3100 | 8.3000 | 8.6500 | 515.7950 | 103105.00 | 0.00 | 103105.00 | 124 | 7 | 1539 | 1697 | 0.906894519740719 | 0.270650259199379 | 0.271942488064039 | false | false | false | true | ||||||||||||||||
| c7307f95-73a7-4f12-88d4-e02909ab134d | 2026-09-25 09:49 | 2026-09-25 09:49 | 2026-09-25 09:49 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 7.8000 | 7.5000 | 7.8000 | 514.4900 | 18720.00 | 18720.00 | 0.00 | 24 | 13 | 1276 | 1697 | 0.751915144372422 | 0.27746738725597 | 0.276401814925751 | true | false | false | true | ||||||||||||||||
| db13cd8d-5d21-4403-9e79-061cfc5d6fb4 | 2026-09-25 09:43 | 2026-09-25 09:43 | 2026-09-25 09:43 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 7.1000 | 7.1000 | 7.3000 | 513.2900 | 114310.00 | 0.00 | 114310.00 | 161 | 15 | 878 | 1697 | 0.517383618149676 | 0.27258164815507 | 0.27258164815507 | true | false | false | true | ||||||||||||||||
| 90c68af6-104d-4bb8-8854-b9f3bd01f6e8 | 2026-09-24 13:38 | 2026-09-24 13:38 | 2026-09-24 13:38 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 1.5700 | 1.4900 | 1.5700 | 495.4200 | 15543.00 | 15543.00 | 0.00 | 99 | 7 | 838 | 1362 | 0.615271659324523 | 0.254604478558412 | 0.254604478558412 | false | false | false | true | ||||||||||||||||
| ee86a25c-3dfd-496b-bc31-90552e7f6b6f | 2026-09-23 10:27 | 2026-09-23 10:27 | 2026-09-23 10:27 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 2.5100 | 2.5100 | 2.6300 | 496.6100 | 117218.00 | 0.00 | 117218.00 | 467 | 54 | 1181 | 1048 | 1.12690839694656 | 0.273095386574317 | 0.273892260100946 | false | false | false | true | ||||||||||||||||
| 38ff0a48-4d2c-4726-8fcc-e6ec3d269125 | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 4.0000 | 3.8500 | 4.0000 | 502.3725 | 19200.00 | 19200.00 | 0.00 | 48 | 12 | 503 | 1048 | 0.479961832061069 | 0.275049098247136 | 0.275049098247136 | false | false | false | true | ||||||||||||||||
| 2fd3f0bd-7ba1-4dc2-a1a4-b60599b60ecb | 2026-09-22 12:35 | 2026-09-22 12:35 | 2026-09-22 12:35 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 2.4500 | 2.4300 | 2.5600 | 495.8700 | 14460.00 | 248.00 | 8600.00 | 59 | 14 | 619 | 968 | 0.639462809917355 | 0.262955743976548 | 0.262955743976548 | true | false | false | true | ||||||||||||||||
| b3193b2e-2112-482e-bf52-2697aa0f9d6a | 2026-09-22 10:59 | 2026-09-22 10:59 | 2026-09-22 10:59 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 2.5800 | 2.4000 | 2.5800 | 496.6399 | 19866.00 | 19866.00 | 0.00 | 77 | 10 | 457 | 968 | 0.472107438016529 | 0.262041550374446 | 0.262041550374446 | false | false | false | true | ||||||||||||||||
| bc066ad2-ab2d-47da-9243-9dc70d302da9 | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 4.0500 | 4.0000 | 4.3000 | 501.0000 | 10125.00 | 8100.00 | 1620.00 | 25 | 6 | 2069 | 462 | 4.47835497835498 | 0.261592719138289 | 0.261543987719896 | false | false | false | true | ||||||||||||||||
| 6ba98162-0f97-4fca-86c7-071580ae8176 | 2026-09-21 12:58 | 2026-09-21 12:58 | 2026-09-21 12:58 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 2.6400 | 2.6200 | 2.6400 | 496.6800 | 15840.00 | 15840.00 | 0.00 | 60 | 10 | 1419 | 462 | 3.07142857142857 | 0.251416352897042 | 0.251416352897042 | true | false | false | true | ||||||||||||||||
| 82e49508-4e0f-4a5e-879a-2cfd379ef8bf | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | MSFT | MSFT261002C00515000 | call | 515.0000 | 2026-10-02 | 1.8400 | 1.7000 | 1.8400 | 493.1200 | 15271.00 | 15088.00 | 183.00 | 83 | 8 | 702 | 462 | 1.51948051948052 | 0.246809496855412 | 0.245952440927687 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:17:27.635758Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:29:05.852425Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:42:20.042631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |