PREVIEW / stock_5min / 2013-06-06
file: by_date/stock_5min/2013/2013-06-06.parquet size: 5.1 MB rows: 339,528 symbols: 3,483
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-06-06 05:05:00 | AAPL | Stock | 15.9418 | 15.9418 | 15.9418 | 15.9418 | 2800.0 |
| 2013-06-06 05:35:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9393 | 15.9393 | 4200.0 |
| 2013-06-06 06:00:00 | AAPL | Stock | 15.9571 | 15.9571 | 15.9571 | 15.9571 | 2800.0 |
| 2013-06-06 06:15:00 | AAPL | Stock | 15.9568 | 15.9571 | 15.9568 | 15.9571 | 28000.0 |
| 2013-06-06 06:20:00 | AAPL | Stock | 15.9643 | 15.9757 | 15.9643 | 15.9757 | 5600.0 |
| 2013-06-06 07:00:00 | AAPL | Stock | 15.9836 | 15.9911 | 15.9643 | 15.9643 | 102060.0 |
| 2013-06-06 07:15:00 | AAPL | Stock | 15.96 | 15.96 | 15.96 | 15.96 | 2800.0 |
| 2013-06-06 07:20:00 | AAPL | Stock | 15.9568 | 15.9568 | 15.9568 | 15.9568 | 2800.0 |
| 2013-06-06 07:25:00 | AAPL | Stock | 15.9432 | 15.9432 | 15.9432 | 15.9432 | 2800.0 |
| 2013-06-06 07:30:00 | AAPL | Stock | 15.9568 | 15.9568 | 15.9568 | 15.9568 | 11200.0 |
| 2013-06-06 07:35:00 | AAPL | Stock | 15.9507 | 15.9536 | 15.9464 | 15.9464 | 28420.0 |
| 2013-06-06 07:40:00 | AAPL | Stock | 15.9496 | 15.9643 | 15.9496 | 15.9643 | 70644.0 |
| 2013-06-06 07:45:00 | AAPL | Stock | 15.9639 | 15.9889 | 15.9621 | 15.9821 | 67452.0 |
| 2013-06-06 07:50:00 | AAPL | Stock | 15.9682 | 15.9739 | 15.9664 | 15.9739 | 19600.0 |
| 2013-06-06 08:00:00 | AAPL | Stock | 15.9696 | 15.9696 | 15.8929 | 15.95 | 300272.0 |
| 2013-06-06 08:05:00 | AAPL | Stock | 15.9464 | 15.9643 | 15.9464 | 15.9643 | 264572.0 |
| 2013-06-06 08:10:00 | AAPL | Stock | 15.9661 | 15.9661 | 15.9396 | 15.9471 | 209020.0 |
| 2013-06-06 08:15:00 | AAPL | Stock | 15.9471 | 15.9568 | 15.9471 | 15.9554 | 57120.0 |
| 2013-06-06 08:20:00 | AAPL | Stock | 15.9486 | 15.9625 | 15.9471 | 15.9607 | 145068.0 |
| 2013-06-06 08:25:00 | AAPL | Stock | 15.9575 | 15.9643 | 15.9575 | 15.9643 | 82348.0 |
| 2013-06-06 08:30:00 | AAPL | Stock | 15.9579 | 15.9579 | 15.9379 | 15.9557 | 138908.0 |
| 2013-06-06 08:35:00 | AAPL | Stock | 15.9536 | 15.9582 | 15.9468 | 15.9468 | 44800.0 |
| 2013-06-06 08:40:00 | AAPL | Stock | 15.9486 | 15.9493 | 15.9146 | 15.9346 | 108276.0 |
| 2013-06-06 08:45:00 | AAPL | Stock | 15.9257 | 15.9375 | 15.925 | 15.93 | 138824.0 |
| 2013-06-06 08:50:00 | AAPL | Stock | 15.93 | 15.93 | 15.9114 | 15.9286 | 89600.0 |
| 2013-06-06 08:55:00 | AAPL | Stock | 15.9218 | 15.9375 | 15.9218 | 15.9375 | 62720.0 |
| 2013-06-06 09:00:00 | AAPL | Stock | 15.9389 | 15.9393 | 15.9243 | 15.9296 | 91000.0 |
| 2013-06-06 09:05:00 | AAPL | Stock | 15.9268 | 15.9268 | 15.9129 | 15.9243 | 84000.0 |
| 2013-06-06 09:10:00 | AAPL | Stock | 15.9196 | 15.925 | 15.9182 | 15.9214 | 58800.0 |
| 2013-06-06 09:15:00 | AAPL | Stock | 15.925 | 15.9357 | 15.9221 | 15.9254 | 76804.0 |
| 2013-06-06 09:20:00 | AAPL | Stock | 15.925 | 15.9318 | 15.9243 | 15.9257 | 68880.0 |
| 2013-06-06 09:25:00 | AAPL | Stock | 15.9286 | 15.9343 | 15.895 | 15.895 | 345576.0 |
| 2013-06-06 09:30:00 | AAPL | Stock | 15.8946 | 15.9618 | 15.8764 | 15.9436 | 12397280.0 |
| 2013-06-06 09:35:00 | AAPL | Stock | 15.9436 | 15.9643 | 15.9107 | 15.9107 | 7146468.0 |
| 2013-06-06 09:40:00 | AAPL | Stock | 15.9111 | 15.9179 | 15.8318 | 15.8514 | 11349800.0 |
| 2013-06-06 09:45:00 | AAPL | Stock | 15.8521 | 15.8611 | 15.8089 | 15.8187 | 8158500.0 |
| 2013-06-06 09:50:00 | AAPL | Stock | 15.8182 | 15.8243 | 15.7429 | 15.7636 | 14460768.0 |
| 2013-06-06 09:55:00 | AAPL | Stock | 15.7636 | 15.81 | 15.7476 | 15.8028 | 8303736.0 |
| 2013-06-06 10:00:00 | AAPL | Stock | 15.8036 | 15.8125 | 15.7643 | 15.7679 | 5037032.0 |
| 2013-06-06 10:05:00 | AAPL | Stock | 15.7693 | 15.79 | 15.7196 | 15.7332 | 7662452.0 |
| 2013-06-06 10:10:00 | AAPL | Stock | 15.7336 | 15.7546 | 15.6664 | 15.6741 | 13213004.0 |
| 2013-06-06 10:15:00 | AAPL | Stock | 15.6779 | 15.7011 | 15.6646 | 15.6839 | 8008980.0 |
| 2013-06-06 10:20:00 | AAPL | Stock | 15.6839 | 15.7018 | 15.6546 | 15.6796 | 7121688.0 |
| 2013-06-06 10:25:00 | AAPL | Stock | 15.6796 | 15.6946 | 15.6729 | 15.6818 | 6129564.0 |
| 2013-06-06 10:30:00 | AAPL | Stock | 15.6818 | 15.7318 | 15.6696 | 15.6914 | 6494712.0 |
| 2013-06-06 10:35:00 | AAPL | Stock | 15.6914 | 15.6946 | 15.6436 | 15.6486 | 6368404.0 |
| 2013-06-06 10:40:00 | AAPL | Stock | 15.6486 | 15.6496 | 15.6122 | 15.6361 | 7492184.0 |
| 2013-06-06 10:45:00 | AAPL | Stock | 15.6354 | 15.6486 | 15.6282 | 15.6364 | 4552632.0 |
| 2013-06-06 10:50:00 | AAPL | Stock | 15.6373 | 15.6591 | 15.6364 | 15.6407 | 2910180.0 |
| 2013-06-06 10:55:00 | AAPL | Stock | 15.6429 | 15.6886 | 15.6339 | 15.6864 | 4287836.0 |
> showing 50 of 339,528 rows — these rows as CSV