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 | strikenumeric | expiry |
|---|
| 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 |
|---|
| 0bc835bb-a206-4725-8a88-16613b9d9563 | 2026-09-14 12:16 | 2026-09-14 12:16 | 2026-09-14 12:16 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 2.8800 | 2.8800 | 2.9200 | 289.1700 | 144001.00 | 289.00 | 143712.00 | 500 | 5 | 11472 | 46934 | 0.244428346188264 | 0.251442148639637 | 0.250612988933195 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 78377484640.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1e83a63d-2695-4b65-b87a-0dc18d91d4b3 | 2026-09-10 15:35 | 2026-09-10 15:35 | 2026-09-10 15:35 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.7300 | 4.7300 | 4.7700 | 287.5600 | 470635.00 | 0.00 | 470635.00 | 995 | 31 | 14175 | 51572 | 0.27485845032188 | 0.240919788337928 | 0.241079376671963 | true | false | false | true | ||||||||||||||||
| 9b068b32-2c29-48e5-a824-083bc872369b | 2026-09-10 15:35 | 2026-09-10 15:34 | 2026-09-10 15:34 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.7600 | 4.7500 | 4.8100 | 287.5400 | 279861.00 | 0.00 | 210841.00 | 588 | 25 | 11998 | 51572 | 0.232645621655162 | 0.242215995057569 | 0.241624198088064 | true | false | false | true | ||||||||||||||||
| 7f370bb4-411b-4f9e-9be1-c6714b2d128a | 2026-09-10 15:34 | 2026-09-10 15:34 | 2026-09-10 15:34 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.7700 | 4.7700 | 4.8300 | 287.5500 | 205587.00 | 0.00 | 205587.00 | 431 | 23 | 11026 | 51572 | 0.213798185061661 | 0.243126994018222 | 0.243126994018222 | true | false | false | true | ||||||||||||||||
| 34709f78-72a0-4513-aeac-0005f31bfd13 | 2026-09-10 13:40 | 2026-09-10 13:40 | 2026-09-10 13:40 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.5700 | 4.5700 | 4.6200 | 287.7900 | 230328.00 | 0.00 | 230328.00 | 504 | 20 | 6693 | 51572 | 0.129779725432405 | 0.238897289103979 | 0.238897289103979 | true | false | false | true | ||||||||||||||||
| df86ac3b-c5ed-4a80-b49a-686eb2e784c0 | 2026-09-10 13:40 | 2026-09-10 13:40 | 2026-09-10 13:40 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.5700 | 4.5600 | 4.6700 | 287.7600 | 841435.00 | 10555.00 | 830880.00 | 1840 | 53 | 5653 | 51572 | 0.109613743892034 | 0.239136812519639 | 0.237956229822108 | true | false | false | true | ||||||||||||||||
| 16067b56-018d-4e2a-9fd7-0f37608bd869 | 2026-09-10 13:40 | 2026-09-10 13:40 | 2026-09-10 13:40 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.5700 | 4.5600 | 4.6300 | 287.7800 | 176402.00 | 0.00 | 99169.00 | 386 | 5 | 6039 | 51572 | 0.117098425502211 | 0.23858390787904 | 0.23858390787904 | true | false | false | true | ||||||||||||||||
| 078ab06d-8177-4695-80f8-c433c9ea644c | 2026-09-10 13:40 | 2026-09-10 13:40 | 2026-09-10 13:40 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 4.5700 | 4.5700 | 4.6800 | 287.7600 | 970045.00 | 0.00 | 970045.00 | 2121 | 73 | 3813 | 51572 | 0.0739354688590708 | 0.237956229822108 | 0.239136812519639 | true | false | false | true | ||||||||||||||||
| 71ae0263-16fe-4bc4-9074-161f24e958fc | 2026-08-27 12:37 | 2026-08-27 12:37 | 2026-08-27 12:37 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.6300 | 1.6300 | 1.6500 | 299.9000 | 165934.00 | 0.00 | 165934.00 | 1018 | 37 | 1520 | 49805 | 0.030519024194358 | 0.195011944134402 | 0.195011944134402 | false | false | false | true | ||||||||||||||||
| 17d99c68-4bed-4c3e-b845-08de8e49f788 | 2026-08-17 16:05 | 2026-08-17 16:03 | 2026-08-17 16:03 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9700 | 1.9300 | 1.9800 | 304.0000 | 788940.00 | 788940.00 | 0.00 | 4000 | 47 | 40522 | 26298 | 1.5408776332801 | 0.210001401296849 | 0.210834147041646 | false | false | false | true | ||||||||||||||||
| fa4800dc-cb46-46f4-be61-788bea26ddcf | 2026-08-17 16:01 | 2026-08-17 16:01 | 2026-08-17 16:01 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9900 | 1.9600 | 1.9900 | 304.0600 | 721375.00 | 721375.00 | 0.00 | 3625 | 16 | 34527 | 26298 | 1.31291352954597 | 0.211712080379884 | 0.211712080379884 | false | false | false | true | ||||||||||||||||
| 17c57fb4-a9be-4cc1-893f-fbf876a01aee | 2026-08-17 16:01 | 2026-08-17 16:01 | 2026-08-17 16:01 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9800 | 1.9500 | 1.9900 | 304.0600 | 1068076.00 | 1068076.00 | 0.00 | 5381 | 63 | 30902 | 26298 | 1.17507034755495 | 0.21129621329452 | 0.211712080379884 | false | false | false | true | ||||||||||||||||
| f8d97240-c488-48ff-9d4f-03c3d8ae2f80 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9700 | 1.9200 | 1.9700 | 303.5800 | 492066.00 | 492066.00 | 0.00 | 2498 | 7 | 14624 | 26298 | 0.556087915430831 | 0.206760694392272 | 0.206760694392272 | false | false | false | true | ||||||||||||||||
| f10ad46e-87fa-4222-9ea0-07a8444bb733 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9700 | 1.9200 | 1.9800 | 303.5500 | 652887.00 | 652887.00 | 0.00 | 3311 | 60 | 17935 | 26298 | 0.681991025933531 | 0.206760694392272 | 0.20735486413715 | false | false | false | true | ||||||||||||||||
| 0901ae04-806e-4a3c-91c0-ccb331de5217 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 1.9800 | 1.9500 | 1.9900 | 303.5500 | 1038906.00 | 1038708.00 | 0.00 | 5247 | 16 | 23182 | 26298 | 0.881511902045783 | 0.20735486413715 | 0.20735486413715 | false | false | false | true | ||||||||||||||||
| d353d43f-c4e5-4856-95f3-b2fd1f9d694d | 2026-08-17 11:38 | 2026-08-17 11:38 | 2026-08-17 11:38 | IWM | IWM260918P00289000 | put | 289.0000 | 2026-09-18 | 2.0000 | 1.9600 | 2.0100 | 303.4600 | 452817.00 | 395817.00 | 56200.00 | 2265 | 68 | 2301 | 26298 | 0.0874971480720967 | 0.207184396562581 | 0.207478867401587 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78377484640.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78377484640.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78377484640.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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 78377484640.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |