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 |
|---|
| 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 |
|---|
| 9e4d707e-1f00-404f-a99d-441b6f8a835b | 2026-09-25 14:39 | 2026-09-25 14:39 | 2026-09-25 14:39 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 14.7000 | 14.7000 | 15.0000 | 517.6400 | 16170.00 | 0.00 | 16170.00 | 11 | 6 | 2559 | 4666 | 0.548435490784398 | 0.257281068465596 | 0.257281068465596 | false | false | false | true | false | 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:46:04.686299Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b425bb1d-a2d4-4a61-b558-7f73281400ac | 2026-09-25 12:23 | 2026-09-25 12:23 | 2026-09-25 12:23 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 12.9100 | 12.8500 | 13.3000 | 514.4800 | 16780.00 | 7760.00 | 9020.00 | 13 | 7 | 2198 | 4666 | 0.471067295327904 | 0.253804512015966 | 0.255404296024463 | false | false | false | true | ||||||||||||||||
| f893f9a5-4993-455f-b45b-3e9a17b3d51e | 2026-09-25 11:46 | 2026-09-25 11:46 | 2026-09-25 11:46 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 12.5000 | 12.3500 | 12.6500 | 513.6400 | 20000.00 | 18750.00 | 0.00 | 16 | 9 | 2114 | 4666 | 0.453064723531933 | 0.256073619277627 | 0.256073619277627 | false | false | false | true | ||||||||||||||||
| a4050f1a-d2d1-4924-b8cd-8bc9490ad03f | 2026-09-25 11:46 | 2026-09-25 11:46 | 2026-09-25 11:46 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 12.5000 | 12.3500 | 12.5000 | 513.5000 | 72500.00 | 72500.00 | 0.00 | 58 | 18 | 2098 | 4666 | 0.449635662237462 | 0.257524652127922 | 0.257524652127922 | false | false | false | true | ||||||||||||||||
| 8680d530-4a37-44bc-83b3-e016889ba9b9 | 2026-09-25 11:46 | 2026-09-25 11:46 | 2026-09-25 11:46 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 12.4500 | 12.3500 | 12.4500 | 513.5050 | 125745.00 | 36105.00 | 0.00 | 101 | 21 | 2013 | 4666 | 0.431418774110587 | 0.256455139804959 | 0.256455139804959 | false | false | false | true | ||||||||||||||||
| c2b9d1e5-724d-40b0-9af5-8b08751ca1d6 | 2026-09-25 11:33 | 2026-09-25 11:33 | 2026-09-25 11:33 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 13.2500 | 13.2000 | 13.6000 | 514.0000 | 29150.00 | 7950.00 | 21200.00 | 22 | 6 | 1858 | 4666 | 0.398199742820403 | 0.258052604739967 | 0.258052604739967 | false | false | false | true | ||||||||||||||||
| 94e16d98-c98b-48d4-87be-2c58018c0f14 | 2026-09-25 10:30 | 2026-09-25 10:30 | 2026-09-25 10:30 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 13.0500 | 12.6500 | 13.0500 | 514.3100 | 65250.00 | 65250.00 | 0.00 | 50 | 11 | 1577 | 4666 | 0.337976853836262 | 0.260252143368052 | 0.260252143368052 | false | false | false | true | ||||||||||||||||
| 74c5f20a-42be-4adc-8d09-e2c2d4f85da6 | 2026-09-25 09:46 | 2026-09-25 09:46 | 2026-09-25 09:46 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 13.5000 | 13.2500 | 13.5000 | 515.3900 | 21600.00 | 21600.00 | 0.00 | 16 | 13 | 1084 | 4666 | 0.232318902700386 | 0.257865204298612 | 0.257865204298612 | true | false | false | true | ||||||||||||||||
| 7a5bb12b-7eb0-4f56-8059-187e959f2381 | 2026-09-23 14:40 | 2026-09-23 14:40 | 2026-09-23 14:40 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 7.1000 | 7.0000 | 7.2000 | 500.0500 | 43310.00 | 29110.00 | 14200.00 | 61 | 7 | 3611 | 3981 | 0.907058528008038 | 0.251963391138052 | 0.251963391138052 | false | false | false | true | ||||||||||||||||
| 0bc34fed-0f00-4927-8da0-44c4e07ebd38 | 2026-09-23 13:02 | 2026-09-23 13:02 | 2026-09-23 13:02 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 6.9500 | 6.9000 | 7.2000 | 499.4750 | 13900.00 | 695.00 | 6255.00 | 20 | 7 | 3445 | 3981 | 0.865360462195428 | 0.25299391620255 | 0.25299391620255 | false | false | false | true | false | |||||||||||||||
| 9a9866d1-6fa3-4549-aa69-c916dc47f592 | 2026-09-23 10:19 | 2026-09-23 10:19 | 2026-09-23 10:19 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 6.4000 | 6.2000 | 6.4000 | 497.0000 | 82560.00 | 82560.00 | 0.00 | 129 | 16 | 1169 | 3981 | 0.29364481286109 | 0.255314827513552 | 0.255314827513552 | false | false | false | true | ||||||||||||||||
| a2001db3-e5cd-4579-858f-7393d7b5eb3f | 2026-09-22 15:19 | 2026-09-22 15:19 | 2026-09-22 15:19 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 6.4000 | 6.3500 | 6.4500 | 498.3500 | 74880.00 | 19840.00 | 28800.00 | 117 | 8 | 953 | 3775 | 0.252450331125828 | 0.243541864427664 | 0.243541864427664 | false | false | false | true | ||||||||||||||||
| 72ec1f0f-23a2-4ab1-8aa6-4a82311d5e24 | 2026-09-22 10:08 | 2026-09-22 10:08 | 2026-09-22 10:08 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 6.4100 | 6.4000 | 6.6000 | 497.3200 | 99283.00 | 0.00 | 99283.00 | 155 | 27 | 311 | 3775 | 0.0823841059602649 | 0.250788544035082 | 0.250788544035082 | true | false | false | true | ||||||||||||||||
| faa6c1f4-1f2a-4665-b101-3bf45c8bdeb7 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 8.5000 | 8.4500 | 9.0500 | 502.4800 | 34005.00 | 1705.00 | 32300.00 | 40 | 21 | 78 | 3775 | 0.0206622516556291 | 0.256954128538388 | 0.256954128538388 | true | false | false | true | ||||||||||||||||
| 126b56fd-6301-4de1-b426-0c3f3ddc7c4a | 2026-09-21 15:44 | 2026-09-21 15:44 | 2026-09-21 15:44 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 7.4000 | 7.4000 | 7.6500 | 499.7300 | 20720.00 | 0.00 | 20720.00 | 28 | 6 | 705 | 3625 | 0.19448275862069 | 0.249431523759175 | 0.249431523759175 | false | false | false | true | false | |||||||||||||||
| 25447018-d6af-45e2-b30e-6fa0220445dc | 2026-09-21 12:48 | 2026-09-21 12:48 | 2026-09-21 12:48 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 6.0000 | 6.0000 | 6.1500 | 496.4101 | 35400.00 | 0.00 | 35400.00 | 59 | 15 | 464 | 3625 | 0.128 | 0.24224352834891 | 0.242848671189909 | true | false | false | true | false | |||||||||||||||
| e4ba77a6-ff7c-467c-ba66-7ea7d4d1411a | 2026-09-18 11:41 | 2026-09-18 11:41 | 2026-09-18 11:41 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 5.3000 | 5.1000 | 5.3000 | 493.8700 | 533150.00 | 533150.00 | 0.00 | 1006 | 66 | 1131 | 2951 | 0.383259911894273 | 0.230473202553528 | 0.229498732258872 | false | false | false | true | ||||||||||||||||
| e8d09f2c-3d4c-4f82-8356-0c9870c6b3dd | 2026-09-03 09:30 | 2026-09-03 09:30 | 2026-09-03 09:30 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 12.8300 | 11.9000 | 13.1500 | 503.0950 | 118070.00 | 59105.00 | 58965.00 | 92 | 8 | 93 | 2134 | 0.0435801312089972 | 0.247345620243986 | 0.248083418547273 | true | false | false | true | ||||||||||||||||
| 1788868d-f156-4db3-9784-e540f7e4a41e | 2026-08-27 15:19 | 2026-08-27 15:19 | 2026-08-27 15:19 | MSFT | MSFT261016C00515000 | call | 515.0000 | 2026-10-16 | 16.3500 | 16.2500 | 16.6000 | 505.0000 | 138975.00 | 45780.00 | 93195.00 | 85 | 7 | 369 | 1790 | 0.206145251396648 | 0.262283524513449 | 0.262283524513449 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:27:03.681802Z"} |
| 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-25T15:51:49.898119Z"} |
| 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-25T15:51:49.898119Z"} |
| 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-25T15:46:29.692189Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:34:39.698780Z"} |
| 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:33:57.900979Z"} |
| 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-25T13:47:32.064714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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:40:32.778143Z"} |
| 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-23T17:03:13.598333Z"} |
| 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-23T14:19:47.877581Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T14:10:05.607073Z"} |
| 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:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:51:16.040164Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3752944946606.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |