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 |
|---|
| 4e69fedb-418b-48dc-8518-71f8a59b5388 | 2026-08-28 10:00 | 2026-08-28 10:00 | 2026-08-28 10:00 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 20.6500 | 18.7500 | 20.6500 | 936.8750 | 103250.00 | 103250.00 | 0.00 | 50 | 12 | 60 | 88 | 0.681818181818182 | 0.552772689698632 | 0.552772689698632 | true | false | false | true | false | 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-28T14:08:43.927668Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 | ||||||||||||||||
| f996052c-9537-463a-9709-a732ac2cddd6 | 2026-08-31 15:21 | 2026-08-31 15:21 | 2026-08-31 15:21 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 14.2000 | 14.1000 | 14.3500 | 943.6750 | 213000.00 | 36920.00 | 176080.00 | 150 | 8 | 3670 | 211 | 17.39336492891 | 0.529282642038283 | 0.529282642038283 | false | false | false | true | ||||||||||||||||
| 809405e6-3c2e-4067-8d2f-0169572b8015 | 2026-08-31 15:30 | 2026-08-31 15:30 | 2026-08-31 15:30 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 15.8700 | 15.7000 | 16.1000 | 947.2700 | 317380.00 | 28728.00 | 288652.00 | 200 | 5 | 4180 | 211 | 19.8104265402844 | 0.526002414218896 | 0.526002414218896 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 02aa36d6-d347-4ba9-bd9b-ba58864f8a06 | 2026-09-02 09:41 | 2026-09-02 09:41 | 2026-09-02 09:41 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 12.0000 | 11.6500 | 12.1500 | 951.8000 | 122400.00 | 122400.00 | 0.00 | 102 | 6 | 3805 | 1558 | 2.44223363286264 | 0.828568504596613 | 0.801136710908163 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 05319d05-bb1d-40f2-9f09-6afa02983226 | 2026-09-02 11:59 | 2026-09-02 11:59 | 2026-09-02 11:59 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 4.8000 | 4.5500 | 4.8000 | 945.1297 | 292320.00 | 292320.00 | 0.00 | 609 | 5 | 23407 | 1558 | 15.0237483953787 | 0.585937168621495 | 0.585937168621495 | false | false | false | true | ||||||||||||||||
| 82e99f0d-d41c-47e6-8322-0dbc0cfee19b | 2026-09-02 11:59 | 2026-09-02 11:59 | 2026-09-02 11:59 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 4.8000 | 4.5000 | 4.8500 | 945.0700 | 240359.00 | 237959.00 | 2400.00 | 501 | 42 | 24119 | 1558 | 15.4807445442875 | 0.598669331063118 | 0.590239626184381 | true | false | false | true | ||||||||||||||||
| 320d9feb-7920-4a37-b9e5-52eeadc376dc | 2026-09-02 12:00 | 2026-09-02 12:00 | 2026-09-02 12:00 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 5.4000 | 5.1500 | 5.4500 | 946.1400 | 269982.00 | 241902.00 | 28080.00 | 500 | 21 | 24806 | 1558 | 15.9216944801027 | 0.596314895813768 | 0.596335741444265 | true | false | false | true | ||||||||||||||||
| 683b661f-1222-4a89-bb03-d4d4169192a7 | 2026-09-02 12:01 | 2026-09-02 12:01 | 2026-09-02 12:01 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 5.3800 | 5.0000 | 5.4000 | 945.4800 | 269531.00 | 259268.00 | 10263.00 | 501 | 38 | 25381 | 1558 | 16.290757381258 | 0.652492496260321 | 0.640939818938041 | true | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 96f75065-dc90-4142-95cb-afdc5ec7bd9f | 2026-09-02 13:49 | 2026-09-02 13:49 | 2026-09-02 13:49 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 6.0000 | 5.8000 | 6.3250 | 948.7000 | 124201.00 | 0.00 | 113401.00 | 207 | 13 | 34636 | 1558 | 22.2310654685494 | 0.630124229731308 | 0.649185572598687 | true | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| aec1c9bf-64d3-4495-812a-bb5467fd4be4 | 2026-09-02 14:09 | 2026-09-02 14:09 | 2026-09-02 14:09 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 4.3500 | 4.1500 | 4.5000 | 946.8799 | 131058.00 | 124843.00 | 6215.00 | 301 | 22 | 38145 | 1558 | 24.4833119383825 | 0.607761594243364 | 0.626522978081607 | true | false | false | true | ||||||||||||||||
| 39f2df94-8297-47ec-9cac-da10388cf368 | 2026-09-02 14:57 | 2026-09-02 14:57 | 2026-09-02 14:57 | MU | MU260902C00945000 | call | 945.0000 | 2026-09-02 | 10.0000 | 9.6000 | 10.0000 | 954.2500 | 367000.00 | 367000.00 | 0.00 | 367 | 5 | 42356 | 1558 | 27.186136071887 | 0.881391745487804 | 0.881391745487804 | 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-31T19:31:33.694739Z"} |
| 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-31T19:31:33.694739Z"} |
| 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-08-31T19:31:33.694739Z"} |
| 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 |
| 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 |
| 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-02T13:42:51.501101Z"} |
| 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-02T15:49:54.253343Z"} |
| 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-02T16:19:14.278097Z"} |
| 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-02T16:19:14.278097Z"} |
| 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-02T16:19:14.278097Z"} |
| 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-02T16:19:14.278097Z"} |
| 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-02T16:56:20.498446Z"} |
| 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-02T16:56:20.498446Z"} |
| 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-02T18:05:44.095975Z"} |
| 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-02T18:39:55.300995Z"} |
| 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 |
| 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-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |