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_alerts425,429 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 | expirydate |
|---|
| 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 |
|---|
| 5e6936c6-80aa-40de-adac-09b7dbe39748 | 2026-09-24 12:56 | 2026-09-24 12:56 | 2026-09-24 12:56 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.9000 | 31.5500 | 31.9500 | 769.0000 | 44660.00 | 35105.00 | 9555.00 | 14 | 9 | 12001 | 19440 | 0.617335390946502 | 0.443604282882967 | 0.444267454327763 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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:59:44.374364Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 2afe170c-2296-4544-8644-ca74b8290ba5 | 2026-09-24 12:59 | 2026-09-24 12:59 | 2026-09-24 12:59 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 33.4000 | 32.9000 | 33.4000 | 772.0000 | 40080.00 | 40080.00 | 0.00 | 12 | 5 | 12064 | 19440 | 0.620576131687243 | 0.446851970584028 | 0.44657769705846 | true | false | false | true | ||||||||||||||||
| 70270890-c766-4758-9364-dd1c017f2e72 | 2026-09-24 13:07 | 2026-09-24 13:07 | 2026-09-24 13:07 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 33.6500 | 33.5500 | 33.6500 | 772.7149 | 37015.00 | 37015.00 | 0.00 | 11 | 8 | 12245 | 19440 | 0.62988683127572 | 0.447516698937948 | 0.447516698937948 | false | false | false | true | ||||||||||||||||
| 4b32eef6-0770-46c6-a222-7914cf2c1c19 | 2026-09-24 13:07 | 2026-09-24 13:07 | 2026-09-24 13:07 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 33.4500 | 33.4500 | 33.7500 | 772.6601 | 76935.00 | 0.00 | 76935.00 | 23 | 6 | 12234 | 19440 | 0.629320987654321 | 0.445247541758137 | 0.445247541758137 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| a5fe93bc-48ea-41e4-ace6-88e74c7e41eb | 2026-09-24 13:30 | 2026-09-24 13:30 | 2026-09-24 13:30 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 33.0500 | 32.5500 | 33.0500 | 771.8700 | 66100.00 | 66100.00 | 0.00 | 20 | 6 | 12666 | 19440 | 0.651543209876543 | 0.443863388871758 | 0.445366866434866 | true | false | false | true | ||||||||||||||||
| e915daef-41ee-4442-bd0d-791b8e342027 | 2026-09-24 13:50 | 2026-09-24 13:50 | 2026-09-24 13:50 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.5000 | 31.5000 | 31.8500 | 770.0000 | 18900.00 | 0.00 | 18900.00 | 6 | 5 | 13366 | 19440 | 0.687551440329218 | 0.437493579651453 | 0.437493579651453 | true | false | false | true | ||||||||||||||||
| 036231e4-5527-4ced-a56f-c9520968a84c | 2026-09-24 14:02 | 2026-09-24 14:01 | 2026-09-24 14:01 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.5000 | 31.3500 | 31.5000 | 769.0000 | 236250.00 | 236250.00 | 0.00 | 75 | 5 | 13503 | 19440 | 0.694598765432099 | 0.43943872329621 | 0.43943872329621 | false | false | false | true | ||||||||||||||||
| 9bb15e98-b259-4ad9-811b-861f13322be9 | 2026-09-24 14:02 | 2026-09-24 14:02 | 2026-09-24 14:02 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.5000 | 31.3500 | 31.7000 | 769.0000 | 207900.00 | 12600.00 | 195300.00 | 66 | 5 | 13882 | 19440 | 0.714094650205761 | 0.438567267610644 | 0.438567267610644 | false | false | false | true | ||||||||||||||||
| 65edc987-d175-425e-8932-053d11f1f6dc | 2026-09-24 14:02 | 2026-09-24 14:02 | 2026-09-24 14:02 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 31.5000 | 31.3500 | 31.5000 | 769.0000 | 34650.00 | 34650.00 | 0.00 | 11 | 7 | 13893 | 19440 | 0.71466049382716 | 0.438030579631189 | 0.438030579631189 | false | false | false | true | ||||||||||||||||
| 6e8d1e27-d2c7-4cf9-87e1-400e5d8719c2 | 2026-09-24 14:42 | 2026-09-24 14:41 | 2026-09-24 14:41 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 35.0000 | 34.8000 | 35.0500 | 776.0800 | 269505.00 | 269505.00 | 0.00 | 77 | 5 | 14811 | 19440 | 0.761882716049383 | 0.441888711719216 | 0.442549129429773 | false | false | false | true | ||||||||||||||||
| 3d928957-ddd0-4391-a87d-d7ddcf34a8f6 | 2026-09-24 14:48 | 2026-09-24 14:48 | 2026-09-24 14:48 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 35.7500 | 35.5500 | 35.7500 | 777.0000 | 103675.00 | 103675.00 | 0.00 | 29 | 7 | 15262 | 19440 | 0.785082304526749 | 0.443940026857562 | 0.443940026857562 | true | false | false | true | ||||||||||||||||
| 323406e3-4e44-4e79-a696-7f90f60044b7 | 2026-09-24 14:53 | 2026-09-24 14:53 | 2026-09-24 14:53 | META | META261016C00775000 | call | 775.0000 | 2026-10-16 | 36.0000 | 35.6000 | 36.0000 | 777.6400 | 82800.00 | 82800.00 | 0.00 | 23 | 11 | 15338 | 19440 | 0.788991769547325 | 0.44377062405325 | 0.443985739446 | true | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:59:44.374364Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:37:15.785672Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T17:55:11.953323Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:05:05.581438Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:05:05.581438Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:05:05.581438Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:42:17.809304Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T18:57:49.526864Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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 |
| 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 |