uw_flow_alerts728,802 rows| 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 |
|---|
| cb7d9766-10d1-49c6-85d8-1d7ee0501fba | 2026-09-03 11:29 | 2026-09-03 11:29 | 2026-09-03 11:29 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6100 | 0.5500 | 0.6500 | 6.1598 | 11152.00 | 5492.00 | 4400.00 | 182 | 13 | 1687 | 8279 | 0.203768571083464 | 1.23048215455285 | 1.23048215455285 | false | false | false | true | false | 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-03T15:43:05.796155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 945780a9-aa81-45dd-9bb4-806c92290b27 | 2026-09-03 11:34 | 2026-09-03 11:34 | 2026-09-03 11:34 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6000 | 0.5500 | 0.6000 | 6.1200 | 31516.00 | 31180.00 | 336.00 | 526 | 9 | 10021 | 8279 | 1.21041188549342 | 1.23780657667297 | 1.20071559841902 | false | false | false | |||||||||||||||||
| 02581d27-0207-4532-abf3-6fb8cd42779b | 2026-09-03 11:39 | 2026-09-03 11:38 | 2026-09-03 11:38 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5500 | 0.5500 | 0.6000 | 6.0900 | 97268.00 | 8642.00 | 88626.00 | 1755 | 79 | 18902 | 8279 | 2.28312598139872 | 1.20279254194523 | 1.20279254194523 | false | false | false | |||||||||||||||||
| f11b7d9d-ccdf-4405-b43c-8e1fcd7a02ef | 2026-09-03 12:12 | 2026-09-03 12:12 | 2026-09-03 12:12 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.5400 | 0.5000 | 0.5500 | 6.0299 | 10250.00 | 10250.00 | 0.00 | 190 | 6 | 48621 | 8279 | 5.87281072593308 | 1.20657629648376 | 1.23192660969041 | false | false | false | |||||||||||||||||
| 75c9b499-a1bf-4178-8c27-973d230b8105 | 2026-09-03 13:28 | 2026-09-03 13:28 | 2026-09-03 13:28 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6000 | 0.6500 | 6.3150 | 20908.00 | 20908.00 | 0.00 | 322 | 11 | 78285 | 8279 | 9.45585215605749 | 1.20174350937628 | 1.21353485384689 | false | false | false | |||||||||||||||||
| d909b2c5-a551-4d4f-b110-bfeabde08e76 | 2026-09-03 15:11 | 2026-09-03 15:11 | 2026-09-03 15:11 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.7000 | 0.6500 | 0.7000 | 6.3900 | 10288.00 | 10288.00 | 0.00 | 147 | 6 | 98043 | 8279 | 11.842372267182 | 1.2226314832952 | 1.23420509076805 | false | false | false | |||||||||||||||||
| fff6dc16-6ec0-4104-9818-641e69511821 | 2026-09-03 15:57 | 2026-09-03 15:57 | 2026-09-03 15:57 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.7000 | 0.6500 | 0.7500 | 6.4050 | 246789.00 | 438.00 | 246001.00 | 3525 | 156 | 111280 | 8279 | 13.4412368643556 | 1.22913905206579 | 1.22660712710595 | false | false | false | |||||||||||||||||
| 9a04da07-b79a-4d9d-aced-52c7a60bea3b | 2026-09-04 09:30 | 2026-09-04 09:30 | 2026-09-04 09:30 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.7200 | 0.7000 | 0.7500 | 6.3500 | 56075.00 | 17775.00 | 38150.00 | 784 | 24 | 1182 | 81554 | 0.0144934644530005 | 1.26906169247197 | 1.32788445175064 | false | false | false | |||||||||||||||||
| 42d6cd54-d4f0-4ce4-923d-64328e6c6b96 | 2026-09-04 09:30 | 2026-09-04 09:30 | 2026-09-04 09:30 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.7500 | 0.7000 | 0.7500 | 6.2500 | 41968.00 | 38325.00 | 3643.00 | 563 | 42 | 2155 | 81554 | 0.0264242097260711 | 1.3326382669743 | 1.32064277980065 | false | false | false | |||||||||||||||||
| 08d5d89e-960a-4e77-84eb-705c59424804 | 2026-09-04 09:37 | 2026-09-04 09:37 | 2026-09-04 09:37 | DPRO | DPRO261016C00007500 | call | 7.5000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 6.3300 | 26134.00 | 0.00 | 26134.00 | 402 | 19 | 5970 | 81554 | 0.0732030311204846 | 1.22005154643585 | 1.24380710109885 | false | false | false | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 |
| false |
| 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-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |