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_alerts566,287 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 |
|---|
| 340be20e-9fb2-4a20-88d0-1b895867b1d8 | 2026-09-29 11:54 | 2026-09-29 11:54 | 2026-09-29 11:54 | FLUT | FLUT261218P00070000 | put | 70.0000 | 2026-12-18 | 5.2000 | 4.9000 | 5.2000 | 75.4200 | 150786.00 | 150276.00 | 510.00 | 290 | 34 | 290 | 96 | 3.02083333333333 | 0.584042255695316 | 0.576204484875895 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 12919986144.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T15:55:27.801272Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| e27cec26-5390-4ddf-b03c-676adc9b798c | 2026-09-29 10:13 | 2026-09-29 10:13 | 2026-09-29 10:13 | FLUT | FLUT261218P00075000 | put | 75.0000 | 2026-12-18 | 6.2000 | 6.2000 | 6.3000 | 77.7950 | 60150.00 | 630.00 | 59520.00 | 97 | 8 | 1526 | 252 | 6.05555555555556 | 0.559679383699859 | 0.552465447833856 | true | false | ||||||||||||||||||
| 44c6fc2e-5834-4520-b84a-9e21a201b9e4 | 2026-09-28 15:27 | 2026-09-28 15:27 | 2026-09-28 15:27 | FLUT | FLUT270115P00065000 | put | 65.0000 | 2027-01-15 | 3.9000 | 3.7000 | 3.9000 | 76.9500 | 110365.00 | 110365.00 | 0.00 | 283 | 42 | 283 | 217 | 1.30414746543779 | 0.58022443454832 | 0.58022443454832 | false | false | ||||||||||||||||||
| 728db3ca-ad53-4e1b-b76e-c8a5ef1d0850 | 2026-09-28 15:15 | 2026-09-28 15:15 | 2026-09-28 15:15 | FLUT | FLUT261016C00075000 | call | 75.0000 | 2026-10-16 | 5.0300 | 5.0000 | 5.3000 | 77.1400 | 12570.00 | 0.00 | 12060.00 | 25 | 9 | 700 | 6 | 116.666666666667 | 0.571890927896941 | 0.55657053321429 | false | false | ||||||||||||||||||
| d87d3d4b-294f-466f-b616-eae7b5de01ad | 2026-09-28 09:30 | 2026-09-28 09:30 | 2026-09-28 09:30 | FLUT | FLUT261120P00090000 | put | 90.0000 | 2026-11-20 | 11.5800 | 10.0000 | 12.2000 | 83.2850 | 19690.00 | 12790.00 | 6900.00 | 17 | 5 | 17 | 94 | 0.180851063829787 | 0.670297516269323 | 0.614204496181198 | false | false | ||||||||||||||||||
| dedeb140-398a-4346-a246-144e25ba3ab5 | 2026-09-25 15:40 | 2026-09-25 15:40 | 2026-09-25 15:40 | FLUT | FLUT261016C00080000 | call | 80.0000 | 2026-10-16 | 5.3500 | 5.3000 | 5.6000 | 81.0000 | 117180.00 | 20720.00 | 96460.00 | 219 | 8 | 226 | 43 | 5.25581395348837 | 0.611188760638715 | 0.571796223890751 | false | false | ||||||||||||||||||
| 04d6c9e5-17e0-4225-8214-fc164ee23382 | 2026-09-25 11:03 | 2026-09-25 11:03 | 2026-09-25 11:03 | FLUT | FLUT261120C00100000 | call | 100.0000 | 2026-11-20 | 2.3900 | 2.1000 | 2.7500 | 81.9100 | 40638.00 | 0.00 | 40638.00 | 170 | 5 | 170 | 206 | 0.825242718446602 | 0.595773553827023 | 0.595773553827023 | false | false | ||||||||||||||||||
| 15b83081-5da8-4b67-a425-267932189a90 | 2026-09-24 11:24 | 2026-09-24 11:23 | 2026-09-24 11:23 | FLUT | FLUT270115P00070000 | put | 70.0000 | 2027-01-15 | 4.5100 | 4.4000 | 4.8000 | 80.0000 | 156064.00 | 450.00 | 155614.00 | 346 | 14 | 398 | 140 | 2.84285714285714 | 0.56452557136885 | 0.558965617986083 | false | false | ||||||||||||||||||
| b233bd19-7a25-4c22-ae68-12d427209ba5 | 2026-09-18 11:33 | 2026-09-18 11:33 | 2026-09-18 11:33 | FLUT | FLUT261218P00085000 | put | 85.0000 | 2026-12-18 | 6.6000 | 6.4000 | 6.6000 | 90.2200 | 147838.00 | 147838.00 | 0.00 | 224 | 27 | 225 | 272 | 0.827205882352941 | 0.539742117853194 | 0.539742117853194 | false | false | ||||||||||||||||||
| 8c532dec-9fae-422e-a71a-7feb9e2f4d7d | 2026-09-17 10:51 | 2026-09-17 10:51 | 2026-09-17 10:51 | FLUT | FLUT260918P00095000 | put | 95.0000 | 2026-09-18 | 1.2000 | 0.1500 | 1.4500 | 95.5200 | 19305.00 | 19195.00 | 110.00 | 161 | 7 | 161 | 889 | 0.181102362204724 | 0.728900118271427 | 0.67803791969593 | false | false | ||||||||||||||||||
| 7922bbd0-7e24-4bb9-af51-238463376815 | 2026-09-17 10:51 | 2026-09-17 10:51 | 2026-09-17 10:51 | FLUT | FLUT261218P00100000 | put | 100.0000 | 2026-12-18 | 12.0000 | 11.5000 | 12.0000 | 95.5200 | 212383.00 | 212383.00 | 0.00 | 177 | 33 | 178 | 2953 | 0.0602776837114799 | 0.526427398951339 | 0.525381968978907 | false | false | ||||||||||||||||||
| 8567ba45-4f22-4d62-874f-9a36f3b7bb4b | 2026-08-28 14:37 | 2026-08-28 14:37 | 2026-08-28 14:37 | FLUT | FLUT260918C00105000 | call | 105.0000 | 2026-09-18 | 2.7200 | 2.4000 | 2.7500 | 100.4750 | 14975.00 | 14975.00 | 0.00 | 55 | 8 | 105 | 275 | 0.381818181818182 | 0.464008953156668 | 0.461304126175962 | true | false | ||||||||||||||||||
| ea5a64c8-1582-471b-93d1-6f05a24abcf8 | 2026-08-28 12:49 | 2026-08-28 12:49 | 2026-08-28 12:49 | FLUT | FLUT260918C00100000 | call | 100.0000 | 2026-09-18 | 2.8300 | 2.7500 | 2.9500 | 96.4650 | 52633.00 | 26098.00 | 26535.00 | 186 | 27 | 227 | 824 | 0.275485436893204 | 0.464502238267616 | 0.464502238267616 | false | false | ||||||||||||||||||
| bc682558-0427-4592-b6cf-758a10ac99ae | 2026-08-27 11:55 | 2026-08-27 11:55 | 2026-08-27 11:55 | FLUT | FLUT261218P00080000 | put | 80.0000 | 2026-12-18 | 3.4000 | 3.2000 | 3.4000 | 97.2300 | 98252.00 | 98252.00 | 0.00 | 289 | 46 | 298 | 673 | 0.442793462109955 | 0.512729577333856 | 0.512729577333856 | false | false | ||||||||||||||||||
| 9ab3fbcc-5b8d-4ee6-afdb-af71435aeb72 | 2026-08-20 10:13 | 2026-08-20 10:13 | 2026-08-20 10:13 | FLUT | FLUT260821P00100000 | put | 100.0000 | 2026-08-21 | 1.4000 | 0.7500 | 1.6000 | 99.9800 | 25742.00 | 25742.00 | 0.00 | 184 | 42 | 188 | 1892 | 0.0993657505285412 | 0.668263906417497 | 0.668263906417497 | true | false | ||||||||||||||||||
| 60a507b2-2e07-4374-a9a3-9b22063d3e5b | 2026-08-18 14:38 | 2026-08-18 14:37 | 2026-08-18 14:37 | FLUT | FLUT261218C00095000 | call | 95.0000 | 2026-12-18 | 10.7000 | 10.7000 | 10.9000 | 94.3400 | 125213.00 | 0.00 | 125213.00 | 117 | 34 | 154 | 52 | 2.96153846153846 | 0.482133064274516 | 0.481201823211382 | false | false | ||||||||||||||||||
| e8dd5f6f-15b6-43e5-b13c-8bed8674d94b | 2026-08-18 14:20 | 2026-08-18 14:20 | 2026-08-18 14:20 | FLUT | FLUT261218C00100000 | call | 100.0000 | 2026-12-18 | 8.5200 | 8.4000 | 9.1000 | 94.3000 | 85151.00 | 0.00 | 85151.00 | 100 | 34 | 119 | 284 | 0.419014084507042 | 0.478334012923663 | 0.475574354377544 | false | false | ||||||||||||||||||
| 3094465b-5271-4333-8224-803dcbb9ef71 | 2026-08-17 14:27 | 2026-08-17 14:27 | 2026-08-17 14:27 | FLUT | FLUT270115C00100000 | call | 100.0000 | 2027-01-15 | 11.3000 | 11.0000 | 11.6000 | 97.0750 | 16943.00 | 14683.00 | 0.00 | 15 | 10 | 25 | 135 | 0.185185185185185 | 0.478056492006567 | 0.477652586049764 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12919986144.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:16:47.847178Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 13298301386.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:30:45.639934Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 13298301386.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:15:55.789711Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 13298301386.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:30:57.841770Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 14443659459.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 14443659459.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:05:27.463808Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 14905273471.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:25:28.380196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15542161975.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 16052366935.00 |
| 2026-11-11 |
| 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 |
| Consumer Cyclical |
| 16052366935.00 |
| 2026-11-11 |
| 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 |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| 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 |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| 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 |
| Consumer Cyclical |
| 17466710616.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |