PREVIEW / stock_5min / 2013-05-21
file: by_date/stock_5min/2013/2013-05-21.parquet size: 5.1 MB rows: 336,125 symbols: 3,508
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-21 04:00:00 | AAPL | Stock | 15.7157 | 15.7157 | 15.7157 | 15.7157 | 8400.0 |
| 2013-05-21 04:10:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 5600.0 |
| 2013-05-21 04:25:00 | AAPL | Stock | 15.7154 | 15.7154 | 15.7154 | 15.7154 | 2800.0 |
| 2013-05-21 05:05:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 5600.0 |
| 2013-05-21 05:25:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 2800.0 |
| 2013-05-21 06:20:00 | AAPL | Stock | 15.6718 | 15.6764 | 15.6718 | 15.6764 | 12600.0 |
| 2013-05-21 06:50:00 | AAPL | Stock | 15.6661 | 15.6696 | 15.6607 | 15.6607 | 38752.0 |
| 2013-05-21 06:55:00 | AAPL | Stock | 15.6643 | 15.6643 | 15.6604 | 15.6604 | 11284.0 |
| 2013-05-21 07:00:00 | AAPL | Stock | 15.6607 | 15.6786 | 15.6607 | 15.6786 | 12432.0 |
| 2013-05-21 07:05:00 | AAPL | Stock | 15.7089 | 15.7107 | 15.7068 | 15.7107 | 23772.0 |
| 2013-05-21 07:10:00 | AAPL | Stock | 15.7007 | 15.7007 | 15.6964 | 15.6964 | 14000.0 |
| 2013-05-21 07:25:00 | AAPL | Stock | 15.7107 | 15.7107 | 15.6964 | 15.6964 | 25564.0 |
| 2013-05-21 07:30:00 | AAPL | Stock | 15.6925 | 15.6925 | 15.6893 | 15.6893 | 19600.0 |
| 2013-05-21 07:35:00 | AAPL | Stock | 15.6875 | 15.6875 | 15.6875 | 15.6875 | 2800.0 |
| 2013-05-21 07:45:00 | AAPL | Stock | 15.6786 | 15.6789 | 15.6786 | 15.6789 | 5600.0 |
| 2013-05-21 07:50:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6771 | 15.6771 | 5600.0 |
| 2013-05-21 07:55:00 | AAPL | Stock | 15.6682 | 15.6793 | 15.6671 | 15.6793 | 30016.0 |
| 2013-05-21 08:00:00 | AAPL | Stock | 15.6857 | 15.7089 | 15.6514 | 15.6786 | 189756.0 |
| 2013-05-21 08:05:00 | AAPL | Stock | 15.6793 | 15.7186 | 15.6793 | 15.7143 | 183260.0 |
| 2013-05-21 08:10:00 | AAPL | Stock | 15.7121 | 15.75 | 15.7018 | 15.7107 | 153244.0 |
| 2013-05-21 08:15:00 | AAPL | Stock | 15.7107 | 15.7107 | 15.7007 | 15.7107 | 51072.0 |
| 2013-05-21 08:20:00 | AAPL | Stock | 15.7104 | 15.7143 | 15.7036 | 15.7139 | 125552.0 |
| 2013-05-21 08:25:00 | AAPL | Stock | 15.7143 | 15.7321 | 15.7143 | 15.7304 | 122332.0 |
| 2013-05-21 08:30:00 | AAPL | Stock | 15.7286 | 15.8121 | 15.7286 | 15.75 | 378700.0 |
| 2013-05-21 08:35:00 | AAPL | Stock | 15.7425 | 15.7479 | 15.7275 | 15.7393 | 76440.0 |
| 2013-05-21 08:40:00 | AAPL | Stock | 15.7279 | 15.7286 | 15.7182 | 15.7286 | 60312.0 |
| 2013-05-21 08:45:00 | AAPL | Stock | 15.7339 | 15.7339 | 15.7286 | 15.7318 | 35196.0 |
| 2013-05-21 08:50:00 | AAPL | Stock | 15.7211 | 15.7289 | 15.7025 | 15.7039 | 151788.0 |
| 2013-05-21 08:55:00 | AAPL | Stock | 15.7036 | 15.7121 | 15.6996 | 15.7075 | 162680.0 |
| 2013-05-21 09:00:00 | AAPL | Stock | 15.7139 | 15.7232 | 15.7071 | 15.7229 | 33684.0 |
| 2013-05-21 09:05:00 | AAPL | Stock | 15.7189 | 15.7189 | 15.7125 | 15.7125 | 55020.0 |
| 2013-05-21 09:10:00 | AAPL | Stock | 15.7089 | 15.7089 | 15.7 | 15.7018 | 85512.0 |
| 2013-05-21 09:15:00 | AAPL | Stock | 15.71 | 15.71 | 15.7032 | 15.7036 | 38976.0 |
| 2013-05-21 09:20:00 | AAPL | Stock | 15.7036 | 15.7036 | 15.6932 | 15.6964 | 166712.0 |
| 2013-05-21 09:25:00 | AAPL | Stock | 15.7036 | 15.7036 | 15.6125 | 15.6407 | 861028.0 |
| 2013-05-21 09:30:00 | AAPL | Stock | 15.6482 | 15.6968 | 15.6 | 15.6818 | 21797216.0 |
| 2013-05-21 09:35:00 | AAPL | Stock | 15.6796 | 15.7407 | 15.5402 | 15.5729 | 20279840.0 |
| 2013-05-21 09:40:00 | AAPL | Stock | 15.5679 | 15.5794 | 15.5071 | 15.5714 | 15780856.0 |
| 2013-05-21 09:45:00 | AAPL | Stock | 15.5736 | 15.625 | 15.54 | 15.6032 | 11010412.0 |
| 2013-05-21 09:50:00 | AAPL | Stock | 15.6035 | 15.6214 | 15.5589 | 15.5949 | 7168616.0 |
| 2013-05-21 09:55:00 | AAPL | Stock | 15.6 | 15.6311 | 15.5711 | 15.6275 | 7442316.0 |
| 2013-05-21 10:00:00 | AAPL | Stock | 15.63 | 15.6536 | 15.5929 | 15.6114 | 6118924.0 |
| 2013-05-21 10:05:00 | AAPL | Stock | 15.6111 | 15.6232 | 15.5932 | 15.5932 | 3370556.0 |
| 2013-05-21 10:10:00 | AAPL | Stock | 15.6011 | 15.6225 | 15.545 | 15.5655 | 8442140.0 |
| 2013-05-21 10:15:00 | AAPL | Stock | 15.5632 | 15.5707 | 15.5357 | 15.5611 | 6935516.0 |
| 2013-05-21 10:20:00 | AAPL | Stock | 15.5591 | 15.5661 | 15.5089 | 15.5104 | 7315784.0 |
| 2013-05-21 10:25:00 | AAPL | Stock | 15.5102 | 15.5571 | 15.5098 | 15.5367 | 5822376.0 |
| 2013-05-21 10:30:00 | AAPL | Stock | 15.5371 | 15.5568 | 15.5286 | 15.5498 | 4787524.0 |
| 2013-05-21 10:35:00 | AAPL | Stock | 15.5468 | 15.5621 | 15.525 | 15.5491 | 7696836.0 |
| 2013-05-21 10:40:00 | AAPL | Stock | 15.5468 | 15.6018 | 15.545 | 15.5871 | 5730424.0 |
> showing 50 of 336,125 rows — these rows as CSV