PREVIEW / stock_1hour / 2004-10-22
file: by_date/stock_1hour/2004/2004-10-22.parquet size: 528 KB rows: 24,612 symbols: 1,836
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-10-22 08:00:00 | AAPL | Stock | 0.8563 | 0.8563 | 0.8546 | 0.8546 | 260680.0 |
| 2004-10-22 09:00:00 | AAPL | Stock | 0.8546 | 0.8546 | 0.8393 | 0.8429 | 114882768.0 |
| 2004-10-22 10:00:00 | AAPL | Stock | 0.843 | 0.8477 | 0.8396 | 0.8454 | 90348776.0 |
| 2004-10-22 11:00:00 | AAPL | Stock | 0.8453 | 0.8484 | 0.8446 | 0.8446 | 42598696.0 |
| 2004-10-22 12:00:00 | AAPL | Stock | 0.8446 | 0.8502 | 0.8438 | 0.8473 | 47210968.0 |
| 2004-10-22 13:00:00 | AAPL | Stock | 0.8473 | 0.8509 | 0.8459 | 0.8473 | 43958824.0 |
| 2004-10-22 14:00:00 | AAPL | Stock | 0.8473 | 0.8482 | 0.8446 | 0.8464 | 51832144.0 |
| 2004-10-22 15:00:00 | AAPL | Stock | 0.8464 | 0.8489 | 0.8427 | 0.8473 | 74414424.0 |
| 2004-10-22 16:00:00 | AAPL | Stock | 0.8473 | 0.8521 | 0.8464 | 0.8466 | 7794360.0 |
| 2004-10-22 17:00:00 | AAPL | Stock | 0.8466 | 0.8466 | 0.846 | 0.846 | 1272320.0 |
| 2004-10-22 08:00:00 | MSFT | Stock | 28.07 | 28.45 | 27.6 | 28.43 | 1195091.0 |
| 2004-10-22 09:00:00 | MSFT | Stock | 28.43 | 28.51 | 28.0 | 28.119 | 16083941.0 |
| 2004-10-22 10:00:00 | MSFT | Stock | 28.12 | 28.18 | 28.01 | 28.03 | 17844805.0 |
| 2004-10-22 11:00:00 | MSFT | Stock | 28.03 | 28.09 | 27.95 | 28.02 | 11941097.0 |
| 2004-10-22 12:00:00 | MSFT | Stock | 28.02 | 28.05 | 27.8 | 27.81 | 9211830.0 |
| 2004-10-22 13:00:00 | MSFT | Stock | 27.81 | 27.9 | 27.72 | 27.789 | 12255644.0 |
| 2004-10-22 14:00:00 | MSFT | Stock | 27.79 | 27.85 | 27.68 | 27.69 | 10279446.0 |
| 2004-10-22 15:00:00 | MSFT | Stock | 27.69 | 27.8 | 27.59 | 27.73 | 17829846.0 |
| 2004-10-22 16:00:00 | MSFT | Stock | 27.73 | 27.78 | 27.6 | 27.75 | 1525101.0 |
| 2004-10-22 17:00:00 | MSFT | Stock | 27.75 | 27.75 | 27.7 | 27.74 | 223270.0 |
| 2004-10-22 18:00:00 | MSFT | Stock | 27.74 | 27.74 | 27.74 | 27.74 | 1100.0 |
| 2004-10-22 08:00:00 | NVDA | Stock | 0.1192 | 0.1192 | 0.1152 | 0.1152 | 72000.0 |
| 2004-10-22 09:00:00 | NVDA | Stock | 0.1179 | 0.1188 | 0.1104 | 0.1154 | 84315480.0 |
| 2004-10-22 10:00:00 | NVDA | Stock | 0.1155 | 0.1156 | 0.1145 | 0.1147 | 91601760.0 |
| 2004-10-22 11:00:00 | NVDA | Stock | 0.1146 | 0.1147 | 0.1132 | 0.1134 | 74766360.0 |
| 2004-10-22 12:00:00 | NVDA | Stock | 0.1133 | 0.1141 | 0.1133 | 0.1137 | 48845160.0 |
| 2004-10-22 13:00:00 | NVDA | Stock | 0.1137 | 0.1137 | 0.1126 | 0.1131 | 72142080.0 |
| 2004-10-22 14:00:00 | NVDA | Stock | 0.113 | 0.1135 | 0.1115 | 0.1116 | 86387880.0 |
| 2004-10-22 15:00:00 | NVDA | Stock | 0.1116 | 0.1121 | 0.1103 | 0.1107 | 202174200.0 |
| 2004-10-22 16:00:00 | NVDA | Stock | 0.1108 | 0.1117 | 0.1107 | 0.1112 | 18135840.0 |
| 2004-10-22 17:00:00 | NVDA | Stock | 0.1115 | 0.1131 | 0.1106 | 0.1131 | 3957960.0 |
| 2004-10-22 18:00:00 | NVDA | Stock | 0.1112 | 0.1112 | 0.1112 | 0.1112 | 114000.0 |
| 2004-10-22 08:00:00 | AMZN | Stock | 1.814 | 1.829 | 1.797 | 1.815 | 6544480.0 |
| 2004-10-22 09:00:00 | AMZN | Stock | 1.82 | 1.9685 | 1.788 | 1.794 | 157010080.0 |
| 2004-10-22 10:00:00 | AMZN | Stock | 1.793 | 1.7975 | 1.756 | 1.7695 | 133132780.0 |
| 2004-10-22 11:00:00 | AMZN | Stock | 1.7695 | 1.775 | 1.747 | 1.75 | 65535580.0 |
| 2004-10-22 12:00:00 | AMZN | Stock | 1.75 | 1.7625 | 1.7385 | 1.7465 | 51485380.0 |
| 2004-10-22 13:00:00 | AMZN | Stock | 1.7465 | 1.75 | 1.7 | 1.7135 | 79187400.0 |
| 2004-10-22 14:00:00 | AMZN | Stock | 1.713 | 1.731 | 1.711 | 1.7185 | 50551140.0 |
| 2004-10-22 15:00:00 | AMZN | Stock | 1.718 | 1.743 | 1.7065 | 1.7235 | 91673960.0 |
| 2004-10-22 16:00:00 | AMZN | Stock | 1.7235 | 1.7325 | 1.7215 | 1.7325 | 7296520.0 |
| 2004-10-22 17:00:00 | AMZN | Stock | 1.7325 | 1.7325 | 1.725 | 1.725 | 1004840.0 |
| 2004-10-22 18:00:00 | AMZN | Stock | 1.7315 | 1.7345 | 1.7315 | 1.7335 | 60200.0 |
| 2004-10-22 09:00:00 | CL | Stock | 22.925 | 22.97 | 22.9 | 22.935 | 604200.0 |
| 2004-10-22 10:00:00 | CL | Stock | 22.93 | 22.975 | 22.89 | 22.95 | 1009600.0 |
| 2004-10-22 11:00:00 | CL | Stock | 22.95 | 22.975 | 22.9 | 22.91 | 420400.0 |
| 2004-10-22 12:00:00 | CL | Stock | 22.91 | 22.945 | 22.9 | 22.935 | 363800.0 |
| 2004-10-22 13:00:00 | CL | Stock | 22.93 | 22.955 | 22.915 | 22.94 | 803400.0 |
| 2004-10-22 14:00:00 | CL | Stock | 22.94 | 22.97 | 22.875 | 22.89 | 839600.0 |
| 2004-10-22 15:00:00 | CL | Stock | 22.89 | 22.94 | 22.835 | 22.855 | 1121600.0 |
> showing 50 of 24,612 rows — these rows as CSV