PREVIEW / stock_30min / 2009-09-22
file: by_date/stock_30min/2009/2009-09-22.parquet size: 1.3 MB rows: 72,568 symbols: 3,395
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-09-22 04:00:00 | AAPL | Stock | 6.5961 | 6.5961 | 6.5961 | 6.5961 | 2800.0 |
| 2009-09-22 05:30:00 | AAPL | Stock | 6.6079 | 6.6079 | 6.6079 | 6.6079 | 2800.0 |
| 2009-09-22 06:00:00 | AAPL | Stock | 6.6161 | 6.625 | 6.6154 | 6.625 | 36400.0 |
| 2009-09-22 07:00:00 | AAPL | Stock | 6.6161 | 6.6268 | 6.6089 | 6.625 | 64400.0 |
| 2009-09-22 07:30:00 | AAPL | Stock | 6.6268 | 6.6329 | 6.6246 | 6.6329 | 57680.0 |
| 2009-09-22 08:00:00 | AAPL | Stock | 6.6189 | 6.6429 | 6.6143 | 6.6375 | 1102108.0 |
| 2009-09-22 08:30:00 | AAPL | Stock | 6.6357 | 6.6382 | 6.6293 | 6.6336 | 441952.0 |
| 2009-09-22 09:00:00 | AAPL | Stock | 6.6336 | 6.6336 | 6.6089 | 6.6125 | 1207948.0 |
| 2009-09-22 09:30:00 | AAPL | Stock | 6.6136 | 6.6207 | 6.5596 | 6.5636 | 74689580.0 |
| 2009-09-22 10:00:00 | AAPL | Stock | 6.5636 | 6.5907 | 6.5586 | 6.56 | 34765724.0 |
| 2009-09-22 10:30:00 | AAPL | Stock | 6.56 | 6.5607 | 6.5304 | 6.5487 | 32437244.0 |
| 2009-09-22 11:00:00 | AAPL | Stock | 6.5493 | 6.5868 | 6.5486 | 6.5836 | 20113688.0 |
| 2009-09-22 11:30:00 | AAPL | Stock | 6.5836 | 6.5946 | 6.5661 | 6.5946 | 17462256.0 |
| 2009-09-22 12:00:00 | AAPL | Stock | 6.5932 | 6.6098 | 6.5796 | 6.5879 | 22164520.0 |
| 2009-09-22 12:30:00 | AAPL | Stock | 6.5872 | 6.5914 | 6.5739 | 6.5857 | 11814964.0 |
| 2009-09-22 13:00:00 | AAPL | Stock | 6.585 | 6.5979 | 6.5718 | 6.5757 | 16631580.0 |
| 2009-09-22 13:30:00 | AAPL | Stock | 6.5752 | 6.5882 | 6.5721 | 6.5807 | 11557392.0 |
| 2009-09-22 14:00:00 | AAPL | Stock | 6.5807 | 6.5896 | 6.5739 | 6.5811 | 12150292.0 |
| 2009-09-22 14:30:00 | AAPL | Stock | 6.5814 | 6.5979 | 6.5754 | 6.5935 | 16167816.0 |
| 2009-09-22 15:00:00 | AAPL | Stock | 6.5939 | 6.5961 | 6.5764 | 6.5882 | 20313916.0 |
| 2009-09-22 15:30:00 | AAPL | Stock | 6.5876 | 6.5989 | 6.5821 | 6.5886 | 28773920.0 |
| 2009-09-22 16:00:00 | AAPL | Stock | 6.5907 | 6.5957 | 6.543 | 6.5886 | 9634968.0 |
| 2009-09-22 16:30:00 | AAPL | Stock | 6.5893 | 6.5896 | 6.5854 | 6.5882 | 95144.0 |
| 2009-09-22 17:00:00 | AAPL | Stock | 6.5864 | 6.5914 | 6.5864 | 6.5914 | 11406556.0 |
| 2009-09-22 17:30:00 | AAPL | Stock | 6.5886 | 6.5886 | 6.5854 | 6.5854 | 12376.0 |
| 2009-09-22 18:00:00 | AAPL | Stock | 6.5886 | 6.5968 | 6.5886 | 6.5968 | 181832.0 |
| 2009-09-22 18:30:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5893 | 6.5893 | 32480.0 |
| 2009-09-22 19:00:00 | AAPL | Stock | 6.5911 | 6.5929 | 6.5875 | 6.5893 | 40040.0 |
| 2009-09-22 19:30:00 | AAPL | Stock | 6.5911 | 6.5911 | 6.5832 | 6.5854 | 72716.0 |
| 2009-09-22 06:00:00 | MSFT | Stock | 25.49 | 25.49 | 25.49 | 25.49 | 386.0 |
| 2009-09-22 07:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.42 | 25.42 | 500.0 |
| 2009-09-22 08:00:00 | MSFT | Stock | 25.42 | 25.45 | 25.4 | 25.4 | 7791.0 |
| 2009-09-22 08:30:00 | MSFT | Stock | 25.4 | 25.41 | 25.4 | 25.4 | 4700.0 |
| 2009-09-22 09:00:00 | MSFT | Stock | 25.4 | 25.49 | 25.37 | 25.41 | 71884.0 |
| 2009-09-22 09:30:00 | MSFT | Stock | 25.41 | 25.46 | 25.29 | 25.38 | 3629081.0 |
| 2009-09-22 10:00:00 | MSFT | Stock | 25.38 | 25.49 | 25.34 | 25.46 | 2714043.0 |
| 2009-09-22 10:30:00 | MSFT | Stock | 25.46 | 25.52 | 25.39 | 25.47 | 4759917.0 |
| 2009-09-22 11:00:00 | MSFT | Stock | 25.47 | 25.569 | 25.462 | 25.51 | 3592817.0 |
| 2009-09-22 11:30:00 | MSFT | Stock | 25.51 | 25.55 | 25.49 | 25.55 | 1849214.0 |
| 2009-09-22 12:00:00 | MSFT | Stock | 25.54 | 25.65 | 25.52 | 25.64 | 4230693.0 |
| 2009-09-22 12:30:00 | MSFT | Stock | 25.64 | 25.7 | 25.64 | 25.67 | 2748491.0 |
| 2009-09-22 13:00:00 | MSFT | Stock | 25.662 | 25.72 | 25.65 | 25.701 | 3261373.0 |
| 2009-09-22 13:30:00 | MSFT | Stock | 25.702 | 25.72 | 25.59 | 25.72 | 3746187.0 |
| 2009-09-22 14:00:00 | MSFT | Stock | 25.71 | 25.73 | 25.66 | 25.692 | 2440758.0 |
| 2009-09-22 14:30:00 | MSFT | Stock | 25.7 | 25.72 | 25.65 | 25.705 | 1977941.0 |
| 2009-09-22 15:00:00 | MSFT | Stock | 25.7 | 25.79 | 25.29 | 25.78 | 4046199.0 |
| 2009-09-22 15:30:00 | MSFT | Stock | 25.79 | 25.82 | 25.65 | 25.77 | 11705627.0 |
| 2009-09-22 16:00:00 | MSFT | Stock | 25.77 | 25.87 | 25.435 | 25.77 | 6476813.0 |
| 2009-09-22 16:30:00 | MSFT | Stock | 25.77 | 25.84 | 25.77 | 25.84 | 1100.0 |
| 2009-09-22 17:00:00 | MSFT | Stock | 25.82 | 25.82 | 25.77 | 25.78 | 583.0 |
> showing 50 of 72,568 rows — these rows as CSV