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.
Simplify Analyticsuw_flow_alerts326,449 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 |
|---|
| 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 |
|---|
| dbaeb5c3-333f-448b-9549-f43f090f2edc | 2026-09-17 09:56 | 2026-09-17 09:56 | 2026-09-17 09:56 | AEHR | AEHR260918C00088000 | call | 88.0000 | 2026-09-18 | 3.3800 | 3.0000 | 4.6000 | 89.5000 | 67690.00 | 0.00 | 67690.00 | 200 | 6 | 408 | 459 | 0.888888888888889 | 1.4121302652258 | 1.4121302652258 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 2953781748.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 7337ee95-d7f4-4274-a981-66077b944ac6 | 2026-09-16 15:52 | 2026-09-16 15:52 | 2026-09-16 15:52 | AEHR | AEHR260925C00084000 | call | 84.0000 | 2026-09-25 | 5.7100 | 4.7000 | 6.8000 | 84.0000 | 46276.00 | 0.00 | 34776.00 | 81 | 7 | 392 | 31 | 12.6451612903226 | 1.06418777452217 | 1.06418777452217 | false | false | false | |||||||||||||||||
| 4ad597d9-e783-4679-8eaa-9daeb267f9a7 | 2026-09-16 14:10 | 2026-09-16 14:09 | 2026-09-16 14:09 | AEHR | AEHR260918C00085000 | call | 85.0000 | 2026-09-18 | 3.4000 | 3.1000 | 3.6000 | 84.8850 | 26489.00 | 10843.00 | 15646.00 | 78 | 16 | 107 | 343 | 0.311953352769679 | 1.41063577778769 | 1.32744805607078 | true | false | false | |||||||||||||||||
| 6e179fd3-d6c9-4c37-b106-0601777ecf68 | 2026-09-16 14:08 | 2026-09-16 14:08 | 2026-09-16 14:08 | AEHR | AEHR260918C00082000 | call | 82.0000 | 2026-09-18 | 4.9400 | 4.1000 | 5.0000 | 84.5800 | 98871.00 | 98871.00 | 0.00 | 200 | 13 | 346 | 113 | 3.06194690265487 | 1.44467337370178 | 1.35946618315204 | true | false | false | |||||||||||||||||
| f8eec0de-fc5e-4d5d-a148-3ce33d212502 | 2026-09-16 13:03 | 2026-09-16 13:03 | 2026-09-16 13:03 | AEHR | AEHR261218C00100000 | call | 100.0000 | 2026-12-18 | 12.0300 | 12.0000 | 12.6000 | 82.2700 | 75800.00 | 7320.00 | 66040.00 | 63 | 13 | 100 | 652 | 0.153374233128834 | 1.07983138571626 | 1.06773016370242 | false | false | false | |||||||||||||||||
| 36c58db4-9791-4bc5-91c9-bf7eb004c16f | 2026-09-14 13:41 | 2026-09-14 13:41 | 2026-09-14 13:41 | AEHR | AEHR260918C00086000 | call | 86.0000 | 2026-09-18 | 5.7800 | 4.6000 | 6.4000 | 87.5401 | 36426.00 | 36426.00 | 0.00 | 63 | 7 | 453 | 143 | 3.16783216783217 | 1.36530256081479 | 1.37367142175664 | true | false | false | |||||||||||||||||
| 2da847f7-58ff-4eea-aa3b-7b6bc11dfc7d | 2026-09-14 09:38 | 2026-09-14 09:38 | 2026-09-14 09:38 | AEHR | AEHR260918C00086000 | call | 86.0000 | 2026-09-18 | 4.8600 | 3.3000 | 5.4000 | 83.0000 | 14568.00 | 13568.00 | 1000.00 | 30 | 7 | 40 | 143 | 0.27972027972028 | 1.6800576774363 | 1.6800576774363 | true | false | false | |||||||||||||||||
| 4f9bc8f5-71b8-40a0-abc4-35aa63d96db1 | 2026-09-08 09:30 | 2026-09-08 09:30 | 2026-09-08 09:30 | AEHR | AEHR261016C00090000 | call | 90.0000 | 2026-10-16 | 13.0200 | 12.0000 | 13.9000 | 90.0100 | 33840.00 | 22100.00 | 11740.00 | 26 | 6 | 41 | 498 | 0.0823293172690763 | 1.1316283682343 | 1.11404329944597 | false | false | false | |||||||||||||||||
| f6e72cbd-91ec-4f00-9e0f-56659d98058f | 2026-09-04 14:13 | 2026-09-04 14:12 | 2026-09-04 14:12 | AEHR | AEHR260918P00075000 | put | 75.0000 | 2026-09-18 | 2.7100 | 2.6000 | 3.0000 | 84.3000 | 27918.00 | 2970.00 | 24948.00 | 103 | 40 | 394 | 703 | 0.560455192034139 | 1.0271794003801 | 1.01946986984959 | true | false | false | |||||||||||||||||
| cd9ad2ad-ca35-46e5-8167-1807e36ae247 | 2026-09-04 14:13 | 2026-09-04 14:12 | 2026-09-04 14:12 | AEHR | AEHR260918P00075000 | put | 75.0000 | 2026-09-18 | 2.7800 | 2.7000 | 3.0000 | 84.3000 | 13058.00 | 0.00 | 13058.00 | 47 | 6 | 291 | 703 | 0.413940256045519 | 1.03870749377124 | 1.03870749377124 | false | false | false | |||||||||||||||||
| 155b6a91-eb17-4fbe-a6c3-edc46a89a329 | 2026-09-04 11:41 | 2026-09-04 11:40 | 2026-09-04 11:40 | AEHR | AEHR261218C00175000 | call | 175.0000 | 2026-12-18 | 4.1000 | 3.6000 | 4.1000 | 84.5100 | 66000.00 | 66000.00 | 0.00 | 161 | 25 | 175 | 246 | 0.711382113821138 | 1.1270983927329 | 1.1270983927329 | false | false | false | |||||||||||||||||
| 5c77371c-b256-4651-bfb9-58e3dcc580ba | 2026-09-04 10:19 | 2026-09-04 10:18 | 2026-09-04 10:18 | AEHR | AEHR260918C00086000 | call | 86.0000 | 2026-09-18 | 6.1400 | 5.5000 | 6.5000 | 84.0000 | 122700.00 | 104250.00 | 0.00 | 200 | 6 | 200 | 17 | 11.7647058823529 | 1.06389696004958 | 1.06389696004958 | false | false | false | |||||||||||||||||
| c94912e4-bec1-4f48-9588-51584f47ce3a | 2026-09-03 14:21 | 2026-09-03 14:21 | 2026-09-03 14:21 | AEHR | AEHR261016P00075000 | put | 75.0000 | 2026-10-16 | 10.4000 | 9.9000 | 10.6000 | 75.1000 | 386871.00 | 385831.00 | 1040.00 | 372 | 53 | 606 | 104 | 5.82692307692308 | 1.05088348810234 | 1.04046554710388 | false | false | false | |||||||||||||||||
| af56da79-3015-4fce-ad9a-79d68fbf56f8 | 2026-08-31 15:35 | 2026-08-31 15:35 | 2026-08-31 15:35 | AEHR | AEHR260918P00060000 | put | 60.0000 | 2026-09-18 | 0.7000 | 0.7000 | 0.8500 | 79.1400 | 14003.00 | 0.00 | 14003.00 | 200 | 5 | 214 | 634 | 0.337539432176656 | 0.984640249794081 | 0.977160223508105 | false | false | false | |||||||||||||||||
| c65a4b7c-1e21-4764-8f26-38f64d330183 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | AEHR | AEHR270115C00200000 | call | 200.0000 | 2027-01-15 | 8.8300 | 8.5000 | 10.5000 | 94.0100 | 10600.00 | 0.00 | 10600.00 | 12 | 5 | 12 | 166 | 0.072289156626506 | 1.22162939889746 | 1.21659903634231 | false | false | false | |||||||||||||||||
| eb6dc273-1ae7-4035-8e50-8b81b5f30134 | 2026-08-18 13:16 | 2026-08-18 13:16 | 2026-08-18 13:16 | AEHR | AEHR260918C00140000 | call | 140.0000 | 2026-09-18 | 11.1800 | 10.8000 | 11.9000 | 123.6250 | 15656.00 | 0.00 | 15656.00 | 14 | 5 | 44 | 208 | 0.211538461538462 | 1.1875010285286 | 1.1875010285286 | false | false | false | |||||||||||||||||
| b146c228-4653-4bb2-93f8-c0a5c0926fbf | 2026-08-17 09:52 | 2026-08-17 09:52 | 2026-08-17 09:52 | AEHR | AEHR260821C00137000 | call | 137.0000 | 2026-08-21 | 9.1900 | 7.3000 | 9.6000 | 138.2500 | 91911.00 | 91911.00 | 0.00 | 100 | 7 | 101 | 25 | 4.04 | 1.5835220049512 | 1.47551432062464 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2748272913.00 |
| 2026-10-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2748272913.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2748272913.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2748272913.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 2719566917.00 |
| 2026-10-05 |
| 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 |