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_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 | expirydate |
|---|
| 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 |
|---|
| 3993d526-ab1a-41aa-86d6-203757a92d2a | 2026-08-19 12:40 | 2026-08-19 12:40 | 2026-08-19 12:40 | RKT | RKT260918P00011000 | put | 11.0000 | 2026-09-18 | 0.0900 | 0.0800 | 0.1000 | 14.8050 | 10214.00 | 9459.00 | 656.00 | 1144 | 38 | 7086 | 11891 | 0.595912875283828 | 0.70958588720773 | 0.729474282624776 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 25622320765.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3f44bf7f-94ae-4c91-8ef7-896b46aea696 | 2026-08-19 11:47 | 2026-08-19 11:47 | 2026-08-19 11:47 | RKT | RKT260918P00011000 | put | 11.0000 | 2026-09-18 | 0.0600 | 0.0400 | 0.0600 | 14.8450 | 11358.00 | 11358.00 | 0.00 | 1893 | 32 | 2004 | 11891 | 0.168530821629804 | 0.670123267344362 | 0.670123267344362 | false | false | false | true | ||||||||||||||||
| 5d7eca18-7b70-42e4-9fa1-0412ef07e5ad | 2026-08-19 11:42 | 2026-08-19 11:42 | 2026-08-19 11:42 | RKT | RKT260828C00015000 | call | 15.0000 | 2026-08-28 | 0.4600 | 0.4300 | 0.4600 | 14.8150 | 132986.00 | 132986.00 | 0.00 | 2891 | 17 | 6336 | 4741 | 1.33642691415313 | 0.580017150743174 | 0.580017150743174 | false | false | false | true | ||||||||||||||||
| 7e2ae4e2-815e-455c-9fd3-4599c07a9938 | 2026-08-19 11:41 | 2026-08-19 11:41 | 2026-08-19 11:41 | RKT | RKT260828C00015000 | call | 15.0000 | 2026-08-28 | 0.4500 | 0.4200 | 0.4600 | 14.8100 | 44190.00 | 44190.00 | 0.00 | 982 | 28 | 3336 | 4741 | 0.703649019194263 | 0.574241623279245 | 0.571726202157944 | false | false | false | true | ||||||||||||||||
| 2fd4e486-838f-433d-a5a3-5b853837c860 | 2026-08-19 11:41 | 2026-08-19 11:41 | 2026-08-19 11:41 | RKT | RKT260828C00015000 | call | 15.0000 | 2026-08-28 | 0.4300 | 0.4000 | 0.4400 | 14.7950 | 34787.00 | 34787.00 | 0.00 | 809 | 9 | 2144 | 4741 | 0.452225268930605 | 0.557572738167164 | 0.557572738167164 | false | false | false | true | ||||||||||||||||
| 73a04659-9214-40ba-8d14-de5a2d5e42f4 | 2026-08-19 11:41 | 2026-08-19 11:41 | 2026-08-19 11:41 | RKT | RKT260828C00015000 | call | 15.0000 | 2026-08-28 | 0.4300 | 0.3900 | 0.4300 | 14.7950 | 41401.00 | 41401.00 | 0.00 | 971 | 20 | 1335 | 4741 | 0.281586163256697 | 0.554149965238716 | 0.557572738167164 | false | false | false | true | ||||||||||||||||
| bed872ea-d14b-4305-962b-dd6d43957bcf | 2026-08-19 11:21 | 2026-08-19 11:20 | 2026-08-19 11:20 | RKT | RKT260918C00015000 | call | 15.0000 | 2026-09-18 | 0.8100 | 0.8100 | 0.8400 | 14.8000 | 16201.00 | 0.00 | 16201.00 | 200 | 23 | 663 | 35232 | 0.0188181198910082 | 0.52039105017742 | 0.52039105017742 | true | false | false | true | ||||||||||||||||
| 1c77ac0e-c297-417c-ab67-a96afdaa1c7a | 2026-08-19 11:20 | 2026-08-19 11:20 | 2026-08-19 11:20 | RKT | RKT261016C00015000 | call | 15.0000 | 2026-10-16 | 1.1700 | 1.1700 | 1.2500 | 14.8100 | 23166.00 | 0.00 | 23166.00 | 198 | 6 | 1143 | 4843 | 0.236010737146397 | 0.516745291410157 | 0.516745291410157 | false | false | false | true | ||||||||||||||||
| 237fcac7-7739-423e-bd88-f1cfb171a3e1 | 2026-08-19 11:10 | 2026-08-19 11:10 | 2026-08-19 11:10 | RKT | RKT261218C00014000 | call | 14.0000 | 2026-12-18 | 2.4400 | 2.3300 | 2.4400 | 14.9150 | 30500.00 | 30500.00 | 0.00 | 125 | 5 | 273 | 608 | 0.449013157894737 | 0.560235085059394 | 0.560235085059394 | false | false | false | true | ||||||||||||||||
| 87366007-fc73-4955-b3bb-cf161c866588 | 2026-08-19 10:55 | 2026-08-19 10:55 | 2026-08-19 10:55 | RKT | RKT261016C00015000 | call | 15.0000 | 2026-10-16 | 1.2900 | 1.2900 | 1.3300 | 14.9650 | 14706.00 | 0.00 | 14706.00 | 114 | 7 | 914 | 4843 | 0.188725996283295 | 0.532231413946949 | 0.532231413946949 | false | false | false | true | ||||||||||||||||
| 480ab286-b4b5-45f4-b50c-0d7526b92cbf | 2026-08-19 10:36 | 2026-08-19 10:36 | 2026-08-19 10:36 | RKT | RKT261120P00013000 | put | 13.0000 | 2026-11-20 | 0.7700 | 0.7700 | 0.8200 | 14.9900 | 22176.00 | 0.00 | 22176.00 | 288 | 9 | 291 | 1944 | 0.149691358024691 | 0.57795075041503 | 0.57795075041503 | false | false | false | true | ||||||||||||||||
| ab6e1182-1313-4193-af0f-ed291ea7fb0c | 2026-08-19 10:18 | 2026-08-19 10:18 | 2026-08-19 10:18 | RKT | RKT260821C00014500 | call | 14.5000 | 2026-08-21 | 0.5500 | 0.5100 | 0.5900 | 14.9050 | 25740.00 | 25685.00 | 55.00 | 468 | 7 | 762 | 4828 | 0.157829328914664 | 0.698861854336518 | 0.698861854336518 | false | false | false | true | ||||||||||||||||
| 3df697c9-b3dd-4490-872f-9bd65af6cce3 | 2026-08-18 14:49 | 2026-08-18 14:48 | 2026-08-18 14:48 | RKT | RKT261218C00017000 | call | 17.0000 | 2026-12-18 | 0.8600 | 0.8600 | 0.9200 | 14.0550 | 25456.00 | 0.00 | 25456.00 | 296 | 9 | 306 | 1368 | 0.223684210526316 | 0.54424770154759 | 0.54424770154759 | false | false | false | true | ||||||||||||||||
| eaec6f3d-410a-4465-8ec4-afffcd90a547 | 2026-08-18 13:32 | 2026-08-18 13:32 | 2026-08-18 13:32 | RKT | RKT261016P00013000 | put | 13.0000 | 2026-10-16 | 0.6700 | 0.6700 | 0.7000 | 14.0350 | 17956.00 | 0.00 | 17956.00 | 268 | 11 | 385 | 3654 | 0.10536398467433 | 0.529562485307337 | 0.529562485307337 | false | false | false | true | ||||||||||||||||
| 76ea0842-3b38-4e77-82a2-27599eda44d7 | 2026-08-18 12:12 | 2026-08-18 12:12 | 2026-08-18 12:12 | RKT | RKT260918P00014000 | put | 14.0000 | 2026-09-18 | 0.8000 | 0.7900 | 0.8100 | 14.0448 | 11520.00 | 8000.00 | 3520.00 | 144 | 6 | 305 | 11535 | 0.0264412657130472 | 0.519221400204361 | 0.519221400204361 | false | false | false | true | ||||||||||||||||
| f0f8dded-7e3d-4758-8e80-18982c563ed3 | 2026-08-18 11:09 | 2026-08-18 11:09 | 2026-08-18 11:09 | RKT | RKT260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5400 | 0.5400 | 0.5800 | 14.1700 | 39366.00 | 0.00 | 5454.00 | 729 | 37 | 1338 | 36125 | 0.037038062283737 | 0.517960195244108 | 0.517960195244108 | true | false | false | true | ||||||||||||||||
| c5de5467-5215-44a7-b3db-ccbee02d6b32 | 2026-08-18 11:09 | 2026-08-18 11:09 | 2026-08-18 11:09 | RKT | RKT260918C00015000 | call | 15.0000 | 2026-09-18 | 0.5400 | 0.5300 | 0.5800 | 14.1775 | 15660.00 | 270.00 | 15390.00 | 290 | 10 | 561 | 36125 | 0.0155294117647059 | 0.51611436719876 | 0.51611436719876 | false | false | false | true | ||||||||||||||||
| 13170957-9511-4bd5-b5d6-687ea1006791 | 2026-08-17 15:44 | 2026-08-17 15:44 | 2026-08-17 15:44 | RKT | RKT261218C00018000 | call | 18.0000 | 2026-12-18 | 0.7400 | 0.7400 | 0.8000 | 14.3950 | 59126.00 | 0.00 | 59126.00 | 799 | 27 | 1216 | 16453 | 0.0739074940740291 | 0.537421882683235 | 0.537421882683235 | false | false | false | true | ||||||||||||||||
| 0f893eca-1e4d-4c05-9e5b-a38e58e9054a | 2026-08-17 13:05 | 2026-08-17 13:05 | 2026-08-17 13:05 | RKT | RKT261218C00017000 | call | 17.0000 | 2026-12-18 | 1.0100 | 1.0100 | 1.0600 | 14.4500 | 16362.00 | 0.00 | 16362.00 | 162 | 14 | 163 | 1343 | 0.121370067014147 | 0.544445288681421 | 0.544445288681421 | false | false | false | true | ||||||||||||||||
| ac4945c5-e2b3-4acd-9f4d-645c746fc7ce | 2026-08-17 12:45 | 2026-08-17 12:45 | 2026-08-17 12:45 | RKT | RKT270319P00012000 | put | 12.0000 | 2027-03-19 | 1.1500 | 1.0200 | 1.2100 | 14.4850 | 21390.00 | 21390.00 | 0.00 | 186 | 5 | 196 | 28 | 7 | 0.573381043177458 | 0.573381043177458 | false | false | false | true | false | |||||||||||||||
| 23059c75-6302-41ac-b930-5cecf6aad81b | 2026-08-17 11:53 | 2026-08-17 11:53 | 2026-08-17 11:53 | RKT | RKT261218C00018000 | call | 18.0000 | 2026-12-18 | 0.8100 | 0.7600 | 0.8500 | 14.5500 | 33696.00 | 81.00 | 33615.00 | 416 | 24 | 416 | 16453 | 0.0252841427095363 | 0.544808674641031 | 0.544808674641031 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 25622320765.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |