PREVIEW / stock_30min / 2010-12-22
file: by_date/stock_30min/2010/2010-12-22.parquet size: 1.4 MB rows: 76,184 symbols: 3,548
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-22 05:30:00 | AAPL | Stock | 11.5914 | 11.5914 | 11.5843 | 11.5843 | 11200.0 |
| 2010-12-22 06:00:00 | AAPL | Stock | 11.5975 | 11.5975 | 11.5975 | 11.5975 | 2800.0 |
| 2010-12-22 07:00:00 | AAPL | Stock | 11.5929 | 11.6143 | 11.5929 | 11.6096 | 51660.0 |
| 2010-12-22 07:30:00 | AAPL | Stock | 11.6029 | 11.6071 | 11.5964 | 11.6014 | 88872.0 |
| 2010-12-22 08:00:00 | AAPL | Stock | 11.5964 | 11.6036 | 11.5714 | 11.5875 | 1106784.0 |
| 2010-12-22 08:30:00 | AAPL | Stock | 11.5875 | 11.5929 | 11.5736 | 11.5832 | 1748656.0 |
| 2010-12-22 09:00:00 | AAPL | Stock | 11.5861 | 11.5929 | 11.5793 | 11.5846 | 798420.0 |
| 2010-12-22 09:30:00 | AAPL | Stock | 11.5854 | 11.6071 | 11.5739 | 11.5846 | 38203424.0 |
| 2010-12-22 10:00:00 | AAPL | Stock | 11.5839 | 11.5893 | 11.5554 | 11.5729 | 25416132.0 |
| 2010-12-22 10:30:00 | AAPL | Stock | 11.5739 | 11.5982 | 11.57 | 11.5979 | 15235052.0 |
| 2010-12-22 11:00:00 | AAPL | Stock | 11.5975 | 11.6161 | 11.5932 | 11.6093 | 33821508.0 |
| 2010-12-22 11:30:00 | AAPL | Stock | 11.6096 | 11.6186 | 11.6071 | 11.6107 | 24898216.0 |
| 2010-12-22 12:00:00 | AAPL | Stock | 11.6111 | 11.6268 | 11.61 | 11.6254 | 22703016.0 |
| 2010-12-22 12:30:00 | AAPL | Stock | 11.6254 | 11.6329 | 11.6114 | 11.6243 | 13967576.0 |
| 2010-12-22 13:00:00 | AAPL | Stock | 11.6243 | 11.6282 | 11.6179 | 11.6267 | 6184668.0 |
| 2010-12-22 13:30:00 | AAPL | Stock | 11.6264 | 11.6268 | 11.5968 | 11.604 | 13727504.0 |
| 2010-12-22 14:00:00 | AAPL | Stock | 11.6029 | 11.616 | 11.6025 | 11.6104 | 6455176.0 |
| 2010-12-22 14:30:00 | AAPL | Stock | 11.6114 | 11.6161 | 11.6057 | 11.6146 | 6484660.0 |
| 2010-12-22 15:00:00 | AAPL | Stock | 11.6125 | 11.6279 | 11.6098 | 11.6211 | 10871616.0 |
| 2010-12-22 15:30:00 | AAPL | Stock | 11.6211 | 11.6286 | 11.6071 | 11.6161 | 22503712.0 |
| 2010-12-22 16:00:00 | AAPL | Stock | 11.6129 | 11.6193 | 11.5757 | 11.6061 | 5584068.0 |
| 2010-12-22 16:30:00 | AAPL | Stock | 11.6061 | 11.6211 | 11.6039 | 11.6068 | 778204.0 |
| 2010-12-22 17:00:00 | AAPL | Stock | 11.6129 | 11.6129 | 11.6046 | 11.6071 | 338380.0 |
| 2010-12-22 17:30:00 | AAPL | Stock | 11.6089 | 11.61 | 11.6089 | 11.6089 | 26992.0 |
| 2010-12-22 18:00:00 | AAPL | Stock | 11.61 | 11.6129 | 11.6096 | 11.6096 | 91644.0 |
| 2010-12-22 18:30:00 | AAPL | Stock | 11.6089 | 11.6118 | 11.6075 | 11.6096 | 61460.0 |
| 2010-12-22 19:00:00 | AAPL | Stock | 11.6075 | 11.6086 | 11.6061 | 11.6086 | 81368.0 |
| 2010-12-22 19:30:00 | AAPL | Stock | 11.6089 | 11.6121 | 11.6057 | 11.6118 | 81144.0 |
| 2010-12-22 05:30:00 | MSFT | Stock | 28.12 | 28.12 | 28.07 | 28.07 | 1800.0 |
| 2010-12-22 07:00:00 | MSFT | Stock | 28.11 | 28.11 | 28.09 | 28.09 | 2595.0 |
| 2010-12-22 07:30:00 | MSFT | Stock | 28.14 | 28.15 | 28.09 | 28.12 | 3600.0 |
| 2010-12-22 08:00:00 | MSFT | Stock | 28.14 | 28.15 | 28.11 | 28.11 | 6450.0 |
| 2010-12-22 08:30:00 | MSFT | Stock | 28.14 | 28.15 | 28.14 | 28.14 | 9150.0 |
| 2010-12-22 09:00:00 | MSFT | Stock | 28.13 | 28.15 | 27.99 | 27.99 | 110173.0 |
| 2010-12-22 09:30:00 | MSFT | Stock | 27.99 | 28.4 | 27.98 | 28.31 | 6540901.0 |
| 2010-12-22 10:00:00 | MSFT | Stock | 28.31 | 28.36 | 28.28 | 28.303 | 4100457.0 |
| 2010-12-22 10:30:00 | MSFT | Stock | 28.31 | 28.33 | 28.18 | 28.24 | 5178936.0 |
| 2010-12-22 11:00:00 | MSFT | Stock | 28.239 | 28.26 | 28.22 | 28.25 | 2563358.0 |
| 2010-12-22 11:30:00 | MSFT | Stock | 28.246 | 28.34 | 28.24 | 28.25 | 2780350.0 |
| 2010-12-22 12:00:00 | MSFT | Stock | 28.244 | 28.33 | 28.23 | 28.31 | 1820255.0 |
| 2010-12-22 12:30:00 | MSFT | Stock | 28.32 | 28.33 | 28.26 | 28.3 | 1693496.0 |
| 2010-12-22 13:00:00 | MSFT | Stock | 28.3 | 28.3 | 28.24 | 28.27 | 1698005.0 |
| 2010-12-22 13:30:00 | MSFT | Stock | 28.27 | 28.27 | 28.2 | 28.225 | 1930271.0 |
| 2010-12-22 14:00:00 | MSFT | Stock | 28.22 | 28.26 | 28.21 | 28.26 | 1472478.0 |
| 2010-12-22 14:30:00 | MSFT | Stock | 28.26 | 28.26 | 28.2 | 28.2 | 1250631.0 |
| 2010-12-22 15:00:00 | MSFT | Stock | 28.2 | 28.24 | 28.18 | 28.19 | 1889858.0 |
| 2010-12-22 15:30:00 | MSFT | Stock | 28.19 | 28.25 | 28.15 | 28.18 | 4329367.0 |
| 2010-12-22 16:00:00 | MSFT | Stock | 28.18 | 28.27 | 28.07 | 28.19 | 1198828.0 |
| 2010-12-22 16:30:00 | MSFT | Stock | 28.232 | 28.232 | 28.2 | 28.2 | 12000.0 |
| 2010-12-22 17:00:00 | MSFT | Stock | 28.18 | 28.19 | 28.18 | 28.19 | 11000.0 |
> showing 50 of 76,184 rows — these rows as CSV