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 |
|---|
| 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 |
|---|
| 1e3fe0d2-1fe9-4e2b-8de6-41fae0e0838d | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 8.9500 | 8.7500 | 9.0000 | 165.0500 | 33115.00 | 32220.00 | 895.00 | 37 | 10 | 220 | 3763 | 0.0584639914961467 | 0.757416754809594 | 0.757416754809594 | 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:04:15.950179Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 25e130f0-baab-4c49-ac98-469919a02fbc | 2026-09-22 12:27 | 2026-09-22 12:27 | 2026-09-22 12:27 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 10.4500 | 10.4500 | 10.7000 | 167.8200 | 15675.00 | 0.00 | 15675.00 | 15 | 9 | 216 | 3640 | 0.0593406593406593 | 0.77412117558449 | 0.77412117558449 | false | false | false | true | ||||||||||||||||
| 659d6a9b-785b-4fcb-a16d-3033d1541291 | 2026-09-21 15:37 | 2026-09-21 15:37 | 2026-09-21 15:37 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 11.5500 | 11.5500 | 11.6500 | 168.5000 | 45045.00 | 0.00 | 45045.00 | 39 | 6 | 1297 | 3568 | 0.363508968609865 | 0.80011328804682 | 0.801108648376239 | false | false | false | true | ||||||||||||||||
| ebb96eb3-f097-4b9a-966e-d33a7e434f1f | 2026-09-21 14:03 | 2026-09-21 14:03 | 2026-09-21 14:03 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 10.2000 | 10.1500 | 10.4000 | 164.0000 | 17340.00 | 0.00 | 16320.00 | 17 | 8 | 1097 | 3568 | 0.307455156950673 | 0.797650273562062 | 0.797650273562062 | true | false | false | true | ||||||||||||||||
| f39093dd-236e-4071-8ea2-121a6d926e2c | 2026-09-21 12:46 | 2026-09-21 12:45 | 2026-09-21 12:45 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 10.9000 | 10.8500 | 10.9000 | 166.6000 | 18530.00 | 18530.00 | 0.00 | 17 | 5 | 999 | 3568 | 0.279988789237668 | 0.802366764891206 | 0.802366764891206 | false | false | false | true | ||||||||||||||||
| 2b759ad0-1d45-4d03-9ff9-6a91b97d8338 | 2026-09-18 12:07 | 2026-09-18 12:07 | 2026-09-18 12:07 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 5.8500 | 5.8000 | 5.8500 | 149.0000 | 22815.00 | 22815.00 | 0.00 | 39 | 17 | 1505 | 3010 | 0.5 | 0.782534092869979 | 0.782534092869979 | false | false | false | true | ||||||||||||||||
| e7980377-2b2d-427b-91db-7a11dc9cd4b2 | 2026-09-18 10:31 | 2026-09-18 10:31 | 2026-09-18 10:31 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 4.9300 | 4.9000 | 5.0500 | 145.5700 | 98582.00 | 0.00 | 98582.00 | 200 | 5 | 965 | 3010 | 0.320598006644518 | 0.781373657582544 | 0.781373657582544 | false | false | false | true | ||||||||||||||||
| bfc7d880-6620-460f-b267-ad76b3b4b5e1 | 2026-09-16 11:33 | 2026-09-16 11:32 | 2026-09-16 11:32 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 2.2600 | 2.2500 | 2.3800 | 125.8300 | 31871.00 | 453.00 | 31418.00 | 141 | 33 | 203 | 2884 | 0.0703883495145631 | 0.809730714677456 | 0.809730714677456 | false | false | false | true | ||||||||||||||||
| b5893e95-5d81-4b11-a4c8-fcfb55439f9b | 2026-09-10 15:48 | 2026-09-10 15:48 | 2026-09-10 15:48 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 3.6000 | 3.6000 | 3.7500 | 129.1000 | 102240.00 | 0.00 | 102240.00 | 284 | 7 | 490 | 2607 | 0.187955504411201 | 0.842643104923924 | 0.842643104923924 | false | false | false | true | ||||||||||||||||
| f89b04d7-5765-45de-9a2f-79ae889f6539 | 2026-09-09 13:54 | 2026-09-09 13:54 | 2026-09-09 13:54 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 4.8000 | 4.8000 | 5.0000 | 134.9400 | 84000.00 | 0.00 | 84000.00 | 175 | 40 | 228 | 2327 | 0.0979802320584443 | 0.845138847235575 | 0.845138847235575 | false | false | false | true | ||||||||||||||||
| e1ba1297-b9c2-49fc-b938-3ae6f7319c22 | 2026-09-03 15:23 | 2026-09-03 15:23 | 2026-09-03 15:23 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 7.1500 | 6.9500 | 7.3000 | 143.2400 | 97955.00 | 67925.00 | 30030.00 | 137 | 7 | 620 | 2165 | 0.286374133949192 | 0.834994940298242 | 0.834994940298242 | false | false | false | true | ||||||||||||||||
| 28820914-910a-47d6-b150-90bdcd9654a1 | 2026-09-01 11:55 | 2026-09-01 11:55 | 2026-09-01 11:55 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 3.7000 | 3.6000 | 3.7500 | 128.1600 | 37000.00 | 32190.00 | 4810.00 | 100 | 8 | 193 | 1936 | 0.0996900826446281 | 0.810384814906486 | 0.810384814906486 | false | false | false | true | ||||||||||||||||
| 1b517bfe-834c-45c6-85b0-05a3ab5e2999 | 2026-09-01 11:26 | 2026-09-01 11:26 | 2026-09-01 11:26 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 3.6000 | 3.6000 | 3.7500 | 127.4900 | 14040.00 | 0.00 | 14040.00 | 39 | 6 | 91 | 1936 | 0.047004132231405 | 0.811156913182059 | 0.811156913182059 | false | false | false | true | ||||||||||||||||
| 7e283cbf-201d-4925-b001-633d507a18ef | 2026-08-25 12:59 | 2026-08-25 12:59 | 2026-08-25 12:59 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 4.7500 | 4.7500 | 5.1000 | 127.2000 | 55575.00 | 0.00 | 55575.00 | 117 | 11 | 451 | 1822 | 0.247530186608123 | 0.850298811405514 | 0.850298811405514 | false | false | false | true | ||||||||||||||||
| 11be1b94-7a89-41bc-b2f0-63434333db82 | 2026-08-25 12:55 | 2026-08-25 12:55 | 2026-08-25 12:55 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 5.2000 | 4.7500 | 5.2000 | 127.6100 | 18200.00 | 18200.00 | 0.00 | 35 | 5 | 333 | 1822 | 0.182766190998902 | 0.871414304490735 | 0.871414304490735 | false | false | false | true | ||||||||||||||||
| 720a2b2f-8b1e-470d-9b4a-1f70e65b6e8d | 2026-08-25 10:33 | 2026-08-25 10:33 | 2026-08-25 10:33 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 5.0000 | 4.5500 | 5.0500 | 126.8200 | 16995.00 | 15000.00 | 1995.00 | 34 | 15 | 51 | 1822 | 0.0279912184412733 | 0.869159347965627 | 0.869159347965627 | true | false | false | true | ||||||||||||||||
| 57852c20-73e1-4ba4-b7f9-b3aee79bfccb | 2026-08-19 11:18 | 2026-08-19 11:18 | 2026-08-19 11:18 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 2.1500 | 2.1200 | 2.2600 | 102.9699 | 18705.00 | 5805.00 | 12900.00 | 87 | 5 | 944 | 839 | 1.12514898688915 | 0.901093169710841 | 0.901093169710841 | false | false | false | true | ||||||||||||||||
| 6d071845-db3e-454a-abe5-9c49a206ddfb | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | MSTR | MSTR261120C00200000 | call | 200.0000 | 2026-11-20 | 2.1000 | 2.1000 | 2.3000 | 103.0100 | 26880.00 | 0.00 | 26880.00 | 128 | 5 | 744 | 839 | 0.886769964243147 | 0.895595474142574 | 0.895595474142574 | false | false | false | true |
| 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-22T16:35:05.886735Z"} |
| 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-21T19:39:27.785314Z"} |
| 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-21T18:05:09.858972Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} |
| 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 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 46003398516.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-11T13:30:31.573730Z"} |
| 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-09T18:27:25.894507Z"} |
| 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-01T16:07:53.122506Z"} |
| 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:45:30.323966Z"} |
| 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-25T16:59:46.608693Z"} |
| 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-25T16:59:46.608693Z"} |
| 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-25T14:42:01.576369Z"} |
| 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-19T15:33:41.628321Z"} |
| 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-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |