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_alerts566,287 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 |
|---|
| 2c474bb0-7904-44a5-9c53-7f8a00b04409 | 2026-09-29 10:16 | 2026-09-29 10:16 | 2026-09-29 10:16 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 19.2000 | 18.7000 | 20.4000 | 155.8300 | 576072.00 | 0.00 | 576072.00 | 300 | 8 | 330 | 11947 | 0.0276219971540973 | 0.701874056128992 | 0.701874056128992 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 56390439440.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:16:47.847178Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| bf7ee32d-c15e-4e62-8d88-290b99987573 | 2026-09-28 13:17 | 2026-09-28 13:17 | 2026-09-28 13:17 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 22.5700 | 22.2000 | 22.6000 | 161.4150 | 15800.00 | 9035.00 | 6765.00 | 7 | 5 | 125 | 11889 | 0.0105139204306502 | 0.703830934255935 | 0.703830934255935 | true | false | false | |||||||||||||||||
| c236dba3-e7be-49b7-96f9-c2cfffbd31d9 | 2026-09-28 12:25 | 2026-09-28 12:25 | 2026-09-28 12:25 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 21.3000 | 20.9000 | 21.3000 | 159.3400 | 21295.00 | 19170.00 | 2125.00 | 10 | 6 | 66 | 11889 | 0.0055513499873833 | 0.702234139047581 | 0.702234139047581 | true | false | false | |||||||||||||||||
| e24a1a7d-8963-4a56-bff3-c59550a1abba | 2026-09-21 15:42 | 2026-09-21 15:41 | 2026-09-21 15:41 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 29.3000 | 29.3000 | 30.0000 | 168.2600 | 35160.00 | 0.00 | 35160.00 | 12 | 12 | 380 | 12122 | 0.0313479623824451 | 0.756391676718645 | 0.756391676718645 | true | false | false | |||||||||||||||||
| 46f779c3-9113-45de-8e16-cab1cf5644b6 | 2026-09-18 15:12 | 2026-09-18 15:12 | 2026-09-18 15:12 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 19.7000 | 19.3500 | 19.7000 | 152.7300 | 21670.00 | 21670.00 | 0.00 | 11 | 11 | 426 | 12085 | 0.0352503103020273 | 0.726587408998655 | 0.726587408998655 | true | false | false | |||||||||||||||||
| 0f84e983-3241-4709-b980-3d85b27a813d | 2026-09-18 13:09 | 2026-09-18 13:09 | 2026-09-18 13:09 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 18.2500 | 18.2500 | 18.5500 | 149.9474 | 74825.00 | 0.00 | 74825.00 | 41 | 5 | 304 | 12085 | 0.0251551510136533 | 0.726740269702596 | 0.726740269702596 | true | false | false | |||||||||||||||||
| e5354069-4d35-47b0-8c17-b819bab513a5 | 2026-09-18 12:33 | 2026-09-18 12:33 | 2026-09-18 12:33 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 19.0000 | 18.6500 | 19.0500 | 150.9700 | 20895.00 | 18995.00 | 1900.00 | 11 | 7 | 224 | 12085 | 0.018535374431113 | 0.734130893891283 | 0.734130893891283 | false | false | false | |||||||||||||||||
| aa0def29-ebeb-4d3f-ac59-863983857623 | 2026-09-18 12:05 | 2026-09-18 12:05 | 2026-09-18 12:05 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 18.0000 | 17.7500 | 18.0500 | 149.0000 | 19800.00 | 18000.00 | 0.00 | 11 | 7 | 188 | 12085 | 0.0155564749689698 | 0.730895526800749 | 0.730895526800749 | false | false | false | |||||||||||||||||
| 52058a5b-ac61-4157-8611-c83e29e5dac8 | 2026-09-17 10:37 | 2026-09-17 10:36 | 2026-09-17 10:36 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 10.1000 | 10.0500 | 10.3500 | 131.3500 | 48480.00 | 0.00 | 45450.00 | 48 | 13 | 158 | 12069 | 0.0130913911674538 | 0.72476862823204 | 0.72536361117259 | false | false | false | |||||||||||||||||
| 3da3d38a-1125-41c3-85fa-44ce9dcde252 | 2026-09-15 09:43 | 2026-09-15 09:43 | 2026-09-15 09:43 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 11.0000 | 10.8000 | 11.2000 | 130.5100 | 11000.00 | 2200.00 | 4400.00 | 10 | 5 | 16 | 12001 | 0.00133322223148071 | 0.765704587408283 | 0.765704587408283 | false | false | false | |||||||||||||||||
| 45ca246d-ee46-471e-9db7-cd8c9967a593 | 2026-09-04 11:47 | 2026-09-04 11:47 | 2026-09-04 11:47 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 17.4000 | 17.1500 | 17.4500 | 141.6550 | 407158.00 | 405418.00 | 1740.00 | 234 | 33 | 442 | 12097 | 0.036537984624287 | 0.779186556633337 | 0.779186556633337 | false | false | false | |||||||||||||||||
| 619d017b-5905-4b47-a5ab-5849d87b4d0c | 2026-09-04 11:36 | 2026-09-04 11:36 | 2026-09-04 11:36 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 17.1500 | 16.8000 | 17.1500 | 141.4800 | 73743.00 | 73743.00 | 0.00 | 43 | 15 | 187 | 12097 | 0.0154583781102753 | 0.773678810643443 | 0.773678810643443 | false | false | false | |||||||||||||||||
| 1c04b0ed-eea0-43cb-831f-c1e77916e3d4 | 2026-09-04 11:36 | 2026-09-04 11:36 | 2026-09-04 11:36 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 17.0500 | 16.9000 | 17.1000 | 141.4293 | 86980.00 | 61405.00 | 25575.00 | 51 | 7 | 144 | 12097 | 0.0119037777961478 | 0.771165807863525 | 0.772821349163324 | false | false | false | |||||||||||||||||
| e89467d4-9a5e-486c-9d51-9208307cb8a1 | 2026-09-03 11:21 | 2026-09-03 11:21 | 2026-09-03 11:21 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 16.1500 | 15.9500 | 16.2000 | 138.3000 | 32300.00 | 32300.00 | 0.00 | 20 | 6 | 163 | 12103 | 0.0134677352722465 | 0.787496396752452 | 0.787496396752452 | false | false | false | |||||||||||||||||
| b75b3645-e915-41de-acea-5a0fe57afb30 | 2026-09-02 10:56 | 2026-09-02 10:56 | 2026-09-02 10:56 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 9.5000 | 9.3500 | 9.5000 | 123.0050 | 47495.00 | 47495.00 | 0.00 | 50 | 19 | 58 | 12075 | 0.00480331262939959 | 0.763902461596592 | 0.763902461596592 | false | false | false | |||||||||||||||||
| 223c0d3a-ada8-4637-8be6-6acbd4085ebe | 2026-08-27 12:23 | 2026-08-27 12:23 | 2026-08-27 12:23 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 17.3000 | 17.3000 | 17.6500 | 138.4700 | 105530.00 | 0.00 | 105530.00 | 61 | 13 | 190 | 12064 | 0.0157493368700265 | 0.79664862214135 | 0.79664862214135 | false | false | false | |||||||||||||||||
| b88a55d4-c98e-45be-9a48-caa9758b0acc | 2026-08-25 14:32 | 2026-08-25 14:32 | 2026-08-25 14:32 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 12.7500 | 12.7000 | 13.3000 | 127.1800 | 39525.00 | 24225.00 | 15300.00 | 31 | 5 | 120 | 12061 | 0.00994942376254042 | 0.798877718538181 | 0.80003285060274 | false | false | false | |||||||||||||||||
| de5b9c42-bb30-4ba8-a524-e5a5a9a0e0ad | 2026-08-21 11:22 | 2026-08-21 11:22 | 2026-08-21 11:22 | MSTR | MSTR261218C00160000 | call | 160.0000 | 2026-12-18 | 12.5500 | 12.2500 | 12.5500 | 121.0700 | 62750.00 | 62750.00 | 0.00 | 50 | 5 | 2275 | 11324 | 0.200900741787354 | 0.866521412550762 | 0.866521412550762 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 57290965627.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:19:28.127725Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 57290965627.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:25:44.498264Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| 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:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| 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 |
| false |
| 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-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| 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-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-04T16:13:56.145626Z"} |
| 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-09-04T15:46:11.944585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T15:46:11.944585Z"} |
| 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-09-03T15:27:44.291947Z"} |
| 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-09-02T15:04:15.415728Z"} |
| 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-27T16:30:57.923324Z"} |
| 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-25T18:54:14.733334Z"} |
| 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-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |