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 | 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 |
|---|
| 67fde2d5-0432-4452-b08c-6d9788d67637 | 2026-09-18 12:22 | 2026-09-18 12:22 | 2026-09-18 12:22 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 3.2000 | 3.1000 | 3.2000 | 149.0000 | 68799.00 | 68799.00 | 0.00 | 215 | 32 | 4013 | 346 | 11.5982658959538 | 0.749700452193607 | 0.749700452193607 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 013d0bba-a8d7-4fc4-b7f9-ad9e4021c253 | 2026-09-18 13:21 | 2026-09-18 13:20 | 2026-09-18 13:20 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 3.2900 | 3.2000 | 3.3000 | 150.1900 | 102715.00 | 86790.00 | 0.00 | 312 | 21 | 7920 | 346 | 22.8901734104046 | 0.738963644613205 | 0.729273772446281 | true | false | false | |||||||||||||||||
| 3111ed12-baff-4098-ae41-cdd48be0b281 | 2026-09-18 14:25 | 2026-09-18 14:25 | 2026-09-18 14:25 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 3.6000 | 3.5000 | 3.6000 | 151.4656 | 27000.00 | 27000.00 | 0.00 | 75 | 6 | 12573 | 346 | 36.3381502890173 | 0.716203507276078 | 0.716203507276078 | true | false | false | |||||||||||||||||
| 18e0c453-489a-41ba-bd5a-f0fc291ad926 | 2026-09-18 15:06 | 2026-09-18 15:05 | 2026-09-18 15:05 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 3.8000 | 3.7000 | 3.8000 | 152.1477 | 42560.00 | 42560.00 | 0.00 | 112 | 14 | 17972 | 346 | 51.9421965317919 | 0.71068294158727 | 0.709123471366762 | true | false | false | |||||||||||||||||
| 79b3b594-54c8-4714-ad9d-814e6690b57f | 2026-09-18 15:33 | 2026-09-18 15:33 | 2026-09-18 15:33 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 4.1500 | 4.0000 | 4.1500 | 152.6500 | 16600.00 | 16600.00 | 0.00 | 40 | 5 | 18231 | 346 | 52.6907514450867 | 0.725049879856195 | 0.727987804693974 | false | false | false | |||||||||||||||||
| 41245173-6122-4dfa-aff3-c9fed8676e39 | 2026-09-18 15:52 | 2026-09-18 15:52 | 2026-09-18 15:52 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 4.5000 | 4.4000 | 4.5000 | 153.0000 | 10350.00 | 10350.00 | 0.00 | 23 | 5 | 22141 | 346 | 63.9913294797688 | 0.733879087705531 | 0.733879087705531 | false | false | false | |||||||||||||||||
| bef5e5e0-0eed-43e0-bdae-a355b544c417 | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 11.6000 | 11.4500 | 11.6500 | 166.3800 | 10440.00 | 10440.00 | 0.00 | 9 | 8 | 842 | 15367 | 0.0547927376846489 | 0.905744343092326 | 0.904452457521034 | false | false | false | |||||||||||||||||
| 2ea66066-89da-4486-818b-cea3daa13bd7 | 2026-09-23 14:33 | 2026-09-23 14:33 | 2026-09-23 14:33 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 6.6000 | 6.5500 | 6.7000 | 162.3800 | 20460.00 | 0.00 | 20460.00 | 31 | 5 | 841 | 14134 | 0.0595019102872506 | 0.767802777914276 | 0.767802777914276 | false | false | false | |||||||||||||||||
| 8d3abb98-0651-42ab-8563-db93e7e75945 | 2026-09-24 09:55 | 2026-09-24 09:54 | 2026-09-24 09:54 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 4.7000 | 4.5500 | 4.7500 | 160.3450 | 12220.00 | 12220.00 | 0.00 | 26 | 6 | 142 | 14378 | 0.00987619974961747 | 0.92169787002823 | 0.92169787002823 | true | false | false | |||||||||||||||||
| e9d36c09-0af2-46c7-a495-a3bdb8252b7b | 2026-09-24 10:57 | 2026-09-24 10:57 | 2026-09-24 10:57 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 3.7000 | 3.6000 | 3.7000 | 158.7400 | 20720.00 | 20720.00 | 0.00 | 56 | 8 | 1969 | 14378 | 0.136945333147865 | 0.91781733136843 | 0.91781733136843 | false | false | false | |||||||||||||||||
| 70bb5918-a8b3-47ae-a0e7-2f863a4a50b7 | 2026-09-24 13:08 | 2026-09-24 13:08 | 2026-09-24 13:08 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 5.5000 | 5.4500 | 5.6500 | 161.9780 | 27502.00 | 16500.00 | 11002.00 | 50 | 5 | 2744 | 14378 | 0.190847127555988 | 0.801284183078211 | 0.801284183078211 | false | false | false | |||||||||||||||||
| 46946e88-0fbe-405c-8fe0-c42a360fccb0 | 2026-09-25 13:12 | 2026-09-25 13:11 | 2026-09-25 13:11 | MSTR | MSTR260925C00157500 | call | 157.5000 | 2026-09-25 | 1.4000 | 1.3800 | 1.4400 | 158.5100 | 28000.00 | 4760.00 | 23240.00 | 200 | 11 | 7255 | 14068 | 0.515709411430196 | 0.703917038935851 | 0.70395208422839 | false | false | false |
| false |
| 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 |
| false |
| 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-18T18:43:10.830314Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| 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 |
| false |
| 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:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| 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-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-23T18:35:00.755474Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-24T13:56:38.298983Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T17:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 57826906314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |