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 |
|---|
| 728b03e2-8204-4a4d-943c-b3bf9c485ad5 | 2026-09-17 09:34 | 2026-09-17 09:34 | 2026-09-17 09:34 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1500 | 4.0000 | 4.2500 | 28.6050 | 15355.00 | 415.00 | 14940.00 | 37 | 7 | 39 | 2664 | 0.0146396396396396 | 0.79596900003521 | 0.79596900003521 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 6273459183.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2773d38d-ba2c-483a-b3fb-642ec950a86c | 2026-09-14 10:35 | 2026-09-14 10:35 | 2026-09-14 10:35 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.3100 | 4.3000 | 4.4000 | 28.7118 | 43100.00 | 0.00 | 43100.00 | 100 | 5 | 2136 | 2932 | 0.728512960436562 | 0.797561410302402 | 0.797561410302402 | false | false | false | true | ||||||||||||||||
| c5a4e1a4-b1ef-490c-a306-c931c59f7c51 | 2026-09-14 09:51 | 2026-09-14 09:51 | 2026-09-14 09:51 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.2000 | 4.1000 | 4.2500 | 28.5350 | 12600.00 | 12600.00 | 0.00 | 30 | 14 | 1327 | 2932 | 0.452592087312415 | 0.796787477478003 | 0.796787477478003 | true | false | false | true | ||||||||||||||||
| 9a95f1ea-b7c2-43df-8cfd-6ad34109e4a3 | 2026-09-14 09:46 | 2026-09-14 09:46 | 2026-09-14 09:46 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.8700 | 3.8000 | 4.1000 | 28.0000 | 17434.00 | 8254.00 | 9180.00 | 45 | 26 | 1036 | 2932 | 0.353342428376535 | 0.790789825079797 | 0.787826559970998 | false | false | false | true | ||||||||||||||||
| ef3233ea-4d88-4543-b3e2-bedbd7549d69 | 2026-09-14 09:45 | 2026-09-14 09:45 | 2026-09-14 09:45 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.0300 | 4.0000 | 4.1500 | 28.0000 | 12486.00 | 3280.00 | 9206.00 | 31 | 11 | 937 | 2932 | 0.319577080491132 | 0.767710478273648 | 0.788864737203365 | false | false | false | true | ||||||||||||||||
| 58e75358-7623-4008-9277-15320a72f4cf | 2026-09-14 09:43 | 2026-09-14 09:43 | 2026-09-14 09:43 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.0800 | 4.0500 | 4.2000 | 28.0000 | 15895.00 | 8200.00 | 7695.00 | 39 | 9 | 702 | 2932 | 0.239427012278308 | 0.760671853967245 | 0.771231325650169 | false | false | false | true | ||||||||||||||||
| ad75b209-f67f-41c0-9182-d4a30cfc2b17 | 2026-09-14 09:43 | 2026-09-14 09:43 | 2026-09-14 09:43 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1000 | 4.1000 | 4.2000 | 28.0000 | 13120.00 | 0.00 | 13120.00 | 32 | 7 | 649 | 2932 | 0.221350613915416 | 0.772873508175356 | 0.772873508175356 | false | false | false | true | ||||||||||||||||
| fd8ca51a-64e0-4af2-941d-261dbfc9a59f | 2026-09-14 09:42 | 2026-09-14 09:42 | 2026-09-14 09:42 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1500 | 4.1000 | 4.2000 | 28.0000 | 32370.00 | 27805.00 | 2490.00 | 78 | 8 | 506 | 2932 | 0.172578444747613 | 0.797560640685365 | 0.797560640685365 | false | false | false | true | ||||||||||||||||
| 342876e2-d982-4d5e-a699-2197b8290392 | 2026-09-14 09:42 | 2026-09-14 09:42 | 2026-09-14 09:42 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1000 | 3.8500 | 4.1500 | 28.0000 | 50838.00 | 50838.00 | 0.00 | 124 | 20 | 428 | 2932 | 0.145975443383356 | 0.790747532154314 | 0.786514690022027 | false | false | false | true | ||||||||||||||||
| 49915cf6-040e-4260-b598-ee75f4d006e1 | 2026-09-14 09:40 | 2026-09-14 09:40 | 2026-09-14 09:40 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.9800 | 3.9500 | 4.1000 | 28.0000 | 39750.00 | 0.00 | 27900.00 | 100 | 7 | 246 | 2932 | 0.0839017735334243 | 0.774598297187752 | 0.785192577212441 | false | false | false | true | ||||||||||||||||
| 0cb70ab9-bd03-4ac4-9962-08d7ceaf9973 | 2026-09-14 09:38 | 2026-09-14 09:38 | 2026-09-14 09:38 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1000 | 3.8000 | 4.1000 | 28.0000 | 26650.00 | 26650.00 | 0.00 | 65 | 12 | 134 | 2932 | 0.0457025920873124 | 0.795449297033474 | 0.792629126107139 | false | false | false | true | ||||||||||||||||
| a2ab730a-800f-413b-b773-79552efcabab | 2026-09-11 12:48 | 2026-09-11 12:48 | 2026-09-11 12:48 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.6000 | 3.5000 | 3.6500 | 27.4100 | 10800.00 | 1800.00 | 9000.00 | 30 | 6 | 703 | 2257 | 0.311475409836066 | 0.790337638427004 | 0.790337638427004 | false | false | false | true | ||||||||||||||||
| e347a806-db8f-4001-96e8-0d497ef585a7 | 2026-09-10 09:34 | 2026-09-10 09:34 | 2026-09-10 09:34 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.6000 | 3.5500 | 3.7500 | 27.2400 | 11880.00 | 0.00 | 11880.00 | 33 | 6 | 338 | 1878 | 0.179978700745474 | 0.802958212542765 | 0.802958212542765 | false | false | false | true | ||||||||||||||||
| f3c726fd-ec8f-4227-911b-049b63eaf351 | 2026-09-10 09:30 | 2026-09-10 09:30 | 2026-09-10 09:30 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.7000 | 3.6000 | 3.7000 | 27.2300 | 46990.00 | 46990.00 | 0.00 | 127 | 8 | 151 | 1878 | 0.0804046858359957 | 0.825141592111355 | 0.825141592111355 | false | false | false | true | ||||||||||||||||
| fe24f920-0c41-465a-a644-4cfade262ba7 | 2026-09-09 15:45 | 2026-09-09 15:44 | 2026-09-09 15:44 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.8000 | 3.8000 | 3.9000 | 27.5800 | 22420.00 | 0.00 | 22420.00 | 59 | 25 | 1652 | 456 | 3.62280701754386 | 0.799480400159017 | 0.799480400159017 | false | false | false | true | ||||||||||||||||
| 5bd7fe1b-c9e6-477d-98a1-55231778154c | 2026-09-09 14:13 | 2026-09-09 14:13 | 2026-09-09 14:13 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.9000 | 3.8000 | 3.9000 | 27.6850 | 97765.00 | 90450.00 | 0.00 | 251 | 13 | 936 | 456 | 2.05263157894737 | 0.812007682917219 | 0.807903223542711 | true | false | false | true | ||||||||||||||||
| bfa42593-75a1-4bbb-99c4-96eeb993171b | 2026-09-09 14:08 | 2026-09-09 14:07 | 2026-09-09 14:07 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.8000 | 3.8000 | 3.8500 | 27.5900 | 25460.00 | 0.00 | 25460.00 | 67 | 8 | 514 | 456 | 1.12719298245614 | 0.798315298619639 | 0.798315298619639 | false | false | false | true | ||||||||||||||||
| 5a50461c-caab-4806-9d8a-17f3e25fff1b | 2026-09-09 14:07 | 2026-09-09 14:07 | 2026-09-09 14:07 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.8000 | 3.8000 | 3.8500 | 27.5901 | 27740.00 | 0.00 | 27740.00 | 73 | 15 | 434 | 456 | 0.951754385964912 | 0.798303646032599 | 0.798303646032599 | false | false | false | true | ||||||||||||||||
| 214f0fb3-da46-40ed-a186-d73193739e76 | 2026-09-04 09:36 | 2026-09-04 09:36 | 2026-09-04 09:36 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 3.8200 | 3.7500 | 4.1500 | 27.7400 | 76476.00 | 0.00 | 76476.00 | 200 | 15 | 201 | 532 | 0.37781954887218 | 0.744011214982697 | 0.783946677283565 | false | false | false | true | ||||||||||||||||
| 14151477-d793-496d-9db2-eb04f9c61b2d | 2026-09-03 12:01 | 2026-09-03 12:01 | 2026-09-03 12:01 | HIMS | HIMS261120C00028000 | call | 28.0000 | 2026-11-20 | 4.1500 | 4.1000 | 4.2500 | 27.9450 | 12450.00 | 0.00 | 12450.00 | 30 | 8 | 241 | 425 | 0.567058823529412 | 0.794783520520522 | 0.794783520520522 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:53:17.072904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 6480400110.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |