PREVIEW / stock_5min / 2013-11-01
file: by_date/stock_5min/2013/2013-11-01.parquet size: 5.4 MB rows: 360,912 symbols: 3,531
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-11-01 04:20:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 2800.0 |
| 2013-11-01 05:40:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6786 | 18.6786 | 3920.0 |
| 2013-11-01 05:55:00 | AAPL | Stock | 18.6854 | 18.6875 | 18.6854 | 18.6875 | 5824.0 |
| 2013-11-01 06:40:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6696 | 18.675 | 47404.0 |
| 2013-11-01 06:45:00 | AAPL | Stock | 18.675 | 18.675 | 18.5714 | 18.5714 | 82600.0 |
| 2013-11-01 06:50:00 | AAPL | Stock | 18.6321 | 18.6429 | 18.6321 | 18.6339 | 97300.0 |
| 2013-11-01 06:55:00 | AAPL | Stock | 18.5825 | 18.5893 | 18.5718 | 18.5893 | 36400.0 |
| 2013-11-01 07:00:00 | AAPL | Stock | 18.6071 | 18.625 | 18.6071 | 18.625 | 34860.0 |
| 2013-11-01 07:05:00 | AAPL | Stock | 18.6425 | 18.6764 | 18.6425 | 18.6764 | 19600.0 |
| 2013-11-01 07:10:00 | AAPL | Stock | 18.6764 | 18.7143 | 18.6764 | 18.7143 | 68740.0 |
| 2013-11-01 07:15:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7054 | 18.7054 | 15680.0 |
| 2013-11-01 07:20:00 | AAPL | Stock | 18.7143 | 18.7286 | 18.7143 | 18.7264 | 22680.0 |
| 2013-11-01 07:25:00 | AAPL | Stock | 18.7264 | 18.7357 | 18.7186 | 18.7357 | 44240.0 |
| 2013-11-01 07:30:00 | AAPL | Stock | 18.7446 | 18.7461 | 18.7321 | 18.7461 | 33376.0 |
| 2013-11-01 07:35:00 | AAPL | Stock | 18.7396 | 18.7396 | 18.7264 | 18.7264 | 16800.0 |
| 2013-11-01 07:45:00 | AAPL | Stock | 18.7475 | 18.7486 | 18.7475 | 18.7486 | 22400.0 |
| 2013-11-01 07:50:00 | AAPL | Stock | 18.7393 | 18.7425 | 18.7386 | 18.7386 | 19600.0 |
| 2013-11-01 07:55:00 | AAPL | Stock | 18.7396 | 18.7454 | 18.7396 | 18.7454 | 16800.0 |
| 2013-11-01 08:00:00 | AAPL | Stock | 18.7411 | 18.7493 | 18.6696 | 18.7321 | 258580.0 |
| 2013-11-01 08:05:00 | AAPL | Stock | 18.7221 | 18.7357 | 18.7221 | 18.7321 | 176400.0 |
| 2013-11-01 08:10:00 | AAPL | Stock | 18.7379 | 18.7379 | 18.6554 | 18.7182 | 94640.0 |
| 2013-11-01 08:15:00 | AAPL | Stock | 18.7314 | 18.7368 | 18.7214 | 18.7321 | 75040.0 |
| 2013-11-01 08:20:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 64736.0 |
| 2013-11-01 08:25:00 | AAPL | Stock | 18.7275 | 18.7321 | 18.7275 | 18.7286 | 16800.0 |
| 2013-11-01 08:30:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7232 | 18.7318 | 43904.0 |
| 2013-11-01 08:35:00 | AAPL | Stock | 18.7232 | 18.7239 | 18.7232 | 18.7239 | 9800.0 |
| 2013-11-01 08:40:00 | AAPL | Stock | 18.7314 | 18.7321 | 18.7314 | 18.7321 | 16800.0 |
| 2013-11-01 08:45:00 | AAPL | Stock | 18.725 | 18.7321 | 18.725 | 18.7311 | 16800.0 |
| 2013-11-01 08:50:00 | AAPL | Stock | 18.7314 | 18.7314 | 18.7232 | 18.7232 | 135408.0 |
| 2013-11-01 08:55:00 | AAPL | Stock | 18.7161 | 18.7236 | 18.7146 | 18.7232 | 52388.0 |
| 2013-11-01 09:00:00 | AAPL | Stock | 18.7239 | 18.7321 | 18.6679 | 18.7321 | 176932.0 |
| 2013-11-01 09:05:00 | AAPL | Stock | 18.7232 | 18.7357 | 18.7168 | 18.7321 | 76328.0 |
| 2013-11-01 09:10:00 | AAPL | Stock | 18.7321 | 18.7411 | 18.7321 | 18.7357 | 267904.0 |
| 2013-11-01 09:15:00 | AAPL | Stock | 18.7393 | 18.7393 | 18.7143 | 18.7346 | 97076.0 |
| 2013-11-01 09:20:00 | AAPL | Stock | 18.7282 | 18.7393 | 18.7275 | 18.7321 | 94640.0 |
| 2013-11-01 09:25:00 | AAPL | Stock | 18.7304 | 18.7321 | 18.7161 | 18.7161 | 80948.0 |
| 2013-11-01 09:30:00 | AAPL | Stock | 18.715 | 18.7286 | 18.6436 | 18.6571 | 11908764.0 |
| 2013-11-01 09:35:00 | AAPL | Stock | 18.6546 | 18.7293 | 18.6546 | 18.7071 | 5829964.0 |
| 2013-11-01 09:40:00 | AAPL | Stock | 18.7075 | 18.7356 | 18.6807 | 18.7239 | 6142836.0 |
| 2013-11-01 09:45:00 | AAPL | Stock | 18.7232 | 18.7429 | 18.7114 | 18.7319 | 3442516.0 |
| 2013-11-01 09:50:00 | AAPL | Stock | 18.7311 | 18.7386 | 18.7043 | 18.7296 | 3998764.0 |
| 2013-11-01 09:55:00 | AAPL | Stock | 18.7318 | 18.7429 | 18.6904 | 18.7007 | 3883460.0 |
| 2013-11-01 10:00:00 | AAPL | Stock | 18.7029 | 18.725 | 18.6654 | 18.6671 | 3579212.0 |
| 2013-11-01 10:05:00 | AAPL | Stock | 18.6671 | 18.7125 | 18.6671 | 18.6764 | 4015620.0 |
| 2013-11-01 10:10:00 | AAPL | Stock | 18.6786 | 18.6943 | 18.6607 | 18.662 | 3676008.0 |
| 2013-11-01 10:15:00 | AAPL | Stock | 18.662 | 18.6675 | 18.6268 | 18.6307 | 6153000.0 |
| 2013-11-01 10:20:00 | AAPL | Stock | 18.6318 | 18.665 | 18.6232 | 18.6499 | 4030264.0 |
| 2013-11-01 10:25:00 | AAPL | Stock | 18.6486 | 18.6661 | 18.6461 | 18.6461 | 1983184.0 |
| 2013-11-01 10:30:00 | AAPL | Stock | 18.6454 | 18.6636 | 18.6375 | 18.6543 | 2786196.0 |
| 2013-11-01 10:35:00 | AAPL | Stock | 18.6529 | 18.6661 | 18.6379 | 18.6561 | 2145892.0 |
> showing 50 of 360,912 rows — these rows as CSV