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.
Simplify Analyticsuw_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 |
|---|
| 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 |
|---|
| f634c3a7-ca57-4d39-9688-22d0919ee342 | 2026-09-28 15:35 | 2026-09-28 15:34 | 2026-09-28 15:34 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 24.7000 | 24.7000 | 24.9000 | 607.7400 | 14820.00 | 0.00 | 14820.00 | 6 | 5 | 703 | 1082 | 0.649722735674677 | 0.510600636438876 | 0.510600636438876 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 992332603781.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:36:53.342339Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 7a837983-e373-49ab-aa2e-5aa832b5d749 | 2026-09-28 11:57 | 2026-09-28 11:56 | 2026-09-28 11:56 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 22.3000 | 22.0500 | 22.4000 | 603.8300 | 40140.00 | 33450.00 | 6690.00 | 18 | 6 | 577 | 1082 | 0.533271719038817 | 0.500525872839704 | 0.500525872839704 | true | false | false | |||||||||||||||||
| dc65c253-4dd7-4bd1-b4d1-6b81fac9ff7e | 2026-09-28 10:17 | 2026-09-28 10:17 | 2026-09-28 10:17 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 25.5200 | 25.5000 | 25.9000 | 610.8150 | 66345.00 | 7685.00 | 58660.00 | 26 | 7 | 433 | 1082 | 0.400184842883549 | 0.495570213794938 | 0.497156548168553 | true | false | false | |||||||||||||||||
| a2ca4cba-356d-42a4-b11a-97755e659baf | 2026-09-28 10:17 | 2026-09-28 10:17 | 2026-09-28 10:17 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 25.5600 | 25.5000 | 25.8000 | 610.7300 | 17890.00 | 2570.00 | 15320.00 | 7 | 6 | 386 | 1082 | 0.356746765249538 | 0.496867541856467 | 0.497948827903165 | true | false | false | |||||||||||||||||
| 4e35e2d4-0a12-4eb8-ba9f-0996bd7c77a6 | 2026-09-28 10:12 | 2026-09-28 10:12 | 2026-09-28 10:12 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 23.8500 | 23.7500 | 23.8500 | 607.5000 | 88245.00 | 88245.00 | 0.00 | 37 | 8 | 371 | 1082 | 0.342883548983364 | 0.496970893077884 | 0.496970893077884 | false | false | false | |||||||||||||||||
| 2b77ca81-4599-4e10-8338-4db2e890affe | 2026-09-28 09:31 | 2026-09-28 09:31 | 2026-09-28 09:31 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 33.4800 | 33.3500 | 34.5000 | 623.1250 | 435225.00 | 13430.00 | 421795.00 | 130 | 20 | 148 | 1082 | 0.136783733826248 | 0.518307459551276 | 0.520126921399139 | true | false | false | |||||||||||||||||
| 3479c4a0-31a3-456a-9ca3-6c3353afa5e6 | 2026-09-25 15:31 | 2026-09-25 15:31 | 2026-09-25 15:31 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 38.5200 | 38.2500 | 38.7500 | 629.7425 | 381368.00 | 377508.00 | 3860.00 | 99 | 20 | 187 | 1173 | 0.159420289855072 | 0.499988372883073 | 0.50171246240586 | true | false | false | |||||||||||||||||
| 63c10fbf-ff8e-4738-ae37-c2e002da5d46 | 2026-09-24 12:43 | 2026-09-24 12:43 | 2026-09-24 12:43 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 38.3500 | 38.3500 | 38.6500 | 626.5389 | 575250.00 | 0.00 | 575250.00 | 150 | 19 | 1744 | 556 | 3.13669064748201 | 0.51546705537638 | 0.517653615731416 | true | false | false | |||||||||||||||||
| 830d11b4-6eaf-4cf3-b4ed-5833eb5ae68e | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 31.1300 | 30.7500 | 31.2000 | 614.0000 | 34245.00 | 18695.00 | 15550.00 | 11 | 5 | 1037 | 556 | 1.86510791366906 | 0.50929318933405 | 0.507627178193272 | false | false | false | |||||||||||||||||
| d54fb948-38f1-4cc3-9a27-09486a450aba | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 31.0500 | 30.3500 | 31.0500 | 614.0000 | 68305.00 | 68305.00 | 0.00 | 22 | 5 | 1025 | 556 | 1.84352517985612 | 0.507333551734128 | 0.506500523955568 | true | false | false | |||||||||||||||||
| 7b69ede0-ec73-472a-9a20-3f2365529a96 | 2026-09-24 11:37 | 2026-09-24 11:36 | 2026-09-24 11:36 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 29.6500 | 29.5500 | 30.0000 | 612.0000 | 62260.00 | 50405.00 | 11855.00 | 21 | 16 | 981 | 556 | 1.76438848920863 | 0.506750383205412 | 0.507585258122194 | false | false | false | |||||||||||||||||
| e9154e12-9a11-4a08-892e-3938a27e5ddf | 2026-09-24 10:14 | 2026-09-24 10:14 | 2026-09-24 10:14 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 31.9500 | 31.9500 | 32.2500 | 615.1950 | 38340.00 | 0.00 | 38340.00 | 12 | 6 | 842 | 556 | 1.51438848920863 | 0.51597333685707 | 0.51730795643313 | false | false | false | |||||||||||||||||
| 84764c5d-77c0-4c25-bcf8-d4efdde0c182 | 2026-09-24 10:00 | 2026-09-24 10:00 | 2026-09-24 10:00 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 33.2000 | 33.2000 | 33.7000 | 617.3300 | 83005.00 | 0.00 | 83005.00 | 25 | 6 | 246 | 556 | 0.442446043165468 | 0.517816392456502 | 0.518950214712718 | true | false | false | |||||||||||||||||
| 20a08dc1-6af1-4c06-bacd-45ac4c5a1e26 | 2026-09-24 09:37 | 2026-09-24 09:37 | 2026-09-24 09:37 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 31.9500 | 31.0500 | 31.9500 | 614.9935 | 57510.00 | 57510.00 | 0.00 | 18 | 6 | 127 | 556 | 0.22841726618705 | 0.519098155411503 | 0.519098155411503 | true | false | false | |||||||||||||||||
| 0b5b7af0-fde1-45cf-b04f-f2ba2449caa8 | 2026-09-23 15:45 | 2026-09-23 15:44 | 2026-09-23 15:44 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 32.3500 | 32.0500 | 32.3500 | 614.0000 | 35580.00 | 32350.00 | 3230.00 | 11 | 5 | 457 | 437 | 1.04576659038902 | 0.514290999512743 | 0.513476270768784 | true | false | false | |||||||||||||||||
| df85420e-a81e-4aa5-af3c-e5f146aede22 | 2026-09-22 10:23 | 2026-09-22 10:23 | 2026-09-22 10:23 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 34.8000 | 34.6000 | 34.9000 | 616.5650 | 17400.00 | 10440.00 | 6960.00 | 5 | 5 | 167 | 317 | 0.526813880126183 | 0.528029405601846 | 0.528029405601846 | false | false | false | |||||||||||||||||
| 357aa957-ff86-4b17-8754-8583ce7dc15b | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 32.2500 | 32.2500 | 32.5500 | 607.8900 | 299925.00 | 0.00 | 299925.00 | 93 | 10 | 612 | 0 | 0 | 0.547941674103169 | 0.547941674103169 | true | false | false | true | ||||||||||||||||
| 429a5288-b2e5-46fb-a372-7dde483938c4 | 2026-09-21 13:10 | 2026-09-21 13:10 | 2026-09-21 13:10 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 32.8500 | 32.8000 | 33.1000 | 608.8800 | 16425.00 | 0.00 | 16425.00 | 5 | 5 | 462 | 0 | 0 | 0.547777734859034 | 0.549498953524494 | false | false | false | true | ||||||||||||||||
| f79ce22f-fde3-44ec-9a81-b611b1e6016d | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | AMD | AMD261016C00615000 | call | 615.0000 | 2026-10-16 | 35.2900 | 34.9000 | 36.4500 | 611.0000 | 81175.00 | 70595.00 | 10580.00 | 23 | 6 | 241 | 0 | 0 | 0.562853105731324 | 0.563426552118017 | true | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 992332603781.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:58:21.684493Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 992332603781.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:18:45.811547Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 992332603781.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:18:45.811547Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 992332603781.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:13:51.758637Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 992332603781.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:31:55.658450Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| 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-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-24T16:45:03.999525Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T16:16:49.777231Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T16:16:49.777231Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T14:18:01.976836Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T14:01:19.671622Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T13:38:54.076483Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-21T18:53:27.633876Z"} |
| 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-21T17:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |