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_alerts609,118 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 |
|---|
| 57e7c6a0-95ee-485b-93ab-9cb1cb0d234f | 2026-08-19 12:15 | 2026-08-19 12:15 | 2026-08-19 12:15 | EWY | EWY260828C00184000 | call | 184.0000 | 2026-08-28 | 2.8900 | 2.7000 | 2.9000 | 174.7250 | 36420.00 | 36420.00 | 0.00 | 126 | 8 | 322 | 1792 | 0.1796875 | 0.5699786258998 | 0.575207786959708 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 26836573555.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 07f3bccb-e12a-413b-882f-a40b58765b05 | 2026-08-19 11:57 | 2026-08-19 11:57 | 2026-08-19 11:57 | EWY | EWY260918C00200000 | call | 200.0000 | 2026-09-18 | 2.8000 | 2.8000 | 2.9500 | 174.1700 | 40605.00 | 0.00 | 40605.00 | 145 | 20 | 10198 | 27550 | 0.37016333938294 | 0.52347002485279 | 0.52347002485279 | true | false | false | true | ||||||||||||||||
| a1363835-56f0-493f-b45b-291a3ed47bfb | 2026-08-19 11:39 | 2026-08-19 11:38 | 2026-08-19 11:38 | EWY | EWY260918C00200000 | call | 200.0000 | 2026-09-18 | 2.8200 | 2.8000 | 2.9500 | 174.0900 | 40349.00 | 0.00 | 40349.00 | 143 | 9 | 6603 | 27550 | 0.23967332123412 | 0.52462478607184 | 0.528851724162266 | true | false | false | true | ||||||||||||||||
| 8a9cc549-3b4a-4603-9294-5bac977260cb | 2026-08-19 09:50 | 2026-08-19 09:50 | 2026-08-19 09:50 | EWY | EWY261120P00170000 | put | 170.0000 | 2026-11-20 | 15.4700 | 14.7000 | 15.6000 | 175.0000 | 154708.00 | 154708.00 | 0.00 | 100 | 13 | 202 | 283 | 0.713780918727915 | 0.53996850249071 | 0.541148571306114 | false | false | false | true | ||||||||||||||||
| fd7c0bb9-e879-4444-a0fa-cf380d231423 | 2026-08-18 14:16 | 2026-08-18 14:16 | 2026-08-18 14:16 | EWY | EWY270617C00225000 | call | 225.0000 | 2027-06-17 | 14.3800 | 13.7000 | 15.7000 | 170.6000 | 17260.00 | 7240.00 | 10020.00 | 12 | 7 | 14 | 43 | 0.325581395348837 | 0.467223672708206 | 0.46894296207035 | false | false | false | true | ||||||||||||||||
| 3ff753a8-c549-4196-bd4d-2ebca1f7ca66 | 2026-08-18 14:00 | 2026-08-18 14:00 | 2026-08-18 14:00 | EWY | EWY260918C00183000 | call | 183.0000 | 2026-09-18 | 6.0000 | 5.6000 | 6.4000 | 170.3900 | 982220.00 | 0.00 | 972020.00 | 1637 | 48 | 1637 | 59 | 27.7457627118644 | 0.535944091637434 | 0.536041005199011 | false | false | false | true | ||||||||||||||||
| 39d23bff-0c3d-459e-bd51-1eaa4d4c69da | 2026-08-18 13:05 | 2026-08-18 13:04 | 2026-08-18 13:04 | EWY | EWY260821P00170000 | put | 170.0000 | 2026-08-21 | 3.0000 | 2.9000 | 3.2000 | 171.7886 | 259212.00 | 0.00 | 259212.00 | 864 | 47 | 7481 | 18463 | 0.405188755890159 | 0.622632318210541 | 0.631459198775447 | false | false | false | true | ||||||||||||||||
| b22a2200-0144-40f4-891c-5c418c393c40 | 2026-08-18 11:56 | 2026-08-18 11:56 | 2026-08-18 11:56 | EWY | EWY270617C00170000 | call | 170.0000 | 2027-06-17 | 31.4000 | 31.2000 | 33.0000 | 171.6300 | 75360.00 | 37800.00 | 37560.00 | 24 | 8 | 33 | 1500 | 0.022 | 0.454512699682119 | 0.457877119287337 | false | false | false | true | ||||||||||||||||
| 5a2b341d-f383-4f15-9621-c3ec2cb977ef | 2026-08-18 11:26 | 2026-08-18 11:26 | 2026-08-18 11:26 | EWY | EWY270617C00155000 | call | 155.0000 | 2027-06-17 | 38.2900 | 38.1000 | 39.8000 | 171.4800 | 30630.00 | 15360.00 | 15270.00 | 8 | 5 | 9 | 136 | 0.0661764705882353 | 0.447411108647031 | 0.451108847353147 | false | false | false | true | ||||||||||||||||
| aaecd26e-dbdf-4b53-8530-b29c89c57989 | 2026-08-18 11:21 | 2026-08-18 11:21 | 2026-08-18 11:21 | EWY | EWY270617C00200000 | call | 200.0000 | 2027-06-17 | 20.1300 | 19.1000 | 22.1000 | 171.2800 | 22140.00 | 8080.00 | 14060.00 | 11 | 5 | 18 | 1019 | 0.0176643768400393 | 0.453117878248282 | 0.456342484757374 | false | false | false | true | ||||||||||||||||
| ada89003-ae1d-4428-ad71-17f4c5ee4f4b | 2026-08-18 11:18 | 2026-08-18 11:18 | 2026-08-18 11:18 | EWY | EWY270617C00215000 | call | 215.0000 | 2027-06-17 | 16.4600 | 15.6000 | 16.5000 | 171.5200 | 14810.00 | 14810.00 | 0.00 | 9 | 5 | 62 | 85 | 0.729411764705882 | 0.458684186404909 | 0.460339506814994 | false | false | false | true | ||||||||||||||||
| 0803d4f8-2b74-4f05-ac8a-93b9f54758ab | 2026-08-18 11:18 | 2026-08-18 11:18 | 2026-08-18 11:18 | EWY | EWY270617C00220000 | call | 220.0000 | 2027-06-17 | 15.2000 | 14.2000 | 17.4000 | 171.5900 | 21280.00 | 10710.00 | 10570.00 | 14 | 6 | 14 | 86 | 0.162790697674419 | 0.456116438428991 | 0.459478510327651 | false | false | false | true | ||||||||||||||||
| 5b685f59-4e37-4c50-90cb-e1387a3467f7 | 2026-08-18 11:17 | 2026-08-18 11:17 | 2026-08-18 11:17 | EWY | EWY270617C00190000 | call | 190.0000 | 2027-06-17 | 23.7900 | 22.6000 | 23.8000 | 171.7200 | 192660.00 | 185610.00 | 7050.00 | 81 | 5 | 93 | 122 | 0.762295081967213 | 0.457606546595943 | 0.454399183600007 | false | false | false | true | ||||||||||||||||
| 777d5358-30c9-46f4-b252-0b2e31c72b31 | 2026-08-18 10:40 | 2026-08-18 10:40 | 2026-08-18 10:40 | EWY | EWY260828P00162000 | put | 162.0000 | 2026-08-28 | 2.3000 | 1.6500 | 2.3000 | 173.4800 | 14945.00 | 14945.00 | 0.00 | 65 | 5 | 67 | 17 | 3.94117647058824 | 0.589959675047963 | 0.591124846912324 | false | false | false | true | ||||||||||||||||
| 5810f3db-a660-4ba8-b277-b3b3b602fec6 | 2026-08-18 09:44 | 2026-08-18 09:44 | 2026-08-18 09:44 | EWY | EWY260821C00192000 | call | 192.0000 | 2026-08-21 | 0.3000 | 0.3000 | 0.5000 | 176.0000 | 20815.00 | 0.00 | 20815.00 | 693 | 40 | 699 | 360 | 1.94166666666667 | 0.61534204368582 | 0.61534204368582 | false | false | false | true | ||||||||||||||||
| 7a922ab0-e277-424e-a3fa-0f24fe6daa05 | 2026-08-17 15:07 | 2026-08-17 15:07 | 2026-08-17 15:07 | EWY | EWY260904P00177000 | put | 177.0000 | 2026-09-04 | 5.1000 | 5.0000 | 5.1000 | 185.0800 | 24479.00 | 24479.00 | 0.00 | 48 | 13 | 113 | 0 | 0 | 0.540398843364976 | 0.541072897527969 | false | false | false | true | ||||||||||||||||
| bedca0b8-5b07-4d27-b9b8-a65974370b41 | 2026-08-17 13:25 | 2026-08-17 13:25 | 2026-08-17 13:25 | EWY | EWY260821P00166000 | put | 166.0000 | 2026-08-21 | 0.2400 | 0.1000 | 0.2500 | 187.3400 | 11931.00 | 11931.00 | 0.00 | 500 | 6 | 1007 | 20 | 50.35 | 0.681861990444321 | 0.681861990444321 | false | false | false | true | ||||||||||||||||
| cc42ab19-12ce-4baf-8be8-f8cc02485f84 | 2026-08-17 11:56 | 2026-08-17 11:56 | 2026-08-17 11:56 | EWY | EWY260821C00210000 | call | 210.0000 | 2026-08-21 | 0.2000 | 0.2000 | 0.2500 | 188.4950 | 15134.00 | 0.00 | 15134.00 | 755 | 41 | 1263 | 11661 | 0.108309750450219 | 0.588686480694573 | 0.588686480694573 | true | false | false | true | ||||||||||||||||
| c4b9a465-66a9-4586-8cc4-2f6e54e2147a | 2026-08-17 10:54 | 2026-08-17 10:54 | 2026-08-17 10:54 | EWY | EWY260828P00182500 | put | 182.5000 | 2026-08-28 | 4.2300 | 4.2000 | 4.7000 | 188.9900 | 67200.00 | 3870.00 | 53010.00 | 159 | 13 | 459 | 59 | 7.77966101694915 | 0.548504838965906 | 0.556863866555898 | false | false | false | true | ||||||||||||||||
| b3ea6e4b-4c0a-4044-b7d5-fe724f02a05c | 2026-08-17 10:52 | 2026-08-17 10:52 | 2026-08-17 10:52 | EWY | EWY260918C00200000 | call | 200.0000 | 2026-09-18 | 7.7600 | 7.6000 | 8.2000 | 189.0700 | 38798.00 | 0.00 | 38798.00 | 50 | 8 | 8712 | 14747 | 0.590764223231844 | 0.532539590175832 | 0.532539590175832 | false | false | false | true | ||||||||||||||||
| 60e3054e-b34e-427e-99dc-0cc34e2a09c7 | 2026-08-17 10:38 | 2026-08-17 10:38 | 2026-08-17 10:38 | EWY | EWY261120C00210000 | call | 210.0000 | 2026-11-20 | 11.9800 | 11.1000 | 12.2000 | 187.6600 | 10780.00 | 5990.00 | 2400.00 | 9 | 9 | 14 | 60 | 0.233333333333333 | 0.509721083710913 | 0.512430905127492 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |