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 |
|---|
| 12b80961-5913-439b-bbb2-9719a19b05cc | 2026-09-11 10:25 | 2026-09-11 10:25 | 2026-09-11 10:25 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 3.7200 | 3.6000 | 3.8500 | 135.8100 | 37185.00 | 13055.00 | 24130.00 | 100 | 6 | 175 | 1880 | 0.0930851063829787 | 0.791268555057287 | 0.791268555057287 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b2af3094-9382-47e9-97d3-80e79cbfdaa6 | 2026-09-21 09:31 | 2026-09-21 09:31 | 2026-09-21 09:31 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.0900 | 11.5500 | 12.1000 | 165.9200 | 71355.00 | 9645.00 | 0.00 | 59 | 57 | 120 | 2275 | 0.0527472527472527 | 0.788513902829248 | 0.791400178750415 | false | false | false | |||||||||||||||||
| 4141542f-3865-42e2-87ea-ce5142620d76 | 2026-09-21 09:31 | 2026-09-21 09:31 | 2026-09-21 09:31 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.0200 | 11.4000 | 12.0500 | 166.0050 | 31260.00 | 20415.00 | 0.00 | 26 | 26 | 61 | 2275 | 0.0268131868131868 | 0.787355878738535 | 0.786062056781315 | false | false | false | |||||||||||||||||
| d7cde822-9c6e-4e63-aad2-7f3a777acd99 | 2026-09-21 09:31 | 2026-09-21 09:31 | 2026-09-21 09:31 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.2400 | 12.0500 | 12.6000 | 166.4650 | 26935.00 | 3665.00 | 1220.00 | 22 | 22 | 171 | 2275 | 0.0751648351648352 | 0.781382573522097 | 0.784259646930032 | false | false | false | |||||||||||||||||
| acf323b7-9466-49bc-bb39-08c92be464c8 | 2026-09-21 09:31 | 2026-09-21 09:31 | 2026-09-21 09:31 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.1600 | 11.8000 | 12.2000 | 166.6600 | 35260.00 | 29170.00 | 0.00 | 29 | 29 | 149 | 2275 | 0.0654945054945055 | 0.769960753675312 | 0.775708451345318 | false | false | false | |||||||||||||||||
| 507f71f7-e2b8-456f-9462-21e553e593b8 | 2026-09-21 09:33 | 2026-09-21 09:33 | 2026-09-21 09:33 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 13.1200 | 12.8500 | 13.4500 | 168.1000 | 19675.00 | 2640.00 | 17035.00 | 15 | 6 | 298 | 2275 | 0.130989010989011 | 0.786221142269877 | 0.78472490580503 | true | false | false | |||||||||||||||||
| 42c04c96-60c1-4f90-8e3f-bf4a5971ff99 | 2026-09-21 09:34 | 2026-09-21 09:34 | 2026-09-21 09:34 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.7700 | 12.6000 | 13.0500 | 167.6050 | 51085.00 | 12795.00 | 38290.00 | 40 | 9 | 344 | 2275 | 0.151208791208791 | 0.781130857561628 | 0.779471235484637 | true | false | false | |||||||||||||||||
| 5356167d-e5b8-4b1b-b0d8-05a0562fc899 | 2026-09-21 11:11 | 2026-09-21 11:11 | 2026-09-21 11:11 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 12.3700 | 12.2500 | 12.4500 | 167.0000 | 37106.00 | 37106.00 | 0.00 | 30 | 5 | 1203 | 2275 | 0.528791208791209 | 0.7671832422382 | 0.7671832422382 | false | false | false | |||||||||||||||||
| c5f46963-3358-434e-bfa9-6f15e1707e5f | 2026-09-24 12:19 | 2026-09-24 12:18 | 2026-09-24 12:18 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 7.7100 | 7.6500 | 7.9500 | 161.0000 | 64020.00 | 26285.00 | 37735.00 | 83 | 11 | 564 | 2438 | 0.231337161607875 | 0.691970999026458 | 0.695188911951086 | false | false | false | |||||||||||||||||
| 80bf3d88-d56b-4cd9-8e6f-e7190eae8095 | 2026-10-02 09:31 | 2026-10-02 09:31 | 2026-10-02 09:31 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 8.4700 | 8.0500 | 8.7500 | 168.7600 | 12710.00 | 12710.00 | 0.00 | 15 | 5 | 157 | 4136 | 0.0379593810444874 | 0.691124099293537 | 0.683331147751919 | false | false | false | |||||||||||||||||
| 69d903d4-4e6d-4ae9-b78a-92e8afe0a288 | 2026-10-02 13:29 | 2026-10-02 13:29 | 2026-10-02 13:29 | MSTR | MSTR261016C00170000 | call | 170.0000 | 2026-10-16 | 3.2100 | 3.2000 | 3.3000 | 157.0000 | 16055.00 | 0.00 | 12480.00 | 50 | 7 | 2665 | 4136 | 0.644342359767892 | 0.621821830212772 | 0.626596052776077 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:31:51.547866Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:31:51.547866Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:31:51.547866Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:31:51.547866Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:34:18.635188Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T13:34:18.635188Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:13:03.739619Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:19:14.224158Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T13:31:51.524532Z"} |
| 2026-10-02 |
| 2026-10-02 23:43 |
| 2026-10-02 23:43 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 58337326015.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T17:33:01.807894Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |