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_alerts658,639 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 |
|---|
| 072a6ced-1a8e-4eb3-82bb-a41f47e6086b | 2026-08-21 12:35 | 2026-08-21 12:35 | 2026-08-21 12:35 | CRWD | CRWD270917C00240000 | call | 240.0000 | 2027-09-17 | 33.3200 | 30.7000 | 34.4500 | 191.5800 | 99950.00 | 96610.00 | 3340.00 | 30 | 10 | 141 | 0 | 0 | 0.583822538119941 | 0.585716367702113 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 241013783110.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cda226d3-b29f-4ed8-bb38-9b1e4a02b7b0 | 2026-08-21 12:08 | 2026-08-21 12:08 | 2026-08-21 12:08 | CRWD | CRWD271217C00230000 | call | 230.0000 | 2027-12-17 | 40.9100 | 38.6000 | 42.7000 | 191.3300 | 7891599.00 | 3757892.00 | 4109167.00 | 1929 | 74 | 1933 | 64 | 30.203125 | 0.574145361264201 | 0.575980691667829 | true | false | false | true | ||||||||||||||||
| c5493901-096e-41a4-9de1-15a9735ad0e9 | 2026-08-20 15:22 | 2026-08-20 15:22 | 2026-08-20 15:22 | CRWD | CRWD270917C00250000 | call | 250.0000 | 2027-09-17 | 29.5000 | 29.5000 | 31.2500 | 190.8900 | 891020.00 | 2965.00 | 888055.00 | 302 | 10 | 311 | 0 | 0 | 0.571445873499851 | 0.573350378166243 | false | false | false | true | ||||||||||||||||
| f4f42ff7-e8c1-4e0a-9025-6a87e669ad20 | 2026-08-20 12:19 | 2026-08-20 12:19 | 2026-08-20 12:19 | CRWD | CRWD260821C00167500 | call | 167.5000 | 2026-08-21 | 26.0800 | 25.0500 | 27.3500 | 193.4100 | 65188.00 | 0.00 | 65188.00 | 25 | 9 | 125 | 580 | 0.21551724137931 | 1.41711336383754 | 1.41711336383754 | false | false | false | true | ||||||||||||||||
| d2315892-c927-426e-9a04-528c5a4c2377 | 2026-08-20 11:54 | 2026-08-20 11:54 | 2026-08-20 11:54 | CRWD | CRWD261120C00310000 | call | 310.0000 | 2026-11-20 | 1.7800 | 1.7800 | 1.9500 | 192.8100 | 71747.00 | 0.00 | 37927.00 | 403 | 15 | 404 | 822 | 0.491484184914842 | 0.589848642612315 | 0.589848642612315 | false | false | false | true | ||||||||||||||||
| 8ce21584-d529-4cb6-b5d1-ed531c04ba93 | 2026-08-20 11:36 | 2026-08-20 11:36 | 2026-08-20 11:36 | CRWD | CRWD270617P00215000 | put | 215.0000 | 2027-06-17 | 49.9500 | 49.3500 | 51.8000 | 192.1200 | 139870.00 | 89915.00 | 49955.00 | 28 | 8 | 28 | 93 | 0.301075268817204 | 0.579675179653761 | 0.580398104007473 | false | false | false | true | ||||||||||||||||
| f737a1c6-367c-42d0-bf99-ecb2f835dd92 | 2026-08-20 10:07 | 2026-08-20 10:07 | 2026-08-20 10:07 | CRWD | CRWD260918P00195000 | put | 195.0000 | 2026-09-18 | 12.0800 | 12.0000 | 12.4000 | 197.5800 | 72475.00 | 24200.00 | 48275.00 | 60 | 41 | 115 | 962 | 0.11954261954262 | 0.616813909335085 | 0.616617854683101 | false | false | false | true | ||||||||||||||||
| 60a4b656-1ed9-41ba-a8b0-27a4f6c03e5a | 2026-08-20 09:30 | 2026-08-20 09:30 | 2026-08-20 09:30 | CRWD | CRWD260828P00200000 | put | 200.0000 | 2026-08-28 | 9.1100 | 7.8000 | 9.8500 | 199.6550 | 80155.00 | 30260.00 | 915.00 | 88 | 81 | 103 | 1316 | 0.0782674772036474 | 0.755632128568022 | 0.776858122495134 | false | false | false | true | ||||||||||||||||
| e96f630a-6548-4dd0-a463-5bf880a7283f | 2026-08-19 13:48 | 2026-08-19 13:48 | 2026-08-19 13:48 | CRWD | CRWD261218P00190000 | put | 190.0000 | 2026-12-18 | 19.1200 | 18.8500 | 19.6000 | 200.4800 | 196905.00 | 5760.00 | 191145.00 | 103 | 6 | 1149 | 2046 | 0.56158357771261 | 0.562309841757446 | 0.566724683642738 | false | false | false | true | ||||||||||||||||
| 60dce30c-e4a4-4f6d-9e23-060e60fc9cb5 | 2026-08-19 13:47 | 2026-08-19 13:47 | 2026-08-19 13:47 | CRWD | CRWD261218P00190000 | put | 190.0000 | 2026-12-18 | 19.2000 | 19.0000 | 19.5000 | 200.4400 | 842900.00 | 1925.00 | 840975.00 | 439 | 46 | 1046 | 2046 | 0.511241446725318 | 0.565256166914064 | 0.566625563142484 | false | false | false | true | ||||||||||||||||
| 109fb4bd-8ebf-48eb-92b7-40bd14de039b | 2026-08-19 13:33 | 2026-08-19 13:33 | 2026-08-19 13:33 | CRWD | CRWD260918P00187500 | put | 187.5000 | 2026-09-18 | 8.1200 | 8.1000 | 8.3000 | 199.5300 | 56038.00 | 12298.00 | 43740.00 | 69 | 6 | 210 | 5988 | 0.0350701402805611 | 0.612728451590681 | 0.615713838852704 | false | false | false | true | ||||||||||||||||
| 62b12beb-e9c7-41a7-a75f-62ba71c63919 | 2026-08-19 12:05 | 2026-08-19 12:05 | 2026-08-19 12:05 | CRWD | CRWD260918C00200000 | call | 200.0000 | 2026-09-18 | 15.2900 | 15.0000 | 15.3000 | 201.6100 | 253758.00 | 253758.00 | 0.00 | 166 | 6 | 256 | 2057 | 0.124453087019932 | 0.616859201776461 | 0.616859201776461 | false | false | false | true | ||||||||||||||||
| 93dfd15d-dea5-48b3-8126-09b76a0c9ed9 | 2026-08-19 11:14 | 2026-08-19 11:13 | 2026-08-19 11:13 | CRWD | CRWD261016C00260000 | call | 260.0000 | 2026-10-16 | 3.5000 | 3.4000 | 3.6500 | 200.3300 | 68220.00 | 4550.00 | 58070.00 | 195 | 7 | 246 | 953 | 0.25813221406086 | 0.573102983927374 | 0.575684510113824 | false | false | false | true | ||||||||||||||||
| 8dfcf3e9-3320-424a-a08c-ec7d9c981a1c | 2026-08-19 10:47 | 2026-08-19 10:47 | 2026-08-19 10:47 | CRWD | CRWD260821P00197500 | put | 197.5000 | 2026-08-21 | 3.7000 | 3.6500 | 4.1000 | 198.2900 | 345226.00 | 370.00 | 344856.00 | 933 | 65 | 1228 | 626 | 1.96166134185304 | 0.688233968947663 | 0.702075000376475 | false | false | false | true | ||||||||||||||||
| 1e90206f-4a9a-4897-aae4-c6a83f1b76ef | 2026-08-19 10:21 | 2026-08-19 10:21 | 2026-08-19 10:21 | CRWD | CRWD260918C00252500 | call | 252.5000 | 2026-09-18 | 1.7400 | 1.7400 | 2.0100 | 198.2708 | 133815.00 | 705.00 | 132936.00 | 769 | 71 | 805 | 177 | 4.54802259887006 | 0.627326915456611 | 0.634679700025495 | true | false | false | true | ||||||||||||||||
| e497784a-f1e7-486e-aeca-3fd8672eb369 | 2026-08-18 15:44 | 2026-08-18 15:44 | 2026-08-18 15:44 | CRWD | CRWD271217C00245000 | call | 245.0000 | 2027-12-17 | 49.9100 | 48.0000 | 51.7000 | 213.4400 | 773535.00 | 49850.00 | 723685.00 | 155 | 18 | 155 | 80 | 1.9375 | 0.582339644354601 | 0.582339644354601 | true | false | false | true | ||||||||||||||||
| 5a740674-18f5-442f-b9e3-41b4c441f965 | 2026-08-18 14:27 | 2026-08-18 14:27 | 2026-08-18 14:27 | CRWD | CRWD280121C00330000 | call | 330.0000 | 2028-01-21 | 32.2100 | 29.2500 | 32.6500 | 212.8500 | 177150.00 | 177150.00 | 0.00 | 55 | 5 | 175 | 127 | 1.37795275590551 | 0.584463904949574 | 0.584966000070281 | true | false | false | true | ||||||||||||||||
| 6ac0c41f-09bf-41c6-8241-5b293bbafd34 | 2026-08-18 13:09 | 2026-08-18 13:09 | 2026-08-18 13:09 | CRWD | CRWD261120C00217500 | call | 217.5000 | 2026-11-20 | 22.0000 | 22.0000 | 22.6000 | 211.1800 | 992223.00 | 0.00 | 992223.00 | 451 | 64 | 451 | 268 | 1.68283582089552 | 0.558197447384696 | 0.558197447384696 | false | false | false | true | ||||||||||||||||
| bd169125-9354-472e-b32f-4b477fbc9d36 | 2026-08-18 10:30 | 2026-08-18 10:30 | 2026-08-18 10:30 | CRWD | CRWD261120C00235000 | call | 235.0000 | 2026-11-20 | 16.1000 | 16.1000 | 16.9500 | 211.0900 | 238295.00 | 3235.00 | 235060.00 | 148 | 41 | 148 | 424 | 0.349056603773585 | 0.568820899134608 | 0.571204219485768 | true | false | false | true | ||||||||||||||||
| 47a26cff-79f9-4b49-aae4-a836dcd369a8 | 2026-08-17 12:15 | 2026-08-17 12:15 | 2026-08-17 12:15 | CRWD | CRWD261120C00287500 | call | 287.5000 | 2026-11-20 | 6.8000 | 6.8000 | 7.2000 | 214.5500 | 274044.00 | 0.00 | 274044.00 | 403 | 50 | 457 | 209 | 2.1866028708134 | 0.586718333724453 | 0.586718333724453 | false | false | false | true | ||||||||||||||||
| 5b516f75-1a7e-4bb4-85cb-6e797e5ab844 | 2026-08-17 11:06 | 2026-08-17 11:05 | 2026-08-17 11:06 | CRWD | CRWD270115P00200000 | put | 200.0000 | 2027-01-15 | 21.9700 | 21.9500 | 22.7500 | 215.1300 | 169150.00 | 22020.00 | 147130.00 | 77 | 37 | 90 | 818 | 0.110024449877751 | 0.575984954531602 | 0.576135160924451 | false | false | false | true | ||||||||||||||||
| 5ad8a394-8e49-4009-9289-8e06adb28b49 | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | CRWD | CRWD260918P00240000 | put | 240.0000 | 2026-09-18 | 31.7700 | 30.1000 | 33.2000 | 214.1650 | 158835.00 | 38145.00 | 25420.00 | 50 | 50 | 50 | 64 | 0.78125 | 0.604070054351514 | 0.613136350526213 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| 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 |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 241013783110.00 |
| 2026-12-01 |
| 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 |