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 |
|---|
| 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 |
|---|
| 06b1e2c0-0fab-4860-9dcf-1b099a4841e6 | 2026-09-18 10:21 | 2026-09-18 10:21 | 2026-09-18 10:21 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 6.9000 | 6.9000 | 7.1500 | 548.4300 | 462300.00 | 0.00 | 462300.00 | 670 | 64 | 716 | 905 | 0.791160220994475 | 0.496679110218572 | 0.496679110218572 | false | false | false | true | 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-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 93a7a4eb-4d2a-48a1-be4a-d0c52929dde4 | 2026-09-21 10:06 | 2026-09-21 10:06 | 2026-09-21 10:06 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 26.9500 | 26.8000 | 27.0500 | 607.4400 | 13475.00 | 2695.00 | 10780.00 | 5 | 5 | 444 | 2121 | 0.209335219236209 | 0.5652744975929 | 0.5652744975929 | false | false | false | true | ||||||||||||||||
| c497dc2e-7ed6-4eab-b54f-e2822ca56280 | 2026-09-21 10:12 | 2026-09-21 10:12 | 2026-09-21 10:12 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 28.9500 | 28.9500 | 29.1500 | 611.0000 | 301080.00 | 0.00 | 301080.00 | 104 | 15 | 559 | 2121 | 0.263554926921264 | 0.567141931259343 | 0.566637501691672 | true | false | false | true | ||||||||||||||||
| 94255e17-856b-4ec3-b8d8-f3cf7e33cfcc | 2026-09-21 10:28 | 2026-09-21 10:28 | 2026-09-21 10:28 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 27.7500 | 27.6500 | 28.0500 | 609.8050 | 110990.00 | 0.00 | 108225.00 | 40 | 8 | 855 | 2121 | 0.403111739745403 | 0.561316669969958 | 0.559732662759507 | true | false | false | true | ||||||||||||||||
| ee718eec-9cd8-4243-ac72-518fd239600c | 2026-09-21 10:51 | 2026-09-21 10:51 | 2026-09-21 10:51 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 28.4500 | 28.4500 | 28.7500 | 611.2950 | 105265.00 | 0.00 | 105265.00 | 37 | 7 | 1139 | 2121 | 0.537010843941537 | 0.561743227910632 | 0.561743227910632 | true | false | false | true | ||||||||||||||||
| d52d095f-4fd3-4c12-bf7f-7e923b058281 | 2026-09-21 11:28 | 2026-09-21 11:28 | 2026-09-21 11:28 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 28.6500 | 28.5500 | 28.9000 | 611.1900 | 28650.00 | 25785.00 | 2865.00 | 10 | 7 | 1307 | 2121 | 0.616218764733616 | 0.565650676511801 | 0.565650676511801 | true | false | false | true | ||||||||||||||||
| afe49449-89b5-4f64-8e83-ee736ee21e47 | 2026-09-21 15:13 | 2026-09-21 15:13 | 2026-09-21 15:13 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 28.5000 | 28.5000 | 28.7500 | 612.4100 | 17100.00 | 0.00 | 17100.00 | 6 | 5 | 3298 | 2121 | 1.55492692126356 | 0.553319717370878 | 0.554510114480892 | true | false | false | true | ||||||||||||||||
| 259dd7a6-8ae9-4d18-8042-206015e98112 | 2026-09-21 15:47 | 2026-09-21 15:47 | 2026-09-21 15:47 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 29.7500 | 29.6000 | 30.1500 | 615.0000 | 53555.00 | 5955.00 | 47600.00 | 18 | 10 | 3433 | 2121 | 1.61857614332862 | 0.553849911933646 | 0.5548787981866 | true | false | false | true | ||||||||||||||||
| f186c008-bd3f-48a4-9350-961368807593 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 25.9900 | 25.5000 | 27.7000 | 608.0501 | 18190.00 | 7825.00 | 10365.00 | 7 | 5 | 8 | 3663 | 0.00218400218400218 | 0.555934741233554 | 0.555934741233554 | true | false | false | true | ||||||||||||||||
| d0731126-f323-4565-b59c-be8ab013db2f | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 26.9900 | 26.8000 | 27.7500 | 612.6300 | 72875.00 | 5395.00 | 67480.00 | 27 | 9 | 45 | 3663 | 0.0122850122850123 | 0.540571404528372 | 0.537505316046936 | true | false | false | true | ||||||||||||||||
| 64fece36-3a92-4642-8138-8fdc2e989fd4 | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 27.6000 | 27.0500 | 27.6500 | 618.0000 | 57960.00 | 55200.00 | 2760.00 | 21 | 7 | 45 | 3880 | 0.0115979381443299 | 0.520538273759045 | 0.520538273759045 | true | false | false | true | ||||||||||||||||
| 88ed6e84-5340-4373-b8ba-bcfb6a21b6d4 | 2026-09-23 13:03 | 2026-09-23 13:03 | 2026-09-23 13:03 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 24.1500 | 23.9000 | 24.3000 | 611.1800 | 115920.00 | 113505.00 | 2415.00 | 48 | 7 | 402 | 3880 | 0.10360824742268 | 0.516538952877037 | 0.516538952877037 | true | false | false | true | ||||||||||||||||
| e3cac6dd-e2e5-4fc0-a082-0395616379a2 | 2026-09-23 14:04 | 2026-09-23 14:04 | 2026-09-23 14:04 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 24.6000 | 24.5500 | 24.9000 | 612.7700 | 66415.00 | 0.00 | 66415.00 | 27 | 7 | 448 | 3880 | 0.115463917525773 | 0.512320825014365 | 0.51149889866618 | true | false | false | true | ||||||||||||||||
| 8250b62e-ce46-420f-944c-2ab2e27459e5 | 2026-09-24 14:39 | 2026-09-24 14:39 | 2026-09-24 14:39 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 29.6000 | 29.5000 | 30.1000 | 623.5700 | 14800.00 | 5925.00 | 8875.00 | 5 | 5 | 1026 | 3575 | 0.286993006993007 | 0.521405456533474 | 0.522224131402141 | false | false | false | true | ||||||||||||||||
| 349a21b5-84f2-46c4-ac2a-319b5f691e2f | 2026-09-24 15:44 | 2026-09-24 15:44 | 2026-09-24 15:44 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 31.9600 | 31.9500 | 32.0000 | 628.5599 | 44750.00 | 12800.00 | 0.00 | 14 | 5 | 1170 | 3575 | 0.327272727272727 | 0.520090695215683 | 0.519578157896697 | false | false | false | true | ||||||||||||||||
| 5c979d40-836b-460d-8c7c-ecc17b930e9c | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 32.5500 | 32.4500 | 32.5500 | 629.1200 | 32550.00 | 32550.00 | 0.00 | 10 | 5 | 1265 | 3575 | 0.353846153846154 | 0.523722804561533 | 0.523722804561533 | true | false | false | true | ||||||||||||||||
| cf89708b-8996-49f6-930c-a1e592fca4be | 2026-09-25 09:32 | 2026-09-25 09:32 | 2026-09-25 09:32 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 33.8900 | 33.8000 | 34.4000 | 633.5900 | 159290.00 | 71295.00 | 87995.00 | 47 | 8 | 136 | 3577 | 0.0380206877271457 | 0.517563261381575 | 0.518893345495062 | true | false | false | true | ||||||||||||||||
| 704d9e97-739a-45fe-ae34-9bf1b51542c4 | 2026-09-25 09:39 | 2026-09-25 09:39 | 2026-09-25 09:39 | AMD | AMD261016C00630000 | call | 630.0000 | 2026-10-16 | 32.2000 | 32.0500 | 32.6000 | 631.0000 | 425075.00 | 102885.00 | 322190.00 | 132 | 5 | 399 | 3577 | 0.111545988258317 | 0.509117145091768 | 0.507836664168943 | false | false | false | true |
| 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:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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:55:57.762099Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| 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 |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:42:17.809304Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1003335485564.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1029487735736.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:33:47.828400Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T13:39:47.971768Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |