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 |
|---|
| 482663af-cc8e-4062-8747-755242eb4eec | 2026-09-09 11:10 | 2026-09-09 11:10 | 2026-09-09 11:10 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 20.4000 | 20.3300 | 20.4100 | 762.2600 | 407904.00 | 338544.00 | 69360.00 | 200 | 17 | 394 | 19286 | 0.0204293269729337 | 0.158251020596385 | 0.158149861413402 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 810275044553.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5705eb86-d069-4749-878b-1fcee18df7a2 | 2026-09-09 11:14 | 2026-09-09 11:14 | 2026-09-09 11:14 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 20.6800 | 20.5900 | 20.6800 | 761.6950 | 310186.00 | 310186.00 | 0.00 | 150 | 8 | 551 | 19286 | 0.0285699471118946 | 0.158513202153048 | 0.158412375985442 | false | false | false | |||||||||||||||||
| ca23e362-df6c-43bf-8d79-e16be4aac1ad | 2026-09-11 14:45 | 2026-09-11 14:45 | 2026-09-11 14:45 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 18.7400 | 18.6900 | 18.7400 | 765.1750 | 417897.00 | 410405.00 | 3746.00 | 223 | 10 | 2481 | 15471 | 0.16036455303471 | 0.156457734490932 | 0.156405701961546 | false | false | false | |||||||||||||||||
| 95895e7f-14fc-4f05-9837-df434c38f063 | 2026-09-14 09:31 | 2026-09-14 09:31 | 2026-09-14 09:31 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 21.5500 | 21.5200 | 21.6100 | 758.8200 | 170276.00 | 163811.00 | 6465.00 | 79 | 8 | 161 | 17943 | 0.00897285849634955 | 0.161996962082025 | 0.161931448051111 | false | false | false | |||||||||||||||||
| 322e9507-8849-4d56-b306-d66f460e0929 | 2026-09-16 15:11 | 2026-09-16 15:11 | 2026-09-16 15:11 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 24.1100 | 24.1000 | 24.1700 | 752.2600 | 137416.00 | 0.00 | 137416.00 | 57 | 12 | 688 | 15491 | 0.0444128849009102 | 0.1601989328992 | 0.160257840407943 | false | false | false | |||||||||||||||||
| 3cbd7795-a052-4237-8005-0b9b670ede74 | 2026-09-16 15:12 | 2026-09-16 15:12 | 2026-09-16 15:12 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 24.2300 | 24.2200 | 24.2500 | 752.0200 | 109027.00 | 0.00 | 99331.00 | 45 | 5 | 1306 | 15491 | 0.0843070169775999 | 0.160417799798219 | 0.16028561613788 | false | false | false | |||||||||||||||||
| 76c61dee-19f2-47a8-b972-41078dccca6c | 2026-09-16 15:12 | 2026-09-16 15:12 | 2026-09-16 15:12 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 24.1800 | 24.1800 | 24.2500 | 752.1399 | 261172.00 | 0.00 | 261172.00 | 108 | 18 | 1573 | 15491 | 0.101542831321412 | 0.160313079328582 | 0.160469980752646 | false | false | false | |||||||||||||||||
| 5ae42ec0-e2c9-4988-8c91-e332a9096a8d | 2026-09-16 15:15 | 2026-09-16 15:15 | 2026-09-16 15:15 | SPY | SPY261218P00760000 | put | 760.0000 | 2026-12-18 | 24.5100 | 24.5000 | 24.6700 | 751.5700 | 230357.00 | 0.00 | 230357.00 | 94 | 5 | 2442 | 15491 | 0.157639919953521 | 0.160479774066346 | 0.160694615204233 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 797118136526.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 797118136526.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 797118136526.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 797118136526.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |