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_alerts474,253 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 |
|---|
| 17c66a17-4148-45cd-9333-9484a6d99caf | 2026-09-24 14:43 | 2026-09-24 14:43 | 2026-09-24 14:43 | SIL | SIL261120P00080000 | put | 80.0000 | 2026-11-20 | 2.4500 | 2.2000 | 2.4500 | 90.0000 | 170258.00 | 170258.00 | 0.00 | 695 | 40 | 710 | 95 | 7.47368421052632 | 0.487629081468501 | 0.487629081468501 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 1100949418.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:51:39.883666Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 28973d96-dcd7-4a17-ae4e-b494218e4c75 | 2026-09-16 12:01 | 2026-09-16 12:01 | 2026-09-16 12:01 | SIL | SIL261120P00070000 | put | 70.0000 | 2026-11-20 | 0.8500 | 0.7000 | 0.8500 | 92.5800 | 36887.00 | 36887.00 | 0.00 | 434 | 34 | 436 | 23 | 18.9565217391304 | 0.531096482269429 | 0.531096482269429 | false | false | ||||||||||||||||||
| 448bb52c-9a73-4ad3-8b62-ec1994e67d56 | 2026-09-16 09:40 | 2026-09-16 09:40 | 2026-09-16 09:40 | SIL | SIL270115C00120000 | call | 120.0000 | 2027-01-15 | 4.1000 | 3.7000 | 4.1000 | 93.7050 | 154144.00 | 154144.00 | 0.00 | 376 | 26 | 377 | 3189 | 0.118218877391032 | 0.531251091675621 | 0.531251091675621 | false | false | ||||||||||||||||||
| 5787f99f-575b-450c-9ea3-55daf44e99e9 | 2026-09-11 15:11 | 2026-09-11 15:11 | 2026-09-11 15:11 | SIL | SIL270115C00110000 | call | 110.0000 | 2027-01-15 | 7.2000 | 7.1000 | 7.9000 | 96.1700 | 360082.00 | 0.00 | 360082.00 | 500 | 7 | 1000 | 2586 | 0.386697602474865 | 0.520983318801955 | 0.520983318801955 | false | false | ||||||||||||||||||
| fcf6a4af-cd7b-4205-9333-c6576ca5164c | 2026-09-11 15:09 | 2026-09-11 15:09 | 2026-09-11 15:09 | SIL | SIL270115C00110000 | call | 110.0000 | 2027-01-15 | 7.1100 | 7.0000 | 7.9000 | 96.1800 | 355388.00 | 0.00 | 355388.00 | 500 | 16 | 500 | 2586 | 0.193348801237432 | 0.523993494070221 | 0.523993494070221 | false | false | ||||||||||||||||||
| 79e5dc3f-89ee-4532-85d9-b8b215fc1d29 | 2026-09-10 13:39 | 2026-09-10 13:39 | 2026-09-10 13:39 | SIL | SIL280121P00075000 | put | 75.0000 | 2028-01-21 | 10.0200 | 8.6000 | 11.5000 | 97.1350 | 17030.00 | 11000.00 | 0.00 | 17 | 5 | 17 | 89 | 0.191011235955056 | 0.542112419892454 | 0.540565423360288 | true | false | ||||||||||||||||||
| 13c93178-f9eb-441e-8bec-8c0f4bc36529 | 2026-09-09 10:14 | 2026-09-09 10:14 | 2026-09-09 10:14 | SIL | SIL261218C00105000 | call | 105.0000 | 2026-12-18 | 10.1400 | 9.4000 | 10.4000 | 100.4400 | 20273.00 | 20273.00 | 0.00 | 20 | 5 | 20 | 365 | 0.0547945205479452 | 0.566034901716142 | 0.551246717957016 | false | false | ||||||||||||||||||
| b81f587c-1403-41eb-9424-4978af480457 | 2026-09-04 11:07 | 2026-09-04 11:07 | 2026-09-04 11:07 | SIL | SIL280121C00150000 | call | 150.0000 | 2028-01-21 | 14.5200 | 12.5000 | 15.1000 | 99.9100 | 29040.00 | 2910.00 | 26130.00 | 20 | 20 | 20 | 177 | 0.112994350282486 | 0.563776647772397 | 0.561601294447866 | false | false | ||||||||||||||||||
| 442d5afc-231c-4ce7-be99-2d515d55ebdb | 2026-09-03 15:29 | 2026-09-03 15:28 | 2026-09-03 15:28 | SIL | SIL280121C00170000 | call | 170.0000 | 2028-01-21 | 12.3000 | 10.8000 | 12.3000 | 101.1500 | 24609.00 | 24609.00 | 0.00 | 20 | 6 | 21 | 1029 | 0.0204081632653061 | 0.574322906841074 | 0.573652922193172 | true | false | ||||||||||||||||||
| 94bba475-af1a-4c83-8f32-d1181a198e1e | 2026-08-28 14:48 | 2026-08-28 14:48 | 2026-08-28 14:48 | SIL | SIL261016P00065000 | put | 65.0000 | 2026-10-16 | 0.2500 | 0.1500 | 0.4000 | 97.9900 | 13293.00 | 13143.00 | 150.00 | 536 | 39 | 648 | 1491 | 0.434607645875252 | 0.62525992465157 | 0.62525992465157 | false | false | ||||||||||||||||||
| 7bd60a7f-685b-4762-b3b4-2ec412178316 | 2026-08-28 13:20 | 2026-08-28 13:20 | 2026-08-28 13:20 | SIL | SIL260918C00110000 | call | 110.0000 | 2026-09-18 | 1.5000 | 1.5000 | 1.6500 | 98.9650 | 37804.00 | 0.00 | 37804.00 | 252 | 6 | 543 | 1408 | 0.385653409090909 | 0.524236048114481 | 0.522824824553626 | false | false | ||||||||||||||||||
| fdc404ec-cb80-4f0f-bc46-fdc73e9d36f2 | 2026-08-27 10:03 | 2026-08-27 10:03 | 2026-08-27 10:03 | SIL | SIL261016C00095000 | call | 95.0000 | 2026-10-16 | 11.9400 | 10.9000 | 12.5000 | 101.7000 | 372500.00 | 372500.00 | 0.00 | 312 | 13 | 312 | 840 | 0.371428571428571 | 0.549353375522978 | 0.549353375522978 | false | false | ||||||||||||||||||
| 0e0b866f-9f5a-4faa-960e-81fe3b18a870 | 2026-08-21 14:06 | 2026-08-21 14:06 | 2026-08-21 14:06 | SIL | SIL261016P00110000 | put | 110.0000 | 2026-10-16 | 14.5400 | 14.0000 | 15.1000 | 99.0000 | 145440.00 | 0.00 | 87240.00 | 100 | 5 | 100 | 8 | 12.5 | 0.555331820086997 | 0.555331820086997 | false | false | ||||||||||||||||||
| 595ecfde-60b0-4204-8fc3-59f8cd05dbbf | 2026-08-20 10:21 | 2026-08-20 10:21 | 2026-08-20 10:21 | SIL | SIL261016C00100000 | call | 100.0000 | 2026-10-16 | 7.5000 | 7.0000 | 7.5000 | 97.0000 | 608960.00 | 608960.00 | 0.00 | 812 | 46 | 833 | 2171 | 0.383694150161216 | 0.559890685017417 | 0.559890685017417 | false | false | ||||||||||||||||||
| e91d4cd5-d502-4f2b-8bdd-7daf70b5ea80 | 2026-08-19 15:32 | 2026-08-19 15:32 | 2026-08-19 15:32 | SIL | SIL261016C00096000 | call | 96.0000 | 2026-10-16 | 8.5700 | 7.8000 | 8.7000 | 95.8500 | 34265.00 | 24805.00 | 9460.00 | 40 | 5 | 54 | 65 | 0.830769230769231 | 0.558912499990808 | 0.547664138566572 | false | false | ||||||||||||||||||
| 78774f15-55e8-4132-a2ce-26d06c63825b | 2026-08-18 11:23 | 2026-08-18 11:23 | 2026-08-18 11:23 | SIL | SIL260918P00078000 | put | 78.0000 | 2026-09-18 | 1.5500 | 1.2000 | 1.5500 | 87.2900 | 293705.00 | 293705.00 | 0.00 | 1895 | 46 | 1895 | 29 | 65.3448275862069 | 0.513561867289525 | 0.513561867289525 | false | false | ||||||||||||||||||
| 95b0463f-22b1-40e3-a74a-52bb9929dff9 | 2026-08-17 12:21 | 2026-08-17 12:21 | 2026-08-17 12:21 | SIL | SIL260918C00095000 | call | 95.0000 | 2026-09-18 | 4.1000 | 4.1000 | 4.3000 | 91.4600 | 11899.00 | 0.00 | 11899.00 | 29 | 7 | 261 | 1026 | 0.254385964912281 | 0.508462416479711 | 0.513145248450415 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:10:32.565799Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 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 |
| 1100949418.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| Financial Services |
| 1100949418.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |