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 | expiry |
|---|
| 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 |
|---|
| a307af24-cd59-4657-914d-583f8aa20deb | 2026-09-29 13:28 | 2026-09-29 13:28 | 2026-09-29 13:28 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 6.9500 | 6.8500 | 6.9500 | 128.5800 | 225180.00 | 225180.00 | 0.00 | 324 | 7 | 1241 | 4641 | 0.267399267399267 | 0.570590173497398 | 0.570590173497398 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 134357960000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:35:56.522795Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 8650809b-88c7-440f-8cba-0fef682220d8 | 2026-09-29 12:07 | 2026-09-29 12:07 | 2026-09-29 12:07 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 8.0000 | 8.0000 | 8.2000 | 131.0000 | 458610.00 | 32200.00 | 426410.00 | 573 | 26 | 881 | 4641 | 0.189829778065072 | 0.570121162473422 | 0.570121162473422 | false | false | false | true | ||||||||||||||||
| 3fd2ee2b-34b5-4182-84b8-5464cb3d107a | 2026-09-29 12:02 | 2026-09-29 12:02 | 2026-09-29 12:02 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 8.1000 | 8.1000 | 8.3500 | 131.0000 | 127170.00 | 0.00 | 127170.00 | 157 | 26 | 308 | 4641 | 0.0663650075414781 | 0.576569943503401 | 0.576569943503401 | false | false | false | true | ||||||||||||||||
| 1513e966-e9fa-4803-b978-b97096356e13 | 2026-09-29 09:30 | 2026-09-29 09:30 | 2026-09-29 09:30 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 8.2000 | 7.7500 | 8.2000 | 130.7000 | 22127.00 | 21312.00 | 815.00 | 27 | 6 | 27 | 4641 | 0.00581771170006464 | 0.589987814258091 | 0.589987814258091 | false | false | false | true | ||||||||||||||||
| 99684ed4-f87a-4222-b5ec-0b23bd62ee6c | 2026-09-28 10:00 | 2026-09-28 10:00 | 2026-09-28 10:00 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 8.2500 | 8.1000 | 8.2500 | 130.6750 | 58575.00 | 50325.00 | 0.00 | 71 | 6 | 318 | 3339 | 0.0952380952380952 | 0.587217004814638 | 0.587217004814638 | false | false | false | true | ||||||||||||||||
| 8c3ece27-21ce-4149-a28a-eecb97709795 | 2026-09-28 09:36 | 2026-09-28 09:35 | 2026-09-28 09:35 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 6.9500 | 6.7500 | 6.9500 | 126.8800 | 16672.00 | 16672.00 | 0.00 | 24 | 8 | 142 | 3339 | 0.0425277029050614 | 0.600539160845766 | 0.600539160845766 | true | false | false | true | ||||||||||||||||
| 6445c31b-0304-4287-86b2-8d3adf309244 | 2026-09-28 09:35 | 2026-09-28 09:35 | 2026-09-28 09:35 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 7.0000 | 6.8500 | 7.0000 | 127.1300 | 23100.00 | 12600.00 | 0.00 | 33 | 7 | 101 | 3339 | 0.0302485774183887 | 0.59800948054982 | 0.59800948054982 | false | false | false | true | ||||||||||||||||
| ca7fe391-e6f7-452f-8d11-aa402d60b099 | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 14.5000 | 14.5000 | 14.5500 | 141.3902 | 29000.00 | 0.00 | 5800.00 | 20 | 6 | 181 | 3087 | 0.0586329770003239 | 0.598668385860552 | 0.598668385860552 | false | false | false | true | ||||||||||||||||
| 342b43de-0242-4835-8503-59fbf4b60e19 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 13.5500 | 13.1000 | 13.5500 | 139.0000 | 10840.00 | 10840.00 | 0.00 | 8 | 6 | 148 | 3087 | 0.0479429867184969 | 0.597733205436546 | 0.597733205436546 | true | false | false | true | ||||||||||||||||
| 7c3d2c8d-857c-4223-90ec-9b908fc04cce | 2026-09-22 15:31 | 2026-09-22 15:31 | 2026-09-22 15:31 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 12.7000 | 12.5500 | 12.7000 | 138.0000 | 12700.00 | 5080.00 | 0.00 | 10 | 5 | 598 | 2938 | 0.20353982300885 | 0.591751660191977 | 0.591751660191977 | false | false | false | true | ||||||||||||||||
| 0f871a56-6093-484c-b311-73e28590e2f1 | 2026-09-22 12:50 | 2026-09-22 12:50 | 2026-09-22 12:50 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.8500 | 11.5500 | 11.8500 | 136.6850 | 23700.00 | 4740.00 | 0.00 | 20 | 6 | 427 | 2938 | 0.145336963921035 | 0.589683917569816 | 0.589683917569816 | false | false | false | true | ||||||||||||||||
| 4d5f5214-0f1b-4b24-a2eb-6c65918641e7 | 2026-09-22 12:36 | 2026-09-22 12:36 | 2026-09-22 12:36 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.5500 | 11.3500 | 11.5500 | 136.1799 | 23100.00 | 23100.00 | 0.00 | 20 | 5 | 402 | 2938 | 0.136827773995916 | 0.58785768885731 | 0.58785768885731 | false | false | false | true | ||||||||||||||||
| 0a5436d5-e964-44a8-8705-dddf72c460cd | 2026-09-22 10:40 | 2026-09-22 10:40 | 2026-09-22 10:40 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.3000 | 11.3000 | 11.4000 | 135.6650 | 16950.00 | 0.00 | 16950.00 | 15 | 5 | 250 | 2938 | 0.0850918992511913 | 0.588399760932758 | 0.588399760932758 | false | false | false | true | ||||||||||||||||
| eb1e4a58-3b49-4c56-ae79-95d0bfa52639 | 2026-09-22 10:39 | 2026-09-22 10:39 | 2026-09-22 10:39 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.3600 | 11.3000 | 11.4000 | 135.7600 | 30680.00 | 5690.00 | 24990.00 | 27 | 6 | 234 | 2938 | 0.079646017699115 | 0.588948094170173 | 0.588488793529568 | false | false | false | true | ||||||||||||||||
| 3aba9efd-8721-4290-b273-7bfd0d0b41c7 | 2026-09-22 10:36 | 2026-09-22 10:36 | 2026-09-22 10:36 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.3500 | 11.2000 | 11.4500 | 135.7697 | 11350.00 | 1135.00 | 4540.00 | 10 | 10 | 205 | 2938 | 0.0697753573859769 | 0.588263118994432 | 0.588263118994432 | false | false | false | true | ||||||||||||||||
| 9881fe19-2ba7-436e-896d-fb688060ece6 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 12.3500 | 12.2500 | 12.5500 | 137.7900 | 27170.00 | 6175.00 | 20995.00 | 22 | 10 | 194 | 2862 | 0.0677847658979734 | 0.580840926636507 | 0.580840926636507 | false | false | false | true | ||||||||||||||||
| 5511f5a0-a4cb-41cf-9e1a-2952c8a0f625 | 2026-08-28 11:13 | 2026-08-28 11:13 | 2026-08-28 11:13 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 18.7000 | 18.7000 | 18.8000 | 144.6800 | 187000.00 | 0.00 | 187000.00 | 100 | 5 | 258 | 2575 | 0.100194174757282 | 0.575792418893476 | 0.575792418893476 | false | false | false | true | ||||||||||||||||
| 40f67575-bd8c-41d0-947f-0138c78ce0df | 2026-08-26 10:59 | 2026-08-26 10:59 | 2026-08-26 10:59 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 8.7400 | 8.6000 | 8.8500 | 125.2800 | 79516.00 | 52430.00 | 27086.00 | 91 | 8 | 109 | 2754 | 0.0395787944807553 | 0.568364195884558 | 0.569288641287462 | false | false | false | true | ||||||||||||||||
| 2f977c4d-16e1-4482-b2b6-2d55c651c0dd | 2026-08-19 11:51 | 2026-08-19 11:51 | 2026-08-19 11:51 | NOW | NOW261120C00140000 | call | 140.0000 | 2026-11-20 | 11.2000 | 10.9000 | 11.2500 | 129.2600 | 60480.00 | 52640.00 | 7840.00 | 54 | 13 | 196 | 2454 | 0.0798696006519967 | 0.574052512455323 | 0.574360779138315 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 134357960000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:08:27.647293Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 134357960000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:08:27.647293Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 134357960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:03.669649Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 135919300000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 135919300000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:37:13.633320Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 135919300000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:35:57.715033Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 145566520000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 145566520000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:47:39.692401Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:42:20.042631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142361120000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 147189900000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 147189900000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 147189900000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |