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_alerts375,978 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 | expiry |
|---|
| 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 |
|---|
| 1c65b817-a51e-46d5-8b14-d240b603d6d8 | 2026-09-23 11:08 | 2026-09-23 11:08 | 2026-09-23 11:08 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 8.1000 | 7.9000 | 8.1500 | 165.3100 | 38070.00 | 37260.00 | 0.00 | 47 | 10 | 2556 | 2536 | 1.00788643533123 | 0.716307320986708 | 0.716307320986708 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 59135768262.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| e2866873-5792-4bcb-8bfa-e7d2628f4ea7 | 2026-09-23 10:04 | 2026-09-23 10:04 | 2026-09-23 10:04 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 9.0500 | 9.0500 | 9.2000 | 167.0000 | 16290.00 | 0.00 | 16290.00 | 18 | 5 | 2442 | 2536 | 0.962933753943218 | 0.716801158056265 | 0.716801158056265 | false | false | false | true | ||||||||||||||||
| b8dffe2b-8a15-497d-9024-c134e44a59b7 | 2026-09-23 10:00 | 2026-09-23 10:00 | 2026-09-23 10:00 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 9.0500 | 8.8500 | 9.1000 | 167.0000 | 13575.00 | 9955.00 | 1810.00 | 15 | 9 | 2423 | 2536 | 0.955441640378549 | 0.714659626675261 | 0.714659626675261 | false | false | false | true | ||||||||||||||||
| d05637e1-b836-41d2-87d5-d3482dfc88a3 | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 9.5000 | 9.5000 | 9.7000 | 168.0000 | 903450.00 | 0.00 | 903450.00 | 951 | 20 | 2197 | 2536 | 0.866324921135647 | 0.723003160984034 | 0.723003160984034 | true | false | false | true | ||||||||||||||||
| 1fade3c2-7269-412b-bf9b-96c660e3e4ac | 2026-09-22 11:10 | 2026-09-22 11:10 | 2026-09-22 11:10 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.1000 | 10.1000 | 10.2500 | 168.0000 | 23230.00 | 0.00 | 23230.00 | 23 | 6 | 847 | 2442 | 0.346846846846847 | 0.72486440525579 | 0.72486440525579 | true | false | false | true | ||||||||||||||||
| 7e06d300-5934-4127-9914-95a09f885d9b | 2026-09-22 10:55 | 2026-09-22 10:55 | 2026-09-22 10:55 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.0000 | 10.0000 | 10.1000 | 168.6501 | 45000.00 | 0.00 | 45000.00 | 45 | 6 | 663 | 2442 | 0.271498771498771 | 0.726350408482158 | 0.726350408482158 | true | false | false | true | ||||||||||||||||
| ec04cd93-3390-46c5-b739-b332767ea0c2 | 2026-09-22 10:53 | 2026-09-22 10:53 | 2026-09-22 10:53 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.0500 | 9.9000 | 10.1000 | 168.7490 | 44220.00 | 44220.00 | 0.00 | 44 | 10 | 494 | 2442 | 0.202293202293202 | 0.7265880613776 | 0.7265880613776 | false | false | false | true | ||||||||||||||||
| 6546315c-b57b-4ba7-8bdb-e1b8d4e83575 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 11.0000 | 11.0000 | 11.2000 | 170.0000 | 12100.00 | 0.00 | 12100.00 | 11 | 6 | 206 | 2442 | 0.0843570843570844 | 0.740540702265154 | 0.740540702265154 | false | false | false | true | ||||||||||||||||
| b6188749-e321-47ec-a7ca-d6f5b5990e6e | 2026-09-22 09:35 | 2026-09-22 09:34 | 2026-09-22 09:34 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.8000 | 10.5500 | 10.9000 | 169.5100 | 12965.00 | 11880.00 | 1085.00 | 12 | 5 | 71 | 2442 | 0.0290745290745291 | 0.749570214315689 | 0.749266813231277 | true | false | false | true | ||||||||||||||||
| 11c20070-18c1-4f94-9c57-196a3bb93293 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.4500 | 10.4000 | 10.7500 | 168.1800 | 27175.00 | 2095.00 | 25080.00 | 26 | 14 | 37 | 2442 | 0.0151515151515152 | 0.761897378078369 | 0.765282262283777 | true | false | false | true | ||||||||||||||||
| 90d52b00-ab4b-4071-8df7-179c721d357f | 2026-09-21 13:01 | 2026-09-21 13:01 | 2026-09-21 13:01 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 10.2000 | 10.2000 | 10.3500 | 166.7950 | 29580.00 | 0.00 | 29580.00 | 29 | 7 | 1792 | 1847 | 0.97022198159177 | 0.768814840340793 | 0.771424775059859 | false | false | false | true | ||||||||||||||||
| 181fe850-4d0c-477b-9c94-f34679c7359c | 2026-09-21 10:24 | 2026-09-21 10:24 | 2026-09-21 10:24 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 9.8500 | 9.7000 | 9.8500 | 165.0000 | 12805.00 | 12805.00 | 0.00 | 13 | 7 | 1467 | 1847 | 0.794260963724959 | 0.781072997897582 | 0.781072997897582 | false | false | false | true | ||||||||||||||||
| 408315c6-5e80-4aee-b811-ee8a4ade2b8e | 2026-09-18 15:40 | 2026-09-18 15:40 | 2026-09-18 15:40 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.3500 | 5.2000 | 5.3500 | 153.4700 | 30495.00 | 30495.00 | 0.00 | 57 | 7 | 1411 | 1562 | 0.903329065300896 | 0.736008534181641 | 0.736008534181641 | false | false | false | true | ||||||||||||||||
| 0ecfeeba-273c-4b76-b9f3-8e43747c0bcf | 2026-09-18 15:12 | 2026-09-18 15:12 | 2026-09-18 15:12 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.0000 | 4.9000 | 5.0500 | 152.7143 | 87500.00 | 75000.00 | 12500.00 | 175 | 12 | 1210 | 1562 | 0.774647887323944 | 0.727213051150723 | 0.727213051150723 | false | false | false | true | ||||||||||||||||
| f4082cc7-a530-41d0-8a08-3f64e8a47754 | 2026-09-18 13:09 | 2026-09-18 13:09 | 2026-09-18 13:09 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 4.4500 | 4.4500 | 4.6000 | 149.9474 | 11125.00 | 0.00 | 11125.00 | 25 | 7 | 509 | 1562 | 0.325864276568502 | 0.742330301720548 | 0.742330301720548 | true | false | false | true | ||||||||||||||||
| 35220d1a-54b8-4304-bba4-d1b42e1c0c65 | 2026-09-18 10:37 | 2026-09-18 10:36 | 2026-09-18 10:36 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 3.7000 | 3.6000 | 3.7000 | 146.5200 | 19240.00 | 19240.00 | 0.00 | 52 | 14 | 178 | 1562 | 0.113956466069142 | 0.751192169404279 | 0.749697228133975 | false | false | false | true | ||||||||||||||||
| aea2ba89-318a-4273-bbb3-3a7c43c18ba6 | 2026-09-15 14:33 | 2026-09-15 14:33 | 2026-09-15 14:33 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 2.0100 | 2.0100 | 2.0700 | 131.3400 | 12864.00 | 0.00 | 12864.00 | 64 | 5 | 267 | 1994 | 0.133901705115346 | 0.812334765877968 | 0.812334765877968 | false | false | false | true | ||||||||||||||||
| bd8799b2-8edd-4f3c-ad4d-6969b2383f2f | 2026-09-03 13:36 | 2026-09-03 13:36 | 2026-09-03 13:36 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.6300 | 5.6000 | 5.7000 | 141.7550 | 232565.00 | 144640.00 | 87925.00 | 413 | 43 | 1278 | 1667 | 0.766646670665867 | 0.802156259128972 | 0.802072287214114 | false | false | false | true | ||||||||||||||||
| d02e9377-5567-4533-82c0-ebe7bf999175 | 2026-09-03 12:27 | 2026-09-03 12:27 | 2026-09-03 12:27 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.1500 | 5.0500 | 5.2000 | 139.4000 | 48410.00 | 2575.00 | 45320.00 | 94 | 7 | 713 | 1667 | 0.427714457108578 | 0.810405836403597 | 0.80949566635384 | true | false | false | true | ||||||||||||||||
| bde2f300-1a9f-449c-b5b5-de756846cc01 | 2026-09-03 11:28 | 2026-09-03 11:27 | 2026-09-03 11:27 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.0000 | 5.0000 | 5.2000 | 138.5700 | 34000.00 | 0.00 | 34000.00 | 68 | 8 | 399 | 1667 | 0.239352129574085 | 0.81332033297147 | 0.81332033297147 | true | false | false | true | ||||||||||||||||
| e140986e-90a2-438d-a9f2-02a78f3cdccb | 2026-09-01 11:15 | 2026-09-01 11:15 | 2026-09-01 11:15 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 2.5300 | 2.5300 | 2.7000 | 127.2950 | 25300.00 | 0.00 | 25300.00 | 100 | 5 | 363 | 2435 | 0.149075975359343 | 0.779011175543166 | 0.779011175543166 | false | false | false | true | ||||||||||||||||
| 716a44ea-4b12-422f-a328-4f7bc9ad3f35 | 2026-08-27 13:00 | 2026-08-27 13:00 | 2026-08-27 13:00 | MSTR | MSTR261016C00175000 | call | 175.0000 | 2026-10-16 | 5.6500 | 5.6500 | 5.8500 | 137.8300 | 33335.00 | 0.00 | 33335.00 | 59 | 24 | 206 | 1415 | 0.145583038869258 | 0.803603585992908 | 0.803998030424831 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T14:05:57.943683Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T14:24:21.810098Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |