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 | strike |
|---|
| 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 |
|---|
| 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 | 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-10T13:32:54.294551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 1a6c9e84-8b7a-456a-aac6-3fb82ced037f | 2026-09-01 15:50 | 2026-09-01 15:49 | 2026-09-01 15:49 | DPRO | DPRO270115C00005000 | call | 5.0000 | 2027-01-15 | 1.5000 | 1.3500 | 1.6000 | 5.4250 | 58041.00 | 57891.00 | 150.00 | 387 | 21 | 525 | 4228 | 0.124172185430464 | 0.995428641718575 | 0.995428641718575 | 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| 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 | ||||||||||||||||||
| c5ba6bd3-553f-4078-ac70-3936f4c4dd42 | 2026-08-26 10:56 | 2026-08-26 10:56 | 2026-08-26 10:56 | DPRO | DPRO270115C00007500 | call | 7.5000 | 2027-01-15 | 0.2600 | 0.2500 | 0.3000 | 4.2500 | 32080.00 | 0.00 | 32080.00 | 1250 | 10 | 1259 | 7388 | 0.17041147807255 | 0.896025719921881 | 0.896025719921881 | 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-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-02T13:42:51.501101Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| 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-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |