PREVIEW / stock_1hour / 2008-09-22
file: by_date/stock_1hour/2008/2008-09-22.parquet size: 839 KB rows: 41,227 symbols: 3,363
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-22 07:00:00 | AAPL | Stock | 5.0 | 5.0 | 4.9568 | 4.9571 | 529648.0 |
| 2008-09-22 08:00:00 | AAPL | Stock | 4.9679 | 5.0068 | 4.9511 | 4.9818 | 3305204.0 |
| 2008-09-22 09:00:00 | AAPL | Stock | 4.9818 | 5.0268 | 4.9154 | 4.9475 | 111088404.0 |
| 2008-09-22 10:00:00 | AAPL | Stock | 4.9464 | 4.9779 | 4.9046 | 4.9657 | 129540404.0 |
| 2008-09-22 11:00:00 | AAPL | Stock | 4.9657 | 4.975 | 4.8486 | 4.8771 | 118391112.0 |
| 2008-09-22 12:00:00 | AAPL | Stock | 4.8748 | 4.9096 | 4.8607 | 4.8807 | 64698424.0 |
| 2008-09-22 13:00:00 | AAPL | Stock | 4.8821 | 4.8875 | 4.8014 | 4.8518 | 104066480.0 |
| 2008-09-22 14:00:00 | AAPL | Stock | 4.8511 | 4.8614 | 4.7693 | 4.7829 | 116539388.0 |
| 2008-09-22 15:00:00 | AAPL | Stock | 4.7818 | 4.7925 | 4.6664 | 4.6725 | 188106632.0 |
| 2008-09-22 16:00:00 | AAPL | Stock | 4.6714 | 4.8724 | 4.6714 | 4.6954 | 14017920.0 |
| 2008-09-22 17:00:00 | AAPL | Stock | 4.6921 | 4.7 | 4.6804 | 4.6961 | 405496.0 |
| 2008-09-22 18:00:00 | AAPL | Stock | 4.6961 | 4.6971 | 4.6829 | 4.6954 | 473480.0 |
| 2008-09-22 19:00:00 | AAPL | Stock | 4.6882 | 4.6964 | 4.6829 | 4.6964 | 230776.0 |
| 2008-09-22 07:00:00 | MSFT | Stock | 24.95 | 24.95 | 24.95 | 24.95 | 100.0 |
| 2008-09-22 08:00:00 | MSFT | Stock | 25.1 | 28.99 | 24.88 | 26.47 | 3516825.0 |
| 2008-09-22 09:00:00 | MSFT | Stock | 26.45 | 26.51 | 25.65 | 26.04 | 13529252.0 |
| 2008-09-22 10:00:00 | MSFT | Stock | 26.05 | 26.3 | 25.94 | 26.23 | 19716541.0 |
| 2008-09-22 11:00:00 | MSFT | Stock | 26.24 | 26.245 | 25.7 | 25.93 | 12392811.0 |
| 2008-09-22 12:00:00 | MSFT | Stock | 25.93 | 26.09 | 25.929 | 26.01 | 7464144.0 |
| 2008-09-22 13:00:00 | MSFT | Stock | 26.002 | 26.01 | 25.71 | 25.88 | 11174037.0 |
| 2008-09-22 14:00:00 | MSFT | Stock | 25.88 | 26.05 | 25.84 | 25.89 | 9551205.0 |
| 2008-09-22 15:00:00 | MSFT | Stock | 25.89 | 25.93 | 25.32 | 25.36 | 21407976.0 |
| 2008-09-22 16:00:00 | MSFT | Stock | 25.38 | 25.9 | 25.36 | 25.59 | 3899896.0 |
| 2008-09-22 17:00:00 | MSFT | Stock | 25.62 | 25.62 | 25.16 | 25.6 | 1136199.0 |
| 2008-09-22 18:00:00 | MSFT | Stock | 25.61 | 25.63 | 25.4 | 25.57 | 35373.0 |
| 2008-09-22 19:00:00 | MSFT | Stock | 25.57 | 25.64 | 25.56 | 25.64 | 13719.0 |
| 2008-09-22 08:00:00 | NVDA | Stock | 0.2855 | 0.2855 | 0.2778 | 0.28 | 153000.0 |
| 2008-09-22 09:00:00 | NVDA | Stock | 0.2825 | 0.2912 | 0.2818 | 0.2888 | 86075680.0 |
| 2008-09-22 10:00:00 | NVDA | Stock | 0.289 | 0.2902 | 0.2852 | 0.2872 | 93804560.0 |
| 2008-09-22 11:00:00 | NVDA | Stock | 0.287 | 0.2872 | 0.281 | 0.2825 | 94411880.0 |
| 2008-09-22 12:00:00 | NVDA | Stock | 0.2826 | 0.2862 | 0.2815 | 0.282 | 46534920.0 |
| 2008-09-22 13:00:00 | NVDA | Stock | 0.2818 | 0.2842 | 0.2812 | 0.2832 | 77287040.0 |
| 2008-09-22 14:00:00 | NVDA | Stock | 0.2832 | 0.285 | 0.2803 | 0.283 | 86429160.0 |
| 2008-09-22 15:00:00 | NVDA | Stock | 0.283 | 0.2842 | 0.2778 | 0.2792 | 194175920.0 |
| 2008-09-22 16:00:00 | NVDA | Stock | 0.2792 | 0.2834 | 0.278 | 0.278 | 1105120.0 |
| 2008-09-22 17:00:00 | NVDA | Stock | 0.2792 | 0.2792 | 0.2792 | 0.2792 | 60080.0 |
| 2008-09-22 18:00:00 | NVDA | Stock | 0.2783 | 0.2783 | 0.2783 | 0.2783 | 35600.0 |
| 2008-09-22 19:00:00 | NVDA | Stock | 0.2783 | 0.2783 | 0.2783 | 0.2783 | 4400.0 |
| 2008-09-22 07:00:00 | AMZN | Stock | 4.0255 | 4.25 | 4.0 | 4.0125 | 171600.0 |
| 2008-09-22 08:00:00 | AMZN | Stock | 4.025 | 4.025 | 3.9885 | 4.0245 | 48000.0 |
| 2008-09-22 09:00:00 | AMZN | Stock | 4.024 | 4.0815 | 3.9145 | 3.915 | 19665620.0 |
| 2008-09-22 10:00:00 | AMZN | Stock | 3.916 | 3.916 | 3.859 | 3.896 | 20152740.0 |
| 2008-09-22 11:00:00 | AMZN | Stock | 3.896 | 3.9015 | 3.8375 | 3.849 | 12637280.0 |
| 2008-09-22 12:00:00 | AMZN | Stock | 3.8495 | 3.8585 | 3.825 | 3.8455 | 10382620.0 |
| 2008-09-22 13:00:00 | AMZN | Stock | 3.8465 | 3.8575 | 3.8135 | 3.853 | 10833760.0 |
| 2008-09-22 14:00:00 | AMZN | Stock | 3.853 | 3.8985 | 3.807 | 3.8135 | 18019740.0 |
| 2008-09-22 15:00:00 | AMZN | Stock | 3.8135 | 3.8225 | 3.716 | 3.747 | 39812100.0 |
| 2008-09-22 16:00:00 | AMZN | Stock | 3.733 | 3.8457 | 3.733 | 3.746 | 5576400.0 |
| 2008-09-22 17:00:00 | AMZN | Stock | 3.745 | 3.7465 | 3.742 | 3.743 | 2956900.0 |
| 2008-09-22 18:00:00 | AMZN | Stock | 3.7425 | 3.743 | 3.7365 | 3.7365 | 40000.0 |
> showing 50 of 41,227 rows — these rows as CSV