PREVIEW / stock_5min / 2013-01-28
file: by_date/stock_5min/2013/2013-01-28.parquet size: 5.0 MB rows: 334,054 symbols: 3,481
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-01-28 04:00:00 | AAPL | Stock | 15.7611 | 15.7611 | 15.7518 | 15.7518 | 29960.0 |
| 2013-01-28 04:05:00 | AAPL | Stock | 15.7429 | 15.7429 | 15.7429 | 15.7429 | 8260.0 |
| 2013-01-28 04:10:00 | AAPL | Stock | 15.7429 | 15.7429 | 15.7429 | 15.7429 | 8400.0 |
| 2013-01-28 04:20:00 | AAPL | Stock | 15.725 | 15.725 | 15.7161 | 15.7161 | 19600.0 |
| 2013-01-28 04:25:00 | AAPL | Stock | 15.7161 | 15.7161 | 15.7143 | 15.7143 | 14868.0 |
| 2013-01-28 04:30:00 | AAPL | Stock | 15.7143 | 15.7161 | 15.7143 | 15.7161 | 8400.0 |
| 2013-01-28 04:35:00 | AAPL | Stock | 15.7161 | 15.7161 | 15.6964 | 15.6964 | 21028.0 |
| 2013-01-28 04:40:00 | AAPL | Stock | 15.7129 | 15.7143 | 15.7129 | 15.7143 | 8400.0 |
| 2013-01-28 04:50:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.6971 | 15.6971 | 16800.0 |
| 2013-01-28 04:55:00 | AAPL | Stock | 15.6964 | 15.7 | 15.6875 | 15.6875 | 16800.0 |
| 2013-01-28 05:00:00 | AAPL | Stock | 15.7086 | 15.7143 | 15.6879 | 15.6879 | 29904.0 |
| 2013-01-28 05:05:00 | AAPL | Stock | 15.6886 | 15.6968 | 15.6875 | 15.6964 | 19600.0 |
| 2013-01-28 05:10:00 | AAPL | Stock | 15.6804 | 15.6804 | 15.6804 | 15.6804 | 2800.0 |
| 2013-01-28 05:15:00 | AAPL | Stock | 15.6793 | 15.6971 | 15.6793 | 15.6957 | 14000.0 |
| 2013-01-28 05:20:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 2800.0 |
| 2013-01-28 05:25:00 | AAPL | Stock | 15.6921 | 15.6921 | 15.67 | 15.67 | 5600.0 |
| 2013-01-28 05:30:00 | AAPL | Stock | 15.6775 | 15.6936 | 15.6775 | 15.6936 | 14000.0 |
| 2013-01-28 05:35:00 | AAPL | Stock | 15.6804 | 15.6804 | 15.6789 | 15.6789 | 5600.0 |
| 2013-01-28 05:45:00 | AAPL | Stock | 15.6918 | 15.6918 | 15.6796 | 15.6796 | 7840.0 |
| 2013-01-28 05:50:00 | AAPL | Stock | 15.71 | 15.71 | 15.71 | 15.71 | 2800.0 |
| 2013-01-28 06:00:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6857 | 15.6857 | 18480.0 |
| 2013-01-28 06:10:00 | AAPL | Stock | 15.7071 | 15.7071 | 15.7071 | 15.7071 | 8540.0 |
| 2013-01-28 06:20:00 | AAPL | Stock | 15.7243 | 15.7257 | 15.7243 | 15.7257 | 5600.0 |
| 2013-01-28 06:25:00 | AAPL | Stock | 15.7321 | 15.75 | 15.7321 | 15.75 | 8400.0 |
| 2013-01-28 06:30:00 | AAPL | Stock | 15.7557 | 15.7607 | 15.7393 | 15.7393 | 31080.0 |
| 2013-01-28 06:35:00 | AAPL | Stock | 15.7393 | 15.75 | 15.7321 | 15.7429 | 22120.0 |
| 2013-01-28 06:40:00 | AAPL | Stock | 15.7393 | 15.7414 | 15.7357 | 15.7357 | 52976.0 |
| 2013-01-28 06:45:00 | AAPL | Stock | 15.7429 | 15.7504 | 15.7357 | 15.75 | 67480.0 |
| 2013-01-28 06:50:00 | AAPL | Stock | 15.7496 | 15.7571 | 15.7496 | 15.7571 | 41720.0 |
| 2013-01-28 06:55:00 | AAPL | Stock | 15.75 | 15.75 | 15.7496 | 15.75 | 16800.0 |
| 2013-01-28 07:00:00 | AAPL | Stock | 15.7536 | 15.7679 | 15.75 | 15.7607 | 141652.0 |
| 2013-01-28 07:05:00 | AAPL | Stock | 15.7586 | 15.7589 | 15.7357 | 15.7393 | 100940.0 |
| 2013-01-28 07:10:00 | AAPL | Stock | 15.7325 | 15.7357 | 15.7071 | 15.7271 | 100156.0 |
| 2013-01-28 07:15:00 | AAPL | Stock | 15.7357 | 15.7679 | 15.7357 | 15.75 | 212296.0 |
| 2013-01-28 07:20:00 | AAPL | Stock | 15.75 | 15.7679 | 15.7446 | 15.7539 | 85904.0 |
| 2013-01-28 07:25:00 | AAPL | Stock | 15.7532 | 15.7671 | 15.7532 | 15.7604 | 29820.0 |
| 2013-01-28 07:30:00 | AAPL | Stock | 15.75 | 15.7657 | 15.75 | 15.7539 | 62972.0 |
| 2013-01-28 07:35:00 | AAPL | Stock | 15.7539 | 15.7571 | 15.7196 | 15.7414 | 93016.0 |
| 2013-01-28 07:40:00 | AAPL | Stock | 15.7482 | 15.7493 | 15.7471 | 15.7489 | 42000.0 |
| 2013-01-28 07:45:00 | AAPL | Stock | 15.7479 | 15.775 | 15.7479 | 15.7682 | 135968.0 |
| 2013-01-28 07:50:00 | AAPL | Stock | 15.7743 | 15.8132 | 15.7679 | 15.8036 | 463260.0 |
| 2013-01-28 07:55:00 | AAPL | Stock | 15.7964 | 15.8357 | 15.7964 | 15.8214 | 515200.0 |
| 2013-01-28 08:00:00 | AAPL | Stock | 15.8214 | 15.8339 | 15.7321 | 15.7675 | 1446564.0 |
| 2013-01-28 08:05:00 | AAPL | Stock | 15.7757 | 15.7771 | 15.7393 | 15.7479 | 421792.0 |
| 2013-01-28 08:10:00 | AAPL | Stock | 15.7389 | 15.7789 | 15.7375 | 15.7375 | 611324.0 |
| 2013-01-28 08:15:00 | AAPL | Stock | 15.7482 | 15.7607 | 15.7386 | 15.7496 | 195692.0 |
| 2013-01-28 08:20:00 | AAPL | Stock | 15.75 | 15.75 | 15.7196 | 15.7307 | 242676.0 |
| 2013-01-28 08:25:00 | AAPL | Stock | 15.7354 | 15.7621 | 15.7271 | 15.7396 | 506940.0 |
| 2013-01-28 08:30:00 | AAPL | Stock | 15.7321 | 15.735 | 15.6757 | 15.6757 | 581560.0 |
| 2013-01-28 08:35:00 | AAPL | Stock | 15.6786 | 15.6793 | 15.6096 | 15.6236 | 924868.0 |
> showing 50 of 334,054 rows — these rows as CSV