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 | 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 |
|---|
| d4d969d0-cb62-4f23-8daf-a237c7b5620b | 2026-09-28 15:52 | 2026-09-28 15:52 | 2026-09-28 15:52 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 5.3000 | 5.2500 | 5.3000 | 183.7250 | 10600.00 | 10600.00 | 0.00 | 20 | 9 | 274 | 5135 | 0.0533592989289192 | 0.44522410082964 | 0.444849864163501 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 26898842873.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 5739fbf1-755a-48ad-9993-a834168ccfa9 | 2026-09-24 10:14 | 2026-09-24 10:14 | 2026-09-24 10:14 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 6.2500 | 6.1000 | 6.3000 | 183.1100 | 65625.00 | 53125.00 | 12500.00 | 105 | 13 | 144 | 5004 | 0.0287769784172662 | 0.444752194240108 | 0.444752194240108 | true | false | false | true | ||||||||||||||||
| bc86204d-5270-46ce-b289-7254b55b387a | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 4.8000 | 4.6500 | 5.1000 | 188.8500 | 15835.00 | 475.00 | 15360.00 | 33 | 8 | 44 | 5052 | 0.00870942201108472 | 0.460735109190851 | 0.457818956115258 | true | false | false | true | ||||||||||||||||
| 5cae7f0d-3d60-4297-811b-1c76799f585d | 2026-09-18 13:38 | 2026-09-18 13:37 | 2026-09-18 13:37 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 8.6200 | 8.3500 | 8.6500 | 179.8500 | 14655.00 | 14655.00 | 0.00 | 17 | 5 | 289 | 4943 | 0.0584665183087194 | 0.445292680060069 | 0.442768920858321 | true | false | false | true | ||||||||||||||||
| 75bfca65-6a1b-4334-a4a8-f8b1003aa3e0 | 2026-09-17 15:28 | 2026-09-17 15:27 | 2026-09-17 15:27 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 7.2500 | 7.1000 | 7.2500 | 182.8500 | 11600.00 | 11600.00 | 0.00 | 16 | 5 | 692 | 4651 | 0.148785207482262 | 0.434906941336488 | 0.434906941336488 | false | false | false | true | ||||||||||||||||
| fe4a09b7-89cb-4257-ad40-e42f12aef0a4 | 2026-09-17 14:58 | 2026-09-17 14:57 | 2026-09-17 14:57 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 7.2000 | 7.1000 | 7.2500 | 182.8900 | 35997.00 | 35997.00 | 0.00 | 50 | 8 | 602 | 4651 | 0.129434530208557 | 0.433243188519712 | 0.433243188519712 | false | false | false | true | ||||||||||||||||
| e7544c02-d3a2-407e-98ae-54403cadd21c | 2026-09-17 14:39 | 2026-09-17 14:39 | 2026-09-17 14:39 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 7.2000 | 7.1500 | 7.4000 | 182.8500 | 20880.00 | 0.00 | 20880.00 | 29 | 15 | 501 | 4651 | 0.107718770156955 | 0.432418170576721 | 0.432418170576721 | true | false | false | true | ||||||||||||||||
| c374e700-8796-4d03-ab54-0fa1bd1801c4 | 2026-09-14 10:00 | 2026-09-14 10:00 | 2026-09-14 10:00 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 11.3000 | 11.0000 | 11.6000 | 177.1900 | 42940.00 | 41810.00 | 1130.00 | 38 | 6 | 110 | 4517 | 0.0243524463139252 | 0.482298081913771 | 0.482298081913771 | false | false | false | true | ||||||||||||||||
| f3adafa4-968f-4c0c-a900-e0ba159c75c1 | 2026-09-11 10:38 | 2026-09-11 10:38 | 2026-09-11 10:38 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 6.7500 | 6.6500 | 6.7500 | 188.4700 | 752615.00 | 752615.00 | 0.00 | 1115 | 20 | 1173 | 3363 | 0.348795718108831 | 0.472099022738124 | 0.472099022738124 | false | false | false | true | ||||||||||||||||
| bf8691db-fb49-48f3-a227-3e3f1837210c | 2026-08-31 15:09 | 2026-08-31 15:09 | 2026-08-31 15:09 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 10.9000 | 10.2000 | 11.0000 | 179.3900 | 49040.00 | 49040.00 | 0.00 | 45 | 13 | 109 | 3079 | 0.0354011042546281 | 0.434945230696583 | 0.434945230696583 | false | false | false | true | ||||||||||||||||
| 78051530-1e73-431c-9def-fc7657de486a | 2026-08-25 15:36 | 2026-08-25 15:36 | 2026-08-25 15:36 | EWY | EWY261016P00180000 | put | 180.0000 | 2026-10-16 | 13.5000 | 13.4000 | 13.9000 | 179.1800 | 32400.00 | 24300.00 | 8100.00 | 24 | 6 | 56 | 2974 | 0.0188298587760592 | 0.504137356983511 | 0.504137356983511 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27420786707.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:18:01.976836Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 26575771427.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28584308397.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} |
| 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-11T14:44:39.456230Z"} |
| 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-08-31T19:31:33.694739Z"} |
| 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-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |