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_alerts326,449 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 |
|---|
| f439508a-e9d9-421d-8643-113ac078646f | 2026-08-17 10:46 | 2026-08-17 10:46 | 2026-08-17 10:46 | SMTC | SMTC260821C00150000 | call | 150.0000 | 2026-08-21 | 8.1600 | 7.9000 | 8.2000 | 153.5700 | 13060.00 | 11480.00 | 1580.00 | 16 | 8 | 29 | 791 | 0.0366624525916561 | 0.981225085914509 | 0.932452924080879 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 13723533303.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 761ddd57-477e-4da7-8407-cea270060a7d | 2026-08-19 09:36 | 2026-08-19 09:36 | 2026-08-19 09:36 | SMTC | SMTC260918C00150000 | call | 150.0000 | 2026-09-18 | 9.9000 | 8.9000 | 12.2000 | 135.9850 | 39604.00 | 0.00 | 39604.00 | 40 | 8 | 41 | 631 | 0.0649762282091918 | 0.972779269474947 | 0.972779269474947 | false | false | false | true | ||||||||||||||||
| f37f7348-d3a1-4fc5-bb8d-5a25e83ca96e | 2026-08-25 15:48 | 2026-08-25 15:48 | 2026-08-25 15:48 | SMTC | SMTC261016C00130000 | call | 130.0000 | 2026-10-16 | 16.5900 | 14.7000 | 16.6000 | 125.2900 | 19909.00 | 19909.00 | 0.00 | 12 | 5 | 72 | 19 | 3.78947368421053 | 0.972502614688293 | 0.97197002854094 | false | false | false | true | ||||||||||||||||
| ecc39306-9eb1-442c-9145-0752f1834bbc | 2026-08-25 15:57 | 2026-08-25 15:57 | 2026-08-25 15:57 | SMTC | SMTC260918C00125000 | call | 125.0000 | 2026-09-18 | 14.4400 | 13.5000 | 14.5000 | 126.7750 | 72208.00 | 72208.00 | 0.00 | 50 | 20 | 1309 | 809 | 1.61804697156984 | 1.04739984423492 | 1.03953985919509 | true | false | false | true | ||||||||||||||||
| 68aa3b69-c88e-4a1c-af54-e16288f669ff | 2026-08-26 10:30 | 2026-08-26 10:30 | 2026-08-26 10:30 | SMTC | SMTC261016P00160000 | put | 160.0000 | 2026-10-16 | 29.2000 | 28.3000 | 29.2000 | 140.3000 | 1019069.00 | 1019069.00 | 0.00 | 349 | 39 | 349 | 13 | 26.8461538461538 | 0.842773702577718 | 0.821438295363185 | false | false | false | |||||||||||||||||
| 7d6bbaa5-e1bd-4869-a31c-c062da4f85a4 | 2026-08-26 10:41 | 2026-08-26 10:41 | 2026-08-26 10:41 | SMTC | SMTC260918P00110000 | put | 110.0000 | 2026-09-18 | 1.4400 | 1.3500 | 1.7000 | 141.7300 | 17957.00 | 13335.00 | 4622.00 | 125 | 20 | 717 | 598 | 1.19899665551839 | 0.843313296989539 | 0.834895949912048 | false | false | false | true | ||||||||||||||||
| 90c6cdbd-ce88-44b5-8820-c8d2801af3be | 2026-08-26 13:59 | 2026-08-26 13:59 | 2026-08-26 13:59 | SMTC | SMTC261016C00185000 | call | 185.0000 | 2026-10-16 | 5.1000 | 4.8000 | 5.1000 | 139.7300 | 139226.00 | 139226.00 | 0.00 | 273 | 38 | 282 | 4 | 70.5 | 0.831564222116647 | 0.831564222116647 | false | false | false | true | ||||||||||||||||
| 76fb5cd9-3007-4323-b35f-fff931aee72f | 2026-08-27 09:32 | 2026-08-27 09:32 | 2026-08-27 09:32 | SMTC | SMTC260918C00150000 | call | 150.0000 | 2026-09-18 | 10.8300 | 9.1000 | 12.0000 | 148.7800 | 16241.00 | 16241.00 | 0.00 | 15 | 6 | 23 | 1248 | 0.0184294871794872 | 0.772490954805906 | 0.772490954805906 | false | false | false | |||||||||||||||||
| b7be27a7-d1c9-4ae4-9559-b9be7a453a73 | 2026-09-01 14:47 | 2026-09-01 14:47 | 2026-09-01 14:47 | SMTC | SMTC261120C00200000 | call | 200.0000 | 2026-11-20 | 3.7000 | 3.3000 | 3.8000 | 131.2800 | 75848.00 | 75848.00 | 0.00 | 205 | 40 | 205 | 373 | 0.549597855227882 | 0.775508657380118 | 0.775399373126291 | false | false | false | |||||||||||||||||
| b47b7c84-c8b6-4a4c-af9b-428519a0f303 | 2026-09-01 14:51 | 2026-09-01 14:50 | 2026-09-01 14:50 | SMTC | SMTC260918C00150000 | call | 150.0000 | 2026-09-18 | 2.9700 | 2.6500 | 3.0000 | 131.9900 | 13666.00 | 13666.00 | 0.00 | 46 | 11 | 113 | 1204 | 0.0938538205980066 | 0.768762004849545 | 0.753175610626463 | false | false | false | |||||||||||||||||
| cbca2cc5-b3e5-4007-bc6a-274b1d55e7f9 | 2026-09-03 11:26 | 2026-09-03 11:25 | 2026-09-03 11:25 | SMTC | SMTC261016C00140000 | call | 140.0000 | 2026-10-16 | 10.2600 | 9.1000 | 10.8000 | 131.5050 | 48230.00 | 48230.00 | 0.00 | 47 | 8 | 151 | 346 | 0.436416184971098 | 0.749921521201085 | 0.749921521201085 | false | false | false | |||||||||||||||||
| c17e51d0-e471-488c-92ef-acbf3223079a | 2026-09-03 12:53 | 2026-09-03 12:53 | 2026-09-03 12:53 | SMTC | SMTC260918P00130000 | put | 130.0000 | 2026-09-18 | 6.0500 | 5.9000 | 6.1000 | 133.3150 | 56300.00 | 56300.00 | 0.00 | 93 | 7 | 95 | 393 | 0.241730279898219 | 0.727374169753156 | 0.717790877308645 | false | false | false | true | ||||||||||||||||
| be6e99d2-f56d-4476-9ced-55dae66750e0 | 2026-09-03 12:53 | 2026-09-03 12:53 | 2026-09-03 12:53 | SMTC | SMTC260918P00130000 | put | 130.0000 | 2026-09-18 | 6.0300 | 6.0000 | 6.3000 | 133.2050 | 45191.00 | 0.00 | 45191.00 | 75 | 6 | 195 | 393 | 0.49618320610687 | 0.716450955318899 | 0.716450955318899 | false | false | false | true | ||||||||||||||||
| c63c6bec-8303-4072-8d55-9c1fc4e35687 | 2026-09-08 10:51 | 2026-09-08 10:51 | 2026-09-08 10:51 | SMTC | SMTC261016C00180000 | call | 180.0000 | 2026-10-16 | 10.6000 | 10.4000 | 10.8000 | 160.2100 | 111258.00 | 104938.00 | 4240.00 | 105 | 27 | 161 | 1586 | 0.101513240857503 | 0.854740140906101 | 0.854740140906101 | false | false | false | |||||||||||||||||
| fc34b300-9b3b-4c60-a3da-9b02ed782ce6 | 2026-09-09 10:29 | 2026-09-09 10:29 | 2026-09-09 10:29 | SMTC | SMTC260918C00165000 | call | 165.0000 | 2026-09-18 | 10.4000 | 9.0000 | 10.7000 | 167.0000 | 156069.00 | 156069.00 | 0.00 | 150 | 11 | 306 | 862 | 0.354988399071926 | 0.911686284286804 | 0.87157893063975 | false | false | false | |||||||||||||||||
| 7930c79a-b39a-45ca-bb69-0f33b3c59e4d | 2026-09-09 10:46 | 2026-09-09 10:46 | 2026-09-09 10:46 | SMTC | SMTC260918C00165000 | call | 165.0000 | 2026-09-18 | 10.7400 | 9.6000 | 11.0000 | 167.6900 | 184670.00 | 161060.00 | 23610.00 | 172 | 13 | 478 | 862 | 0.554524361948956 | 0.91082374824041 | 0.884743081677357 | true | false | false | |||||||||||||||||
| 1afe5193-356c-4833-a9f1-382e6afbad38 | 2026-09-14 15:44 | 2026-09-14 15:44 | 2026-09-14 15:44 | SMTC | SMTC261218P00120000 | put | 120.0000 | 2026-12-18 | 11.1900 | 10.3000 | 11.2000 | 148.8800 | 50358.00 | 50358.00 | 0.00 | 45 | 23 | 111 | 31 | 3.58064516129032 | 0.863838072343787 | 0.863838072343787 | false | false | false | true | ||||||||||||||||
| 99e24eea-288d-4a76-b597-8ca061015005 | 2026-09-16 10:41 | 2026-09-16 10:41 | 2026-09-16 10:41 | SMTC | SMTC270115C00200000 | call | 200.0000 | 2027-01-15 | 19.3900 | 18.9000 | 20.4000 | 163.2500 | 994960.00 | 932820.00 | 62140.00 | 513 | 8 | 516 | 1541 | 0.334847501622323 | 0.824000158909551 | 0.818840958880549 | true | false | false | |||||||||||||||||
| 25bfba7e-33cc-41f1-aa43-ad77e71d08c7 | 2026-09-16 10:45 | 2026-09-16 10:45 | 2026-09-16 10:45 | SMTC | SMTC270115C00200000 | call | 200.0000 | 2027-01-15 | 20.3900 | 19.4000 | 20.4000 | 164.2000 | 1019374.00 | 976744.00 | 42630.00 | 500 | 26 | 1016 | 1541 | 0.659312134977287 | 0.84119139044485 | 0.836399900540514 | true | false | false | |||||||||||||||||
| bfa2ead3-b389-4a91-9b57-1a94805edec3 | 2026-09-17 10:43 | 2026-09-17 10:43 | 2026-09-17 10:43 | SMTC | SMTC261016C00230000 | call | 230.0000 | 2026-10-16 | 3.5800 | 3.5000 | 3.9000 | 177.7200 | 14310.00 | 720.00 | 13590.00 | 40 | 13 | 418 | 208 | 2.00961538461538 | 0.853805529257835 | 0.845996315556306 | false | false | false | |||||||||||||||||
| 9a95e634-60fd-4121-8922-8b9e9ccca800 | 2026-09-17 13:30 | 2026-09-17 13:30 | 2026-09-17 13:30 | SMTC | SMTC261016C00170000 | call | 170.0000 | 2026-10-16 | 22.3200 | 21.3000 | 22.4000 | 179.4599 | 11160.00 | 6710.00 | 4450.00 | 5 | 5 | 12 | 798 | 0.0150375939849624 | 0.86563965949262 | 0.860357964126476 | true | false | false | |||||||||||||||||
| 513bb7d7-99a1-44fc-a858-de19f652b344 | 2026-09-21 14:14 | 2026-09-21 14:14 | 2026-09-21 14:14 | SMTC | SMTC261016C00200000 | call | 200.0000 | 2026-10-16 | 8.1900 | 7.8000 | 8.4000 | 177.3300 | 40964.00 | 40964.00 | 0.00 | 50 | 13 | 302 | 427 | 0.707259953161593 | 0.868397921717021 | 0.868397921717021 | true | false | false | true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 15636708636.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 15636708636.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 16629693297.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 16629693297.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 16553166284.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |