PREVIEW / stock_1hour / 2024-03-08
file: by_date/stock_1hour/2024/2024-03-08.parquet size: 1.4 MB rows: 60,013 symbols: 1,099
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-08 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 169.29 | 169.49 | 21220.0 |
| 2024-03-08 05:00:00 | AAPL | Stock | 169.46 | 170.19 | 169.46 | 170.07 | 15651.0 |
| 2024-03-08 06:00:00 | AAPL | Stock | 170.0 | 170.28 | 169.63 | 169.65 | 24726.0 |
| 2024-03-08 07:00:00 | AAPL | Stock | 169.64 | 169.72 | 169.29 | 169.72 | 47584.0 |
| 2024-03-08 08:00:00 | AAPL | Stock | 169.48 | 170.47 | 169.01 | 170.16 | 380615.0 |
| 2024-03-08 09:00:00 | AAPL | Stock | 170.16 | 170.86 | 168.94 | 170.73 | 7471208.0 |
| 2024-03-08 10:00:00 | AAPL | Stock | 170.74 | 171.9 | 170.65 | 171.3687 | 8370616.0 |
| 2024-03-08 11:00:00 | AAPL | Stock | 171.36 | 172.48 | 170.93 | 171.49 | 8811436.0 |
| 2024-03-08 12:00:00 | AAPL | Stock | 171.48 | 172.79 | 171.36 | 171.84 | 7086071.0 |
| 2024-03-08 13:00:00 | AAPL | Stock | 171.84 | 172.49 | 171.71 | 172.4217 | 4889809.0 |
| 2024-03-08 14:00:00 | AAPL | Stock | 172.43 | 173.7 | 172.396 | 172.711 | 7400283.0 |
| 2024-03-08 15:00:00 | AAPL | Stock | 172.71 | 172.97 | 170.72 | 170.74 | 11482092.0 |
| 2024-03-08 16:00:00 | AAPL | Stock | 170.73 | 171.17 | 170.73 | 171.09 | 7077898.0 |
| 2024-03-08 17:00:00 | AAPL | Stock | 171.1 | 171.16 | 170.75 | 170.99 | 47318.0 |
| 2024-03-08 18:00:00 | AAPL | Stock | 170.98 | 170.99 | 170.6481 | 170.6481 | 35712.0 |
| 2024-03-08 19:00:00 | AAPL | Stock | 170.69 | 170.71 | 170.0 | 170.48 | 78777.0 |
| 2024-03-08 04:00:00 | MSFT | Stock | 409.84 | 409.84 | 408.2 | 409.1 | 1881.0 |
| 2024-03-08 05:00:00 | MSFT | Stock | 409.08 | 409.09 | 407.35 | 407.65 | 9780.0 |
| 2024-03-08 06:00:00 | MSFT | Stock | 407.5 | 407.5 | 407.0 | 407.02 | 5253.0 |
| 2024-03-08 07:00:00 | MSFT | Stock | 407.41 | 408.0 | 407.05 | 407.5 | 5124.0 |
| 2024-03-08 08:00:00 | MSFT | Stock | 407.28 | 409.19 | 406.15 | 407.84 | 37274.0 |
| 2024-03-08 09:00:00 | MSFT | Stock | 407.9866 | 409.19 | 406.63 | 409.08 | 1497506.0 |
| 2024-03-08 10:00:00 | MSFT | Stock | 409.08 | 410.42 | 408.36 | 408.8201 | 1731442.0 |
| 2024-03-08 11:00:00 | MSFT | Stock | 408.84 | 408.9099 | 406.53 | 407.285 | 1556951.0 |
| 2024-03-08 12:00:00 | MSFT | Stock | 407.29 | 408.32 | 404.5501 | 405.15 | 987703.0 |
| 2024-03-08 13:00:00 | MSFT | Stock | 405.14 | 406.3858 | 404.33 | 405.2225 | 844453.0 |
| 2024-03-08 14:00:00 | MSFT | Stock | 405.18 | 407.42 | 405.11 | 407.06 | 902116.0 |
| 2024-03-08 15:00:00 | MSFT | Stock | 407.04 | 407.72 | 405.4155 | 406.17 | 1535749.0 |
| 2024-03-08 16:00:00 | MSFT | Stock | 406.22 | 407.65 | 406.22 | 406.62 | 3091821.0 |
| 2024-03-08 17:00:00 | MSFT | Stock | 406.75 | 407.88 | 406.52 | 406.53 | 16018.0 |
| 2024-03-08 18:00:00 | MSFT | Stock | 406.66 | 406.95 | 406.0 | 406.0 | 8999.0 |
| 2024-03-08 19:00:00 | MSFT | Stock | 405.7 | 405.8 | 405.3 | 405.3 | 12974.0 |
| 2024-03-08 04:00:00 | NVDA | Stock | 95.499 | 95.9 | 95.195 | 95.56 | 1039790.0 |
| 2024-03-08 05:00:00 | NVDA | Stock | 95.6 | 95.725 | 95.35 | 95.45 | 482940.0 |
| 2024-03-08 06:00:00 | NVDA | Stock | 95.48 | 95.67 | 95.271 | 95.3 | 400590.0 |
| 2024-03-08 07:00:00 | NVDA | Stock | 95.281 | 95.478 | 94.159 | 94.29 | 2857340.0 |
| 2024-03-08 08:00:00 | NVDA | Stock | 95.23 | 95.899 | 94.16 | 95.329 | 11537250.0 |
| 2024-03-08 09:00:00 | NVDA | Stock | 95.32 | 95.892 | 94.62 | 95.7047 | 77582750.0 |
| 2024-03-08 10:00:00 | NVDA | Stock | 95.6985 | 97.4 | 95.001 | 95.396 | 112228590.0 |
| 2024-03-08 11:00:00 | NVDA | Stock | 95.381 | 95.475 | 88.058 | 89.2165 | 199723740.0 |
| 2024-03-08 12:00:00 | NVDA | Stock | 89.255 | 90.084 | 87.077 | 87.528 | 94787400.0 |
| 2024-03-08 13:00:00 | NVDA | Stock | 87.5 | 88.669 | 86.506 | 87.4886 | 81283690.0 |
| 2024-03-08 14:00:00 | NVDA | Stock | 87.49 | 89.371 | 87.341 | 88.597 | 73656070.0 |
| 2024-03-08 15:00:00 | NVDA | Stock | 88.597 | 89.084 | 87.415 | 87.502 | 76548280.0 |
| 2024-03-08 16:00:00 | NVDA | Stock | 87.528 | 87.78 | 87.084 | 87.305 | 26070420.0 |
| 2024-03-08 17:00:00 | NVDA | Stock | 87.31 | 87.668 | 85.876 | 86.1 | 3359640.0 |
| 2024-03-08 18:00:00 | NVDA | Stock | 86.1494 | 86.409 | 85.476 | 85.7 | 2515410.0 |
| 2024-03-08 19:00:00 | NVDA | Stock | 85.702 | 85.75 | 85.0 | 85.1 | 2677200.0 |
| 2024-03-08 04:00:00 | AMZN | Stock | 176.74 | 177.32 | 176.74 | 177.25 | 10317.0 |
| 2024-03-08 05:00:00 | AMZN | Stock | 177.18 | 177.34 | 177.18 | 177.25 | 9259.0 |
> showing 50 of 60,013 rows — these rows as CSV