PREVIEW / stock_5min / 2012-01-04
file: by_date/stock_5min/2012/2012-01-04.parquet size: 4.7 MB rows: 318,467 symbols: 3,520
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-04 04:20:00 | AAPL | Stock | 14.6436 | 14.6436 | 14.6436 | 14.6436 | 2800.0 |
| 2012-01-04 05:45:00 | AAPL | Stock | 14.6511 | 14.6511 | 14.6464 | 14.6464 | 5600.0 |
| 2012-01-04 05:55:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 11200.0 |
| 2012-01-04 06:15:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 16800.0 |
| 2012-01-04 06:20:00 | AAPL | Stock | 14.6271 | 14.6271 | 14.6271 | 14.6271 | 2800.0 |
| 2012-01-04 06:25:00 | AAPL | Stock | 14.6271 | 14.6271 | 14.6271 | 14.6271 | 11200.0 |
| 2012-01-04 06:35:00 | AAPL | Stock | 14.6271 | 14.6271 | 14.6271 | 14.6271 | 14000.0 |
| 2012-01-04 06:45:00 | AAPL | Stock | 14.6179 | 14.6179 | 14.6179 | 14.6179 | 2800.0 |
| 2012-01-04 06:50:00 | AAPL | Stock | 14.6214 | 14.6214 | 14.6214 | 14.6214 | 5600.0 |
| 2012-01-04 07:00:00 | AAPL | Stock | 14.6254 | 14.6254 | 14.625 | 14.625 | 49000.0 |
| 2012-01-04 07:05:00 | AAPL | Stock | 14.6386 | 14.6429 | 14.6386 | 14.6429 | 21700.0 |
| 2012-01-04 07:10:00 | AAPL | Stock | 14.6425 | 14.6425 | 14.6393 | 14.6393 | 11200.0 |
| 2012-01-04 07:20:00 | AAPL | Stock | 14.65 | 14.6607 | 14.65 | 14.6607 | 55720.0 |
| 2012-01-04 07:25:00 | AAPL | Stock | 14.6607 | 14.6696 | 14.6607 | 14.6607 | 37380.0 |
| 2012-01-04 07:30:00 | AAPL | Stock | 14.6571 | 14.6607 | 14.6561 | 14.6607 | 8400.0 |
| 2012-01-04 07:35:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6607 | 14.6607 | 8820.0 |
| 2012-01-04 07:40:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6518 | 14.6607 | 16800.0 |
| 2012-01-04 07:45:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6607 | 14.6607 | 11200.0 |
| 2012-01-04 07:50:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6539 | 14.6539 | 19600.0 |
| 2012-01-04 07:55:00 | AAPL | Stock | 14.6536 | 14.6536 | 14.6536 | 14.6536 | 16800.0 |
| 2012-01-04 08:00:00 | AAPL | Stock | 14.6696 | 14.6768 | 14.6546 | 14.6696 | 90020.0 |
| 2012-01-04 08:05:00 | AAPL | Stock | 14.6646 | 14.6646 | 14.6464 | 14.6464 | 106540.0 |
| 2012-01-04 08:10:00 | AAPL | Stock | 14.6446 | 14.6446 | 14.635 | 14.6354 | 163184.0 |
| 2012-01-04 08:15:00 | AAPL | Stock | 14.6307 | 14.6307 | 14.6107 | 14.6296 | 223580.0 |
| 2012-01-04 08:20:00 | AAPL | Stock | 14.6157 | 14.6157 | 14.5911 | 14.6021 | 195412.0 |
| 2012-01-04 08:25:00 | AAPL | Stock | 14.6061 | 14.6246 | 14.5971 | 14.6246 | 168448.0 |
| 2012-01-04 08:30:00 | AAPL | Stock | 14.6093 | 14.6386 | 14.6089 | 14.63 | 204148.0 |
| 2012-01-04 08:35:00 | AAPL | Stock | 14.63 | 14.6429 | 14.63 | 14.6414 | 176064.0 |
| 2012-01-04 08:40:00 | AAPL | Stock | 14.6429 | 14.6532 | 14.6429 | 14.6496 | 196308.0 |
| 2012-01-04 08:45:00 | AAPL | Stock | 14.6446 | 14.6607 | 14.6446 | 14.6536 | 107520.0 |
| 2012-01-04 08:50:00 | AAPL | Stock | 14.6539 | 14.6607 | 14.6464 | 14.6589 | 150388.0 |
| 2012-01-04 08:55:00 | AAPL | Stock | 14.6679 | 14.6679 | 14.6429 | 14.6429 | 233800.0 |
| 2012-01-04 09:00:00 | AAPL | Stock | 14.6429 | 14.6479 | 14.6357 | 14.6464 | 151060.0 |
| 2012-01-04 09:05:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6425 | 14.6425 | 8932.0 |
| 2012-01-04 09:10:00 | AAPL | Stock | 14.6464 | 14.6493 | 14.6411 | 14.6493 | 61040.0 |
| 2012-01-04 09:15:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 22400.0 |
| 2012-01-04 09:20:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6379 | 14.6425 | 16240.0 |
| 2012-01-04 09:25:00 | AAPL | Stock | 14.6375 | 14.6496 | 14.6357 | 14.6471 | 121212.0 |
| 2012-01-04 09:30:00 | AAPL | Stock | 14.6429 | 14.6964 | 14.6361 | 14.6657 | 11716740.0 |
| 2012-01-04 09:35:00 | AAPL | Stock | 14.6646 | 14.6661 | 14.6171 | 14.6257 | 7418656.0 |
| 2012-01-04 09:40:00 | AAPL | Stock | 14.6261 | 14.6568 | 14.6214 | 14.6504 | 5082084.0 |
| 2012-01-04 09:45:00 | AAPL | Stock | 14.6504 | 14.6746 | 14.6421 | 14.6743 | 4406556.0 |
| 2012-01-04 09:50:00 | AAPL | Stock | 14.6743 | 14.6786 | 14.6621 | 14.6646 | 4388972.0 |
| 2012-01-04 09:55:00 | AAPL | Stock | 14.6648 | 14.6757 | 14.6634 | 14.6732 | 2694524.0 |
| 2012-01-04 10:00:00 | AAPL | Stock | 14.6689 | 14.6786 | 14.6586 | 14.66 | 3997224.0 |
| 2012-01-04 10:05:00 | AAPL | Stock | 14.6593 | 14.6664 | 14.6529 | 14.6571 | 1999704.0 |
| 2012-01-04 10:10:00 | AAPL | Stock | 14.6571 | 14.6579 | 14.6339 | 14.6396 | 3813096.0 |
| 2012-01-04 10:15:00 | AAPL | Stock | 14.6375 | 14.655 | 14.6311 | 14.6455 | 2930760.0 |
| 2012-01-04 10:20:00 | AAPL | Stock | 14.6446 | 14.6564 | 14.6443 | 14.6557 | 2571772.0 |
| 2012-01-04 10:25:00 | AAPL | Stock | 14.6564 | 14.66 | 14.6454 | 14.6518 | 2970548.0 |
> showing 50 of 318,467 rows — these rows as CSV