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 |
|---|
| 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 |
|---|
| a35f62ff-da1a-4eb1-ace9-f46e7fc0ad41 | 2026-09-22 10:16 | 2026-09-22 10:15 | 2026-09-22 10:15 | DASH | DASH261120C00180000 | call | 180.0000 | 2026-11-20 | 26.7500 | 26.7000 | 28.0500 | 197.8700 | 3209725.00 | 214000.00 | 2899425.00 | 1200 | 31 | 2881 | 96 | 30.0104166666667 | 0.513113633095498 | 0.510392831018187 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 78612528577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 1bddeb94-bdd5-462f-b314-8a947a614cbd | 2026-09-22 10:05 | 2026-09-22 10:05 | 2026-09-22 10:05 | DASH | DASH261120C00180000 | call | 180.0000 | 2026-11-20 | 28.0300 | 27.1500 | 29.2000 | 199.2200 | 602650.00 | 182105.00 | 398105.00 | 215 | 51 | 758 | 96 | 7.89583333333333 | 0.519851411575162 | 0.510947421176305 | true | false | false | |||||||||||||||||
| db9e4b38-065d-4ce6-a10a-07b4b4ec3e45 | 2026-09-21 13:45 | 2026-09-21 13:45 | 2026-09-21 13:45 | DASH | DASH260925C00202500 | call | 202.5000 | 2026-09-25 | 1.3000 | 1.0200 | 1.3900 | 194.0000 | 18817.00 | 13462.00 | 5355.00 | 145 | 29 | 161 | 47 | 3.42553191489362 | 0.493699326402778 | 0.467764764471032 | true | false | false | |||||||||||||||||
| 835c72c4-79ca-43ae-bee9-b5642725bcae | 2026-09-18 11:28 | 2026-09-18 11:28 | 2026-09-18 11:28 | DASH | DASH261218P00200000 | put | 200.0000 | 2026-12-18 | 20.6400 | 19.8500 | 21.4000 | 193.6800 | 1442926.00 | 664930.00 | 777996.00 | 699 | 146 | 699 | 619 | 1.12924071082391 | 0.469840252680336 | 0.470615062522607 | true | false | false | |||||||||||||||||
| 39394e79-2afa-45fb-ac46-114c138581c4 | 2026-09-18 11:25 | 2026-09-18 11:25 | 2026-09-18 11:25 | DASH | DASH261218P00150000 | put | 150.0000 | 2026-12-18 | 3.5600 | 2.8200 | 3.7500 | 193.2800 | 177020.00 | 150845.00 | 26175.00 | 497 | 122 | 497 | 1174 | 0.423339011925043 | 0.532756720560675 | 0.523594401750565 | true | false | false | |||||||||||||||||
| 57128c12-74f3-498d-9cb5-27fadb69079d | 2026-09-08 11:58 | 2026-09-08 11:58 | 2026-09-08 11:58 | DASH | DASH280121P00165000 | put | 165.0000 | 2028-01-21 | 21.9800 | 21.8500 | 22.9500 | 200.9450 | 255005.00 | 4420.00 | 241825.00 | 116 | 11 | 133 | 7 | 19 | 0.491259479762189 | 0.487815178819505 | false | false | false | |||||||||||||||||
| 836f52d2-61ce-4edc-8d4f-92c4043bcfe9 | 2026-09-04 12:34 | 2026-09-04 12:34 | 2026-09-04 12:34 | DASH | DASH280121C00195000 | call | 195.0000 | 2028-01-21 | 62.8500 | 62.0500 | 64.1000 | 214.8950 | 62854.00 | 0.00 | 62854.00 | 10 | 5 | 152 | 26 | 5.84615384615385 | 0.495466366876237 | 0.495466366876237 | false | false | false | |||||||||||||||||
| 1d413dd1-43bc-45d8-b33d-a9cb24509336 | 2026-09-04 10:42 | 2026-09-04 10:42 | 2026-09-04 10:42 | DASH | DASH261016P00230000 | put | 230.0000 | 2026-10-16 | 19.7700 | 19.2000 | 20.8500 | 215.2900 | 114655.00 | 57090.00 | 57565.00 | 58 | 16 | 63 | 215 | 0.293023255813953 | 0.391906885909688 | 0.384464714773171 | true | false | false | |||||||||||||||||
| f6b5a06b-6b79-458c-89df-576994e39f38 | 2026-08-28 11:25 | 2026-08-28 11:25 | 2026-08-28 11:25 | DASH | DASH260918C00240000 | call | 240.0000 | 2026-09-18 | 7.2500 | 6.6500 | 7.2500 | 237.8300 | 345088.00 | 345088.00 | 0.00 | 476 | 40 | 490 | 1201 | 0.407993338884263 | 0.35240793373698 | 0.35240793373698 | false | false | false | |||||||||||||||||
| 5da309cd-f3f9-4035-a7ac-8a7ddb3007d2 | 2026-08-26 12:55 | 2026-08-26 12:54 | 2026-08-26 12:54 | DASH | DASH261218P00230000 | put | 230.0000 | 2026-12-18 | 18.5100 | 17.6500 | 18.6500 | 235.3650 | 70326.00 | 46261.00 | 5565.00 | 38 | 10 | 109 | 63 | 1.73015873015873 | 0.435221620267869 | 0.433839482965558 | false | false | false | |||||||||||||||||
| d7a9908f-cec6-44b1-a74a-441bbc9d4b21 | 2026-08-26 11:35 | 2026-08-26 11:34 | 2026-08-26 11:34 | DASH | DASH270115C00260000 | call | 260.0000 | 2027-01-15 | 16.7600 | 16.7500 | 17.7500 | 236.0000 | 120670.00 | 0.00 | 120670.00 | 72 | 7 | 74 | 483 | 0.153209109730849 | 0.424449509947399 | 0.418393686323715 | true | false | false | |||||||||||||||||
| 06f22da0-cbc1-4b82-a84a-0c117e582700 | 2026-08-26 11:19 | 2026-08-26 11:19 | 2026-08-26 11:19 | DASH | DASH260904P00235000 | put | 235.0000 | 2026-09-04 | 5.4000 | 4.9500 | 5.4000 | 235.5500 | 209482.00 | 209482.00 | 0.00 | 388 | 40 | 401 | 603 | 0.665008291873963 | 0.392178012211542 | 0.392178012211542 | false | false | false | |||||||||||||||||
| 4092a5b4-aec8-476a-860d-6f0aa7ad240f | 2026-08-25 11:34 | 2026-08-25 11:34 | 2026-08-25 11:34 | DASH | DASH260904P00235000 | put | 235.0000 | 2026-09-04 | 7.0400 | 6.9500 | 7.6000 | 232.8200 | 95765.00 | 37525.00 | 54740.00 | 136 | 31 | 649 | 10 | 64.9 | 0.382731523894843 | 0.387568198997265 | true | false | false | |||||||||||||||||
| 24f6dd83-cd05-4d76-8894-38129bf5bb4e | 2026-08-25 09:51 | 2026-08-25 09:51 | 2026-08-25 09:51 | DASH | DASH261218C00240000 | call | 240.0000 | 2026-12-18 | 20.0600 | 19.0000 | 21.4000 | 231.1790 | 80228.00 | 0.00 | 80228.00 | 40 | 5 | 40 | 348 | 0.114942528735632 | 0.437812089598853 | 0.437812089598853 | false | false | false | |||||||||||||||||
| 0ed96219-82de-4dd2-a7b4-26dcf1ea0d8f | 2026-08-24 11:34 | 2026-08-24 11:34 | 2026-08-24 11:34 | DASH | DASH260828P00230000 | put | 230.0000 | 2026-08-28 | 4.6500 | 4.1500 | 4.6500 | 229.2000 | 132048.00 | 132048.00 | 0.00 | 284 | 35 | 792 | 7 | 113.142857142857 | 0.459034941161592 | 0.447392666963349 | false | false | false | |||||||||||||||||
| 4c504ecd-30d3-4951-97c5-2bcf7d4ed3d5 | 2026-08-21 12:25 | 2026-08-21 12:25 | 2026-08-21 12:25 | DASH | DASH270219C00220000 | call | 220.0000 | 2027-02-19 | 32.1600 | 32.1500 | 34.0000 | 223.6700 | 109340.00 | 0.00 | 109340.00 | 34 | 12 | 35 | 19 | 1.84210526315789 | 0.454732786918019 | 0.453908905935437 | true | false | false | |||||||||||||||||
| ea8319e8-1e36-4f4e-99fa-1c16d46d2af2 | 2026-08-20 14:30 | 2026-08-20 14:29 | 2026-08-20 14:29 | DASH | DASH261120C00250000 | call | 250.0000 | 2026-11-20 | 10.5000 | 10.3500 | 11.1000 | 222.7400 | 1684835.00 | 1065.00 | 1683770.00 | 1604 | 6 | 2694 | 2607 | 1.03337169159954 | 0.441463577656547 | 0.441723170998249 | true | false | false | |||||||||||||||||
| 98766407-9fcb-449f-8dec-99af41ffebd3 | 2026-08-20 14:28 | 2026-08-20 14:28 | 2026-08-20 14:28 | DASH | DASH261120C00250000 | call | 250.0000 | 2026-11-20 | 10.7500 | 10.4000 | 11.4500 | 223.1300 | 1049375.00 | 365730.00 | 620515.00 | 976 | 55 | 997 | 2607 | 0.382431914077484 | 0.43929798297562 | 0.439576843730321 | true | false | false | |||||||||||||||||
| 8a380ba1-8b1b-41b5-a40d-1a618533ff52 | 2026-08-19 11:58 | 2026-08-19 11:58 | 2026-08-19 11:58 | DASH | DASH261120C00250000 | call | 250.0000 | 2026-11-20 | 10.2300 | 9.8000 | 11.2000 | 220.1100 | 1485883.00 | 700895.00 | 508568.00 | 1452 | 72 | 1452 | 364 | 3.98901098901099 | 0.44815423137815 | 0.450555232111423 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 78612528577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 79275097102.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 78911093406.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 78911093406.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |