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 |
|---|
| 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 |
|---|
| 27e20c10-d28f-4614-849a-4464218832da | 2026-09-25 10:40 | 2026-09-25 10:40 | 2026-09-25 10:40 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 0.4400 | 0.4200 | 0.5100 | 158.3700 | 41800.00 | 0.00 | 41800.00 | 950 | 16 | 3339 | 6208 | 0.537854381443299 | 0.781763555599513 | 0.781763555599513 | false | false | false | true | 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-25T14:43:48.295772Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b03c1828-362a-48c1-a28e-1668a61a5d5b | 2026-09-21 12:36 | 2026-09-21 12:36 | 2026-09-21 12:36 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7100 | 166.1700 | 44395.00 | 0.00 | 44395.00 | 683 | 44 | 5675 | 3206 | 1.77011852776045 | 0.862137771720694 | 0.862137771720694 | false | false | false | true | ||||||||||||||||
| 66e65128-ac7d-4b1c-bd42-c6a6fcea8ef9 | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.1700 | 1.1500 | 1.2300 | 148.7387 | 17668.00 | 10179.00 | 7255.00 | 151 | 21 | 2675 | 4268 | 0.626757263355202 | 0.719781090077281 | 0.720286841225317 | true | false | false | true | ||||||||||||||||
| ab05a8c8-8c59-4bb3-8c8a-206767064eb1 | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.7200 | 1.7000 | 1.7800 | 141.4200 | 34745.00 | 5333.00 | 29240.00 | 202 | 8 | 2143 | 4268 | 0.502108716026242 | 0.695865144963451 | 0.697611830950369 | true | false | false | true | ||||||||||||||||
| 6d2acaf7-edab-4289-9007-f3541532a28d | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.7600 | 1.7500 | 1.8000 | 141.2300 | 93183.00 | 74976.00 | 18207.00 | 529 | 15 | 1834 | 4268 | 0.42970946579194 | 0.695787615005075 | 0.699828202767522 | true | false | false | true | ||||||||||||||||
| 9ad71892-09bb-4a9a-8c57-c7b2e19cf29a | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.7700 | 1.7500 | 1.8400 | 141.1200 | 19604.00 | 12348.00 | 7256.00 | 111 | 10 | 1215 | 4268 | 0.284676663542643 | 0.698137951185405 | 0.698137951185405 | true | false | false | true | ||||||||||||||||
| 8f9ed61a-c96f-4887-9cf7-286473cd9063 | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.7700 | 1.7700 | 1.8200 | 141.1600 | 15574.00 | 15222.00 | 352.00 | 88 | 5 | 1303 | 4268 | 0.305295220243674 | 0.6987529004149 | 0.6987529004149 | true | false | false | true | ||||||||||||||||
| 8cddf1c7-72dd-4174-9387-ecaaaa50a014 | 2026-09-18 09:40 | 2026-09-18 09:40 | 2026-09-18 09:40 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 1.8500 | 1.8500 | 1.8900 | 141.3450 | 185000.00 | 0.00 | 185000.00 | 1000 | 31 | 1060 | 4268 | 0.248359887535145 | 0.711716785072037 | 0.711716785072037 | true | false | false | true | ||||||||||||||||
| 286f6caa-67b3-4ac5-b1dd-59f52c105f6e | 2026-09-17 09:56 | 2026-09-17 09:56 | 2026-09-17 09:56 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 3.4500 | 3.4000 | 3.6500 | 130.6800 | 34500.00 | 0.00 | 34500.00 | 100 | 6 | 134 | 4106 | 0.0326351680467608 | 0.681006818502754 | 0.681006818502754 | false | false | false | true | ||||||||||||||||
| ca7bd32d-422f-4a58-90f8-45d6bda3ccab | 2026-09-16 14:57 | 2026-09-16 14:56 | 2026-09-16 14:56 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 5.4500 | 5.2500 | 5.4500 | 123.9300 | 36515.00 | 36515.00 | 0.00 | 67 | 11 | 333 | 3985 | 0.0835633626097867 | 0.688708380427697 | 0.688708380427697 | false | false | false | true | ||||||||||||||||
| 0bafc6cb-5ea9-4d9d-a795-7986e69a7688 | 2026-09-16 13:49 | 2026-09-16 13:49 | 2026-09-16 13:49 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 4.8000 | 4.6500 | 4.8000 | 125.0000 | 17280.00 | 17280.00 | 0.00 | 36 | 10 | 182 | 3985 | 0.0456712672521957 | 0.677549347980112 | 0.677549347980112 | true | false | false | true | ||||||||||||||||
| 2a01aae7-540d-48bd-a3a2-c59be7ef8928 | 2026-09-16 10:14 | 2026-09-16 10:14 | 2026-09-16 10:14 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 4.8300 | 4.8000 | 4.9500 | 126.0000 | 19308.00 | 0.00 | 19308.00 | 40 | 6 | 50 | 3985 | 0.0125470514429109 | 0.694036608791342 | 0.697327369019876 | false | false | false | true | ||||||||||||||||
| 1d104def-a481-4676-8878-201fbf1d889a | 2026-09-15 14:52 | 2026-09-15 14:51 | 2026-09-15 14:51 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 5.3500 | 5.3500 | 5.4500 | 126.5450 | 26764.00 | 0.00 | 26764.00 | 50 | 5 | 939 | 3370 | 0.278635014836795 | 0.731806233557856 | 0.731806233557856 | false | false | false | true | ||||||||||||||||
| 492a2450-f4de-4a82-a0b4-2e900f7577cb | 2026-09-14 10:19 | 2026-09-14 10:19 | 2026-09-14 10:19 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 3.2300 | 3.1500 | 3.4000 | 136.0000 | 32347.00 | 0.00 | 32347.00 | 100 | 5 | 153 | 2806 | 0.0545260156806842 | 0.72663542691343 | 0.72663542691343 | false | false | false | true | ||||||||||||||||
| d362834b-81db-4c56-a69e-d8137c5e1f9b | 2026-09-01 11:12 | 2026-09-01 11:12 | 2026-09-01 11:12 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 6.3500 | 6.1000 | 6.4000 | 127.3200 | 28573.00 | 21588.00 | 635.00 | 45 | 12 | 209 | 1906 | 0.109653725078699 | 0.69134619941174 | 0.691157448231143 | false | false | false | true | ||||||||||||||||
| 1049a208-6a8f-4c9b-bb6c-7a519344a76f | 2026-09-01 10:52 | 2026-09-01 10:52 | 2026-09-01 10:52 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 5.9500 | 5.9000 | 5.9500 | 128.6200 | 48790.00 | 48790.00 | 0.00 | 82 | 44 | 133 | 1906 | 0.0697796432318993 | 0.688829779128002 | 0.688829779128002 | false | false | false | true | ||||||||||||||||
| c6d6b965-60a4-4ebf-a6ee-0011852d6f93 | 2026-08-27 12:14 | 2026-08-27 12:14 | 2026-08-27 12:14 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 5.3000 | 5.0500 | 5.3000 | 137.9200 | 15900.00 | 15900.00 | 0.00 | 30 | 8 | 468 | 1820 | 0.257142857142857 | 0.757803594443564 | 0.757803594443564 | false | false | false | true | ||||||||||||||||
| d530f870-11a8-4e12-b0b0-7dabafeb1ff2 | 2026-08-26 11:35 | 2026-08-26 11:35 | 2026-08-26 11:35 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 8.8000 | 8.8000 | 8.9500 | 122.4800 | 86240.00 | 0.00 | 86240.00 | 98 | 10 | 248 | 1738 | 0.142692750287687 | 0.7059815529293 | 0.7059815529293 | true | false | false | true | ||||||||||||||||
| 58d2c582-0351-4f19-b2da-bba3ce836616 | 2026-08-24 10:08 | 2026-08-24 10:08 | 2026-08-24 10:08 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 9.8000 | 9.6000 | 9.8500 | 123.7800 | 103880.00 | 102900.00 | 0.00 | 106 | 17 | 115 | 1466 | 0.0784447476125512 | 0.776974959305657 | 0.776974959305657 | false | false | false | true | ||||||||||||||||
| 4d7b3459-e3c1-4de8-8037-e41f0da39892 | 2026-08-20 11:55 | 2026-08-20 11:54 | 2026-08-20 11:54 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 14.7600 | 14.5000 | 14.8500 | 113.4000 | 29520.00 | 2960.00 | 25080.00 | 20 | 7 | 282 | 1171 | 0.240819812126388 | 0.800254024397081 | 0.802028717691375 | false | false | false | true | ||||||||||||||||
| 0e9223c0-dc35-4ceb-a6ac-2e403f81093e | 2026-08-20 10:45 | 2026-08-20 10:45 | 2026-08-20 10:45 | MSTR | MSTR261016P00115000 | put | 115.0000 | 2026-10-16 | 16.2100 | 16.1500 | 16.4500 | 109.2000 | 179965.00 | 47125.00 | 132840.00 | 111 | 5 | 179 | 1171 | 0.152860802732707 | 0.768546151693935 | 0.768546151693935 | false | false | false | true |
| 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:38:21.627494Z"} |
| 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 |
| — |
| 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-18T13:50:28.178058Z"} |
| 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-18T13:50:28.178058Z"} |
| 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-18T13:50:28.178058Z"} |
| 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-18T13:50:28.178058Z"} |
| 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-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 48216432507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 46003398516.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 46003398516.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 46003398516.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 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-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-09-14T14:26:55.719155Z"} |
| 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:18:08.991662Z"} |
| 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 |
| 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:30:57.923324Z"} |
| 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-26T15:48:55.759300Z"} |
| 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:21:20.397116Z"} |
| 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-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |