PREVIEW / stock_5min / 2011-12-15
file: by_date/stock_5min/2011/2011-12-15.parquet size: 4.8 MB rows: 328,242 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 |
|---|---|---|---|---|---|---|---|
| 2011-12-15 04:00:00 | AAPL | Stock | 13.5393 | 13.6071 | 13.5393 | 13.6071 | 28000.0 |
| 2011-12-15 04:40:00 | AAPL | Stock | 13.6111 | 13.6111 | 13.6111 | 13.6111 | 5600.0 |
| 2011-12-15 04:45:00 | AAPL | Stock | 13.6111 | 13.63 | 13.6111 | 13.63 | 16800.0 |
| 2011-12-15 06:50:00 | AAPL | Stock | 13.6439 | 13.6439 | 13.6439 | 13.6439 | 15792.0 |
| 2011-12-15 07:00:00 | AAPL | Stock | 13.6436 | 13.6571 | 13.6393 | 13.6571 | 72240.0 |
| 2011-12-15 07:05:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 13440.0 |
| 2011-12-15 07:10:00 | AAPL | Stock | 13.6679 | 13.6964 | 13.6679 | 13.6964 | 170856.0 |
| 2011-12-15 07:15:00 | AAPL | Stock | 13.7089 | 13.7089 | 13.7014 | 13.7064 | 28028.0 |
| 2011-12-15 07:20:00 | AAPL | Stock | 13.7039 | 13.7089 | 13.6964 | 13.6964 | 64400.0 |
| 2011-12-15 07:25:00 | AAPL | Stock | 13.6968 | 13.7014 | 13.6911 | 13.7014 | 70000.0 |
| 2011-12-15 07:30:00 | AAPL | Stock | 13.6879 | 13.7143 | 13.6879 | 13.7143 | 58744.0 |
| 2011-12-15 07:35:00 | AAPL | Stock | 13.7 | 13.7104 | 13.6982 | 13.7021 | 43400.0 |
| 2011-12-15 07:40:00 | AAPL | Stock | 13.7032 | 13.7032 | 13.6893 | 13.6893 | 69384.0 |
| 2011-12-15 07:45:00 | AAPL | Stock | 13.69 | 13.6964 | 13.6893 | 13.6893 | 8400.0 |
| 2011-12-15 07:50:00 | AAPL | Stock | 13.6964 | 13.7 | 13.6893 | 13.7 | 40180.0 |
| 2011-12-15 07:55:00 | AAPL | Stock | 13.7032 | 13.7054 | 13.6921 | 13.705 | 72800.0 |
| 2011-12-15 08:00:00 | AAPL | Stock | 13.6943 | 13.7 | 13.6796 | 13.6896 | 219800.0 |
| 2011-12-15 08:05:00 | AAPL | Stock | 13.6875 | 13.6875 | 13.6768 | 13.6768 | 171080.0 |
| 2011-12-15 08:10:00 | AAPL | Stock | 13.6743 | 13.7 | 13.6743 | 13.6971 | 193508.0 |
| 2011-12-15 08:15:00 | AAPL | Stock | 13.6893 | 13.7196 | 13.6893 | 13.7143 | 370076.0 |
| 2011-12-15 08:20:00 | AAPL | Stock | 13.7054 | 13.7143 | 13.6964 | 13.6979 | 152824.0 |
| 2011-12-15 08:25:00 | AAPL | Stock | 13.6993 | 13.7071 | 13.6993 | 13.7032 | 99400.0 |
| 2011-12-15 08:30:00 | AAPL | Stock | 13.7036 | 13.7321 | 13.7036 | 13.7268 | 434560.0 |
| 2011-12-15 08:35:00 | AAPL | Stock | 13.7268 | 13.7321 | 13.7079 | 13.7143 | 197288.0 |
| 2011-12-15 08:40:00 | AAPL | Stock | 13.7143 | 13.715 | 13.7054 | 13.7054 | 265496.0 |
| 2011-12-15 08:45:00 | AAPL | Stock | 13.7054 | 13.7139 | 13.7054 | 13.7139 | 60480.0 |
| 2011-12-15 08:50:00 | AAPL | Stock | 13.7132 | 13.7282 | 13.7132 | 13.7246 | 136360.0 |
| 2011-12-15 08:55:00 | AAPL | Stock | 13.7232 | 13.725 | 13.7143 | 13.7214 | 119840.0 |
| 2011-12-15 09:00:00 | AAPL | Stock | 13.7196 | 13.7211 | 13.7107 | 13.7136 | 195440.0 |
| 2011-12-15 09:05:00 | AAPL | Stock | 13.7107 | 13.7125 | 13.7036 | 13.7057 | 78120.0 |
| 2011-12-15 09:10:00 | AAPL | Stock | 13.7064 | 13.71 | 13.7064 | 13.71 | 171304.0 |
| 2011-12-15 09:15:00 | AAPL | Stock | 13.7104 | 13.7121 | 13.7054 | 13.7054 | 45668.0 |
| 2011-12-15 09:20:00 | AAPL | Stock | 13.7089 | 13.7089 | 13.6964 | 13.7089 | 166684.0 |
| 2011-12-15 09:25:00 | AAPL | Stock | 13.7096 | 13.7143 | 13.6786 | 13.6943 | 524888.0 |
| 2011-12-15 09:30:00 | AAPL | Stock | 13.6921 | 13.705 | 13.6472 | 13.65 | 13932128.0 |
| 2011-12-15 09:35:00 | AAPL | Stock | 13.6489 | 13.67 | 13.6371 | 13.6396 | 5660676.0 |
| 2011-12-15 09:40:00 | AAPL | Stock | 13.6368 | 13.6639 | 13.6332 | 13.6471 | 4931948.0 |
| 2011-12-15 09:45:00 | AAPL | Stock | 13.6471 | 13.6579 | 13.6304 | 13.6371 | 3339056.0 |
| 2011-12-15 09:50:00 | AAPL | Stock | 13.6371 | 13.6486 | 13.5893 | 13.6029 | 5962180.0 |
| 2011-12-15 09:55:00 | AAPL | Stock | 13.6018 | 13.6321 | 13.5929 | 13.6121 | 5644072.0 |
| 2011-12-15 10:00:00 | AAPL | Stock | 13.6136 | 13.6379 | 13.5914 | 13.6118 | 5569900.0 |
| 2011-12-15 10:05:00 | AAPL | Stock | 13.6139 | 13.6146 | 13.5821 | 13.6071 | 4883788.0 |
| 2011-12-15 10:10:00 | AAPL | Stock | 13.6068 | 13.6071 | 13.5657 | 13.5893 | 4449564.0 |
| 2011-12-15 10:15:00 | AAPL | Stock | 13.5929 | 13.6014 | 13.5782 | 13.5986 | 3190460.0 |
| 2011-12-15 10:20:00 | AAPL | Stock | 13.6011 | 13.6225 | 13.5971 | 13.6186 | 4997860.0 |
| 2011-12-15 10:25:00 | AAPL | Stock | 13.6187 | 13.6314 | 13.6129 | 13.6152 | 3575600.0 |
| 2011-12-15 10:30:00 | AAPL | Stock | 13.6161 | 13.6221 | 13.5932 | 13.6121 | 3887128.0 |
| 2011-12-15 10:35:00 | AAPL | Stock | 13.6121 | 13.6193 | 13.5757 | 13.5797 | 4362904.0 |
| 2011-12-15 10:40:00 | AAPL | Stock | 13.5811 | 13.6061 | 13.5632 | 13.5725 | 4634616.0 |
| 2011-12-15 10:45:00 | AAPL | Stock | 13.5696 | 13.5779 | 13.554 | 13.5632 | 5182128.0 |
> showing 50 of 328,242 rows — these rows as CSV