PREVIEW / stock_5min / 2012-03-29
file: by_date/stock_5min/2012/2012-03-29.parquet size: 4.8 MB rows: 323,968 symbols: 3,536
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-03-29 04:00:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 26600.0 |
| 2012-03-29 04:05:00 | AAPL | Stock | 22.0979 | 22.0979 | 22.0979 | 22.0979 | 11200.0 |
| 2012-03-29 04:10:00 | AAPL | Stock | 22.0857 | 22.0857 | 22.0857 | 22.0857 | 4200.0 |
| 2012-03-29 04:40:00 | AAPL | Stock | 22.0718 | 22.0718 | 22.0718 | 22.0718 | 2800.0 |
| 2012-03-29 05:05:00 | AAPL | Stock | 22.0536 | 22.0536 | 22.0464 | 22.0464 | 37212.0 |
| 2012-03-29 05:20:00 | AAPL | Stock | 22.0429 | 22.0429 | 22.0429 | 22.0429 | 14000.0 |
| 2012-03-29 05:30:00 | AAPL | Stock | 22.0446 | 22.0446 | 22.0411 | 22.0411 | 19600.0 |
| 2012-03-29 06:00:00 | AAPL | Stock | 22.0229 | 22.0229 | 22.0107 | 22.0107 | 21000.0 |
| 2012-03-29 06:05:00 | AAPL | Stock | 22.0164 | 22.0164 | 22.0164 | 22.0164 | 9800.0 |
| 2012-03-29 06:15:00 | AAPL | Stock | 22.0093 | 22.0093 | 22.0093 | 22.0093 | 5600.0 |
| 2012-03-29 06:25:00 | AAPL | Stock | 22.0004 | 22.0004 | 22.0004 | 22.0004 | 2800.0 |
| 2012-03-29 06:30:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0321 | 22.0321 | 11200.0 |
| 2012-03-29 06:35:00 | AAPL | Stock | 22.025 | 22.025 | 22.025 | 22.025 | 5600.0 |
| 2012-03-29 07:00:00 | AAPL | Stock | 22.0143 | 22.0175 | 22.0036 | 22.01 | 20160.0 |
| 2012-03-29 07:05:00 | AAPL | Stock | 22.0193 | 22.0304 | 22.0161 | 22.0161 | 39200.0 |
| 2012-03-29 07:10:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 20720.0 |
| 2012-03-29 07:15:00 | AAPL | Stock | 22.0086 | 22.0086 | 22.0086 | 22.0086 | 2800.0 |
| 2012-03-29 07:20:00 | AAPL | Stock | 22.0075 | 22.0075 | 22.0075 | 22.0075 | 14000.0 |
| 2012-03-29 07:25:00 | AAPL | Stock | 22.0139 | 22.0139 | 22.0139 | 22.0139 | 2800.0 |
| 2012-03-29 07:30:00 | AAPL | Stock | 22.0161 | 22.0325 | 22.0161 | 22.0268 | 62020.0 |
| 2012-03-29 07:35:00 | AAPL | Stock | 22.0268 | 22.0357 | 22.0268 | 22.0357 | 177800.0 |
| 2012-03-29 07:40:00 | AAPL | Stock | 22.0404 | 22.0429 | 22.0357 | 22.04 | 39200.0 |
| 2012-03-29 07:45:00 | AAPL | Stock | 22.0357 | 22.0386 | 22.0321 | 22.0357 | 25200.0 |
| 2012-03-29 07:50:00 | AAPL | Stock | 22.0271 | 22.0357 | 22.0271 | 22.0357 | 33600.0 |
| 2012-03-29 07:55:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0346 | 22.0346 | 23884.0 |
| 2012-03-29 08:00:00 | AAPL | Stock | 22.0311 | 22.0536 | 22.0075 | 22.0075 | 500640.0 |
| 2012-03-29 08:05:00 | AAPL | Stock | 22.0136 | 22.0232 | 21.9911 | 21.9911 | 408380.0 |
| 2012-03-29 08:10:00 | AAPL | Stock | 21.9925 | 21.9943 | 21.9679 | 21.9679 | 399924.0 |
| 2012-03-29 08:15:00 | AAPL | Stock | 21.9732 | 21.9782 | 21.9507 | 21.9639 | 367444.0 |
| 2012-03-29 08:20:00 | AAPL | Stock | 21.9639 | 21.9711 | 21.9561 | 21.9618 | 228004.0 |
| 2012-03-29 08:25:00 | AAPL | Stock | 21.9632 | 21.9925 | 21.9589 | 21.9854 | 296548.0 |
| 2012-03-29 08:30:00 | AAPL | Stock | 21.9839 | 21.9918 | 21.95 | 21.9571 | 429072.0 |
| 2012-03-29 08:35:00 | AAPL | Stock | 21.9571 | 21.9821 | 21.9571 | 21.9729 | 266140.0 |
| 2012-03-29 08:40:00 | AAPL | Stock | 21.9725 | 21.9729 | 21.9404 | 21.9411 | 483364.0 |
| 2012-03-29 08:45:00 | AAPL | Stock | 21.945 | 21.9607 | 21.9418 | 21.9579 | 263396.0 |
| 2012-03-29 08:50:00 | AAPL | Stock | 21.9586 | 21.9643 | 21.9536 | 21.9643 | 159180.0 |
| 2012-03-29 08:55:00 | AAPL | Stock | 21.9639 | 21.9821 | 21.9607 | 21.9714 | 262584.0 |
| 2012-03-29 09:00:00 | AAPL | Stock | 21.9714 | 21.9732 | 21.9554 | 21.9604 | 164416.0 |
| 2012-03-29 09:05:00 | AAPL | Stock | 21.9636 | 21.97 | 21.9471 | 21.9471 | 174272.0 |
| 2012-03-29 09:10:00 | AAPL | Stock | 21.9479 | 21.955 | 21.9361 | 21.9429 | 395640.0 |
| 2012-03-29 09:15:00 | AAPL | Stock | 21.9411 | 21.9454 | 21.9132 | 21.9154 | 634760.0 |
| 2012-03-29 09:20:00 | AAPL | Stock | 21.9214 | 21.9232 | 21.8775 | 21.8789 | 724192.0 |
| 2012-03-29 09:25:00 | AAPL | Stock | 21.8911 | 21.8921 | 21.8571 | 21.885 | 1210048.0 |
| 2012-03-29 09:30:00 | AAPL | Stock | 21.8893 | 21.9424 | 21.8304 | 21.9252 | 28576100.0 |
| 2012-03-29 09:35:00 | AAPL | Stock | 21.9225 | 21.9643 | 21.88 | 21.9532 | 15384012.0 |
| 2012-03-29 09:40:00 | AAPL | Stock | 21.9525 | 22.0136 | 21.9207 | 21.9822 | 15837304.0 |
| 2012-03-29 09:45:00 | AAPL | Stock | 21.9821 | 22.02 | 21.9518 | 22.0146 | 13871536.0 |
| 2012-03-29 09:50:00 | AAPL | Stock | 22.0179 | 22.0182 | 21.9382 | 21.9614 | 11281060.0 |
| 2012-03-29 09:55:00 | AAPL | Stock | 21.9636 | 21.9636 | 21.9161 | 21.9561 | 10133676.0 |
| 2012-03-29 10:00:00 | AAPL | Stock | 21.9561 | 21.985 | 21.9414 | 21.9832 | 7679588.0 |
> showing 50 of 323,968 rows — these rows as CSV