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_alerts609,118 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 |
|---|
| 9663bb50-0fe5-44ff-9126-5b83a855ffc1 | 2026-08-31 09:35 | 2026-08-31 09:35 | 2026-08-31 09:35 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 0.4600 | 0.4000 | 0.5000 | 5.0700 | 110306.00 | 960.00 | 95846.00 | 2424 | 83 | 18693 | 2070 | 9.0304347826087 | 1.10444301460984 | 1.06150976476037 | false | 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-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f329ed0e-1cc7-45f8-b1e2-bf7b17adebdd | 2026-08-31 12:07 | 2026-08-31 12:07 | 2026-08-31 12:07 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 0.5900 | 0.5500 | 0.6500 | 5.3280 | 23602.00 | 18000.00 | 5362.00 | 397 | 8 | 65091 | 2070 | 31.4449275362319 | 1.11390768514944 | 1.08727982700127 | false | false | false | |||||||||||||||||
| f43f9e3b-5865-464a-8e3b-e68d030e7224 | 2026-09-01 09:41 | 2026-09-01 09:41 | 2026-09-01 09:41 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 0.6000 | 0.6000 | 0.6500 | 5.2100 | 119468.00 | 630.00 | 118838.00 | 1987 | 113 | 6418 | 53425 | 0.120131024801123 | 1.24157980737763 | 1.20025018230625 | false | false | false | |||||||||||||||||
| c0db207b-697f-4a41-aa72-579089bd2ace | 2026-09-02 09:33 | 2026-09-02 09:33 | 2026-09-02 09:33 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 0.7100 | 0.7000 | 0.7500 | 5.4700 | 25730.00 | 0.00 | 25730.00 | 364 | 21 | 667 | 64978 | 0.0102650127735541 | 1.20834320976685 | 1.20834320976685 | false | false | false | |||||||||||||||||
| ca64066e-129e-4173-ae65-3774b72288f8 | 2026-09-03 11:33 | 2026-09-03 11:33 | 2026-09-03 11:33 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 0.9900 | 0.9500 | 1.0500 | 6.0750 | 14846.00 | 4558.00 | 2288.00 | 150 | 16 | 9085 | 66679 | 0.136249793788149 | 1.16523514083969 | 1.09561569868889 | false | false | false | |||||||||||||||||
| 694fee1a-c1c2-4869-a683-178957e9b5d9 | 2026-09-03 12:48 | 2026-09-03 12:48 | 2026-09-03 12:48 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 1.1500 | 1.1500 | 1.2000 | 6.3450 | 19104.00 | 0.00 | 19104.00 | 166 | 16 | 61155 | 66679 | 0.917155326264641 | 1.14568273407059 | 1.13734504846101 | false | false | false | |||||||||||||||||
| 5ff02f59-c565-4d29-8005-13e0f46c3077 | 2026-09-03 13:37 | 2026-09-03 13:37 | 2026-09-03 13:37 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 1.2000 | 1.1500 | 1.2000 | 6.4099 | 16168.00 | 15700.00 | 468.00 | 135 | 15 | 65409 | 66679 | 0.980953523598134 | 1.14756873132834 | 1.14756873132834 | false | false | false | |||||||||||||||||
| eb89ee2d-c223-44ef-a15b-7ebc42d51b97 | 2026-09-03 13:53 | 2026-09-03 13:53 | 2026-09-03 13:53 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 1.1100 | 1.1000 | 1.1500 | 6.3300 | 27637.00 | 5085.00 | 22552.00 | 250 | 7 | 66780 | 66679 | 1.00151471977684 | 1.12453645744145 | 1.08783533647278 | false | false | false | |||||||||||||||||
| be79f9a5-c7d0-4dae-b0a7-15b0ac6773e3 | 2026-09-03 15:10 | 2026-09-03 15:09 | 2026-09-03 15:09 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 1.1900 | 1.1500 | 1.2500 | 6.3800 | 12778.00 | 9600.00 | 3058.00 | 107 | 22 | 72457 | 66679 | 1.08665396901573 | 1.17113243563663 | 1.17113243563663 | false | false | false | |||||||||||||||||
| fa9101f6-8483-4a63-a8ea-01195d599ba7 | 2026-09-03 15:15 | 2026-09-03 15:15 | 2026-09-03 15:15 | DPRO | DPRO261016C00006000 | call | 6.0000 | 2026-10-16 | 1.2400 | 1.2000 | 1.2500 | 6.4600 | 12437.00 | 12437.00 | 0.00 | 100 | 10 | 72782 | 66679 | 1.09152806730755 | 1.16887398996621 | 1.16887398996621 | true | 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-08-31T16:39:59.140702Z"} |
| 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-01T13:44:23.259187Z"} |
| 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-02T13:42:51.501101Z"} |
| 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: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-03T17:55:09.170571Z"} |
| 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-03T17:55:09.170571Z"} |
| 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-03T19:29:59.445996Z"} |
| 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-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |