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_alerts523,327 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 |
|---|
| 000a7728-26c3-45cc-9d02-9794e3b4eed3 | 2026-09-25 12:03 | 2026-09-25 12:03 | 2026-09-25 12:03 | TLN | TLN280121P00230000 | put | 230.0000 | 2028-01-21 | 31.3100 | 30.3000 | 31.4000 | 302.5150 | 15656.00 | 15656.00 | 0.00 | 5 | 5 | 10 | 3194 | 0.00313087038196619 | 0.569112253703151 | 0.568803595562129 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 14586058725.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:03:52.208373Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 902bc819-64f3-4672-b80b-7f479c967492 | 2026-09-17 11:39 | 2026-09-17 11:39 | 2026-09-17 11:39 | TLN | TLN270115P00230000 | put | 230.0000 | 2027-01-15 | 8.6100 | 8.0000 | 9.8000 | 302.3700 | 21535.00 | 0.00 | 21535.00 | 25 | 5 | 26 | 455 | 0.0571428571428571 | 0.564543509216413 | 0.564543509216413 | false | false | ||||||||||||||||||
| 7c3b8fc4-149b-41cd-ad2b-0ccf9b33d7b1 | 2026-09-17 10:55 | 2026-09-17 10:55 | 2026-09-17 10:55 | TLN | TLN261120C00320000 | call | 320.0000 | 2026-11-20 | 20.4900 | 18.8000 | 20.5000 | 299.4800 | 32780.00 | 28700.00 | 4080.00 | 16 | 11 | 16 | 314 | 0.0509554140127389 | 0.557945256962953 | 0.557945256962953 | true | false | ||||||||||||||||||
| c9ec6ed0-2838-4e74-bc7a-17b90dcab312 | 2026-09-15 10:20 | 2026-09-15 10:20 | 2026-09-15 10:20 | TLN | TLN260918C00292500 | call | 292.5000 | 2026-09-18 | 4.9000 | 4.8000 | 7.6000 | 286.5000 | 36230.00 | 0.00 | 36230.00 | 74 | 15 | 74 | 6 | 12.3333333333333 | 0.715116338397998 | 0.705066551759101 | true | false | ||||||||||||||||||
| fa10f564-4fcb-4a8e-a20c-556884e12eee | 2026-09-03 09:55 | 2026-09-03 09:55 | 2026-09-03 09:55 | TLN | TLN260904P00307500 | put | 307.5000 | 2026-09-04 | 3.7000 | 2.8000 | 3.7000 | 310.0000 | 100631.00 | 100631.00 | 0.00 | 272 | 45 | 272 | 11 | 24.7272727272727 | 0.754148935413761 | 0.754148935413761 | false | false | ||||||||||||||||||
| cc44a8e9-65b6-4f8d-8785-f24d127f4f60 | 2026-08-28 12:41 | 2026-08-28 12:41 | 2026-08-28 12:41 | TLN | TLN270115P00260000 | put | 260.0000 | 2027-01-15 | 23.2800 | 21.1000 | 23.8000 | 296.5400 | 20956.00 | 16660.00 | 4296.00 | 9 | 5 | 140 | 4149 | 0.0337430706194264 | 0.601110042788494 | 0.56356905198727 | false | false | ||||||||||||||||||
| 1d1f0ead-8730-4b4b-8ca8-f4755b98fadf | 2026-08-26 09:43 | 2026-08-26 09:43 | 2026-08-26 09:43 | TLN | TLN260828P00310000 | put | 310.0000 | 2026-08-28 | 4.0800 | 3.3000 | 5.2000 | 315.4900 | 30622.00 | 0.00 | 30622.00 | 75 | 16 | 75 | 285 | 0.263157894736842 | 0.704318724085003 | 0.704318724085003 | false | false | ||||||||||||||||||
| b2690b94-c169-4eb9-affd-407459da3817 | 2026-08-24 10:28 | 2026-08-24 10:27 | 2026-08-24 10:27 | TLN | TLN260828C00317500 | call | 317.5000 | 2026-08-28 | 3.9200 | 3.8000 | 4.9000 | 307.9500 | 18020.00 | 1170.00 | 15980.00 | 46 | 17 | 56 | 21 | 2.66666666666667 | 0.629243997736966 | 0.582053523477141 | false | false | ||||||||||||||||||
| 438eefe1-658d-4ef7-b360-6eadd5f99880 | 2026-08-19 10:32 | 2026-08-19 10:32 | 2026-08-19 10:32 | TLN | TLN260828P00315000 | put | 315.0000 | 2026-08-28 | 11.2900 | 11.1000 | 12.4000 | 320.3400 | 32740.00 | 9040.00 | 20310.00 | 29 | 10 | 30 | 79 | 0.379746835443038 | 0.700979372557296 | 0.695877932953978 | true | false | ||||||||||||||||||
| c694955d-e97e-41db-87ba-eabe17ff6f67 | 2026-08-19 09:41 | 2026-08-19 09:41 | 2026-08-19 09:41 | TLN | TLN260918C00340000 | call | 340.0000 | 2026-09-18 | 16.4700 | 13.9000 | 20.0000 | 320.0000 | 171240.00 | 136590.00 | 34650.00 | 104 | 23 | 104 | 129 | 0.806201550387597 | 0.660117701637012 | 0.657324416650649 | true | false | ||||||||||||||||||
| dd109955-fa38-476f-9193-0f4adb172683 | 2026-08-18 14:38 | 2026-08-18 14:38 | 2026-08-18 14:38 | TLN | TLN261120P00310000 | put | 310.0000 | 2026-11-20 | 30.5400 | 29.1500 | 31.9000 | 319.9900 | 149659.00 | 58139.00 | 91520.00 | 49 | 21 | 82 | 5 | 16.4 | 0.58162068767573 | 0.58162068767573 | false | false | ||||||||||||||||||
| a688f850-d2d2-43c4-8ebd-c015f43ed6a5 | 2026-08-18 12:56 | 2026-08-18 12:56 | 2026-08-18 12:56 | TLN | TLN260828P00375000 | put | 375.0000 | 2026-08-28 | 27.9900 | 27.9000 | 28.0000 | 352.3000 | 69980.00 | 64400.00 | 5580.00 | 25 | 9 | 25 | 10 | 2.5 | 0.600039401766242 | 0.589182642346937 | false | false | ||||||||||||||||||
| 0a562163-f443-400a-aa3a-2f3cc48793bf | 2026-08-18 12:56 | 2026-08-18 12:56 | 2026-08-18 12:56 | TLN | TLN260821P00355000 | put | 355.0000 | 2026-08-21 | 9.8000 | 9.7000 | 9.8000 | 352.6000 | 62716.00 | 62716.00 | 0.00 | 64 | 19 | 64 | 23 | 2.78260869565217 | 0.672821294368376 | 0.672821294368376 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 14053731307.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 14053731307.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |