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_alerts566,287 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 | expirydate |
|---|
| 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 |
|---|
| 94187b8f-a991-43de-ac1c-6c4b161c84d6 | 2026-09-17 15:35 | 2026-09-17 15:35 | 2026-09-17 15:35 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 3.4500 | 3.4500 | 3.5500 | 107.9759 | 172500.00 | 0.00 | 172500.00 | 500 | 5 | 3021 | 8927 | 0.338411560434636 | 0.678590443391441 | 0.678590443391441 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 86819105996.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 57e25502-cfbf-4a93-be72-cf3aae651700 | 2026-09-16 14:50 | 2026-09-16 14:50 | 2026-09-16 14:50 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 2.0000 | 1.9800 | 2.0000 | 104.2900 | 57600.00 | 57600.00 | 0.00 | 288 | 6 | 8812 | 7687 | 1.1463509821777 | 0.753370268559964 | 0.753370268559964 | false | false | false | true | false | |||||||||||||||
| 1add03e0-95cb-4abe-a1a1-bdeb268d7274 | 2026-09-16 14:50 | 2026-09-16 14:50 | 2026-09-16 14:50 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 2.0000 | 2.0000 | 2.0500 | 104.3600 | 69401.00 | 0.00 | 69401.00 | 347 | 12 | 8316 | 7687 | 1.08182646025758 | 0.742739882935922 | 0.745994948546252 | true | false | false | true | false | |||||||||||||||
| 856166ff-a172-4b8b-bffa-d208f01153f6 | 2026-09-16 14:40 | 2026-09-16 14:40 | 2026-09-16 14:40 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 2.0700 | 2.0200 | 2.0800 | 104.3200 | 92950.00 | 65005.00 | 0.00 | 450 | 12 | 7501 | 7687 | 0.975803304279953 | 0.771625271050134 | 0.765111323913858 | false | false | false | true | ||||||||||||||||
| 56cdfc1d-5617-4c51-a5e4-616a5335fefa | 2026-09-16 10:24 | 2026-09-16 10:23 | 2026-09-16 10:23 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 2.9900 | 2.9500 | 3.0000 | 105.0000 | 63986.00 | 49335.00 | 0.00 | 214 | 19 | 878 | 7687 | 0.114218810979576 | 0.860607083475632 | 0.860607083475632 | false | false | false | true | ||||||||||||||||
| be2a3101-33ac-4a3d-8f30-85c473f529b3 | 2026-09-09 13:09 | 2026-09-09 13:09 | 2026-09-09 13:09 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 12.2100 | 12.0500 | 12.3000 | 115.0000 | 538400.00 | 523750.00 | 14650.00 | 441 | 20 | 502 | 7501 | 0.0669244100786562 | 0.658378704344462 | 0.691967388101693 | true | false | false | true | ||||||||||||||||
| 7a7b6d12-a7f1-490c-92c4-8a8529b97107 | 2026-08-21 10:29 | 2026-08-21 10:29 | 2026-08-21 10:29 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 8.6000 | 8.5500 | 8.7500 | 106.2800 | 58490.00 | 8610.00 | 49880.00 | 68 | 25 | 4156 | 8438 | 0.49253377577625 | 0.670194617848084 | 0.668572331296967 | true | false | false | true | ||||||||||||||||
| 137863a2-5ad5-4fcf-8b2f-a6c7c9e782a1 | 2026-08-21 09:35 | 2026-08-21 09:30 | 2026-08-21 09:35 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 5.1400 | 0.0000 | 0.0000 | 100.2075 | 781525.00 | 10000.00 | 771525.00 | 1517 | 12 | 2330 | 8438 | 0.276131784783124 | 0 | 0 | true | true | true | true | false | |||||||||||||||
| 99a3f63a-f428-40f2-9a7a-a29de2989cbc | 2026-08-21 09:30 | 2026-08-21 09:30 | 2026-08-21 09:30 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 6.0500 | 6.0000 | 6.5000 | 102.0280 | 60505.00 | 610.00 | 59895.00 | 100 | 5 | 199 | 8438 | 0.0235837876273999 | 0.640483989367091 | 0.64056881965198 | false | false | false | true | ||||||||||||||||
| 0a6d4db1-ef70-4d28-9ee8-d9aaec5745bc | 2026-08-20 10:24 | 2026-08-20 10:24 | 2026-08-20 10:24 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 3.1500 | 3.1000 | 3.2250 | 94.9100 | 84105.00 | 69615.00 | 14490.00 | 267 | 13 | 644 | 8410 | 0.0765755053507729 | 0.624143618088267 | 0.622841764758874 | true | false | false | true | ||||||||||||||||
| d18af7a9-392a-458c-85be-aeafada74bb8 | 2026-08-19 13:27 | 2026-08-19 13:27 | 2026-08-19 13:27 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 3.7000 | 3.7000 | 3.7500 | 96.8300 | 55500.00 | 0.00 | 55500.00 | 150 | 6 | 1435 | 8016 | 0.179016966067864 | 0.60218182854862 | 0.60218182854862 | false | false | false | true | false | |||||||||||||||
| 70aa0fdf-2dd7-4a1c-a389-25f2e9c2163e | 2026-08-19 12:28 | 2026-08-19 12:28 | 2026-08-19 12:28 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 4.7500 | 4.7500 | 4.8000 | 99.2500 | 95950.00 | 0.00 | 95950.00 | 202 | 5 | 1032 | 8016 | 0.12874251497006 | 0.612894707062746 | 0.612894707062746 | false | false | false | true | false | |||||||||||||||
| 81c5fb13-fe00-4494-82f2-72da1b8ceb0c | 2026-08-17 15:22 | 2026-08-17 15:22 | 2026-08-17 15:22 | HOOD | HOOD260918C00105000 | call | 105.0000 | 2026-09-18 | 3.5500 | 3.4000 | 3.6000 | 96.4000 | 298200.00 | 355.00 | 280095.00 | 840 | 35 | 1292 | 6346 | 0.203592814371257 | 0.581567486512177 | 0.582557775987635 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 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-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 36cb34b2-bfec-40a0-b347-859cae1cf152 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 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-08-21T13:35:10.222979Z"} |
| 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-08-20T14:33:56.503993Z"} |
| 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-08-19T17:43:33.841762Z"} |
| 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-08-19T16:52:36.966336Z"} |
| 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-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |