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_alerts658,639 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 | strike |
|---|
| 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 |
|---|
| a479e084-d226-478b-82f3-03e2a5329f5e | 2026-09-18 13:37 | 2026-09-18 13:37 | 2026-09-18 13:37 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 3.7600 | 3.7000 | 3.9500 | 999.2400 | 105184.00 | 3555.00 | 101629.00 | 280 | 7 | 109901 | 16069 | 6.83931794137781 | 0.616606934934028 | 0.627362182834592 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1147237562786.00 | 2026-09-30 | postmarket | — | 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 |
| c3528666-9b9a-448a-82ea-e97a91075b22 | 2026-09-18 13:34 | 2026-09-18 13:34 | 2026-09-18 13:34 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 3.3000 | 3.2000 | 3.3000 | 998.3750 | 338238.00 | 337586.00 | 652.00 | 1025 | 8 | 107687 | 16069 | 6.70153712116498 | 0.611931520392673 | 0.606151551759241 | false | false | false | |||||||||||||||||
| b091b370-f80b-42de-8b8d-f4e13ba913e6 | 2026-09-18 13:04 | 2026-09-18 13:04 | 2026-09-18 13:04 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 2.5600 | 2.5400 | 2.6000 | 996.4400 | 132361.00 | 107625.00 | 24736.00 | 518 | 27 | 93204 | 16069 | 5.80023648017923 | 0.567581897681741 | 0.567581897681741 | true | false | false | |||||||||||||||||
| 9fe3100a-0319-409a-a147-78da3577220d | 2026-09-18 10:47 | 2026-09-18 10:46 | 2026-09-18 10:46 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 3.9500 | 3.8000 | 3.9500 | 994.8000 | 391429.00 | 391429.00 | 0.00 | 991 | 52 | 51052 | 16069 | 3.17704897628975 | 0.63820971917003 | 0.63820971917003 | false | false | false | |||||||||||||||||
| a93ec416-2a30-4613-b268-ea3e408af4f5 | 2026-09-18 09:42 | 2026-09-18 09:42 | 2026-09-18 09:42 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 4.9900 | 4.8000 | 5.0000 | 993.0000 | 127678.00 | 127678.00 | 0.00 | 256 | 19 | 11380 | 16069 | 0.708195905159002 | 0.758653604429657 | 0.744353934992208 | true | false | false | |||||||||||||||||
| b1f0d1ba-04d4-4be9-a4ab-83b83277543f | 2026-09-17 15:00 | 2026-09-17 15:00 | 2026-09-17 15:00 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 3.4500 | 3.4500 | 3.5500 | 976.1000 | 478259.00 | 708.00 | 477551.00 | 1386 | 53 | 45308 | 13350 | 3.39385767790262 | 0.570411801536725 | 0.566745781403023 | false | false | false | |||||||||||||||||
| e046ba72-2666-409d-b486-763c82671d48 | 2026-09-17 10:18 | 2026-09-17 10:18 | 2026-09-17 10:18 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 5.8400 | 5.6500 | 5.8500 | 978.2050 | 207300.00 | 207300.00 | 0.00 | 355 | 23 | 21960 | 13350 | 1.64494382022472 | 0.683898422797971 | 0.682144850774056 | true | false | false | |||||||||||||||||
| f00e5568-6371-4c74-8f3c-8bbc2c16871b | 2026-09-17 10:15 | 2026-09-17 10:15 | 2026-09-17 10:15 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 6.1000 | 5.9000 | 6.1000 | 978.8000 | 154883.00 | 154883.00 | 0.00 | 254 | 35 | 20921 | 13350 | 1.56711610486891 | 0.688752053650789 | 0.688752053650789 | false | false | false | |||||||||||||||||
| fb075eac-8706-41a0-9867-a09ceca39e13 | 2026-09-08 10:18 | 2026-09-08 10:18 | 2026-09-08 10:18 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 51.4600 | 51.4500 | 51.9500 | 1016.6200 | 385920.00 | 0.00 | 385920.00 | 75 | 8 | 574 | 8986 | 0.063877142221233 | 0.632674954931263 | 0.632064544047762 | false | false | false | |||||||||||||||||
| 30a8c7ed-e4c0-477b-acce-f377dadc704d | 2026-09-04 13:12 | 2026-09-04 13:11 | 2026-09-04 13:11 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 44.3000 | 43.9000 | 45.3500 | 999.3600 | 4602376.00 | 827890.00 | 3774486.00 | 1039 | 68 | 6555 | 10823 | 0.605654624410977 | 0.563028295524185 | 0.564478357991883 | false | false | false | |||||||||||||||||
| ba7e04bf-0fb8-4cb5-b12c-4f8d5ae589db | 2026-09-04 11:15 | 2026-09-04 11:15 | 2026-09-04 11:15 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 43.3200 | 42.5500 | 43.4500 | 999.8000 | 103970.00 | 73675.00 | 30295.00 | 24 | 18 | 3096 | 10823 | 0.286057470202347 | 0.5473977424669 | 0.5473977424669 | true | false | false | |||||||||||||||||
| 244f3740-8d01-49f8-96ff-e624a0980600 | 2026-09-04 09:58 | 2026-09-04 09:58 | 2026-09-04 09:58 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 43.7500 | 43.4500 | 43.8500 | 999.2600 | 188128.00 | 118248.00 | 69880.00 | 43 | 21 | 1721 | 10823 | 0.15901321260279 | 0.557382502620576 | 0.556682331706768 | true | false | false | |||||||||||||||||
| c1e6eb0a-e718-4ccf-b3f4-9a63d0a85909 | 2026-09-03 12:55 | 2026-09-03 12:55 | 2026-09-03 12:55 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 22.2000 | 21.8500 | 22.3000 | 949.3799 | 344085.00 | 275275.00 | 66590.00 | 155 | 29 | 3740 | 10729 | 0.348587939230124 | 0.537240422322205 | 0.537192558406032 | false | false | false | |||||||||||||||||
| 6f62af4e-ddcd-4608-a47f-a7aed1e1b264 | 2026-08-27 14:53 | 2026-08-27 14:52 | 2026-08-27 14:52 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 23.8500 | 23.3000 | 23.8500 | 915.1500 | 1578856.00 | 1578856.00 | 0.00 | 662 | 65 | 2859 | 9787 | 0.292122202922244 | 0.595674079875589 | 0.595115080590373 | false | false | false | |||||||||||||||||
| f78af40f-de9a-4c35-b97b-864c9d89e297 | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | MU | MU260918C01000000 | call | 1000.0000 | 2026-09-18 | 64.8200 | 64.5000 | 65.6500 | 969.0899 | 129648.00 | 0.00 | 129648.00 | 20 | 8 | 1374 | 9981 | 0.137661556958221 | 0.641125235715041 | 0.641125235715041 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |