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 |
|---|
| f0a627dd-ea8c-4c7d-af7d-a86a3c071102 | 2026-09-24 10:52 | 2026-09-24 10:52 | 2026-09-24 10:52 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 14.0000 | 13.8500 | 14.0000 | 769.0000 | 33600.00 | 33600.00 | 0.00 | 24 | 11 | 14893 | 6137 | 2.42675574384879 | 0.742569304280944 | 0.739736784468629 | false | false | false | true | false | 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-24T14:53:28.868411Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| c3e20e39-69a0-43aa-8fed-e2151a1a5d30 | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 14.5300 | 14.0000 | 14.9000 | 769.3700 | 31960.00 | 10140.00 | 21820.00 | 22 | 9 | 15258 | 6137 | 2.48623105751996 | 0.740820330800799 | 0.748640895288434 | true | false | false | true | ||||||||||||||||
| fc22d792-3ada-4168-97ff-48dc459589bd | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 13.8400 | 13.8000 | 14.2500 | 768.8850 | 63682.00 | 0.00 | 55282.00 | 46 | 12 | 15325 | 6137 | 2.49714844386508 | 0.73404962427289 | 0.73246271933976 | true | false | false | true | ||||||||||||||||
| 9ab5da93-c02b-4373-8722-8c2e96adacae | 2026-09-24 10:57 | 2026-09-24 10:57 | 2026-09-24 10:57 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 14.4000 | 14.2500 | 14.7000 | 769.5000 | 53280.00 | 1440.00 | 51840.00 | 37 | 7 | 15478 | 6137 | 2.52207919178752 | 0.747139542148039 | 0.747139542148039 | true | false | false | true | ||||||||||||||||
| 352c77ca-3ae4-47f2-a797-80fb29c65d61 | 2026-09-24 10:58 | 2026-09-24 10:58 | 2026-09-24 10:58 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 15.0000 | 14.8000 | 15.0000 | 770.3800 | 18000.00 | 18000.00 | 0.00 | 12 | 11 | 15554 | 6137 | 2.53446309271631 | 0.753149769606222 | 0.753149769606222 | false | false | false | true | ||||||||||||||||
| cdab84a5-1419-4d19-8c99-d5b83b82c108 | 2026-09-24 11:01 | 2026-09-24 11:00 | 2026-09-24 11:00 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 13.7000 | 13.7000 | 14.0500 | 768.5000 | 83573.00 | 0.00 | 83573.00 | 61 | 13 | 15889 | 6137 | 2.58905002444191 | 0.730373492587748 | 0.7384471984952 | true | false | false | true | ||||||||||||||||
| fd12ddd3-9aa3-4a26-b758-5a41519a1e6a | 2026-09-24 11:09 | 2026-09-24 11:09 | 2026-09-24 11:09 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 10.9800 | 10.8000 | 11.3500 | 763.0000 | 12080.00 | 6600.00 | 5480.00 | 11 | 9 | 16342 | 6137 | 2.66286459182011 | 0.711250354412707 | 0.70841301744756 | false | false | false | true | ||||||||||||||||
| 1a067a4e-4c77-4d26-b694-cec673f49ece | 2026-09-24 11:11 | 2026-09-24 11:11 | 2026-09-24 11:11 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 11.7800 | 11.2500 | 11.8000 | 765.0000 | 15320.00 | 15320.00 | 0.00 | 13 | 10 | 16512 | 6137 | 2.69056542284504 | 0.731917885558202 | 0.731917885558202 | true | false | false | true | ||||||||||||||||
| d85d7f2e-1c4d-4537-8ac1-f42addee5aab | 2026-09-24 11:15 | 2026-09-24 11:15 | 2026-09-24 11:15 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 11.8300 | 11.8000 | 12.1500 | 766.0600 | 27210.00 | 3600.00 | 23610.00 | 23 | 7 | 16832 | 6137 | 2.74270816359785 | 0.722872691083228 | 0.701896668891452 | false | false | false | true | ||||||||||||||||
| 7252fb83-7dc2-4ee4-8954-4668c56c9307 | 2026-09-24 11:17 | 2026-09-24 11:17 | 2026-09-24 11:17 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 12.0000 | 12.0000 | 12.2500 | 766.3850 | 20400.00 | 0.00 | 20400.00 | 17 | 5 | 17169 | 6137 | 2.79762098745315 | 0.703719773457612 | 0.703719773457612 | true | false | false | true | ||||||||||||||||
| 98999480-ccbc-45fb-910d-f3d76d61cd96 | 2026-09-24 11:34 | 2026-09-24 11:34 | 2026-09-24 11:34 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 12.0000 | 11.7500 | 12.0000 | 766.0000 | 123585.00 | 123585.00 | 0.00 | 103 | 5 | 18215 | 6137 | 2.9680625712889 | 0.712452868211795 | 0.709321646120712 | false | false | false | true | ||||||||||||||||
| 31449361-70b8-45c9-a679-f9ea54749e9b | 2026-09-24 11:36 | 2026-09-24 11:36 | 2026-09-24 11:36 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 12.6500 | 12.3500 | 12.6500 | 767.0000 | 20240.00 | 20240.00 | 0.00 | 16 | 7 | 18389 | 6137 | 2.99641518657324 | 0.713644873967094 | 0.713644873967094 | true | false | false | true | ||||||||||||||||
| bc13b536-f2b9-4ce4-a19b-3e24353d0f42 | 2026-09-24 11:45 | 2026-09-24 11:45 | 2026-09-24 11:45 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 12.7500 | 12.6500 | 12.8000 | 768.2000 | 131330.00 | 131330.00 | 0.00 | 103 | 8 | 18911 | 6137 | 3.08147303242627 | 0.689144720367678 | 0.69229088577304 | true | false | false | true | ||||||||||||||||
| a26e6e19-faa6-45ca-8fb0-47f9dbcd24fd | 2026-09-24 11:45 | 2026-09-24 11:45 | 2026-09-24 11:45 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 13.0000 | 12.7000 | 13.0500 | 768.1550 | 29898.00 | 29898.00 | 0.00 | 23 | 7 | 18934 | 6137 | 3.08522079191788 | 0.706439353823463 | 0.706439353823463 | false | false | false | true | ||||||||||||||||
| 37a40a58-1862-4f8a-842d-0e8f383ed2ec | 2026-09-24 12:09 | 2026-09-24 12:09 | 2026-09-24 12:09 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 10.4000 | 10.3000 | 10.4000 | 763.0000 | 52000.00 | 52000.00 | 0.00 | 50 | 10 | 19811 | 6137 | 3.22812449079355 | 0.69201823745157 | 0.69201823745157 | true | false | false | true | ||||||||||||||||
| ebad5dc7-5ee4-4884-ae9e-39d636be0a16 | 2026-09-24 12:13 | 2026-09-24 12:13 | 2026-09-24 12:13 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 9.0000 | 9.0000 | 9.1500 | 760.0000 | 94500.00 | 0.00 | 94500.00 | 105 | 6 | 20149 | 6137 | 3.2832002607137 | 0.679872153134855 | 0.684793725529974 | false | false | false | true | ||||||||||||||||
| b987c3e0-ebba-4a60-92f3-49e3facb4121 | 2026-09-24 12:48 | 2026-09-24 12:48 | 2026-09-24 12:48 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 13.1500 | 12.9000 | 13.4500 | 769.4300 | 562820.00 | 2630.00 | 560190.00 | 428 | 51 | 23002 | 6137 | 3.74808538373798 | 0.6587463692973 | 0.667454794450469 | false | false | false | true | ||||||||||||||||
| 0efb2e9a-939d-49b5-97fe-7202a1438e8b | 2026-09-24 13:05 | 2026-09-24 13:05 | 2026-09-24 13:05 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 15.4400 | 15.0000 | 15.4500 | 772.8000 | 92645.00 | 75705.00 | 16940.00 | 60 | 7 | 23626 | 6137 | 3.84976372820596 | 0.689185105219101 | 0.689185105219101 | false | false | false | true | ||||||||||||||||
| def9895a-6f09-4902-a6fb-b3936a131cb9 | 2026-09-24 13:06 | 2026-09-24 13:06 | 2026-09-24 13:06 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 15.6400 | 15.0500 | 15.6500 | 773.2100 | 62570.00 | 62570.00 | 0.00 | 40 | 9 | 23675 | 6137 | 3.85774808538374 | 0.685612241771813 | 0.675832353307785 | false | false | false | true | ||||||||||||||||
| 7c494e18-22cd-45cd-abe3-b3fb7f74ed4c | 2026-09-24 13:32 | 2026-09-24 13:32 | 2026-09-24 13:32 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 13.8700 | 13.6500 | 14.1500 | 771.3250 | 20800.00 | 0.00 | 20800.00 | 15 | 5 | 23821 | 6137 | 3.88153821085221 | 0.645410032557089 | 0.645410032557089 | false | false | false | true | ||||||||||||||||
| a296c63c-417f-46a5-836e-14da8203150b | 2026-09-24 13:52 | 2026-09-24 13:52 | 2026-09-24 13:52 | META | META260925C00765000 | call | 765.0000 | 2026-09-25 | 12.5900 | 12.2500 | 12.6000 | 769.0000 | 12595.00 | 12595.00 | 0.00 | 10 | 6 | 23971 | 6137 | 3.90598012058009 | 0.627928168966955 | 0.622506007252811 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:56:01.849843Z"} |
| 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-24T14:58:33.796895Z"} |
| 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-24T14:58:33.796895Z"} |
| 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-24T15:01:26.561696Z"} |
| 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-24T15:12:31.706500Z"} |
| 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-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T15:16:59.605616Z"} |
| 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-24T15:21:44.336640Z"} |
| 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-24T15:39:15.853086Z"} |
| 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-24T15:39:15.853086Z"} |
| 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-24T15:50:02.461499Z"} |
| 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-24T15:50:02.461499Z"} |
| 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-24T16:13:55.044964Z"} |
| 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-24T16:13:55.044964Z"} |
| 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-24T16:51:44.270939Z"} |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |