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_alerts425,429 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 |
|---|
| a036ca6c-9d1c-44f3-9f85-4fe7f8d04848 | 2026-08-20 10:00 | 2026-08-20 10:00 | 2026-08-20 10:00 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 7.0000 | 6.2000 | 7.1000 | 177.3000 | 16800.00 | 16100.00 | 700.00 | 24 | 6 | 65 | 5938 | 0.0109464466150219 | 0.521918374711973 | 0.521918374711973 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 26836573555.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2dcb6e34-55fa-40c7-bf17-0be509acef10 | 2026-08-24 14:15 | 2026-08-24 14:15 | 2026-08-24 14:15 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 5.4000 | 4.7000 | 5.5000 | 174.6400 | 11880.00 | 11880.00 | 0.00 | 22 | 11 | 58 | 5823 | 0.00996050145972866 | 0.508564492685437 | 0.508438852838528 | true | false | false | true | ||||||||||||||||
| 512b655e-414a-41d0-91e4-4f8b622fd3fc | 2026-09-04 12:50 | 2026-09-04 12:50 | 2026-09-04 12:50 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 6.2000 | 5.5000 | 6.2000 | 186.8400 | 129577.00 | 129577.00 | 0.00 | 209 | 17 | 401 | 6772 | 0.059214412285883 | 0.433062091491943 | 0.43275869968196 | false | false | false | true | ||||||||||||||||
| 7710173b-c93f-4907-bd04-afe702a2375c | 2026-09-11 13:58 | 2026-09-11 13:58 | 2026-09-11 13:58 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 6.7500 | 6.7500 | 6.9500 | 189.6700 | 18225.00 | 0.00 | 18225.00 | 27 | 11 | 561 | 7030 | 0.079800853485064 | 0.452902277694335 | 0.452902277694335 | false | false | false | true | ||||||||||||||||
| df5c2a38-fb65-4a25-8691-d6ed279cb579 | 2026-09-11 14:13 | 2026-09-11 14:13 | 2026-09-11 14:13 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 6.8000 | 6.7000 | 6.8500 | 189.4550 | 10200.00 | 3400.00 | 6800.00 | 15 | 5 | 610 | 7030 | 0.0867709815078236 | 0.458840265522902 | 0.458840265522902 | false | false | false | true | ||||||||||||||||
| 4730c010-0afe-48dd-89fb-233f0d0a8ed4 | 2026-09-11 14:13 | 2026-09-11 14:13 | 2026-09-11 14:13 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 6.8000 | 6.7000 | 6.8500 | 189.4600 | 10200.00 | 2720.00 | 7480.00 | 15 | 5 | 648 | 7030 | 0.092176386913229 | 0.458753863794305 | 0.458753863794305 | true | false | false | true | ||||||||||||||||
| 61b12656-fd98-468d-a6aa-c8aa88c2cd37 | 2026-09-14 15:03 | 2026-09-14 15:03 | 2026-09-14 15:03 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 3.2500 | 3.2500 | 3.5500 | 178.6300 | 71846.00 | 0.00 | 71846.00 | 221 | 25 | 1126 | 7006 | 0.160719383385669 | 0.472064539778913 | 0.472064539778913 | false | false | false | true | ||||||||||||||||
| e4d423b5-7000-4dc1-81f1-681f563355ed | 2026-09-14 15:45 | 2026-09-14 15:45 | 2026-09-14 15:45 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 2.9000 | 2.9000 | 3.1000 | 177.0000 | 67280.00 | 0.00 | 67280.00 | 232 | 20 | 1432 | 7006 | 0.204396231801313 | 0.464767939446854 | 0.464767939446854 | false | false | false | true | ||||||||||||||||
| cc206092-635d-4687-a78e-e338a02ac25c | 2026-09-15 13:08 | 2026-09-15 13:08 | 2026-09-15 13:08 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 2.2900 | 2.2900 | 2.3900 | 176.1350 | 12137.00 | 0.00 | 12137.00 | 53 | 17 | 201 | 7734 | 0.025989138867339 | 0.450872455570917 | 0.450872455570917 | false | false | false | true | ||||||||||||||||
| 2c0f0ebf-2932-4def-89ee-d19f4e20de46 | 2026-09-17 09:39 | 2026-09-17 09:39 | 2026-09-17 09:39 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 3.0000 | 3.0000 | 3.1500 | 181.9600 | 14700.00 | 0.00 | 14700.00 | 49 | 11 | 52 | 7855 | 0.00661998726925525 | 0.429739472575206 | 0.429739472575206 | false | false | false | true | ||||||||||||||||
| 060686da-72e3-4554-a916-fe648cbd4538 | 2026-09-18 10:53 | 2026-09-18 10:52 | 2026-09-18 10:52 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 2.2900 | 2.2800 | 2.4500 | 179.3900 | 16259.00 | 0.00 | 15114.00 | 71 | 26 | 140 | 7940 | 0.017632241813602 | 0.428820072223917 | 0.428820072223917 | false | false | false | true | ||||||||||||||||
| 5295b1e8-3bf6-47e2-9cdf-20a4da9014c3 | 2026-09-22 10:36 | 2026-09-22 10:35 | 2026-09-22 10:35 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 5.4000 | 5.4000 | 5.7000 | 191.2300 | 92340.00 | 0.00 | 92340.00 | 171 | 28 | 200 | 8009 | 0.0249719066050693 | 0.446900671883706 | 0.446900671883706 | true | false | false | true | ||||||||||||||||
| 2ac02296-0283-4e11-b6be-1c06c770a6ef | 2026-09-22 10:47 | 2026-09-22 10:47 | 2026-09-22 10:47 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 5.0500 | 4.8500 | 5.1000 | 190.2000 | 26765.00 | 25755.00 | 505.00 | 53 | 8 | 254 | 8009 | 0.031714321388438 | 0.448542154903101 | 0.448542154903101 | true | false | false | true | ||||||||||||||||
| d0aa123c-e561-4799-8196-6ba92fca1b0b | 2026-09-22 10:47 | 2026-09-22 10:47 | 2026-09-22 10:47 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 5.0500 | 4.8500 | 5.1000 | 190.2000 | 12120.00 | 11615.00 | 505.00 | 24 | 7 | 278 | 8009 | 0.0347109501810463 | 0.448542154903101 | 0.448542154903101 | true | false | false | true | ||||||||||||||||
| 697a89bb-d7e8-4ab0-85cc-365db7582c92 | 2026-09-22 12:45 | 2026-09-22 12:45 | 2026-09-22 12:45 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 4.9500 | 4.9000 | 4.9500 | 190.2050 | 27720.00 | 27720.00 | 0.00 | 56 | 6 | 426 | 8009 | 0.0531901610687976 | 0.443354545017682 | 0.442961052659512 | true | false | false | true | ||||||||||||||||
| 99658029-e4d2-4ed0-9c88-8e470ad8c01e | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 3.8500 | 3.7000 | 3.8500 | 187.0000 | 92387.00 | 92387.00 | 0.00 | 240 | 36 | 392 | 7973 | 0.0491659350307287 | 0.439727841306584 | 0.439727841306584 | true | false | false | true | ||||||||||||||||
| 1adc50da-b366-4158-bf87-ca6d55f24e67 | 2026-09-23 10:54 | 2026-09-23 10:54 | 2026-09-23 10:54 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 3.7500 | 3.7500 | 3.8000 | 187.0000 | 59625.00 | 0.00 | 59625.00 | 159 | 7 | 582 | 7973 | 0.0729963627241942 | 0.44252284767145 | 0.44252284767145 | true | false | false | true | ||||||||||||||||
| 5cc4631c-91ed-4510-90db-75d600c4af41 | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 2.7100 | 2.7100 | 2.8800 | 184.3200 | 68027.00 | 276.00 | 67751.00 | 251 | 30 | 251 | 7839 | 0.0320193902283455 | 0.434015497172135 | 0.437694197746985 | false | false | false | true | ||||||||||||||||
| 79f063ed-5c70-44f6-882b-3c21c636a1fc | 2026-09-24 09:44 | 2026-09-24 09:44 | 2026-09-24 09:44 | EWY | EWY261016C00200000 | call | 200.0000 | 2026-10-16 | 2.8500 | 2.7400 | 2.8500 | 184.4500 | 21659.00 | 21659.00 | 0.00 | 76 | 23 | 332 | 7839 | 0.0423523408598035 | 0.441704319156963 | 0.441704319156963 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26836573555.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26292809532.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 26575771427.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27365088480.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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |