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 |
|---|
| 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 |
|---|
| 82d44f48-719c-4241-906a-75528ef366bb | 2026-09-21 10:12 | 2026-09-21 10:12 | 2026-09-21 10:12 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 3.4900 | 3.4000 | 3.6000 | 611.3200 | 17465.00 | 1405.00 | 16060.00 | 50 | 18 | 10710 | 28 | 382.5 | 0.802958100142347 | 0.823282628142081 | false | false | false | true | 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:14:40.112451Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| cbee867c-3572-4e98-99fb-5a3c301a30c4 | 2026-09-21 10:14 | 2026-09-21 10:14 | 2026-09-21 10:14 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 3.5500 | 3.5000 | 3.6000 | 611.5550 | 10653.00 | 358.00 | 9940.00 | 30 | 5 | 11330 | 28 | 404.642857142857 | 0.814487549408331 | 0.809532753809117 | true | false | false | |||||||||||||||||
| 0074491b-3d0c-4a4a-8bca-5e246b496319 | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 3.4100 | 3.3500 | 3.5000 | 611.0000 | 11265.00 | 690.00 | 10575.00 | 33 | 6 | 11894 | 28 | 424.785714285714 | 0.793450131079937 | 0.785163770836499 | false | false | false | |||||||||||||||||
| d7cde117-0d6f-4c6e-bd43-61a1db3f4fd7 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 4.0400 | 3.9000 | 4.3000 | 612.4202 | 10911.00 | 2395.00 | 7706.00 | 27 | 17 | 12966 | 28 | 463.071428571429 | 0.790066314699565 | 0.811812065370968 | true | false | false | |||||||||||||||||
| d7a08a20-5df4-41b6-a628-89504e43cf82 | 2026-09-21 10:26 | 2026-09-21 10:26 | 2026-09-21 10:26 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 2.3400 | 2.2800 | 2.4500 | 609.5000 | 24098.00 | 716.00 | 684.00 | 103 | 8 | 15014 | 28 | 536.214285714286 | 0.747721409367985 | 0.742407277135856 | false | false | false | |||||||||||||||||
| b039c4a7-b5a4-4dc1-adfb-f13431ede1f7 | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 2.4800 | 2.4700 | 2.4900 | 611.0050 | 14110.00 | 0.00 | 14110.00 | 57 | 5 | 16917 | 28 | 604.178571428571 | 0.687331852249362 | 0.685559959103919 | false | false | false | |||||||||||||||||
| 7d14ade3-df3b-4c56-969e-b63291934528 | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 4.1100 | 4.1000 | 4.1500 | 615.3501 | 15202.00 | 2070.00 | 13132.00 | 37 | 7 | 23500 | 28 | 839.285714285714 | 0.656493240626996 | 0.675508844566001 | false | false | false | |||||||||||||||||
| a88fc4c2-e5fc-4e81-8c92-0aff7ae5ffd5 | 2026-09-21 11:08 | 2026-09-21 11:08 | 2026-09-21 11:08 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 2.4900 | 2.3400 | 2.5600 | 612.5700 | 12193.00 | 499.00 | 11460.00 | 49 | 11 | 25711 | 28 | 918.25 | 0.634965878145982 | 0.608372341249319 | false | false | false | |||||||||||||||||
| 2cadce9a-2494-48a3-ac24-e3d4822ee779 | 2026-09-21 11:34 | 2026-09-21 11:34 | 2026-09-21 11:34 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 2.0000 | 2.0000 | 2.1000 | 612.0000 | 23412.00 | 0.00 | 23412.00 | 117 | 11 | 31479 | 28 | 1124.25 | 0.607370951556852 | 0.595742324954844 | false | false | false | |||||||||||||||||
| 745d9c2d-1457-4ed0-b605-f6bfc7c862a1 | 2026-09-21 15:25 | 2026-09-21 15:25 | 2026-09-21 15:25 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 0.9900 | 0.9700 | 1.0200 | 613.9400 | 12780.00 | 11880.00 | 0.00 | 129 | 5 | 77526 | 28 | 2768.78571428571 | 0.742860303259765 | 0.737588282946635 | false | false | false | |||||||||||||||||
| a2f27dc7-3e88-4792-8504-316301f837c5 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 1.1900 | 1.1600 | 1.2500 | 614.2300 | 11694.00 | 2267.00 | 9427.00 | 98 | 13 | 80389 | 28 | 2871.03571428571 | 0.811173989840561 | 0.846126198218811 | false | false | false | |||||||||||||||||
| cda57cbc-978b-47e7-aa91-99d725d48f1b | 2026-09-21 15:37 | 2026-09-21 15:37 | 2026-09-21 15:37 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 1.6700 | 1.6700 | 1.7900 | 615.6000 | 25915.00 | 0.00 | 25050.00 | 155 | 8 | 82192 | 28 | 2935.42857142857 | 0.870951397937681 | 0.833300827773025 | false | false | false | |||||||||||||||||
| 11276091-c0e5-405f-afe7-f39d23c4a5e4 | 2026-09-21 15:40 | 2026-09-21 15:39 | 2026-09-21 15:39 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 1.9500 | 1.8300 | 1.9700 | 615.9300 | 21415.00 | 21029.00 | 386.00 | 110 | 16 | 83007 | 28 | 2964.53571428571 | 0.998936711250869 | 0.947052791012022 | true | false | false | |||||||||||||||||
| e6d1cd7d-d10a-44c3-9e1a-572fd2f6ceb3 | 2026-09-21 15:50 | 2026-09-21 15:50 | 2026-09-21 15:50 | AMD | AMD260921C00615000 | call | 615.0000 | 2026-09-21 | 1.0000 | 0.9000 | 1.1550 | 614.8300 | 55455.00 | 420.00 | 55035.00 | 553 | 9 | 85771 | 28 | 3063.25 | 1.01279490453226 | 1.03088069348683 | true | false | false |
| 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:14:40.112451Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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 |
| 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:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |