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_alerts375,978 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 |
|---|
| a3972b4f-e28f-45a9-82e1-e32205645feb | 2026-08-24 10:31 | 2026-08-24 10:31 | 2026-08-24 10:31 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 4.7000 | 4.5000 | 4.7500 | 106.8750 | 272101.00 | 264111.00 | 7990.00 | 579 | 57 | 667 | 2152 | 0.309944237918216 | 0.650472748848657 | 0.648845928795217 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 90392754653.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce44e4e1-e8bc-4d5b-bc79-b7ea9551fd77 | 2026-09-03 10:41 | 2026-09-03 10:41 | 2026-09-03 10:41 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 9.8000 | 9.6000 | 9.9500 | 121.7148 | 65660.00 | 34300.00 | 31360.00 | 67 | 5 | 1186 | 3161 | 0.375197722239798 | 0.660349730372434 | 0.660349730372434 | false | false | false | true | ||||||||||||||||
| 164ae5af-3a8e-4afb-acc0-5de1ef17f637 | 2026-09-10 15:14 | 2026-09-10 15:14 | 2026-09-10 15:14 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 5.2000 | 5.2000 | 5.3000 | 114.3000 | 113880.00 | 0.00 | 113880.00 | 219 | 27 | 801 | 3538 | 0.2263990955342 | 0.632543875917019 | 0.632543875917019 | false | false | false | true | ||||||||||||||||
| f05c0327-9d22-4f81-980f-0df37ff6bd72 | 2026-09-14 10:27 | 2026-09-14 10:27 | 2026-09-14 10:27 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 4.4000 | 4.3500 | 4.5000 | 113.3100 | 163240.00 | 0.00 | 163240.00 | 371 | 5 | 966 | 3985 | 0.242409033877039 | 0.636192003658739 | 0.636192003658739 | false | false | false | true | ||||||||||||||||
| 0ef04d1c-f6b8-4d27-a0cb-dc23eda34a75 | 2026-09-14 13:01 | 2026-09-14 13:01 | 2026-09-14 13:01 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 4.7000 | 4.6500 | 4.7500 | 114.3300 | 220902.00 | 79430.00 | 115152.00 | 470 | 41 | 2449 | 3985 | 0.614554579673777 | 0.630806058274575 | 0.631655364975555 | false | false | false | true | ||||||||||||||||
| 72dfead2-a403-4473-ab85-acbd102ee9e4 | 2026-09-14 13:30 | 2026-09-14 13:30 | 2026-09-14 13:30 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 5.0000 | 4.8500 | 5.0000 | 114.8350 | 223500.00 | 223500.00 | 0.00 | 447 | 29 | 2998 | 3985 | 0.752321204516939 | 0.640794879211032 | 0.640794879211032 | false | false | false | true | ||||||||||||||||
| 7625dbc8-50c8-476e-8db7-ec98c80b6a39 | 2026-09-14 13:34 | 2026-09-14 13:34 | 2026-09-14 13:34 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 4.9000 | 4.9000 | 5.0000 | 114.5450 | 94080.00 | 0.00 | 94080.00 | 192 | 11 | 3195 | 3985 | 0.801756587202007 | 0.641296960654026 | 0.641296960654026 | false | false | false | true | ||||||||||||||||
| 4b2c463c-381a-4518-bad7-3d5bc263bb37 | 2026-09-15 09:49 | 2026-09-15 09:49 | 2026-09-15 09:49 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 3.1000 | 3.1000 | 3.2000 | 109.4600 | 279212.00 | 0.00 | 279212.00 | 900 | 35 | 1606 | 5483 | 0.292905343789896 | 0.636256279692313 | 0.63719932769832 | false | false | false | true | ||||||||||||||||
| aefcbace-3a58-4c50-bd64-e9fb91b2d479 | 2026-09-15 09:55 | 2026-09-15 09:55 | 2026-09-15 09:55 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 3.1500 | 3.1000 | 3.2000 | 109.8000 | 71190.00 | 50400.00 | 5985.00 | 226 | 18 | 2474 | 5483 | 0.451212839686303 | 0.632894541945478 | 0.632184145723422 | false | false | false | true | ||||||||||||||||
| 4f226ada-cd89-4d2d-b7dd-6cd2af700d10 | 2026-09-15 09:55 | 2026-09-15 09:55 | 2026-09-15 09:55 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 3.1500 | 3.0500 | 3.2000 | 109.8300 | 80010.00 | 67410.00 | 3150.00 | 254 | 19 | 2248 | 5483 | 0.409994528542769 | 0.631538300538408 | 0.63140912798812 | false | false | false | true | ||||||||||||||||
| 299ec57c-0f95-4b55-91a3-a639a04c821e | 2026-09-15 13:28 | 2026-09-15 13:28 | 2026-09-15 13:28 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 3.3600 | 3.3500 | 3.4500 | 110.7100 | 53080.00 | 0.00 | 53080.00 | 158 | 10 | 4150 | 5483 | 0.756884917016232 | 0.626882817818496 | 0.629598137959485 | false | false | false | true | ||||||||||||||||
| 888c5404-f6d4-4d9b-bafb-c8592d504645 | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.1000 | 8.1000 | 8.1500 | 124.3300 | 20250.00 | 0.00 | 20250.00 | 25 | 5 | 1258 | 6786 | 0.185381668140289 | 0.636528809693034 | 0.636528809693034 | true | false | false | true | ||||||||||||||||
| ee86cf4e-22a5-4153-bdb7-5db8bc05444e | 2026-09-21 11:03 | 2026-09-21 11:03 | 2026-09-21 11:03 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 7.7500 | 7.6000 | 7.8000 | 123.7147 | 10850.00 | 9300.00 | 1550.00 | 14 | 8 | 1577 | 6786 | 0.232390215148836 | 0.634245297962046 | 0.634245297962046 | true | false | false | true | ||||||||||||||||
| afbf7553-b588-4860-8f61-2de6920f3134 | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.1500 | 8.1500 | 8.2500 | 124.7200 | 93725.00 | 0.00 | 93725.00 | 115 | 27 | 2650 | 6786 | 0.390509873268494 | 0.624021955553678 | 0.624433353009876 | true | false | false | true | ||||||||||||||||
| 95fcc3b6-7f83-40e1-a97f-17bd6716fa1e | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 7.5000 | 7.5000 | 7.6000 | 123.3250 | 18752.00 | 0.00 | 18752.00 | 25 | 6 | 2913 | 6786 | 0.429266136162688 | 0.630294891617012 | 0.63107163936688 | false | false | false | true | ||||||||||||||||
| 9beae95e-d1cb-4878-849f-328f8437ad87 | 2026-09-22 11:48 | 2026-09-22 11:48 | 2026-09-22 11:48 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.0000 | 7.8500 | 8.0000 | 124.8000 | 17600.00 | 17600.00 | 0.00 | 22 | 8 | 712 | 6732 | 0.105763517528223 | 0.624784117757792 | 0.622685311654072 | false | false | false | true | ||||||||||||||||
| 05822f3a-9df3-4277-8320-ed2bdb2f70a8 | 2026-09-22 12:01 | 2026-09-22 12:01 | 2026-09-22 12:01 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 7.8000 | 7.7500 | 7.9500 | 124.5600 | 37440.00 | 8580.00 | 28860.00 | 48 | 17 | 838 | 6732 | 0.12448009506833 | 0.614909050940559 | 0.616992729155819 | false | false | false | true | ||||||||||||||||
| e984b8f1-8e4d-413b-97ea-19718fb000f5 | 2026-09-22 14:19 | 2026-09-22 14:19 | 2026-09-22 14:19 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 7.8000 | 7.6500 | 7.8000 | 124.5000 | 14820.00 | 14820.00 | 0.00 | 19 | 7 | 1045 | 6732 | 0.155228758169935 | 0.619489145616679 | 0.619489145616679 | true | false | false | true | ||||||||||||||||
| d1294134-7e77-4556-a5a6-63f294b2eee9 | 2026-09-22 15:22 | 2026-09-22 15:22 | 2026-09-22 15:22 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.0000 | 7.8500 | 8.0500 | 124.9150 | 10400.00 | 10400.00 | 0.00 | 13 | 8 | 1112 | 6732 | 0.165181224004753 | 0.617846231931735 | 0.617846231931735 | true | false | false | true | ||||||||||||||||
| e4e81d9d-d879-454f-bca8-0df67c8f720d | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.9500 | 8.8500 | 8.9500 | 126.0000 | 16110.00 | 16110.00 | 0.00 | 18 | 8 | 86 | 7042 | 0.0122124396478273 | 0.632208976866561 | 0.632208976866561 | true | false | false | true | ||||||||||||||||
| 34e8dbb6-e371-4fbd-9c37-c1a5b10067f5 | 2026-09-23 10:21 | 2026-09-23 10:21 | 2026-09-23 10:21 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 7.7500 | 7.6500 | 7.7500 | 124.4800 | 10075.00 | 10075.00 | 0.00 | 13 | 5 | 238 | 7042 | 0.0337972166998012 | 0.630117307179375 | 0.630117307179375 | false | false | false | true | ||||||||||||||||
| 8ff95590-2acc-4766-9950-2a15e3b90cf8 | 2026-09-23 12:28 | 2026-09-23 12:28 | 2026-09-23 12:28 | HOOD | HOOD261016C00125000 | call | 125.0000 | 2026-10-16 | 8.1000 | 7.9500 | 8.1000 | 125.2950 | 24295.00 | 24295.00 | 0.00 | 30 | 5 | 458 | 7042 | 0.0650383413802897 | 0.623185152431368 | 0.619176534898036 | false | false | false | true |
| 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:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-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 |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 97484707852.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |