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 | expirydate |
|---|
| 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 |
|---|
| 052bd4de-2a96-466c-9eba-05246274de07 | 2026-09-04 13:00 | 2026-09-04 13:00 | 2026-09-04 13:00 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5500 | 0.5000 | 0.5500 | 6.0650 | 16500.00 | 16500.00 | 0.00 | 300 | 10 | 17035 | 81554 | 0.208880005885671 | 1.22900573947977 | 1.22900573947977 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 161983158.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5a25a71f-2084-497a-88ba-bca4a27ea756 | 2026-09-04 15:25 | 2026-09-04 15:25 | 2026-09-04 15:25 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5500 | 0.5000 | 0.5500 | 6.0870 | 13750.00 | 13750.00 | 0.00 | 250 | 7 | 20026 | 81554 | 0.245555092331461 | 1.21822873482482 | 1.21822873482482 | false | false | false | true | ||||||||||||||||
| 92118d6d-d34a-4f21-81aa-fe596fe7267a | 2026-09-08 09:34 | 2026-09-08 09:33 | 2026-09-08 09:33 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5000 | 0.5000 | 0.5500 | 5.9500 | 38366.00 | 1272.00 | 37094.00 | 765 | 20 | 1438 | 95133 | 0.0151156801530489 | 1.28392537243435 | 1.28392537243435 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 5c6ee8cb-691f-495f-99a2-7e12b5bf84be | 2026-09-08 15:38 | 2026-09-08 15:38 | 2026-09-08 15:38 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4000 | 0.3500 | 0.4000 | 5.8600 | 10310.00 | 10310.00 | 0.00 | 258 | 17 | 7228 | 95133 | 0.0759778415481484 | 1.18634888958794 | 1.1716939984582 | false | false | false | true | ||||||||||||||||
| d821e50a-2f02-4ae9-892a-60b299b858a8 | 2026-09-08 15:38 | 2026-09-08 15:38 | 2026-09-08 15:38 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4000 | 0.3500 | 0.4500 | 5.8600 | 14000.00 | 13840.00 | 0.00 | 350 | 16 | 7578 | 95133 | 0.0796569013906846 | 1.18634888958794 | 1.18634888958794 | true | false | false | true | ||||||||||||||||
| 7cd47ace-18df-438f-9f0b-c3a6ab26343b | 2026-09-08 15:41 | 2026-09-08 15:41 | 2026-09-08 15:41 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4500 | 0.4000 | 0.4500 | 5.9200 | 21855.00 | 14925.00 | 0.00 | 486 | 28 | 8765 | 95133 | 0.0921341700566575 | 1.24381929118602 | 1.22898471595839 | true | false | false | true | ||||||||||||||||
| ac9a52d5-4a6a-4930-8235-0560a3035a30 | 2026-09-08 15:54 | 2026-09-08 15:54 | 2026-09-08 15:54 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5000 | 0.4500 | 0.5000 | 5.9950 | 12500.00 | 12500.00 | 0.00 | 250 | 6 | 10381 | 95133 | 0.109120914929625 | 1.26116140828916 | 1.26116140828916 | false | false | false | true | ||||||||||||||||
| cdad9db1-103d-46a7-a511-ac6129deae6f | 2026-09-08 15:56 | 2026-09-08 15:56 | 2026-09-08 15:56 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4500 | 0.4500 | 0.5000 | 6.0200 | 67817.00 | 1551.00 | 66266.00 | 1500 | 47 | 12187 | 95133 | 0.128104863717112 | 1.17249421367757 | 1.17983065353866 | false | false | false | true | ||||||||||||||||
| ddda5fcf-a600-40d3-9fa2-4e91f3d98fd1 | 2026-09-09 09:32 | 2026-09-09 09:32 | 2026-09-09 09:32 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5000 | 0.4500 | 0.5500 | 5.9900 | 12300.00 | 0.00 | 500.00 | 246 | 6 | 1622 | 99186 | 0.0163531143508156 | 1.28087831149142 | 1.28087831149142 | false | false | false | true | ||||||||||||||||
| c507a30c-508b-40c2-b9e7-e96e9927f70a | 2026-09-09 09:44 | 2026-09-09 09:43 | 2026-09-09 09:43 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5300 | 0.5000 | 0.5500 | 6.0600 | 17278.00 | 17278.00 | 0.00 | 326 | 5 | 2299 | 99186 | 0.0231786744096949 | 1.28615650704099 | 1.28615650704099 | false | false | false | true | ||||||||||||||||
| 7dee8cc5-fa9d-421f-9f9c-1203c289ba42 | 2026-09-09 10:18 | 2026-09-09 10:18 | 2026-09-09 10:18 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4500 | 0.4500 | 0.5000 | 5.9599 | 38159.00 | 1920.00 | 36239.00 | 842 | 39 | 3957 | 99186 | 0.0398947432097272 | 1.22577820822869 | 1.22577820822869 | false | false | false | true | ||||||||||||||||
| 72348439-cef4-4af6-8f23-3c2963f091bf | 2026-09-09 13:35 | 2026-09-09 13:35 | 2026-09-09 13:35 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.4500 | 0.4500 | 0.5000 | 5.9200 | 15049.00 | 0.00 | 15049.00 | 331 | 24 | 5779 | 99186 | 0.0582642711673018 | 1.24570597949481 | 1.24570597949481 | false | false | false | true | ||||||||||||||||
| 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 | ||||||||||||||||
| b18effd1-650e-4a0d-a95c-3536ac71fa2e | 2026-09-10 09:40 | 2026-09-10 09:40 | 2026-09-10 09:40 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.3100 | 0.3000 | 0.3500 | 5.6294 | 14291.00 | 0.00 | 14291.00 | 461 | 9 | 1994 | 102357 | 0.019480836679465 | 1.18874350613862 | 1.18874350613862 | false | false | false | true | ||||||||||||||||
| efa43fb0-fbef-4c06-9c0d-690e134a7b98 | 2026-09-28 10:28 | 2026-09-28 10:27 | 2026-09-28 10:27 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.1500 | 0.1000 | 0.2000 | 5.0000 | 13470.00 | 10845.00 | 0.00 | 898 | 15 | 1355 | 95871 | 0.0141335753251765 | 1.16402537631918 | 1.16402537631918 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 161983158.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 164184016.00 |
| 2026-11-11 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:31:22.759072Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |