PREVIEW / stock_5min / 2011-02-10
file: by_date/stock_5min/2011/2011-02-10.parquet size: 4.8 MB rows: 330,778 symbols: 3,541
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-02-10 04:10:00 | AAPL | Stock | 12.7089 | 12.7089 | 12.7089 | 12.7089 | 2800.0 |
| 2011-02-10 04:15:00 | AAPL | Stock | 12.7011 | 12.7011 | 12.6786 | 12.6786 | 8400.0 |
| 2011-02-10 04:35:00 | AAPL | Stock | 12.68 | 12.68 | 12.6764 | 12.6786 | 11200.0 |
| 2011-02-10 04:40:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 36400.0 |
| 2011-02-10 04:45:00 | AAPL | Stock | 12.6879 | 12.6879 | 12.6879 | 12.6879 | 5600.0 |
| 2011-02-10 04:50:00 | AAPL | Stock | 12.6929 | 12.6929 | 12.6929 | 12.6929 | 14000.0 |
| 2011-02-10 05:00:00 | AAPL | Stock | 12.7046 | 12.7143 | 12.7046 | 12.7143 | 25200.0 |
| 2011-02-10 05:05:00 | AAPL | Stock | 12.7243 | 12.725 | 12.7136 | 12.7136 | 16800.0 |
| 2011-02-10 05:10:00 | AAPL | Stock | 12.7189 | 12.7189 | 12.7164 | 12.7164 | 11200.0 |
| 2011-02-10 05:15:00 | AAPL | Stock | 12.7157 | 12.7204 | 12.7157 | 12.7204 | 5600.0 |
| 2011-02-10 05:30:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7164 | 12.7164 | 5600.0 |
| 2011-02-10 05:40:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 7000.0 |
| 2011-02-10 06:15:00 | AAPL | Stock | 12.6893 | 12.6893 | 12.6893 | 12.6893 | 2800.0 |
| 2011-02-10 06:25:00 | AAPL | Stock | 12.6964 | 12.6982 | 12.6964 | 12.6982 | 8400.0 |
| 2011-02-10 06:30:00 | AAPL | Stock | 12.6968 | 12.6968 | 12.6968 | 12.6968 | 5600.0 |
| 2011-02-10 06:35:00 | AAPL | Stock | 12.7196 | 12.7196 | 12.7196 | 12.7196 | 22400.0 |
| 2011-02-10 06:40:00 | AAPL | Stock | 12.7411 | 12.7411 | 12.7411 | 12.7411 | 14000.0 |
| 2011-02-10 07:00:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 25200.0 |
| 2011-02-10 07:05:00 | AAPL | Stock | 12.7036 | 12.7054 | 12.7036 | 12.7054 | 8400.0 |
| 2011-02-10 07:10:00 | AAPL | Stock | 12.7079 | 12.7175 | 12.7075 | 12.7175 | 25480.0 |
| 2011-02-10 07:15:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7107 | 12.7139 | 117180.0 |
| 2011-02-10 07:20:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7071 | 12.7071 | 30800.0 |
| 2011-02-10 07:25:00 | AAPL | Stock | 12.7071 | 12.7139 | 12.7071 | 12.7139 | 72800.0 |
| 2011-02-10 07:30:00 | AAPL | Stock | 12.7139 | 12.7807 | 12.7139 | 12.7171 | 81284.0 |
| 2011-02-10 07:35:00 | AAPL | Stock | 12.7304 | 12.7304 | 12.7196 | 12.7282 | 33320.0 |
| 2011-02-10 07:45:00 | AAPL | Stock | 12.7304 | 12.7479 | 12.7304 | 12.7414 | 64260.0 |
| 2011-02-10 07:50:00 | AAPL | Stock | 12.7464 | 12.7464 | 12.7343 | 12.7343 | 77000.0 |
| 2011-02-10 07:55:00 | AAPL | Stock | 12.7357 | 12.7357 | 12.7357 | 12.7357 | 2800.0 |
| 2011-02-10 08:00:00 | AAPL | Stock | 12.7382 | 12.7468 | 12.7321 | 12.7396 | 322364.0 |
| 2011-02-10 08:05:00 | AAPL | Stock | 12.7407 | 12.7479 | 12.72 | 12.7207 | 312368.0 |
| 2011-02-10 08:10:00 | AAPL | Stock | 12.7232 | 12.725 | 12.6936 | 12.6936 | 408464.0 |
| 2011-02-10 08:15:00 | AAPL | Stock | 12.6957 | 12.725 | 12.6936 | 12.725 | 285404.0 |
| 2011-02-10 08:20:00 | AAPL | Stock | 12.725 | 12.7371 | 12.7196 | 12.7318 | 364336.0 |
| 2011-02-10 08:25:00 | AAPL | Stock | 12.7307 | 12.7357 | 12.725 | 12.7357 | 43120.0 |
| 2011-02-10 08:30:00 | AAPL | Stock | 12.7361 | 12.7429 | 12.7246 | 12.7246 | 508648.0 |
| 2011-02-10 08:35:00 | AAPL | Stock | 12.7171 | 12.7232 | 12.7007 | 12.7196 | 287056.0 |
| 2011-02-10 08:40:00 | AAPL | Stock | 12.7211 | 12.7254 | 12.7089 | 12.7154 | 269948.0 |
| 2011-02-10 08:45:00 | AAPL | Stock | 12.7193 | 12.7232 | 12.7193 | 12.7232 | 16800.0 |
| 2011-02-10 08:50:00 | AAPL | Stock | 12.7232 | 12.7268 | 12.7232 | 12.7257 | 21084.0 |
| 2011-02-10 08:55:00 | AAPL | Stock | 12.7232 | 12.7314 | 12.7143 | 12.7296 | 110852.0 |
| 2011-02-10 09:00:00 | AAPL | Stock | 12.7286 | 12.7286 | 12.7221 | 12.7221 | 93800.0 |
| 2011-02-10 09:05:00 | AAPL | Stock | 12.7293 | 12.7393 | 12.7286 | 12.7357 | 245700.0 |
| 2011-02-10 09:10:00 | AAPL | Stock | 12.7364 | 12.7368 | 12.7314 | 12.7354 | 115612.0 |
| 2011-02-10 09:15:00 | AAPL | Stock | 12.7357 | 12.7357 | 12.7321 | 12.7343 | 47600.0 |
| 2011-02-10 09:20:00 | AAPL | Stock | 12.7325 | 12.7357 | 12.7318 | 12.7336 | 117040.0 |
| 2011-02-10 09:25:00 | AAPL | Stock | 12.7339 | 12.7643 | 12.7339 | 12.7632 | 1000860.0 |
| 2011-02-10 09:30:00 | AAPL | Stock | 12.7643 | 12.78 | 12.7189 | 12.7354 | 16100756.0 |
| 2011-02-10 09:35:00 | AAPL | Stock | 12.7379 | 12.7714 | 12.7268 | 12.7696 | 11235896.0 |
| 2011-02-10 09:40:00 | AAPL | Stock | 12.7704 | 12.7739 | 12.7346 | 12.7521 | 11452896.0 |
| 2011-02-10 09:45:00 | AAPL | Stock | 12.7518 | 12.7789 | 12.7429 | 12.7557 | 10984848.0 |
> showing 50 of 330,778 rows — these rows as CSV