PREVIEW / stock_5min / 2012-01-06
file: by_date/stock_5min/2012/2012-01-06.parquet size: 4.7 MB rows: 317,660 symbols: 3,529
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-06 04:20:00 | AAPL | Stock | 14.9304 | 14.9304 | 14.9304 | 14.9304 | 8400.0 |
| 2012-01-06 07:00:00 | AAPL | Stock | 14.9532 | 14.9532 | 14.9532 | 14.9532 | 5320.0 |
| 2012-01-06 07:05:00 | AAPL | Stock | 14.9425 | 14.9425 | 14.9425 | 14.9425 | 14000.0 |
| 2012-01-06 07:10:00 | AAPL | Stock | 14.9604 | 14.9607 | 14.9604 | 14.9607 | 14000.0 |
| 2012-01-06 07:15:00 | AAPL | Stock | 14.9493 | 14.9536 | 14.9464 | 14.9536 | 16800.0 |
| 2012-01-06 07:20:00 | AAPL | Stock | 14.9521 | 14.9521 | 14.9507 | 14.9507 | 8400.0 |
| 2012-01-06 07:30:00 | AAPL | Stock | 14.9529 | 14.9557 | 14.9529 | 14.9557 | 16996.0 |
| 2012-01-06 07:35:00 | AAPL | Stock | 14.9561 | 14.9561 | 14.9561 | 14.9561 | 12600.0 |
| 2012-01-06 07:45:00 | AAPL | Stock | 14.9593 | 14.9593 | 14.9593 | 14.9593 | 5600.0 |
| 2012-01-06 07:50:00 | AAPL | Stock | 14.9589 | 14.9596 | 14.9557 | 14.9596 | 15456.0 |
| 2012-01-06 07:55:00 | AAPL | Stock | 14.9511 | 14.9561 | 14.9432 | 14.9561 | 11984.0 |
| 2012-01-06 08:00:00 | AAPL | Stock | 14.9568 | 14.9596 | 14.9536 | 14.9554 | 159572.0 |
| 2012-01-06 08:05:00 | AAPL | Stock | 14.9521 | 14.9554 | 14.9507 | 14.9507 | 95200.0 |
| 2012-01-06 08:10:00 | AAPL | Stock | 14.9518 | 14.9546 | 14.9464 | 14.9464 | 90916.0 |
| 2012-01-06 08:15:00 | AAPL | Stock | 14.9529 | 14.9532 | 14.9461 | 14.9518 | 57400.0 |
| 2012-01-06 08:20:00 | AAPL | Stock | 14.9521 | 14.9521 | 14.9436 | 14.9436 | 88200.0 |
| 2012-01-06 08:25:00 | AAPL | Stock | 14.9432 | 14.9536 | 14.9379 | 14.9436 | 137452.0 |
| 2012-01-06 08:30:00 | AAPL | Stock | 14.9554 | 14.9911 | 14.9432 | 14.9761 | 1180312.0 |
| 2012-01-06 08:35:00 | AAPL | Stock | 14.9739 | 14.9807 | 14.9625 | 14.9646 | 516852.0 |
| 2012-01-06 08:40:00 | AAPL | Stock | 14.9643 | 14.9679 | 14.9554 | 14.9589 | 421064.0 |
| 2012-01-06 08:45:00 | AAPL | Stock | 14.9589 | 14.9714 | 14.9575 | 14.9704 | 208012.0 |
| 2012-01-06 08:50:00 | AAPL | Stock | 14.9704 | 14.9786 | 14.9704 | 14.9779 | 161140.0 |
| 2012-01-06 08:55:00 | AAPL | Stock | 14.9757 | 14.9786 | 14.9589 | 14.9718 | 454692.0 |
| 2012-01-06 09:00:00 | AAPL | Stock | 14.9661 | 14.9786 | 14.9589 | 14.97 | 611408.0 |
| 2012-01-06 09:05:00 | AAPL | Stock | 14.9732 | 14.9786 | 14.97 | 14.975 | 414260.0 |
| 2012-01-06 09:10:00 | AAPL | Stock | 14.9732 | 14.9836 | 14.9732 | 14.9836 | 251272.0 |
| 2012-01-06 09:15:00 | AAPL | Stock | 14.9846 | 14.9864 | 14.975 | 14.9782 | 273560.0 |
| 2012-01-06 09:20:00 | AAPL | Stock | 14.98 | 14.9925 | 14.9789 | 14.9911 | 404852.0 |
| 2012-01-06 09:25:00 | AAPL | Stock | 14.9907 | 14.9975 | 14.9857 | 14.9918 | 1182664.0 |
| 2012-01-06 09:30:00 | AAPL | Stock | 14.9918 | 14.9993 | 14.9821 | 14.9955 | 16369024.0 |
| 2012-01-06 09:35:00 | AAPL | Stock | 14.9929 | 15.05 | 14.9929 | 15.0446 | 22438724.0 |
| 2012-01-06 09:40:00 | AAPL | Stock | 15.0446 | 15.0525 | 15.01 | 15.0282 | 13451844.0 |
| 2012-01-06 09:45:00 | AAPL | Stock | 15.0289 | 15.0311 | 15.0018 | 15.008 | 9638496.0 |
| 2012-01-06 09:50:00 | AAPL | Stock | 15.0068 | 15.0107 | 14.9721 | 14.9775 | 9874172.0 |
| 2012-01-06 09:55:00 | AAPL | Stock | 14.9789 | 15.0086 | 14.9775 | 15.0021 | 7212240.0 |
| 2012-01-06 10:00:00 | AAPL | Stock | 15.0029 | 15.0236 | 14.9964 | 15.0196 | 6309408.0 |
| 2012-01-06 10:05:00 | AAPL | Stock | 15.0197 | 15.0225 | 14.99 | 15.0018 | 5291636.0 |
| 2012-01-06 10:10:00 | AAPL | Stock | 15.0014 | 15.0179 | 14.9879 | 14.9993 | 4566492.0 |
| 2012-01-06 10:15:00 | AAPL | Stock | 14.999 | 15.0129 | 14.9975 | 15.0004 | 2694664.0 |
| 2012-01-06 10:20:00 | AAPL | Stock | 15.0007 | 15.0154 | 15.0 | 15.0107 | 3528364.0 |
| 2012-01-06 10:25:00 | AAPL | Stock | 15.01 | 15.0118 | 15.0036 | 15.0057 | 2948456.0 |
| 2012-01-06 10:30:00 | AAPL | Stock | 15.0057 | 15.0286 | 15.0054 | 15.0286 | 4099732.0 |
| 2012-01-06 10:35:00 | AAPL | Stock | 15.0286 | 15.0321 | 15.0232 | 15.0321 | 3680236.0 |
| 2012-01-06 10:40:00 | AAPL | Stock | 15.0318 | 15.0357 | 15.0268 | 15.03 | 3976028.0 |
| 2012-01-06 10:45:00 | AAPL | Stock | 15.03 | 15.0439 | 15.0268 | 15.0436 | 3658144.0 |
| 2012-01-06 10:50:00 | AAPL | Stock | 15.0429 | 15.0457 | 15.0286 | 15.0286 | 3492608.0 |
| 2012-01-06 10:55:00 | AAPL | Stock | 15.0307 | 15.0307 | 15.0111 | 15.0157 | 3533628.0 |
| 2012-01-06 11:00:00 | AAPL | Stock | 15.0159 | 15.0304 | 15.0146 | 15.0293 | 2766932.0 |
| 2012-01-06 11:05:00 | AAPL | Stock | 15.0286 | 15.0407 | 15.0218 | 15.0258 | 3560200.0 |
| 2012-01-06 11:10:00 | AAPL | Stock | 15.0264 | 15.0289 | 15.0171 | 15.0226 | 2120300.0 |
> showing 50 of 317,660 rows — these rows as CSV