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_alerts658,639 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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| 3fd92b36-1ecf-4110-965b-c84c50789df8 | 2026-09-28 10:39 | 2026-09-28 10:39 | 2026-09-28 10:39 | UMAC | UMAC261120C00050000 | call | 50.0000 | 2026-11-20 | 0.4000 | 0.3000 | 0.4500 | 24.2000 | 16549.00 | 15429.00 | 1120.00 | 414 | 59 | 446 | 427 | 1.04449648711944 | 1.21019687598302 | 1.21019687598302 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1196957860.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T14:39:59.726153Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 63d6df79-c9fe-41fe-a5bc-77c1a46d33c0 | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | UMAC | UMAC261016C00025000 | call | 25.0000 | 2026-10-16 | 1.4500 | 1.3500 | 1.6000 | 23.4300 | 29825.00 | 0.00 | 29545.00 | 206 | 5 | 349 | 2858 | 0.122113365990203 | 0.993491796873946 | 0.96901238590896 | false | false | ||||||||||||||||||
| 673d8187-037c-4024-bbf9-a8ddcb97ad63 | 2026-09-25 15:06 | 2026-09-25 15:06 | 2026-09-25 15:06 | UMAC | UMAC261016C00025000 | call | 25.0000 | 2026-10-16 | 2.2100 | 2.1500 | 2.2500 | 24.0000 | 11067.00 | 11067.00 | 0.00 | 50 | 6 | 1915 | 1074 | 1.78305400372439 | 0.993116528891695 | 0.97615681441216 | false | false | ||||||||||||||||||
| 096484fd-7f2c-41fd-b5c2-4fa53717620c | 2026-09-25 14:15 | 2026-09-25 14:15 | 2026-09-25 14:15 | UMAC | UMAC261016C00025000 | call | 25.0000 | 2026-10-16 | 2.1500 | 2.1500 | 2.2000 | 24.7100 | 29921.00 | 0.00 | 29921.00 | 139 | 17 | 957 | 1074 | 0.891061452513967 | 0.963699024544594 | 0.955217267557205 | false | false | ||||||||||||||||||
| 88d3e037-420d-4427-86f2-0e1c2ac92647 | 2026-09-25 14:12 | 2026-09-25 14:12 | 2026-09-25 14:12 | UMAC | UMAC261016C00025000 | call | 25.0000 | 2026-10-16 | 2.1000 | 2.1000 | 2.1500 | 24.6600 | 12184.00 | 0.00 | 12184.00 | 58 | 9 | 587 | 1074 | 0.546554934823091 | 0.953680402597926 | 0.945187630384722 | false | false | ||||||||||||||||||
| 532af4ce-30ac-4985-8041-c99eb1847e0c | 2026-09-22 10:23 | 2026-09-22 10:23 | 2026-09-22 10:23 | UMAC | UMAC270115C00030000 | call | 30.0000 | 2027-01-15 | 3.2000 | 3.2000 | 3.8000 | 23.6899 | 16004.00 | 0.00 | 16004.00 | 50 | 5 | 54 | 2045 | 0.0264058679706601 | 0.970054607393718 | 0.966248352908043 | false | false | ||||||||||||||||||
| 37acc6ad-d186-484f-8ac1-4e0fdc94f124 | 2026-09-18 13:58 | 2026-09-18 13:57 | 2026-09-18 13:57 | UMAC | UMAC261016C00030000 | call | 30.0000 | 2026-10-16 | 0.7000 | 0.6000 | 0.7000 | 23.0300 | 52468.00 | 52468.00 | 0.00 | 750 | 50 | 973 | 2263 | 0.429960229783473 | 1.01646375236754 | 1.01646375236754 | false | false | ||||||||||||||||||
| 801bb11d-b8d0-46e1-883d-09540c27dbf6 | 2026-09-09 11:06 | 2026-09-09 11:06 | 2026-09-09 11:06 | UMAC | UMAC260918P00025000 | put | 25.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.9000 | 24.9150 | 27237.00 | 0.00 | 27237.00 | 165 | 6 | 366 | 1624 | 0.225369458128079 | 1.05003436593742 | 1.0371916834453 | false | false | ||||||||||||||||||
| 34b097a1-2e94-4385-834f-ea8c66f28421 | 2026-09-02 13:01 | 2026-09-02 13:01 | 2026-09-02 13:01 | UMAC | UMAC260918C00023500 | call | 23.5000 | 2026-09-18 | 1.6000 | 1.6000 | 1.7500 | 22.8350 | 23850.00 | 0.00 | 23850.00 | 149 | 10 | 175 | 44 | 3.97727272727273 | 0.987823173389006 | 0.982578193799012 | false | false | ||||||||||||||||||
| ff5f003c-127a-498c-ba96-533791295047 | 2026-08-28 15:21 | 2026-08-28 15:21 | 2026-08-28 15:21 | UMAC | UMAC261016C00022500 | call | 22.5000 | 2026-10-16 | 4.3900 | 4.2000 | 4.4000 | 23.8100 | 10542.00 | 10542.00 | 0.00 | 24 | 5 | 71 | 69 | 1.02898550724638 | 1.08660406436584 | 1.05907693505274 | false | false | ||||||||||||||||||
| f4836f30-5027-4a01-a90a-c957b5a69ac1 | 2026-08-28 12:53 | 2026-08-28 12:52 | 2026-08-28 12:52 | UMAC | UMAC280121C00020000 | call | 20.0000 | 2028-01-21 | 12.5600 | 12.0000 | 13.0000 | 23.2250 | 15076.00 | 15076.00 | 0.00 | 12 | 10 | 22 | 610 | 0.0360655737704918 | 1.11180995342053 | 1.11180995342053 | false | false | ||||||||||||||||||
| b568b163-42ca-492b-895f-2617f13a21e3 | 2026-08-26 14:18 | 2026-08-26 14:17 | 2026-08-26 14:17 | UMAC | UMAC270115P00025000 | put | 25.0000 | 2027-01-15 | 6.9900 | 6.8000 | 7.1000 | 23.7250 | 157352.00 | 104852.00 | 52500.00 | 225 | 5 | 252 | 603 | 0.417910447761194 | 1.10875793172377 | 1.1062440539395 | false | false | ||||||||||||||||||
| 46e583ea-b60b-4056-942a-a63437287e77 | 2026-08-18 10:01 | 2026-08-18 10:01 | 2026-08-18 10:01 | UMAC | UMAC260828P00037000 | put | 37.0000 | 2026-08-28 | 5.6000 | 5.2000 | 5.6000 | 33.0000 | 179187.00 | 179187.00 | 0.00 | 320 | 46 | 320 | 0 | 0 | 1.40792357893013 | 1.40792357893013 | false | false | ||||||||||||||||||
| 6f546b2b-4ff8-456a-81df-c1036ec70877 | 2026-08-17 11:07 | 2026-08-17 11:07 | 2026-08-17 11:07 | UMAC | UMAC261120C00050000 | call | 50.0000 | 2026-11-20 | 3.9100 | 3.8000 | 4.9000 | 31.5505 | 26560.00 | 0.00 | 26560.00 | 68 | 8 | 68 | 0 | 0 | 1.33909515822401 | 1.32268421201032 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1196957860.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1201453945.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1201453945.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1201453945.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:18:37.657539Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1200454815.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1157991786.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1132014403.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |