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.
Simplify Analyticsuw_flow_alerts375,978 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 |
|---|
| 552b33ce-767c-40a9-93b0-f6bd2af1daf5 | 2026-08-17 16:02 | 2026-08-17 16:02 | 2026-08-17 16:02 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 1.8300 | 1.8200 | 1.8700 | 304.0700 | 1060699.00 | 0.00 | 1060699.00 | 5801 | 84 | 14053 | 16623 | 0.84539493472899 | 0.213282401449581 | 0.212847216527474 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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 |
| 3645b542-3e96-4bf2-9090-586db4d28eb2 | 2026-08-17 16:02 | 2026-08-17 16:02 | 2026-08-17 16:02 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 1.8200 | 1.8200 | 1.8500 | 304.0700 | 291594.00 | 0.00 | 291594.00 | 1602 | 20 | 15857 | 16623 | 0.953919268483427 | 0.213282401449581 | 0.212847216527474 | false | false | false | true | ||||||||||||||||
| 5e2b143e-50ff-411f-b66b-9b1658f9f01e | 2026-08-18 10:15 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.2400 | 2.2300 | 2.2800 | 301.8250 | 781214.00 | 0.00 | 781214.00 | 3492 | 45 | 42034 | 16574 | 2.53614094364668 | 0.21596236061065 | 0.215560639081821 | false | false | false | true | ||||||||||||||||
| 4fdc44c0-0c48-4a24-acf2-d50bf31e76cb | 2026-08-18 10:15 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.2300 | 2.2300 | 2.2700 | 301.8400 | 617264.00 | 0.00 | 617264.00 | 2768 | 11 | 47699 | 16574 | 2.87794135392784 | 0.21560152367766 | 0.215683282703941 | false | false | false | true | ||||||||||||||||
| 45d0ebcd-e1da-4842-80ed-a1ef79fb5857 | 2026-08-18 10:15 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.2400 | 2.2300 | 2.2700 | 301.8250 | 648529.00 | 0.00 | 648529.00 | 2897 | 11 | 44931 | 16574 | 2.71093278629178 | 0.21596236061065 | 0.215560639081821 | false | false | false | true | ||||||||||||||||
| 187b1856-6db7-440c-84d6-4c739c10b209 | 2026-08-18 10:15 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.2300 | 2.2300 | 2.2700 | 301.8400 | 635773.00 | 0.00 | 635773.00 | 2851 | 8 | 50550 | 16574 | 3.04995776517437 | 0.215683282703941 | 0.215683282703941 | false | false | false | true | ||||||||||||||||
| 15687cc5-4cd8-453f-8998-85058fe4475e | 2026-08-18 10:15 | 2026-08-18 10:14 | 2026-08-18 10:14 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.2300 | 2.2300 | 2.2700 | 301.8400 | 600539.00 | 0.00 | 600539.00 | 2693 | 8 | 53243 | 16574 | 3.21244117292144 | 0.215683282703941 | 0.215683282703941 | false | false | false | true | ||||||||||||||||
| f926df81-2166-4155-a43e-9eac402d7788 | 2026-08-18 10:29 | 2026-08-18 10:28 | 2026-08-18 10:28 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.1400 | 2.0900 | 2.1500 | 302.2800 | 1283090.00 | 1250230.00 | 0.00 | 6000 | 5 | 76049 | 16574 | 4.58845179196332 | 0.2147828002705 | 0.2147828002705 | false | false | false | true | ||||||||||||||||
| f1daca38-3850-4043-8621-f3eb40f5a62e | 2026-08-18 10:30 | 2026-08-18 10:30 | 2026-08-18 10:30 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.1600 | 2.1100 | 2.1600 | 302.2400 | 648000.00 | 648000.00 | 0.00 | 3000 | 12 | 79049 | 16574 | 4.76945818752263 | 0.216097808638036 | 0.216097808638036 | true | false | false | true | ||||||||||||||||
| aa67a41a-110c-47d0-8de9-e9e08102eb58 | 2026-08-18 11:02 | 2026-08-18 11:02 | 2026-08-18 11:02 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.3300 | 2.3200 | 2.3800 | 301.1000 | 316181.00 | 0.00 | 316181.00 | 1357 | 63 | 80842 | 16574 | 4.87763967660191 | 0.213545225268302 | 0.213545225268302 | false | false | false | true | ||||||||||||||||
| 010cd527-9f0a-4fa0-8a21-da45b5e3f358 | 2026-08-18 11:03 | 2026-08-18 11:02 | 2026-08-18 11:02 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.3100 | 2.3100 | 2.3500 | 301.1400 | 119427.00 | 0.00 | 119427.00 | 517 | 26 | 81507 | 16574 | 4.91776276095089 | 0.213091962645823 | 0.213091962645823 | false | false | false | true | ||||||||||||||||
| c28ecb01-f40a-48fb-9395-e8e050269531 | 2026-08-18 15:39 | 2026-08-18 15:38 | 2026-08-18 15:38 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.3700 | 2.3600 | 2.3700 | 300.6450 | 2844000.00 | 2844000.00 | 0.00 | 12000 | 5 | 94218 | 16574 | 5.68468685893568 | 0.211289851890333 | 0.211289851890333 | true | false | false | true | ||||||||||||||||
| b55d6bda-0aff-47b0-8111-95d4cec38adc | 2026-08-18 15:39 | 2026-08-18 15:39 | 2026-08-18 15:39 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.3700 | 2.3700 | 2.3800 | 300.6500 | 218988.00 | 0.00 | 218988.00 | 924 | 15 | 95143 | 16574 | 5.74049716423314 | 0.211332030241582 | 0.211332030241582 | false | false | false | true | ||||||||||||||||
| d962343a-54cd-4328-870b-bca4725f5900 | 2026-08-19 16:09 | 2026-08-19 16:09 | 2026-08-19 16:09 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 1.9200 | 1.9200 | 1.9700 | 301.6900 | 192000.00 | 0.00 | 192000.00 | 1000 | 8 | 46085 | 39157 | 1.17692877391016 | 0.204761553079301 | 0.204761553079301 | false | false | false | true | ||||||||||||||||
| 95608bb8-4b6b-4233-957c-d5c351148c92 | 2026-09-02 11:07 | 2026-09-02 11:07 | 2026-09-02 11:07 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.7700 | 2.7700 | 2.8100 | 292.7100 | 138777.00 | 0.00 | 138777.00 | 501 | 5 | 14187 | 66772 | 0.212469298508357 | 0.20384904831869 | 0.20384904831869 | false | false | false | true | ||||||||||||||||
| 802084cf-506e-4b94-8469-02a73b0f8472 | 2026-09-02 11:46 | 2026-09-02 11:45 | 2026-09-02 11:45 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.7300 | 2.7000 | 2.7500 | 292.8200 | 122850.00 | 61152.00 | 61698.00 | 450 | 9 | 16596 | 66772 | 0.248547295273468 | 0.203524171436474 | 0.203671838182987 | false | false | false | true | ||||||||||||||||
| 359cd71b-a965-48f0-b129-defe5c676754 | 2026-09-02 14:33 | 2026-09-02 14:33 | 2026-09-02 14:33 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.3700 | 2.3600 | 2.3800 | 293.9500 | 319950.00 | 35313.00 | 284637.00 | 1350 | 21 | 25394 | 66772 | 0.380309111603666 | 0.20322776071356 | 0.20322776071356 | true | false | false | true | ||||||||||||||||
| 2e75599c-cc50-4679-b9ac-3b890f02d581 | 2026-09-09 15:00 | 2026-09-09 15:00 | 2026-09-09 15:00 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.7000 | 2.7000 | 2.7300 | 290.8000 | 107460.00 | 0.00 | 107460.00 | 398 | 7 | 2067 | 71034 | 0.0290987414477574 | 0.223591593605873 | 0.223591593605873 | true | false | false | true | ||||||||||||||||
| 4fc902af-51d0-4db5-b1a9-88d58b3c8fcb | 2026-09-09 15:25 | 2026-09-09 15:25 | 2026-09-09 15:25 | IWM | IWM260918P00288000 | put | 288.0000 | 2026-09-18 | 2.7000 | 2.6700 | 2.7000 | 290.8600 | 133650.00 | 133650.00 | 0.00 | 495 | 8 | 3020 | 71034 | 0.0425148520426838 | 0.224887876304389 | 0.224887876304389 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 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-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 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-18T14:15:30.654866Z"} |
| 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-18T14:15:30.654866Z"} |
| 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-18T14:32:52.256663Z"} |
| 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-18T14:32:52.256663Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T15:04:03.259366Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-18T19:46:05.553268Z"} |
| 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-20T13:30:24.310264Z"} |
| 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-09-02T15:25:17.297093Z"} |
| 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-09-02T15:49:54.253343Z"} |
| 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-09-02T18:39:55.300995Z"} |
| 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-09T19:27:55.926703Z"} |
| 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-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |