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_alerts523,327 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 |
|---|
| 465c34f8-70fe-4e4f-bade-6e3370631cff | 2026-08-21 12:04 | 2026-08-21 12:04 | 2026-08-21 12:04 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.2000 | 0.2000 | 0.2400 | 15.9900 | 12660.00 | 0.00 | 12660.00 | 633 | 51 | 7903 | 5781 | 1.36706452170905 | 1.51748599287152 | 1.51748599287152 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6489005338.00 | 2026-11-02 | 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 |
| 67d77e90-b85c-4a44-9424-00ed4982e550 | 2026-08-21 10:57 | 2026-08-21 10:57 | 2026-08-21 10:57 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.1600 | 0.1100 | 0.1600 | 15.6350 | 14736.00 | 14736.00 | 0.00 | 921 | 51 | 3939 | 5781 | 0.681370005189414 | 2.03857924269979 | 2.03857924269979 | true | false | false | true | false | |||||||||||||||
| 0ad9ab08-e683-4252-9777-eedcd1ba2448 | 2026-08-20 10:51 | 2026-08-20 10:51 | 2026-08-20 10:51 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4500 | 0.4200 | 0.4500 | 15.7950 | 12812.00 | 12240.00 | 572.00 | 285 | 12 | 3157 | 4727 | 0.667865453776179 | 1.61383065960052 | 1.64432513174096 | false | false | false | true | false | |||||||||||||||
| c0968480-6ea4-4a2a-98aa-bcd4abd90834 | 2026-08-20 10:00 | 2026-08-20 10:00 | 2026-08-20 10:00 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4900 | 0.4900 | 0.5000 | 15.8329 | 23716.00 | 0.00 | 23716.00 | 484 | 7 | 1706 | 4727 | 0.360905436852126 | 1.71236848486939 | 1.71236848486939 | true | false | false | true | false | |||||||||||||||
| f15d108b-83b1-42ad-8da6-749b8bf6d08f | 2026-08-20 10:00 | 2026-08-20 10:00 | 2026-08-20 10:00 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4900 | 0.4500 | 0.4900 | 15.8299 | 12642.00 | 12642.00 | 0.00 | 258 | 20 | 778 | 4727 | 0.164586418447218 | 1.71665648944914 | 1.71665648944914 | false | false | false | true | false | |||||||||||||||
| 9173c172-cddc-48a3-96e7-19658b0ee923 | 2026-08-19 13:46 | 2026-08-19 13:46 | 2026-08-19 13:46 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.6300 | 0.6100 | 0.6400 | 16.0000 | 12978.00 | 3528.00 | 0.00 | 206 | 8 | 5192 | 3324 | 1.56197352587244 | 1.33050897646202 | 1.33050897646202 | false | false | false | true | false | |||||||||||||||
| 1f873ecb-12d6-4aee-873e-52288220afdf | 2026-08-19 11:20 | 2026-08-19 11:20 | 2026-08-19 11:20 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4800 | 0.4800 | 0.5100 | 15.6820 | 14256.00 | 0.00 | 14256.00 | 297 | 21 | 4205 | 3324 | 1.2650421179302 | 1.33627937569717 | 1.33627937569717 | false | false | false | true | false | |||||||||||||||
| 479416c4-4233-4cf7-85b5-edbca98266e3 | 2026-08-19 09:47 | 2026-08-19 09:47 | 2026-08-19 09:47 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4400 | 0.4300 | 0.4700 | 15.4300 | 32015.00 | 0.00 | 31795.00 | 724 | 25 | 1789 | 3324 | 0.53820697954272 | 1.49400914042035 | 1.48021512509739 | true | false | false | true | false | |||||||||||||||
| 3ce5b8a4-c823-400f-b61f-7f834c2b4e9f | 2026-08-19 09:43 | 2026-08-19 09:43 | 2026-08-19 09:43 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.4000 | 0.3800 | 0.4000 | 15.3050 | 15960.00 | 15960.00 | 0.00 | 399 | 5 | 1052 | 3324 | 0.316486161251504 | 1.49717310569466 | 1.49717310569466 | false | false | false | true | false | |||||||||||||||
| d9a0b492-c347-419a-945c-91b4345b661d | 2026-08-18 15:38 | 2026-08-18 15:38 | 2026-08-18 15:38 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.7500 | 0.7500 | 0.7600 | 15.9150 | 30000.00 | 0.00 | 3675.00 | 400 | 42 | 3288 | 854 | 3.85011709601874 | 1.36878406506002 | 1.36878406506002 | false | false | false | true | false | |||||||||||||||
| 7e9d5b33-6761-4e4b-be42-23f7fc43bc45 | 2026-08-18 15:07 | 2026-08-18 15:07 | 2026-08-18 15:07 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.7400 | 0.7000 | 0.7500 | 15.8950 | 12580.00 | 11470.00 | 1110.00 | 170 | 9 | 2682 | 854 | 3.14051522248244 | 1.36901399934397 | 1.36901399934397 | true | false | false | true | false | |||||||||||||||
| 71240f1a-b98c-42a6-bae4-4c2f629ed434 | 2026-08-18 15:07 | 2026-08-18 15:07 | 2026-08-18 15:07 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 0.7400 | 0.6900 | 0.7600 | 15.9000 | 137237.00 | 102815.00 | 15702.00 | 1857 | 139 | 2452 | 854 | 2.8711943793911 | 1.37559035067094 | 1.36462194026386 | true | false | false | true | ||||||||||||||||
| a128f354-278f-4915-949c-019f271ab3f8 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | CIFR | CIFR260821C00016000 | call | 16.0000 | 2026-08-21 | 2.0800 | 2.0800 | 2.5500 | 18.1300 | 20844.00 | 0.00 | 19968.00 | 100 | 8 | 100 | 863 | 0.115874855156431 | 1.67220615764219 | 1.67220615764219 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 6489005338.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |