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 | expirydate |
|---|
| 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 |
|---|
| 64d3b852-4789-495d-8584-258c38dd46a0 | 2026-09-30 13:28 | 2026-09-30 13:28 | 2026-09-30 13:28 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.4200 | 3.4200 | 3.4300 | 766.6990 | 13338.00 | 0.00 | 13338.00 | 39 | 5 | 58133 | 7931 | 7.32984491236918 | 0.199750278812814 | 0.199750278812814 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 811183218780.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T17:35:36.166637Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 81113760-30c9-4cb7-b802-0c3d3c995546 | 2026-09-30 13:37 | 2026-09-30 13:37 | 2026-09-30 13:37 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.0100 | 3.0100 | 3.0300 | 767.0000 | 27692.00 | 0.00 | 27692.00 | 92 | 6 | 59172 | 7931 | 7.46084982978187 | 0.179646954745036 | 0.179646954745036 | false | false | false | true | ||||||||||||||||
| 28ca7841-b125-456b-9797-aa769fde8f40 | 2026-09-30 13:43 | 2026-09-30 13:43 | 2026-09-30 13:43 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.6700 | 2.6650 | 2.6900 | 767.5050 | 24844.00 | 0.00 | 24576.00 | 93 | 5 | 60393 | 7931 | 7.6148026730551 | 0.196079945957899 | 0.192626645730151 | false | false | false | true | ||||||||||||||||
| b56f060e-e843-42ad-bd48-8004eb1bcbe0 | 2026-09-30 13:44 | 2026-09-30 13:44 | 2026-09-30 13:44 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.7700 | 2.7600 | 2.7700 | 767.4200 | 12465.00 | 12465.00 | 0.00 | 45 | 5 | 60561 | 7931 | 7.63598537384945 | 0.202693398620228 | 0.202693398620228 | false | false | false | true | ||||||||||||||||
| 16a8464d-c5fa-420e-91d1-17443ab9ba0d | 2026-09-30 13:45 | 2026-09-30 13:45 | 2026-09-30 13:45 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.8700 | 2.8600 | 2.8700 | 767.3100 | 21525.00 | 21525.00 | 0.00 | 75 | 8 | 60933 | 7931 | 7.68288992560837 | 0.205684975524589 | 0.205684975524589 | false | false | false | true | ||||||||||||||||
| 397bef83-aab8-4ce5-b73d-733847fcfbe6 | 2026-09-30 13:45 | 2026-09-30 13:45 | 2026-09-30 13:45 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.8100 | 2.8100 | 2.8200 | 767.3300 | 39060.00 | 282.00 | 38778.00 | 139 | 6 | 61101 | 7931 | 7.70407262640272 | 0.189860288736573 | 0.189860288736573 | false | false | false | true | ||||||||||||||||
| b4016ced-8b3d-4495-95b9-086407a37ef8 | 2026-09-30 13:51 | 2026-09-30 13:50 | 2026-09-30 13:50 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.3900 | 2.3800 | 2.3900 | 767.8400 | 23900.00 | 23900.00 | 0.00 | 100 | 7 | 61684 | 7931 | 7.77758164165931 | 0.197684468721922 | 0.197684468721922 | false | false | false | true | ||||||||||||||||
| e795066c-efe7-4a5f-8ce0-694292fb62cf | 2026-09-30 13:51 | 2026-09-30 13:51 | 2026-09-30 13:51 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.3500 | 2.3300 | 2.3500 | 767.8900 | 27965.00 | 27965.00 | 0.00 | 119 | 5 | 61835 | 7931 | 7.79662085487328 | 0.198032441508248 | 0.198032441508248 | true | false | false | true | ||||||||||||||||
| a4f91faa-2799-4247-8156-146c40ba57ca | 2026-09-30 13:51 | 2026-09-30 13:51 | 2026-09-30 13:51 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.4100 | 2.4100 | 2.4200 | 767.8250 | 14430.00 | 0.00 | 14430.00 | 60 | 7 | 62005 | 7931 | 7.81805573067709 | 0.197636112041789 | 0.200783220120425 | false | false | false | true | ||||||||||||||||
| afbba77d-ae6b-4517-8e19-18195883dcf7 | 2026-09-30 14:00 | 2026-09-30 14:00 | 2026-09-30 14:00 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.7800 | 2.7700 | 2.7900 | 767.3400 | 20850.00 | 0.00 | 13344.00 | 75 | 5 | 62788 | 7931 | 7.91678224687933 | 0.192362868594833 | 0.192362868594833 | false | false | false | true | ||||||||||||||||
| 7f372c37-eef0-43eb-a74f-db1cf9311081 | 2026-09-30 14:04 | 2026-09-30 14:04 | 2026-09-30 14:04 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 2.8500 | 2.8500 | 2.8600 | 767.2500 | 11400.00 | 0.00 | 11400.00 | 40 | 8 | 63202 | 7931 | 7.96898247383684 | 0.190380517532062 | 0.190380517532062 | false | false | false | true | ||||||||||||||||
| 4dc8329c-a45f-4df0-b3b2-1054a5e47317 | 2026-09-30 14:24 | 2026-09-30 14:24 | 2026-09-30 14:24 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.3800 | 3.3600 | 3.3900 | 766.6900 | 33824.00 | 21018.00 | 0.00 | 100 | 5 | 65017 | 7931 | 8.19783129491867 | 0.213277461204746 | 0.227064867530695 | true | false | false | true | ||||||||||||||||
| fd3436dc-9b48-45a7-9eee-036d92cd312a | 2026-09-30 14:33 | 2026-09-30 14:33 | 2026-09-30 14:33 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.9300 | 3.9300 | 3.9400 | 766.1350 | 11397.00 | 0.00 | 11397.00 | 29 | 5 | 65796 | 7931 | 8.29605346110201 | 0.256981436858951 | 0.256981436858951 | false | false | false | true | ||||||||||||||||
| 8db8feaa-c699-4335-8c9e-8f6167aeb9aa | 2026-09-30 14:51 | 2026-09-30 14:51 | 2026-09-30 14:51 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.8500 | 3.8500 | 3.8600 | 766.0000 | 38500.00 | 0.00 | 38500.00 | 100 | 5 | 67256 | 7931 | 8.4801412180053 | 0.259656242248231 | 0.259656242248231 | false | false | false | true | ||||||||||||||||
| 94541883-eb82-434a-b9e6-8e2c07da28dc | 2026-09-30 15:36 | 2026-09-30 15:36 | 2026-09-30 15:36 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 3.8400 | 3.8200 | 3.8500 | 766.2100 | 12656.00 | 11120.00 | 0.00 | 33 | 10 | 69153 | 7931 | 8.71932921447485 | 0.437064922543528 | 0.456448266286746 | false | false | false | true | ||||||||||||||||
| 8105709c-833c-474a-89e3-7647c8c6848b | 2026-09-30 15:53 | 2026-09-30 15:53 | 2026-09-30 15:53 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 5.2100 | 5.1700 | 5.2200 | 764.0000 | 27607.00 | 25006.00 | 521.00 | 53 | 19 | 69907 | 7931 | 8.81439919303997 | 0 | 0 | false | false | false | true | false | |||||||||||||||
| 318f96ff-aaf2-44ac-9490-bda72d20e8f7 | 2026-09-30 15:55 | 2026-09-30 15:55 | 2026-09-30 15:55 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 6.2800 | 6.2800 | 6.2900 | 763.6500 | 52752.00 | 0.00 | 52752.00 | 84 | 6 | 70313 | 7931 | 8.86559071995965 | 0 | 0 | false | false | false | true | false | |||||||||||||||
| e3bea541-3aef-4aea-a2be-4d79d0907b64 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 6.1000 | 6.0700 | 6.1200 | 763.8700 | 20737.00 | 20737.00 | 0.00 | 34 | 12 | 70602 | 7931 | 8.90203000882613 | 0 | 0 | false | false | false | true | false | |||||||||||||||
| 84b68cbe-69b1-4afb-aafd-e865f6cca83c | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 6.0800 | 6.0600 | 6.0900 | 763.8700 | 10337.00 | 10337.00 | 0.00 | 17 | 6 | 70622 | 7931 | 8.90455175892069 | 0 | 0 | false | false | false | true | false | |||||||||||||||
| 3c6803ee-5537-4cb0-81c2-91301ff03348 | 2026-09-30 15:56 | 2026-09-30 15:56 | 2026-09-30 15:56 | SPY | SPY260930P00770000 | put | 770.0000 | 2026-09-30 | 6.0400 | 6.0200 | 6.0500 | 763.9400 | 12083.00 | 12083.00 | 0.00 | 20 | 8 | 70645 | 7931 | 8.90745177152944 | 0.564446447496993 | 0.564446447496993 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:42:40.626650Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:48:42.017267Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:48:42.017267Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:48:42.017267Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:48:42.017267Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:55:15.856475Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:55:15.856475Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:55:15.856475Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:03:32.794352Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:11:38.489909Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:26:32.922967Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:39:35.869440Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:54:12.320411Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:54:17.966040Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 811183218780.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |