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 | 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 |
|---|
| 254a8d60-262b-4447-8cd1-49b0f7b0bb8c | 2026-08-21 09:53 | 2026-08-21 09:52 | 2026-08-21 09:52 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 0.8500 | 0.7800 | 0.8500 | 27.3000 | 69105.00 | 69105.00 | 0.00 | 813 | 6 | 1027 | 7120 | 0.144241573033708 | 0.596213579501346 | 0.593856089785436 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 7050904301.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8b62f563-d444-4f41-b1ef-f050143ebee7 | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 0.9000 | 0.7800 | 1.0400 | 27.3900 | 96425.00 | 77983.00 | 18352.00 | 1072 | 38 | 2103 | 7120 | 0.295365168539326 | 0.606339359347146 | 0.6015548556131 | true | false | false | true | ||||||||||||||||
| 4839b409-5a2a-4d2f-9526-03fd6d16bc94 | 2026-08-21 12:25 | 2026-08-21 12:25 | 2026-08-21 12:25 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.2400 | 1.2100 | 1.2800 | 28.4600 | 105276.00 | 68076.00 | 37200.00 | 849 | 7 | 3780 | 7120 | 0.530898876404494 | 0.582965261089831 | 0.582965261089831 | false | false | false | true | ||||||||||||||||
| c721cb9e-e4a7-4ec2-aeea-647b8025992d | 2026-08-21 15:44 | 2026-08-21 15:44 | 2026-08-21 15:44 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.4200 | 1.4200 | 1.4400 | 28.8800 | 21300.00 | 0.00 | 7810.00 | 150 | 57 | 5334 | 7120 | 0.749157303370787 | 0.58307153958026 | 0.58307153958026 | false | false | false | true | ||||||||||||||||
| 1f8770c4-5c73-49df-9f7e-bdc7a925779c | 2026-08-25 13:59 | 2026-08-25 13:59 | 2026-08-25 13:59 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 0.8600 | 0.8500 | 0.8800 | 27.0000 | 20468.00 | 2494.00 | 17114.00 | 238 | 8 | 1781 | 8957 | 0.198838896952104 | 0.590208126042166 | 0.590208126042166 | false | false | false | true | ||||||||||||||||
| ac8b0e5d-532d-4b5a-975b-bc1971950afc | 2026-08-25 15:12 | 2026-08-25 15:12 | 2026-08-25 15:12 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 0.9000 | 0.8600 | 0.9500 | 27.8705 | 14760.00 | 3960.00 | 10800.00 | 164 | 7 | 2666 | 8957 | 0.297644300547058 | 0.588566905167021 | 0.588566905167021 | false | false | false | true | ||||||||||||||||
| bbb6019c-86ae-4430-a574-b83dcf71555c | 2026-08-27 11:37 | 2026-08-27 11:37 | 2026-08-27 11:37 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.6500 | 1.5700 | 1.6500 | 29.7400 | 75075.00 | 75075.00 | 0.00 | 455 | 31 | 2018 | 10071 | 0.200377321020753 | 0.59735039606936 | 0.59735039606936 | true | false | false | true | ||||||||||||||||
| e13a1334-0c1a-4172-9522-4ab5944cbd5a | 2026-08-27 11:43 | 2026-08-27 11:43 | 2026-08-27 11:43 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.7000 | 1.5700 | 1.7000 | 29.7800 | 57630.00 | 57630.00 | 0.00 | 339 | 35 | 2554 | 10071 | 0.253599443947969 | 0.607456819669415 | 0.607456819669415 | true | false | false | true | ||||||||||||||||
| dded0835-655b-459e-8679-d7dcd2680f42 | 2026-08-27 11:43 | 2026-08-27 11:43 | 2026-08-27 11:43 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.6400 | 1.5700 | 1.6400 | 29.7223 | 25092.00 | 25092.00 | 0.00 | 153 | 18 | 2215 | 10071 | 0.219938437096614 | 0.597022096159081 | 0.597022096159081 | true | false | false | true | ||||||||||||||||
| e4e6869c-82dd-44bd-9fea-e32b24ae05a4 | 2026-08-27 14:49 | 2026-08-27 14:49 | 2026-08-27 14:49 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.8200 | 1.7400 | 1.8200 | 30.0450 | 48048.00 | 48048.00 | 0.00 | 264 | 35 | 3051 | 10071 | 0.302949061662198 | 0.600651502950454 | 0.600651502950454 | true | false | false | true | ||||||||||||||||
| cce4b9aa-c3bd-4955-a752-f95cddc3edc1 | 2026-08-27 14:49 | 2026-08-27 14:49 | 2026-08-27 14:49 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.8200 | 1.8200 | 1.8400 | 30.0900 | 15288.00 | 0.00 | 6734.00 | 84 | 5 | 3141 | 10071 | 0.311885612153709 | 0.592331926291627 | 0.592331926291627 | false | false | false | true | ||||||||||||||||
| ab44e44d-12b8-4d45-b7a6-ed147decc33f | 2026-08-27 14:49 | 2026-08-27 14:49 | 2026-08-27 14:49 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.8400 | 1.8000 | 1.8400 | 30.0900 | 24472.00 | 24472.00 | 0.00 | 133 | 27 | 3282 | 10071 | 0.325886207923741 | 0.599158858756269 | 0.599158858756269 | true | false | false | true | ||||||||||||||||
| 9132950b-631e-4b50-b01e-8a687ff8e825 | 2026-09-02 11:46 | 2026-09-02 11:46 | 2026-09-02 11:46 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 2.0100 | 1.9800 | 2.0600 | 30.8900 | 16884.00 | 2412.00 | 14472.00 | 84 | 27 | 227 | 11814 | 0.0192144912815304 | 0.580297659359856 | 0.587934843440269 | false | false | false | true | ||||||||||||||||
| 72f9f1a5-a31a-423a-baeb-573b89cbc758 | 2026-09-03 09:38 | 2026-09-03 09:38 | 2026-09-03 09:38 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 3.1000 | 2.7500 | 3.2000 | 32.4600 | 24768.00 | 24768.00 | 0.00 | 80 | 14 | 240 | 11603 | 0.0206843057829872 | 0.607251051644644 | 0.607251051644644 | false | false | false | true | ||||||||||||||||
| 8de1cfdd-c72e-4d8c-904d-be0ca086193b | 2026-09-03 14:12 | 2026-09-03 14:11 | 2026-09-03 14:11 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 3.0000 | 2.8200 | 3.0500 | 32.4001 | 30600.00 | 29400.00 | 1200.00 | 102 | 8 | 535 | 11603 | 0.0461087649745755 | 0.580456876858889 | 0.580456876858889 | false | false | false | true | ||||||||||||||||
| 0d20f16b-61e4-4d35-86a1-2999e87cfa88 | 2026-09-04 09:49 | 2026-09-04 09:49 | 2026-09-04 09:49 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.3000 | 31.7300 | 23000.00 | 0.00 | 0.00 | 100 | 5 | 106 | 11148 | 0.00950843200574094 | 0.503294290514482 | 0.503294290514482 | false | false | false | true | ||||||||||||||||
| 0fe33399-7a3a-4abf-ba66-0bdb64017f35 | 2026-09-04 15:43 | 2026-09-04 15:43 | 2026-09-04 15:43 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 2.1000 | 2.1000 | 2.2000 | 31.3873 | 40320.00 | 0.00 | 40320.00 | 192 | 7 | 739 | 11148 | 0.0662899174739864 | 0.524771403633521 | 0.524771403633521 | true | false | false | true | ||||||||||||||||
| 096a7801-bc4e-4682-b1a0-a9ace291b5e5 | 2026-09-16 14:31 | 2026-09-16 14:31 | 2026-09-16 14:31 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 1.3800 | 1.3800 | 1.4700 | 31.1728 | 44436.00 | 0.00 | 44436.00 | 322 | 36 | 404 | 10068 | 0.0401271354787445 | 0.686605169673745 | 0.686605169673745 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7014524272.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |