PREVIEW / stock_30min / 2008-09-17
file: by_date/stock_30min/2008/2008-09-17.parquet size: 1.4 MB rows: 78,274 symbols: 3,365
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-17 06:00:00 | AAPL | Stock | 5.02 | 5.02 | 5.0157 | 5.0157 | 8400.0 |
| 2008-09-17 06:30:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0132 | 5.0132 | 8400.0 |
| 2008-09-17 07:00:00 | AAPL | Stock | 5.0357 | 5.0357 | 4.9904 | 5.0036 | 149800.0 |
| 2008-09-17 07:30:00 | AAPL | Stock | 4.9875 | 5.025 | 4.9875 | 5.0107 | 41748.0 |
| 2008-09-17 08:00:00 | AAPL | Stock | 5.0007 | 5.025 | 4.9896 | 5.0014 | 1129968.0 |
| 2008-09-17 08:30:00 | AAPL | Stock | 5.0014 | 5.0125 | 4.9639 | 4.9757 | 938840.0 |
| 2008-09-17 09:00:00 | AAPL | Stock | 4.9779 | 4.9814 | 4.9361 | 4.9493 | 1297912.0 |
| 2008-09-17 09:30:00 | AAPL | Stock | 4.9411 | 4.9468 | 4.7889 | 4.8771 | 124223148.0 |
| 2008-09-17 10:00:00 | AAPL | Stock | 4.8768 | 4.8971 | 4.8214 | 4.8321 | 87324804.0 |
| 2008-09-17 10:30:00 | AAPL | Stock | 4.8336 | 4.8655 | 4.7979 | 4.8409 | 71914220.0 |
| 2008-09-17 11:00:00 | AAPL | Stock | 4.8407 | 4.8489 | 4.6736 | 4.6786 | 79243864.0 |
| 2008-09-17 11:30:00 | AAPL | Stock | 4.6786 | 4.7768 | 4.6739 | 4.7443 | 73453296.0 |
| 2008-09-17 12:00:00 | AAPL | Stock | 4.7451 | 4.7668 | 4.6964 | 4.7245 | 56394492.0 |
| 2008-09-17 12:30:00 | AAPL | Stock | 4.7229 | 4.7839 | 4.7226 | 4.7296 | 50110704.0 |
| 2008-09-17 13:00:00 | AAPL | Stock | 4.7282 | 4.7696 | 4.6789 | 4.6862 | 41631632.0 |
| 2008-09-17 13:30:00 | AAPL | Stock | 4.6859 | 4.6929 | 4.6161 | 4.6596 | 94255028.0 |
| 2008-09-17 14:00:00 | AAPL | Stock | 4.6604 | 4.6839 | 4.5779 | 4.6693 | 102423440.0 |
| 2008-09-17 14:30:00 | AAPL | Stock | 4.6693 | 4.7479 | 4.6446 | 4.6864 | 91132972.0 |
| 2008-09-17 15:00:00 | AAPL | Stock | 4.685 | 4.7886 | 4.6743 | 4.75 | 115232068.0 |
| 2008-09-17 15:30:00 | AAPL | Stock | 4.7504 | 4.7518 | 4.5664 | 4.5664 | 128323664.0 |
| 2008-09-17 16:00:00 | AAPL | Stock | 4.5714 | 4.748 | 4.5654 | 4.5732 | 27508488.0 |
| 2008-09-17 16:30:00 | AAPL | Stock | 4.5796 | 4.742 | 4.5654 | 4.5654 | 27675144.0 |
| 2008-09-17 17:00:00 | AAPL | Stock | 4.6046 | 4.6071 | 4.56 | 4.5625 | 1336048.0 |
| 2008-09-17 17:30:00 | AAPL | Stock | 4.5668 | 4.6805 | 4.5571 | 4.5786 | 249424.0 |
| 2008-09-17 18:00:00 | AAPL | Stock | 4.5786 | 4.699 | 4.5714 | 4.585 | 249116.0 |
| 2008-09-17 18:30:00 | AAPL | Stock | 4.585 | 4.6071 | 4.585 | 4.5875 | 133588.0 |
| 2008-09-17 19:00:00 | AAPL | Stock | 4.585 | 4.5875 | 4.5732 | 4.5775 | 146580.0 |
| 2008-09-17 19:30:00 | AAPL | Stock | 4.5775 | 4.5839 | 4.5639 | 4.5714 | 332472.0 |
| 2008-09-17 08:00:00 | MSFT | Stock | 26.0 | 26.1 | 25.96 | 25.96 | 4858.0 |
| 2008-09-17 08:30:00 | MSFT | Stock | 25.91 | 26.08 | 25.8 | 25.84 | 28080.0 |
| 2008-09-17 09:00:00 | MSFT | Stock | 25.82 | 25.82 | 25.7 | 25.72 | 21639.0 |
| 2008-09-17 09:30:00 | MSFT | Stock | 25.73 | 25.87 | 25.55 | 25.71 | 6436229.0 |
| 2008-09-17 10:00:00 | MSFT | Stock | 25.72 | 25.78 | 25.49 | 25.54 | 5643353.0 |
| 2008-09-17 10:30:00 | MSFT | Stock | 25.54 | 25.6 | 25.36 | 25.48 | 4915297.0 |
| 2008-09-17 11:00:00 | MSFT | Stock | 25.48 | 25.52 | 25.31 | 25.36 | 5630079.0 |
| 2008-09-17 11:30:00 | MSFT | Stock | 25.35 | 25.53 | 25.322 | 25.4 | 5677565.0 |
| 2008-09-17 12:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.13 | 25.2 | 6637497.0 |
| 2008-09-17 12:30:00 | MSFT | Stock | 25.2 | 25.36 | 25.19 | 25.24 | 4897074.0 |
| 2008-09-17 13:00:00 | MSFT | Stock | 25.23 | 25.36 | 25.08 | 25.11 | 5668560.0 |
| 2008-09-17 13:30:00 | MSFT | Stock | 25.11 | 25.14 | 24.92 | 24.962 | 8167843.0 |
| 2008-09-17 14:00:00 | MSFT | Stock | 24.96 | 25.17 | 24.87 | 25.16 | 7525463.0 |
| 2008-09-17 14:30:00 | MSFT | Stock | 25.162 | 25.25 | 24.93 | 25.11 | 9489739.0 |
| 2008-09-17 15:00:00 | MSFT | Stock | 25.112 | 25.44 | 25.04 | 25.24 | 8060903.0 |
| 2008-09-17 15:30:00 | MSFT | Stock | 25.23 | 25.252 | 24.5 | 24.59 | 14355588.0 |
| 2008-09-17 16:00:00 | MSFT | Stock | 24.57 | 25.207 | 24.43 | 24.61 | 6859334.0 |
| 2008-09-17 16:30:00 | MSFT | Stock | 24.61 | 25.103 | 24.57 | 24.57 | 372648.0 |
| 2008-09-17 17:00:00 | MSFT | Stock | 24.62 | 24.95 | 24.57 | 24.95 | 16570.0 |
| 2008-09-17 17:30:00 | MSFT | Stock | 24.98 | 24.99 | 24.62 | 24.66 | 32373.0 |
| 2008-09-17 18:00:00 | MSFT | Stock | 24.66 | 24.76 | 24.55 | 24.58 | 3325960.0 |
| 2008-09-17 18:30:00 | MSFT | Stock | 24.67 | 24.83 | 24.54 | 24.6 | 51388.0 |
> showing 50 of 78,274 rows — these rows as CSV