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 |
|---|
| 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 |
|---|
| ba1a019f-bd83-43b3-8727-f50789847991 | 2026-09-29 09:48 | 2026-09-29 09:48 | 2026-09-29 09:48 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 59.8600 | 56.9000 | 60.0000 | 615.7900 | 83800.00 | 59970.00 | 23830.00 | 14 | 6 | 14 | 3277 | 0.00427220018309429 | 0.555613900287468 | 0.553221205912021 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 991842861268.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T13:48:49.550855Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| f9c5ee42-a7b8-4fe0-abf7-ad3f9889f67d | 2026-09-25 10:00 | 2026-09-25 10:00 | 2026-09-25 10:00 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 74.2500 | 73.9500 | 76.3000 | 636.0000 | 51975.00 | 0.00 | 51975.00 | 7 | 6 | 79 | 3252 | 0.0242927429274293 | 0.563674844778906 | 0.563674844778906 | false | false | false | |||||||||||||||||
| 6b899f53-c1a4-4887-a2a7-5f638e8e7b36 | 2026-09-25 09:59 | 2026-09-25 09:59 | 2026-09-25 09:59 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 74.2500 | 74.2500 | 76.3000 | 636.0000 | 37125.00 | 0.00 | 37125.00 | 5 | 5 | 72 | 3252 | 0.022140221402214 | 0.563845992582036 | 0.563845992582036 | false | false | false | |||||||||||||||||
| 546a2d9b-7c8d-4c5c-b3e1-10b04f198a24 | 2026-09-21 10:57 | 2026-09-21 10:56 | 2026-09-21 10:56 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 66.8600 | 65.5500 | 67.4000 | 613.2700 | 53490.00 | 26730.00 | 26760.00 | 8 | 6 | 318 | 3440 | 0.0924418604651163 | 0.597789275805458 | 0.595700016454209 | false | false | false | |||||||||||||||||
| 4da4a44b-24fb-47ac-a226-ec0a72b153c6 | 2026-09-21 10:57 | 2026-09-21 10:56 | 2026-09-21 10:56 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 66.8000 | 65.5500 | 66.8000 | 613.2700 | 53440.00 | 53440.00 | 0.00 | 8 | 5 | 328 | 3440 | 0.0953488372093023 | 0.595700016454209 | 0.595700016454209 | false | false | false | |||||||||||||||||
| 9c854e50-fc14-4ba2-8338-da11ce282fb8 | 2026-09-18 15:13 | 2026-09-18 15:12 | 2026-09-18 15:12 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 32.0000 | 31.7000 | 32.0000 | 545.0900 | 320000.00 | 320000.00 | 0.00 | 100 | 5 | 1549 | 1924 | 0.805093555093555 | 0.549314648392707 | 0.549314648392707 | false | false | false | |||||||||||||||||
| 3685aa08-5b53-4c91-b59a-ed95d021ca9b | 2026-09-18 15:13 | 2026-09-18 15:12 | 2026-09-18 15:12 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 32.0000 | 31.6500 | 32.4000 | 545.1300 | 697600.00 | 64000.00 | 633600.00 | 218 | 6 | 1449 | 1924 | 0.753118503118503 | 0.549172625708852 | 0.549172625708852 | false | false | false | |||||||||||||||||
| f86db3aa-281d-42a7-b905-dd03305041cb | 2026-09-18 15:06 | 2026-09-18 15:06 | 2026-09-18 15:06 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 32.0000 | 31.7000 | 32.0000 | 545.0320 | 320000.00 | 320000.00 | 0.00 | 100 | 5 | 1078 | 1924 | 0.56029106029106 | 0.549520581620318 | 0.549520581620318 | false | false | false | |||||||||||||||||
| d800db10-4be7-42ae-bcea-3d245e148379 | 2026-09-18 15:00 | 2026-09-18 15:00 | 2026-09-18 15:00 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 32.3500 | 32.0000 | 32.3500 | 545.6500 | 1384580.00 | 1222830.00 | 0.00 | 428 | 17 | 493 | 1924 | 0.256237006237006 | 0.550392408645538 | 0.550748403800922 | false | false | false | |||||||||||||||||
| 644009ff-d47d-4d79-b788-c99386791947 | 2026-09-16 11:36 | 2026-09-16 11:35 | 2026-09-16 11:35 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 25.5500 | 25.5500 | 26.9500 | 524.2393 | 232508.00 | 0.00 | 232508.00 | 91 | 10 | 118 | 1865 | 0.0632707774798928 | 0.548790235556764 | 0.549194291178228 | false | false | false | |||||||||||||||||
| bf46d3ef-3185-4611-b9c3-e49695d2bc03 | 2026-09-08 12:28 | 2026-09-08 12:28 | 2026-09-08 12:28 | AMD | AMD261218C00630000 | call | 630.0000 | 2026-12-18 | 26.8500 | 26.8500 | 27.6500 | 507.6200 | 338310.00 | 0.00 | 338310.00 | 126 | 20 | 173 | 1704 | 0.101525821596244 | 0.593908011681218 | 0.593908011681218 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1029487735736.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:01:14.001980Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1029487735736.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:01:14.001980Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 913892178012.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 913892178012.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 913892178012.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 913892178012.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 836643459025.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 805479510473.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |