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_alerts474,253 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 |
|---|
| fccf8017-5f0a-44ac-8d63-4da2cb34a7a2 | 2026-08-18 14:03 | 2026-08-18 14:03 | 2026-08-18 14:03 | TLN | TLN260828P00310000 | put | 310.0000 | 2026-08-28 | 4.7300 | 4.7000 | 5.4000 | 327.9615 | 19390.00 | 1960.00 | 17430.00 | 41 | 6 | 56 | 20 | 2.8 | 0.551088223562571 | 0.575544464976137 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Utilities | 13728393489.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3f599267-7d41-4a6d-9e84-2f58852f1c3d | 2026-08-18 13:22 | 2026-08-18 13:22 | 2026-08-18 13:22 | OKLO | OKLO260821P00040000 | put | 40.0000 | 2026-08-21 | 0.6100 | 0.5900 | 0.6150 | 41.5900 | 10001.00 | 10001.00 | 0.00 | 164 | 6 | 674 | 3391 | 0.198761427307579 | 0.840841148193999 | 0.848580440378254 | true | false | false | true | ||||||||||||||||
| 33060a79-4ef8-4ed7-855a-4479ebf1c0e1 | 2026-08-18 13:14 | 2026-08-18 13:14 | 2026-08-18 13:14 | GEV | GEV260918C01050000 | call | 1050.0000 | 2026-09-18 | 44.0600 | 43.9000 | 46.0000 | 1015.4450 | 61690.00 | 0.00 | 39690.00 | 14 | 5 | 44 | 365 | 0.120547945205479 | 0.486436526008758 | 0.489003198553153 | true | false | false | true | ||||||||||||||||
| c5e1904a-90f4-4e9d-94ed-fb88b21a2e20 | 2026-08-18 12:59 | 2026-08-18 12:59 | 2026-08-18 12:59 | CEG | CEG260821P00275000 | put | 275.0000 | 2026-08-21 | 3.9600 | 3.7000 | 4.7000 | 276.4850 | 69260.00 | 16810.00 | 52450.00 | 175 | 19 | 205 | 147 | 1.39455782312925 | 0.4811059522829 | 0.485911513790738 | true | false | false | true | ||||||||||||||||
| f3f18760-3c75-41d9-8f8a-31f7b37a7b14 | 2026-08-18 12:57 | 2026-08-18 12:57 | 2026-08-18 12:57 | TLN | TLN260904P00365000 | put | 365.0000 | 2026-09-04 | 24.8800 | 24.7000 | 24.9000 | 351.2850 | 24880.00 | 24880.00 | 0.00 | 10 | 10 | 10 | 8 | 1.25 | 0.56823307767862 | 0.56823307767862 | true | false | false | true | ||||||||||||||||
| f21bffbe-e719-4be4-98c1-8fa123028366 | 2026-08-18 12:57 | 2026-08-18 12:57 | 2026-08-18 12:57 | TLN | TLN260828P00362500 | put | 362.5000 | 2026-08-28 | 19.9500 | 19.9000 | 20.1000 | 351.2850 | 135690.00 | 38180.00 | 97510.00 | 68 | 20 | 68 | 2 | 34 | 0.591001618349274 | 0.595461252269725 | true | false | false | true | ||||||||||||||||
| 7fffc027-95fd-4daa-a3c5-c4c2a5662a35 | 2026-08-18 12:56 | 2026-08-18 12:56 | 2026-08-18 12:56 | CEG | CEG260821P00285000 | put | 285.0000 | 2026-08-21 | 10.0600 | 10.0000 | 10.1000 | 277.2000 | 53316.00 | 32316.00 | 21000.00 | 53 | 9 | 53 | 16 | 3.3125 | 0.518647807115069 | 0.518647807115069 | false | false | false | true | ||||||||||||||||
| 1146cb16-358b-4837-b7c9-0c58e1d2d9e4 | 2026-08-18 12:17 | 2026-08-18 12:17 | 2026-08-18 12:17 | UGI | UGI270115C00035000 | call | 35.0000 | 2027-01-15 | 5.0000 | 5.0000 | 6.8000 | 39.1800 | 14996.00 | 0.00 | 14996.00 | 30 | 8 | 42 | 1096 | 0.0383211678832117 | 0.173119098244979 | 0.175198601048771 | true | false | false | true | ||||||||||||||||
| 73273c96-bea9-46bc-816d-8a1e98852198 | 2026-08-18 11:18 | 2026-08-18 11:18 | 2026-08-18 11:18 | UGI | UGI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.1200 | 0.8500 | 1.3000 | 35.2099 | 13770.00 | 13770.00 | 0.00 | 123 | 12 | 125 | 697 | 0.179340028694405 | 0.228133849702896 | 0.277639343101827 | false | false | false | true | ||||||||||||||||
| 0e99e18c-c268-4f6d-8acb-364e46ebb501 | 2026-08-18 10:02 | 2026-08-18 10:01 | 2026-08-18 10:01 | NEE | NEE280121C00080000 | call | 80.0000 | 2028-01-21 | 13.8500 | 13.8500 | 15.5500 | 86.4601 | 245165.00 | 0.00 | 245165.00 | 177 | 13 | 177 | 271 | 0.653136531365314 | 0.178162721976687 | 0.180596132049715 | false | false | false | true | ||||||||||||||||
| fd6b2e79-0b68-4a02-9210-b947d74ea11a | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | VST | VST260918C00160000 | call | 160.0000 | 2026-09-18 | 2.1800 | 2.1500 | 2.9600 | 144.5100 | 13297.00 | 0.00 | 13297.00 | 61 | 40 | 65 | 10022 | 0.00648573139093993 | 0.415267018617474 | 0.434749123477873 | true | false | false | true | ||||||||||||||||
| 0e9696c3-1b97-46e1-83ab-3134bf1cb914 | 2026-08-17 14:52 | 2026-08-17 14:52 | 2026-08-17 14:52 | TLN | TLN270115C00560000 | call | 560.0000 | 2027-01-15 | 8.2000 | 6.6000 | 11.4000 | 358.0800 | 15580.00 | 6630.00 | 8950.00 | 19 | 7 | 19 | 2425 | 0.00783505154639175 | 0.542309513729403 | 0.542309513729403 | false | false | false | |||||||||||||||||
| 0a6a1040-a825-4828-88a1-a5d54c70eec2 | 2026-08-17 13:25 | 2026-08-17 13:25 | 2026-08-17 13:25 | VST | VST260918P00135000 | put | 135.0000 | 2026-09-18 | 2.6400 | 2.4400 | 2.6600 | 146.8099 | 33835.00 | 25419.00 | 8416.00 | 128 | 17 | 336 | 2883 | 0.116545265348595 | 0.432937204030825 | 0.433071270531193 | true | false | false | true | ||||||||||||||||
| e24cc7eb-c82f-4e8f-bb39-acdfcfe1ec1e | 2026-08-17 12:28 | 2026-08-17 12:27 | 2026-08-17 12:27 | OKLO | OKLO260911C00038000 | call | 38.0000 | 2026-09-11 | 7.3400 | 7.1000 | 7.6000 | 44.1550 | 46263.00 | 8820.00 | 36708.00 | 63 | 15 | 130 | 1 | 130 | 0.770889907841445 | 0.780259733026121 | true | false | false | true | ||||||||||||||||
| add2a1d0-7141-41c6-9b82-2c4449915a1d | 2026-08-17 11:31 | 2026-08-17 11:31 | 2026-08-17 11:31 | VST | VST261016C00160000 | call | 160.0000 | 2026-10-16 | 5.5200 | 5.3000 | 5.5500 | 145.8700 | 33122.00 | 33122.00 | 0.00 | 60 | 6 | 105 | 737 | 0.14246947082768 | 0.440220178173152 | 0.440220178173152 | false | false | false | true | ||||||||||||||||
| ff52296e-4bbc-4c99-be48-6844c2aae227 | 2026-08-17 10:51 | 2026-08-17 10:50 | 2026-08-17 10:50 | OKLO | OKLO261016P00045000 | put | 45.0000 | 2026-10-16 | 6.0500 | 6.0500 | 6.2000 | 43.9200 | 1366778.00 | 0.00 | 1366778.00 | 2259 | 67 | 2269 | 4610 | 0.492190889370933 | 0.790360028041959 | 0.790360028041959 | false | false | false | |||||||||||||||||
| 80684b21-47f3-440d-9070-79d55bfc6da8 | 2026-08-17 10:16 | 2026-08-17 10:16 | 2026-08-17 10:16 | VST | VST260821P00141000 | put | 141.0000 | 2026-08-21 | 1.0000 | 0.8300 | 1.0200 | 145.9100 | 11599.00 | 11599.00 | 0.00 | 116 | 41 | 182 | 78 | 2.33333333333333 | 0.480731904544079 | 0.469810545983044 | true | false | false | true | ||||||||||||||||
| b8df0656-6e22-4ce2-a818-ec605b00cd0d | 2026-08-17 10:13 | 2026-08-17 10:12 | 2026-08-17 10:12 | OKLO | OKLO260821C00043500 | call | 43.5000 | 2026-08-21 | 1.8100 | 1.8000 | 1.9700 | 44.0400 | 17925.00 | 0.00 | 17925.00 | 99 | 10 | 115 | 528 | 0.21780303030303 | 0.823492061684865 | 0.834564826741663 | false | false | false | true | ||||||||||||||||
| 499383b1-b393-4330-bd70-de6dccf28c62 | 2026-08-17 10:06 | 2026-08-17 10:06 | 2026-08-17 10:06 | CEG | CEG261218C00290000 | call | 290.0000 | 2026-12-18 | 23.2000 | 22.8000 | 24.3000 | 276.4000 | 1461639.00 | 2320.00 | 1459319.00 | 630 | 60 | 633 | 56 | 11.3035714285714 | 0.427366622187405 | 0.428061157140743 | false | false | false | |||||||||||||||||
| 34d742a3-dfa6-4a09-b4c2-7cffee853d3a | 2026-08-17 09:46 | 2026-08-17 09:46 | 2026-08-17 09:46 | GEV | GEV260821C01090000 | call | 1090.0000 | 2026-08-21 | 18.6500 | 17.0000 | 18.7000 | 1074.0000 | 93270.00 | 93270.00 | 0.00 | 50 | 18 | 55 | 320 | 0.171875 | 0.568468249156709 | 0.568468249156709 | false | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 6735699107.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 93739103262.00 |
| 2026-11-06 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 93739103262.00 |
| 2026-11-06 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 8090750155.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 8090750155.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 170264114318.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47233940992.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 13728393489.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47233940992.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 6735699107.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47233940992.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 6735699107.00 |
| 2026-11-10 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 47233940992.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 6735699107.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 93739103262.00 |
| 2026-11-06 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 232977963316.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |