PREVIEW / stock_1hour / 2009-09-11
file: by_date/stock_1hour/2009/2009-09-11.parquet size: 867 KB rows: 41,850 symbols: 3,364
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-11 06:00:00 | AAPL | Stock | 6.1764 | 6.1786 | 6.1764 | 6.1786 | 9520.0 |
| 2009-09-11 07:00:00 | AAPL | Stock | 6.1796 | 6.1939 | 6.1782 | 6.1857 | 132860.0 |
| 2009-09-11 08:00:00 | AAPL | Stock | 6.1875 | 6.1964 | 6.1643 | 6.1796 | 2841440.0 |
| 2009-09-11 09:00:00 | AAPL | Stock | 6.1804 | 6.1882 | 6.1025 | 6.1271 | 75242916.0 |
| 2009-09-11 10:00:00 | AAPL | Stock | 6.1279 | 6.1743 | 6.1089 | 6.1464 | 73279332.0 |
| 2009-09-11 11:00:00 | AAPL | Stock | 6.1468 | 6.1643 | 6.1429 | 6.1511 | 35155148.0 |
| 2009-09-11 12:00:00 | AAPL | Stock | 6.1507 | 6.155 | 6.1107 | 6.1357 | 40000940.0 |
| 2009-09-11 13:00:00 | AAPL | Stock | 6.1357 | 6.1429 | 6.1225 | 6.1236 | 27275220.0 |
| 2009-09-11 14:00:00 | AAPL | Stock | 6.1243 | 6.1511 | 6.1218 | 6.1418 | 31773028.0 |
| 2009-09-11 15:00:00 | AAPL | Stock | 6.1411 | 6.155 | 6.1361 | 6.1486 | 41587924.0 |
| 2009-09-11 16:00:00 | AAPL | Stock | 6.1486 | 6.15 | 6.1318 | 6.1496 | 4514440.0 |
| 2009-09-11 17:00:00 | AAPL | Stock | 6.1393 | 6.1393 | 6.1393 | 6.1393 | 5600.0 |
| 2009-09-11 18:00:00 | AAPL | Stock | 6.1429 | 6.1482 | 6.1375 | 6.1375 | 57876.0 |
| 2009-09-11 19:00:00 | AAPL | Stock | 6.1446 | 6.1446 | 6.1386 | 6.1443 | 132104.0 |
| 2009-09-11 07:00:00 | MSFT | Stock | 25.05 | 25.05 | 25.05 | 25.05 | 100.0 |
| 2009-09-11 08:00:00 | MSFT | Stock | 24.91 | 25.0 | 24.87 | 25.0 | 160854.0 |
| 2009-09-11 09:00:00 | MSFT | Stock | 24.99 | 25.11 | 24.89 | 25.01 | 5588693.0 |
| 2009-09-11 10:00:00 | MSFT | Stock | 25.0 | 25.06 | 24.91 | 25.01 | 6276549.0 |
| 2009-09-11 11:00:00 | MSFT | Stock | 25.01 | 25.17 | 24.95 | 25.02 | 6489544.0 |
| 2009-09-11 12:00:00 | MSFT | Stock | 25.01 | 25.03 | 24.93 | 24.962 | 6138948.0 |
| 2009-09-11 13:00:00 | MSFT | Stock | 24.967 | 25.041 | 24.94 | 24.95 | 3141422.0 |
| 2009-09-11 14:00:00 | MSFT | Stock | 24.95 | 25.053 | 24.93 | 24.96 | 4101937.0 |
| 2009-09-11 15:00:00 | MSFT | Stock | 24.96 | 24.96 | 24.81 | 24.84 | 18342334.0 |
| 2009-09-11 16:00:00 | MSFT | Stock | 24.85 | 24.952 | 24.83 | 24.86 | 1418549.0 |
| 2009-09-11 17:00:00 | MSFT | Stock | 25.0 | 25.0 | 24.82 | 24.84 | 1300.0 |
| 2009-09-11 18:00:00 | MSFT | Stock | 24.83 | 24.83 | 24.83 | 24.83 | 300.0 |
| 2009-09-11 19:00:00 | MSFT | Stock | 24.86 | 24.86 | 24.84 | 24.84 | 597.0 |
| 2009-09-11 08:00:00 | NVDA | Stock | 0.41 | 0.4118 | 0.41 | 0.4118 | 1124640.0 |
| 2009-09-11 09:00:00 | NVDA | Stock | 0.4112 | 0.4122 | 0.408 | 0.4108 | 61336040.0 |
| 2009-09-11 10:00:00 | NVDA | Stock | 0.4108 | 0.4122 | 0.4072 | 0.409 | 91431440.0 |
| 2009-09-11 11:00:00 | NVDA | Stock | 0.4093 | 0.4095 | 0.406 | 0.4075 | 127825840.0 |
| 2009-09-11 12:00:00 | NVDA | Stock | 0.4075 | 0.409 | 0.405 | 0.407 | 123820320.0 |
| 2009-09-11 13:00:00 | NVDA | Stock | 0.407 | 0.4093 | 0.4068 | 0.4075 | 60794080.0 |
| 2009-09-11 14:00:00 | NVDA | Stock | 0.4075 | 0.4082 | 0.4062 | 0.4075 | 54365720.0 |
| 2009-09-11 15:00:00 | NVDA | Stock | 0.4075 | 0.4108 | 0.407 | 0.4078 | 169466360.0 |
| 2009-09-11 16:00:00 | NVDA | Stock | 0.4072 | 0.4081 | 0.4072 | 0.4075 | 2859240.0 |
| 2009-09-11 17:00:00 | NVDA | Stock | 0.4118 | 0.4118 | 0.4118 | 0.4118 | 16000.0 |
| 2009-09-11 18:00:00 | NVDA | Stock | 0.4062 | 0.4062 | 0.4062 | 0.4062 | 48000.0 |
| 2009-09-11 19:00:00 | NVDA | Stock | 0.4062 | 0.4062 | 0.4062 | 0.4062 | 40000.0 |
| 2009-09-11 08:00:00 | AMZN | Stock | 4.2125 | 4.2125 | 4.187 | 4.1925 | 311400.0 |
| 2009-09-11 09:00:00 | AMZN | Stock | 4.195 | 4.25 | 4.194 | 4.207 | 19430520.0 |
| 2009-09-11 10:00:00 | AMZN | Stock | 4.209 | 4.242 | 4.2 | 4.229 | 18293260.0 |
| 2009-09-11 11:00:00 | AMZN | Stock | 4.229 | 4.234 | 4.205 | 4.211 | 10820580.0 |
| 2009-09-11 12:00:00 | AMZN | Stock | 4.211 | 4.223 | 4.188 | 4.204 | 10187440.0 |
| 2009-09-11 13:00:00 | AMZN | Stock | 4.204 | 4.2215 | 4.1985 | 4.2005 | 7418620.0 |
| 2009-09-11 14:00:00 | AMZN | Stock | 4.199 | 4.2345 | 4.197 | 4.2205 | 8792260.0 |
| 2009-09-11 15:00:00 | AMZN | Stock | 4.2205 | 4.239 | 4.217 | 4.225 | 20874400.0 |
| 2009-09-11 16:00:00 | AMZN | Stock | 4.2255 | 4.23 | 4.216 | 4.23 | 2695580.0 |
| 2009-09-11 17:00:00 | AMZN | Stock | 4.2275 | 4.232 | 4.2275 | 4.2275 | 10000.0 |
| 2009-09-11 18:00:00 | AMZN | Stock | 4.2275 | 4.232 | 4.227 | 4.227 | 13800.0 |
> showing 50 of 41,850 rows — these rows as CSV