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_alerts425,429 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 |
|---|
| 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 |
|---|
| 8ba5d19c-dd2e-4940-ae07-bba6e5382b80 | 2026-09-18 10:47 | 2026-09-18 10:47 | 2026-09-18 10:47 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.0000 | 2.9400 | 3.0000 | 147.0700 | 10200.00 | 10200.00 | 0.00 | 34 | 8 | 24280 | 28876 | 0.840836680980745 | 1.24799731470421 | 1.24799731470421 | true | false | false | true | 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-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 6498b104-adb5-4d66-af4e-7c1e53e48b7e | 2026-09-18 10:50 | 2026-09-18 10:50 | 2026-09-18 10:50 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.0000 | 3.0000 | 3.1000 | 147.1750 | 16500.00 | 0.00 | 16500.00 | 55 | 5 | 24462 | 28876 | 0.847139493004571 | 1.1969916651914 | 1.1969916651914 | true | false | false | true | ||||||||||||||||
| c8275f38-979b-4c16-9b9f-765bc586a020 | 2026-09-18 11:00 | 2026-09-18 11:00 | 2026-09-18 11:00 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.6200 | 3.6000 | 3.7500 | 148.2200 | 18806.00 | 0.00 | 18806.00 | 52 | 5 | 24810 | 28876 | 0.859191023687491 | 1.040712999246 | 1.06171339078988 | false | false | false | true | ||||||||||||||||
| 89431863-1a39-40cc-b586-78553adf392c | 2026-09-18 11:04 | 2026-09-18 11:04 | 2026-09-18 11:04 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 2.8800 | 2.8300 | 2.8800 | 147.2150 | 72000.00 | 72000.00 | 0.00 | 250 | 6 | 25457 | 28876 | 0.88159717412384 | 1.09990225879679 | 1.09990225879679 | false | false | false | true | ||||||||||||||||
| d9ca72f6-71f6-4459-860a-4bab5dd8b4ad | 2026-09-18 11:16 | 2026-09-18 11:16 | 2026-09-18 11:16 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.6000 | 3.5500 | 3.7500 | 148.2700 | 125280.00 | 0.00 | 125280.00 | 348 | 5 | 26319 | 28876 | 0.911448954148774 | 1.0252653932063 | 1.0252653932063 | false | false | false | true | ||||||||||||||||
| 4402e730-4c5d-4563-8a7e-d121bbdf9630 | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.0500 | 148.7000 | 10000.00 | 10000.00 | 0.00 | 25 | 9 | 26713 | 28876 | 0.925093503255298 | 1.086934870751 | 1.086934870751 | false | false | false | true | ||||||||||||||||
| ec4cb646-fd49-409d-a9f0-1ba225e8ed51 | 2026-09-18 11:36 | 2026-09-18 11:35 | 2026-09-18 11:35 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.2000 | 3.2000 | 3.5500 | 148.0000 | 109144.00 | 0.00 | 109144.00 | 341 | 7 | 27365 | 28876 | 0.947672807868126 | 0.871843912530647 | 0.844910613990154 | false | false | false | true | ||||||||||||||||
| 62b1e2c1-02ff-4130-98c9-31eaf6d3f059 | 2026-09-18 11:53 | 2026-09-18 11:53 | 2026-09-18 11:53 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.0000 | 4.0000 | 4.1500 | 148.7500 | 22400.00 | 0.00 | 22400.00 | 56 | 7 | 27867 | 28876 | 0.965057487186591 | 1.09173335012828 | 1.09173335012828 | true | false | false | true | ||||||||||||||||
| a1ed7f46-07ed-4b21-a4cb-f7d97868d4fa | 2026-09-18 12:03 | 2026-09-18 12:03 | 2026-09-18 12:03 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.3000 | 4.3000 | 4.5000 | 149.0000 | 10320.00 | 0.00 | 10320.00 | 24 | 6 | 28522 | 28876 | 0.987740684305305 | 1.13011615735921 | 1.17248646472077 | true | false | false | true | ||||||||||||||||
| 69cee626-01d9-47c8-9ca7-47a89edd43f6 | 2026-09-18 12:04 | 2026-09-18 12:03 | 2026-09-18 12:03 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 3.9000 | 3.9000 | 4.3000 | 148.0000 | 102570.00 | 0.00 | 102570.00 | 263 | 6 | 28877 | 28876 | 1.0000346308353 | 0.747463803675828 | 0.747463803675828 | false | false | false | true | ||||||||||||||||
| 45c955a6-a58c-4ab2-a5fc-87a9a23c5927 | 2026-09-18 12:06 | 2026-09-18 12:05 | 2026-09-18 12:05 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.5000 | 4.2000 | 4.5000 | 149.0000 | 28800.00 | 28800.00 | 0.00 | 64 | 17 | 28953 | 28876 | 1.00266657431777 | 1.16335270677322 | 1.16335270677322 | false | false | false | true | ||||||||||||||||
| 0fb35ce0-1f4f-462f-aec9-d758b0d1185b | 2026-09-18 12:19 | 2026-09-18 12:19 | 2026-09-18 12:19 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 5.0000 | 4.7500 | 5.0500 | 149.0000 | 19510.00 | 19510.00 | 0.00 | 39 | 10 | 29433 | 28876 | 1.01928937525973 | 1.18028411930394 | 1.20064219078818 | false | false | false | true | ||||||||||||||||
| 1ff043e9-f342-480d-b430-a398bf142769 | 2026-09-18 12:31 | 2026-09-18 12:31 | 2026-09-18 12:31 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 5.0000 | 5.0000 | 5.1000 | 149.8900 | 55000.00 | 0.00 | 55000.00 | 110 | 6 | 29836 | 28876 | 1.03324560188392 | 1.14150644617361 | 1.14150644617361 | true | false | false | true | ||||||||||||||||
| 7990ac04-3351-4277-8e4f-7926fb0ffaeb | 2026-09-18 12:48 | 2026-09-18 12:48 | 2026-09-18 12:48 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 5.1000 | 5.1000 | 5.4500 | 150.0100 | 74970.00 | 0.00 | 74970.00 | 147 | 5 | 30314 | 28876 | 1.04979914115528 | 1.15784832568154 | 1.15784832568154 | true | false | false | true | ||||||||||||||||
| 520133a6-258e-478d-aa29-e2165a9c4223 | 2026-09-18 12:50 | 2026-09-18 12:50 | 2026-09-18 12:50 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 4.9000 | 4.9000 | 5.4500 | 149.7600 | 66640.00 | 0.00 | 66640.00 | 136 | 9 | 30450 | 28876 | 1.05450893475551 | 1.07254912732284 | 1.24737919921053 | true | false | false | true | ||||||||||||||||
| f02c4669-b5c8-49bc-9d0b-f6073b253979 | 2026-09-18 13:18 | 2026-09-18 13:18 | 2026-09-18 13:18 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 5.2500 | 5.2500 | 5.5500 | 150.2100 | 57225.00 | 0.00 | 57225.00 | 109 | 8 | 31085 | 28876 | 1.07649951516831 | 1.10285048194373 | 1.10285048194373 | true | false | false | true | ||||||||||||||||
| abc2f01b-2b48-46c8-aa7b-aa8892a70968 | 2026-09-18 13:54 | 2026-09-18 13:53 | 2026-09-18 13:53 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 6.3000 | 6.1000 | 6.3000 | 151.1000 | 23938.00 | 23938.00 | 0.00 | 38 | 6 | 31730 | 28876 | 1.09883640393406 | 1.95482562527708 | 2.0087483842609 | false | false | false | true | ||||||||||||||||
| 66fc49df-793d-4760-bae2-34bcb0b9692a | 2026-09-18 13:54 | 2026-09-18 13:54 | 2026-09-18 13:54 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 6.3000 | 5.9000 | 6.3000 | 151.1300 | 96355.00 | 96355.00 | 0.00 | 153 | 24 | 31883 | 28876 | 1.10413492173431 | 1.93488764979714 | 1.93488764979714 | false | false | false | true | ||||||||||||||||
| 2a30bef5-43e3-4b8c-8cfc-545a85876cdb | 2026-09-18 13:54 | 2026-09-18 13:54 | 2026-09-18 13:54 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 6.3500 | 5.9000 | 6.4000 | 151.2400 | 89535.00 | 10160.00 | 79375.00 | 141 | 16 | 32024 | 28876 | 1.10901786951101 | 1.73522596960735 | 1.76988960358035 | true | false | false | true | ||||||||||||||||
| d8cb4d18-ec50-4c69-9aa7-c7244c205e0a | 2026-09-18 14:29 | 2026-09-18 14:28 | 2026-09-18 14:28 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.0100 | 6.6000 | 7.0500 | 151.8500 | 17520.00 | 14700.00 | 0.00 | 25 | 8 | 32712 | 28876 | 1.13284388419449 | 2.57081884136738 | 2.39677703406004 | false | false | false | true | ||||||||||||||||
| c5622aa3-615b-4ff4-810d-344fed972c57 | 2026-09-18 14:38 | 2026-09-18 14:38 | 2026-09-18 14:38 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 6.9000 | 6.9000 | 7.1500 | 151.9400 | 35880.00 | 0.00 | 35880.00 | 52 | 7 | 32948 | 28876 | 1.14101676132428 | 2.7830878897894 | 2.7830878897894 | true | false | false | true | ||||||||||||||||
| af49456b-d291-4185-8107-4cc97f487de5 | 2026-09-18 15:33 | 2026-09-18 15:33 | 2026-09-18 15:33 | MSTR | MSTR260918C00145000 | call | 145.0000 | 2026-09-18 | 7.5700 | 7.4500 | 7.8500 | 152.6000 | 227132.00 | 0.00 | 227132.00 | 300 | 9 | 51960 | 28876 | 1.79941820196703 | 5.02288385979638 | 3.02700334968706 | false | false | false | true |
| 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-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 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-18T15:20:59.279522Z"} |
| 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-18T15:20:59.279522Z"} |
| 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-18T15:40:17.489597Z"} |
| 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-18T15:40:17.489597Z"} |
| 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-18T16:02:16.049420Z"} |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-18T16:45:45.480252Z"} |
| 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:09:50.881001Z"} |
| 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:09:50.881001Z"} |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:59:53.998874Z"} |
| 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-18T17:59:53.998874Z"} |
| 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:59:53.998874Z"} |
| 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-18T18:43:10.830314Z"} |
| 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-18T18:43:10.830314Z"} |
| 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:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |