PREVIEW / stock_1hour / 2004-03-02
file: by_date/stock_1hour/2004/2004-03-02.parquet size: 521 KB rows: 23,630 symbols: 1,732
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2004-03-02 08:00:00 | AAPL | Stock | 0.4309 | 0.4332 | 0.4293 | 0.4298 | 61600.0 |
| 2004-03-02 09:00:00 | AAPL | Stock | 0.4277 | 0.4298 | 0.427 | 0.4275 | 13986168.0 |
| 2004-03-02 10:00:00 | AAPL | Stock | 0.4277 | 0.4304 | 0.4266 | 0.4298 | 34393184.0 |
| 2004-03-02 11:00:00 | AAPL | Stock | 0.4296 | 0.4298 | 0.4279 | 0.4289 | 23579360.0 |
| 2004-03-02 12:00:00 | AAPL | Stock | 0.4288 | 0.4293 | 0.4264 | 0.4268 | 33772984.0 |
| 2004-03-02 13:00:00 | AAPL | Stock | 0.427 | 0.4271 | 0.4256 | 0.4268 | 29040648.0 |
| 2004-03-02 14:00:00 | AAPL | Stock | 0.4268 | 0.4277 | 0.4254 | 0.4275 | 19925192.0 |
| 2004-03-02 15:00:00 | AAPL | Stock | 0.4273 | 0.4284 | 0.4245 | 0.4245 | 43731744.0 |
| 2004-03-02 16:00:00 | AAPL | Stock | 0.4245 | 0.4288 | 0.4245 | 0.4288 | 701120.0 |
| 2004-03-02 17:00:00 | AAPL | Stock | 0.4252 | 0.4252 | 0.4252 | 0.4252 | 746928.0 |
| 2004-03-02 08:00:00 | MSFT | Stock | 26.7 | 26.71 | 26.61 | 26.62 | 133160.0 |
| 2004-03-02 09:00:00 | MSFT | Stock | 26.63 | 26.69 | 26.55 | 26.63 | 5019682.0 |
| 2004-03-02 10:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.55 | 26.61 | 7844900.0 |
| 2004-03-02 11:00:00 | MSFT | Stock | 26.62 | 26.63 | 26.54 | 26.6 | 5519103.0 |
| 2004-03-02 12:00:00 | MSFT | Stock | 26.6 | 26.61 | 26.5 | 26.52 | 9510621.0 |
| 2004-03-02 13:00:00 | MSFT | Stock | 26.52 | 26.57 | 26.43 | 26.48 | 6927041.0 |
| 2004-03-02 14:00:00 | MSFT | Stock | 26.48 | 26.5 | 26.42 | 26.48 | 8119895.0 |
| 2004-03-02 15:00:00 | MSFT | Stock | 26.47 | 26.5 | 26.35 | 26.37 | 11158307.0 |
| 2004-03-02 16:00:00 | MSFT | Stock | 26.39 | 26.6919 | 26.31 | 26.4 | 1368452.0 |
| 2004-03-02 17:00:00 | MSFT | Stock | 26.39 | 26.427 | 26.34 | 26.35 | 118360.0 |
| 2004-03-02 18:00:00 | MSFT | Stock | 26.5251 | 26.5251 | 26.5251 | 26.5251 | 1700.0 |
| 2004-03-02 08:00:00 | NVDA | Stock | 0.1882 | 0.1883 | 0.1882 | 0.1882 | 18876000.0 |
| 2004-03-02 09:00:00 | NVDA | Stock | 0.1882 | 0.1897 | 0.1875 | 0.1881 | 84435000.0 |
| 2004-03-02 10:00:00 | NVDA | Stock | 0.188 | 0.189 | 0.1874 | 0.1884 | 76497840.0 |
| 2004-03-02 11:00:00 | NVDA | Stock | 0.1885 | 0.1887 | 0.1871 | 0.1879 | 119942880.0 |
| 2004-03-02 12:00:00 | NVDA | Stock | 0.1879 | 0.1882 | 0.184 | 0.1842 | 124067760.0 |
| 2004-03-02 13:00:00 | NVDA | Stock | 0.1841 | 0.1858 | 0.1839 | 0.1857 | 89793600.0 |
| 2004-03-02 14:00:00 | NVDA | Stock | 0.1858 | 0.1862 | 0.1846 | 0.1853 | 78836880.0 |
| 2004-03-02 15:00:00 | NVDA | Stock | 0.1852 | 0.1871 | 0.1842 | 0.1846 | 136195080.0 |
| 2004-03-02 16:00:00 | NVDA | Stock | 0.1846 | 0.1881 | 0.1843 | 0.1845 | 1596120.0 |
| 2004-03-02 17:00:00 | NVDA | Stock | 0.1847 | 0.1847 | 0.1844 | 0.1844 | 548640.0 |
| 2004-03-02 18:00:00 | NVDA | Stock | 0.1845 | 0.1846 | 0.1845 | 0.1846 | 324000.0 |
| 2004-03-02 09:00:00 | AMZN | Stock | 2.145 | 2.173 | 2.13 | 2.168 | 11207200.0 |
| 2004-03-02 10:00:00 | AMZN | Stock | 2.1685 | 2.1745 | 2.1435 | 2.151 | 20771440.0 |
| 2004-03-02 11:00:00 | AMZN | Stock | 2.151 | 2.151 | 2.1305 | 2.1356 | 11445940.0 |
| 2004-03-02 12:00:00 | AMZN | Stock | 2.1355 | 2.1365 | 2.112 | 2.117 | 21978880.0 |
| 2004-03-02 13:00:00 | AMZN | Stock | 2.1165 | 2.1225 | 2.0985 | 2.1035 | 17649860.0 |
| 2004-03-02 14:00:00 | AMZN | Stock | 2.103 | 2.1095 | 2.093 | 2.101 | 17551440.0 |
| 2004-03-02 15:00:00 | AMZN | Stock | 2.1015 | 2.121 | 2.1 | 2.1005 | 21107340.0 |
| 2004-03-02 16:00:00 | AMZN | Stock | 2.1005 | 2.1032 | 2.0935 | 2.1005 | 644780.0 |
| 2004-03-02 17:00:00 | AMZN | Stock | 2.0995 | 2.1005 | 2.094 | 2.094 | 1085880.0 |
| 2004-03-02 09:00:00 | CL | Stock | 28.05 | 28.1 | 27.95 | 28.02 | 270800.0 |
| 2004-03-02 10:00:00 | CL | Stock | 28.02 | 28.08 | 27.9 | 28.08 | 472400.0 |
| 2004-03-02 11:00:00 | CL | Stock | 28.08 | 28.1 | 27.98 | 28.05 | 214200.0 |
| 2004-03-02 12:00:00 | CL | Stock | 28.05 | 28.055 | 27.96 | 27.97 | 269600.0 |
| 2004-03-02 13:00:00 | CL | Stock | 27.97 | 28.03 | 27.89 | 27.965 | 326000.0 |
| 2004-03-02 14:00:00 | CL | Stock | 27.965 | 28.04 | 27.955 | 28.02 | 456000.0 |
| 2004-03-02 15:00:00 | CL | Stock | 28.015 | 28.07 | 27.98 | 28.055 | 779200.0 |
| 2004-03-02 16:00:00 | CL | Stock | 28.065 | 28.065 | 28.065 | 28.065 | 1000.0 |
| 2004-03-02 17:00:00 | CL | Stock | 28.065 | 28.065 | 28.0415 | 28.0415 | 53600.0 |
> showing 50 of 23,630 rows — these rows as CSV