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 |
|---|
| 656a0366-2fad-43e4-87a2-ed4ee064fc6f | 2026-09-22 13:49 | 2026-09-22 13:49 | 2026-09-22 13:49 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 5.6500 | 5.3000 | 5.7000 | 277.9100 | 377760.00 | 370415.00 | 6780.00 | 669 | 59 | 1789 | 1085 | 1.64884792626728 | 0.860347030946722 | 0.855519236349828 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 81445646989.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 532ed739-ca84-4d98-8c41-bbb18e17d28d | 2026-09-25 10:01 | 2026-09-25 10:01 | 2026-09-25 10:01 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 3.6700 | 3.6000 | 3.8000 | 284.0000 | 37778.00 | 0.00 | 37778.00 | 103 | 5 | 1400 | 1726 | 0.811123986095017 | 1.33080661687064 | 1.37498857923974 | false | false | false | |||||||||||||||||
| 561f674e-6bfa-4a88-8da3-3877900e20c5 | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 2.4800 | 2.4100 | 2.6200 | 282.3900 | 37707.00 | 507.00 | 37200.00 | 152 | 5 | 4390 | 1726 | 2.54345307068366 | 1.30515219703439 | 1.24680552940951 | false | false | false | |||||||||||||||||
| 60feec13-9367-4728-9ac6-8ecc62ef967b | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 2.2800 | 2.0800 | 2.2800 | 281.7600 | 11392.00 | 11392.00 | 0.00 | 50 | 15 | 4661 | 1726 | 2.70046349942063 | 1.28748067424614 | 1.28375063228055 | true | false | false | |||||||||||||||||
| 0c2e091b-3507-45e8-82da-24eebed1ded6 | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 2.1100 | 1.9600 | 2.1600 | 280.9800 | 11376.00 | 10536.00 | 840.00 | 54 | 6 | 4772 | 1726 | 2.76477404403244 | 1.34756623407817 | 1.32457536186914 | false | false | false | |||||||||||||||||
| 7aca9180-3e73-437d-a900-59a50ce03ad9 | 2026-09-25 10:28 | 2026-09-25 10:28 | 2026-09-25 10:28 | BE | BE260925C00285000 | call | 285.0000 | 2026-09-25 | 2.0000 | 1.8000 | 2.2100 | 280.8200 | 41536.00 | 960.00 | 40576.00 | 208 | 6 | 6163 | 1726 | 3.57068366164542 | 1.28888095429438 | 1.28499620077316 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:02:31.622340Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |