PREVIEW / stock_1hour / 2008-09-05
file: by_date/stock_1hour/2008/2008-09-05.parquet size: 824 KB rows: 40,274 symbols: 3,304
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-09-05 06:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 5040.0 |
| 2008-09-05 07:00:00 | AAPL | Stock | 5.7143 | 5.7607 | 5.7143 | 5.7507 | 123368.0 |
| 2008-09-05 08:00:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.6168 | 5.6604 | 6125672.0 |
| 2008-09-05 09:00:00 | AAPL | Stock | 5.6593 | 5.775 | 5.6429 | 5.7604 | 116368476.0 |
| 2008-09-05 10:00:00 | AAPL | Stock | 5.7614 | 5.8 | 5.6596 | 5.6768 | 149857260.0 |
| 2008-09-05 11:00:00 | AAPL | Stock | 5.6771 | 5.7489 | 5.6304 | 5.7286 | 118267912.0 |
| 2008-09-05 12:00:00 | AAPL | Stock | 5.7304 | 5.7589 | 5.6793 | 5.7132 | 97847708.0 |
| 2008-09-05 13:00:00 | AAPL | Stock | 5.7154 | 5.7757 | 5.6825 | 5.7189 | 78581552.0 |
| 2008-09-05 14:00:00 | AAPL | Stock | 5.7189 | 5.7604 | 5.6864 | 5.7376 | 95851000.0 |
| 2008-09-05 15:00:00 | AAPL | Stock | 5.7368 | 5.7393 | 5.6961 | 5.7143 | 99565480.0 |
| 2008-09-05 16:00:00 | AAPL | Stock | 5.7171 | 5.7679 | 5.7114 | 5.7657 | 10973144.0 |
| 2008-09-05 17:00:00 | AAPL | Stock | 5.7661 | 5.7757 | 5.7207 | 5.7714 | 762916.0 |
| 2008-09-05 18:00:00 | AAPL | Stock | 5.7714 | 5.7768 | 5.7646 | 5.7764 | 177100.0 |
| 2008-09-05 19:00:00 | AAPL | Stock | 5.7721 | 5.7768 | 5.7682 | 5.7746 | 107968.0 |
| 2008-09-05 07:00:00 | MSFT | Stock | 26.2 | 26.29 | 26.2 | 26.29 | 984.0 |
| 2008-09-05 08:00:00 | MSFT | Stock | 26.35 | 26.38 | 25.92 | 26.09 | 66418.0 |
| 2008-09-05 09:00:00 | MSFT | Stock | 26.07 | 26.22 | 25.95 | 26.05 | 10057540.0 |
| 2008-09-05 10:00:00 | MSFT | Stock | 26.06 | 26.09 | 25.71 | 25.763 | 16490406.0 |
| 2008-09-05 11:00:00 | MSFT | Stock | 25.77 | 25.98 | 25.69 | 25.92 | 11752918.0 |
| 2008-09-05 12:00:00 | MSFT | Stock | 25.92 | 26.04 | 25.79 | 25.95 | 8362916.0 |
| 2008-09-05 13:00:00 | MSFT | Stock | 25.96 | 26.08 | 25.8 | 25.928 | 9004265.0 |
| 2008-09-05 14:00:00 | MSFT | Stock | 25.92 | 25.96 | 25.85 | 25.89 | 7628263.0 |
| 2008-09-05 15:00:00 | MSFT | Stock | 25.89 | 25.91 | 25.63 | 25.64 | 14440543.0 |
| 2008-09-05 16:00:00 | MSFT | Stock | 25.63 | 25.897 | 25.56 | 25.85 | 2713367.0 |
| 2008-09-05 17:00:00 | MSFT | Stock | 25.84 | 25.98 | 25.65 | 25.95 | 97821.0 |
| 2008-09-05 18:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.8 | 25.8 | 5800.0 |
| 2008-09-05 19:00:00 | MSFT | Stock | 25.87 | 25.91 | 25.86 | 25.91 | 4980.0 |
| 2008-09-05 08:00:00 | NVDA | Stock | 0.2875 | 0.29 | 0.285 | 0.285 | 324600.0 |
| 2008-09-05 09:00:00 | NVDA | Stock | 0.285 | 0.291 | 0.2848 | 0.2908 | 63322760.0 |
| 2008-09-05 10:00:00 | NVDA | Stock | 0.2908 | 0.292 | 0.285 | 0.2857 | 128990760.0 |
| 2008-09-05 11:00:00 | NVDA | Stock | 0.2855 | 0.2912 | 0.2855 | 0.2903 | 165202960.0 |
| 2008-09-05 12:00:00 | NVDA | Stock | 0.2902 | 0.2912 | 0.2886 | 0.289 | 127317080.0 |
| 2008-09-05 13:00:00 | NVDA | Stock | 0.2892 | 0.2902 | 0.2882 | 0.2895 | 45732400.0 |
| 2008-09-05 14:00:00 | NVDA | Stock | 0.2895 | 0.2912 | 0.2882 | 0.291 | 94676240.0 |
| 2008-09-05 15:00:00 | NVDA | Stock | 0.291 | 0.2925 | 0.2908 | 0.292 | 142856800.0 |
| 2008-09-05 16:00:00 | NVDA | Stock | 0.2925 | 0.2935 | 0.2897 | 0.2935 | 9572680.0 |
| 2008-09-05 17:00:00 | NVDA | Stock | 0.2928 | 0.2928 | 0.2918 | 0.2925 | 96480.0 |
| 2008-09-05 18:00:00 | NVDA | Stock | 0.294 | 0.2942 | 0.2925 | 0.2942 | 68000.0 |
| 2008-09-05 19:00:00 | NVDA | Stock | 0.293 | 0.2948 | 0.293 | 0.2945 | 111480.0 |
| 2008-09-05 08:00:00 | AMZN | Stock | 3.905 | 3.905 | 3.8425 | 3.8425 | 135020.0 |
| 2008-09-05 09:00:00 | AMZN | Stock | 3.8425 | 3.9525 | 3.835 | 3.915 | 18685180.0 |
| 2008-09-05 10:00:00 | AMZN | Stock | 3.917 | 3.925 | 3.8745 | 3.8775 | 23230240.0 |
| 2008-09-05 11:00:00 | AMZN | Stock | 3.8775 | 3.9605 | 3.876 | 3.9445 | 19323360.0 |
| 2008-09-05 12:00:00 | AMZN | Stock | 3.945 | 4.03 | 3.9422 | 4.0085 | 25725500.0 |
| 2008-09-05 13:00:00 | AMZN | Stock | 4.0085 | 4.036 | 3.9965 | 4.003 | 20032120.0 |
| 2008-09-05 14:00:00 | AMZN | Stock | 4.003 | 4.0085 | 3.9675 | 3.992 | 21509000.0 |
| 2008-09-05 15:00:00 | AMZN | Stock | 3.991 | 3.9975 | 3.953 | 3.9595 | 26533600.0 |
| 2008-09-05 16:00:00 | AMZN | Stock | 3.9605 | 4.015 | 3.944 | 4.01 | 4232360.0 |
| 2008-09-05 17:00:00 | AMZN | Stock | 3.9595 | 4.0 | 3.9595 | 4.0 | 26560.0 |
| 2008-09-05 18:00:00 | AMZN | Stock | 4.0095 | 4.0095 | 4.0095 | 4.0095 | 20000.0 |
> showing 50 of 40,274 rows — these rows as CSV