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_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 |
|---|
| 92735756-5915-4b5b-8c93-a7f286ca80b3 | 2026-09-02 10:08 | 2026-09-02 10:08 | 2026-09-02 10:08 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.0700 | 1.0700 | 1.1000 | 37.6200 | 19474.00 | 0.00 | 19474.00 | 182 | 5 | 509 | 42204 | 0.0120604682020662 | 0.428734173295514 | 0.428734173295514 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 8633146199.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 39c24016-8174-4c81-8dbc-99a9bd693325 | 2026-09-08 09:48 | 2026-09-08 09:47 | 2026-09-08 09:47 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3600 | 38.9705 | 22005.00 | 22005.00 | 0.00 | 163 | 19 | 275 | 32884 | 0.00836272959493979 | 0.429153234897901 | 0.429153234897901 | false | false | false | true | ||||||||||||||||
| 217d6a42-b897-48fe-95ce-ac866e92e448 | 2026-09-08 09:48 | 2026-09-08 09:47 | 2026-09-08 09:47 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3500 | 38.9600 | 65205.00 | 65205.00 | 0.00 | 483 | 14 | 758 | 32884 | 0.023050723756234 | 0.429682637765119 | 0.429682637765119 | false | false | false | true | ||||||||||||||||
| 33e87646-61d6-4af2-97ae-91bf3994379e | 2026-09-08 09:49 | 2026-09-08 09:49 | 2026-09-08 09:49 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3300 | 1.3700 | 38.9300 | 68040.00 | 0.00 | 61560.00 | 504 | 9 | 1262 | 32884 | 0.0383773263593237 | 0.431194967071137 | 0.431194967071137 | false | false | false | true | ||||||||||||||||
| d9a1eb3b-8fad-44d4-bc73-21b6cfeceaa6 | 2026-09-08 09:49 | 2026-09-08 09:49 | 2026-09-08 09:49 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.2900 | 1.3600 | 38.9114 | 154575.00 | 141615.00 | 12960.00 | 1145 | 25 | 2523 | 32884 | 0.0767242427928476 | 0.432132428800719 | 0.432132428800719 | false | false | false | true | ||||||||||||||||
| 429a1585-cf0c-4652-9ef5-dee9ba440f65 | 2026-09-08 09:50 | 2026-09-08 09:49 | 2026-09-08 09:49 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3000 | 1.3600 | 38.9300 | 60210.00 | 52245.00 | 7965.00 | 446 | 24 | 3165 | 32884 | 0.096247415156307 | 0.431194967071137 | 0.431194967071137 | false | false | false | true | ||||||||||||||||
| 13ead4f6-e52d-41ea-860f-f810f2d50276 | 2026-09-08 10:14 | 2026-09-08 10:13 | 2026-09-08 10:13 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3500 | 1.3600 | 38.9600 | 13635.00 | 0.00 | 13635.00 | 101 | 12 | 3471 | 32884 | 0.10555285245104 | 0.429682637765119 | 0.429682637765119 | false | false | false | true | ||||||||||||||||
| 744ccd08-300b-451c-a972-155e05c8eede | 2026-09-08 10:14 | 2026-09-08 10:14 | 2026-09-08 10:14 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3500 | 1.3600 | 38.9500 | 16470.00 | 0.00 | 16470.00 | 122 | 13 | 3627 | 32884 | 0.110296800875806 | 0.430186788445708 | 0.430186788445708 | false | false | false | true | ||||||||||||||||
| f3c95d81-7f49-4018-82a0-d0d20a4d6b97 | 2026-09-08 10:14 | 2026-09-08 10:14 | 2026-09-08 10:14 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3600 | 38.9300 | 110025.00 | 110025.00 | 0.00 | 815 | 38 | 4825 | 32884 | 0.146727891983944 | 0.431194967071137 | 0.431194967071137 | false | false | false | true | ||||||||||||||||
| 54cbd2d1-7a01-4863-8590-d9df8cf0427d | 2026-09-08 10:14 | 2026-09-08 10:14 | 2026-09-08 10:14 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3500 | 1.3600 | 38.9301 | 39285.00 | 0.00 | 39285.00 | 291 | 8 | 4010 | 32884 | 0.121943802457122 | 0.431189926580858 | 0.431189926580858 | true | false | false | true | ||||||||||||||||
| 2d414f80-d9a8-4f53-8332-619386301d6a | 2026-09-08 10:14 | 2026-09-08 10:14 | 2026-09-08 10:14 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3400 | 1.3600 | 38.9100 | 59940.00 | 59805.00 | 0.00 | 444 | 16 | 6024 | 32884 | 0.183189393017881 | 0.432202984884132 | 0.432202984884132 | false | false | false | true | ||||||||||||||||
| 0e82b78c-cb72-4ba5-aba1-e1b317a5bdb3 | 2026-09-08 11:01 | 2026-09-08 11:00 | 2026-09-08 11:00 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3600 | 38.8400 | 266085.00 | 191160.00 | 73845.00 | 1971 | 38 | 8414 | 32884 | 0.255869115679358 | 0.435729829449603 | 0.435729829449603 | false | false | false | true | ||||||||||||||||
| 8c96dc82-2596-43d0-ba67-67a6916ccbcc | 2026-09-08 11:01 | 2026-09-08 11:00 | 2026-09-08 11:00 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3600 | 38.8400 | 48330.00 | 10395.00 | 28890.00 | 358 | 10 | 8773 | 32884 | 0.266786279041479 | 0.435729829449603 | 0.435729829449603 | true | false | false | true | ||||||||||||||||
| 66787a86-9201-45f9-a231-8377391f6256 | 2026-09-08 11:19 | 2026-09-08 11:19 | 2026-09-08 11:19 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.3500 | 1.3200 | 1.3600 | 38.8200 | 91395.00 | 81000.00 | 10395.00 | 677 | 23 | 9474 | 32884 | 0.288103637027126 | 0.43623351530414 | 0.436737165126183 | false | false | false | true | ||||||||||||||||
| 37160e4d-75c8-4849-9393-df187b6f4afc | 2026-09-11 10:07 | 2026-09-11 10:07 | 2026-09-11 10:07 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 1.1000 | 1.1000 | 1.1300 | 38.3300 | 71500.00 | 0.00 | 71500.00 | 650 | 27 | 651 | 37743 | 0.0172482314601383 | 0.427648241641791 | 0.427648241641791 | false | false | false | true | ||||||||||||||||
| e33b2245-5290-4bcb-a260-ada2f5d02080 | 2026-09-14 10:16 | 2026-09-14 10:16 | 2026-09-14 10:16 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.8700 | 0.8600 | 0.8900 | 37.0000 | 30972.00 | 0.00 | 30972.00 | 356 | 7 | 358 | 41097 | 0.00871109813368372 | 0.441155728260694 | 0.441155728260694 | true | false | false | true | ||||||||||||||||
| edb17c8d-773d-4c0c-8e85-0553ecc8b48f | 2026-09-14 11:44 | 2026-09-14 11:44 | 2026-09-14 11:44 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.9400 | 0.9400 | 0.9500 | 37.7300 | 4961414.00 | 0.00 | 4961414.00 | 52781 | 1 | 53151 | 41097 | 1.29330608073582 | 0.437751336537337 | 0.437751336537337 | false | true | false | true | ||||||||||||||||
| 5a0d4967-3194-4179-9ffb-016fd7494a9a | 2026-09-14 13:18 | 2026-09-14 13:18 | 2026-09-14 13:18 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.9400 | 0.9400 | 0.9500 | 37.6700 | 21620.00 | 0.00 | 21620.00 | 230 | 5 | 53382 | 41097 | 1.29892692897292 | 0.440403951289315 | 0.440403951289315 | true | false | false | true | ||||||||||||||||
| 1d0bfdbc-ef4f-4e55-8dcd-fd757cfdeeec | 2026-09-15 10:45 | 2026-09-15 10:45 | 2026-09-15 10:45 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.9600 | 0.9600 | 0.9800 | 37.6250 | 32256.00 | 0.00 | 32256.00 | 336 | 5 | 347 | 95892 | 0.00361865431944271 | 0.449080025215066 | 0.449080025215066 | false | false | false | true | ||||||||||||||||
| efbc5962-da51-45ce-96ef-300b0b57d705 | 2026-09-15 10:45 | 2026-09-15 10:45 | 2026-09-15 10:45 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.9700 | 0.9550 | 0.9800 | 37.6250 | 14162.00 | 9894.00 | 1261.00 | 146 | 13 | 1013 | 95892 | 0.0105639677971051 | 0.451058718610367 | 0.451058718610367 | true | false | false | true | ||||||||||||||||
| 44e24197-1940-4237-9f67-9209ce0b8f02 | 2026-09-21 10:30 | 2026-09-21 10:30 | 2026-09-21 10:30 | EWZ | EWZ261120C00044000 | call | 44.0000 | 2026-11-20 | 0.8500 | 0.8500 | 0.8700 | 37.8000 | 42500.00 | 0.00 | 42500.00 | 500 | 28 | 504 | 146719 | 0.00343513791669791 | 0.440230870565532 | 0.440230870565532 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeMidCap |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8686956917.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8633146199.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 8582555431.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |