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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| 48f6da4c-3d1c-4062-b5d5-900c0595eefd | 2026-09-29 15:25 | 2026-09-29 15:25 | 2026-09-29 15:25 | RAM | RAM270319P00011000 | put | 11.0000 | 2027-03-19 | 2.5000 | 2.4500 | 2.5000 | 14.0000 | 12750.00 | 6500.00 | 0.00 | 51 | 13 | 236 | 379 | 0.622691292875989 | 1.20743766603429 | 1.20743766603429 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | Financial Services | 0.00 | — | unkown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 03661841-03a5-4c10-b5db-5cc2cde0c5d5 | 2026-09-29 15:25 | 2026-09-29 15:25 | 2026-09-29 15:25 | RAM | RAM270319P00011000 | put | 11.0000 | 2027-03-19 | 2.5000 | 2.4500 | 2.5000 | 14.0000 | 11500.00 | 4250.00 | 0.00 | 46 | 7 | 282 | 379 | 0.744063324538259 | 1.20743766603429 | 1.20743766603429 | true | false | false | |||||||||||||||||
| f9d62c42-f5d6-4e10-b45d-36d198237953 | 2026-09-29 15:25 | 2026-09-29 15:24 | 2026-09-29 15:24 | RAM | RAM270319P00011000 | put | 11.0000 | 2027-03-19 | 2.5000 | 2.3500 | 2.5000 | 14.0000 | 12500.00 | 12500.00 | 0.00 | 50 | 8 | 57 | 379 | 0.150395778364116 | 1.2078180256682 | 1.2078180256682 | false | false | false | |||||||||||||||||
| 16fd0da1-1b33-4676-a91b-f55281e57a0d | 2026-09-29 10:43 | 2026-09-29 10:43 | 2026-09-29 10:43 | RAM | RAM261120C00019000 | call | 19.0000 | 2026-11-20 | 1.2500 | 1.1500 | 1.3000 | 14.2400 | 43702.00 | 42490.00 | 1212.00 | 350 | 11 | 352 | 155 | 2.27096774193548 | 1.21057372998462 | 1.21057372998462 | false | false | ||||||||||||||||||
| 844dc05f-b2dc-4cf5-bf21-d8ab8aae903b | 2026-09-28 14:48 | 2026-09-28 14:47 | 2026-09-28 14:47 | RAM | RAM261016C00014000 | call | 14.0000 | 2026-10-16 | 1.0500 | 1.0500 | 1.2000 | 13.4500 | 105000.00 | 0.00 | 105000.00 | 1000 | 5 | 2697 | 764 | 3.53010471204188 | 1.06818821048207 | 1.06818821048207 | false | false | ||||||||||||||||||
| 446f079b-813b-4ce1-a1a1-d96e840b2d46 | 2026-09-28 11:49 | 2026-09-28 11:49 | 2026-09-28 11:49 | RAM | RAM261016C00014000 | call | 14.0000 | 2026-10-16 | 1.0500 | 0.9500 | 1.0500 | 13.0850 | 102794.00 | 102794.00 | 0.00 | 979 | 17 | 1611 | 764 | 2.1086387434555 | 1.20573937349777 | 1.21441782411058 | false | false | ||||||||||||||||||
| d5bbfd56-8cb9-4a10-ac2f-f728449ecdaa | 2026-09-25 12:52 | 2026-09-25 12:52 | 2026-09-25 12:52 | RAM | RAM261016C00015000 | call | 15.0000 | 2026-10-16 | 1.3000 | 1.1000 | 1.3000 | 14.3250 | 39000.00 | 39000.00 | 0.00 | 300 | 5 | 347 | 2565 | 0.135282651072125 | 1.14537000819121 | 1.14537000819121 | false | false | ||||||||||||||||||
| 9655ab67-bd6f-4610-9f1c-ceeddc90d1f3 | 2026-09-24 14:09 | 2026-09-24 14:09 | 2026-09-24 14:09 | RAM | RAM261120C00015000 | call | 15.0000 | 2026-11-20 | 2.2500 | 2.1000 | 2.2500 | 13.8250 | 19575.00 | 14850.00 | 0.00 | 87 | 17 | 100 | 194 | 0.515463917525773 | 1.22957272981242 | 1.22957272981242 | false | false | ||||||||||||||||||
| 1df50f69-7d08-4236-887f-dd0e6a04a97f | 2026-09-22 15:14 | 2026-09-22 15:14 | 2026-09-22 15:14 | RAM | RAM261016C00014000 | call | 14.0000 | 2026-10-16 | 2.5500 | 2.4000 | 2.5500 | 15.3010 | 38250.00 | 38250.00 | 0.00 | 150 | 10 | 236 | 905 | 0.260773480662983 | 1.21014361492013 | 1.21014361492013 | false | false | ||||||||||||||||||
| 1c944866-1779-490a-bea0-47bde935f476 | 2026-09-22 10:57 | 2026-09-22 10:57 | 2026-09-22 10:57 | RAM | RAM261218C00020000 | call | 20.0000 | 2026-12-18 | 2.0100 | 1.9500 | 2.1500 | 14.9450 | 18079.00 | 2000.00 | 16079.00 | 90 | 6 | 105 | 1779 | 0.0590219224283305 | 1.19599066585584 | 1.20298369664784 | false | false | ||||||||||||||||||
| d0eaf91d-ea94-4929-b46f-78f1ec601763 | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | RAM | RAM261016C00017000 | call | 17.0000 | 2026-10-16 | 1.2500 | 1.1500 | 1.2500 | 15.1300 | 10000.00 | 10000.00 | 0.00 | 80 | 7 | 368 | 834 | 0.441247002398082 | 1.24588635046819 | 1.24588635046819 | false | false | ||||||||||||||||||
| ce7ee11d-4259-48e9-bfe8-494fd6257bef | 2026-09-22 09:56 | 2026-09-22 09:56 | 2026-09-22 09:56 | RAM | RAM261016C00018000 | call | 18.0000 | 2026-10-16 | 1.0000 | 0.8500 | 1.0000 | 15.1000 | 10000.00 | 10000.00 | 0.00 | 100 | 7 | 305 | 1060 | 0.287735849056604 | 1.26823524116956 | 1.26823524116956 | false | false | ||||||||||||||||||
| eeb81019-c1f3-48fd-adb3-d74e8ff52828 | 2026-09-21 11:16 | 2026-09-21 11:16 | 2026-09-21 11:16 | RAM | RAM261120C00016000 | call | 16.0000 | 2026-11-20 | 2.1500 | 2.0500 | 2.3000 | 14.2800 | 31605.00 | 31390.00 | 215.00 | 147 | 6 | 169 | 110 | 1.53636363636364 | 1.19493412030065 | 1.19493412030065 | false | false | ||||||||||||||||||
| 150d46ec-117e-4c9e-bd64-51cfb620cfce | 2026-09-09 10:10 | 2026-09-09 10:10 | 2026-09-09 10:10 | RAM | RAM261016P00012000 | put | 12.0000 | 2026-10-16 | 1.1000 | 1.1000 | 1.3000 | 15.0690 | 110012.00 | 0.00 | 110012.00 | 1000 | 5 | 2000 | 152 | 13.1578947368421 | 1.39136905945611 | 1.38447203510682 | false | false | ||||||||||||||||||
| 0a4f2d3a-1605-4f7f-aa46-54349dab29ec | 2026-08-24 09:34 | 2026-08-24 09:34 | 2026-08-24 09:34 | RAM | RAM260918C00014000 | call | 14.0000 | 2026-09-18 | 0.9000 | 0.8000 | 0.9000 | 11.6400 | 179960.00 | 179960.00 | 0.00 | 2000 | 12 | 2000 | 2801 | 0.714030703320243 | 1.37336841832661 | 1.37336841832661 | false | false | ||||||||||||||||||
| 80ea5a86-36f4-4b36-aba0-e8801281ce47 | 2026-08-19 09:48 | 2026-08-19 09:48 | 2026-08-19 09:48 | RAM | RAM261218P00007000 | put | 7.0000 | 2026-12-18 | 1.2500 | 0.7000 | 1.2500 | 12.4400 | 125000.00 | 125000.00 | 0.00 | 1000 | 7 | 1000 | 1494 | 0.669344042838019 | 1.58286067939625 | 1.58286067939625 | false | false | ||||||||||||||||||
| 82337966-782e-44a1-a40e-d0b2e599a44e | 2026-08-18 09:47 | 2026-08-18 09:47 | 2026-08-18 09:47 | RAM | RAM260821P00014000 | put | 14.0000 | 2026-08-21 | 1.5000 | 1.5000 | 1.6000 | 12.0000 | 107403.00 | 0.00 | 107403.00 | 716 | 10 | 1009 | 1649 | 0.611885991510006 | 1.6035715277209 | 1.5272426745943 | false | false |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:43:57.970888Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:53:41.284908Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 0.00 |
| — |
| unkown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |