PREVIEW / stock_1hour / 2004-10-04
file: by_date/stock_1hour/2004/2004-10-04.parquet size: 509 KB rows: 24,503 symbols: 1,835
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-04 08:00:00 | AAPL | Stock | 0.6971 | 0.7045 | 0.6948 | 0.6996 | 1079176.0 |
| 2004-10-04 09:00:00 | AAPL | Stock | 0.6996 | 0.6996 | 0.6927 | 0.693 | 77925176.0 |
| 2004-10-04 10:00:00 | AAPL | Stock | 0.6932 | 0.6995 | 0.6932 | 0.6955 | 124620608.0 |
| 2004-10-04 11:00:00 | AAPL | Stock | 0.6957 | 0.6966 | 0.6938 | 0.6946 | 57766576.0 |
| 2004-10-04 12:00:00 | AAPL | Stock | 0.6946 | 0.6955 | 0.6929 | 0.6945 | 38351152.0 |
| 2004-10-04 13:00:00 | AAPL | Stock | 0.6945 | 0.6952 | 0.693 | 0.6936 | 52685976.0 |
| 2004-10-04 14:00:00 | AAPL | Stock | 0.6936 | 0.6955 | 0.6929 | 0.6934 | 36893416.0 |
| 2004-10-04 15:00:00 | AAPL | Stock | 0.6936 | 0.6954 | 0.6925 | 0.6925 | 153393688.0 |
| 2004-10-04 16:00:00 | AAPL | Stock | 0.6925 | 0.6964 | 0.6911 | 0.6927 | 18354784.0 |
| 2004-10-04 17:00:00 | AAPL | Stock | 0.6927 | 0.6973 | 0.6914 | 0.6927 | 468720.0 |
| 2004-10-04 08:00:00 | MSFT | Stock | 28.25 | 28.54 | 28.25 | 28.5 | 166449.0 |
| 2004-10-04 09:00:00 | MSFT | Stock | 28.48 | 28.53 | 28.35 | 28.4 | 8907521.0 |
| 2004-10-04 10:00:00 | MSFT | Stock | 28.41 | 28.43 | 28.22 | 28.23 | 10949172.0 |
| 2004-10-04 11:00:00 | MSFT | Stock | 28.24 | 28.28 | 28.08 | 28.14 | 9925238.0 |
| 2004-10-04 12:00:00 | MSFT | Stock | 28.15 | 28.19 | 28.08 | 28.1 | 4959081.0 |
| 2004-10-04 13:00:00 | MSFT | Stock | 28.1 | 28.25 | 28.09 | 28.19 | 4007534.0 |
| 2004-10-04 14:00:00 | MSFT | Stock | 28.19 | 28.27 | 28.12 | 28.14 | 6512260.0 |
| 2004-10-04 15:00:00 | MSFT | Stock | 28.14 | 28.21 | 28.07 | 28.09 | 10688257.0 |
| 2004-10-04 16:00:00 | MSFT | Stock | 28.09 | 28.3737 | 28.09 | 28.12 | 2629869.0 |
| 2004-10-04 17:00:00 | MSFT | Stock | 28.13 | 28.13 | 28.1 | 28.11 | 48673.0 |
| 2004-10-04 18:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 138.0 |
| 2004-10-04 08:00:00 | NVDA | Stock | 0.1275 | 0.1292 | 0.1275 | 0.1292 | 480000.0 |
| 2004-10-04 09:00:00 | NVDA | Stock | 0.1292 | 0.13 | 0.1268 | 0.1295 | 122248320.0 |
| 2004-10-04 10:00:00 | NVDA | Stock | 0.1295 | 0.1306 | 0.1292 | 0.1299 | 136574640.0 |
| 2004-10-04 11:00:00 | NVDA | Stock | 0.1299 | 0.1307 | 0.1292 | 0.1298 | 67706880.0 |
| 2004-10-04 12:00:00 | NVDA | Stock | 0.1298 | 0.1301 | 0.1292 | 0.1293 | 42084480.0 |
| 2004-10-04 13:00:00 | NVDA | Stock | 0.1293 | 0.1312 | 0.1292 | 0.1309 | 71612160.0 |
| 2004-10-04 14:00:00 | NVDA | Stock | 0.131 | 0.1312 | 0.1303 | 0.1304 | 50520960.0 |
| 2004-10-04 15:00:00 | NVDA | Stock | 0.1304 | 0.1307 | 0.129 | 0.1295 | 155400360.0 |
| 2004-10-04 16:00:00 | NVDA | Stock | 0.1292 | 0.1297 | 0.129 | 0.1296 | 5447280.0 |
| 2004-10-04 17:00:00 | NVDA | Stock | 0.1296 | 0.1296 | 0.1295 | 0.1295 | 235440.0 |
| 2004-10-04 08:00:00 | AMZN | Stock | 2.03 | 2.037 | 2.024 | 2.025 | 492000.0 |
| 2004-10-04 09:00:00 | AMZN | Stock | 2.0325 | 2.071 | 2.0275 | 2.061 | 34761160.0 |
| 2004-10-04 10:00:00 | AMZN | Stock | 2.06 | 2.075 | 2.045 | 2.0645 | 35743520.0 |
| 2004-10-04 11:00:00 | AMZN | Stock | 2.065 | 2.084 | 2.0635 | 2.0805 | 25935800.0 |
| 2004-10-04 12:00:00 | AMZN | Stock | 2.0805 | 2.082 | 2.0665 | 2.0695 | 13977840.0 |
| 2004-10-04 13:00:00 | AMZN | Stock | 2.069 | 2.0735 | 2.0525 | 2.0725 | 15294440.0 |
| 2004-10-04 14:00:00 | AMZN | Stock | 2.0725 | 2.082 | 2.0675 | 2.0695 | 13171940.0 |
| 2004-10-04 15:00:00 | AMZN | Stock | 2.069 | 2.0695 | 2.049 | 2.049 | 30033260.0 |
| 2004-10-04 16:00:00 | AMZN | Stock | 2.05 | 2.0515 | 2.045 | 2.0505 | 1982280.0 |
| 2004-10-04 17:00:00 | AMZN | Stock | 2.045 | 2.0505 | 2.045 | 2.0505 | 417840.0 |
| 2004-10-04 18:00:00 | AMZN | Stock | 2.0475 | 2.0637 | 2.0455 | 2.0637 | 83900.0 |
| 2004-10-04 08:00:00 | CL | Stock | 22.47 | 22.47 | 22.47 | 22.47 | 1800.0 |
| 2004-10-04 09:00:00 | CL | Stock | 22.475 | 22.56 | 22.32 | 22.375 | 2414600.0 |
| 2004-10-04 10:00:00 | CL | Stock | 22.37 | 22.525 | 22.235 | 22.525 | 2372000.0 |
| 2004-10-04 11:00:00 | CL | Stock | 22.52 | 22.655 | 22.49 | 22.5 | 2013000.0 |
| 2004-10-04 12:00:00 | CL | Stock | 22.5 | 22.605 | 22.495 | 22.535 | 1126200.0 |
| 2004-10-04 13:00:00 | CL | Stock | 22.53 | 22.55 | 22.475 | 22.485 | 1429200.0 |
| 2004-10-04 14:00:00 | CL | Stock | 22.485 | 22.495 | 22.425 | 22.445 | 2577600.0 |
| 2004-10-04 15:00:00 | CL | Stock | 22.445 | 22.505 | 22.435 | 22.45 | 2641200.0 |
> showing 50 of 24,503 rows — these rows as CSV