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_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 | 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 |
|---|
| 470d9875-d438-43f8-a022-c568ad0b1701 | 2026-08-26 13:30 | 2026-08-26 13:30 | 2026-08-26 13:30 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.1700 | 0.9800 | 1.1800 | 21.4700 | 58300.00 | 58300.00 | 0.00 | 500 | 5 | 1010 | 1397 | 0.722977809591983 | 1.06076634667927 | 1.06076634667927 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 2196101153.00 | 2026-11-09 | 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 |
| 778bc47a-4bbb-41b7-b883-17848743515a | 2026-08-26 13:38 | 2026-08-26 13:38 | 2026-08-26 13:38 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.1400 | 1.0300 | 1.2300 | 21.4900 | 28442.00 | 18140.00 | 6912.00 | 250 | 10 | 1260 | 1397 | 0.901932712956335 | 1.05111903142301 | 1.05111903142301 | false | false | false | true | ||||||||||||||||
| caa333be-38c7-4915-8a78-165315c54784 | 2026-08-27 09:52 | 2026-08-27 09:52 | 2026-08-27 09:52 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.6000 | 1.4500 | 1.6000 | 23.1100 | 15979.00 | 12640.00 | 3339.00 | 100 | 8 | 153 | 2844 | 0.0537974683544304 | 1.0669846972699 | 1.0669846972699 | false | false | false | true | ||||||||||||||||
| 3949c3a0-023b-42d2-ac1a-68a838c25ad5 | 2026-08-31 12:20 | 2026-08-31 12:20 | 2026-08-31 12:20 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.2500 | 1.1800 | 1.3000 | 23.7200 | 16801.00 | 12165.00 | 1386.00 | 134 | 10 | 231 | 3707 | 0.0623145400593472 | 0.929077785809197 | 0.93250500934217 | false | false | false | true | ||||||||||||||||
| df22addf-e401-49c2-ac8b-4cf3d7c36729 | 2026-08-31 12:20 | 2026-08-31 12:20 | 2026-08-31 12:20 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.2400 | 1.1900 | 1.3000 | 23.6900 | 16430.00 | 7976.00 | 2861.00 | 132 | 10 | 363 | 3707 | 0.0979228486646884 | 0.928697848522689 | 0.932137061292595 | false | false | false | true | ||||||||||||||||
| 2aab710a-4e00-4cc4-a492-46d6c4322349 | 2026-08-31 12:42 | 2026-08-31 12:42 | 2026-08-31 12:42 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.2900 | 1.1700 | 1.4900 | 23.7050 | 32335.00 | 19630.00 | 12705.00 | 250 | 9 | 855 | 3707 | 0.230644726193688 | 0.947702123300353 | 0.94088093724753 | true | false | false | true | ||||||||||||||||
| c83a6a18-464b-4d75-b9b2-e6429bf370d1 | 2026-08-31 15:06 | 2026-08-31 15:06 | 2026-08-31 15:06 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.4100 | 1.3100 | 1.5000 | 24.2100 | 35164.00 | 30824.00 | 4340.00 | 250 | 8 | 1189 | 3707 | 0.320744537361748 | 0.928764436017456 | 0.928764436017456 | false | false | false | true | ||||||||||||||||
| 7c4adfa0-9e88-410c-a644-9b21e950b35e | 2026-09-03 11:10 | 2026-09-03 11:10 | 2026-09-03 11:10 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9500 | 1.9000 | 1.9500 | 26.3300 | 35685.00 | 35685.00 | 0.00 | 183 | 11 | 438 | 4833 | 0.090626939788951 | 0.896494071054392 | 0.896494071054392 | true | false | false | true | ||||||||||||||||
| 49f69160-33da-4a16-9d1c-4553ccdfd901 | 2026-09-03 11:10 | 2026-09-03 11:10 | 2026-09-03 11:10 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9500 | 1.9500 | 1.9700 | 26.3057 | 11700.00 | 0.00 | 9360.00 | 60 | 6 | 255 | 4833 | 0.0527622594661701 | 0.899274111003241 | 0.899274111003241 | false | false | false | true | ||||||||||||||||
| 9fdae22f-7668-46f9-80a0-31912b48d659 | 2026-09-03 11:12 | 2026-09-03 11:11 | 2026-09-03 11:11 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9900 | 1.7900 | 1.9900 | 26.2800 | 13315.00 | 13315.00 | 0.00 | 67 | 13 | 506 | 4833 | 0.104696875646596 | 0.913695434258599 | 0.910827134328158 | false | false | false | true | ||||||||||||||||
| 2680ae78-1f3d-419e-af9d-20fcc9aa91ee | 2026-09-03 11:23 | 2026-09-03 11:23 | 2026-09-03 11:23 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 2.0000 | 1.8800 | 2.0000 | 26.7700 | 65800.00 | 65800.00 | 0.00 | 329 | 6 | 939 | 4833 | 0.194289261328367 | 0.860146787233301 | 0.860146787233301 | true | false | false | true | ||||||||||||||||
| fe0c3a98-7d71-4063-b452-e92f79b17cd4 | 2026-09-03 13:36 | 2026-09-03 13:36 | 2026-09-03 13:36 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 2.1000 | 1.8800 | 2.1000 | 27.0300 | 19110.00 | 19110.00 | 0.00 | 91 | 17 | 1081 | 4833 | 0.223670597972274 | 0.857738994799717 | 0.857738994799717 | true | false | false | true | ||||||||||||||||
| ee4b716c-cbb6-4d81-b1cb-ee6bf07425f2 | 2026-09-03 14:10 | 2026-09-03 14:09 | 2026-09-03 14:09 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 2.1000 | 1.9600 | 2.2000 | 27.0900 | 57750.00 | 57750.00 | 0.00 | 275 | 5 | 1391 | 4833 | 0.287812952617422 | 0.850734986022952 | 0.850734986022952 | false | false | false | true | ||||||||||||||||
| b47024b7-4ee1-49ac-84d5-dd4227c60a82 | 2026-09-08 09:32 | 2026-09-08 09:32 | 2026-09-08 09:32 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.3700 | 1.3700 | 1.5900 | 25.8300 | 34250.00 | 0.00 | 34250.00 | 250 | 17 | 253 | 4494 | 0.0562972852692479 | 0.830855549496183 | 0.830855549496183 | true | false | false | true | ||||||||||||||||
| 7e69d325-7fa7-40fe-829b-25ac9e51afec | 2026-09-10 13:38 | 2026-09-10 13:38 | 2026-09-10 13:38 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.6600 | 1.5800 | 1.7800 | 27.3200 | 61579.00 | 2152.00 | 55941.00 | 371 | 26 | 739 | 5607 | 0.131799536293918 | 0.76008861846406 | 0.767947697155845 | true | false | false | true | ||||||||||||||||
| a8587ca7-ab5f-4247-9b9e-f376e7701a96 | 2026-09-14 15:47 | 2026-09-14 15:47 | 2026-09-14 15:47 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 2.2300 | 2.2300 | 2.3000 | 28.0000 | 10704.00 | 0.00 | 10704.00 | 48 | 7 | 699 | 6172 | 0.113253402462735 | 0.775412949862989 | 0.775412949862989 | false | false | false | true | ||||||||||||||||
| 7a6f4909-a09b-4afe-b12c-2667d5e2d022 | 2026-09-21 12:13 | 2026-09-21 12:13 | 2026-09-21 12:13 | ASST | ASST261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9400 | 1.8900 | 2.0400 | 29.0000 | 29036.00 | 2167.00 | 26869.00 | 150 | 6 | 956 | 6521 | 0.14660328170526 | 0.782159047413294 | 0.782159047413294 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| 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 |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2196101153.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2294445331.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |