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_alerts425,429 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 |
|---|
| 676e393e-695d-4a54-8bed-4e2aff99a113 | 2026-09-24 14:15 | 2026-09-24 14:15 | 2026-09-24 14:15 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 10.3700 | 10.3000 | 10.7500 | 774.5404 | 207398.00 | 0.00 | 207398.00 | 200 | 5 | 491 | 669 | 0.733931240657698 | 0.441410583635042 | 0.441410583635042 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1640836123547.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T18:15:40.223371Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 07fefe42-0bb6-41e6-a0c4-e77f44e14cb9 | 2026-09-24 10:07 | 2026-09-24 10:07 | 2026-09-24 10:07 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 14.0100 | 14.0000 | 14.5000 | 760.8000 | 84068.00 | 7025.00 | 61643.00 | 60 | 16 | 94 | 669 | 0.14050822122571 | 0.448649858661918 | 0.449473422016966 | true | false | false | true | false | |||||||||||||||
| e0cd8ce3-f659-4043-8a06-68c81930510b | 2026-09-22 09:50 | 2026-09-22 09:50 | 2026-09-22 09:50 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 19.8400 | 19.3500 | 19.9000 | 744.1430 | 13890.00 | 7940.00 | 5950.00 | 7 | 6 | 106 | 530 | 0.2 | 0.443893838954826 | 0.443173084675365 | true | false | false | true | false | |||||||||||||||
| 4932b74c-6041-4383-a34d-2217822c5dee | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 21.9200 | 21.6000 | 22.1500 | 740.1336 | 39462.00 | 30710.00 | 8752.00 | 18 | 8 | 82 | 530 | 0.154716981132075 | 0.451687729891921 | 0.454241074736551 | true | false | false | true | false | |||||||||||||||
| e3e99105-ae3a-4e7b-9a51-4f50e13c0bcb | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 23.2100 | 23.1000 | 24.0000 | 735.4050 | 127660.00 | 9300.00 | 118360.00 | 55 | 20 | 57 | 530 | 0.107547169811321 | 0.44768755706766 | 0.446285986988365 | true | false | false | true | ||||||||||||||||
| 31e49f0b-3f7c-4771-9d89-045166d225d1 | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 21.8500 | 21.8500 | 21.9500 | 743.1200 | 39330.00 | 0.00 | 37145.00 | 18 | 15 | 1139 | 47 | 24.2340425531915 | 0.45860626963089 | 0.45860626963089 | false | false | false | true | false | |||||||||||||||
| 05d9282c-3c79-4d8d-acea-ba8c7f1e3132 | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 19.5000 | 19.4500 | 19.5000 | 750.3600 | 31200.00 | 31200.00 | 0.00 | 16 | 11 | 1107 | 47 | 23.5531914893617 | 0.459000312398788 | 0.459000312398788 | true | false | false | true | false | |||||||||||||||
| 9e7e24bb-2cbc-469e-904e-d77c099ab437 | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 19.5000 | 19.4500 | 19.5500 | 749.3600 | 17550.00 | 0.00 | 15600.00 | 9 | 5 | 1086 | 47 | 23.1063829787234 | 0.454479020975685 | 0.454479020975685 | false | false | false | true | false | |||||||||||||||
| 81019eda-fa0f-4a59-aaac-73021b90031e | 2026-09-21 14:40 | 2026-09-21 14:40 | 2026-09-21 14:40 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 20.4500 | 20.4000 | 20.5500 | 748.2636 | 14315.00 | 4090.00 | 8180.00 | 7 | 7 | 1043 | 47 | 22.1914893617021 | 0.463027003271898 | 0.463027003271898 | false | false | false | true | false | |||||||||||||||
| 2e641b91-2f5e-494c-93e0-83cc9698ee9d | 2026-09-21 12:25 | 2026-09-21 12:25 | 2026-09-21 12:25 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 26.3000 | 26.1500 | 26.6500 | 726.7550 | 47340.00 | 44710.00 | 2630.00 | 18 | 16 | 837 | 47 | 17.8085106382979 | 0.435200066745894 | 0.435200066745894 | true | false | false | true | false | |||||||||||||||
| 4a0a09d2-f617-4621-be3d-690114e582cd | 2026-09-21 12:24 | 2026-09-21 12:24 | 2026-09-21 12:24 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 26.2500 | 26.2000 | 26.4000 | 726.9150 | 36745.00 | 0.00 | 36745.00 | 14 | 7 | 819 | 47 | 17.4255319148936 | 0.435163272938641 | 0.435413097063506 | false | false | false | true | false | |||||||||||||||
| 0d61ce90-6523-4f21-899e-0752357d06b4 | 2026-09-21 12:23 | 2026-09-21 12:23 | 2026-09-21 12:23 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 26.2500 | 26.2500 | 26.5500 | 727.3800 | 39375.00 | 0.00 | 39375.00 | 15 | 6 | 805 | 47 | 17.1276595744681 | 0.435884709584654 | 0.437988682820556 | true | false | false | true | false | |||||||||||||||
| 7eb38397-1425-4579-8ac3-9132d75f4a8b | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 28.1000 | 28.0000 | 28.2500 | 721.8713 | 22480.00 | 5620.00 | 16860.00 | 8 | 6 | 665 | 47 | 14.1489361702128 | 0.431629528968493 | 0.431629528968493 | false | false | false | true | false | |||||||||||||||
| 85006036-4f88-4636-b4c1-29f7fff666f0 | 2026-09-21 11:55 | 2026-09-21 11:54 | 2026-09-21 11:54 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 28.1500 | 28.1500 | 28.2500 | 721.2200 | 295590.00 | 5645.00 | 289945.00 | 105 | 5 | 656 | 47 | 13.9574468085106 | 0.429156380964883 | 0.429156380964883 | true | false | false | true | ||||||||||||||||
| 2ad00e46-5b65-4e17-8a83-ccd2450eaa7c | 2026-09-21 11:46 | 2026-09-21 11:46 | 2026-09-21 11:46 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 28.8700 | 28.8500 | 28.9000 | 718.8200 | 184765.00 | 72250.00 | 112515.00 | 64 | 12 | 459 | 47 | 9.76595744680851 | 0.42426811350943 | 0.42426811350943 | false | false | false | true | ||||||||||||||||
| a4835c54-cdab-41a6-b837-2cdfd3c919b7 | 2026-09-21 11:38 | 2026-09-21 11:38 | 2026-09-21 11:38 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 29.7100 | 29.6500 | 29.9000 | 715.0000 | 20795.00 | 5945.00 | 14850.00 | 7 | 6 | 371 | 47 | 7.8936170212766 | 0.415780718185556 | 0.415780718185556 | false | false | false | true | false | |||||||||||||||
| 9f7b4406-8a15-4726-aea8-4723d681237a | 2026-09-21 10:57 | 2026-09-21 10:57 | 2026-09-21 10:57 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 31.4500 | 31.3500 | 31.4500 | 711.3200 | 53465.00 | 53465.00 | 0.00 | 17 | 9 | 318 | 47 | 6.76595744680851 | 0.411355955869505 | 0.411355955869505 | true | false | false | true | false | |||||||||||||||
| 91414840-738f-4825-a5ad-c3776d98d056 | 2026-09-21 10:24 | 2026-09-21 10:24 | 2026-09-21 10:24 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 31.1000 | 30.9500 | 31.1500 | 712.0000 | 24880.00 | 24880.00 | 0.00 | 8 | 6 | 206 | 47 | 4.38297872340426 | 0.414566242610223 | 0.415116222423884 | true | false | false | true | false | |||||||||||||||
| acc31a01-dec4-474d-a113-9532c000712f | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | META | META261016P00715000 | put | 715.0000 | 2026-10-16 | 30.4000 | 30.1500 | 30.4500 | 714.0650 | 15200.00 | 15200.00 | 0.00 | 5 | 5 | 126 | 47 | 2.68085106382979 | 0.414969586607758 | 0.414969586607758 | false | false | false | true | false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 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-21T19:36:57.124687Z"} |
| 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:42:48.011261Z"} |
| 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:25:44.384112Z"} |
| 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:25:44.384112Z"} |
| 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:25:44.384112Z"} |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:56:02.019393Z"} |
| 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-21T15:39:42.073830Z"} |
| 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:59:04.068372Z"} |
| 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:24:21.810098Z"} |
| 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:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |