PREVIEW / stock_1hour / 2008-09-19
file: by_date/stock_1hour/2008/2008-09-19.parquet size: 915 KB rows: 45,112 symbols: 3,379
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-19 07:00:00 | AAPL | Stock | 4.9464 | 5.0536 | 4.9289 | 5.0139 | 1543612.0 |
| 2008-09-19 08:00:00 | AAPL | Stock | 5.0139 | 5.1411 | 4.9821 | 5.1125 | 12977496.0 |
| 2008-09-19 09:00:00 | AAPL | Stock | 5.1143 | 5.2143 | 4.8929 | 5.0157 | 375781504.0 |
| 2008-09-19 10:00:00 | AAPL | Stock | 5.015 | 5.0439 | 4.9425 | 4.9887 | 209298656.0 |
| 2008-09-19 11:00:00 | AAPL | Stock | 4.9889 | 5.0982 | 4.9843 | 5.0893 | 154824376.0 |
| 2008-09-19 12:00:00 | AAPL | Stock | 5.0893 | 5.15 | 5.075 | 5.0891 | 131180112.0 |
| 2008-09-19 13:00:00 | AAPL | Stock | 5.0903 | 5.0954 | 5.0121 | 5.0257 | 110942776.0 |
| 2008-09-19 14:00:00 | AAPL | Stock | 5.0264 | 5.0482 | 5.0004 | 5.025 | 112763056.0 |
| 2008-09-19 15:00:00 | AAPL | Stock | 5.0246 | 5.0343 | 4.9496 | 5.0279 | 242375364.0 |
| 2008-09-19 16:00:00 | AAPL | Stock | 5.0266 | 5.0446 | 5.0027 | 5.0361 | 47738292.0 |
| 2008-09-19 17:00:00 | AAPL | Stock | 5.0364 | 5.0464 | 5.0325 | 5.0357 | 5177284.0 |
| 2008-09-19 18:00:00 | AAPL | Stock | 5.0325 | 5.0361 | 5.0268 | 5.0282 | 292880.0 |
| 2008-09-19 19:00:00 | AAPL | Stock | 5.0268 | 5.0393 | 5.0221 | 5.0232 | 702268.0 |
| 2008-09-19 07:00:00 | MSFT | Stock | 25.75 | 26.15 | 25.75 | 26.1 | 41306.0 |
| 2008-09-19 08:00:00 | MSFT | Stock | 26.1 | 26.36 | 25.8 | 26.28 | 250275.0 |
| 2008-09-19 09:00:00 | MSFT | Stock | 26.25 | 26.43 | 23.5 | 25.51 | 13318045.0 |
| 2008-09-19 10:00:00 | MSFT | Stock | 25.52 | 25.6 | 24.82 | 24.97 | 15720026.0 |
| 2008-09-19 11:00:00 | MSFT | Stock | 24.97 | 25.53 | 24.94 | 25.49 | 15610060.0 |
| 2008-09-19 12:00:00 | MSFT | Stock | 25.49 | 25.57 | 25.28 | 25.4 | 7839334.0 |
| 2008-09-19 13:00:00 | MSFT | Stock | 25.4 | 25.42 | 25.03 | 25.064 | 7612735.0 |
| 2008-09-19 14:00:00 | MSFT | Stock | 25.062 | 25.19 | 24.96 | 25.07 | 10949248.0 |
| 2008-09-19 15:00:00 | MSFT | Stock | 25.07 | 25.47 | 24.96 | 25.16 | 22445497.0 |
| 2008-09-19 16:00:00 | MSFT | Stock | 25.15 | 26.25 | 25.023 | 25.15 | 14400137.0 |
| 2008-09-19 17:00:00 | MSFT | Stock | 25.16 | 25.25 | 25.16 | 25.16 | 684631.0 |
| 2008-09-19 18:00:00 | MSFT | Stock | 25.19 | 25.29 | 25.16 | 25.28 | 10163.0 |
| 2008-09-19 19:00:00 | MSFT | Stock | 25.27 | 25.29 | 25.16 | 25.28 | 9175.0 |
| 2008-09-19 08:00:00 | NVDA | Stock | 0.2838 | 0.2925 | 0.2825 | 0.2918 | 2204160.0 |
| 2008-09-19 09:00:00 | NVDA | Stock | 0.2915 | 0.2925 | 0.275 | 0.2808 | 119280320.0 |
| 2008-09-19 10:00:00 | NVDA | Stock | 0.2808 | 0.281 | 0.2724 | 0.2743 | 140571520.0 |
| 2008-09-19 11:00:00 | NVDA | Stock | 0.2744 | 0.2875 | 0.2743 | 0.2858 | 139301960.0 |
| 2008-09-19 12:00:00 | NVDA | Stock | 0.2858 | 0.287 | 0.2816 | 0.2828 | 82012440.0 |
| 2008-09-19 13:00:00 | NVDA | Stock | 0.2828 | 0.2832 | 0.2785 | 0.2812 | 78811960.0 |
| 2008-09-19 14:00:00 | NVDA | Stock | 0.2812 | 0.2818 | 0.2772 | 0.2812 | 144735840.0 |
| 2008-09-19 15:00:00 | NVDA | Stock | 0.2812 | 0.2862 | 0.278 | 0.2852 | 248809240.0 |
| 2008-09-19 16:00:00 | NVDA | Stock | 0.2852 | 0.2875 | 0.275 | 0.285 | 4480680.0 |
| 2008-09-19 17:00:00 | NVDA | Stock | 0.2852 | 0.2855 | 0.285 | 0.285 | 3391760.0 |
| 2008-09-19 18:00:00 | NVDA | Stock | 0.2852 | 0.2855 | 0.285 | 0.285 | 169080.0 |
| 2008-09-19 19:00:00 | NVDA | Stock | 0.285 | 0.2855 | 0.285 | 0.2855 | 10506000.0 |
| 2008-09-19 08:00:00 | AMZN | Stock | 3.895 | 4.01 | 3.895 | 4.01 | 189300.0 |
| 2008-09-19 09:00:00 | AMZN | Stock | 4.015 | 4.3385 | 3.8875 | 3.9945 | 81435600.0 |
| 2008-09-19 10:00:00 | AMZN | Stock | 3.993 | 4.079 | 3.951 | 3.9555 | 44027080.0 |
| 2008-09-19 11:00:00 | AMZN | Stock | 3.955 | 4.048 | 3.952 | 4.044 | 29110840.0 |
| 2008-09-19 12:00:00 | AMZN | Stock | 4.045 | 4.0845 | 4.024 | 4.0645 | 20777520.0 |
| 2008-09-19 13:00:00 | AMZN | Stock | 4.0645 | 4.069 | 3.989 | 3.993 | 16291700.0 |
| 2008-09-19 14:00:00 | AMZN | Stock | 3.99 | 3.9995 | 3.951 | 3.9788 | 22928340.0 |
| 2008-09-19 15:00:00 | AMZN | Stock | 3.98 | 4.068 | 3.9575 | 4.068 | 40990360.0 |
| 2008-09-19 16:00:00 | AMZN | Stock | 4.068 | 4.068 | 3.975 | 4.046 | 27974440.0 |
| 2008-09-19 17:00:00 | AMZN | Stock | 4.05 | 4.1322 | 4.05 | 4.1322 | 886700.0 |
| 2008-09-19 18:00:00 | AMZN | Stock | 4.0675 | 4.0675 | 4.051 | 4.051 | 15000.0 |
| 2008-09-19 19:00:00 | AMZN | Stock | 4.05 | 4.05 | 4.025 | 4.025 | 299840.0 |
> showing 50 of 45,112 rows — these rows as CSV