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 | expirydate |
|---|
| 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 |
|---|
| 167d981f-aa63-4c0f-a0d3-64c19d22531a | 2026-08-25 15:50 | 2026-08-25 15:50 | 2026-08-25 15:50 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 30.6500 | 30.6000 | 30.6500 | 490.7100 | 196160.00 | 196160.00 | 0.00 | 64 | 5 | 394 | 10814 | 0.0364342518956908 | 0.291482405720698 | 0.291482405720698 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3752944946606.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc81cbfa-30d7-4293-bbbc-865d6e0c448f | 2026-08-25 15:52 | 2026-08-25 15:52 | 2026-08-25 15:52 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 30.6500 | 30.6500 | 30.8500 | 490.9500 | 275850.00 | 0.00 | 275850.00 | 90 | 5 | 1680 | 10814 | 0.155354170519697 | 0.290529396927265 | 0.290529396927265 | false | false | false | true | ||||||||||||||||
| 500ad42f-64b7-487e-b5cd-80432b0a58cc | 2026-09-18 10:04 | 2026-09-18 10:04 | 2026-09-18 10:04 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.9000 | 26.7500 | 27.9000 | 492.9000 | 285190.00 | 142895.00 | 142295.00 | 106 | 7 | 145 | 12988 | 0.0111641515244841 | 0.2793361100003 | 0.280227749886602 | false | false | false | true | ||||||||||||||||
| 179a154a-aaad-4b56-86d7-67492896d97d | 2026-09-18 10:04 | 2026-09-18 10:04 | 2026-09-18 10:04 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.8600 | 26.8500 | 27.2000 | 493.1100 | 225610.00 | 10800.00 | 214810.00 | 84 | 17 | 229 | 12988 | 0.0176316599938405 | 0.280167946867184 | 0.280217239421445 | false | false | false | true | ||||||||||||||||
| eeb7a52c-43ea-430e-a718-19d4467c263e | 2026-09-18 10:04 | 2026-09-18 10:04 | 2026-09-18 10:04 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.9500 | 26.9000 | 27.5000 | 493.1300 | 253325.00 | 121515.00 | 131810.00 | 94 | 8 | 335 | 12988 | 0.0257930397289806 | 0.278407912399455 | 0.279240161884501 | false | false | false | true | ||||||||||||||||
| 37033433-73e9-4e05-bc82-a6b8c1f4b0b4 | 2026-09-18 10:10 | 2026-09-18 10:10 | 2026-09-18 10:10 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.8500 | 26.8500 | 27.1000 | 493.0900 | 153065.00 | 5380.00 | 147685.00 | 57 | 11 | 739 | 12988 | 0.0568986757006468 | 0.278966397688896 | 0.278520783724912 | false | false | false | true | ||||||||||||||||
| ab5c4463-5a5d-4384-bcca-c9d1cb816ec6 | 2026-09-18 10:12 | 2026-09-18 10:12 | 2026-09-18 10:12 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.7000 | 26.6000 | 27.0000 | 492.8100 | 144180.00 | 0.00 | 144180.00 | 54 | 5 | 898 | 12988 | 0.0691407453033569 | 0.278384211058191 | 0.278384211058191 | false | false | false | true | ||||||||||||||||
| c0e91a62-ee72-4a40-b7e8-997344ae339f | 2026-09-18 10:17 | 2026-09-18 10:17 | 2026-09-18 10:17 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.2500 | 26.2500 | 26.8000 | 491.8150 | 112875.00 | 0.00 | 112875.00 | 43 | 7 | 942 | 12988 | 0.0725284878349245 | 0.278879545432647 | 0.278610954597006 | false | false | false | true | ||||||||||||||||
| 6ca8c54d-6d67-457e-a77f-99b2e3bea1de | 2026-09-18 10:17 | 2026-09-18 10:17 | 2026-09-18 10:17 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.2500 | 26.2000 | 26.6000 | 491.8800 | 165376.00 | 2625.00 | 162751.00 | 63 | 9 | 1011 | 12988 | 0.0778410840776101 | 0.278334620769322 | 0.278334620769322 | false | false | false | true | ||||||||||||||||
| 6907ed58-9ac3-4125-9e94-adc0d29c36c5 | 2026-09-22 11:06 | 2026-09-22 11:06 | 2026-09-22 11:06 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 28.7500 | 28.1500 | 28.9500 | 496.0000 | 28750.00 | 5750.00 | 23000.00 | 10 | 5 | 170 | 13758 | 0.0123564471580172 | 0.28670439061066 | 0.28670439061066 | false | false | false | true | ||||||||||||||||
| 1ccc5edc-edf8-4cdf-8146-e096287e5e4e | 2026-09-24 09:43 | 2026-09-24 09:43 | 2026-09-24 09:43 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 26.8000 | 26.7500 | 27.5000 | 493.1800 | 42880.00 | 29480.00 | 13400.00 | 16 | 6 | 20 | 13856 | 0.00144341801385681 | 0.285887695005269 | 0.285887695005269 | false | false | false | true | ||||||||||||||||
| e5bf7211-18fa-4e66-a42c-2f4fe5f50140 | 2026-09-24 12:02 | 2026-09-24 12:02 | 2026-09-24 12:02 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 27.4000 | 27.4000 | 27.6000 | 494.9300 | 449365.00 | 2745.00 | 446620.00 | 164 | 40 | 235 | 13856 | 0.0169601616628176 | 0.283080609218884 | 0.283615446953963 | false | false | false | true | ||||||||||||||||
| 127c2ea8-8b7f-4d99-b697-f4aac5a8aa8e | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 37.7000 | 37.0000 | 37.7000 | 513.3107 | 131950.00 | 128180.00 | 0.00 | 35 | 19 | 368 | 13950 | 0.0263799283154122 | 0.289257831354867 | 0.28904519850033 | false | false | false | true | ||||||||||||||||
| b69ac81a-d156-431c-9a2d-afcdbf5330de | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 37.7000 | 37.0500 | 37.7000 | 513.3400 | 60320.00 | 60320.00 | 0.00 | 16 | 7 | 384 | 13950 | 0.0275268817204301 | 0.289257831354867 | 0.288892073367736 | false | false | false | true | ||||||||||||||||
| 0b9c7e78-5157-45d2-b83d-b2df2adfd0de | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 37.5000 | 37.0500 | 37.8000 | 513.3101 | 187500.00 | 48750.00 | 7500.00 | 50 | 18 | 434 | 13950 | 0.0311111111111111 | 0.287248314320071 | 0.287248314320071 | false | false | false | true | ||||||||||||||||
| 36b01a38-d128-48a5-a67f-ccd4ce399444 | 2026-09-25 10:25 | 2026-09-25 10:25 | 2026-09-25 10:25 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 37.6000 | 37.5000 | 37.9000 | 513.5700 | 379760.00 | 308320.00 | 45120.00 | 101 | 26 | 535 | 13950 | 0.0383512544802867 | 0.287050309123927 | 0.28678842535066 | false | false | false | true | ||||||||||||||||
| b2461496-36d9-4a8c-90f3-05b5d679ca27 | 2026-09-25 10:26 | 2026-09-25 10:25 | 2026-09-25 10:25 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 37.8000 | 37.5500 | 37.8000 | 513.5900 | 223020.00 | 223020.00 | 0.00 | 59 | 16 | 594 | 13950 | 0.0425806451612903 | 0.288483971694394 | 0.288483971694394 | false | false | false | true | ||||||||||||||||
| 0ee9785e-d15c-467b-b34b-07464973df33 | 2026-09-25 13:58 | 2026-09-25 13:58 | 2026-09-25 13:58 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 40.1500 | 39.9500 | 40.4500 | 517.2901 | 36135.00 | 0.00 | 36135.00 | 9 | 9 | 1012 | 13950 | 0.0725448028673835 | 0.289832361678998 | 0.289967095369353 | false | false | false | true | ||||||||||||||||
| b380e8d3-b048-4e06-b5ec-1750aa780bc0 | 2026-09-25 13:59 | 2026-09-25 13:59 | 2026-09-25 13:59 | MSFT | MSFT270115C00510000 | call | 510.0000 | 2027-01-15 | 40.7000 | 40.3500 | 40.7000 | 518.0700 | 20350.00 | 20350.00 | 0.00 | 5 | 5 | 1028 | 13950 | 0.0736917562724014 | 0.290891766369142 | 0.290701169703123 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3666585852546.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T16:07:29.919397Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |