PREVIEW / stock_1hour / 2008-07-21
file: by_date/stock_1hour/2008/2008-07-21.parquet size: 820 KB rows: 40,192 symbols: 3,327
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-21 05:00:00 | AAPL | Stock | 5.9161 | 5.9171 | 5.9161 | 5.9171 | 36400.0 |
| 2008-07-21 06:00:00 | AAPL | Stock | 5.9271 | 5.95 | 5.9271 | 5.95 | 8960.0 |
| 2008-07-21 07:00:00 | AAPL | Stock | 5.9464 | 5.9729 | 5.9393 | 5.95 | 495908.0 |
| 2008-07-21 08:00:00 | AAPL | Stock | 5.9482 | 5.9643 | 5.9421 | 5.9518 | 7625576.0 |
| 2008-07-21 09:00:00 | AAPL | Stock | 5.9518 | 5.9821 | 5.8611 | 5.8929 | 130350556.0 |
| 2008-07-21 10:00:00 | AAPL | Stock | 5.8929 | 5.9046 | 5.8407 | 5.8579 | 139918716.0 |
| 2008-07-21 11:00:00 | AAPL | Stock | 5.8576 | 5.8679 | 5.7543 | 5.7775 | 128281748.0 |
| 2008-07-21 12:00:00 | AAPL | Stock | 5.7775 | 5.8261 | 5.7718 | 5.7832 | 97607020.0 |
| 2008-07-21 13:00:00 | AAPL | Stock | 5.7832 | 5.8768 | 5.7793 | 5.8231 | 120916964.0 |
| 2008-07-21 14:00:00 | AAPL | Stock | 5.8243 | 5.8643 | 5.8107 | 5.8607 | 107100784.0 |
| 2008-07-21 15:00:00 | AAPL | Stock | 5.8614 | 5.9525 | 5.8257 | 5.9457 | 242987304.0 |
| 2008-07-21 16:00:00 | AAPL | Stock | 5.9457 | 5.9925 | 5.5714 | 5.5839 | 200078984.0 |
| 2008-07-21 17:00:00 | AAPL | Stock | 5.5857 | 5.9289 | 5.2714 | 5.3336 | 114599268.0 |
| 2008-07-21 18:00:00 | AAPL | Stock | 5.3357 | 5.3357 | 5.27 | 5.2896 | 31448844.0 |
| 2008-07-21 19:00:00 | AAPL | Stock | 5.2896 | 5.3536 | 5.2896 | 5.3464 | 10477768.0 |
| 2008-07-21 07:00:00 | MSFT | Stock | 25.99 | 26.08 | 25.99 | 26.0 | 7430.0 |
| 2008-07-21 08:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.75 | 25.81 | 37777.0 |
| 2008-07-21 09:00:00 | MSFT | Stock | 25.82 | 26.135 | 25.62 | 26.135 | 8974923.0 |
| 2008-07-21 10:00:00 | MSFT | Stock | 26.13 | 26.17 | 25.81 | 25.91 | 14218860.0 |
| 2008-07-21 11:00:00 | MSFT | Stock | 25.91 | 25.97 | 25.66 | 25.71 | 9993219.0 |
| 2008-07-21 12:00:00 | MSFT | Stock | 25.71 | 25.71 | 25.54 | 25.58 | 8262754.0 |
| 2008-07-21 13:00:00 | MSFT | Stock | 25.58 | 26.15 | 25.56 | 25.66 | 7396921.0 |
| 2008-07-21 14:00:00 | MSFT | Stock | 25.67 | 25.71 | 25.54 | 25.552 | 8903771.0 |
| 2008-07-21 15:00:00 | MSFT | Stock | 25.56 | 25.66 | 25.53 | 25.63 | 12716576.0 |
| 2008-07-21 16:00:00 | MSFT | Stock | 25.63 | 25.751 | 25.4 | 25.41 | 4826959.0 |
| 2008-07-21 17:00:00 | MSFT | Stock | 25.41 | 26.01 | 25.25 | 25.35 | 102326.0 |
| 2008-07-21 18:00:00 | MSFT | Stock | 25.34 | 25.35 | 25.27 | 25.27 | 14269.0 |
| 2008-07-21 19:00:00 | MSFT | Stock | 25.34 | 25.34 | 25.3 | 25.31 | 12750.0 |
| 2008-07-21 08:00:00 | NVDA | Stock | 0.289 | 0.2972 | 0.289 | 0.2972 | 505880.0 |
| 2008-07-21 09:00:00 | NVDA | Stock | 0.2972 | 0.2975 | 0.291 | 0.2968 | 75310840.0 |
| 2008-07-21 10:00:00 | NVDA | Stock | 0.297 | 0.2978 | 0.2925 | 0.2929 | 120300360.0 |
| 2008-07-21 11:00:00 | NVDA | Stock | 0.293 | 0.2938 | 0.2882 | 0.2885 | 88383640.0 |
| 2008-07-21 12:00:00 | NVDA | Stock | 0.2885 | 0.293 | 0.2882 | 0.291 | 73786000.0 |
| 2008-07-21 13:00:00 | NVDA | Stock | 0.291 | 0.2938 | 0.2902 | 0.2932 | 54760440.0 |
| 2008-07-21 14:00:00 | NVDA | Stock | 0.2932 | 0.2932 | 0.29 | 0.292 | 58265400.0 |
| 2008-07-21 15:00:00 | NVDA | Stock | 0.2918 | 0.2935 | 0.2908 | 0.291 | 75357480.0 |
| 2008-07-21 16:00:00 | NVDA | Stock | 0.2908 | 0.2928 | 0.2858 | 0.2865 | 17743600.0 |
| 2008-07-21 17:00:00 | NVDA | Stock | 0.2858 | 0.2945 | 0.2815 | 0.2825 | 600200.0 |
| 2008-07-21 18:00:00 | NVDA | Stock | 0.2815 | 0.284 | 0.2815 | 0.2825 | 203200.0 |
| 2008-07-21 19:00:00 | NVDA | Stock | 0.284 | 0.284 | 0.2818 | 0.2838 | 102640.0 |
| 2008-07-21 08:00:00 | AMZN | Stock | 3.49 | 3.5 | 3.49 | 3.5 | 4000.0 |
| 2008-07-21 09:00:00 | AMZN | Stock | 3.475 | 3.49 | 3.4 | 3.435 | 14660100.0 |
| 2008-07-21 10:00:00 | AMZN | Stock | 3.437 | 3.452 | 3.356 | 3.3665 | 24797520.0 |
| 2008-07-21 11:00:00 | AMZN | Stock | 3.367 | 3.379 | 3.315 | 3.321 | 25169460.0 |
| 2008-07-21 12:00:00 | AMZN | Stock | 3.321 | 3.374 | 3.319 | 3.3675 | 17791740.0 |
| 2008-07-21 13:00:00 | AMZN | Stock | 3.366 | 3.426 | 3.366 | 3.4135 | 15924420.0 |
| 2008-07-21 14:00:00 | AMZN | Stock | 3.4145 | 3.4375 | 3.4 | 3.426 | 14852100.0 |
| 2008-07-21 15:00:00 | AMZN | Stock | 3.427 | 3.4435 | 3.4095 | 3.4255 | 19431380.0 |
| 2008-07-21 16:00:00 | AMZN | Stock | 3.4345 | 3.435 | 3.371 | 3.371 | 1719880.0 |
| 2008-07-21 17:00:00 | AMZN | Stock | 3.365 | 3.365 | 3.325 | 3.325 | 104560.0 |
> showing 50 of 40,192 rows — these rows as CSV