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_alerts523,327 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 |
|---|
| 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 |
|---|
| 73dfc7dc-dcc2-450f-8f94-c03025fa6ee6 | 2026-09-25 11:46 | 2026-09-25 11:46 | 2026-09-25 11:46 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.1700 | 0.1700 | 0.1800 | 767.6400 | 17001.00 | 18.00 | 16983.00 | 1000 | 16 | 202164 | 9457 | 21.3771809241831 | 0.218803270776099 | 0.215438890163133 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 818687275738.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T15:51:49.898119Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 29e5a2da-28c8-42f3-b298-9eba413d7cf6 | 2026-09-25 10:31 | 2026-09-25 10:31 | 2026-09-25 10:31 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.3100 | 0.3000 | 0.3100 | 767.4200 | 11090.00 | 10850.00 | 240.00 | 358 | 7 | 80061 | 9457 | 8.46579253463043 | 0.218669054256016 | 0.216355424503417 | false | false | false | |||||||||||||||||
| abd1e7d6-a0bd-4230-821c-df6db48d1852 | 2026-09-25 10:23 | 2026-09-25 10:23 | 2026-09-25 10:23 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.3000 | 0.2900 | 0.3100 | 767.6300 | 10977.00 | 30.00 | 10947.00 | 366 | 9 | 73483 | 9457 | 7.7702231151528 | 0.219723092359821 | 0.220699861874913 | true | false | false | |||||||||||||||||
| 8cb12f38-5b1f-40d7-b62c-002a66bcf11c | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.4900 | 0.4800 | 0.5000 | 766.6800 | 10047.00 | 198.00 | 9849.00 | 205 | 13 | 61305 | 9457 | 6.48249973564555 | 0.225462360442479 | 0.22437220552216 | false | false | false | |||||||||||||||||
| 6f060440-6b91-495c-823e-aa6863fd520e | 2026-09-25 10:06 | 2026-09-25 10:06 | 2026-09-25 10:06 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 0.5000 | 0.4900 | 0.5100 | 766.8000 | 36099.00 | 36001.00 | 98.00 | 722 | 17 | 47028 | 9457 | 4.97282436290578 | 0.228754318642568 | 0.227491366929764 | false | false | false | |||||||||||||||||
| cc301e3b-250a-40e5-ba90-047768ec1745 | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.1600 | 2.1500 | 2.1700 | 763.4600 | 10588.00 | 868.00 | 0.00 | 49 | 5 | 27458 | 4611 | 5.95489047928866 | 0.152608107608691 | 0.151978107501393 | false | false | false | |||||||||||||||||
| 5cd36ae9-556c-44d7-810d-2702647e361f | 2026-09-24 11:32 | 2026-09-24 11:32 | 2026-09-24 11:32 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.1600 | 2.1600 | 2.1800 | 763.4600 | 283204.00 | 3052.00 | 280152.00 | 1311 | 31 | 27409 | 4611 | 5.944263717198 | 0.153238087093448 | 0.151978107501393 | false | false | false | |||||||||||||||||
| 278da4e7-900a-4d61-989f-95590d7a80a8 | 2026-09-24 11:23 | 2026-09-24 11:22 | 2026-09-24 11:23 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.8900 | 1.8900 | 1.9100 | 764.0000 | 11557.00 | 573.00 | 10984.00 | 61 | 10 | 23487 | 4611 | 5.09368900455433 | 0.151950546069546 | 0.153265860602575 | false | false | false | |||||||||||||||||
| c9a91b74-6e2e-4ce6-b26c-97399219661e | 2026-09-24 11:15 | 2026-09-24 11:15 | 2026-09-24 11:15 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 2.1500 | 2.1500 | 2.1800 | 763.5700 | 13547.00 | 0.00 | 13547.00 | 63 | 6 | 20833 | 4611 | 4.51810887009326 | 0.155507957585283 | 0.154534292023835 | false | false | false | |||||||||||||||||
| a7ff21cc-ca11-4add-8316-716fb911846e | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.5900 | 1.5800 | 1.5900 | 764.8600 | 36048.00 | 28938.00 | 7110.00 | 227 | 38 | 13570 | 4611 | 2.94296248102364 | 0.152937415992939 | 0.152937415992939 | false | false | false | |||||||||||||||||
| e28aa381-86d8-4075-8744-f3c72c967933 | 2026-09-24 10:55 | 2026-09-24 10:54 | 2026-09-24 10:54 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.5700 | 1.5600 | 1.5800 | 764.8794 | 20910.00 | 19818.00 | 1092.00 | 133 | 13 | 12947 | 4611 | 2.80785079158534 | 0.152755233631367 | 0.152094954687457 | false | false | false | |||||||||||||||||
| 6d351465-79c3-4410-9de5-47b4241b935a | 2026-09-24 10:47 | 2026-09-24 10:47 | 2026-09-24 10:47 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4200 | 1.4200 | 1.4400 | 765.0000 | 15633.00 | 144.00 | 13916.00 | 110 | 25 | 11691 | 4611 | 2.53545868575146 | 0.15186875473134 | 0.151810078807766 | false | false | false | |||||||||||||||||
| a75b5299-e623-4005-beea-c54f9834b18d | 2026-09-24 10:47 | 2026-09-24 10:47 | 2026-09-24 10:47 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4500 | 1.4500 | 1.4700 | 765.0000 | 15108.00 | 588.00 | 14520.00 | 104 | 21 | 11319 | 4611 | 2.45478204294079 | 0.15214732788001 | 0.151593722971197 | true | false | false | |||||||||||||||||
| 86b46404-69f5-47c4-8d8e-214afa3d5635 | 2026-09-24 10:45 | 2026-09-24 10:45 | 2026-09-24 10:45 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4400 | 1.4300 | 1.4400 | 765.2400 | 27697.00 | 14112.00 | 13585.00 | 193 | 29 | 9458 | 4611 | 2.05118195619172 | 0.15210229499991 | 0.15210229499991 | true | false | false | |||||||||||||||||
| f1d65807-fbc3-401b-873e-4a2c48ec9e1e | 2026-09-24 10:45 | 2026-09-24 10:45 | 2026-09-24 10:45 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4300 | 1.4200 | 1.4300 | 765.2400 | 12282.00 | 10010.00 | 2272.00 | 86 | 21 | 9016 | 4611 | 1.95532422468011 | 0.151898645224857 | 0.151427889804118 | false | false | false | |||||||||||||||||
| 4870b208-93bc-44a5-bfc2-dd1ebbddfc18 | 2026-09-24 10:45 | 2026-09-24 10:44 | 2026-09-24 10:45 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4200 | 1.4100 | 1.4200 | 765.2900 | 15037.00 | 12922.00 | 2115.00 | 106 | 10 | 8930 | 4611 | 1.93667317284754 | 0.151927316435136 | 0.151927316435136 | false | false | false | |||||||||||||||||
| 2daaa96f-cd07-41e0-909a-1555d377b2fd | 2026-09-24 10:45 | 2026-09-24 10:45 | 2026-09-24 10:45 | SPY | SPY260925P00763000 | put | 763.0000 | 2026-09-25 | 1.4300 | 1.4300 | 1.4400 | 765.2400 | 27264.00 | 13536.00 | 13728.00 | 190 | 20 | 9260 | 4611 | 2.00824116243765 | 0.15210229499991 | 0.15210229499991 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:33:57.900979Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:17:27.635758Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 818687275738.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:06:13.706447Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:16:59.605616Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:50:12.704684Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:50:12.704684Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803942864100.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |