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_alerts474,253 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 |
|---|
| 9fd79f53-bdec-410e-8457-66d2aaa565ae | 2026-08-18 12:15 | 2026-08-18 12:15 | 2026-08-18 12:15 | EWY | EWY261016C00190000 | call | 190.0000 | 2026-10-16 | 8.2100 | 8.2000 | 8.6000 | 171.2397 | 50052.00 | 0.00 | 50052.00 | 61 | 7 | 81 | 14846 | 0.00545601508823926 | 0.536437819383073 | 0.535664737163015 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 26836573555.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d93a0f6-b11c-4acf-b01a-518df60d1fa0 | 2026-08-18 12:15 | 2026-08-18 12:15 | 2026-08-18 12:15 | EWY | EWY270617C00150000 | call | 150.0000 | 2027-06-17 | 40.9200 | 40.6000 | 43.5000 | 171.2406 | 61380.00 | 36900.00 | 24480.00 | 15 | 5 | 36 | 95 | 0.378947368421053 | 0.453956938415685 | 0.453956938415685 | false | false | false | true | ||||||||||||||||
| 23064053-0af9-477a-83ac-84ebc9069da6 | 2026-08-18 12:10 | 2026-08-18 12:10 | 2026-08-18 12:10 | EWY | EWY270115C00200000 | call | 200.0000 | 2027-01-15 | 11.9500 | 11.8000 | 12.9000 | 171.6095 | 20310.00 | 7140.00 | 11980.00 | 17 | 7 | 68 | 12262 | 0.00554558799543305 | 0.477437284931684 | 0.47505700433828 | true | false | false | true | ||||||||||||||||
| 0c7c81d6-ce0b-4757-a22f-07cc97de0c7a | 2026-08-18 11:48 | 2026-08-18 11:48 | 2026-08-18 11:48 | EWY | EWY270617C00190000 | call | 190.0000 | 2027-06-17 | 23.5700 | 23.2000 | 24.5000 | 171.9000 | 25930.00 | 14150.00 | 11780.00 | 11 | 6 | 155 | 122 | 1.27049180327869 | 0.456276973238875 | 0.452906582239873 | false | false | false | true | ||||||||||||||||
| dcb7491d-5a31-4006-9437-c3dedcedf706 | 2026-08-18 11:20 | 2026-08-18 11:20 | 2026-08-18 11:20 | EWY | EWY270617C00205000 | call | 205.0000 | 2027-06-17 | 18.6700 | 18.6000 | 20.6000 | 171.3000 | 35470.00 | 3760.00 | 31710.00 | 19 | 6 | 22 | 129 | 0.170542635658915 | 0.456857665062989 | 0.453611368060893 | false | false | false | true | ||||||||||||||||
| 80c75a1c-882c-42d7-b5c1-ed8e0510efc7 | 2026-08-18 09:53 | 2026-08-18 09:53 | 2026-08-18 09:53 | EWY | EWY280121C00315000 | call | 315.0000 | 2028-01-21 | 10.7500 | 9.2000 | 12.8000 | 175.3750 | 34410.00 | 18360.00 | 16050.00 | 32 | 7 | 44 | 50 | 0.88 | 0.455834251119421 | 0.455927086190966 | false | false | false | true | ||||||||||||||||
| 23711f0f-3f7f-4ce3-ae57-a72d3ea56e1d | 2026-08-17 10:26 | 2026-08-17 10:26 | 2026-08-17 10:26 | EWY | EWY270617P00165000 | put | 165.0000 | 2027-06-17 | 21.1600 | 19.8000 | 22.8000 | 186.7200 | 103660.00 | 57240.00 | 46420.00 | 49 | 7 | 62 | 1840 | 0.033695652173913 | 0.529496373030654 | 0.529496373030654 | false | false | false | true | ||||||||||||||||
| b692c369-4287-476e-b8d1-c20006094950 | 2026-08-17 10:26 | 2026-08-17 10:26 | 2026-08-17 10:26 | EWY | EWY261016P00150000 | put | 150.0000 | 2026-10-16 | 3.3900 | 3.0000 | 3.4000 | 186.7400 | 141078.00 | 135958.00 | 5120.00 | 416 | 42 | 454 | 20208 | 0.0224663499604117 | 0.572776541598503 | 0.572776541598503 | false | false | false | true | ||||||||||||||||
| 40b18b20-fdc4-48d6-b07e-25f34f3f1390 | 2026-08-17 09:51 | 2026-08-17 09:51 | 2026-08-17 09:51 | EWY | EWY260918C00195000 | call | 195.0000 | 2026-09-18 | 8.0000 | 7.5000 | 8.1000 | 185.8899 | 1707901.00 | 1707101.00 | 800.00 | 2135 | 55 | 2188 | 8084 | 0.270658090054428 | 0.523746904315173 | 0.523746904315173 | false | false | false | true | ||||||||||||||||
| 2248faae-e962-4aa3-966b-2b150dcd7357 | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | EWY | EWY270617C00215000 | call | 215.0000 | 2027-06-17 | 21.6500 | 20.8000 | 23.4000 | 184.6750 | 138530.00 | 75600.00 | 62930.00 | 64 | 5 | 64 | 6 | 10.6666666666667 | 0.451592743058034 | 0.450100306768156 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |