PREVIEW / stock_1hour / 2009-07-22
file: by_date/stock_1hour/2009/2009-07-22.parquet size: 832 KB rows: 40,617 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-22 04:00:00 | AAPL | Stock | 5.6075 | 5.6182 | 5.5925 | 5.6054 | 161700.0 |
| 2009-07-22 05:00:00 | AAPL | Stock | 5.6054 | 5.6196 | 5.6054 | 5.6161 | 63784.0 |
| 2009-07-22 06:00:00 | AAPL | Stock | 5.6239 | 5.6239 | 5.6 | 5.6107 | 473200.0 |
| 2009-07-22 07:00:00 | AAPL | Stock | 5.6143 | 5.6729 | 5.6107 | 5.6721 | 3524696.0 |
| 2009-07-22 08:00:00 | AAPL | Stock | 5.67 | 5.67 | 5.5979 | 5.6118 | 13926612.0 |
| 2009-07-22 09:00:00 | AAPL | Stock | 5.6121 | 5.665 | 5.5754 | 5.6525 | 240407664.0 |
| 2009-07-22 10:00:00 | AAPL | Stock | 5.6518 | 5.6689 | 5.6089 | 5.6289 | 158824764.0 |
| 2009-07-22 11:00:00 | AAPL | Stock | 5.6286 | 5.6479 | 5.6161 | 5.6296 | 69526044.0 |
| 2009-07-22 12:00:00 | AAPL | Stock | 5.6298 | 5.64 | 5.6004 | 5.6139 | 81280864.0 |
| 2009-07-22 13:00:00 | AAPL | Stock | 5.6133 | 5.6268 | 5.6046 | 5.6164 | 57866732.0 |
| 2009-07-22 14:00:00 | AAPL | Stock | 5.6161 | 5.6354 | 5.5993 | 5.6275 | 85112664.0 |
| 2009-07-22 15:00:00 | AAPL | Stock | 5.6275 | 5.6329 | 5.5761 | 5.5968 | 125034448.0 |
| 2009-07-22 16:00:00 | AAPL | Stock | 5.6 | 5.6321 | 5.4143 | 5.5932 | 18695768.0 |
| 2009-07-22 17:00:00 | AAPL | Stock | 5.5914 | 5.5986 | 5.5914 | 5.5946 | 357308.0 |
| 2009-07-22 18:00:00 | AAPL | Stock | 5.5939 | 5.5946 | 5.5875 | 5.5893 | 217644.0 |
| 2009-07-22 19:00:00 | AAPL | Stock | 5.5889 | 5.5896 | 5.5857 | 5.5896 | 203896.0 |
| 2009-07-22 20:00:00 | AAPL | Stock | 5.6261 | 5.6261 | 5.6261 | 5.6261 | 45640.0 |
| 2009-07-22 08:00:00 | MSFT | Stock | 24.8 | 24.8 | 24.25 | 24.68 | 32172.0 |
| 2009-07-22 09:00:00 | MSFT | Stock | 24.73 | 24.77 | 24.51 | 24.65 | 6553724.0 |
| 2009-07-22 10:00:00 | MSFT | Stock | 24.65 | 24.74 | 24.6 | 24.65 | 6857432.0 |
| 2009-07-22 11:00:00 | MSFT | Stock | 24.652 | 24.72 | 24.63 | 24.652 | 4337320.0 |
| 2009-07-22 12:00:00 | MSFT | Stock | 24.66 | 24.71 | 24.6 | 24.62 | 8622659.0 |
| 2009-07-22 13:00:00 | MSFT | Stock | 24.63 | 24.69 | 24.58 | 24.62 | 10545541.0 |
| 2009-07-22 14:00:00 | MSFT | Stock | 24.612 | 24.79 | 24.57 | 24.741 | 11285348.0 |
| 2009-07-22 15:00:00 | MSFT | Stock | 24.742 | 24.9 | 24.65 | 24.754 | 13047351.0 |
| 2009-07-22 16:00:00 | MSFT | Stock | 24.8 | 24.87 | 24.669 | 24.85 | 4263520.0 |
| 2009-07-22 17:00:00 | MSFT | Stock | 24.81 | 24.89 | 24.77 | 24.89 | 89854.0 |
| 2009-07-22 18:00:00 | MSFT | Stock | 24.84 | 24.88 | 24.81 | 24.85 | 13711.0 |
| 2009-07-22 19:00:00 | MSFT | Stock | 24.87 | 24.9 | 24.81 | 24.87 | 4763.0 |
| 2009-07-22 09:00:00 | NVDA | Stock | 0.2942 | 0.303 | 0.2912 | 0.3015 | 103140120.0 |
| 2009-07-22 10:00:00 | NVDA | Stock | 0.3015 | 0.3045 | 0.2995 | 0.3045 | 148723200.0 |
| 2009-07-22 11:00:00 | NVDA | Stock | 0.3045 | 0.3055 | 0.3032 | 0.3055 | 56162800.0 |
| 2009-07-22 12:00:00 | NVDA | Stock | 0.3055 | 0.3095 | 0.3045 | 0.3075 | 66374000.0 |
| 2009-07-22 13:00:00 | NVDA | Stock | 0.3076 | 0.309 | 0.3065 | 0.307 | 50690200.0 |
| 2009-07-22 14:00:00 | NVDA | Stock | 0.3073 | 0.3079 | 0.3058 | 0.3073 | 42598800.0 |
| 2009-07-22 15:00:00 | NVDA | Stock | 0.3073 | 0.3075 | 0.3058 | 0.3068 | 94856840.0 |
| 2009-07-22 16:00:00 | NVDA | Stock | 0.3068 | 0.309 | 0.2992 | 0.3048 | 36840760.0 |
| 2009-07-22 17:00:00 | NVDA | Stock | 0.3078 | 0.3085 | 0.3068 | 0.3068 | 134000.0 |
| 2009-07-22 18:00:00 | NVDA | Stock | 0.3068 | 0.3068 | 0.3068 | 0.3068 | 40000.0 |
| 2009-07-22 07:00:00 | AMZN | Stock | 4.449 | 4.4495 | 4.449 | 4.4495 | 6000.0 |
| 2009-07-22 08:00:00 | AMZN | Stock | 4.455 | 4.455 | 4.4185 | 4.4345 | 118880.0 |
| 2009-07-22 09:00:00 | AMZN | Stock | 4.434 | 4.4614 | 4.4085 | 4.455 | 13513500.0 |
| 2009-07-22 10:00:00 | AMZN | Stock | 4.456 | 4.4585 | 4.3975 | 4.4095 | 21172240.0 |
| 2009-07-22 11:00:00 | AMZN | Stock | 4.4085 | 4.417 | 4.389 | 4.4069 | 14014920.0 |
| 2009-07-22 12:00:00 | AMZN | Stock | 4.407 | 4.46 | 4.407 | 4.457 | 9616820.0 |
| 2009-07-22 13:00:00 | AMZN | Stock | 4.4565 | 4.46 | 4.4175 | 4.4345 | 8486440.0 |
| 2009-07-22 14:00:00 | AMZN | Stock | 4.4345 | 4.4405 | 4.405 | 4.438 | 11890940.0 |
| 2009-07-22 15:00:00 | AMZN | Stock | 4.436 | 4.4425 | 4.4145 | 4.439 | 17992360.0 |
| 2009-07-22 16:00:00 | AMZN | Stock | 4.4425 | 4.4425 | 4.4005 | 4.4325 | 2621260.0 |
| 2009-07-22 17:00:00 | AMZN | Stock | 4.433 | 4.525 | 4.433 | 4.4775 | 1670540.0 |
> showing 50 of 40,617 rows — these rows as CSV