PREVIEW / stock_1hour / 2009-10-15
file: by_date/stock_1hour/2009/2009-10-15.parquet size: 894 KB rows: 42,731 symbols: 3,384
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-10-15 05:00:00 | AAPL | Stock | 6.8364 | 6.8364 | 6.8364 | 6.8364 | 4620.0 |
| 2009-10-15 07:00:00 | AAPL | Stock | 6.8036 | 6.8321 | 6.7871 | 6.7929 | 81004.0 |
| 2009-10-15 08:00:00 | AAPL | Stock | 6.8036 | 6.8136 | 6.7768 | 6.7839 | 2571940.0 |
| 2009-10-15 09:00:00 | AAPL | Stock | 6.7839 | 6.7918 | 6.76 | 6.79 | 41507956.0 |
| 2009-10-15 10:00:00 | AAPL | Stock | 6.79 | 6.8186 | 6.7832 | 6.7893 | 74153436.0 |
| 2009-10-15 11:00:00 | AAPL | Stock | 6.7896 | 6.8 | 6.7807 | 6.7982 | 39864160.0 |
| 2009-10-15 12:00:00 | AAPL | Stock | 6.7986 | 6.8064 | 6.7807 | 6.7836 | 31474212.0 |
| 2009-10-15 13:00:00 | AAPL | Stock | 6.7829 | 6.7911 | 6.7811 | 6.7844 | 30722832.0 |
| 2009-10-15 14:00:00 | AAPL | Stock | 6.785 | 6.8 | 6.7689 | 6.7914 | 52499300.0 |
| 2009-10-15 15:00:00 | AAPL | Stock | 6.7918 | 6.8057 | 6.7779 | 6.8057 | 64231048.0 |
| 2009-10-15 16:00:00 | AAPL | Stock | 6.8057 | 6.825 | 6.7868 | 6.8023 | 24029796.0 |
| 2009-10-15 17:00:00 | AAPL | Stock | 6.7964 | 6.8114 | 6.7964 | 6.8089 | 364588.0 |
| 2009-10-15 18:00:00 | AAPL | Stock | 6.8107 | 6.8143 | 6.805 | 6.8125 | 232288.0 |
| 2009-10-15 19:00:00 | AAPL | Stock | 6.8136 | 6.8211 | 6.8132 | 6.8136 | 303856.0 |
| 2009-10-15 05:00:00 | MSFT | Stock | 26.11 | 26.11 | 26.11 | 26.11 | 700.0 |
| 2009-10-15 06:00:00 | MSFT | Stock | 26.27 | 26.27 | 26.26 | 26.26 | 750.0 |
| 2009-10-15 07:00:00 | MSFT | Stock | 26.16 | 26.16 | 25.9 | 25.9 | 6498.0 |
| 2009-10-15 08:00:00 | MSFT | Stock | 25.96 | 25.98 | 25.83 | 25.87 | 20793.0 |
| 2009-10-15 09:00:00 | MSFT | Stock | 25.87 | 26.23 | 25.87 | 26.23 | 5194546.0 |
| 2009-10-15 10:00:00 | MSFT | Stock | 26.23 | 26.33 | 26.15 | 26.24 | 8540977.0 |
| 2009-10-15 11:00:00 | MSFT | Stock | 26.25 | 26.33 | 26.14 | 26.305 | 4424322.0 |
| 2009-10-15 12:00:00 | MSFT | Stock | 26.305 | 26.55 | 26.3 | 26.51 | 10707797.0 |
| 2009-10-15 13:00:00 | MSFT | Stock | 26.51 | 26.58 | 26.3 | 26.5 | 4492820.0 |
| 2009-10-15 14:00:00 | MSFT | Stock | 26.49 | 26.57 | 26.47 | 26.55 | 7874296.0 |
| 2009-10-15 15:00:00 | MSFT | Stock | 26.541 | 26.71 | 26.53 | 26.71 | 14240487.0 |
| 2009-10-15 16:00:00 | MSFT | Stock | 26.71 | 26.72 | 26.394 | 26.697 | 6623466.0 |
| 2009-10-15 17:00:00 | MSFT | Stock | 26.56 | 26.6 | 26.47 | 26.6 | 1961815.0 |
| 2009-10-15 18:00:00 | MSFT | Stock | 26.71 | 26.71 | 26.57 | 26.58 | 51084.0 |
| 2009-10-15 19:00:00 | MSFT | Stock | 26.57 | 26.8 | 26.57 | 26.65 | 7964.0 |
| 2009-10-15 08:00:00 | NVDA | Stock | 0.3485 | 0.3525 | 0.3485 | 0.3488 | 326000.0 |
| 2009-10-15 09:00:00 | NVDA | Stock | 0.3488 | 0.3513 | 0.3475 | 0.3506 | 56691240.0 |
| 2009-10-15 10:00:00 | NVDA | Stock | 0.3508 | 0.3513 | 0.342 | 0.3445 | 139570520.0 |
| 2009-10-15 11:00:00 | NVDA | Stock | 0.3445 | 0.3455 | 0.3395 | 0.3398 | 134871320.0 |
| 2009-10-15 12:00:00 | NVDA | Stock | 0.3397 | 0.3433 | 0.339 | 0.339 | 130704880.0 |
| 2009-10-15 13:00:00 | NVDA | Stock | 0.3393 | 0.3405 | 0.3375 | 0.3378 | 162626160.0 |
| 2009-10-15 14:00:00 | NVDA | Stock | 0.3375 | 0.3388 | 0.3368 | 0.3375 | 144183040.0 |
| 2009-10-15 15:00:00 | NVDA | Stock | 0.3373 | 0.3398 | 0.336 | 0.3385 | 259361560.0 |
| 2009-10-15 16:00:00 | NVDA | Stock | 0.3382 | 0.3407 | 0.3368 | 0.3388 | 37122960.0 |
| 2009-10-15 17:00:00 | NVDA | Stock | 0.3388 | 0.3395 | 0.3385 | 0.3385 | 251800.0 |
| 2009-10-15 18:00:00 | NVDA | Stock | 0.3385 | 0.3385 | 0.338 | 0.338 | 104000.0 |
| 2009-10-15 19:00:00 | NVDA | Stock | 0.339 | 0.339 | 0.3382 | 0.339 | 152000.0 |
| 2009-10-15 06:00:00 | AMZN | Stock | 4.8505 | 4.8505 | 4.8385 | 4.8385 | 48000.0 |
| 2009-10-15 07:00:00 | AMZN | Stock | 4.83 | 4.83 | 4.8285 | 4.8285 | 13000.0 |
| 2009-10-15 08:00:00 | AMZN | Stock | 4.847 | 4.85 | 4.7415 | 4.746 | 963860.0 |
| 2009-10-15 09:00:00 | AMZN | Stock | 4.742 | 4.847 | 4.742 | 4.843 | 22789140.0 |
| 2009-10-15 10:00:00 | AMZN | Stock | 4.843 | 4.853 | 4.7795 | 4.803 | 22674500.0 |
| 2009-10-15 11:00:00 | AMZN | Stock | 4.8023 | 4.8045 | 4.765 | 4.7685 | 11675880.0 |
| 2009-10-15 12:00:00 | AMZN | Stock | 4.7675 | 4.804 | 4.767 | 4.785 | 10005640.0 |
| 2009-10-15 13:00:00 | AMZN | Stock | 4.7855 | 4.795 | 4.7745 | 4.7815 | 11406580.0 |
| 2009-10-15 14:00:00 | AMZN | Stock | 4.7825 | 4.8105 | 4.765 | 4.809 | 11895020.0 |
> showing 50 of 42,731 rows — these rows as CSV