PREVIEW / stock_5min / 2009-07-22
file: by_date/stock_5min/2009/2009-07-22.parquet size: 4.5 MB rows: 310,520 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-22 04:00:00 | AAPL | Stock | 5.6075 | 5.6075 | 5.6075 | 5.6075 | 16800.0 |
| 2009-07-22 04:10:00 | AAPL | Stock | 5.6161 | 5.6161 | 5.6161 | 5.6161 | 14000.0 |
| 2009-07-22 04:15:00 | AAPL | Stock | 5.6161 | 5.6161 | 5.6125 | 5.6161 | 33600.0 |
| 2009-07-22 04:20:00 | AAPL | Stock | 5.6125 | 5.6125 | 5.6125 | 5.6125 | 2800.0 |
| 2009-07-22 04:25:00 | AAPL | Stock | 5.6125 | 5.6182 | 5.6125 | 5.6182 | 19600.0 |
| 2009-07-22 04:30:00 | AAPL | Stock | 5.6075 | 5.6107 | 5.6075 | 5.6107 | 11200.0 |
| 2009-07-22 04:40:00 | AAPL | Stock | 5.5989 | 5.6039 | 5.5925 | 5.5925 | 32900.0 |
| 2009-07-22 04:45:00 | AAPL | Stock | 5.5925 | 5.5925 | 5.5925 | 5.5925 | 16800.0 |
| 2009-07-22 04:50:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 2800.0 |
| 2009-07-22 04:55:00 | AAPL | Stock | 5.5929 | 5.6054 | 5.5925 | 5.6054 | 11200.0 |
| 2009-07-22 05:25:00 | AAPL | Stock | 5.6054 | 5.6064 | 5.6054 | 5.6064 | 22400.0 |
| 2009-07-22 05:35:00 | AAPL | Stock | 5.6139 | 5.615 | 5.6139 | 5.615 | 14000.0 |
| 2009-07-22 05:40:00 | AAPL | Stock | 5.6189 | 5.6189 | 5.6189 | 5.6189 | 2800.0 |
| 2009-07-22 05:50:00 | AAPL | Stock | 5.6196 | 5.6196 | 5.6196 | 5.6196 | 14000.0 |
| 2009-07-22 05:55:00 | AAPL | Stock | 5.6161 | 5.6161 | 5.6161 | 5.6161 | 10584.0 |
| 2009-07-22 06:15:00 | AAPL | Stock | 5.6239 | 5.6239 | 5.6125 | 5.6125 | 85400.0 |
| 2009-07-22 06:20:00 | AAPL | Stock | 5.6075 | 5.6075 | 5.6064 | 5.6068 | 37184.0 |
| 2009-07-22 06:25:00 | AAPL | Stock | 5.6068 | 5.6071 | 5.6068 | 5.6068 | 56420.0 |
| 2009-07-22 06:30:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6 | 5.6 | 30380.0 |
| 2009-07-22 06:35:00 | AAPL | Stock | 5.6007 | 5.6007 | 5.6007 | 5.6007 | 56000.0 |
| 2009-07-22 06:40:00 | AAPL | Stock | 5.6064 | 5.6125 | 5.6064 | 5.6107 | 93016.0 |
| 2009-07-22 06:45:00 | AAPL | Stock | 5.6136 | 5.6136 | 5.6136 | 5.6136 | 28000.0 |
| 2009-07-22 06:50:00 | AAPL | Stock | 5.6139 | 5.6143 | 5.6093 | 5.6093 | 84000.0 |
| 2009-07-22 06:55:00 | AAPL | Stock | 5.6107 | 5.6107 | 5.6107 | 5.6107 | 2800.0 |
| 2009-07-22 07:00:00 | AAPL | Stock | 5.6143 | 5.6179 | 5.6107 | 5.6161 | 49700.0 |
| 2009-07-22 07:05:00 | AAPL | Stock | 5.6175 | 5.625 | 5.6121 | 5.625 | 47600.0 |
| 2009-07-22 07:10:00 | AAPL | Stock | 5.6279 | 5.6407 | 5.6279 | 5.6389 | 522508.0 |
| 2009-07-22 07:15:00 | AAPL | Stock | 5.6368 | 5.6396 | 5.6175 | 5.6175 | 192500.0 |
| 2009-07-22 07:20:00 | AAPL | Stock | 5.6304 | 5.6364 | 5.6304 | 5.6364 | 89180.0 |
| 2009-07-22 07:25:00 | AAPL | Stock | 5.6364 | 5.6429 | 5.6354 | 5.6429 | 124600.0 |
| 2009-07-22 07:30:00 | AAPL | Stock | 5.6482 | 5.6496 | 5.6429 | 5.6461 | 278180.0 |
| 2009-07-22 07:35:00 | AAPL | Stock | 5.6461 | 5.6496 | 5.6429 | 5.6464 | 73080.0 |
| 2009-07-22 07:40:00 | AAPL | Stock | 5.6496 | 5.6536 | 5.6471 | 5.6486 | 323596.0 |
| 2009-07-22 07:45:00 | AAPL | Stock | 5.6486 | 5.6568 | 5.6486 | 5.6536 | 415884.0 |
| 2009-07-22 07:50:00 | AAPL | Stock | 5.6536 | 5.6707 | 5.6529 | 5.6704 | 899052.0 |
| 2009-07-22 07:55:00 | AAPL | Stock | 5.6696 | 5.6729 | 5.6661 | 5.6721 | 508816.0 |
| 2009-07-22 08:00:00 | AAPL | Stock | 5.67 | 5.67 | 5.625 | 5.6275 | 1661436.0 |
| 2009-07-22 08:05:00 | AAPL | Stock | 5.6314 | 5.6314 | 5.6125 | 5.6229 | 1763020.0 |
| 2009-07-22 08:10:00 | AAPL | Stock | 5.6221 | 5.6321 | 5.6179 | 5.6321 | 972944.0 |
| 2009-07-22 08:15:00 | AAPL | Stock | 5.6339 | 5.6346 | 5.6171 | 5.6189 | 699748.0 |
| 2009-07-22 08:20:00 | AAPL | Stock | 5.6193 | 5.6321 | 5.6161 | 5.625 | 579880.0 |
| 2009-07-22 08:25:00 | AAPL | Stock | 5.6264 | 5.6304 | 5.6257 | 5.6286 | 528388.0 |
| 2009-07-22 08:30:00 | AAPL | Stock | 5.6279 | 5.6286 | 5.6182 | 5.6229 | 517720.0 |
| 2009-07-22 08:35:00 | AAPL | Stock | 5.6239 | 5.6268 | 5.6189 | 5.6243 | 1049748.0 |
| 2009-07-22 08:40:00 | AAPL | Stock | 5.6243 | 5.6243 | 5.6161 | 5.6168 | 650272.0 |
| 2009-07-22 08:45:00 | AAPL | Stock | 5.6168 | 5.6179 | 5.6057 | 5.6068 | 1261652.0 |
| 2009-07-22 08:50:00 | AAPL | Stock | 5.6061 | 5.6121 | 5.5979 | 5.6089 | 3292408.0 |
| 2009-07-22 08:55:00 | AAPL | Stock | 5.6089 | 5.6143 | 5.6079 | 5.6118 | 949396.0 |
| 2009-07-22 09:00:00 | AAPL | Stock | 5.6121 | 5.6243 | 5.6075 | 5.6175 | 1140132.0 |
| 2009-07-22 09:05:00 | AAPL | Stock | 5.6168 | 5.6186 | 5.6111 | 5.6186 | 1370376.0 |
> showing 50 of 310,520 rows — these rows as CSV