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 | 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 |
|---|
| b0d876cd-9ad2-4ecd-b76e-04c95c107ef4 | 2026-09-25 10:29 | 2026-09-25 10:29 | 2026-09-25 10:29 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 20.3200 | 20.3000 | 20.6500 | 752.8400 | 46730.00 | 4085.00 | 42645.00 | 23 | 11 | 261 | 20701 | 0.0126080865658664 | 0.403466687774698 | 0.403129449521339 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1657506895075.00 | 2026-11-04 | 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 |
| 38029ddd-ded8-4817-8277-aa3226ab0910 | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 22.6800 | 22.3500 | 22.7000 | 756.0050 | 83900.00 | 83900.00 | 0.00 | 37 | 8 | 109 | 20701 | 0.00526544611371431 | 0.416869574327019 | 0.417540558252657 | true | false | false | |||||||||||||||||
| e6cb8112-7a33-4a84-8d21-835e96931765 | 2026-09-24 15:25 | 2026-09-24 15:25 | 2026-09-24 15:25 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 36.7700 | 36.7000 | 37.0000 | 779.2250 | 73535.00 | 7370.00 | 66165.00 | 20 | 7 | 15891 | 19440 | 0.817438271604938 | 0.441788215439987 | 0.443769412706004 | false | false | false | |||||||||||||||||
| 329e44a6-f235-47d3-b3de-e6352e6778d9 | 2026-09-24 15:05 | 2026-09-24 15:05 | 2026-09-24 15:05 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 35.3000 | 35.2500 | 35.5500 | 776.5105 | 63540.00 | 7080.00 | 56460.00 | 18 | 6 | 15537 | 19440 | 0.799228395061728 | 0.442139718929424 | 0.444120808051718 | false | false | false | |||||||||||||||||
| 54341771-1474-4676-852b-235029e26e83 | 2026-09-24 13:21 | 2026-09-24 13:21 | 2026-09-24 13:21 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 32.9100 | 32.8500 | 33.1000 | 771.7515 | 210640.00 | 3295.00 | 164510.00 | 64 | 13 | 12544 | 19440 | 0.645267489711934 | 0.444189776577453 | 0.444189776577453 | true | false | false | |||||||||||||||||
| 2d9a671a-baf8-41be-995c-c21f0c5bd13f | 2026-09-24 12:22 | 2026-09-24 12:22 | 2026-09-24 12:22 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.7900 | 31.1000 | 31.9500 | 769.6600 | 680205.00 | 677030.00 | 3175.00 | 214 | 8 | 5603 | 19440 | 0.288220164609053 | 0.446870741266279 | 0.44574368487636 | true | false | false | |||||||||||||||||
| 66d047c7-68d9-492d-b5b0-f66ae044df49 | 2026-09-24 12:18 | 2026-09-24 12:18 | 2026-09-24 12:18 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.1500 | 30.6500 | 31.9000 | 768.0000 | 445435.00 | 436030.00 | 9405.00 | 143 | 7 | 3302 | 19440 | 0.169855967078189 | 0.444511026808151 | 0.445518684335385 | false | false | false | |||||||||||||||||
| 331a41d3-843a-477b-8601-b78cdeecbde6 | 2026-09-24 12:18 | 2026-09-24 12:18 | 2026-09-24 12:18 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.1200 | 31.0500 | 31.2000 | 768.0000 | 15560.00 | 6230.00 | 9330.00 | 5 | 5 | 2944 | 19440 | 0.151440329218107 | 0.443987525591779 | 0.444652043939073 | false | false | false | |||||||||||||||||
| 3c0658d5-6454-44f1-9c94-6a36dec6c8b0 | 2026-09-24 12:17 | 2026-09-24 12:17 | 2026-09-24 12:17 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 30.9800 | 30.7500 | 31.0500 | 767.9300 | 303605.00 | 303605.00 | 0.00 | 98 | 10 | 2160 | 19440 | 0.111111111111111 | 0.443978424020174 | 0.444643215390969 | false | false | false | |||||||||||||||||
| e84f3569-e694-4e32-9a63-6fed91e769c5 | 2026-09-24 10:21 | 2026-09-24 10:21 | 2026-09-24 10:21 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.1700 | 30.7500 | 31.6000 | 765.9850 | 37398.00 | 6236.00 | 31162.00 | 12 | 6 | 750 | 19440 | 0.0385802469135802 | 0.459548541285801 | 0.459548541285801 | false | false | false | |||||||||||||||||
| 0478d5fa-dbc0-4144-b46e-29a3181bdd4e | 2026-09-24 09:53 | 2026-09-24 09:53 | 2026-09-24 09:53 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 26.3500 | 26.2000 | 26.9000 | 756.2300 | 79060.00 | 2640.00 | 76420.00 | 30 | 7 | 616 | 19440 | 0.0316872427983539 | 0.456090041078805 | 0.456090041078805 | true | false | false | |||||||||||||||||
| 01e32985-16fb-4da7-b55d-f2e7ca09d5e2 | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 28.4500 | 28.4500 | 28.7500 | 756.9550 | 79670.00 | 2850.00 | 76820.00 | 28 | 8 | 698 | 19445 | 0.0358961172537927 | 0.469292958662411 | 0.469957286821862 | true | false | false | |||||||||||||||||
| 73ba43f2-e784-46c7-8594-7a73021c618e | 2026-09-23 10:15 | 2026-09-23 10:15 | 2026-09-23 10:15 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 23.1900 | 22.8500 | 23.2500 | 745.1300 | 85820.00 | 78870.00 | 6950.00 | 37 | 10 | 272 | 19445 | 0.013988171766521 | 0.465671490386005 | 0.46636388480491 | true | false | false | |||||||||||||||||
| 9f03fa3e-d414-4f2a-81fd-6a4dc8e8309e | 2026-09-23 10:06 | 2026-09-23 10:06 | 2026-09-23 10:06 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 26.8800 | 26.5500 | 26.9500 | 752.0000 | 37635.00 | 21515.00 | 16120.00 | 14 | 7 | 219 | 19445 | 0.0112625353561327 | 0.46805913673921 | 0.472153237442053 | true | false | false | |||||||||||||||||
| 488df1dc-c2bc-408c-9afc-5558df855941 | 2026-09-22 10:09 | 2026-09-22 10:09 | 2026-09-22 10:09 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 22.5400 | 22.2000 | 22.6000 | 746.7700 | 31554.00 | 20279.00 | 11275.00 | 14 | 5 | 134 | 19266 | 0.00695525796740372 | 0.436895795934105 | 0.438490640837049 | false | false | false | |||||||||||||||||
| d7cf9762-7d24-4cc6-a1f5-225d97cd9e77 | 2026-09-21 13:39 | 2026-09-21 13:39 | 2026-09-21 13:39 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 22.2300 | 22.1000 | 22.3500 | 740.0000 | 31126.00 | 31126.00 | 0.00 | 14 | 5 | 15520 | 5005 | 3.1008991008991 | 0.459661021140215 | 0.459661021140215 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:07:42.806014Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:26:09.725902Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:24:07.570312Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:19:14.224158Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:19:14.224158Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:18:11.979462Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:21:25.715883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:07:47.966434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |