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_alerts474,253 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 |
|---|
| f769595d-81ec-4ab2-95d3-298196f82022 | 2026-09-23 10:35 | 2026-09-23 10:35 | 2026-09-23 10:35 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 27.0200 | 26.9500 | 27.3000 | 747.3400 | 18913.00 | 5428.00 | 13485.00 | 7 | 5 | 428 | 99 | 4.32323232323232 | 0.751284203697313 | 0.753726422589 | false | false | false | true | 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:37:43.750009Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 19884540-63a9-41ed-8569-c25c50055484 | 2026-09-24 10:03 | 2026-09-24 10:03 | 2026-09-24 10:03 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 14.1600 | 14.1000 | 14.5000 | 760.8132 | 25495.00 | 12760.00 | 12735.00 | 18 | 6 | 573 | 369 | 1.55284552845528 | 0.75252627759723 | 0.75252627759723 | true | false | false | |||||||||||||||||
| 1e1cfdd5-ae03-4479-af81-6aaa56a15d81 | 2026-09-24 10:10 | 2026-09-24 10:10 | 2026-09-24 10:10 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 11.9100 | 11.8500 | 12.2500 | 765.2100 | 13100.00 | 5965.00 | 7135.00 | 11 | 5 | 811 | 369 | 2.19783197831978 | 0.75003441677092 | 0.754082410846997 | false | false | false | |||||||||||||||||
| a689eb6a-14ac-4b43-af5d-cc901b0cdd45 | 2026-09-24 10:23 | 2026-09-24 10:23 | 2026-09-24 10:23 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 11.8300 | 11.5500 | 11.8500 | 765.2400 | 105322.00 | 101812.00 | 3510.00 | 89 | 8 | 1996 | 369 | 5.40921409214092 | 0.743103331307279 | 0.742477239071817 | false | false | false | |||||||||||||||||
| bc6842c8-d7c0-4d9a-a2d5-e62233f412d9 | 2026-09-24 10:28 | 2026-09-24 10:28 | 2026-09-24 10:28 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 10.3100 | 10.1000 | 10.4000 | 767.9900 | 14430.00 | 12360.00 | 2070.00 | 14 | 6 | 2475 | 369 | 6.70731707317073 | 0.735923950992491 | 0.738782251753435 | true | false | false | |||||||||||||||||
| 48502757-5051-4d07-8ba3-ca07d77c850f | 2026-09-24 10:35 | 2026-09-24 10:35 | 2026-09-24 10:35 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 11.2600 | 11.2500 | 11.5000 | 765.3354 | 16895.00 | 1140.00 | 15755.00 | 15 | 6 | 3288 | 369 | 8.91056910569106 | 0.71721413944791 | 0.726605269873485 | true | false | false | |||||||||||||||||
| c101fd8b-f6b6-415f-b159-3daa6fca10ac | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 10.4200 | 10.2000 | 10.5000 | 767.5214 | 16670.00 | 16670.00 | 0.00 | 16 | 5 | 4586 | 369 | 12.4281842818428 | 0.73138793485599 | 0.734839852434556 | true | false | false | |||||||||||||||||
| 314f310c-7ec8-49ab-bb22-3cbd18fda536 | 2026-09-24 11:00 | 2026-09-24 11:00 | 2026-09-24 11:00 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 10.0700 | 9.9000 | 10.1500 | 768.1200 | 13090.00 | 11075.00 | 2015.00 | 13 | 8 | 5106 | 369 | 13.8373983739837 | 0.726925174813385 | 0.729889207709638 | true | false | false | |||||||||||||||||
| 903e0a49-598e-4bf8-89ff-b2377ef5aa22 | 2026-09-24 11:09 | 2026-09-24 11:09 | 2026-09-24 11:09 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 11.4900 | 11.3500 | 11.5000 | 764.0000 | 11488.00 | 11488.00 | 0.00 | 10 | 5 | 5961 | 369 | 16.1544715447154 | 0.709900598737258 | 0.704889991713571 | false | false | false | |||||||||||||||||
| fde12ef8-3ab4-4a9d-81db-3aead679132d | 2026-09-24 11:26 | 2026-09-24 11:26 | 2026-09-24 11:26 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 10.5900 | 10.2500 | 10.6000 | 766.2550 | 26475.00 | 26475.00 | 0.00 | 25 | 5 | 7116 | 369 | 19.2845528455285 | 0.697904543823423 | 0.704167925593692 | true | false | false | |||||||||||||||||
| f3316d5b-60d7-49b7-975a-638fcb6d081e | 2026-09-24 13:41 | 2026-09-24 13:41 | 2026-09-24 13:41 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 7.7900 | 7.7000 | 7.8500 | 769.7050 | 15584.00 | 15584.00 | 0.00 | 20 | 5 | 12950 | 369 | 35.0948509485095 | 0.624297134384743 | 0.624297134384743 | false | false | false | |||||||||||||||||
| 8941ffc1-b05f-4616-af0d-f55e9c334e1a | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 6.5900 | 6.3500 | 8.2000 | 767.6250 | 17136.00 | 0.00 | 17136.00 | 26 | 8 | 49 | 1863 | 0.0263016639828234 | 0.931000932413047 | 0.961298252502675 | true | false | false | |||||||||||||||||
| a515e244-a363-45c4-8f66-53c9e4d54594 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 7.5600 | 7.1500 | 7.7500 | 765.1900 | 12095.00 | 10590.00 | 1505.00 | 16 | 8 | 200 | 1863 | 0.107353730542136 | 0.937527487373017 | 0.927112391560783 | true | false | false | |||||||||||||||||
| 401cccab-8fe3-41b1-aaac-83c8bcaf56c7 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 7.5400 | 7.1000 | 7.7500 | 765.5350 | 12065.00 | 11310.00 | 755.00 | 16 | 15 | 184 | 1863 | 0.0987654320987654 | 0.937312900585581 | 0.941294781936635 | true | false | false | |||||||||||||||||
| 05d3f8e4-b776-48e3-9f2f-0cae242cce3a | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 7.8200 | 7.6000 | 7.9500 | 763.9150 | 10167.00 | 1552.00 | 8615.00 | 13 | 7 | 357 | 1863 | 0.191626409017713 | 0.84383315356854 | 0.869389180801142 | true | false | false | |||||||||||||||||
| e39588bc-c382-43a7-83ab-c63a01c1c261 | 2026-09-25 09:31 | 2026-09-25 09:31 | 2026-09-25 09:31 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 9.0500 | 8.8000 | 9.3000 | 760.6091 | 16284.00 | 5434.00 | 10850.00 | 18 | 7 | 819 | 1863 | 0.439613526570048 | 0.793451587612208 | 0.802522337405903 | false | false | false | |||||||||||||||||
| 088deb2b-9ea3-464a-9ae6-16efd00161f7 | 2026-09-25 09:31 | 2026-09-25 09:31 | 2026-09-25 09:31 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 10.0500 | 10.0000 | 10.4500 | 758.2400 | 30150.00 | 0.00 | 30150.00 | 30 | 8 | 919 | 1863 | 0.493290391841117 | 0.741658968576441 | 0.731896164193874 | true | false | false | |||||||||||||||||
| 5eb9b984-aadd-4f55-9d91-befff0bf96d1 | 2026-09-25 09:32 | 2026-09-25 09:32 | 2026-09-25 09:32 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 11.9900 | 11.4000 | 12.0000 | 757.0295 | 17990.00 | 17990.00 | 0.00 | 15 | 7 | 1075 | 1863 | 0.577026301663983 | 0.878436350450839 | 0.891765772069931 | false | false | false | |||||||||||||||||
| 5ccdca44-28fa-46ca-ab07-94322781a3d6 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | META | META260925P00765000 | put | 765.0000 | 2026-09-25 | 12.0900 | 11.6500 | 12.1000 | 756.0000 | 68930.00 | 66530.00 | 2400.00 | 57 | 6 | 1493 | 1863 | 0.801395598497048 | 0.864526374774538 | 0.827218820340121 | false | false | false |
| 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:04:09.722188Z"} |
| 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:10:55.671270Z"} |
| 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:24:55.986256Z"} |
| 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:31:48.426973Z"} |
| 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:35:45.310206Z"} |
| 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:56:01.849843Z"} |
| 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-24T15:01:26.561696Z"} |
| 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-24T15:12:31.706500Z"} |
| 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-24T15:29:44.716579Z"} |
| 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:43:31.900788Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:30:25.838480Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:32:31.841243Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:32:31.841243Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:32:31.841243Z"} |
| 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 |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |