PREVIEW / stock_1hour / 2009-02-02
file: by_date/stock_1hour/2009/2009-02-02.parquet size: 812 KB rows: 40,091 symbols: 3,294
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-02-02 07:00:00 | AAPL | Stock | 3.1932 | 3.1932 | 3.1607 | 3.1607 | 14000.0 |
| 2009-02-02 08:00:00 | AAPL | Stock | 3.1768 | 3.1961 | 3.1704 | 3.1771 | 666764.0 |
| 2009-02-02 09:00:00 | AAPL | Stock | 3.1796 | 3.2443 | 3.175 | 3.2339 | 76491268.0 |
| 2009-02-02 10:00:00 | AAPL | Stock | 3.2325 | 3.2729 | 3.2289 | 3.2332 | 96831000.0 |
| 2009-02-02 11:00:00 | AAPL | Stock | 3.2336 | 3.2539 | 3.2239 | 3.2443 | 57029700.0 |
| 2009-02-02 12:00:00 | AAPL | Stock | 3.2443 | 3.2686 | 3.2414 | 3.2636 | 54691784.0 |
| 2009-02-02 13:00:00 | AAPL | Stock | 3.2639 | 3.2646 | 3.2304 | 3.2361 | 49071288.0 |
| 2009-02-02 14:00:00 | AAPL | Stock | 3.2358 | 3.2407 | 3.2068 | 3.225 | 58417940.0 |
| 2009-02-02 15:00:00 | AAPL | Stock | 3.2246 | 3.2857 | 3.2182 | 3.2689 | 140174328.0 |
| 2009-02-02 16:00:00 | AAPL | Stock | 3.2689 | 3.2768 | 3.2321 | 3.2679 | 18333364.0 |
| 2009-02-02 17:00:00 | AAPL | Stock | 3.2189 | 3.2696 | 3.2189 | 3.2625 | 1231440.0 |
| 2009-02-02 18:00:00 | AAPL | Stock | 3.2582 | 3.2682 | 3.2571 | 3.2571 | 194488.0 |
| 2009-02-02 19:00:00 | AAPL | Stock | 3.2536 | 3.2671 | 3.2536 | 3.2625 | 143864.0 |
| 2009-02-02 04:00:00 | MSFT | Stock | 17.0 | 17.0 | 17.0 | 17.0 | 100.0 |
| 2009-02-02 08:00:00 | MSFT | Stock | 17.03 | 17.1 | 16.95 | 16.99 | 48225.0 |
| 2009-02-02 09:00:00 | MSFT | Stock | 17.0 | 17.595 | 16.97 | 17.58 | 10263253.0 |
| 2009-02-02 10:00:00 | MSFT | Stock | 17.58 | 17.9 | 17.57 | 17.812 | 15652379.0 |
| 2009-02-02 11:00:00 | MSFT | Stock | 17.812 | 18.05 | 17.72 | 17.91 | 12262538.0 |
| 2009-02-02 12:00:00 | MSFT | Stock | 17.91 | 18.12 | 17.87 | 18.09 | 12279821.0 |
| 2009-02-02 13:00:00 | MSFT | Stock | 18.098 | 18.13 | 17.87 | 17.88 | 9172811.0 |
| 2009-02-02 14:00:00 | MSFT | Stock | 17.875 | 17.89 | 17.72 | 17.768 | 8465917.0 |
| 2009-02-02 15:00:00 | MSFT | Stock | 17.76 | 18.07 | 17.74 | 17.86 | 17129422.0 |
| 2009-02-02 16:00:00 | MSFT | Stock | 17.86 | 17.957 | 17.71 | 17.85 | 2115754.0 |
| 2009-02-02 17:00:00 | MSFT | Stock | 17.1 | 17.89 | 17.1 | 17.89 | 351659.0 |
| 2009-02-02 18:00:00 | MSFT | Stock | 17.84 | 17.84 | 17.82 | 17.82 | 8165.0 |
| 2009-02-02 19:00:00 | MSFT | Stock | 17.82 | 17.82 | 17.82 | 17.82 | 2700.0 |
| 2009-02-02 09:00:00 | NVDA | Stock | 0.197 | 0.2015 | 0.1948 | 0.2 | 61854640.0 |
| 2009-02-02 10:00:00 | NVDA | Stock | 0.2002 | 0.2065 | 0.2002 | 0.204 | 93776880.0 |
| 2009-02-02 11:00:00 | NVDA | Stock | 0.2038 | 0.2053 | 0.2025 | 0.204 | 68866920.0 |
| 2009-02-02 12:00:00 | NVDA | Stock | 0.2043 | 0.2072 | 0.2038 | 0.2062 | 28947040.0 |
| 2009-02-02 13:00:00 | NVDA | Stock | 0.206 | 0.2115 | 0.206 | 0.2088 | 99134000.0 |
| 2009-02-02 14:00:00 | NVDA | Stock | 0.209 | 0.2095 | 0.2038 | 0.2046 | 56139000.0 |
| 2009-02-02 15:00:00 | NVDA | Stock | 0.2047 | 0.2118 | 0.204 | 0.2092 | 126148560.0 |
| 2009-02-02 16:00:00 | NVDA | Stock | 0.2092 | 0.21 | 0.205 | 0.2095 | 13082160.0 |
| 2009-02-02 17:00:00 | NVDA | Stock | 0.1988 | 0.2082 | 0.1988 | 0.2082 | 920280.0 |
| 2009-02-02 18:00:00 | NVDA | Stock | 0.2082 | 0.2082 | 0.2058 | 0.2058 | 72000.0 |
| 2009-02-02 04:00:00 | AMZN | Stock | 2.944 | 2.944 | 2.944 | 2.944 | 41300.0 |
| 2009-02-02 07:00:00 | AMZN | Stock | 2.9045 | 2.935 | 2.9045 | 2.935 | 10000.0 |
| 2009-02-02 08:00:00 | AMZN | Stock | 2.926 | 2.941 | 2.918 | 2.9285 | 482940.0 |
| 2009-02-02 09:00:00 | AMZN | Stock | 2.925 | 2.972 | 2.9065 | 2.9565 | 45491280.0 |
| 2009-02-02 10:00:00 | AMZN | Stock | 2.956 | 3.045 | 2.945 | 2.9905 | 92957060.0 |
| 2009-02-02 11:00:00 | AMZN | Stock | 2.991 | 3.007 | 2.9575 | 3.0055 | 48441360.0 |
| 2009-02-02 12:00:00 | AMZN | Stock | 3.0055 | 3.071 | 3.0055 | 3.0645 | 44265280.0 |
| 2009-02-02 13:00:00 | AMZN | Stock | 3.0655 | 3.0655 | 3.015 | 3.0303 | 26748060.0 |
| 2009-02-02 14:00:00 | AMZN | Stock | 3.0305 | 3.0415 | 2.9915 | 3.0075 | 32942000.0 |
| 2009-02-02 15:00:00 | AMZN | Stock | 3.008 | 3.1 | 3.002 | 3.0575 | 86994060.0 |
| 2009-02-02 16:00:00 | AMZN | Stock | 3.0575 | 3.078 | 3.0575 | 3.07 | 3515940.0 |
| 2009-02-02 17:00:00 | AMZN | Stock | 3.0725 | 3.0775 | 2.941 | 3.0615 | 353380.0 |
| 2009-02-02 18:00:00 | AMZN | Stock | 3.0615 | 3.0615 | 3.058 | 3.058 | 67840.0 |
| 2009-02-02 19:00:00 | AMZN | Stock | 3.06 | 3.065 | 3.06 | 3.06 | 30000.0 |
> showing 50 of 40,091 rows — these rows as CSV