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 |
|---|
| 85e9dab9-00fe-4485-8278-8bac9ecb1807 | 2026-09-21 14:19 | 2026-09-21 14:19 | 2026-09-21 14:19 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 5.1500 | 4.9500 | 5.1500 | 497.7801 | 312090.00 | 312090.00 | 0.00 | 606 | 51 | 786 | 257 | 3.05836575875486 | 0.277936259895573 | 0.271961153218846 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3724727873741.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 350a0472-0dd0-4442-848b-cd57836d26cb | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 1.8300 | 1.5000 | 1.9100 | 506.1062 | 11167.00 | 10252.00 | 360.00 | 61 | 14 | 97 | 986 | 0.0983772819472617 | 0.397711668458109 | 0.402230741664913 | true | false | false | true | ||||||||||||||||
| 01ce625c-5e6c-4276-9055-c1d0aef680db | 2026-09-22 09:47 | 2026-09-22 09:47 | 2026-09-22 09:47 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 4.7900 | 4.7000 | 5.0000 | 497.8400 | 10050.00 | 480.00 | 9570.00 | 21 | 11 | 1267 | 986 | 1.28498985801217 | 0.350457308919847 | 0.340592751551748 | true | false | false | true | ||||||||||||||||
| 2071394e-df1e-447e-9587-5dec47a74fc0 | 2026-09-22 09:47 | 2026-09-22 09:47 | 2026-09-22 09:47 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 4.5000 | 4.5000 | 4.7000 | 498.3000 | 14400.00 | 0.00 | 14400.00 | 32 | 5 | 1307 | 986 | 1.32555780933063 | 0.347111171098524 | 0.347111171098524 | true | false | false | true | ||||||||||||||||
| 4486bc71-cd9b-41fd-9c36-63c65f1f95f4 | 2026-09-22 11:14 | 2026-09-22 11:14 | 2026-09-22 11:14 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 6.2000 | 5.9500 | 6.6500 | 495.0800 | 183520.00 | 0.00 | 183520.00 | 296 | 33 | 2158 | 986 | 2.18864097363083 | 0.298566760984475 | 0.30753835163947 | false | false | false | true | ||||||||||||||||
| 4f9a97bb-9f34-49ce-8ee8-72f3e7928571 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 1.1600 | 1.1100 | 1.2700 | 503.0000 | 35063.00 | 15607.00 | 19456.00 | 303 | 29 | 3651 | 906 | 4.02980132450331 | 0.474744416586585 | 0.480679564938846 | true | false | false | true | ||||||||||||||||
| b12bf756-ffd1-4cc1-b40c-bced5d9be3cb | 2026-09-23 10:00 | 2026-09-23 10:00 | 2026-09-23 10:00 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 0.9400 | 0.8800 | 0.9500 | 503.7100 | 10810.00 | 10716.00 | 94.00 | 115 | 22 | 5301 | 906 | 5.85099337748344 | 0.448240308836454 | 0.448240308836454 | true | false | false | true | ||||||||||||||||
| d5e2886c-0cea-44a8-b1e8-6da9ba093684 | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 1.3000 | 1.3000 | 1.3800 | 502.3950 | 38740.00 | 0.00 | 38740.00 | 298 | 23 | 6160 | 906 | 6.79911699779249 | 0.441196574520915 | 0.44278232985327 | true | false | false | true | ||||||||||||||||
| bbd04119-abd3-4df0-8fb1-85b593673678 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 2.6400 | 2.5700 | 2.7400 | 499.2614 | 14544.00 | 10847.00 | 3438.00 | 55 | 7 | 8458 | 906 | 9.3355408388521 | 0.443255525679757 | 0.439333721582798 | true | false | false | true | ||||||||||||||||
| f6962428-1f8f-42f0-b9e7-0c3ad7c7e75a | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 4.0900 | 3.9500 | 4.1000 | 496.8300 | 17180.00 | 17180.00 | 0.00 | 42 | 6 | 9212 | 906 | 10.167770419426 | 0.457170592568228 | 0.429474838080001 | true | false | false | true | ||||||||||||||||
| b874e5f1-032a-4a8d-b0e1-cf07750cf6c4 | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 2.2900 | 2.2900 | 2.4200 | 499.1530 | 25191.00 | 0.00 | 25191.00 | 110 | 7 | 9937 | 906 | 10.9679911699779 | 0.382903686432443 | 0.385016301551442 | false | false | false | true | ||||||||||||||||
| 5242a7b2-10a0-4c02-ac02-fe94b2111b78 | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 2.1400 | 2.0300 | 2.3400 | 499.2550 | 26540.00 | 26106.00 | 434.00 | 124 | 23 | 10258 | 906 | 11.3222958057395 | 0.390873847097922 | 0.386104102251389 | true | false | false | true | ||||||||||||||||
| b91eb9a5-41a0-4bea-973b-13a035afdb3c | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 2.1000 | 1.9000 | 2.1000 | 499.2800 | 14910.00 | 14910.00 | 0.00 | 71 | 11 | 10401 | 906 | 11.4801324503311 | 0.3650027570237 | 0.3650027570237 | true | false | false | true | ||||||||||||||||
| 2fb9d1c7-c82c-4aff-8ec3-f022c377e09a | 2026-09-23 11:36 | 2026-09-23 11:36 | 2026-09-23 11:36 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 2.1500 | 2.1500 | 2.2400 | 498.9350 | 11180.00 | 0.00 | 11180.00 | 52 | 13 | 10967 | 906 | 12.1048565121413 | 0.35090118693817 | 0.35090118693817 | true | false | false | true | ||||||||||||||||
| 1830372e-9479-48bc-b8aa-747946a13b87 | 2026-09-23 14:08 | 2026-09-23 14:08 | 2026-09-23 14:08 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 1.5100 | 1.5100 | 1.6300 | 499.1900 | 59796.00 | 0.00 | 59796.00 | 396 | 53 | 13040 | 906 | 14.39293598234 | 0.333778482231129 | 0.365098909855595 | false | false | false | true | ||||||||||||||||
| 7f892637-11f2-4dce-a01e-ff3ad596cb41 | 2026-09-23 14:22 | 2026-09-23 14:22 | 2026-09-23 14:22 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 0.7800 | 0.7600 | 0.8200 | 500.0000 | 16360.00 | 0.00 | 16360.00 | 210 | 5 | 13488 | 906 | 14.887417218543 | 0.325460280245714 | 0.336879201540312 | false | false | false | true | ||||||||||||||||
| 7d37cf62-ebf7-4f68-b016-59aa879e53d9 | 2026-09-23 14:22 | 2026-09-23 14:22 | 2026-09-23 14:22 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 0.8200 | 0.7500 | 0.8200 | 500.0000 | 43705.00 | 43705.00 | 0.00 | 533 | 52 | 14021 | 906 | 15.4757174392936 | 0.353410466451911 | 0.345871138029902 | false | false | false | true | ||||||||||||||||
| 2b32696c-88e8-4e91-a88c-e6e853f9d6c2 | 2026-09-23 15:01 | 2026-09-23 15:01 | 2026-09-23 15:01 | MSFT | MSFT260923P00500000 | put | 500.0000 | 2026-09-23 | 0.5200 | 0.5200 | 0.5900 | 500.6399 | 24960.00 | 0.00 | 24960.00 | 480 | 7 | 15817 | 906 | 17.4580573951435 | 0.380160536371293 | 0.380160536371293 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:41:14.023510Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:27:32.623000Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:27:32.623000Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:05:07.702473Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |