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_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 |
|---|
| 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 |
|---|
| 4f03f3c9-9d20-4261-9fa8-09cc02d05d58 | 2026-08-24 09:49 | 2026-08-24 09:49 | 2026-08-24 09:49 | ZETA | ZETA261218P00020000 | put | 20.0000 | 2026-12-18 | 0.7600 | 0.7600 | 0.8200 | 28.8450 | 11020.00 | 0.00 | 608.00 | 145 | 5 | 1391 | 2457 | 0.566137566137566 | 0.676427606378772 | 0.676427606378772 | 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-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 604940db-46d9-4634-ae41-6597eda62b88 | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.5700 | 2.4500 | 2.6900 | 28.9600 | 28473.00 | 0.00 | 21277.00 | 111 | 9 | 375 | 621 | 0.603864734299517 | 0.662679557162846 | 0.661030706808649 | false | false | false | true | ||||||||||||||||
| 668cdd05-d048-4926-aac9-cab5ae4caf22 | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | ZETA | ZETA261218P00020000 | put | 20.0000 | 2026-12-18 | 0.7400 | 0.7100 | 0.9200 | 28.8800 | 20077.00 | 13792.00 | 2442.00 | 272 | 14 | 811 | 2457 | 0.33007733007733 | 0.668327073226579 | 0.674597733540153 | false | false | false | true | ||||||||||||||||
| 1841c5ac-0460-43b2-b755-44bf9f33ee1b | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.5800 | 2.4500 | 2.7700 | 28.8800 | 37682.00 | 4656.00 | 22185.00 | 146 | 14 | 170 | 621 | 0.273752012882448 | 0.662340255805898 | 0.659045893602299 | 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 | ||||||||||||||||
| e8a52de6-653b-4438-a08a-b44257bd3230 | 2026-08-21 13:01 | 2026-08-21 13:01 | 2026-08-21 13:01 | ZETA | ZETA260918C00025000 | call | 25.0000 | 2026-09-18 | 4.2000 | 4.2000 | 4.3000 | 28.6800 | 42000.00 | 0.00 | 42000.00 | 100 | 7 | 191 | 8681 | 0.0220020734938371 | 0.577493576790923 | 0.577493576790923 | false | 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 | ||||||||||||||||
| 42cc61fa-cab6-4330-934f-a582f62a7f44 | 2026-08-21 10:21 | 2026-08-21 10:21 | 2026-08-21 10:21 | ZETA | ZETA261002C00027000 | call | 27.0000 | 2026-10-02 | 2.7000 | 2.5900 | 2.8000 | 27.8000 | 38880.00 | 38880.00 | 0.00 | 144 | 5 | 144 | 0 | 0 | 0.598650672360681 | 0.598650672360681 | false | false | false | true | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 98fded9f-9ba5-4418-8b14-57067a39094a | 2026-08-20 14:41 | 2026-08-20 14:41 | 2026-08-20 14:41 | ZETA | ZETA260821P00029000 | put | 29.0000 | 2026-08-21 | 1.4000 | 1.0900 | 1.6000 | 27.6250 | 33600.00 | 16800.00 | 16800.00 | 240 | 8 | 409 | 554 | 0.73826714801444 | 0.686163712247774 | 0.623519387883268 | false | false | false | true | ||||||||||||||||
| 5e26b8cf-9371-428c-abaa-910076d1378d | 2026-08-20 13:36 | 2026-08-20 13:36 | 2026-08-20 13:36 | ZETA | ZETA270319C00025000 | call | 25.0000 | 2027-03-19 | 7.0100 | 7.0000 | 7.2500 | 27.6400 | 133843.00 | 0.00 | 133843.00 | 191 | 9 | 217 | 356 | 0.609550561797753 | 0.671417680340921 | 0.671417680340921 | false | false | false | true | ||||||||||||||||
| 37a4c4ad-207f-40d8-9112-699b51f94050 | 2026-08-18 14:45 | 2026-08-18 14:45 | 2026-08-18 14:45 | ZETA | ZETA261218C00035000 | call | 35.0000 | 2026-12-18 | 2.4000 | 2.4000 | 2.5600 | 28.4450 | 34080.00 | 0.00 | 34080.00 | 142 | 6 | 178 | 3322 | 0.053582179409994 | 0.674154605927646 | 0.674154605927646 | false | false | false | true | ||||||||||||||||
| 02eb41c4-f283-45ae-b8b5-10f609be6a05 | 2026-08-17 14:25 | 2026-08-17 14:25 | 2026-08-17 14:25 | ZETA | ZETA270115C00030000 | call | 30.0000 | 2027-01-15 | 4.5000 | 4.3500 | 4.5000 | 28.5100 | 85050.00 | 85050.00 | 0.00 | 189 | 10 | 304 | 18572 | 0.0163687271160887 | 0.675074080941759 | 0.675074080941759 | false | false | false | true | ||||||||||||||||
| 25e97acb-1f8a-43d6-b289-74181036fc81 | 2026-08-17 12:59 | 2026-08-17 12:58 | 2026-08-17 12:58 | ZETA | ZETA261218P00025000 | put | 25.0000 | 2026-12-18 | 2.4600 | 2.4600 | 2.5200 | 28.6400 | 37884.00 | 0.00 | 37884.00 | 154 | 13 | 312 | 2501 | 0.124750099960016 | 0.677281103567357 | 0.677281103567357 | false | false | false | true | ||||||||||||||||
| 73843570-5964-4be8-8770-6003ab58c47e | 2026-08-17 12:52 | 2026-08-17 12:52 | 2026-08-17 12:52 | ZETA | ZETA280121C00035000 | call | 35.0000 | 2028-01-21 | 8.0500 | 8.0500 | 8.2500 | 28.6300 | 10467.00 | 0.00 | 10467.00 | 13 | 8 | 47 | 6083 | 0.00772645076442545 | 0.707125854643538 | 0.707125854643538 | false | false | false | true | ||||||||||||||||
| cf298854-b7a3-4b55-a635-9223717b39d9 | 2026-08-17 10:53 | 2026-08-17 10:53 | 2026-08-17 10:53 | ZETA | ZETA261218P00025000 | put | 25.0000 | 2026-12-18 | 2.4200 | 2.4200 | 2.5000 | 28.9200 | 28072.00 | 0.00 | 28072.00 | 116 | 19 | 122 | 2501 | 0.0487804878048781 | 0.684048911594888 | 0.684048911594888 | false | false | false | true | ||||||||||||||||
| 8674e930-4aff-48fd-ba90-69a5012136fb | 2026-08-17 09:45 | 2026-08-17 09:45 | 2026-08-17 09:45 | ZETA | ZETA281215C00025000 | call | 25.0000 | 2028-12-15 | 13.8500 | 13.7500 | 15.8000 | 28.5900 | 23545.00 | 2770.00 | 20775.00 | 17 | 8 | 26 | 1502 | 0.0173102529960053 | 0.718625961485625 | 0.718625961485625 | 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-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 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-08-24T13:57:36.320523Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 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-21T14:24:12.053362Z"} |
| 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-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-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-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 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-18T18:49:07.657249Z"} |
| 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-17T18:41:22.197029Z"} |
| 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-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 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-17T14:59:17.821734Z"} |
| 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-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |