PREVIEW / stock_1hour / 2009-07-29
file: by_date/stock_1hour/2009/2009-07-29.parquet size: 881 KB rows: 43,856 symbols: 3,338
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-07-29 04:00:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 4200.0 |
| 2009-07-29 07:00:00 | AAPL | Stock | 5.6896 | 5.7032 | 5.6864 | 5.7032 | 56588.0 |
| 2009-07-29 08:00:00 | AAPL | Stock | 5.6868 | 5.6986 | 5.6786 | 5.6786 | 688016.0 |
| 2009-07-29 09:00:00 | AAPL | Stock | 5.6796 | 5.6929 | 5.6518 | 5.6689 | 44550380.0 |
| 2009-07-29 10:00:00 | AAPL | Stock | 5.6696 | 5.7143 | 5.6643 | 5.7057 | 72454256.0 |
| 2009-07-29 11:00:00 | AAPL | Stock | 5.7057 | 5.7107 | 5.6718 | 5.7036 | 43292956.0 |
| 2009-07-29 12:00:00 | AAPL | Stock | 5.7032 | 5.7146 | 5.695 | 5.7021 | 42425516.0 |
| 2009-07-29 13:00:00 | AAPL | Stock | 5.7021 | 5.7025 | 5.6714 | 5.6996 | 47588324.0 |
| 2009-07-29 14:00:00 | AAPL | Stock | 5.7 | 5.71 | 5.6861 | 5.6936 | 39319056.0 |
| 2009-07-29 15:00:00 | AAPL | Stock | 5.6943 | 5.7304 | 5.6921 | 5.7161 | 81376820.0 |
| 2009-07-29 16:00:00 | AAPL | Stock | 5.7154 | 5.7193 | 5.6772 | 5.7146 | 6630092.0 |
| 2009-07-29 17:00:00 | AAPL | Stock | 5.7146 | 5.7171 | 5.7026 | 5.7171 | 283276.0 |
| 2009-07-29 18:00:00 | AAPL | Stock | 5.7154 | 5.7189 | 5.7154 | 5.7171 | 250208.0 |
| 2009-07-29 19:00:00 | AAPL | Stock | 5.7154 | 5.7225 | 5.7154 | 5.7211 | 149072.0 |
| 2009-07-29 04:00:00 | MSFT | Stock | 23.57 | 23.64 | 23.56 | 23.64 | 600.0 |
| 2009-07-29 05:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 200.0 |
| 2009-07-29 06:00:00 | MSFT | Stock | 23.56 | 23.57 | 23.56 | 23.57 | 700.0 |
| 2009-07-29 07:00:00 | MSFT | Stock | 23.57 | 23.75 | 23.3 | 23.7 | 129979.0 |
| 2009-07-29 08:00:00 | MSFT | Stock | 23.65 | 23.89 | 23.51 | 23.57 | 2194206.0 |
| 2009-07-29 09:00:00 | MSFT | Stock | 23.56 | 23.91 | 23.47 | 23.58 | 12318624.0 |
| 2009-07-29 10:00:00 | MSFT | Stock | 23.58 | 23.72 | 23.5 | 23.57 | 11719290.0 |
| 2009-07-29 11:00:00 | MSFT | Stock | 23.58 | 23.67 | 23.46 | 23.54 | 8382310.0 |
| 2009-07-29 12:00:00 | MSFT | Stock | 23.55 | 23.63 | 23.52 | 23.531 | 5134142.0 |
| 2009-07-29 13:00:00 | MSFT | Stock | 23.53 | 23.56 | 23.34 | 23.5 | 8537389.0 |
| 2009-07-29 14:00:00 | MSFT | Stock | 23.51 | 23.68 | 23.43 | 23.63 | 8374498.0 |
| 2009-07-29 15:00:00 | MSFT | Stock | 23.64 | 23.88 | 23.63 | 23.79 | 13120863.0 |
| 2009-07-29 16:00:00 | MSFT | Stock | 23.77 | 23.82 | 23.54 | 23.78 | 2098945.0 |
| 2009-07-29 17:00:00 | MSFT | Stock | 23.78 | 23.83 | 23.559 | 23.78 | 26245.0 |
| 2009-07-29 18:00:00 | MSFT | Stock | 23.78 | 23.8 | 23.68 | 23.8 | 22569.0 |
| 2009-07-29 19:00:00 | MSFT | Stock | 23.79 | 23.84 | 23.72 | 23.8 | 12828.0 |
| 2009-07-29 08:00:00 | NVDA | Stock | 0.3245 | 0.3248 | 0.32 | 0.32 | 380000.0 |
| 2009-07-29 09:00:00 | NVDA | Stock | 0.3203 | 0.3243 | 0.32 | 0.3215 | 25713960.0 |
| 2009-07-29 10:00:00 | NVDA | Stock | 0.3215 | 0.3243 | 0.3204 | 0.3207 | 74896800.0 |
| 2009-07-29 11:00:00 | NVDA | Stock | 0.3208 | 0.3215 | 0.3163 | 0.3185 | 73755800.0 |
| 2009-07-29 12:00:00 | NVDA | Stock | 0.3188 | 0.3223 | 0.3186 | 0.3205 | 30694880.0 |
| 2009-07-29 13:00:00 | NVDA | Stock | 0.3205 | 0.3205 | 0.3163 | 0.3188 | 37760640.0 |
| 2009-07-29 14:00:00 | NVDA | Stock | 0.319 | 0.3205 | 0.3175 | 0.3178 | 40191880.0 |
| 2009-07-29 15:00:00 | NVDA | Stock | 0.3178 | 0.3203 | 0.3178 | 0.3198 | 73061960.0 |
| 2009-07-29 16:00:00 | NVDA | Stock | 0.3198 | 0.326 | 0.3183 | 0.3195 | 14110360.0 |
| 2009-07-29 17:00:00 | NVDA | Stock | 0.3195 | 0.3195 | 0.3188 | 0.3188 | 255280.0 |
| 2009-07-29 18:00:00 | NVDA | Stock | 0.3188 | 0.3188 | 0.3188 | 0.3188 | 32000.0 |
| 2009-07-29 04:00:00 | AMZN | Stock | 4.245 | 4.245 | 4.245 | 4.245 | 2360.0 |
| 2009-07-29 08:00:00 | AMZN | Stock | 4.2375 | 4.2375 | 4.215 | 4.215 | 110260.0 |
| 2009-07-29 09:00:00 | AMZN | Stock | 4.2175 | 4.2385 | 4.176 | 4.184 | 15934660.0 |
| 2009-07-29 10:00:00 | AMZN | Stock | 4.183 | 4.25 | 4.183 | 4.2355 | 30148480.0 |
| 2009-07-29 11:00:00 | AMZN | Stock | 4.2365 | 4.2435 | 4.2105 | 4.2335 | 10075760.0 |
| 2009-07-29 12:00:00 | AMZN | Stock | 4.2335 | 4.275 | 4.225 | 4.2597 | 12523860.0 |
| 2009-07-29 13:00:00 | AMZN | Stock | 4.26 | 4.26 | 4.213 | 4.2375 | 10142960.0 |
| 2009-07-29 14:00:00 | AMZN | Stock | 4.2385 | 4.2695 | 4.229 | 4.231 | 18566980.0 |
| 2009-07-29 15:00:00 | AMZN | Stock | 4.2295 | 4.244 | 4.2035 | 4.217 | 29183040.0 |
> showing 50 of 43,856 rows — these rows as CSV