PREVIEW / stock_5min / 2012-11-06
file: by_date/stock_5min/2012/2012-11-06.parquet size: 4.7 MB rows: 318,585 symbols: 3,469
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-11-06 05:25:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 2800.0 |
| 2012-11-06 05:55:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 5600.0 |
| 2012-11-06 06:00:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9782 | 20.9782 | 11060.0 |
| 2012-11-06 06:05:00 | AAPL | Stock | 20.9786 | 20.9786 | 20.9786 | 20.9786 | 5600.0 |
| 2012-11-06 06:25:00 | AAPL | Stock | 20.9893 | 21.0107 | 20.9893 | 21.0107 | 6440.0 |
| 2012-11-06 06:30:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 98084.0 |
| 2012-11-06 06:40:00 | AAPL | Stock | 21.0221 | 21.0221 | 21.0221 | 21.0221 | 2800.0 |
| 2012-11-06 06:45:00 | AAPL | Stock | 21.0221 | 21.0221 | 21.0221 | 21.0221 | 2800.0 |
| 2012-11-06 06:50:00 | AAPL | Stock | 21.0179 | 21.0261 | 21.0179 | 21.0261 | 18200.0 |
| 2012-11-06 07:00:00 | AAPL | Stock | 21.0179 | 21.0357 | 21.0179 | 21.0357 | 65072.0 |
| 2012-11-06 07:05:00 | AAPL | Stock | 21.0493 | 21.0496 | 21.0357 | 21.0489 | 83832.0 |
| 2012-11-06 07:10:00 | AAPL | Stock | 21.0446 | 21.0471 | 21.0371 | 21.0461 | 37100.0 |
| 2012-11-06 07:15:00 | AAPL | Stock | 21.0396 | 21.0396 | 21.0289 | 21.0396 | 107800.0 |
| 2012-11-06 07:20:00 | AAPL | Stock | 21.0304 | 21.0304 | 21.0211 | 21.0304 | 97272.0 |
| 2012-11-06 07:25:00 | AAPL | Stock | 21.0296 | 21.0461 | 21.0296 | 21.0461 | 40208.0 |
| 2012-11-06 07:30:00 | AAPL | Stock | 21.0446 | 21.0596 | 21.0364 | 21.0596 | 39760.0 |
| 2012-11-06 07:35:00 | AAPL | Stock | 21.0604 | 21.0632 | 21.0179 | 21.0179 | 217392.0 |
| 2012-11-06 07:40:00 | AAPL | Stock | 21.0229 | 21.0357 | 21.0179 | 21.0357 | 101976.0 |
| 2012-11-06 07:45:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0352 | 21.0357 | 52472.0 |
| 2012-11-06 07:50:00 | AAPL | Stock | 21.0518 | 21.0625 | 21.0411 | 21.05 | 54320.0 |
| 2012-11-06 07:55:00 | AAPL | Stock | 21.0393 | 21.0586 | 21.0393 | 21.0586 | 27440.0 |
| 2012-11-06 08:00:00 | AAPL | Stock | 21.0586 | 21.0625 | 21.025 | 21.0429 | 529368.0 |
| 2012-11-06 08:05:00 | AAPL | Stock | 21.0486 | 21.0568 | 21.0393 | 21.0504 | 259168.0 |
| 2012-11-06 08:10:00 | AAPL | Stock | 21.05 | 21.0589 | 21.0268 | 21.0282 | 267400.0 |
| 2012-11-06 08:15:00 | AAPL | Stock | 21.0254 | 21.0429 | 21.0254 | 21.0429 | 54684.0 |
| 2012-11-06 08:20:00 | AAPL | Stock | 21.0446 | 21.0571 | 21.04 | 21.045 | 321720.0 |
| 2012-11-06 08:25:00 | AAPL | Stock | 21.0461 | 21.0532 | 21.0357 | 21.0432 | 77000.0 |
| 2012-11-06 08:30:00 | AAPL | Stock | 21.0357 | 21.0407 | 21.0357 | 21.0386 | 48020.0 |
| 2012-11-06 08:35:00 | AAPL | Stock | 21.0425 | 21.0618 | 21.0425 | 21.0554 | 179228.0 |
| 2012-11-06 08:40:00 | AAPL | Stock | 21.0496 | 21.0589 | 21.0496 | 21.0571 | 53480.0 |
| 2012-11-06 08:45:00 | AAPL | Stock | 21.0568 | 21.0571 | 21.0504 | 21.0504 | 87472.0 |
| 2012-11-06 08:50:00 | AAPL | Stock | 21.0504 | 21.0518 | 21.0464 | 21.0464 | 69468.0 |
| 2012-11-06 08:55:00 | AAPL | Stock | 21.05 | 21.05 | 21.0425 | 21.0425 | 78400.0 |
| 2012-11-06 09:00:00 | AAPL | Stock | 21.0454 | 21.0536 | 21.0429 | 21.05 | 137424.0 |
| 2012-11-06 09:05:00 | AAPL | Stock | 21.0471 | 21.0471 | 21.0421 | 21.0429 | 36680.0 |
| 2012-11-06 09:10:00 | AAPL | Stock | 21.0429 | 21.0464 | 21.0321 | 21.0446 | 91504.0 |
| 2012-11-06 09:15:00 | AAPL | Stock | 21.0371 | 21.0446 | 21.0364 | 21.0393 | 46732.0 |
| 2012-11-06 09:20:00 | AAPL | Stock | 21.0382 | 21.0564 | 21.0382 | 21.0536 | 238336.0 |
| 2012-11-06 09:25:00 | AAPL | Stock | 21.0486 | 21.0807 | 21.0421 | 21.0807 | 842128.0 |
| 2012-11-06 09:30:00 | AAPL | Stock | 21.0804 | 21.0979 | 20.9732 | 21.0067 | 15828120.0 |
| 2012-11-06 09:35:00 | AAPL | Stock | 21.0121 | 21.05 | 20.9779 | 21.0289 | 8654968.0 |
| 2012-11-06 09:40:00 | AAPL | Stock | 21.0289 | 21.0311 | 20.9593 | 20.9929 | 9494268.0 |
| 2012-11-06 09:45:00 | AAPL | Stock | 20.9929 | 21.0143 | 20.9718 | 20.9932 | 5606916.0 |
| 2012-11-06 09:50:00 | AAPL | Stock | 20.99 | 21.0068 | 20.9571 | 20.9871 | 4659452.0 |
| 2012-11-06 09:55:00 | AAPL | Stock | 20.9825 | 21.0125 | 20.9596 | 20.9671 | 5991412.0 |
| 2012-11-06 10:00:00 | AAPL | Stock | 20.9664 | 20.9939 | 20.9432 | 20.98 | 4313400.0 |
| 2012-11-06 10:05:00 | AAPL | Stock | 20.9818 | 20.9854 | 20.9146 | 20.9304 | 6610128.0 |
| 2012-11-06 10:10:00 | AAPL | Stock | 20.9336 | 20.96 | 20.9071 | 20.915 | 3842860.0 |
| 2012-11-06 10:15:00 | AAPL | Stock | 20.9157 | 20.9407 | 20.9018 | 20.9189 | 5344640.0 |
| 2012-11-06 10:20:00 | AAPL | Stock | 20.9189 | 20.9614 | 20.9189 | 20.9504 | 3380804.0 |
> showing 50 of 318,585 rows — these rows as CSV