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 | 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 |
|---|
| eb55f5c3-e7ff-404f-8754-4b263aed4ae5 | 2026-08-27 14:34 | 2026-08-27 14:34 | 2026-08-27 14:34 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 12.0500 | 11.8000 | 12.1500 | 217.8900 | 74710.00 | 54225.00 | 20485.00 | 62 | 10 | 106 | 4522 | 0.0234409553295002 | 0.871207589360593 | 0.871207589360593 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 75708254289.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 075327f2-4f20-4bae-b0d2-0d29b3e5b713 | 2026-09-04 13:00 | 2026-09-04 13:00 | 2026-09-04 13:00 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 21.0000 | 20.9500 | 21.7500 | 247.4000 | 579600.00 | 535500.00 | 44100.00 | 276 | 8 | 495 | 4340 | 0.114055299539171 | 0.877801597718886 | 0.877801597718886 | false | false | false | true | ||||||||||||||||
| 93a89127-a0a9-4cc8-b3a9-db26fb9a7c42 | 2026-09-04 15:59 | 2026-09-04 15:59 | 2026-09-04 15:59 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 23.8100 | 22.5000 | 24.9000 | 252.7575 | 600122.00 | 442742.00 | 71520.00 | 252 | 22 | 1641 | 4340 | 0.378110599078341 | 0.888293063561017 | 0.885481449121165 | false | false | false | true | ||||||||||||||||
| 3ca2e4f4-53a8-4912-839d-be30f562899e | 2026-09-08 09:45 | 2026-09-08 09:45 | 2026-09-08 09:45 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 32.0500 | 32.0500 | 33.7000 | 271.4600 | 320500.00 | 0.00 | 320500.00 | 100 | 10 | 572 | 5157 | 0.110917199922436 | 0.887365354398734 | 0.887365354398734 | false | false | false | true | ||||||||||||||||
| 6799a20a-e26b-4c4f-9d96-758211bc2557 | 2026-09-08 10:17 | 2026-09-08 10:17 | 2026-09-08 10:17 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 33.4000 | 32.5500 | 33.8000 | 273.5500 | 3349891.00 | 3259741.00 | 90150.00 | 1003 | 44 | 2874 | 5157 | 0.557300756253636 | 0.897549288933216 | 0.891652386709281 | true | false | false | true | ||||||||||||||||
| 9fbad637-fde9-4469-81a0-5b4347a0e870 | 2026-09-09 14:52 | 2026-09-09 14:52 | 2026-09-09 14:52 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 30.5200 | 30.4000 | 31.0500 | 273.2800 | 515725.00 | 210970.00 | 304755.00 | 169 | 26 | 2182 | 5666 | 0.385104129897635 | 0.821943481985316 | 0.824878117675291 | false | false | false | true | ||||||||||||||||
| 99ad59c5-3108-4b61-a3c2-358e2bc2ef92 | 2026-09-11 13:02 | 2026-09-11 13:01 | 2026-09-11 13:01 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 29.7000 | 29.6500 | 30.0500 | 274.9700 | 53461.00 | 23760.00 | 17821.00 | 18 | 5 | 384 | 7437 | 0.0516337232755143 | 0.793710200236604 | 0.79340907655649 | false | false | false | true | ||||||||||||||||
| 7d28e3a9-0ab6-4d3a-b3a2-cb1e1a717a02 | 2026-09-15 14:33 | 2026-09-15 14:32 | 2026-09-15 14:32 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 20.0100 | 19.9500 | 20.2000 | 259.4150 | 212090.00 | 16010.00 | 196080.00 | 106 | 24 | 518 | 7548 | 0.0686274509803922 | 0.801878660121953 | 0.80021955193215 | true | false | false | true | ||||||||||||||||
| 5c4e2434-56f8-4ab6-9c34-1794f502d539 | 2026-09-16 09:55 | 2026-09-16 09:55 | 2026-09-16 09:55 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 27.9500 | 27.1500 | 27.9500 | 273.2300 | 363350.00 | 363350.00 | 0.00 | 130 | 10 | 197 | 7657 | 0.0257280919420138 | 0.835389196762731 | 0.835389196762731 | false | false | false | true | ||||||||||||||||
| 186315b2-3d7e-4b01-8301-1dde0b64f32f | 2026-09-17 10:30 | 2026-09-17 10:30 | 2026-09-17 10:30 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 29.5500 | 29.4000 | 29.6000 | 278.2600 | 153665.00 | 150710.00 | 0.00 | 52 | 11 | 218 | 7722 | 0.0282310282310282 | 0.805918275630197 | 0.807570886515979 | true | false | false | true | ||||||||||||||||
| 9e61d500-46c4-4788-af4d-ac4455fa5d08 | 2026-09-17 15:12 | 2026-09-17 15:12 | 2026-09-17 15:12 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 30.0500 | 29.2500 | 30.0500 | 280.2700 | 81130.00 | 81130.00 | 0.00 | 27 | 9 | 425 | 7722 | 0.055037555037555 | 0.780321572024835 | 0.781977754112658 | true | false | false | true | ||||||||||||||||
| e0f68be5-fa3d-44ec-8f56-6c40ff7c3b55 | 2026-09-18 10:36 | 2026-09-18 10:36 | 2026-09-18 10:36 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 24.2600 | 23.8000 | 24.4500 | 271.5300 | 320270.00 | 89630.00 | 230640.00 | 132 | 8 | 524 | 7648 | 0.0685146443514644 | 0.771005254024042 | 0.774950537495311 | false | false | false | true | ||||||||||||||||
| 6167a9f4-a731-4ea6-a210-67a884e961a0 | 2026-09-21 11:53 | 2026-09-21 11:53 | 2026-09-21 11:53 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 29.3500 | 29.3500 | 29.4500 | 281.2700 | 413835.00 | 0.00 | 413835.00 | 141 | 7 | 538 | 8154 | 0.0659798871719402 | 0.7965651265555 | 0.7965651265555 | false | false | false | true | ||||||||||||||||
| 5eec9beb-3d7c-4779-b7f3-d350e8b754e4 | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 27.2900 | 26.9500 | 27.4000 | 279.0000 | 73670.00 | 51915.00 | 21755.00 | 27 | 10 | 39 | 8084 | 0.00482434438396833 | 0.788089934315223 | 0.788089934315223 | true | false | false | true | ||||||||||||||||
| abcecdbc-a886-44a7-be03-1c45a08ddd9b | 2026-09-23 10:43 | 2026-09-23 10:43 | 2026-09-23 10:43 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 24.8000 | 24.8000 | 25.0000 | 276.4600 | 74400.00 | 0.00 | 74400.00 | 30 | 5 | 120 | 8084 | 0.0148441365660564 | 0.771149266832946 | 0.771149266832946 | false | false | false | true | ||||||||||||||||
| 27febe38-6289-45b6-b1be-57d8f071c8fb | 2026-09-24 10:22 | 2026-09-24 10:21 | 2026-09-24 10:21 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 14.2500 | 14.1500 | 14.9500 | 257.8000 | 15675.00 | 2850.00 | 12825.00 | 11 | 7 | 127 | 8131 | 0.015619235026442 | 0.755915567666601 | 0.755915567666601 | true | false | false | true | ||||||||||||||||
| 71241916-f2dd-45ae-9cf0-40e79c8faf5a | 2026-09-24 15:38 | 2026-09-24 15:38 | 2026-09-24 15:38 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 18.4000 | 18.4000 | 18.6000 | 266.0000 | 18400.00 | 0.00 | 18400.00 | 10 | 10 | 360 | 8131 | 0.0442749969253474 | 0.758896165238644 | 0.758896165238644 | false | false | false | true | ||||||||||||||||
| 3401a626-eacf-4cb7-b6e6-90b4a15e0db7 | 2026-09-25 09:34 | 2026-09-25 09:33 | 2026-09-25 09:33 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 22.4700 | 22.2000 | 22.5000 | 274.0000 | 58416.00 | 49455.00 | 8961.00 | 26 | 12 | 94 | 8250 | 0.0113939393939394 | 0.75909268203256 | 0.76103033615448 | true | false | false | true | ||||||||||||||||
| a9e0ea21-a4fb-4cd7-bfad-68d6b5cc7398 | 2026-09-29 09:33 | 2026-09-29 09:32 | 2026-09-29 09:32 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 26.0000 | 25.7500 | 26.0000 | 282.0450 | 761800.00 | 761800.00 | 0.00 | 293 | 10 | 324 | 9162 | 0.0353634577603143 | 0.80433421937323 | 0.80433421937323 | false | false | false | true | ||||||||||||||||
| 1fa8a51d-bcc7-433c-b6e7-65f415ab4664 | 2026-09-29 09:33 | 2026-09-29 09:33 | 2026-09-29 09:33 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 27.5600 | 27.5000 | 28.0500 | 285.1350 | 30315.00 | 22050.00 | 8265.00 | 11 | 8 | 376 | 9162 | 0.0410390744378957 | 0.784226993849425 | 0.784226993849425 | false | false | false | true | ||||||||||||||||
| 787298cc-5146-4d8c-804e-6b94bd5f2ccf | 2026-09-29 13:13 | 2026-09-29 13:13 | 2026-09-29 13:13 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 35.1000 | 35.1000 | 35.1500 | 295.3901 | 287820.00 | 0.00 | 287820.00 | 82 | 7 | 966 | 9162 | 0.10543549443353 | 0.802343914343556 | 0.802343914343556 | true | false | false | true | ||||||||||||||||
| 8742f574-1aa0-46b5-8e38-c0a1dc2e018e | 2026-09-29 13:56 | 2026-09-29 13:56 | 2026-09-29 13:56 | BE | BE261016C00270000 | call | 270.0000 | 2026-10-16 | 32.6700 | 32.6000 | 32.9500 | 292.3900 | 849390.00 | 176310.00 | 489750.00 | 260 | 24 | 1233 | 9162 | 0.134577603143418 | 0.789059714478316 | 0.793713928500126 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 75708254289.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 79528273967.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 82691497663.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 78235298918.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 80373567450.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 81050980346.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81050980346.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:43:13.868883Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81050980346.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 81050980346.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 85030044790.00 |
| 2026-10-27 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:33:34.031299Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:33:34.031299Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:16:24.150546Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 85781089523.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |