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 |
|---|
| 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 |
|---|
| 5938b867-9eb4-4c77-9305-19419fa2280d | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.5200 | 1.5200 | 1.5300 | 773.2975 | 31313.00 | 153.00 | 31160.00 | 206 | 8 | 18298 | 2694 | 6.79213066072754 | 0.112824902504236 | 0.112200131993627 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 803326731841.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 5cab3947-da4f-4c73-8702-414d27abfb1d | 2026-09-22 12:48 | 2026-09-22 12:48 | 2026-09-22 12:48 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.3700 | 1.3500 | 1.3600 | 773.3400 | 25845.00 | 25845.00 | 0.00 | 189 | 8 | 47717 | 2694 | 17.7123236822569 | 0.104404291576874 | 0.101015488220228 | true | false | false | |||||||||||||||||
| f1bde484-e49b-4a4c-bf1b-08f33221779a | 2026-09-22 14:01 | 2026-09-22 14:01 | 2026-09-22 14:01 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.6400 | 1.6300 | 1.6500 | 773.9000 | 11950.00 | 0.00 | 11950.00 | 73 | 5 | 64118 | 2694 | 23.800296956199 | 0.101977776915039 | 0.101358974714809 | false | false | false | |||||||||||||||||
| cda840cb-b9c9-4384-99d2-315f56169f87 | 2026-09-22 15:23 | 2026-09-22 15:22 | 2026-09-22 15:22 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.6600 | 1.6600 | 1.6800 | 774.1400 | 35031.00 | 0.00 | 34196.00 | 211 | 5 | 81028 | 2694 | 30.0772086117298 | 0.0962356873061563 | 0.0956159577064181 | false | false | false | |||||||||||||||||
| 90de5d6c-6768-4194-83e4-db5b612c16ce | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.5200 | 1.5200 | 1.5300 | 773.7250 | 102753.00 | 153.00 | 102600.00 | 676 | 5 | 97876 | 2694 | 36.3311061618411 | 0.100337481019929 | 0.0998674082021619 | false | false | false | |||||||||||||||||
| 3d1c24a8-b0be-4dfc-a443-47367c2fb96d | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.4500 | 1.4300 | 1.4600 | 773.0000 | 16085.00 | 145.00 | 15220.00 | 111 | 5 | 100398 | 2694 | 37.2672605790646 | 0.101245080608684 | 0.100623368948243 | false | false | false | |||||||||||||||||
| 2ebaed0e-f86a-4010-8b05-50b625d0b670 | 2026-09-22 16:06 | 2026-09-22 16:05 | 2026-09-22 16:05 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 1.3400 | 1.3300 | 1.3500 | 773.0000 | 133605.00 | 134.00 | 133471.00 | 1000 | 28 | 105357 | 2694 | 39.1080178173719 | 0.0952619571288172 | 0.0946393666231481 | true | false | false | |||||||||||||||||
| a1ffcf9d-a1a5-4276-ab28-b9adcc7e1d02 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | SPY | SPY260923C00774000 | call | 774.0000 | 2026-09-23 | 0.1500 | 0.1500 | 0.1600 | 770.0000 | 15032.00 | 32.00 | 15000.00 | 1002 | 11 | 105279 | 10801 | 9.74715304138506 | 0.154813925602887 | 0.151993842157682 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 803326731841.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 806184418262.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:55:11.622050Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |