Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 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 |
| 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 | 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:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |
| 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 | false | 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 |