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 |
|---|
| 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 |
|---|
| a422969d-2a21-4438-90a4-025f758f2071 | 2026-09-03 11:32 | 2026-09-03 11:32 | 2026-09-03 11:32 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6000 | 0.6500 | 6.2500 | 18948.00 | 18948.00 | 0.00 | 292 | 30 | 2998 | 8279 | 0.362121029109796 | 1.2560323054306 | 1.24601014313817 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 161983158.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7934f9d-7bb9-48a7-99a7-d78e6fd029b1 | 2026-09-03 11:32 | 2026-09-03 11:32 | 2026-09-03 11:32 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6000 | 0.7000 | 6.2500 | 22450.00 | 15781.00 | 5694.00 | 346 | 26 | 3608 | 8279 | 0.43580142529291 | 1.24601014313817 | 1.24601014313817 | true | false | false | |||||||||||||||||
| 2abf1f69-1a71-4436-aaad-ec184c13a4d8 | 2026-09-03 11:32 | 2026-09-03 11:32 | 2026-09-03 11:32 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6400 | 0.6000 | 0.6500 | 6.2500 | 16640.00 | 16640.00 | 0.00 | 259 | 13 | 3257 | 8279 | 0.393405000603938 | 1.24601014313817 | 1.24601014313817 | false | false | false | |||||||||||||||||
| bde6f51d-f688-4bc1-9bbd-711b1658ac59 | 2026-09-03 11:39 | 2026-09-03 11:39 | 2026-09-03 11:39 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5900 | 0.5500 | 0.6000 | 6.0900 | 11900.00 | 11900.00 | 0.00 | 200 | 10 | 21170 | 8279 | 2.55707211015823 | 1.26497595136512 | 1.24017240934878 | false | false | false | |||||||||||||||||
| 51c32e3f-ac9d-4b92-91ab-c041f47f026f | 2026-09-03 11:44 | 2026-09-03 11:44 | 2026-09-03 11:44 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5300 | 0.5000 | 0.5500 | 5.9650 | 15351.00 | 13847.00 | 1504.00 | 290 | 134 | 26960 | 8279 | 3.25643193622418 | 1.23783504222867 | 1.26356396950987 | false | false | false | |||||||||||||||||
| 592599ca-5fb0-4533-9219-c50305386b29 | 2026-09-03 12:42 | 2026-09-03 12:42 | 2026-09-03 12:42 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6000 | 0.7000 | 6.3800 | 19468.00 | 16305.00 | 1408.00 | 300 | 18 | 65517 | 8279 | 7.91363691267061 | 1.18119384201803 | 1.18119384201803 | false | false | false | |||||||||||||||||
| 6ff14715-a607-4355-b0da-72c0d320e111 | 2026-09-03 12:47 | 2026-09-03 12:47 | 2026-09-03 12:47 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 6.3650 | 19544.00 | 0.00 | 19544.00 | 300 | 5 | 68413 | 8279 | 8.26343761323831 | 1.20031697554113 | 1.20031697554113 | false | false | false | |||||||||||||||||
| 75118425-c12d-4310-a057-7740db7e445b | 2026-09-03 15:55 | 2026-09-03 15:55 | 2026-09-03 15:55 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.7300 | 0.7000 | 0.7500 | 6.4550 | 14579.00 | 12779.00 | 1800.00 | 200 | 12 | 107046 | 8279 | 12.929822442324 | 1.24700608460324 | 1.235598004168 | false | false | false | |||||||||||||||||
| 8d39bdab-bef5-4e17-96df-88e50105454d | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.3700 | 0.3500 | 0.5000 | 5.7700 | 26485.00 | 1203.00 | 24282.00 | 720 | 73 | 2197 | 95133 | 0.0230939842115775 | 1.30993091130496 | 1.15432876202828 | true | false | false | |||||||||||||||||
| 99e7318a-4a6a-4a61-8ec2-9879d01a7244 | 2026-09-10 09:32 | 2026-09-10 09:32 | 2026-09-10 09:32 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.3000 | 0.3000 | 0.3500 | 5.5400 | 13994.00 | 0.00 | 13994.00 | 465 | 90 | 775 | 102357 | 0.00757153882978204 | 1.21460236439461 | 1.21421635894637 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |