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 | 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 |
|---|
| 25df5f6f-844a-4d4e-a12c-fd0a8afbdca0 | 2026-09-02 13:21 | 2026-09-02 13:21 | 2026-09-02 13:21 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 1.9400 | 1.8000 | 1.9400 | 945.2209 | 103208.00 | 103208.00 | 0.00 | 532 | 50 | 28175 | 1725 | 16.3333333333333 | 0.620868620833665 | 0.615674370451778 | false | 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-09-02T17:36:40.694178Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 46a94bd0-8fb8-41e2-8239-8e36e8488e6e | 2026-09-02 11:51 | 2026-09-02 11:50 | 2026-09-02 11:51 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 4.5000 | 4.3000 | 4.5000 | 940.8400 | 200245.00 | 199800.00 | 445.00 | 445 | 18 | 17839 | 1725 | 10.3414492753623 | 0.602089645425551 | 0.602109728444871 | true | false | false | true | ||||||||||||||||
| 965ba471-7315-42d4-bdaf-e59b79fab8fc | 2026-09-02 11:50 | 2026-09-02 11:49 | 2026-09-02 11:49 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 4.7600 | 4.6500 | 4.8500 | 940.0600 | 224368.00 | 112303.00 | 112065.00 | 471 | 32 | 17309 | 1725 | 10.0342028985507 | 0.587141346342142 | 0.591535943383098 | true | false | false | true | ||||||||||||||||
| 404323b8-4e32-4661-b6b1-265953a572ed | 2026-09-02 11:37 | 2026-09-02 11:37 | 2026-09-02 11:37 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 3.4000 | 3.1500 | 3.4000 | 943.0200 | 123760.00 | 123760.00 | 0.00 | 364 | 23 | 15493 | 1725 | 8.98144927536232 | 0.584772454243031 | 0.567331030950209 | false | false | false | true | ||||||||||||||||
| fbfa739c-51d1-41e2-b991-681d0c51a4bf | 2026-09-02 11:23 | 2026-09-02 11:23 | 2026-09-02 11:23 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 4.8500 | 4.8500 | 5.0500 | 940.4050 | 242016.00 | 0.00 | 242016.00 | 499 | 17 | 14014 | 1725 | 8.12405797101449 | 0.578870382562227 | 0.588028400284078 | true | false | false | true | ||||||||||||||||
| efb8db4f-f066-4fcb-8584-4c3e08f03c56 | 2026-09-02 11:22 | 2026-09-02 11:21 | 2026-09-02 11:21 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 4.2000 | 3.9500 | 4.2000 | 942.1300 | 193504.00 | 187694.00 | 3735.00 | 461 | 28 | 13352 | 1725 | 7.74028985507246 | 0.601109449292562 | 0.596761330485495 | true | false | false | true | ||||||||||||||||
| 05e60582-11d2-421a-8eba-876860333498 | 2026-09-02 11:03 | 2026-09-02 11:03 | 2026-09-02 11:03 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 6.7000 | 6.6500 | 6.7500 | 938.2200 | 113840.00 | 34840.00 | 53540.00 | 170 | 10 | 11774 | 1725 | 6.82550724637681 | 0.648847821329396 | 0.643190574859281 | false | false | false | true | ||||||||||||||||
| ea1fa85d-d11b-47c7-9a39-916ac0f6be42 | 2026-09-02 10:54 | 2026-09-02 10:54 | 2026-09-02 10:54 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 7.5700 | 7.3500 | 7.7500 | 937.0300 | 189348.00 | 171315.00 | 18033.00 | 250 | 6 | 11026 | 1725 | 6.39188405797101 | 0.656435977745311 | 0.671108717316576 | false | false | false | true | ||||||||||||||||
| 90e85c68-dd94-4402-95de-4296645f9879 | 2026-09-01 13:47 | 2026-09-01 13:47 | 2026-09-01 13:47 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 12.6500 | 12.1500 | 12.7000 | 936.5000 | 1037238.00 | 1033468.00 | 2510.00 | 820 | 66 | 19627 | 1923 | 10.2064482579303 | 0.570253897899919 | 0.557178992697034 | true | false | false | true | ||||||||||||||||
| 630300f7-6514-462e-b3a7-464c5f8bad67 | 2026-09-01 13:34 | 2026-09-01 13:34 | 2026-09-01 13:34 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 10.4000 | 10.3500 | 10.8000 | 940.4300 | 520241.00 | 0.00 | 520241.00 | 500 | 20 | 18423 | 1923 | 9.58034321372855 | 0.539903221230991 | 0.547207768874655 | true | false | false | true | ||||||||||||||||
| 7220791b-c98e-4d1e-87a0-3a596f36afc3 | 2026-09-01 12:04 | 2026-09-01 12:04 | 2026-09-01 12:04 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 4.7000 | 4.6000 | 4.7500 | 957.6400 | 210090.00 | 210090.00 | 0.00 | 447 | 5 | 10622 | 1923 | 5.52366094643786 | 0.577952719920123 | 0.577952719920123 | false | false | false | true | ||||||||||||||||
| b3cde075-2c0c-4c7b-bf68-cc90a62f031d | 2026-08-31 15:32 | 2026-08-31 15:31 | 2026-08-31 15:31 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 12.1500 | 12.1000 | 12.5000 | 945.0950 | 489624.00 | 0.00 | 489624.00 | 403 | 10 | 6447 | 110 | 58.6090909090909 | 0.525853433615946 | 0.528032149559075 | false | false | false | true | ||||||||||||||||
| fabebb66-52fd-4b97-8537-2a09138c0391 | 2026-08-31 14:48 | 2026-08-31 14:48 | 2026-08-31 14:48 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 12.8500 | 12.5500 | 12.9000 | 943.1648 | 562770.00 | 23080.00 | 537130.00 | 438 | 7 | 4650 | 110 | 42.2727272727273 | 0.51864319437671 | 0.520449671298545 | true | false | false | true | ||||||||||||||||
| df5fdd7c-5e08-4194-a124-990ccb9d8462 | 2026-08-31 11:19 | 2026-08-31 11:19 | 2026-08-31 11:19 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 14.5500 | 14.5500 | 15.3500 | 940.3000 | 1110197.00 | 0.00 | 1110197.00 | 763 | 38 | 3060 | 110 | 27.8181818181818 | 0.52327827602889 | 0.533074502185684 | false | false | false | true | ||||||||||||||||
| 9a80f3ed-e815-4f48-a88e-f17750f85c09 | 2026-08-31 10:15 | 2026-08-31 10:15 | 2026-08-31 10:15 | MU | MU260902P00940000 | put | 940.0000 | 2026-09-02 | 16.3000 | 16.3000 | 16.8500 | 939.7550 | 875336.00 | 0.00 | 875336.00 | 537 | 50 | 1417 | 110 | 12.8818181818182 | 0.586526341439648 | 0.586526341439648 | false | false | false | true |
| 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 |
| 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: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-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-02T15:25:17.297093Z"} |
| 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-02T15:25:17.297093Z"} |
| 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-02T15:04:15.415728Z"} |
| 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-02T15:04:15.415728Z"} |
| 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-01T17:48:11.364966Z"} |
| 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-01T17:48:11.364966Z"} |
| 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 |
| 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-08-31T19:01:22.528333Z"} |
| 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-31T15:33:38.203445Z"} |
| 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:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |