Query Result
Loading...Loading chart...
1SELECT
2 datetime::date as day,
3 close,
4 open,
5 high,
6 low
7FROM
8 "@coindesk.indices.coindesk_spot_price"
9WHERE
10 instrument = 'AAVE-USD'
11 AND datetime >= CURRENT_DATE - INTERVAL 90 DAY
12ORDER BY
13 datetime ASC| day | close | open | high | low |
|---|---|---|---|---|
| 2026-01-07 | 167.732558085276 | 176.122361424783 | 176.141828468026 | 165.86475509323 |
| 2026-01-08 | 164.215196034632 | 167.732558085276 | 169.089385255889 | 161.232300416534 |
| 2026-01-09 | 165.504327472727 | 164.215196034632 | 170.182453767792 | 162.672917508362 |
| 2026-01-10 | 164.726751271376 | 165.504327472727 | 167.097031177939 | 163.244420631208 |
| 2026-01-11 | 167.690783383482 | 164.726751271376 | 171.275063711284 | 164.501639384306 |
| 2026-01-12 | 164.842232323922 | 167.690783383482 | 171.322261843902 | 160.964927812057 |
| 2026-01-13 | 177.559595923722 | 164.842232323922 | 179.713051423914 | 164.605853173634 |
| 2026-01-14 | 178.405863351234 | 177.559595923722 | 180.022915428298 | 174.138365553909 |
| 2026-01-15 | 171.677063327392 | 178.405863351234 | 178.405877494382 | 169.257491313929 |
| 2026-01-16 | 175.299952991952 | 171.677063327392 | 176.357898675806 | 168.570413470038 |
| 2026-01-17 | 173.809080663222 | 175.299952991952 | 177.358055653899 | 173.434832098001 |
| 2026-01-18 | 168.862174746805 | 173.809080663222 | 177.206476599668 | 168.777390543744 |
| 2026-01-19 | 163.864451726979 | 168.862174746805 | 168.863420738762 | 161.503609164865 |
| 2026-01-20 | 153.152660149166 | 163.864451726979 | 164.426990910785 | 152.137597012 |
| 2026-01-21 | 159.395363510604 | 153.152660149166 | 163.324176424561 | 152.031913305492 |
| 2026-01-22 | 157.156465899832 | 159.395363510604 | 161.723983385122 | 155.081618679523 |
| 2026-01-23 | 156.932469953284 | 157.156465899832 | 161.160878868027 | 154.82062255995 |
| 2026-01-24 | 156.134420021997 | 156.932469953284 | 157.912582690649 | 155.216946523207 |
| 2026-01-25 | 147.880850155803 | 156.134420021997 | 156.70057011709 | 145.558984602478 |
| 2026-01-26 | 154.124522518345 | 147.880850155803 | 155.109415113618 | 147.60401360461 |
| 2026-01-27 | 158.839594957192 | 154.124522518345 | 159.697540232676 | 152.856813816415 |
| 2026-01-28 | 160.023012849088 | 158.839594957192 | 163.704133773115 | 156.407880907547 |
| 2026-01-29 | 147.13768690151 | 160.023012849088 | 160.140787279149 | 142.985514898921 |
| 2026-01-30 | 137.877317854367 | 147.13768690151 | 147.646719279322 | 135.509261746434 |
| 2026-01-31 | 128.921768625495 | 137.877317854367 | 138.411186236017 | 117.433936112597 |
| 2026-02-01 | 124.204344719887 | 128.921768625495 | 130.289996921422 | 121.639164875856 |
| 2026-02-02 | 128.349227678779 | 124.204344719887 | 130.992160513935 | 120.552615524243 |
| 2026-02-03 | 125.173087189188 | 128.349227678779 | 130.607985180718 | 120.914801015456 |
| 2026-02-04 | 123.540928401802 | 125.173087189188 | 128.651442715801 | 119.473794635547 |
| 2026-02-05 | 100.826570142813 | 123.540928401802 | 125.285845659091 | 98.6400396733549 |
| 2026-02-06 | 114.004251933352 | 100.826570142813 | 115.328062291574 | 93.4794779498781 |
| 2026-02-07 | 113.95286417219 | 114.004251933352 | 116.316405586312 | 110.140471475745 |
| 2026-02-08 | 112.461502730231 | 113.95286417219 | 115.132567581867 | 111.032501324632 |
| 2026-02-09 | 112.660931677825 | 112.461502730231 | 115.055214051284 | 108.912075264608 |
| 2026-02-10 | 109.378165372206 | 112.660931677825 | 113.200943918747 | 107.896572919218 |
| 2026-02-11 | 107.492529022764 | 109.378165372206 | 113.839064583895 | 104.693892848626 |
| 2026-02-12 | 114.868976142269 | 107.492529022764 | 115.494447648107 | 105.702356897863 |
| 2026-02-13 | 118.861708215008 | 114.868976142269 | 120.458328839766 | 109.695192155628 |
| 2026-02-14 | 128.304299988157 | 118.861708215008 | 130.93339101689 | 118.398806128885 |
| 2026-02-15 | 125.812965709957 | 128.304299988157 | 131.856814407914 | 122.65556064715 |
| 2026-02-16 | 127.030651145496 | 125.812965709957 | 129.108970272987 | 123.231051796519 |
| 2026-02-17 | 126.536781378106 | 127.030651145496 | 130.703708303481 | 123.813744278847 |
| 2026-02-18 | 123.002399165844 | 126.536781378106 | 128.747668949068 | 120.786776190547 |
| 2026-02-19 | 124.779914220541 | 123.002399165844 | 125.016745911917 | 120.00273533894 |
| 2026-02-20 | 115.930607450878 | 124.779914220541 | 126.818049486079 | 114.864809750203 |
| 2026-02-21 | 121.575340625998 | 115.930607450878 | 124.823383211108 | 114.662418554375 |
| 2026-02-22 | 117.987795655244 | 121.575340625998 | 121.673537251934 | 117.182778725828 |
| 2026-02-23 | 114.624948148257 | 117.987795655244 | 119.785801535447 | 111.349374680132 |
| 2026-02-24 | 114.463517638858 | 114.624948148257 | 116.498151069303 | 111.613278615453 |
| 2026-02-25 | 119.199884021256 | 114.463517638858 | 124.338725531838 | 113.958868197764 |
| 2026-02-26 | 114.536541253671 | 119.199884021256 | 120.611775049711 | 110.797461656755 |
| 2026-02-27 | 113.048725589832 | 114.536541253671 | 121.625117252401 | 110.369392451732 |
| 2026-02-28 | 112.038580157972 | 113.048725589832 | 113.645349625491 | 104.971253496001 |
| 2026-03-01 | 113.622611769189 | 112.038580157972 | 118.685486833036 | 110.7209983628 |
| 2026-03-02 | 122.207301742503 | 113.622611769189 | 126.846703025476 | 112.292238217638 |
| 2026-03-03 | 111.125187253086 | 122.207301742503 | 122.958275761938 | 107.957597152066 |
| 2026-03-04 | 115.876935767294 | 111.125187253086 | 118.789161245108 | 109.345406514074 |
| 2026-03-05 | 116.821207637592 | 115.876935767294 | 119.74445724109 | 114.090692434021 |
| 2026-03-06 | 110.964773540064 | 116.821207637592 | 118.555388421997 | 109.346566549762 |
| 2026-03-07 | 108.832304221313 | 110.964773540064 | 111.399648083404 | 108.255885438152 |
| 2026-03-08 | 105.528581157033 | 108.832304221313 | 109.603169335987 | 103.930269732419 |
| 2026-03-09 | 106.710973695416 | 105.528581157033 | 109.304318512202 | 104.924893212402 |
| 2026-03-10 | 111.736393319542 | 106.710973695416 | 114.781568463695 | 106.487573211964 |
| 2026-03-11 | 110.270731410704 | 111.736393319542 | 113.946128380322 | 108.970582834531 |
| 2026-03-12 | 111.61466567022 | 110.270731410704 | 112.881913388441 | 106.979488123618 |
| 2026-03-13 | 112.311131603936 | 111.61466567022 | 119.037526799395 | 111.179101313645 |
| 2026-03-14 | 111.194648816263 | 112.311131603936 | 113.421193452735 | 109.848472996363 |
| 2026-03-15 | 116.340296419499 | 111.194648816263 | 117.843443528303 | 109.935879349219 |
| 2026-03-16 | 122.291959512526 | 116.340296419499 | 124.734121631838 | 115.932270711104 |
| 2026-03-17 | 119.683010395596 | 122.291959512526 | 123.578557186758 | 119.439647986674 |
| 2026-03-18 | 115.315481499604 | 119.683010395596 | 122.143283778241 | 112.621802562916 |
| 2026-03-19 | 111.621642287841 | 115.315481499604 | 119.095707780628 | 110.746406925091 |
| 2026-03-20 | 111.234024119109 | 111.621642287841 | 113.356977573025 | 108.47722383283 |
| 2026-03-21 | 108.318143576663 | 111.234024119109 | 112.614860198804 | 107.796116637902 |
| 2026-03-22 | 106.285768991897 | 108.318143576663 | 110.176759937284 | 105.003948569592 |
| 2026-03-23 | 110.265386655827 | 106.285768991897 | 112.112784923016 | 104.618558160452 |
| 2026-03-24 | 112.249877938469 | 110.265386655827 | 112.400797300554 | 107.942693122203 |
| 2026-03-25 | 112.561794041246 | 112.249877938469 | 116.420027615167 | 111.245701048208 |
| 2026-03-26 | 105.144987471009 | 112.561794041246 | 112.757428750028 | 103.98529859036 |
| 2026-03-27 | 98.6508685064047 | 105.144987471009 | 106.683041502719 | 97.6254423498052 |
| 2026-03-28 | 96.8110710597791 | 98.6508685064047 | 98.6852307711315 | 96.2405407915411 |
| 2026-03-29 | 95.4104234939635 | 96.8110710597791 | 97.9626910664124 | 92.9036906642386 |
| 2026-03-30 | 96.7856344112718 | 95.4104234939635 | 99.9418396850171 | 95.2203232025717 |
| 2026-03-31 | 98.1647374266111 | 96.7856344112718 | 99.2336859629728 | 95.3889928232917 |
| 2026-04-01 | 98.0079762208693 | 98.1647374266111 | 101.074689237286 | 96.9425709517673 |
| 2026-04-02 | 94.3218205513717 | 98.0079762208693 | 99.0226569405368 | 92.3620337703861 |
| 2026-04-03 | 94.8418135076249 | 94.3218205513717 | 96.0641759017022 | 93.9048019221521 |
| 2026-04-04 | 94.5856659254723 | 94.8418135076249 | 95.4626658975739 | 94.2140406427866 |
| 2026-04-05 | 94.0306581095918 | 94.5856659254723 | 94.8350362789623 | 90.6332111009131 |