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 |
|---|
| 500859ed-e249-4190-978c-76c90c545556 | 2026-09-10 09:52 | 2026-09-10 09:51 | 2026-09-10 09:51 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 2.3900 | 2.2300 | 2.6900 | 59.1900 | 14340.00 | 2151.00 | 12189.00 | 60 | 5 | 246 | 5116 | 0.0480844409695074 | 0.806246670524708 | 0.783053303996014 | false | false | false | true | false | 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-09-10T13:52:43.061304Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 68711c0f-fbc0-4f23-b0b9-759dabda0b32 | 2026-09-10 09:32 | 2026-09-10 09:32 | 2026-09-10 09:32 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 2.1800 | 2.0100 | 2.3800 | 58.3000 | 23154.00 | 0.00 | 21189.00 | 106 | 69 | 135 | 5116 | 0.0263878029710711 | 0.827929403933797 | 0.837139705988979 | true | false | false | true | ||||||||||||||||
| 9f9a5b09-568f-4cc9-a710-08efc79fa4fe | 2026-08-20 09:58 | 2026-08-20 09:58 | 2026-08-20 09:58 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 10.0000 | 9.5000 | 10.0000 | 67.1000 | 14000.00 | 14000.00 | 0.00 | 14 | 13 | 441 | 5775 | 0.0763636363636364 | 0.791033977971772 | 0.791033977971772 | false | false | false | true | ||||||||||||||||
| 45fb5681-4dd4-4a54-b3e8-8ea8ef364800 | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 8.0000 | 7.6500 | 8.0000 | 64.2860 | 13600.00 | 13600.00 | 0.00 | 17 | 5 | 189 | 5775 | 0.0327272727272727 | 0.787319359216819 | 0.787319359216819 | false | false | false | true | ||||||||||||||||
| 70526f2b-0ff7-48d5-a4b5-8403b3d5840e | 2026-08-19 13:31 | 2026-08-19 13:30 | 2026-08-19 13:30 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 4.9500 | 4.8500 | 4.9500 | 60.1150 | 56430.00 | 34155.00 | 0.00 | 114 | 5 | 3982 | 5600 | 0.711071428571429 | 0.700756496185055 | 0.700756496185055 | false | false | false | true | ||||||||||||||||
| 952eb0ca-4c3d-4c21-978f-945082f23ceb | 2026-08-19 10:50 | 2026-08-19 10:50 | 2026-08-19 10:50 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 4.5000 | 4.4500 | 4.5000 | 58.8699 | 16650.00 | 16650.00 | 0.00 | 37 | 14 | 2612 | 5600 | 0.466428571428571 | 0.73181124796332 | 0.73181124796332 | false | false | false | true | ||||||||||||||||
| e77e3211-b7ba-490e-96ec-df02d6d111ab | 2026-08-19 10:45 | 2026-08-19 10:45 | 2026-08-19 10:45 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 4.0000 | 3.8500 | 4.0500 | 57.8800 | 101605.00 | 101605.00 | 0.00 | 254 | 6 | 2406 | 5600 | 0.429642857142857 | 0.73363698627331 | 0.737940076666223 | false | false | false | true | ||||||||||||||||
| 22d76274-a694-4a86-8fcc-65bd1e2654c6 | 2026-08-19 10:37 | 2026-08-19 10:37 | 2026-08-19 10:37 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 3.8800 | 3.8000 | 3.9000 | 57.6250 | 23280.00 | 23280.00 | 0.00 | 60 | 7 | 1989 | 5600 | 0.355178571428571 | 0.730547095120966 | 0.730547095120966 | false | false | false | true | ||||||||||||||||
| 12f05113-23f3-4a2b-96bd-bc9513903c26 | 2026-08-19 10:36 | 2026-08-19 10:35 | 2026-08-19 10:35 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 3.8700 | 3.8500 | 3.9000 | 57.6300 | 13555.00 | 7780.00 | 5775.00 | 35 | 5 | 1834 | 5600 | 0.3275 | 0.725625074219121 | 0.731710113462227 | false | false | false | true | ||||||||||||||||
| 938402da-5f5d-4859-932c-54beb23eed12 | 2026-08-19 09:45 | 2026-08-19 09:45 | 2026-08-19 09:45 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 2.9200 | 2.7700 | 2.9200 | 56.0000 | 14600.00 | 14600.00 | 0.00 | 50 | 5 | 593 | 5600 | 0.105892857142857 | 0.69235683737573 | 0.69235683737573 | false | false | false | true | ||||||||||||||||
| d69b5004-4109-4bdb-8142-7ab741c7aef8 | 2026-08-19 09:45 | 2026-08-19 09:45 | 2026-08-19 09:45 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 2.9200 | 2.7300 | 2.9200 | 55.9700 | 29492.00 | 29492.00 | 0.00 | 101 | 16 | 508 | 5600 | 0.0907142857142857 | 0.69431981483565 | 0.69431981483565 | false | false | false | true | ||||||||||||||||
| fca199c4-8459-4e80-900f-d32f1eb81953 | 2026-08-19 09:43 | 2026-08-19 09:43 | 2026-08-19 09:43 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 2.9200 | 2.9200 | 3.2000 | 55.7700 | 18981.00 | 293.00 | 18688.00 | 65 | 15 | 295 | 5600 | 0.0526785714285714 | 0.70150878620432 | 0.707380940583603 | true | false | false | true | ||||||||||||||||
| 63fe1530-b36a-4660-8498-bb89d15d46d7 | 2026-08-18 09:50 | 2026-08-18 09:50 | 2026-08-18 09:50 | TEM | TEM260918C00060000 | call | 60.0000 | 2026-09-18 | 0.9500 | 0.9500 | 1.3200 | 50.0000 | 11400.00 | 0.00 | 11400.00 | 120 | 14 | 130 | 5726 | 0.0227034579112819 | 0.634401189137477 | 0.634401189137477 | false | false | false | true |
| 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-10T13:32:54.294551Z"} |
| 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-20T14:05:52.049536Z"} |
| 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-20T13:35:56.061771Z"} |
| 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-19T17:43:33.841762Z"} |
| 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-19T15:01:13.058297Z"} |
| 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-19T14:50:22.027850Z"} |
| 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-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| 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-19T14:37:39.751673Z"} |
| 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-19T13:50:14.094967Z"} |
| 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-19T13:50:14.094967Z"} |
| 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-19T13:50:14.094967Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |