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 |
|---|
| a82670ac-99e7-42c5-a698-b307b98e1291 | 2026-09-29 10:26 | 2026-09-29 10:26 | 2026-09-29 10:26 | BTDR | BTDR261016P00012000 | put | 12.0000 | 2026-10-16 | 1.3000 | 1.2500 | 1.4000 | 11.2599 | 178914.00 | 0.00 | 178914.00 | 1376 | 60 | 3000 | 5244 | 0.5720823798627 | 0.882763065508584 | 0.897267538440723 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 2567517716.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| ee8d34f8-0167-4d12-b025-1d7d1523b386 | 2026-09-28 12:51 | 2026-09-28 12:51 | 2026-09-28 12:51 | BTDR | BTDR261002P00011000 | put | 11.0000 | 2026-10-02 | 0.3500 | 0.3500 | 0.4000 | 11.1664 | 17527.00 | 0.00 | 17527.00 | 500 | 12 | 576 | 1052 | 0.547528517110266 | 0.9519566699603 | 0.9519566699603 | false | false | ||||||||||||||||||
| ff979502-84f2-4648-9ca8-96ac6932e322 | 2026-09-09 10:31 | 2026-09-09 10:31 | 2026-09-09 10:31 | BTDR | BTDR261120C00013000 | call | 13.0000 | 2026-11-20 | 2.0900 | 1.9000 | 2.3500 | 12.0000 | 12352.00 | 8754.00 | 3598.00 | 59 | 7 | 59 | 100 | 0.59 | 1.04290039296234 | 1.0246186551314 | false | false | ||||||||||||||||||
| 3b2720ce-6071-4f56-88c0-25a84877696a | 2026-09-04 15:20 | 2026-09-04 15:19 | 2026-09-04 15:19 | BTDR | BTDR280121C00012500 | call | 12.5000 | 2028-01-21 | 5.6800 | 5.6000 | 5.8000 | 12.3400 | 17050.00 | 0.00 | 17050.00 | 30 | 5 | 62 | 698 | 0.0888252148997135 | 1.01259429941278 | 1.01259429941278 | false | false | ||||||||||||||||||
| f8d2e006-1c21-41bc-a0c8-446c124cef2a | 2026-09-04 13:27 | 2026-09-04 13:27 | 2026-09-04 13:27 | BTDR | BTDR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.8200 | 1.7500 | 1.8500 | 12.3250 | 18175.00 | 18175.00 | 0.00 | 100 | 12 | 963 | 4513 | 0.213383558608464 | 1.01195704722035 | 0.980937838513611 | false | false | ||||||||||||||||||
| a4656bf6-1eae-43cb-b94c-78819bf81f14 | 2026-09-04 12:35 | 2026-09-04 12:34 | 2026-09-04 12:34 | BTDR | BTDR270115C00012500 | call | 12.5000 | 2027-01-15 | 2.9500 | 2.7500 | 2.9500 | 12.3400 | 326614.00 | 326614.00 | 0.00 | 1108 | 24 | 1114 | 6664 | 0.167166866746699 | 1.00553429814535 | 1.00553429814535 | false | false | ||||||||||||||||||
| 4f38bf58-b95d-4a54-a589-bc2bf1e1d829 | 2026-09-04 12:35 | 2026-09-04 12:34 | 2026-09-04 12:34 | BTDR | BTDR270115C00017500 | call | 17.5000 | 2027-01-15 | 1.5500 | 1.3000 | 1.5500 | 12.3400 | 127087.00 | 127087.00 | 0.00 | 820 | 29 | 860 | 1556 | 0.552699228791774 | 0.996610840243959 | 0.996610840243959 | false | false | ||||||||||||||||||
| a277fc67-16db-43c5-8bb3-df37451ad91f | 2026-09-03 10:28 | 2026-09-03 10:28 | 2026-09-03 10:28 | BTDR | BTDR261016C00012000 | call | 12.0000 | 2026-10-16 | 1.4000 | 1.4000 | 1.5000 | 11.7900 | 120078.00 | 0.00 | 120078.00 | 857 | 29 | 862 | 4296 | 0.200651769087523 | 0.924657925677631 | 0.912185590055333 | true | false | ||||||||||||||||||
| d7ba797e-c8f2-4896-9122-82dd52539bfa | 2026-08-31 13:38 | 2026-08-31 13:38 | 2026-08-31 13:38 | BTDR | BTDR270115C00014000 | call | 14.0000 | 2027-01-15 | 1.6900 | 1.5500 | 1.7500 | 10.8000 | 25324.00 | 12649.00 | 12675.00 | 150 | 7 | 150 | 120 | 1.25 | 1.00186794300919 | 0.99718146284372 | false | false | ||||||||||||||||||
| 2cad2474-6045-4daa-83ec-cd78f5754efe | 2026-08-25 12:47 | 2026-08-25 12:46 | 2026-08-25 12:46 | BTDR | BTDR261002P00008000 | put | 8.0000 | 2026-10-02 | 0.2000 | 0.2000 | 0.3500 | 11.1800 | 79942.00 | 0.00 | 79942.00 | 3996 | 34 | 4000 | 29 | 137.931034482759 | 0.98723527945157 | 0.95739145568692 | false | false | ||||||||||||||||||
| d30fc533-02b3-4374-a9d1-4eb365c6a254 | 2026-08-19 11:44 | 2026-08-19 11:44 | 2026-08-19 11:44 | BTDR | BTDR260918C00012500 | call | 12.5000 | 2026-09-18 | 0.4000 | 0.3000 | 0.4000 | 9.8700 | 98983.00 | 98983.00 | 0.00 | 2475 | 45 | 2537 | 4507 | 0.562902152207677 | 1.03167000461724 | 1.03167000461724 | false | false | ||||||||||||||||||
| e3548b95-80da-437f-843a-82c6c9ad09de | 2026-08-18 11:26 | 2026-08-18 11:26 | 2026-08-18 11:26 | BTDR | BTDR260911C00009000 | call | 9.0000 | 2026-09-11 | 0.8500 | 0.7500 | 0.8500 | 8.9150 | 305780.00 | 305780.00 | 0.00 | 3599 | 31 | 3686 | 130 | 28.3538461538462 | 0.96503978570026 | 0.943013226842181 | false | false | ||||||||||||||||||
| c193fd30-dd1c-40f1-a25f-b54b01c1f3cc | 2026-08-18 11:26 | 2026-08-18 11:26 | 2026-08-18 11:26 | BTDR | BTDR260911C00009500 | call | 9.5000 | 2026-09-11 | 0.6500 | 0.5500 | 0.6500 | 8.9150 | 254140.00 | 254140.00 | 0.00 | 3912 | 46 | 3934 | 103 | 38.1941747572816 | 0.962710081932353 | 0.962710081932353 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2598139487.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:56:37.183860Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2746537299.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |