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_alerts658,639 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 |
|---|
| 025a83d5-9070-431d-99bc-507f045a60a5 | 2026-09-14 12:15 | 2026-09-14 12:15 | 2026-09-14 12:15 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 37.4500 | 36.6000 | 37.4500 | 427.9128 | 179745.00 | 172265.00 | 7480.00 | 48 | 26 | 2774 | 2729 | 1.01648955661414 | 0.56753508599685 | 0.56753508599685 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 336651971295.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2dc05387-0e5c-4024-ad1d-185f35717625 | 2026-09-14 09:53 | 2026-09-14 09:53 | 2026-09-14 09:53 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 37.0500 | 36.1000 | 39.0500 | 425.7300 | 111150.00 | 29640.00 | 62985.00 | 30 | 5 | 2031 | 2729 | 0.744228655185049 | 0.577330368147582 | 0.577330368147582 | false | false | false | |||||||||||||||||
| dd8a59e5-1170-4b40-b674-27213a142278 | 2026-09-14 09:52 | 2026-09-14 09:52 | 2026-09-14 09:52 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.8000 | 35.8000 | 37.9500 | 425.1260 | 117760.00 | 29440.00 | 25760.00 | 32 | 6 | 1979 | 2729 | 0.725174056430927 | 0.578095707256983 | 0.578095707256983 | false | false | false | |||||||||||||||||
| a6787032-758c-4c7a-80db-76789dcd86a0 | 2026-09-14 09:52 | 2026-09-14 09:51 | 2026-09-14 09:51 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 37.1000 | 36.7000 | 39.6500 | 425.6350 | 129850.00 | 25970.00 | 59360.00 | 35 | 6 | 1947 | 2729 | 0.713448149505313 | 0.57867981830363 | 0.57867981830363 | false | false | false | |||||||||||||||||
| 227ce061-9dc1-4499-be30-77a6d7629452 | 2026-09-14 09:51 | 2026-09-14 09:51 | 2026-09-14 09:51 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 37.6500 | 36.3000 | 38.3500 | 426.7450 | 120480.00 | 30120.00 | 26355.00 | 32 | 5 | 1911 | 2729 | 0.700256504213998 | 0.578473175747718 | 0.578473175747718 | false | false | false | |||||||||||||||||
| ca584c3e-6338-41c1-b7f8-42d0dd6bd6c3 | 2026-09-14 09:50 | 2026-09-14 09:50 | 2026-09-14 09:50 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 38.6000 | 37.9500 | 39.5500 | 428.2293 | 220020.00 | 38600.00 | 181420.00 | 57 | 18 | 1879 | 2729 | 0.688530597288384 | 0.58103276310176 | 0.58103276310176 | false | false | false | |||||||||||||||||
| 79dff68b-9bba-4740-829e-89e315f3f533 | 2026-09-14 09:47 | 2026-09-14 09:47 | 2026-09-14 09:47 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 38.1000 | 36.8000 | 38.6000 | 426.0000 | 281940.00 | 281940.00 | 0.00 | 74 | 6 | 1744 | 2729 | 0.639061927445951 | 0.583802212668141 | 0.583802212668141 | false | false | false | |||||||||||||||||
| 8664e4b9-b036-42dd-9222-7b7c1ef55a7a | 2026-09-14 09:46 | 2026-09-14 09:46 | 2026-09-14 09:46 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 38.2000 | 37.4000 | 39.8500 | 427.0000 | 126060.00 | 95500.00 | 30560.00 | 33 | 5 | 1650 | 2729 | 0.60461707585196 | 0.580705621902066 | 0.580705621902066 | false | false | false | |||||||||||||||||
| 2145bce4-45ae-4492-8a69-7af1e4cf0b8d | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.7000 | 34.7500 | 35.7000 | 422.6100 | 221340.00 | 221340.00 | 0.00 | 62 | 5 | 1298 | 2729 | 0.475632099670209 | 0.580289371208961 | 0.580289371208961 | false | false | false | |||||||||||||||||
| 3a051f3d-a88a-4510-97c7-c111811baedb | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.4500 | 34.8500 | 36.5500 | 422.4500 | 361600.00 | 74455.00 | 116985.00 | 102 | 9 | 1210 | 2729 | 0.443385855624771 | 0.577136647226048 | 0.579309840620376 | true | false | false | |||||||||||||||||
| 94f6b7c4-f786-49c7-bade-934ba01c85d1 | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.7000 | 35.1000 | 35.7000 | 422.5500 | 221340.00 | 82110.00 | 0.00 | 62 | 5 | 1074 | 2729 | 0.393550751190912 | 0.580701176137775 | 0.580701176137775 | false | false | false | |||||||||||||||||
| 9e9b7178-e0c3-49f1-bb03-2ef5a71d6fae | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.6500 | 34.9500 | 35.6500 | 422.2900 | 303025.00 | 303025.00 | 0.00 | 85 | 6 | 969 | 2729 | 0.355075119091242 | 0.581792105189856 | 0.581792105189856 | false | false | false | |||||||||||||||||
| 38dfebfd-d2fc-478f-a4db-6123e0ed851a | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.7000 | 34.7500 | 35.7000 | 422.4500 | 310590.00 | 310590.00 | 0.00 | 87 | 5 | 884 | 2729 | 0.323928178820081 | 0.581387366917929 | 0.581387366917929 | false | false | false | |||||||||||||||||
| 00987772-b8b1-4f9c-a996-5e48feee0887 | 2026-09-14 09:34 | 2026-09-14 09:34 | 2026-09-14 09:34 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 35.4500 | 34.2000 | 37.4000 | 421.9200 | 340320.00 | 148890.00 | 152435.00 | 96 | 8 | 774 | 2729 | 0.283620373763283 | 0.58155399902313 | 0.58155399902313 | false | false | false | |||||||||||||||||
| 1a24fc90-f16a-4722-a19f-f9cd8b6157e5 | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.1000 | 35.0500 | 37.4500 | 423.3050 | 194940.00 | 137180.00 | 57760.00 | 54 | 7 | 602 | 2729 | 0.220593624038109 | 0.58104281792162 | 0.58104281792162 | false | false | false | |||||||||||||||||
| b4953693-db93-4341-a8a9-f8c354c2e23d | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.0000 | 34.1500 | 37.8500 | 423.3650 | 291600.00 | 244800.00 | 46800.00 | 81 | 8 | 548 | 2729 | 0.200806156101136 | 0.579247413345303 | 0.579247413345303 | false | false | false | |||||||||||||||||
| f1f154cb-7577-489b-8a9c-761fdfa3b975 | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.5000 | 36.0500 | 37.9500 | 424.0100 | 317550.00 | 83950.00 | 233600.00 | 87 | 14 | 452 | 2729 | 0.165628435324295 | 0.581699351401443 | 0.581699351401443 | false | false | false | |||||||||||||||||
| 3ab99a7b-47ff-469e-8191-543b819009e8 | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 37.0000 | 35.8500 | 37.0000 | 424.6150 | 303400.00 | 303400.00 | 0.00 | 82 | 6 | 365 | 2729 | 0.133748625870282 | 0.584400145431598 | 0.584400145431598 | false | false | false | |||||||||||||||||
| 33eaaa59-41d4-416b-8071-60736b69d9fa | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.2000 | 32.9500 | 38.2000 | 424.2600 | 293220.00 | 133940.00 | 39820.00 | 81 | 6 | 198 | 2729 | 0.0725540491022353 | 0.575832297286042 | 0.575832297286042 | false | false | false | |||||||||||||||||
| b26be991-3347-4af3-8558-e1694dc555f1 | 2026-09-14 09:33 | 2026-09-14 09:33 | 2026-09-14 09:33 | AMAT | AMAT261120C00440000 | call | 440.0000 | 2026-11-20 | 36.5500 | 32.6000 | 36.5500 | 423.5300 | 215645.00 | 215645.00 | 0.00 | 59 | 5 | 61 | 2729 | 0.0223525100769513 | 0.585708172379171 | 0.585708172379171 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 336651971295.00 |
| 2026-11-12 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |