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_alerts523,327 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 |
|---|
| 5dc4b04d-d741-45f4-9ee7-3f43e7cace0d | 2026-09-04 13:01 | 2026-09-04 13:00 | 2026-09-04 13:00 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 25.1500 | 25.0500 | 25.2500 | 143.0200 | 95570.00 | 20120.00 | 60360.00 | 38 | 28 | 54 | 1949 | 0.0277065161621344 | 0.770334075733757 | 0.770334075733757 | true | false | false | true | 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-04T17:07:55.847311Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e83ddf7-548a-47d4-92c5-1deb5784be53 | 2026-09-18 14:16 | 2026-09-18 14:16 | 2026-09-18 14:16 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 16.4500 | 16.4000 | 16.6500 | 151.4350 | 14805.00 | 3290.00 | 11515.00 | 9 | 7 | 157 | 2119 | 0.07409155261916 | 0.698594740284761 | 0.698594740284761 | false | false | false | |||||||||||||||||
| 6f2b96da-c132-46b2-812c-2a9f1ea55d02 | 2026-09-21 14:44 | 2026-09-21 14:44 | 2026-09-21 14:44 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.4500 | 9.3500 | 9.4500 | 166.1508 | 19842.00 | 19842.00 | 0.00 | 21 | 5 | 973 | 2221 | 0.438090950022512 | 0.734413731575521 | 0.734413731575521 | false | false | false | |||||||||||||||||
| 49efb1f8-4dc6-4fd5-b97a-67117c2ca6b4 | 2026-09-21 15:42 | 2026-09-21 15:42 | 2026-09-21 15:42 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 8.8500 | 8.8000 | 8.8500 | 168.2250 | 15045.00 | 15045.00 | 0.00 | 17 | 5 | 1093 | 2221 | 0.492120666366502 | 0.74429174523487 | 0.74429174523487 | true | false | false | |||||||||||||||||
| 6a7976c4-e839-47cd-a838-f59ac48ba43d | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 7.5500 | 7.5000 | 7.6000 | 168.0000 | 46055.00 | 44545.00 | 1510.00 | 61 | 16 | 112 | 2983 | 0.0375460945357023 | 0.69636858249092 | 0.695012946855662 | true | false | false | |||||||||||||||||
| a820b6d8-06f9-4565-8526-fe8ab1d75abd | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 8.3000 | 8.1500 | 8.3500 | 166.0850 | 16600.00 | 15770.00 | 830.00 | 20 | 12 | 168 | 2983 | 0.0563191418035535 | 0.690570821429034 | 0.690570821429034 | false | false | false | |||||||||||||||||
| 9da432b7-f44a-46c7-b3e6-7c72dd931efb | 2026-09-23 10:23 | 2026-09-23 10:23 | 2026-09-23 10:23 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.6500 | 9.5000 | 9.6500 | 163.1100 | 68481.00 | 68481.00 | 0.00 | 71 | 18 | 347 | 2983 | 0.116325846463292 | 0.700222546263275 | 0.70137754014523 | true | false | false | |||||||||||||||||
| 4ff7e24d-9b9b-49d4-a2eb-c66cb13b9024 | 2026-09-23 12:02 | 2026-09-23 12:02 | 2026-09-23 12:02 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.5500 | 9.3500 | 9.6000 | 162.6800 | 18145.00 | 17190.00 | 955.00 | 19 | 9 | 532 | 2983 | 0.178343949044586 | 0.68383989920461 | 0.68383989920461 | true | false | false | |||||||||||||||||
| 9aae806c-8091-4029-979c-1f76024d7d5a | 2026-09-23 12:28 | 2026-09-23 12:28 | 2026-09-23 12:28 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.0000 | 8.9500 | 9.0500 | 163.7800 | 44998.00 | 1798.00 | 36900.00 | 50 | 7 | 732 | 2983 | 0.245390546429769 | 0.67729359402266 | 0.677920657941103 | false | false | false | |||||||||||||||||
| 46c59c80-ddc4-41b4-8410-94803bf1895f | 2026-09-23 13:13 | 2026-09-23 13:13 | 2026-09-23 13:13 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.6000 | 9.4500 | 9.6000 | 162.0000 | 20160.00 | 20160.00 | 0.00 | 21 | 8 | 1698 | 2983 | 0.569225611800201 | 0.688815439444942 | 0.688815439444942 | true | false | false | |||||||||||||||||
| a116e769-00a1-4bed-b9da-6fbad0bf63a8 | 2026-09-24 09:33 | 2026-09-24 09:33 | 2026-09-24 09:33 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 8.9300 | 8.8500 | 9.2500 | 163.7200 | 25005.00 | 2685.00 | 22320.00 | 28 | 13 | 34 | 4009 | 0.00848091793464704 | 0.683600122116599 | 0.684712588682895 | false | false | false | |||||||||||||||||
| fde5e40e-1fd5-4f5e-879c-c9903f0b06d7 | 2026-09-24 09:55 | 2026-09-24 09:55 | 2026-09-24 09:55 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.9000 | 9.8500 | 10.1000 | 160.9100 | 44550.00 | 1980.00 | 42570.00 | 45 | 8 | 105 | 4009 | 0.0261910700922923 | 0.671894518011004 | 0.671894518011004 | false | false | false | |||||||||||||||||
| 7c7d999e-c1c6-4149-a80f-05827c32b6a2 | 2026-09-24 10:51 | 2026-09-24 10:51 | 2026-09-24 10:51 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 10.2000 | 10.0000 | 10.2000 | 160.4500 | 55080.00 | 55080.00 | 0.00 | 54 | 11 | 646 | 4009 | 0.161137440758294 | 0.677817413290216 | 0.677817413290216 | false | false | false | |||||||||||||||||
| ffc7bcb7-32ea-466f-8fae-194a030d97cf | 2026-09-24 15:05 | 2026-09-24 15:05 | 2026-09-24 15:05 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 9.4000 | 9.3500 | 9.5500 | 162.0707 | 17860.00 | 940.00 | 16920.00 | 19 | 6 | 982 | 4009 | 0.244948865053629 | 0.672513059426077 | 0.672513059426077 | false | false | false | |||||||||||||||||
| 64e7f7b9-c09a-4d9d-9857-43ab4fef8bdf | 2026-09-25 09:48 | 2026-09-25 09:48 | 2026-09-25 09:48 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 10.2000 | 10.1500 | 10.3500 | 159.4200 | 139740.00 | 25500.00 | 89760.00 | 137 | 20 | 152 | 4138 | 0.0367327211213146 | 0.659140846591066 | 0.661935670592924 | false | false | false | |||||||||||||||||
| 157c9f6b-8e80-4605-9bc1-c0321d8026dd | 2026-09-28 10:49 | 2026-09-28 10:49 | 2026-09-28 10:49 | MSTR | MSTR261016P00160000 | put | 160.0000 | 2026-10-16 | 11.3500 | 11.3500 | 11.5500 | 155.0000 | 21565.00 | 0.00 | 21565.00 | 19 | 5 | 211 | 4377 | 0.0482065341558145 | 0.654879561509412 | 0.654879561509412 | true | false | false |
| 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-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-21T18:46:35.766190Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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 |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T16:06:31.927382Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T13:56:38.298983Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T19:07:42.806014Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 57290965627.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:50:19.857671Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |