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_alerts566,287 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 |
|---|
| dba8bce5-9bcb-4185-b66f-6dc85247c376 | 2026-09-15 15:32 | 2026-09-15 15:32 | 2026-09-15 15:32 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.3100 | 4.3000 | 4.4500 | 68.4900 | 40519.00 | 3969.00 | 36550.00 | 94 | 14 | 2482 | 4734 | 0.524292353189692 | 0.923629352078095 | 0.867324595392304 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 10911072057.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 3d84c8a6-e0bf-460c-9fb8-441860c36d96 | 2026-09-15 15:30 | 2026-09-15 15:29 | 2026-09-15 15:29 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.3000 | 4.2000 | 4.3000 | 68.3300 | 10320.00 | 1290.00 | 0.00 | 24 | 15 | 2380 | 4734 | 0.502746092099704 | 0.928137341071757 | 0.928137341071757 | false | false | false | true | false | |||||||||||||||
| 2c197b3c-921e-434b-a3bd-5d036d6f7e65 | 2026-09-15 15:00 | 2026-09-15 15:00 | 2026-09-15 15:00 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.2500 | 4.0000 | 4.2500 | 68.2300 | 10625.00 | 10625.00 | 0.00 | 25 | 21 | 2222 | 4734 | 0.469370511195606 | 0.939718354268817 | 0.939718354268817 | false | false | false | true | false | |||||||||||||||
| 944fda35-2c33-49f8-8e61-fd1ce837387b | 2026-09-15 15:00 | 2026-09-15 14:59 | 2026-09-15 14:59 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.2500 | 4.0000 | 4.2500 | 68.3100 | 11900.00 | 11900.00 | 0.00 | 28 | 22 | 2150 | 4734 | 0.454161385720321 | 0.910617723344577 | 0.910617723344577 | false | false | false | true | false | |||||||||||||||
| 3bc71ce7-5de3-41d5-8fde-166ba6b45e52 | 2026-09-15 15:00 | 2026-09-15 15:00 | 2026-09-15 15:00 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.3000 | 4.1500 | 4.3000 | 68.3150 | 10320.00 | 10320.00 | 0.00 | 24 | 21 | 2174 | 4734 | 0.459231094212083 | 0.933622834026128 | 0.933622834026128 | false | false | false | true | false | |||||||||||||||
| 651f0b8b-929f-4872-9eb3-6873e51b34ba | 2026-09-15 15:00 | 2026-09-15 14:59 | 2026-09-15 14:59 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.2500 | 3.8000 | 4.3500 | 68.2650 | 10200.00 | 5525.00 | 0.00 | 24 | 17 | 2122 | 4734 | 0.448246725813266 | 0.927102362136865 | 0.927102362136865 | false | false | false | true | false | |||||||||||||||
| 8e3a0e1a-12dd-4daf-8cfe-e27f040de2a3 | 2026-09-15 14:59 | 2026-09-15 14:59 | 2026-09-15 14:59 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 4.2500 | 3.7500 | 4.2500 | 68.3000 | 11475.00 | 11475.00 | 0.00 | 27 | 22 | 2098 | 4734 | 0.443177017321504 | 0.914307674172945 | 0.914307674172945 | false | false | false | true | false | |||||||||||||||
| 77ec8c0a-a3d5-447d-9daa-8f2e7a9bd079 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 2.2400 | 2.0500 | 2.2400 | 65.1500 | 63168.00 | 63168.00 | 0.00 | 282 | 21 | 1298 | 4734 | 0.27418673426278 | 0.935480994590191 | 0.915335994108106 | false | false | false | true | false | |||||||||||||||
| 2d87ac93-1968-4397-a949-53174456d320 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 2.2200 | 2.0500 | 2.2200 | 65.0199 | 12432.00 | 12432.00 | 0.00 | 56 | 11 | 1016 | 4734 | 0.21461765948458 | 0.935866289980471 | 0.935866289980471 | false | false | false | true | false | |||||||||||||||
| 05e8299e-fb5d-45a7-a82b-4a2feb158544 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 2.2800 | 2.2500 | 2.4100 | 65.1800 | 10494.00 | 694.00 | 9800.00 | 46 | 24 | 842 | 4734 | 0.177862272919307 | 0.936202182931711 | 0.917077145033257 | false | false | false | true | false | |||||||||||||||
| a9512f0f-7417-41dd-888d-956c339ddb42 | 2026-09-14 12:48 | 2026-09-14 12:48 | 2026-09-14 12:48 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 0.9000 | 0.8500 | 0.9000 | 61.6700 | 42030.00 | 42030.00 | 0.00 | 467 | 5 | 810 | 4404 | 0.183923705722071 | 0.817827692453616 | 0.817827692453616 | true | false | false | true | false | |||||||||||||||
| 18f10281-adfc-4a38-9419-a55445a40287 | 2026-09-09 09:32 | 2026-09-09 09:32 | 2026-09-09 09:32 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 2.2500 | 2.2500 | 2.6700 | 62.5500 | 33750.00 | 0.00 | 33750.00 | 150 | 6 | 151 | 4214 | 0.0358329378262933 | 0.829112776642251 | 0.829112776642251 | false | false | false | true | false | |||||||||||||||
| 40c7ab07-6faf-45f5-a492-90669e46bf7b | 2026-09-08 09:55 | 2026-09-08 09:54 | 2026-09-08 09:54 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 3.5000 | 3.1500 | 3.5000 | 64.9350 | 17150.00 | 17150.00 | 0.00 | 49 | 8 | 204 | 4228 | 0.0482497634815516 | 0.816604437001766 | 0.816604437001766 | true | false | false | true | false | |||||||||||||||
| 3695ea46-5902-4a09-83fa-de68c6e582c5 | 2026-08-21 13:15 | 2026-08-21 13:15 | 2026-08-21 13:15 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 10.2300 | 9.9000 | 10.5000 | 72.0400 | 17396.00 | 17396.00 | 0.00 | 17 | 6 | 155 | 4378 | 0.035404294198264 | 0.786243617658174 | 0.786243617658174 | false | false | false | true | false | |||||||||||||||
| a7f10e8d-2bd1-46bc-af14-b385f528b581 | 2026-08-21 09:31 | 2026-08-21 09:31 | 2026-08-21 09:31 | TEM | TEM260918C00065000 | call | 65.0000 | 2026-09-18 | 7.5000 | 6.4500 | 8.0500 | 68.1100 | 21750.00 | 10500.00 | 3750.00 | 29 | 7 | 29 | 4378 | 0.00662402923709456 | 0.777727894113106 | 0.777727894113106 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |