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_alerts609,118 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 |
|---|
| 03dbfae8-e50a-433d-b277-45daef1e5c1d | 2026-09-21 13:32 | 2026-09-21 13:32 | 2026-09-21 13:32 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 11.4500 | 11.4000 | 11.6000 | 356.1000 | 44655.00 | 3459.00 | 41196.00 | 39 | 6 | 595 | 1431 | 0.415793151642208 | 0.315399792983263 | 0.31669962027078 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 2082963960000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1819fb62-45a7-452f-a464-a41d48328d14 | 2026-09-23 10:11 | 2026-09-23 10:10 | 2026-09-23 10:10 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 4.0000 | 3.9500 | 4.2000 | 341.0000 | 17185.00 | 0.00 | 17185.00 | 43 | 7 | 1076 | 1499 | 0.717811874583055 | 0.331428078738603 | 0.332946325742917 | false | false | false | |||||||||||||||||
| b62fd214-a486-4cc3-ba0b-931462735a41 | 2026-09-24 12:16 | 2026-09-24 12:15 | 2026-09-24 12:15 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 3.1500 | 3.0500 | 3.2000 | 341.2500 | 47304.00 | 47304.00 | 0.00 | 150 | 6 | 2120 | 4849 | 0.437203547123118 | 0.319621629711773 | 0.319621629711773 | false | false | false | |||||||||||||||||
| 5dfe2870-2b5b-429e-a785-ab7ee3d233c5 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 4.5000 | 4.3000 | 4.5000 | 346.0000 | 23380.00 | 23380.00 | 0.00 | 52 | 15 | 924 | 15662 | 0.0589962967692504 | 0.322933158450281 | 0.321971332178086 | false | false | false | |||||||||||||||||
| 25861e09-e9dc-434f-a218-b99e6002a614 | 2026-09-25 11:13 | 2026-09-25 11:13 | 2026-09-25 11:13 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 3.3300 | 3.2000 | 3.3500 | 343.5700 | 11652.00 | 11652.00 | 0.00 | 35 | 6 | 6884 | 15662 | 0.439535180692121 | 0.306720665853673 | 0.306150501748272 | false | false | false | |||||||||||||||||
| 8f69dfb7-0de7-46b2-bdb8-c3f509335857 | 2026-09-28 11:13 | 2026-09-28 11:13 | 2026-09-28 11:13 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 1.7500 | 1.7500 | 1.8000 | 341.0000 | 75810.00 | 0.00 | 75810.00 | 432 | 17 | 15741 | 17610 | 0.893867120954003 | 0.336563712974252 | 0.337446339579735 | false | false | false | |||||||||||||||||
| 8c7da001-89bc-47e5-bb09-147fbaba1c44 | 2026-09-29 10:10 | 2026-09-29 10:10 | 2026-09-29 10:10 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 1.2500 | 1.1900 | 1.2800 | 339.0000 | 165996.00 | 163496.00 | 2500.00 | 1332 | 62 | 3458 | 11949 | 0.289396602226128 | 0.368773411961469 | 0.370408340843801 | true | false | false | |||||||||||||||||
| 2787d19a-065d-40a3-affe-131b2be78ddc | 2026-09-29 10:22 | 2026-09-29 10:21 | 2026-09-29 10:21 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 1.0500 | 1.0100 | 1.0500 | 338.3950 | 24974.00 | 24974.00 | 0.00 | 238 | 5 | 4285 | 11949 | 0.358607414846431 | 0.379102515077783 | 0.38038865496445 | false | false | false | |||||||||||||||||
| a6d2b3af-95cd-4870-a92a-a86a28886a0e | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 2.0200 | 1.9000 | 2.0400 | 344.8600 | 43676.00 | 43676.00 | 0.00 | 216 | 13 | 602 | 13791 | 0.0436516568776738 | 0.392357615243394 | 0.397876406712253 | true | false | false | |||||||||||||||||
| 3529c501-be46-4eaa-9d43-695ff6d5c9a6 | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 2.2000 | 2.1000 | 2.2000 | 345.1800 | 45536.00 | 45536.00 | 0.00 | 207 | 6 | 837 | 13791 | 0.0606917554927126 | 0.39870281758827 | 0.404072995687181 | true | false | false | |||||||||||||||||
| 4480b0d6-3447-4175-8098-50e83b6359d2 | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 2.2500 | 2.0200 | 2.2600 | 344.8140 | 11901.00 | 11682.00 | 219.00 | 53 | 6 | 1242 | 13791 | 0.0900587339569284 | 0.4178420098076 | 0.422488937467593 | true | false | false | |||||||||||||||||
| ddb41974-c182-4acc-90be-1cc4f4b5d198 | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 2.5700 | 2.5200 | 2.6100 | 345.3200 | 77234.00 | 35441.00 | 41793.00 | 300 | 26 | 2551 | 13791 | 0.184975708795591 | 0.430692699124292 | 0.442801783064726 | true | false | false | |||||||||||||||||
| 8f6574eb-8b2a-459a-82c8-4f1d56957fb6 | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 3.0000 | 2.8900 | 3.1000 | 346.6800 | 22518.00 | 21940.00 | 578.00 | 75 | 5 | 4003 | 13791 | 0.29026176491915 | 0.420938246077698 | 0.432109467083639 | false | false | false | |||||||||||||||||
| 92e56f91-cd9c-4b76-b3fb-bc210fcc5c14 | 2026-09-30 09:32 | 2026-09-30 09:32 | 2026-09-30 09:32 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 3.7900 | 3.6000 | 3.8000 | 348.2800 | 29979.00 | 29979.00 | 0.00 | 79 | 9 | 4798 | 13791 | 0.347908055978537 | 0.441910247028074 | 0.443736840806425 | false | false | false | |||||||||||||||||
| fecf31a5-5dd1-4b52-ad1e-9d75762ee038 | 2026-09-30 09:49 | 2026-09-30 09:49 | 2026-09-30 09:49 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 3.9000 | 3.8500 | 3.9000 | 348.0000 | 15594.00 | 15594.00 | 0.00 | 40 | 6 | 9242 | 13791 | 0.670147197447611 | 0.42716503064607 | 0.429113303058651 | false | false | false | |||||||||||||||||
| 41c92b38-7944-48db-9007-a9b69ab21bff | 2026-09-30 09:59 | 2026-09-30 09:59 | 2026-09-30 09:59 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 4.3000 | 4.2500 | 4.5000 | 349.8000 | 26211.00 | 0.00 | 26211.00 | 61 | 20 | 11947 | 13791 | 0.866289609165398 | 0.418727639055114 | 0.424048749433286 | true | false | false | |||||||||||||||||
| 86633c6c-cee0-4b7d-bef1-aa01ddb8a555 | 2026-09-30 10:08 | 2026-09-30 10:08 | 2026-09-30 10:08 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 5.5500 | 5.4000 | 5.6000 | 352.0000 | 48250.00 | 48250.00 | 0.00 | 87 | 6 | 13719 | 13791 | 0.994779203828584 | 0.413721370529876 | 0.417084617914532 | false | false | false | |||||||||||||||||
| 6f765b98-92cb-4286-904f-f67717df957e | 2026-09-30 15:53 | 2026-09-30 15:53 | 2026-09-30 15:53 | GOOGL | GOOGL261002C00350000 | call | 350.0000 | 2026-10-02 | 1.8200 | 1.7300 | 2.7900 | 344.0000 | 22890.00 | 14116.00 | 8774.00 | 126 | 13 | 22980 | 13791 | 1.66630411137698 | 0.390126398965254 | 0.39734256976285 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:16:21.801502Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:15:19.758010Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:17:18.738051Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:13:29.737020Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:30:21.950232Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:30:21.950232Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:32:13.617209Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:33:11.727621Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:50:15.846728Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:59:55.546961Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:09:43.877107Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:54:17.966040Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |