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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 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 |
|---|
| f3f216e3-d9aa-4b34-b637-1eedc4bef151 | 2026-09-10 14:01 | 2026-09-10 14:01 | 2026-09-10 14:01 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 1.5500 | 1.5500 | 1.6300 | 130.0400 | 13950.00 | 0.00 | 13950.00 | 90 | 5 | 1297 | 4005 | 0.323845193508115 | 0.791661318316964 | 0.791661318316964 | true | false | false | true | false | 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-10T18:09:00.187388Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a7e75f30-ec29-47ff-9a27-3b5b5b06dc70 | 2026-09-09 10:08 | 2026-09-09 10:08 | 2026-09-09 10:08 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.8000 | 3.8000 | 4.0000 | 136.4400 | 45646.00 | 0.00 | 45646.00 | 120 | 7 | 660 | 3626 | 0.182018753447325 | 0.825410127803677 | 0.830818973234884 | false | false | false | true | false | |||||||||||||||
| 882fe65b-3423-43ad-8dfa-8e5edcea74e7 | 2026-09-09 10:00 | 2026-09-09 10:00 | 2026-09-09 10:00 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.0500 | 4.0500 | 4.1000 | 136.9050 | 10935.00 | 0.00 | 10935.00 | 27 | 8 | 490 | 3626 | 0.135135135135135 | 0.834123016349047 | 0.834123016349047 | false | false | false | true | false | |||||||||||||||
| 891f3b22-5c3b-4d6d-8c99-15588693f086 | 2026-09-03 15:14 | 2026-09-03 15:14 | 2026-09-03 15:14 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.3000 | 7.2500 | 7.5000 | 141.8000 | 25550.00 | 730.00 | 24090.00 | 35 | 8 | 1962 | 2903 | 0.675852566310713 | 0.752094148680168 | 0.752094148680168 | true | false | false | true | ||||||||||||||||
| 105eeff4-11c4-4d7a-8552-6fe9c2aee0fe | 2026-09-03 15:05 | 2026-09-03 15:05 | 2026-09-03 15:05 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.7000 | 7.6500 | 7.7000 | 142.3750 | 31570.00 | 31570.00 | 0.00 | 41 | 10 | 1804 | 2903 | 0.621426110919738 | 0.762799334853311 | 0.762799334853311 | true | false | false | true | false | |||||||||||||||
| 8469fabb-18c3-47b8-9061-b1905b7ccb7d | 2026-09-03 15:01 | 2026-09-03 15:01 | 2026-09-03 15:01 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.4000 | 7.1500 | 7.4000 | 142.0500 | 11100.00 | 11100.00 | 0.00 | 15 | 6 | 1709 | 2903 | 0.588701343437823 | 0.750386014979058 | 0.750386014979058 | true | false | false | true | false | |||||||||||||||
| adff24e2-3d36-44e1-8922-82e6e6f6e681 | 2026-09-03 11:23 | 2026-09-03 11:23 | 2026-09-03 11:23 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 6.2500 | 6.2000 | 6.3000 | 138.9900 | 29375.00 | 16875.00 | 12500.00 | 47 | 23 | 594 | 2903 | 0.204615914571133 | 0.771551281153237 | 0.771551281153237 | false | false | false | true | ||||||||||||||||
| c317f531-7640-4f83-bc29-9f2524991943 | 2026-09-01 10:48 | 2026-09-01 10:48 | 2026-09-01 10:48 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.0500 | 3.0500 | 3.2000 | 129.5399 | 45750.00 | 0.00 | 45750.00 | 150 | 8 | 330 | 2946 | 0.112016293279022 | 0.727278068086437 | 0.729599095550818 | false | false | false | true | false | |||||||||||||||
| 41480840-77ac-4acd-8ac6-2e7ca26f8ca8 | 2026-08-31 10:41 | 2026-08-31 10:41 | 2026-08-31 10:41 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 2.8900 | 2.7600 | 2.9200 | 128.1900 | 25186.00 | 22022.00 | 3164.00 | 87 | 6 | 343 | 2965 | 0.115682967959528 | 0.73016288368968 | 0.730144282135649 | true | false | false | true | false | |||||||||||||||
| 4361b1ab-bee5-4e7e-9d8f-eccd85c26c09 | 2026-08-27 15:33 | 2026-08-27 15:33 | 2026-08-27 15:33 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.0000 | 6.9500 | 7.2000 | 136.0000 | 18900.00 | 700.00 | 17500.00 | 27 | 17 | 1553 | 2883 | 0.538674991328477 | 0.751148457774195 | 0.754958693364863 | true | false | false | true | ||||||||||||||||
| e56cedf3-1e01-450a-9a8e-523726161bd4 | 2026-08-27 11:50 | 2026-08-27 11:50 | 2026-08-27 11:50 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 8.0000 | 7.7500 | 8.0500 | 138.5750 | 70372.00 | 47200.00 | 23172.00 | 88 | 7 | 747 | 2883 | 0.259105098855359 | 0.781547114299687 | 0.777308166670761 | false | false | false | true | ||||||||||||||||
| a9fcd761-a559-454b-90f7-47ae2538fbd4 | 2026-08-27 11:33 | 2026-08-27 11:33 | 2026-08-27 11:33 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.7000 | 7.7000 | 8.0000 | 138.0000 | 43890.00 | 0.00 | 43890.00 | 57 | 7 | 591 | 2883 | 0.204994797086368 | 0.774707693997379 | 0.774707693997379 | false | false | false | true | false | |||||||||||||||
| fe8ce342-4848-458c-9b75-753a97671b34 | 2026-08-27 11:31 | 2026-08-27 11:31 | 2026-08-27 11:31 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.6500 | 7.6000 | 8.0000 | 137.6650 | 13005.00 | 765.00 | 11475.00 | 17 | 11 | 508 | 2883 | 0.176205341657995 | 0.781126966307489 | 0.781945161702304 | true | false | false | true | ||||||||||||||||
| 05358b4d-91ee-4ae8-9249-7397c2ce12be | 2026-08-25 14:21 | 2026-08-25 14:21 | 2026-08-25 14:21 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.3600 | 4.3500 | 4.6000 | 127.0000 | 43163.00 | 0.00 | 43163.00 | 99 | 5 | 1151 | 2929 | 0.392966882895186 | 0.777395230722772 | 0.777395230722772 | false | false | false | true | ||||||||||||||||
| 0cd66156-050a-48f5-9486-da6c3bcf80ec | 2026-08-25 14:20 | 2026-08-25 14:20 | 2026-08-25 14:20 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.4000 | 4.4000 | 4.6000 | 127.0000 | 43560.00 | 0.00 | 43560.00 | 99 | 9 | 1052 | 2929 | 0.359166951177876 | 0.781085789987894 | 0.781085789987894 | false | false | false | true | ||||||||||||||||
| c3d390c1-5dda-4897-806d-dd1c02b0ea9a | 2026-08-25 11:51 | 2026-08-25 11:51 | 2026-08-25 11:51 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.4700 | 4.2000 | 4.5000 | 126.9000 | 44280.00 | 44280.00 | 0.00 | 99 | 7 | 562 | 2929 | 0.191874359849778 | 0.809455861313387 | 0.800588121649278 | false | false | false | true | false | |||||||||||||||
| c24115d8-432b-40d8-92f3-2f0f77347190 | 2026-08-25 11:50 | 2026-08-25 11:50 | 2026-08-25 11:50 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.4400 | 4.2000 | 4.5000 | 126.8600 | 43945.00 | 43945.00 | 0.00 | 99 | 6 | 463 | 2929 | 0.158074428132468 | 0.810515002819078 | 0.800752392990573 | false | false | false | true | false | |||||||||||||||
| 29aad960-7ef9-4203-aac4-929fd14c0f21 | 2026-08-24 10:07 | 2026-08-24 10:06 | 2026-08-24 10:06 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.1000 | 3.9000 | 4.1500 | 123.5000 | 407950.00 | 407950.00 | 0.00 | 995 | 6 | 2301 | 3734 | 0.616229244777718 | 0.844617153472265 | 0.84410920269786 | false | false | false | true | ||||||||||||||||
| 4d318749-aade-4fdd-9bd8-c0c0e818ef1f | 2026-08-24 10:05 | 2026-08-24 10:05 | 2026-08-24 10:05 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.0000 | 3.8500 | 4.0000 | 123.0401 | 13200.00 | 13200.00 | 0.00 | 33 | 6 | 495 | 3734 | 0.132565613283342 | 0.846391458552773 | 0.846391458552773 | false | false | false | true | false | |||||||||||||||
| 2a132908-9bc8-4bf1-af4f-b1d243028bc8 | 2026-08-24 10:05 | 2026-08-24 10:05 | 2026-08-24 10:05 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.0000 | 3.8500 | 4.1500 | 123.0900 | 322000.00 | 92800.00 | 229200.00 | 805 | 9 | 1301 | 3734 | 0.34841992501339 | 0.845130758245226 | 0.845130758245226 | false | false | false | true | ||||||||||||||||
| 7f62815b-a136-462d-baa2-6fcffee5d91e | 2026-08-21 13:25 | 2026-08-21 13:25 | 2026-08-21 13:25 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.8500 | 3.7500 | 3.9000 | 119.6100 | 220605.00 | 89320.00 | 130900.00 | 573 | 22 | 2321 | 2815 | 0.824511545293073 | 0.868390002530818 | 0.866960761519725 | false | false | false | true | ||||||||||||||||
| 058278e7-f1ea-41eb-b717-0e5b62ec3e83 | 2026-08-21 13:25 | 2026-08-21 13:25 | 2026-08-21 13:25 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.8500 | 3.7500 | 3.8500 | 119.5500 | 176696.00 | 176696.00 | 0.00 | 459 | 50 | 1748 | 2815 | 0.620959147424512 | 0.868390002530818 | 0.868390002530818 | false | false | false | true |
| 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-09T14:11:22.686371Z"} |
| 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-09T14:11:22.686371Z"} |
| 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-03T19:29:59.445996Z"} |
| 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-03T19:09:41.417490Z"} |
| 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-03T19:09:41.417490Z"} |
| 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:27:44.291947Z"} |
| 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-01T14:59:17.018627Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-31T14:41:39.850499Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 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-27T16:07:33.804891Z"} |
| 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-27T15:44:11.413260Z"} |
| 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-27T15:44:11.413260Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} |
| 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-24T14:08:32.927735Z"} |
| 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-24T14:08:32.927735Z"} |
| 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-24T14:08:32.927735Z"} |
| 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-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |