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 |
|---|
| 04d6528d-ee65-48a1-b590-b8a8b2f94d6a | 2026-08-27 14:46 | 2026-08-27 14:45 | 2026-08-27 14:45 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 18.6000 | 18.0000 | 18.6000 | 914.6900 | 1443260.00 | 1419175.00 | 24085.00 | 776 | 76 | 2079 | 926 | 2.2451403887689 | 0.600997494376822 | 0.600363374132423 | false | false | false | 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-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f26a1b0-eb03-4e7d-b186-ca179db2a8d9 | 2026-08-28 10:59 | 2026-08-28 10:59 | 2026-08-28 10:59 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 24.6400 | 23.9500 | 24.9000 | 940.0300 | 123222.00 | 123222.00 | 0.00 | 50 | 7 | 1207 | 2183 | 0.552908841044434 | 0.555454756515438 | 0.555454756515438 | false | false | false | true | ||||||||||||||||
| 5cee8664-693c-4adb-9081-4cc0f3941f28 | 2026-08-31 09:56 | 2026-08-31 09:55 | 2026-08-31 09:55 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 23.0000 | 22.5000 | 23.0000 | 946.9700 | 124195.00 | 124195.00 | 0.00 | 54 | 7 | 1191 | 2535 | 0.469822485207101 | 0.612560165374672 | 0.613573957899281 | false | false | false | true | ||||||||||||||||
| ff7df77b-32a2-4a34-bba3-32fa470ab42c | 2026-08-31 10:03 | 2026-08-31 10:03 | 2026-08-31 10:03 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 22.6500 | 22.5500 | 23.1500 | 946.7000 | 158550.00 | 0.00 | 158550.00 | 70 | 6 | 1876 | 2535 | 0.740039447731755 | 0.608098867468553 | 0.608098867468553 | false | false | false | true | ||||||||||||||||
| 8e2dd174-c815-45b9-ac4c-96da1bfb93a2 | 2026-08-31 15:52 | 2026-08-31 15:52 | 2026-08-31 15:52 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 24.0000 | 23.5500 | 24.0000 | 952.7800 | 304788.00 | 304788.00 | 0.00 | 127 | 10 | 8207 | 2535 | 3.23747534516765 | 0.565876891555318 | 0.563393624084956 | false | false | false | true | ||||||||||||||||
| 92ed9a6b-1f65-4eac-9d0e-5f196cac04ca | 2026-09-01 11:01 | 2026-09-01 11:00 | 2026-09-01 11:00 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 25.0000 | 24.5500 | 25.0000 | 958.9200 | 147500.00 | 147500.00 | 0.00 | 59 | 6 | 2501 | 3178 | 0.786972938955318 | 0.581065855340501 | 0.581065855340501 | false | false | false | true | ||||||||||||||||
| 4d32cbf0-67aa-4555-a726-161f9a3f5a1f | 2026-09-01 11:46 | 2026-09-01 11:45 | 2026-09-01 11:45 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 30.0000 | 29.6500 | 30.3000 | 966.7880 | 107989.00 | 107989.00 | 0.00 | 36 | 7 | 3406 | 3178 | 1.07174323473883 | 0.583112308683578 | 0.586472256191531 | false | false | false | true | ||||||||||||||||
| 0e84c9fe-df78-4ce9-873d-f90716bb9792 | 2026-09-01 11:52 | 2026-09-01 11:52 | 2026-09-01 11:52 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 29.0000 | 28.6500 | 29.3500 | 965.7800 | 226200.00 | 176900.00 | 0.00 | 78 | 8 | 3587 | 3178 | 1.12869729389553 | 0.577151547310001 | 0.575617284932891 | false | false | false | true | ||||||||||||||||
| 7bf29046-02ae-46eb-b9cb-df03dba8b7b9 | 2026-09-01 12:05 | 2026-09-01 12:05 | 2026-09-01 12:05 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 22.0000 | 21.6500 | 22.0000 | 954.3050 | 220000.00 | 220000.00 | 0.00 | 100 | 5 | 4048 | 3178 | 1.27375707992448 | 0.569627881115001 | 0.569627881115001 | true | false | false | true | ||||||||||||||||
| b470ba50-f590-4c9d-a096-451efb223351 | 2026-09-01 14:18 | 2026-09-01 14:18 | 2026-09-01 14:18 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 11.5000 | 11.5000 | 11.7000 | 928.6800 | 575000.00 | 0.00 | 575000.00 | 500 | 10 | 9457 | 3178 | 2.97577092511013 | 0.597772283333141 | 0.597772283333141 | true | false | false | true | ||||||||||||||||
| 2f91a688-c704-473f-bd4f-2018a7be37d6 | 2026-09-02 09:38 | 2026-09-02 09:38 | 2026-09-02 09:38 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 14.6500 | 14.0500 | 14.6500 | 941.0550 | 131839.00 | 131839.00 | 0.00 | 90 | 16 | 599 | 3689 | 0.162374627270263 | 0.669414043200126 | 0.669778623320872 | false | false | false | true | ||||||||||||||||
| 8344d8d4-4c25-4912-9a5c-c928fe399403 | 2026-09-02 14:33 | 2026-09-02 14:33 | 2026-09-02 14:33 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 15.6600 | 15.6500 | 16.0000 | 949.7900 | 101770.00 | 14130.00 | 46950.00 | 65 | 5 | 8907 | 3689 | 2.4144754676064 | 0.558174666936477 | 0.55995768018151 | true | false | false | true | ||||||||||||||||
| c8175acb-de71-4bcb-aa05-4e9eaad81efd | 2026-09-02 15:54 | 2026-09-02 15:54 | 2026-09-02 15:54 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 20.0000 | 19.8000 | 20.0000 | 956.9250 | 119986.00 | 119986.00 | 0.00 | 60 | 9 | 12593 | 3689 | 3.41366223908918 | 0.573144298688159 | 0.575044238559846 | true | false | false | true | ||||||||||||||||
| eca79749-33ca-4d37-82f4-7baeff95c3e6 | 2026-09-03 10:52 | 2026-09-03 10:52 | 2026-09-03 10:52 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 8.2000 | 7.9500 | 8.2000 | 937.8800 | 150010.00 | 150010.00 | 0.00 | 183 | 15 | 12057 | 3812 | 3.16290661070304 | 0.677827645178909 | 0.677827645178909 | false | false | false | true | ||||||||||||||||
| 5ce5fece-a0c0-42b4-a12c-c9a002c037ae | 2026-09-03 12:19 | 2026-09-03 12:19 | 2026-09-03 12:19 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 10.1000 | 9.8000 | 10.1000 | 944.1800 | 100970.00 | 98980.00 | 0.00 | 100 | 5 | 20883 | 3812 | 5.47822665267576 | 0.63741381624534 | 0.645123870408783 | false | false | false | true | ||||||||||||||||
| 8974af52-d30e-4aba-ba74-ee84d7dfc821 | 2026-09-03 12:26 | 2026-09-03 12:25 | 2026-09-03 12:25 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 9.9500 | 9.6000 | 10.0000 | 943.8050 | 151240.00 | 151240.00 | 0.00 | 152 | 12 | 21282 | 3812 | 5.58289611752361 | 0.645767602268975 | 0.645767602268975 | false | false | false | true | ||||||||||||||||
| d09bc5bc-4457-4eb8-80bf-a62ef946b808 | 2026-09-03 13:30 | 2026-09-03 13:30 | 2026-09-03 13:30 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 9.1500 | 8.9000 | 9.1500 | 941.9900 | 118035.00 | 118035.00 | 0.00 | 129 | 24 | 26350 | 3812 | 6.91238195173137 | 0.643794147626142 | 0.643794147626142 | true | false | false | true | ||||||||||||||||
| 79996e32-1f60-4d6b-870d-d585498500da | 2026-09-03 14:05 | 2026-09-03 14:04 | 2026-09-03 14:04 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 12.3600 | 12.3000 | 12.5000 | 950.3300 | 123608.00 | 79148.00 | 44460.00 | 100 | 7 | 28716 | 3812 | 7.53305351521511 | 0.613164029125656 | 0.611651583298639 | false | false | false | true | ||||||||||||||||
| db795fd0-eaa1-43db-b3a8-4ef29961e301 | 2026-09-03 15:52 | 2026-09-03 15:52 | 2026-09-03 15:52 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 14.9500 | 14.9500 | 15.3000 | 954.4200 | 115115.00 | 0.00 | 115115.00 | 77 | 18 | 35603 | 3812 | 9.3397166841553 | 0.631822496715191 | 0.631822496715191 | true | false | false | true | ||||||||||||||||
| 60b27dff-863f-4da4-a671-44609a962038 | 2026-09-04 09:32 | 2026-09-04 09:32 | 2026-09-04 09:32 | MU | MU260904C00950000 | call | 950.0000 | 2026-09-04 | 35.0300 | 33.9000 | 35.5500 | 984.1100 | 241701.00 | 241701.00 | 0.00 | 69 | 8 | 735 | 4721 | 0.155687354374073 | 1.06149783234203 | 1.03871563589716 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-03T18:16:35.526734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |