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 | 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 |
|---|
| 2ca9369d-d17f-4402-9c8b-6d768ed8d9a2 | 2026-09-29 11:34 | 2026-09-29 11:34 | 2026-09-29 11:34 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 29.9300 | 28.9500 | 30.0500 | 457.0000 | 29931.00 | 29931.00 | 0.00 | 10 | 7 | 261 | 1883 | 0.138608603292618 | 0.34307745127434 | 0.34307745127434 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Technology | 2369921550834.00 | 2026-10-15 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T15:36:52.175506Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 2b5b61d3-79dd-4d61-9f83-376241c13cd7 | 2026-09-29 11:12 | 2026-09-29 11:12 | 2026-09-29 11:12 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 29.2000 | 28.8500 | 29.5000 | 455.0000 | 292000.00 | 292000.00 | 0.00 | 100 | 10 | 251 | 1883 | 0.133297928836962 | 0.344291841326703 | 0.344291841326703 | false | false | false | true | ||||||||||||||||
| bd98caba-ee47-4055-9fa5-f09e64d0cce2 | 2026-09-28 12:22 | 2026-09-28 12:22 | 2026-09-28 12:22 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 27.5900 | 27.1000 | 27.8500 | 452.9400 | 22072.00 | 22072.00 | 0.00 | 8 | 6 | 42 | 1841 | 0.0228136882129278 | 0.339254280245833 | 0.339254280245833 | false | false | false | true | ||||||||||||||||
| c4ce7177-7019-4c2c-b9a4-3f03bfd93039 | 2026-09-25 13:44 | 2026-09-25 13:44 | 2026-09-25 13:44 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 27.1600 | 27.1000 | 27.5500 | 451.1799 | 19015.00 | 2720.00 | 16295.00 | 7 | 7 | 46 | 1820 | 0.0252747252747253 | 0.337780431876719 | 0.337780431876719 | true | false | false | true | ||||||||||||||||
| 36fa5551-2f06-4f28-92cb-4332fe8bd69b | 2026-09-24 10:27 | 2026-09-24 10:27 | 2026-09-24 10:27 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 24.1500 | 24.1000 | 24.9000 | 444.1700 | 33810.00 | 0.00 | 33810.00 | 14 | 5 | 16 | 1804 | 0.00886917960088692 | 0.340842871028849 | 0.340842871028849 | false | false | false | true | ||||||||||||||||
| 7d6ec01d-e056-49c4-87cb-2cabc5ae2c46 | 2026-09-23 10:56 | 2026-09-23 10:56 | 2026-09-23 10:56 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 26.1000 | 25.7500 | 26.2500 | 447.9750 | 52195.00 | 52195.00 | 0.00 | 20 | 8 | 104 | 1739 | 0.0598044853364002 | 0.339521448281092 | 0.340097921693077 | false | false | false | true | ||||||||||||||||
| c399eaec-d422-4a37-ba99-f868fc434f71 | 2026-09-23 10:22 | 2026-09-23 10:21 | 2026-09-23 10:21 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 23.6000 | 23.2000 | 23.6500 | 443.5700 | 63710.00 | 56655.00 | 7055.00 | 27 | 15 | 67 | 1739 | 0.0385278895917194 | 0.335630047889791 | 0.334461929131408 | false | false | false | true | ||||||||||||||||
| d51dd5fd-c1a8-499d-a028-7e49115fc264 | 2026-09-23 10:22 | 2026-09-23 10:21 | 2026-09-23 10:21 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 23.6500 | 23.0500 | 23.6500 | 443.5500 | 49665.00 | 49665.00 | 0.00 | 21 | 13 | 40 | 1739 | 0.0230017251293847 | 0.336323315286158 | 0.336323315286158 | false | false | false | true | ||||||||||||||||
| 2624c45f-cd87-4c4c-8cda-10f470c11b7c | 2026-09-22 15:57 | 2026-09-22 15:57 | 2026-09-22 15:57 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 28.3000 | 28.2000 | 28.3000 | 452.2200 | 42450.00 | 42450.00 | 0.00 | 15 | 9 | 107 | 1721 | 0.0621731551423591 | 0.338503731851706 | 0.338503731851706 | true | false | false | true | ||||||||||||||||
| 762bbcdc-2ff3-42a3-8024-d77b3d635beb | 2026-09-22 11:07 | 2026-09-22 11:07 | 2026-09-22 11:07 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 25.5000 | 24.7500 | 26.0500 | 446.0000 | 20400.00 | 20400.00 | 0.00 | 8 | 8 | 43 | 1721 | 0.0249854735618826 | 0.339167940952306 | 0.339167940952306 | false | false | false | true | ||||||||||||||||
| 8305e246-a002-4000-8c38-e394e95fceeb | 2026-09-22 10:15 | 2026-09-22 10:15 | 2026-09-22 10:15 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 25.5000 | 25.5000 | 25.9000 | 446.4900 | 12750.00 | 0.00 | 12750.00 | 5 | 5 | 32 | 1721 | 0.0185938407902382 | 0.339279609171189 | 0.339279609171189 | false | false | false | true | ||||||||||||||||
| 5ec1d5c0-a026-4a4c-8e1a-b1e92b967a5d | 2026-09-21 11:04 | 2026-09-21 11:04 | 2026-09-21 11:04 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 23.0800 | 22.4000 | 23.1000 | 440.8000 | 41535.00 | 39230.00 | 2305.00 | 18 | 8 | 51 | 1664 | 0.0306490384615385 | 0.340100137071796 | 0.340444075723475 | false | false | false | true | ||||||||||||||||
| d0346ea3-edb0-4931-9cfb-10dce30d82c7 | 2026-09-01 14:25 | 2026-09-01 14:25 | 2026-09-01 14:25 | TSM | TSM261218C00460000 | call | 460.0000 | 2026-12-18 | 16.1000 | 16.0500 | 16.4500 | 413.1400 | 178725.00 | 1625.00 | 177100.00 | 111 | 30 | 116 | 1451 | 0.0799448656099242 | 0.348349279025247 | 0.350457386359282 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2369921550834.00 |
| 2026-10-15 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:12:41.685966Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2348864340924.00 |
| 2026-10-15 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:23:11.774661Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2337090974791.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2316137494979.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2344300216608.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2344300216608.00 |
| 2026-10-15 |
| 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 |
| ADR |
| Technology |
| 2344300216608.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Technology |
| 2308720792967.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Technology |
| 2168010914921.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |