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_alerts326,449 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 |
|---|
| b91e468f-505a-46a8-9eee-8965e8fcd202 | 2026-09-22 14:04 | 2026-09-22 14:04 | 2026-09-22 14:04 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 31.3500 | 30.7500 | 31.3500 | 740.0350 | 53295.00 | 53295.00 | 0.00 | 17 | 6 | 423 | 652 | 0.648773006134969 | 0.434558009019133 | 0.433151085733613 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1624286634087.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 8963169d-e947-4f07-9efe-93c45e3a6acc | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 35.8000 | 35.7500 | 36.0000 | 743.0300 | 46540.00 | 0.00 | 46540.00 | 13 | 6 | 1599 | 426 | 3.75352112676056 | 0.461458169983033 | 0.461424315449351 | false | false | false | true | ||||||||||||||||
| bffa5008-d53e-42c2-8d81-ef9cb37315d2 | 2026-09-21 15:48 | 2026-09-21 15:48 | 2026-09-21 15:48 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 38.7500 | 38.5000 | 38.7500 | 748.0000 | 19375.00 | 19375.00 | 0.00 | 5 | 5 | 1539 | 426 | 3.61267605633803 | 0.462371347858687 | 0.462371347858687 | false | false | false | true | false | |||||||||||||||
| 21ad74e7-82ab-4773-9669-8118020a2ab1 | 2026-09-21 15:33 | 2026-09-21 15:33 | 2026-09-21 15:33 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 38.9000 | 38.9000 | 39.1000 | 749.0000 | 19450.00 | 0.00 | 19450.00 | 5 | 5 | 1481 | 426 | 3.47652582159624 | 0.456998826241103 | 0.456998826241103 | false | false | false | true | false | |||||||||||||||
| a2e1347c-fd2e-450d-8365-c6a75390ec87 | 2026-09-21 14:58 | 2026-09-21 14:58 | 2026-09-21 14:58 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 38.1100 | 37.9000 | 38.2000 | 746.4350 | 22864.00 | 22864.00 | 0.00 | 6 | 5 | 1392 | 426 | 3.26760563380282 | 0.467601566122626 | 0.467601566122626 | false | false | false | true | false | |||||||||||||||
| ab0a06da-c195-4e31-be64-a9b8e3cc3767 | 2026-09-21 13:57 | 2026-09-21 13:57 | 2026-09-21 13:57 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 35.6000 | 35.4500 | 35.6000 | 742.3499 | 89000.00 | 89000.00 | 0.00 | 25 | 8 | 955 | 426 | 2.24178403755869 | 0.463434176364762 | 0.463434176364762 | false | false | false | true | false | |||||||||||||||
| b10d7402-e3cb-4df4-89dc-a4e02a4a75dd | 2026-09-21 13:44 | 2026-09-21 13:44 | 2026-09-21 13:44 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 36.1200 | 36.1000 | 36.4500 | 743.0000 | 72245.00 | 3615.00 | 68630.00 | 20 | 8 | 864 | 426 | 2.02816901408451 | 0.460782063487978 | 0.461259733443554 | true | false | false | true | ||||||||||||||||
| 4216928a-e711-4823-96f3-dd9f2665c721 | 2026-09-21 13:20 | 2026-09-21 13:20 | 2026-09-21 13:20 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 30.8500 | 30.8000 | 31.0500 | 735.0000 | 30845.00 | 0.00 | 30845.00 | 10 | 6 | 770 | 426 | 1.8075117370892 | 0.444462953454737 | 0.443811959268285 | false | false | false | true | false | |||||||||||||||
| 3332c7c8-5b76-443a-840a-0ffa0db9cd46 | 2026-09-21 13:17 | 2026-09-21 13:17 | 2026-09-21 13:17 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 30.3000 | 30.2500 | 30.5500 | 734.0000 | 21210.00 | 15150.00 | 6060.00 | 7 | 5 | 749 | 426 | 1.75821596244131 | 0.445075662885549 | 0.445075662885549 | true | false | false | true | ||||||||||||||||
| b903c3e2-24ab-4556-b298-b1c0190110a4 | 2026-09-21 12:41 | 2026-09-21 12:41 | 2026-09-21 12:41 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 27.4000 | 27.3500 | 27.6000 | 728.5600 | 30140.00 | 2740.00 | 27400.00 | 11 | 6 | 681 | 426 | 1.59859154929577 | 0.443729263260872 | 0.444483568237061 | false | false | false | true | ||||||||||||||||
| e7bef84a-53e3-4d85-9791-e0ba380f450a | 2026-09-21 12:39 | 2026-09-21 12:38 | 2026-09-21 12:38 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 27.4500 | 27.4500 | 27.6500 | 728.5950 | 21960.00 | 0.00 | 21960.00 | 8 | 5 | 654 | 426 | 1.53521126760563 | 0.444933667374739 | 0.444933667374739 | false | false | false | true | false | |||||||||||||||
| dcf5c333-1719-4ad4-b7bd-13336453234b | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 26.8500 | 26.8500 | 27.1000 | 727.2901 | 83235.00 | 0.00 | 83235.00 | 31 | 11 | 645 | 426 | 1.51408450704225 | 0.444164031196447 | 0.444820937629962 | true | false | false | true | ||||||||||||||||
| 604fe02e-a01b-4507-9ff2-b113820029eb | 2026-09-21 12:08 | 2026-09-21 12:07 | 2026-09-21 12:07 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 24.1500 | 23.9500 | 24.2000 | 723.2401 | 21735.00 | 16905.00 | 4830.00 | 9 | 8 | 534 | 426 | 1.25352112676056 | 0.432744080804466 | 0.432513008047788 | true | false | false | true | ||||||||||||||||
| c85e58a8-5e7c-47bd-9b65-d99fb1a3384b | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 24.2500 | 24.1000 | 24.2500 | 722.2079 | 55775.00 | 55775.00 | 0.00 | 23 | 14 | 484 | 426 | 1.13615023474178 | 0.439527050932752 | 0.439797407111243 | true | false | false | true | ||||||||||||||||
| 58b6c48a-7f09-480f-a96a-de65d365453a | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 22.3000 | 22.1000 | 22.3250 | 719.4150 | 37910.00 | 37910.00 | 0.00 | 17 | 8 | 424 | 426 | 0.995305164319249 | 0.42912913767647 | 0.42912913767647 | true | false | false | true | false | |||||||||||||||
| eea1cc20-6d75-4a22-9287-140ce2e7d084 | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 22.1000 | 22.1000 | 22.3000 | 719.1900 | 15470.00 | 0.00 | 15470.00 | 7 | 6 | 404 | 426 | 0.948356807511737 | 0.427202711885644 | 0.42764873238422 | false | false | false | true | false | |||||||||||||||
| 15d70245-6ad5-4291-b438-2f4f3dcde211 | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 19.3000 | 19.2500 | 19.4000 | 713.0000 | 13510.00 | 11580.00 | 1930.00 | 7 | 5 | 173 | 426 | 0.406103286384977 | 0.417995050826794 | 0.417995050826794 | false | false | false | true | ||||||||||||||||
| 64492d30-42fa-4ab9-a747-16238f5b7edc | 2026-09-21 10:13 | 2026-09-21 10:13 | 2026-09-21 10:13 | META | META261016C00745000 | call | 745.0000 | 2026-10-16 | 19.1000 | 19.1000 | 19.3000 | 713.7400 | 15280.00 | 0.00 | 15280.00 | 8 | 6 | 165 | 426 | 0.387323943661972 | 0.415017885670833 | 0.415655094833651 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:14:40.112451Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |