PREVIEW / stock_1hour / 2003-08-29
file: by_date/stock_1hour/2003/2003-08-29.parquet size: 455 KB rows: 21,475 symbols: 1,608
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-29 09:00:00 | AAPL | Stock | 0.3955 | 0.3975 | 0.3937 | 0.3961 | 22914640.0 |
| 2003-08-29 10:00:00 | AAPL | Stock | 0.3963 | 0.408 | 0.3955 | 0.4054 | 71170344.0 |
| 2003-08-29 11:00:00 | AAPL | Stock | 0.4054 | 0.4071 | 0.4021 | 0.4021 | 32988312.0 |
| 2003-08-29 12:00:00 | AAPL | Stock | 0.4021 | 0.4032 | 0.4004 | 0.4014 | 29416352.0 |
| 2003-08-29 13:00:00 | AAPL | Stock | 0.4016 | 0.4045 | 0.4014 | 0.4045 | 18640552.0 |
| 2003-08-29 14:00:00 | AAPL | Stock | 0.4043 | 0.4054 | 0.4027 | 0.4041 | 25680984.0 |
| 2003-08-29 15:00:00 | AAPL | Stock | 0.4041 | 0.4054 | 0.4018 | 0.4043 | 32491704.0 |
| 2003-08-29 16:00:00 | AAPL | Stock | 0.4036 | 0.4043 | 0.4014 | 0.4014 | 3343200.0 |
| 2003-08-29 17:00:00 | AAPL | Stock | 0.4009 | 0.4009 | 0.4009 | 0.4009 | 5600.0 |
| 2003-08-29 18:00:00 | AAPL | Stock | 0.4041 | 0.4041 | 0.4041 | 0.4041 | 2021600.0 |
| 2003-08-29 08:00:00 | MSFT | Stock | 26.33 | 26.5 | 26.33 | 26.45 | 38900.0 |
| 2003-08-29 09:00:00 | MSFT | Stock | 26.45 | 26.542 | 26.35 | 26.532 | 5848872.0 |
| 2003-08-29 10:00:00 | MSFT | Stock | 26.53 | 26.551 | 26.35 | 26.42 | 7013831.0 |
| 2003-08-29 11:00:00 | MSFT | Stock | 26.41 | 26.47 | 26.37 | 26.4 | 3075943.0 |
| 2003-08-29 12:00:00 | MSFT | Stock | 26.4 | 26.44 | 26.36 | 26.43 | 2719960.0 |
| 2003-08-29 13:00:00 | MSFT | Stock | 26.42 | 26.49 | 26.4 | 26.47 | 2067670.0 |
| 2003-08-29 14:00:00 | MSFT | Stock | 26.48 | 26.5 | 26.44 | 26.49 | 2141054.0 |
| 2003-08-29 15:00:00 | MSFT | Stock | 26.48 | 26.55 | 26.4 | 26.53 | 6025869.0 |
| 2003-08-29 16:00:00 | MSFT | Stock | 26.53 | 26.54 | 26.4368 | 26.53 | 1413873.0 |
| 2003-08-29 17:00:00 | MSFT | Stock | 26.52 | 26.53 | 26.5 | 26.5 | 345950.0 |
| 2003-08-29 18:00:00 | MSFT | Stock | 26.52 | 26.53 | 26.5 | 26.53 | 264000.0 |
| 2003-08-29 08:00:00 | NVDA | Stock | 0.1493 | 0.1494 | 0.1489 | 0.1491 | 588000.0 |
| 2003-08-29 09:00:00 | NVDA | Stock | 0.1491 | 0.1507 | 0.1486 | 0.1505 | 73799640.0 |
| 2003-08-29 10:00:00 | NVDA | Stock | 0.1505 | 0.1515 | 0.1497 | 0.1505 | 110139840.0 |
| 2003-08-29 11:00:00 | NVDA | Stock | 0.1505 | 0.1515 | 0.1501 | 0.1507 | 53876520.0 |
| 2003-08-29 12:00:00 | NVDA | Stock | 0.1507 | 0.1515 | 0.1504 | 0.1506 | 45247440.0 |
| 2003-08-29 13:00:00 | NVDA | Stock | 0.1507 | 0.1514 | 0.1504 | 0.1512 | 41112360.0 |
| 2003-08-29 14:00:00 | NVDA | Stock | 0.1513 | 0.1521 | 0.1512 | 0.1515 | 52861680.0 |
| 2003-08-29 15:00:00 | NVDA | Stock | 0.1515 | 0.1518 | 0.1504 | 0.1507 | 96753000.0 |
| 2003-08-29 16:00:00 | NVDA | Stock | 0.1512 | 0.1517 | 0.1506 | 0.1517 | 3949080.0 |
| 2003-08-29 17:00:00 | NVDA | Stock | 0.1512 | 0.1512 | 0.1512 | 0.1512 | 114000.0 |
| 2003-08-29 18:00:00 | NVDA | Stock | 0.1513 | 0.1513 | 0.1513 | 0.1513 | 1464000.0 |
| 2003-08-29 08:00:00 | AMZN | Stock | 2.258 | 2.295 | 2.258 | 2.295 | 71600.0 |
| 2003-08-29 09:00:00 | AMZN | Stock | 2.284 | 2.2995 | 2.284 | 2.296 | 11034720.0 |
| 2003-08-29 10:00:00 | AMZN | Stock | 2.296 | 2.302 | 2.286 | 2.292 | 15972660.0 |
| 2003-08-29 11:00:00 | AMZN | Stock | 2.2935 | 2.2975 | 2.292 | 2.2925 | 11435500.0 |
| 2003-08-29 12:00:00 | AMZN | Stock | 2.2925 | 2.303 | 2.2895 | 2.3 | 15544500.0 |
| 2003-08-29 13:00:00 | AMZN | Stock | 2.2995 | 2.315 | 2.2995 | 2.315 | 19400680.0 |
| 2003-08-29 14:00:00 | AMZN | Stock | 2.314 | 2.3165 | 2.298 | 2.307 | 16014280.0 |
| 2003-08-29 15:00:00 | AMZN | Stock | 2.307 | 2.3195 | 2.3025 | 2.319 | 19720860.0 |
| 2003-08-29 16:00:00 | AMZN | Stock | 2.319 | 2.322 | 2.3102 | 2.318 | 5094500.0 |
| 2003-08-29 17:00:00 | AMZN | Stock | 2.318 | 2.322 | 2.3144 | 2.3144 | 204000.0 |
| 2003-08-29 18:00:00 | AMZN | Stock | 2.3175 | 2.322 | 2.3175 | 2.319 | 378000.0 |
| 2003-08-29 09:00:00 | CL | Stock | 27.7 | 27.845 | 27.69 | 27.845 | 338800.0 |
| 2003-08-29 10:00:00 | CL | Stock | 27.845 | 27.845 | 27.6 | 27.605 | 417800.0 |
| 2003-08-29 11:00:00 | CL | Stock | 27.605 | 27.62 | 27.52 | 27.525 | 325600.0 |
| 2003-08-29 12:00:00 | CL | Stock | 27.525 | 27.56 | 27.5 | 27.505 | 245800.0 |
| 2003-08-29 13:00:00 | CL | Stock | 27.5 | 27.6 | 27.5 | 27.6 | 241800.0 |
| 2003-08-29 14:00:00 | CL | Stock | 27.595 | 27.675 | 27.555 | 27.665 | 184000.0 |
| 2003-08-29 15:00:00 | CL | Stock | 27.65 | 27.695 | 27.595 | 27.625 | 401200.0 |
> showing 50 of 21,475 rows — these rows as CSV