PREVIEW / stock_1hour / 2004-11-02
file: by_date/stock_1hour/2004/2004-11-02.parquet size: 523 KB rows: 24,335 symbols: 1,868
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-11-02 08:00:00 | AAPL | Stock | 0.9393 | 0.9402 | 0.9384 | 0.9384 | 304584.0 |
| 2004-11-02 09:00:00 | AAPL | Stock | 0.9393 | 0.9436 | 0.9348 | 0.9393 | 89458824.0 |
| 2004-11-02 10:00:00 | AAPL | Stock | 0.9396 | 0.9464 | 0.9382 | 0.9461 | 125361824.0 |
| 2004-11-02 11:00:00 | AAPL | Stock | 0.9461 | 0.9477 | 0.9446 | 0.9463 | 61409488.0 |
| 2004-11-02 12:00:00 | AAPL | Stock | 0.9464 | 0.9516 | 0.9455 | 0.9475 | 73247104.0 |
| 2004-11-02 13:00:00 | AAPL | Stock | 0.9475 | 0.9584 | 0.9471 | 0.9552 | 85598968.0 |
| 2004-11-02 14:00:00 | AAPL | Stock | 0.9552 | 0.9657 | 0.9529 | 0.9605 | 122600576.0 |
| 2004-11-02 15:00:00 | AAPL | Stock | 0.9605 | 0.9613 | 0.9502 | 0.9532 | 142985192.0 |
| 2004-11-02 16:00:00 | AAPL | Stock | 0.9532 | 0.958 | 0.953 | 0.958 | 7761096.0 |
| 2004-11-02 17:00:00 | AAPL | Stock | 0.9442 | 0.958 | 0.9442 | 0.958 | 112056.0 |
| 2004-11-02 18:00:00 | AAPL | Stock | 0.9554 | 0.9588 | 0.9554 | 0.9588 | 114576.0 |
| 2004-11-02 08:00:00 | MSFT | Stock | 28.11 | 28.15 | 28.11 | 28.13 | 7800.0 |
| 2004-11-02 09:00:00 | MSFT | Stock | 28.12 | 28.31 | 28.08 | 28.3 | 9041181.0 |
| 2004-11-02 10:00:00 | MSFT | Stock | 28.29 | 28.46 | 28.26 | 28.39 | 14212119.0 |
| 2004-11-02 11:00:00 | MSFT | Stock | 28.4 | 28.46 | 28.37 | 28.43 | 9382624.0 |
| 2004-11-02 12:00:00 | MSFT | Stock | 28.43 | 28.44 | 28.36 | 28.41 | 6382082.0 |
| 2004-11-02 13:00:00 | MSFT | Stock | 28.42 | 28.46 | 28.36 | 28.44 | 5606551.0 |
| 2004-11-02 14:00:00 | MSFT | Stock | 28.44 | 28.47 | 28.22 | 28.3 | 9416798.0 |
| 2004-11-02 15:00:00 | MSFT | Stock | 28.3 | 28.3 | 28.029 | 28.24 | 23754532.0 |
| 2004-11-02 16:00:00 | MSFT | Stock | 28.24 | 28.41 | 28.11 | 28.41 | 8853272.0 |
| 2004-11-02 17:00:00 | MSFT | Stock | 28.2 | 28.3163 | 28.11 | 28.11 | 39938.0 |
| 2004-11-02 18:00:00 | MSFT | Stock | 28.21 | 28.21 | 28.11 | 28.18 | 26314.0 |
| 2004-11-02 08:00:00 | NVDA | Stock | 0.1225 | 0.1225 | 0.1225 | 0.1225 | 138000.0 |
| 2004-11-02 09:00:00 | NVDA | Stock | 0.1225 | 0.1248 | 0.1218 | 0.1244 | 113324280.0 |
| 2004-11-02 10:00:00 | NVDA | Stock | 0.1244 | 0.1273 | 0.1243 | 0.1269 | 273816840.0 |
| 2004-11-02 11:00:00 | NVDA | Stock | 0.1268 | 0.1275 | 0.1262 | 0.1267 | 130976760.0 |
| 2004-11-02 12:00:00 | NVDA | Stock | 0.1267 | 0.127 | 0.1258 | 0.126 | 56123520.0 |
| 2004-11-02 13:00:00 | NVDA | Stock | 0.126 | 0.1262 | 0.125 | 0.1256 | 154782120.0 |
| 2004-11-02 14:00:00 | NVDA | Stock | 0.1256 | 0.1262 | 0.1242 | 0.1249 | 136634640.0 |
| 2004-11-02 15:00:00 | NVDA | Stock | 0.1249 | 0.125 | 0.1234 | 0.1247 | 206723400.0 |
| 2004-11-02 16:00:00 | NVDA | Stock | 0.1247 | 0.1249 | 0.1234 | 0.1243 | 7118160.0 |
| 2004-11-02 17:00:00 | NVDA | Stock | 0.1243 | 0.1243 | 0.1237 | 0.1237 | 360000.0 |
| 2004-11-02 18:00:00 | NVDA | Stock | 0.1246 | 0.1246 | 0.1246 | 0.1246 | 48000.0 |
| 2004-11-02 08:00:00 | AMZN | Stock | 1.76 | 1.765 | 1.76 | 1.765 | 38000.0 |
| 2004-11-02 09:00:00 | AMZN | Stock | 1.765 | 1.775 | 1.755 | 1.761 | 17742040.0 |
| 2004-11-02 10:00:00 | AMZN | Stock | 1.761 | 1.7835 | 1.7595 | 1.7785 | 32300320.0 |
| 2004-11-02 11:00:00 | AMZN | Stock | 1.7785 | 1.8245 | 1.778 | 1.818 | 45786360.0 |
| 2004-11-02 12:00:00 | AMZN | Stock | 1.8185 | 1.819 | 1.7975 | 1.7995 | 21655520.0 |
| 2004-11-02 13:00:00 | AMZN | Stock | 1.7995 | 1.81 | 1.7905 | 1.8035 | 22410000.0 |
| 2004-11-02 14:00:00 | AMZN | Stock | 1.8045 | 1.814 | 1.8 | 1.8015 | 26710340.0 |
| 2004-11-02 15:00:00 | AMZN | Stock | 1.8005 | 1.8175 | 1.795 | 1.811 | 50574300.0 |
| 2004-11-02 16:00:00 | AMZN | Stock | 1.8115 | 1.8125 | 1.805 | 1.811 | 1413740.0 |
| 2004-11-02 17:00:00 | AMZN | Stock | 1.8105 | 1.812 | 1.8075 | 1.8075 | 39200.0 |
| 2004-11-02 18:00:00 | AMZN | Stock | 1.8075 | 1.8075 | 1.7982 | 1.7982 | 98000.0 |
| 2004-11-02 09:00:00 | CL | Stock | 22.475 | 22.48 | 22.245 | 22.25 | 533800.0 |
| 2004-11-02 10:00:00 | CL | Stock | 22.25 | 22.46 | 22.18 | 22.445 | 1455600.0 |
| 2004-11-02 11:00:00 | CL | Stock | 22.45 | 22.65 | 22.445 | 22.65 | 989400.0 |
| 2004-11-02 12:00:00 | CL | Stock | 22.655 | 22.7 | 22.625 | 22.685 | 553000.0 |
| 2004-11-02 13:00:00 | CL | Stock | 22.68 | 22.72 | 22.625 | 22.675 | 824000.0 |
| 2004-11-02 14:00:00 | CL | Stock | 22.68 | 22.75 | 22.56 | 22.6 | 1248200.0 |
> showing 50 of 24,335 rows — these rows as CSV