PREVIEW / stock_1hour / 2009-03-26
file: by_date/stock_1hour/2009/2009-03-26.parquet size: 858 KB rows: 42,914 symbols: 3,307
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-03-26 08:00:00 | AAPL | Stock | 3.8214 | 3.8496 | 3.8214 | 3.8446 | 1245384.0 |
| 2009-03-26 09:00:00 | AAPL | Stock | 3.8464 | 3.8829 | 3.8421 | 3.8693 | 70472192.0 |
| 2009-03-26 10:00:00 | AAPL | Stock | 3.8696 | 3.9043 | 3.8436 | 3.8829 | 97832924.0 |
| 2009-03-26 11:00:00 | AAPL | Stock | 3.8829 | 3.9018 | 3.8682 | 3.8864 | 66219916.0 |
| 2009-03-26 12:00:00 | AAPL | Stock | 3.8871 | 3.905 | 3.8696 | 3.8734 | 54352396.0 |
| 2009-03-26 13:00:00 | AAPL | Stock | 3.8736 | 3.9054 | 3.8725 | 3.8946 | 72313668.0 |
| 2009-03-26 14:00:00 | AAPL | Stock | 3.8936 | 3.9107 | 3.8811 | 3.8818 | 81477788.0 |
| 2009-03-26 15:00:00 | AAPL | Stock | 3.8821 | 3.9279 | 3.8786 | 3.9239 | 127464540.0 |
| 2009-03-26 16:00:00 | AAPL | Stock | 3.9211 | 3.925 | 3.8691 | 3.9057 | 24454528.0 |
| 2009-03-26 17:00:00 | AAPL | Stock | 3.9057 | 3.9239 | 3.8892 | 3.9196 | 799120.0 |
| 2009-03-26 18:00:00 | AAPL | Stock | 3.9218 | 3.9239 | 3.9154 | 3.9154 | 1687056.0 |
| 2009-03-26 19:00:00 | AAPL | Stock | 3.9164 | 3.9214 | 3.9143 | 3.9143 | 194600.0 |
| 2009-03-26 04:00:00 | MSFT | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 200.0 |
| 2009-03-26 07:00:00 | MSFT | Stock | 18.19 | 18.19 | 18.19 | 18.19 | 2000.0 |
| 2009-03-26 08:00:00 | MSFT | Stock | 18.13 | 18.13 | 18.0 | 18.08 | 16413.0 |
| 2009-03-26 09:00:00 | MSFT | Stock | 18.08 | 18.38 | 18.03 | 18.24 | 6432006.0 |
| 2009-03-26 10:00:00 | MSFT | Stock | 18.24 | 18.33 | 18.14 | 18.22 | 7332546.0 |
| 2009-03-26 11:00:00 | MSFT | Stock | 18.22 | 18.35 | 18.2 | 18.33 | 7113780.0 |
| 2009-03-26 12:00:00 | MSFT | Stock | 18.34 | 18.36 | 18.27 | 18.34 | 2135392.0 |
| 2009-03-26 13:00:00 | MSFT | Stock | 18.22 | 18.54 | 18.22 | 18.51 | 9817158.0 |
| 2009-03-26 14:00:00 | MSFT | Stock | 18.509 | 18.59 | 18.37 | 18.38 | 6869817.0 |
| 2009-03-26 15:00:00 | MSFT | Stock | 18.37 | 18.88 | 18.35 | 18.82 | 15940636.0 |
| 2009-03-26 16:00:00 | MSFT | Stock | 18.85 | 18.85 | 18.413 | 18.77 | 5402572.0 |
| 2009-03-26 17:00:00 | MSFT | Stock | 18.83 | 18.83 | 18.74 | 18.74 | 113008.0 |
| 2009-03-26 18:00:00 | MSFT | Stock | 18.78 | 18.83 | 18.74 | 18.79 | 294581.0 |
| 2009-03-26 19:00:00 | MSFT | Stock | 18.77 | 18.8 | 18.74 | 18.8 | 3200.0 |
| 2009-03-26 08:00:00 | NVDA | Stock | 0.2475 | 0.258 | 0.246 | 0.2553 | 296000.0 |
| 2009-03-26 09:00:00 | NVDA | Stock | 0.255 | 0.2563 | 0.2498 | 0.2535 | 110887080.0 |
| 2009-03-26 10:00:00 | NVDA | Stock | 0.2535 | 0.2583 | 0.252 | 0.2523 | 233638680.0 |
| 2009-03-26 11:00:00 | NVDA | Stock | 0.2523 | 0.2563 | 0.252 | 0.2558 | 190346240.0 |
| 2009-03-26 12:00:00 | NVDA | Stock | 0.2558 | 0.2592 | 0.2553 | 0.2568 | 125032720.0 |
| 2009-03-26 13:00:00 | NVDA | Stock | 0.2565 | 0.264 | 0.2565 | 0.2615 | 220833000.0 |
| 2009-03-26 14:00:00 | NVDA | Stock | 0.2615 | 0.2638 | 0.259 | 0.2594 | 127605920.0 |
| 2009-03-26 15:00:00 | NVDA | Stock | 0.2592 | 0.2645 | 0.259 | 0.2638 | 294960760.0 |
| 2009-03-26 16:00:00 | NVDA | Stock | 0.2638 | 0.265 | 0.2547 | 0.265 | 6735120.0 |
| 2009-03-26 17:00:00 | NVDA | Stock | 0.264 | 0.267 | 0.2638 | 0.264 | 668760.0 |
| 2009-03-26 18:00:00 | NVDA | Stock | 0.264 | 0.27 | 0.264 | 0.2688 | 62800.0 |
| 2009-03-26 19:00:00 | NVDA | Stock | 0.2688 | 0.2688 | 0.268 | 0.2685 | 70800.0 |
| 2009-03-26 08:00:00 | AMZN | Stock | 3.6595 | 3.6725 | 3.6385 | 3.6385 | 78200.0 |
| 2009-03-26 09:00:00 | AMZN | Stock | 3.6485 | 3.735 | 3.6455 | 3.6875 | 18760380.0 |
| 2009-03-26 10:00:00 | AMZN | Stock | 3.6865 | 3.7072 | 3.632 | 3.683 | 20259180.0 |
| 2009-03-26 11:00:00 | AMZN | Stock | 3.682 | 3.711 | 3.672 | 3.705 | 12186920.0 |
| 2009-03-26 12:00:00 | AMZN | Stock | 3.7045 | 3.735 | 3.699 | 3.7025 | 14733400.0 |
| 2009-03-26 13:00:00 | AMZN | Stock | 3.7035 | 3.749 | 3.701 | 3.7145 | 13184300.0 |
| 2009-03-26 14:00:00 | AMZN | Stock | 3.7145 | 3.721 | 3.635 | 3.635 | 20064020.0 |
| 2009-03-26 15:00:00 | AMZN | Stock | 3.6355 | 3.692 | 3.634 | 3.6845 | 24494500.0 |
| 2009-03-26 16:00:00 | AMZN | Stock | 3.6855 | 3.7012 | 3.62 | 3.684 | 7853380.0 |
| 2009-03-26 17:00:00 | AMZN | Stock | 3.6845 | 3.6845 | 3.6775 | 3.6775 | 27040.0 |
| 2009-03-26 18:00:00 | AMZN | Stock | 3.68 | 3.685 | 3.68 | 3.685 | 11720.0 |
| 2009-03-26 19:00:00 | AMZN | Stock | 3.6845 | 3.689 | 3.6805 | 3.6805 | 42000.0 |
> showing 50 of 42,914 rows — these rows as CSV