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_alerts566,287 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 |
|---|
| 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 |
|---|
| aa3b1229-3f9c-4aa5-b386-df9091a977c2 | 2026-09-21 10:50 | 2026-09-21 10:50 | 2026-09-21 10:50 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 5.0200 | 4.9500 | 5.1000 | 166.6500 | 12060.00 | 6036.00 | 6024.00 | 24 | 6 | 12565 | 4866 | 2.58220304151254 | 0.933525475582704 | 0.929165656263451 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 61432656919.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 73ea6ec7-3d76-46fa-931a-8c884f0bc0d9 | 2026-09-21 10:57 | 2026-09-21 10:57 | 2026-09-21 10:57 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 5.2800 | 5.2500 | 5.3500 | 167.1300 | 15825.00 | 0.00 | 15825.00 | 30 | 6 | 13218 | 4866 | 2.71639950678175 | 0.935818636805173 | 0.931489051509262 | false | false | false | |||||||||||||||||
| 2b9c6089-ac7d-4647-9f0d-f51750bbe7b9 | 2026-09-22 10:01 | 2026-09-22 10:01 | 2026-09-22 10:01 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 5.2400 | 5.2000 | 5.3500 | 169.4900 | 20970.00 | 0.00 | 20970.00 | 40 | 6 | 3620 | 8531 | 0.424334779041144 | 0.877239625454718 | 0.883914324568392 | true | false | false | |||||||||||||||||
| 7bd75c80-8a97-43f5-bf4e-3e8269fa6cba | 2026-09-22 11:42 | 2026-09-22 11:42 | 2026-09-22 11:42 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 5.0800 | 5.0500 | 5.1000 | 169.6600 | 41185.00 | 40678.00 | 507.00 | 81 | 5 | 7862 | 8531 | 0.921580119563943 | 0.852791983466013 | 0.848728546563365 | false | false | false | |||||||||||||||||
| c0f18d74-4349-4770-ae43-6d96f11a9dcb | 2026-09-23 09:55 | 2026-09-23 09:55 | 2026-09-23 09:55 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 2.9600 | 2.9600 | 3.1000 | 166.8200 | 60694.00 | 0.00 | 60694.00 | 205 | 8 | 2858 | 9924 | 0.287988714228134 | 0.869889249162202 | 0.875368530496345 | false | false | false | |||||||||||||||||
| 0d9912f2-2345-4101-8091-af888703d245 | 2026-09-23 12:22 | 2026-09-23 12:21 | 2026-09-23 12:21 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 1.8800 | 1.8400 | 1.8800 | 163.8800 | 13141.00 | 9588.00 | 3553.00 | 70 | 12 | 10803 | 9924 | 1.08857315598549 | 0.861678515932731 | 0.859287418898014 | false | false | false | |||||||||||||||||
| b6723149-f801-454f-bb65-c3bea6af0eb8 | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 1.5100 | 1.3800 | 1.5100 | 163.6010 | 15353.00 | 11627.00 | 276.00 | 102 | 10 | 773 | 12452 | 0.0620783809829746 | 1.11929114896732 | 1.07263729078022 | false | false | false | |||||||||||||||||
| 55500ffd-4fa1-4999-b9a0-234236158f84 | 2026-09-24 14:30 | 2026-09-24 14:30 | 2026-09-24 14:30 | MSTR | MSTR260925C00170000 | call | 170.0000 | 2026-09-25 | 0.8700 | 0.8000 | 0.8800 | 162.6400 | 34273.00 | 34016.00 | 257.00 | 394 | 47 | 15459 | 12452 | 1.2414873112753 | 0.959026447820556 | 0.950513759201247 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:24:45.701241Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:32:33.635262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |