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 |
|---|
| 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 |
|---|
| 7bc4f54a-a052-4153-a4ba-7dd3885894d0 | 2026-08-31 15:19 | 2026-08-31 15:19 | 2026-08-31 15:19 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 13.7300 | 13.5000 | 13.8500 | 942.4500 | 549081.00 | 529958.00 | 19123.00 | 400 | 5 | 3172 | 211 | 15.0331753554502 | 0.531047030566616 | 0.531047030566616 | false | false | false | true | false | 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:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54743493-69bc-4985-886c-791bb820b520 | 2026-08-31 15:31 | 2026-08-31 15:31 | 2026-08-31 15:31 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 14.9600 | 14.8500 | 15.3000 | 945.3800 | 601404.00 | 0.00 | 601404.00 | 402 | 6 | 4590 | 211 | 21.7535545023697 | 0.52416161658796 | 0.528181073496437 | false | false | false | |||||||||||||||||
| f26230f2-c2e1-4c6b-90ab-e2a6f7938f90 | 2026-09-01 14:04 | 2026-09-01 14:04 | 2026-09-01 14:04 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 6.5000 | 6.4000 | 6.7000 | 934.3000 | 325070.00 | 301600.00 | 23470.00 | 500 | 6 | 11513 | 514 | 22.3988326848249 | 0.560511084453639 | 0.560511084453639 | true | false | false | |||||||||||||||||
| d921a658-ab34-4a5c-a843-aa14a6822d7e | 2026-09-02 11:47 | 2026-09-02 11:47 | 2026-09-02 11:47 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 3.4500 | 3.4500 | 3.7000 | 942.5200 | 213244.00 | 0.00 | 213244.00 | 618 | 38 | 20752 | 1558 | 13.3196405648267 | 0.554786264489402 | 0.554786264489402 | false | false | false | |||||||||||||||||
| 560cd428-0fcf-4009-86a8-8e39c1de7519 | 2026-09-02 12:46 | 2026-09-02 12:46 | 2026-09-02 12:46 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 4.1000 | 4.1000 | 4.3000 | 944.6500 | 164824.00 | 0.00 | 164824.00 | 402 | 39 | 28637 | 1558 | 18.3806161745828 | 0.588799083731606 | 0.589483085807729 | false | false | false | |||||||||||||||||
| cc88b880-11f0-49f8-8f01-5e9782a95ef0 | 2026-09-02 12:52 | 2026-09-02 12:52 | 2026-09-02 12:52 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 2.9200 | 2.8600 | 2.9300 | 942.0650 | 102305.00 | 92295.00 | 0.00 | 350 | 27 | 29644 | 1558 | 19.0269576379974 | 0.58388682840824 | 0.594976635955093 | true | false | false | |||||||||||||||||
| f51ce878-3a15-4b3a-86ac-9d7eb3adbc97 | 2026-09-02 14:07 | 2026-09-02 14:07 | 2026-09-02 14:07 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 4.2300 | 4.0000 | 4.3500 | 946.2100 | 169079.00 | 162426.00 | 6653.00 | 400 | 7 | 37733 | 1558 | 24.2188703465982 | 0.636224072318836 | 0.636224072318836 | false | false | false |
| false |
| 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 |
| false |
| 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-01T18:15:43.135015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |