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_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 | 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 |
|---|
| 789013dd-46da-4492-b0e2-da15b8467c84 | 2026-09-18 10:20 | 2026-09-18 10:20 | 2026-09-18 10:20 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 0.8600 | 0.8600 | 0.8700 | 145.3100 | 32938.00 | 0.00 | 32938.00 | 383 | 7 | 3301 | 259 | 12.7451737451737 | 1.28384923029295 | 1.28384923029295 | 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:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8806f4aa-b43b-461a-b1e6-be15ed19a2bd | 2026-09-18 10:20 | 2026-09-18 10:20 | 2026-09-18 10:20 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 0.9400 | 0.8600 | 0.9400 | 145.5300 | 70500.00 | 70500.00 | 0.00 | 750 | 5 | 4056 | 259 | 15.6602316602317 | 1.30673731909056 | 1.29475003916151 | false | false | false | true | ||||||||||||||||
| 744830ce-9689-47e9-ba2c-3ca4c6b3c3cb | 2026-09-18 10:26 | 2026-09-18 10:26 | 2026-09-18 10:26 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.2000 | 1.1900 | 1.2600 | 146.3100 | 270726.00 | 726.00 | 268920.00 | 2256 | 51 | 7519 | 259 | 29.030888030888 | 1.30261607150917 | 1.30261607150917 | true | false | false | true | ||||||||||||||||
| 6f0ec225-6e26-4f46-bb0a-034d22574af6 | 2026-09-18 10:31 | 2026-09-18 10:31 | 2026-09-18 10:31 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 0.8500 | 0.8500 | 0.8700 | 145.4700 | 10795.00 | 0.00 | 10795.00 | 127 | 7 | 7964 | 259 | 30.7490347490347 | 1.26116665797049 | 1.26116665797049 | false | false | false | true | ||||||||||||||||
| 0c2be1b4-2fe9-483b-9256-1a006bbb5bfa | 2026-09-18 10:32 | 2026-09-18 10:31 | 2026-09-18 10:31 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 0.8500 | 0.8500 | 0.8700 | 145.4400 | 261205.00 | 0.00 | 261205.00 | 3073 | 5 | 11039 | 259 | 42.6216216216216 | 1.26128653474624 | 1.26128653474624 | false | false | false | true | ||||||||||||||||
| 178d49b6-70aa-4e30-b9aa-0f4c8b6327de | 2026-09-18 10:35 | 2026-09-18 10:35 | 2026-09-18 10:35 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.0000 | 0.9500 | 1.0000 | 146.1200 | 70100.00 | 70100.00 | 0.00 | 701 | 7 | 11978 | 259 | 46.2471042471042 | 1.26362666715504 | 1.22280240126585 | false | false | false | true | ||||||||||||||||
| 2d01c856-d4e5-4b3c-b883-0e2721ec6276 | 2026-09-18 10:35 | 2026-09-18 10:35 | 2026-09-18 10:35 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.0000 | 0.9600 | 1.0000 | 146.0500 | 221400.00 | 221400.00 | 0.00 | 2214 | 12 | 14296 | 259 | 55.1969111969112 | 1.2409183735603 | 1.2409183735603 | false | false | false | true | ||||||||||||||||
| b3df08e7-125c-48a4-8267-93f6461961fd | 2026-09-18 10:41 | 2026-09-18 10:41 | 2026-09-18 10:41 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.2300 | 1.1800 | 1.2300 | 146.7150 | 12300.00 | 12300.00 | 0.00 | 100 | 13 | 15640 | 259 | 60.3861003861004 | 1.24293822652541 | 1.24293822652541 | true | false | false | true | ||||||||||||||||
| 37cb9005-d9f6-4aa8-8d7e-0b412bd031ce | 2026-09-18 10:49 | 2026-09-18 10:49 | 2026-09-18 10:49 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.5400 | 1.4800 | 1.5400 | 147.4500 | 15400.00 | 15400.00 | 0.00 | 100 | 8 | 17025 | 259 | 65.7335907335907 | 1.25691099272817 | 1.25691099272817 | false | false | false | true | ||||||||||||||||
| a70a339f-0c83-4cb0-9cc7-6692c5a06b62 | 2026-09-18 10:51 | 2026-09-18 10:51 | 2026-09-18 10:51 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.2500 | 1.2500 | 1.3000 | 146.9800 | 12128.00 | 0.00 | 12128.00 | 97 | 6 | 17528 | 259 | 67.6756756756757 | 1.20769154403913 | 1.20047358319626 | true | false | false | true | ||||||||||||||||
| 3d1b711f-a15f-4a5b-9d1e-5c559aaff3d0 | 2026-09-18 11:38 | 2026-09-18 11:38 | 2026-09-18 11:38 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.3700 | 1.3000 | 1.3700 | 148.0000 | 21372.00 | 21372.00 | 0.00 | 156 | 28 | 22679 | 259 | 87.5637065637066 | 1.03957871584749 | 1.03957871584749 | false | false | false | true | ||||||||||||||||
| b4bf04c0-5739-4021-b432-88433a3736db | 2026-09-18 11:38 | 2026-09-18 11:38 | 2026-09-18 11:38 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.3400 | 1.3000 | 1.3500 | 147.9100 | 24522.00 | 4422.00 | 0.00 | 183 | 10 | 22862 | 259 | 88.2702702702703 | 1.05109657209957 | 1.05109657209957 | false | false | false | true | ||||||||||||||||
| 09856f29-bbc2-43f3-b8d0-69f2e8caa3d8 | 2026-09-18 11:51 | 2026-09-18 11:51 | 2026-09-18 11:51 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.6700 | 1.5500 | 1.6800 | 148.5800 | 12524.00 | 12524.00 | 0.00 | 75 | 6 | 23537 | 259 | 90.8764478764479 | 1.06061742743731 | 1.06365290793272 | false | false | false | true | ||||||||||||||||
| 70242145-3246-4cd4-b8e7-90ab974ecdc7 | 2026-09-18 11:52 | 2026-09-18 11:51 | 2026-09-18 11:51 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.8000 | 1.7200 | 1.7900 | 148.6800 | 17987.00 | 17987.00 | 0.00 | 100 | 5 | 23692 | 259 | 91.4749034749035 | 1.10653072598742 | 1.11445211064183 | false | false | false | true | ||||||||||||||||
| 23933ef0-20c7-4aa3-a37c-acc8c9b95a9a | 2026-09-18 11:53 | 2026-09-18 11:53 | 2026-09-18 11:53 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.8000 | 1.7200 | 1.8000 | 148.7200 | 12060.00 | 12060.00 | 0.00 | 67 | 7 | 23901 | 259 | 92.2818532818533 | 1.09940806710507 | 1.09940806710507 | true | false | false | true | ||||||||||||||||
| 9008dff6-b41c-47dd-b567-f4a39f7a15d7 | 2026-09-18 11:58 | 2026-09-18 11:58 | 2026-09-18 11:58 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 1.9000 | 1.9000 | 2.0000 | 149.0000 | 19619.00 | 0.00 | 19619.00 | 103 | 5 | 24160 | 259 | 93.2818532818533 | 1.030915507565 | 1.06237762782109 | false | false | false | true | ||||||||||||||||
| fc705f8f-0489-48e1-8711-3c7a2c330664 | 2026-09-18 13:48 | 2026-09-18 13:47 | 2026-09-18 13:47 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 3.2000 | 2.9700 | 3.2000 | 151.0673 | 12475.00 | 12475.00 | 0.00 | 39 | 5 | 26342 | 259 | 101.706563706564 | 1.15999534334998 | 1.05183548532507 | true | false | false | true | ||||||||||||||||
| 14c15860-9e5c-4455-88d1-f7a99de9defc | 2026-09-18 14:51 | 2026-09-18 14:51 | 2026-09-18 14:51 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.1500 | 151.9601 | 10400.00 | 0.00 | 10400.00 | 26 | 23 | 26594 | 259 | 102.679536679537 | 1.34009749130389 | 1.34026203157722 | false | false | false | true | ||||||||||||||||
| 18785080-91de-47b4-b018-505124e9c5cd | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | MSTR | MSTR260918C00148000 | call | 148.0000 | 2026-09-18 | 5.5000 | 5.5000 | 5.7000 | 153.4800 | 12650.00 | 0.00 | 12650.00 | 23 | 5 | 26909 | 259 | 103.895752895753 | 3.69495568192294 | 3.69495568192294 | 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-18T14:32:18.430939Z"} |
| 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:32:18.430939Z"} |
| 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:32:18.430939Z"} |
| 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:32:18.430939Z"} |
| 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 |
| 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 |
| 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 |
| 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 |
| 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: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: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-18T15:40:17.489597Z"} |
| 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-18T16:02:16.049420Z"} |
| 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-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 |
| — |
| 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 |
| 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-18T16:02:16.049420Z"} |
| 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 |
| 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:03:43.854590Z"} |
| 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:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |