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_alerts375,978 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 |
|---|
| 5717de1f-2553-4327-a357-afc849924465 | 2026-08-17 15:55 | 2026-08-17 15:55 | 2026-08-17 15:55 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 0.3500 | 0.2500 | 0.3500 | 7.1650 | 17500.00 | 17500.00 | 0.00 | 500 | 33 | 652 | 2029 | 0.32134056185313 | 1.05160807555504 | 1.05160807555504 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 2344375524.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 176d687d-e64e-41a4-af42-de35df31d660 | 2026-08-19 15:28 | 2026-08-19 15:28 | 2026-08-19 15:28 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 0.7500 | 0.4500 | 0.7500 | 8.8650 | 11925.00 | 11925.00 | 0.00 | 159 | 15 | 534 | 2390 | 0.223430962343096 | 1.05383718773325 | 1.05383718773325 | false | false | false | true | ||||||||||||||||
| 3c969326-d8ae-4d43-b3a9-a2a648eb1816 | 2026-08-25 10:31 | 2026-08-25 10:31 | 2026-08-25 10:31 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.9000 | 1.6000 | 1.9000 | 11.6950 | 11388.00 | 11388.00 | 0.00 | 60 | 10 | 63 | 5515 | 0.0114233907524932 | 1.108533690357 | 1.108533690357 | true | false | false | true | ||||||||||||||||
| d59a9b06-d398-430d-a48f-e9f9afeb82a3 | 2026-08-25 10:31 | 2026-08-25 10:31 | 2026-08-25 10:31 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.9000 | 1.6500 | 1.9000 | 11.6950 | 83790.00 | 83790.00 | 0.00 | 441 | 20 | 504 | 5515 | 0.0913871260199456 | 1.108533690357 | 1.108533690357 | true | false | false | true | ||||||||||||||||
| 523b1fc5-c12d-4eb6-a17a-de97f9ac38c2 | 2026-08-25 15:45 | 2026-08-25 15:45 | 2026-08-25 15:45 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.8500 | 1.8500 | 1.9000 | 11.8650 | 55500.00 | 0.00 | 55500.00 | 300 | 7 | 2281 | 5515 | 0.413599274705349 | 1.05909620435919 | 1.05909620435919 | false | false | false | true | ||||||||||||||||
| fa6f53cc-08fc-4eb9-8c7c-9bb544a0a0a8 | 2026-08-26 13:34 | 2026-08-26 13:34 | 2026-08-26 13:34 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.7000 | 1.5500 | 1.7000 | 11.4459 | 34000.00 | 34000.00 | 0.00 | 200 | 11 | 591 | 6545 | 0.0902979373567609 | 1.08043030768012 | 1.08043030768012 | false | false | false | true | ||||||||||||||||
| dbe26018-be76-43da-bf0c-2e4103e74e79 | 2026-08-26 13:41 | 2026-08-26 13:41 | 2026-08-26 13:41 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.7000 | 1.6000 | 1.7000 | 11.4750 | 17000.00 | 17000.00 | 0.00 | 100 | 7 | 891 | 6545 | 0.136134453781513 | 1.07526397453999 | 1.07526397453999 | false | false | false | true | ||||||||||||||||
| d68d7d89-a5e1-452a-a5f2-34eacfba1d52 | 2026-08-26 13:42 | 2026-08-26 13:42 | 2026-08-26 13:42 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.7000 | 1.6000 | 1.7000 | 11.4700 | 32300.00 | 32300.00 | 0.00 | 190 | 7 | 1181 | 6545 | 0.180443086325439 | 1.07615092963089 | 1.07615092963089 | false | false | false | true | ||||||||||||||||
| fc2ea2fc-723b-4753-9999-792ff95a954b | 2026-08-27 10:09 | 2026-08-27 10:09 | 2026-08-27 10:09 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 2.4700 | 2.3500 | 2.5500 | 13.2350 | 12374.00 | 12374.00 | 0.00 | 50 | 6 | 307 | 7420 | 0.0413746630727763 | 1.04343338535084 | 1.04343338535084 | false | false | false | true | ||||||||||||||||
| 314e21ea-8205-411b-a24d-b8a9ac340c1b | 2026-08-28 10:01 | 2026-08-28 10:01 | 2026-08-28 10:01 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 2.5700 | 2.3500 | 2.7000 | 13.4400 | 43688.00 | 43688.00 | 0.00 | 170 | 5 | 171 | 7288 | 0.0234632272228321 | 1.0410081553473 | 1.0410081553473 | false | false | false | true | ||||||||||||||||
| eac2b54a-26f3-4a4c-852e-e7a280043f5f | 2026-08-31 09:57 | 2026-08-31 09:57 | 2026-08-31 09:57 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.4700 | 1.4000 | 1.7000 | 11.3028 | 26519.00 | 0.00 | 26519.00 | 180 | 5 | 189 | 7554 | 0.0250198570293884 | 1.04941299120337 | 1.04941299120337 | false | false | false | true | ||||||||||||||||
| adc8264d-3fd7-47a1-8803-f301ee8b380a | 2026-09-08 12:02 | 2026-09-08 12:02 | 2026-09-08 12:02 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.8300 | 1.7500 | 1.8500 | 12.2750 | 45716.00 | 45716.00 | 0.00 | 250 | 6 | 263 | 7234 | 0.0363560962123307 | 1.04371245370917 | 1.04371245370917 | false | false | false | true | ||||||||||||||||
| 9acdd78a-0cab-4b86-bcf9-3a28055df44b | 2026-09-09 11:26 | 2026-09-09 11:26 | 2026-09-09 11:26 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.6500 | 1.6500 | 1.7500 | 12.0600 | 33000.00 | 0.00 | 33000.00 | 200 | 7 | 902 | 7359 | 0.122571001494768 | 1.02106643360791 | 1.02106643360791 | false | false | false | true | ||||||||||||||||
| 2ea7d565-35ae-41d4-9374-cec28cf1ee39 | 2026-09-15 14:45 | 2026-09-15 14:45 | 2026-09-15 14:45 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.0000 | 1.0000 | 1.0500 | 10.7500 | 25000.00 | 0.00 | 25000.00 | 250 | 17 | 255 | 6980 | 0.0365329512893983 | 0.998691237884816 | 0.998691237884816 | false | false | false | true | ||||||||||||||||
| be1674ab-2e1a-4041-ac85-0b150529721c | 2026-09-15 14:45 | 2026-09-15 14:45 | 2026-09-15 14:45 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.0000 | 0.9500 | 1.0500 | 10.7300 | 50000.00 | 0.00 | 49900.00 | 500 | 15 | 755 | 6980 | 0.108166189111748 | 1.00216414629855 | 1.00216414629855 | false | false | false | true | ||||||||||||||||
| 52b35fda-2c02-4a64-81d8-1c977703acce | 2026-09-15 14:46 | 2026-09-15 14:45 | 2026-09-15 14:45 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 1.0000 | 1.0000 | 1.0500 | 10.7100 | 25000.00 | 0.00 | 25000.00 | 250 | 15 | 1005 | 6980 | 0.143982808022923 | 1.00564219342127 | 1.00564219342127 | false | false | false | true | ||||||||||||||||
| bf0f9d9e-89d2-4a8f-ac42-2209baf5e9eb | 2026-09-23 10:02 | 2026-09-23 10:01 | 2026-09-23 10:01 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 2.5500 | 2.4500 | 2.5500 | 14.0000 | 10193.00 | 10193.00 | 0.00 | 40 | 5 | 64 | 7001 | 0.00914155120697043 | 1.03856318676375 | 1.03487041102022 | false | false | false | true | ||||||||||||||||
| c3a8b062-8025-4669-86fc-f4c7770778aa | 2026-09-23 12:24 | 2026-09-23 12:24 | 2026-09-23 12:24 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 2.3000 | 2.2500 | 2.4000 | 13.7900 | 92000.00 | 0.00 | 92000.00 | 400 | 6 | 881 | 7001 | 0.125839165833452 | 1.020298242301 | 1.020298242301 | false | false | false | true | ||||||||||||||||
| 8d1cb2a8-c6f1-43c6-a29b-3bb238ccacd9 | 2026-09-23 14:23 | 2026-09-23 14:23 | 2026-09-23 14:23 | PURR | PURR261218C00015000 | call | 15.0000 | 2026-12-18 | 2.2500 | 2.2000 | 2.3000 | 13.0000 | 292500.00 | 234000.00 | 25425.00 | 1300 | 7 | 2259 | 7001 | 0.322668190258534 | 1.02569706739155 | 1.02569706739155 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2344375524.00 |
| 2026-08-27 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 2757856102.00 |
| — |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2757856102.00 |
| — |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:24:45.701241Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 2757856102.00 |
| — |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:27:32.623000Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |