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 |
|---|
| 16c3b0cf-09a3-4f66-b021-acb5e2f2c502 | 2026-08-18 15:06 | 2026-08-18 15:05 | 2026-08-18 15:05 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 3.0100 | 3.0000 | 3.1000 | 92.9400 | 54200.00 | 0.00 | 54200.00 | 180 | 6 | 377 | 11838 | 0.0318465957087346 | 0.634478288318927 | 0.636061991949667 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 90392754653.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 985a8afc-6bcf-4ae7-b897-8253f9914f30 | 2026-08-21 13:36 | 2026-08-21 13:36 | 2026-08-21 13:36 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.4000 | 7.4000 | 7.6500 | 108.1267 | 133200.00 | 0.00 | 133200.00 | 180 | 9 | 1310 | 11657 | 0.112378828171914 | 0.679648084307316 | 0.679648084307316 | false | false | false | |||||||||||||||||
| 00692f62-4118-4ac8-b6a7-14c527cae853 | 2026-08-25 11:42 | 2026-08-25 11:42 | 2026-08-25 11:42 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 8.0000 | 7.8000 | 8.0000 | 110.7050 | 53600.00 | 53600.00 | 0.00 | 67 | 14 | 706 | 11051 | 0.0638856212107502 | 0.680858607612129 | 0.680858607612129 | false | false | false | true | ||||||||||||||||
| 68a92756-8929-4d2a-95d6-3408b3263a67 | 2026-09-03 10:16 | 2026-09-03 10:16 | 2026-09-03 10:16 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 11.1000 | 11.1000 | 11.2000 | 120.7900 | 54390.00 | 0.00 | 54390.00 | 49 | 5 | 750 | 13327 | 0.0562767314474375 | 0.685638745342113 | 0.685638745342113 | false | false | false | |||||||||||||||||
| 1bb2e374-32eb-485b-9092-6ac8f51556a6 | 2026-09-03 10:17 | 2026-09-03 10:17 | 2026-09-03 10:17 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 11.1000 | 11.1000 | 11.2000 | 120.7200 | 72150.00 | 0.00 | 72150.00 | 65 | 5 | 855 | 13327 | 0.0641554738500788 | 0.686611806333168 | 0.686611806333168 | false | false | false | |||||||||||||||||
| 12580c70-3552-4b99-b2a8-31c81b556255 | 2026-09-04 10:22 | 2026-09-04 10:21 | 2026-09-04 10:21 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.6500 | 10.6500 | 11.0000 | 121.6900 | 68160.00 | 0.00 | 68160.00 | 64 | 10 | 204 | 12849 | 0.0158767219238851 | 0.661682098232324 | 0.661682098232324 | false | false | false | |||||||||||||||||
| 171b09c5-6bee-406a-bbf9-f736fea02a1e | 2026-09-08 10:01 | 2026-09-08 10:00 | 2026-09-08 10:00 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 11.7500 | 11.6000 | 11.7500 | 123.5999 | 51700.00 | 51700.00 | 0.00 | 44 | 5 | 241 | 13064 | 0.0184476423759951 | 0.684679160785886 | 0.684679160785886 | false | false | false | |||||||||||||||||
| a8da711a-126b-4edd-9ffd-affc2c689752 | 2026-09-08 10:03 | 2026-09-08 10:03 | 2026-09-08 10:03 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 11.6000 | 11.4000 | 11.6000 | 123.3000 | 105560.00 | 105560.00 | 0.00 | 91 | 5 | 483 | 13064 | 0.0369718309859155 | 0.683659439253092 | 0.683659439253092 | false | false | false | |||||||||||||||||
| 3824e799-ad8d-474c-8703-dfb8f815e967 | 2026-09-08 12:13 | 2026-09-08 12:13 | 2026-09-08 12:13 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.8000 | 10.5000 | 10.8000 | 121.0400 | 96120.00 | 96120.00 | 0.00 | 89 | 6 | 870 | 13064 | 0.0665952235150031 | 0.68690147738555 | 0.68690147738555 | false | false | false | true | ||||||||||||||||
| 7801930d-b53a-47f4-afa7-8bd942603659 | 2026-09-08 14:23 | 2026-09-08 14:22 | 2026-09-08 14:22 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.5500 | 10.4000 | 10.5500 | 120.7400 | 105476.00 | 105476.00 | 0.00 | 100 | 21 | 1735 | 13064 | 0.13280771586038 | 0.681988308217126 | 0.680891923711024 | false | false | false | |||||||||||||||||
| 9eb9a3b2-8418-4e18-8598-62dc4a2f1e50 | 2026-09-18 09:57 | 2026-09-18 09:57 | 2026-09-18 09:57 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.2500 | 7.1000 | 7.3000 | 115.3250 | 56550.00 | 56550.00 | 0.00 | 78 | 8 | 402 | 14106 | 0.0284985112717992 | 0.652052499661768 | 0.652052499661768 | false | false | false | true | ||||||||||||||||
| b2e7b461-687e-4807-91fc-1c40f9d348b8 | 2026-09-21 10:34 | 2026-09-21 10:34 | 2026-09-21 10:34 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.5000 | 10.3500 | 10.6000 | 124.2450 | 15750.00 | 14700.00 | 1050.00 | 15 | 6 | 381 | 13945 | 0.0273216206525636 | 0.665102988293208 | 0.665102988293208 | false | false | false | |||||||||||||||||
| c8bb4ef4-f3a9-48ad-bc73-6779b935682b | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.2400 | 10.0500 | 10.3000 | 123.8750 | 100394.00 | 100394.00 | 0.00 | 98 | 5 | 518 | 13945 | 0.0371459304410183 | 0.66299960178434 | 0.660753343087695 | false | false | false | |||||||||||||||||
| ff829a8f-5f75-499b-9f0a-8781217b8dfc | 2026-09-21 15:04 | 2026-09-21 15:04 | 2026-09-21 15:04 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.5000 | 10.4500 | 10.6000 | 124.0000 | 25200.00 | 0.00 | 25200.00 | 24 | 5 | 1242 | 13945 | 0.0890641807099319 | 0.660895297318621 | 0.660895297318621 | false | false | false | |||||||||||||||||
| fc5c3cdf-f9ba-4e41-9dec-d85bfd60ae4c | 2026-09-22 09:58 | 2026-09-22 09:58 | 2026-09-22 09:58 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.6000 | 10.3500 | 10.7500 | 125.0000 | 21200.00 | 8480.00 | 12720.00 | 20 | 6 | 65 | 14331 | 0.0045356220780127 | 0.654770082670871 | 0.654770082670871 | false | false | false | |||||||||||||||||
| fff856b1-4562-4e87-8f39-142276289109 | 2026-09-22 10:41 | 2026-09-22 10:40 | 2026-09-22 10:40 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 9.9000 | 9.9000 | 10.1000 | 123.9300 | 79200.00 | 0.00 | 79200.00 | 80 | 21 | 220 | 14331 | 0.015351336264043 | 0.650092022701346 | 0.650092022701346 | true | false | false | true | ||||||||||||||||
| d8c6c8b5-8d86-4447-a77e-bdb403cd11ed | 2026-09-23 10:14 | 2026-09-23 10:14 | 2026-09-23 10:14 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 10.0500 | 10.0500 | 10.1500 | 124.0000 | 157822.00 | 0.00 | 157822.00 | 157 | 11 | 265 | 14346 | 0.0184720479576188 | 0.653933654714199 | 0.653933654714199 | false | false | false | |||||||||||||||||
| a04c23ad-2403-471a-a768-376b2a90a0e8 | 2026-09-23 10:51 | 2026-09-23 10:51 | 2026-09-23 10:51 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 9.9500 | 9.9500 | 10.1000 | 124.4700 | 1050822.00 | 0.00 | 1050822.00 | 1056 | 60 | 1335 | 14346 | 0.0930572982015893 | 0.647203568723745 | 0.647203568723745 | false | false | false | |||||||||||||||||
| e9b13c79-c36c-4462-a8a4-63985b90e1a6 | 2026-09-25 09:56 | 2026-09-25 09:56 | 2026-09-25 09:56 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.7000 | 7.6000 | 7.8500 | 119.8450 | 46216.00 | 9240.00 | 36976.00 | 60 | 13 | 125 | 14197 | 0.00880467704444601 | 0.62948830463044 | 0.62948830463044 | false | false | false | |||||||||||||||||
| 6b8b0868-5607-40e1-b3c1-aca649e95d1a | 2026-09-25 09:56 | 2026-09-25 09:56 | 2026-09-25 09:56 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.6500 | 7.6000 | 7.8500 | 119.8100 | 179791.00 | 3060.00 | 176731.00 | 235 | 44 | 360 | 14197 | 0.0253574698880045 | 0.627415343491979 | 0.627897736124447 | false | false | false | |||||||||||||||||
| d3e57a0f-4a46-4eec-a581-c3f55273650d | 2026-09-25 10:22 | 2026-09-25 10:22 | 2026-09-25 10:22 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.1000 | 7.0500 | 7.2500 | 118.5700 | 16330.00 | 12780.00 | 3550.00 | 23 | 19 | 655 | 14197 | 0.0461365077128971 | 0.621730833692582 | 0.621730833692582 | false | false | false | |||||||||||||||||
| adf640b1-ec30-4873-88e6-031dfc102940 | 2026-09-25 15:34 | 2026-09-25 15:34 | 2026-09-25 15:34 | HOOD | HOOD270115C00150000 | call | 150.0000 | 2027-01-15 | 7.2500 | 7.2500 | 7.3000 | 119.2450 | 43500.00 | 0.00 | 43500.00 | 60 | 15 | 888 | 14197 | 0.0625484257237445 | 0.618909447750587 | 0.618909447750587 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:24:32.358904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 94733314638.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97484707852.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 97484707852.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97484707852.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 98235806575.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 98235806575.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:14:46.490149Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 94401249940.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 94401249940.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 94401249940.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:22:54.159476Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 94401249940.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |