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_alerts523,327 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 |
|---|
| 64cfc9d4-6537-4513-b611-67eb4a35ceae | 2026-09-24 15:16 | 2026-09-24 15:16 | 2026-09-24 15:16 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 9.9900 | 9.6000 | 10.7000 | 173.0000 | 24979.00 | 0.00 | 24979.00 | 25 | 13 | 31 | 654 | 0.0474006116207951 | 0.852745132689208 | 0.852745132689208 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 15802828251.00 | 2026-11-23 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T19:21:59.976006Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 41709aae-aa60-4287-82ba-c9de19b22324 | 2026-09-21 10:39 | 2026-09-21 10:39 | 2026-09-21 10:39 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 14.2000 | 13.2000 | 14.4000 | 180.0100 | 12780.00 | 7100.00 | 5680.00 | 9 | 5 | 23 | 623 | 0.0369181380417336 | 0.860869913878754 | 0.860869913878754 | false | false | false | true | ||||||||||||||||
| 5675d753-cb5d-40a0-a7dc-6b5a22759955 | 2026-09-17 13:46 | 2026-09-17 13:46 | 2026-09-17 13:46 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 15.3000 | 14.8000 | 15.4000 | 179.0600 | 10710.00 | 6120.00 | 3060.00 | 7 | 7 | 43 | 606 | 0.070957095709571 | 0.87578511334258 | 0.87578511334258 | true | false | false | true | ||||||||||||||||
| f9c33b93-b604-402f-b02d-166ea51d4652 | 2026-09-17 12:52 | 2026-09-17 12:52 | 2026-09-17 12:52 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 16.2000 | 15.4000 | 16.5000 | 181.1700 | 16200.00 | 12960.00 | 3240.00 | 10 | 7 | 26 | 606 | 0.0429042904290429 | 0.867019453544949 | 0.867019453544949 | true | false | false | true | ||||||||||||||||
| bf1d4185-5d9f-48f5-bea3-4975a7091c74 | 2026-09-11 12:33 | 2026-09-11 12:33 | 2026-09-11 12:33 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 10.6000 | 10.1000 | 10.6000 | 169.1700 | 45580.00 | 45580.00 | 0.00 | 43 | 6 | 122 | 485 | 0.251546391752577 | 0.785983440279898 | 0.785983440279898 | false | false | false | true | ||||||||||||||||
| d3254999-4303-45aa-babb-e1bfa179e37f | 2026-09-11 10:48 | 2026-09-11 10:48 | 2026-09-11 10:48 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 10.0000 | 9.0000 | 10.0000 | 166.8000 | 17000.00 | 17000.00 | 0.00 | 17 | 5 | 21 | 485 | 0.0432989690721649 | 0.8033007695349 | 0.8033007695349 | false | false | false | true | ||||||||||||||||
| 9a69b75d-615d-4b2b-a365-5746c09b9d10 | 2026-09-09 11:13 | 2026-09-09 11:13 | 2026-09-09 11:13 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 10.8000 | 10.8000 | 11.0000 | 165.1100 | 27000.00 | 0.00 | 27000.00 | 25 | 6 | 168 | 286 | 0.587412587412587 | 0.853025999653581 | 0.853025999653581 | true | false | false | true | ||||||||||||||||
| fe5bb201-9ea6-40d9-be48-98cca1fed307 | 2026-09-09 11:06 | 2026-09-09 11:06 | 2026-09-09 11:06 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 11.4000 | 11.4000 | 11.8000 | 166.7100 | 18240.00 | 0.00 | 18240.00 | 16 | 6 | 143 | 286 | 0.5 | 0.851002910950951 | 0.851002910950951 | true | false | false | true | ||||||||||||||||
| e1f18c15-4854-456f-9123-91906b8968c3 | 2026-09-09 10:14 | 2026-09-09 10:14 | 2026-09-09 10:14 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 11.8000 | 11.8000 | 12.1000 | 167.6700 | 35400.00 | 0.00 | 35400.00 | 30 | 5 | 30 | 286 | 0.104895104895105 | 0.851237666573681 | 0.851237666573681 | true | false | false | true | ||||||||||||||||
| 9b88246d-bf54-4690-8c46-16668e46e835 | 2026-09-08 10:51 | 2026-09-08 10:51 | 2026-09-08 10:51 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 9.2900 | 9.1000 | 9.3000 | 160.2100 | 20440.00 | 19530.00 | 910.00 | 22 | 7 | 23 | 285 | 0.0807017543859649 | 0.858567534036729 | 0.858567534036729 | false | false | false | true | ||||||||||||||||
| 90c6cdbd-ce88-44b5-8820-c8d2801af3be | 2026-08-26 13:59 | 2026-08-26 13:59 | 2026-08-26 13:59 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 5.1000 | 4.8000 | 5.1000 | 139.7300 | 139226.00 | 139226.00 | 0.00 | 273 | 38 | 282 | 4 | 70.5 | 0.831564222116647 | 0.831564222116647 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16553166284.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16629693297.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 16629693297.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| 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 |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |