PREVIEW / stock_5min / 2012-04-11
file: by_date/stock_5min/2012/2012-04-11.parquet size: 4.8 MB rows: 325,592 symbols: 3,525
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-04-11 04:00:00 | AAPL | Stock | 22.5714 | 22.625 | 22.5214 | 22.5821 | 107632.0 |
| 2012-04-11 04:05:00 | AAPL | Stock | 22.5821 | 22.6 | 22.5821 | 22.6 | 14000.0 |
| 2012-04-11 04:45:00 | AAPL | Stock | 22.6004 | 22.6004 | 22.6004 | 22.6004 | 2800.0 |
| 2012-04-11 04:50:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 14000.0 |
| 2012-04-11 05:00:00 | AAPL | Stock | 22.6232 | 22.6232 | 22.6232 | 22.6232 | 2800.0 |
| 2012-04-11 05:10:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 2800.0 |
| 2012-04-11 05:15:00 | AAPL | Stock | 22.6429 | 22.6607 | 22.6429 | 22.6607 | 8400.0 |
| 2012-04-11 05:20:00 | AAPL | Stock | 22.6607 | 22.6607 | 22.6607 | 22.6607 | 5600.0 |
| 2012-04-11 05:25:00 | AAPL | Stock | 22.6339 | 22.6429 | 22.6339 | 22.6429 | 5600.0 |
| 2012-04-11 05:35:00 | AAPL | Stock | 22.6268 | 22.6268 | 22.6268 | 22.6268 | 2800.0 |
| 2012-04-11 05:40:00 | AAPL | Stock | 22.65 | 22.65 | 22.65 | 22.65 | 5600.0 |
| 2012-04-11 05:45:00 | AAPL | Stock | 22.6607 | 22.6607 | 22.6607 | 22.6607 | 3304.0 |
| 2012-04-11 05:55:00 | AAPL | Stock | 22.6607 | 22.6607 | 22.6607 | 22.6607 | 3220.0 |
| 2012-04-11 06:05:00 | AAPL | Stock | 22.7071 | 22.7314 | 22.7071 | 22.7314 | 14000.0 |
| 2012-04-11 06:10:00 | AAPL | Stock | 22.7321 | 22.7461 | 22.7321 | 22.7461 | 87500.0 |
| 2012-04-11 06:15:00 | AAPL | Stock | 22.7071 | 22.7071 | 22.7071 | 22.7071 | 2800.0 |
| 2012-04-11 06:25:00 | AAPL | Stock | 22.7143 | 22.7214 | 22.7143 | 22.7214 | 8400.0 |
| 2012-04-11 06:30:00 | AAPL | Stock | 22.7143 | 22.7143 | 22.7143 | 22.7143 | 8400.0 |
| 2012-04-11 06:35:00 | AAPL | Stock | 22.7071 | 22.7357 | 22.7071 | 22.7357 | 45388.0 |
| 2012-04-11 06:40:00 | AAPL | Stock | 22.7143 | 22.7143 | 22.7071 | 22.7071 | 22400.0 |
| 2012-04-11 06:45:00 | AAPL | Stock | 22.7143 | 22.7143 | 22.7143 | 22.7143 | 22400.0 |
| 2012-04-11 06:50:00 | AAPL | Stock | 22.7089 | 22.7089 | 22.6964 | 22.6964 | 22848.0 |
| 2012-04-11 06:55:00 | AAPL | Stock | 22.7054 | 22.7054 | 22.7054 | 22.7054 | 16100.0 |
| 2012-04-11 07:00:00 | AAPL | Stock | 22.7107 | 22.7311 | 22.7054 | 22.7214 | 148260.0 |
| 2012-04-11 07:05:00 | AAPL | Stock | 22.7321 | 22.7461 | 22.7271 | 22.7329 | 179200.0 |
| 2012-04-11 07:10:00 | AAPL | Stock | 22.7411 | 22.7461 | 22.7321 | 22.7321 | 197204.0 |
| 2012-04-11 07:15:00 | AAPL | Stock | 22.7279 | 22.7279 | 22.7107 | 22.7107 | 102480.0 |
| 2012-04-11 07:20:00 | AAPL | Stock | 22.7043 | 22.7143 | 22.7043 | 22.7132 | 83580.0 |
| 2012-04-11 07:25:00 | AAPL | Stock | 22.7071 | 22.75 | 22.7071 | 22.7225 | 212716.0 |
| 2012-04-11 07:30:00 | AAPL | Stock | 22.7214 | 22.7286 | 22.7111 | 22.7111 | 80780.0 |
| 2012-04-11 07:35:00 | AAPL | Stock | 22.7107 | 22.7275 | 22.7107 | 22.7275 | 33544.0 |
| 2012-04-11 07:40:00 | AAPL | Stock | 22.725 | 22.7332 | 22.7146 | 22.7332 | 232204.0 |
| 2012-04-11 07:45:00 | AAPL | Stock | 22.7321 | 22.7321 | 22.7207 | 22.7207 | 30968.0 |
| 2012-04-11 07:50:00 | AAPL | Stock | 22.7318 | 22.7321 | 22.7207 | 22.7207 | 83468.0 |
| 2012-04-11 07:55:00 | AAPL | Stock | 22.7218 | 22.7218 | 22.7107 | 22.7179 | 218148.0 |
| 2012-04-11 08:00:00 | AAPL | Stock | 22.72 | 22.7461 | 22.7054 | 22.7146 | 538272.0 |
| 2012-04-11 08:05:00 | AAPL | Stock | 22.7214 | 22.7357 | 22.7143 | 22.7343 | 566524.0 |
| 2012-04-11 08:10:00 | AAPL | Stock | 22.7364 | 22.7418 | 22.7161 | 22.7246 | 299880.0 |
| 2012-04-11 08:15:00 | AAPL | Stock | 22.725 | 22.725 | 22.7061 | 22.7214 | 457268.0 |
| 2012-04-11 08:20:00 | AAPL | Stock | 22.7221 | 22.7221 | 22.7036 | 22.7089 | 184324.0 |
| 2012-04-11 08:25:00 | AAPL | Stock | 22.7089 | 22.7093 | 22.6911 | 22.7093 | 323820.0 |
| 2012-04-11 08:30:00 | AAPL | Stock | 22.7029 | 22.7107 | 22.6786 | 22.705 | 492548.0 |
| 2012-04-11 08:35:00 | AAPL | Stock | 22.705 | 22.7143 | 22.6911 | 22.6929 | 524160.0 |
| 2012-04-11 08:40:00 | AAPL | Stock | 22.6964 | 22.6964 | 22.6786 | 22.6882 | 394772.0 |
| 2012-04-11 08:45:00 | AAPL | Stock | 22.6879 | 22.6921 | 22.655 | 22.6607 | 457184.0 |
| 2012-04-11 08:50:00 | AAPL | Stock | 22.6632 | 22.6893 | 22.6579 | 22.6893 | 332360.0 |
| 2012-04-11 08:55:00 | AAPL | Stock | 22.6893 | 22.705 | 22.6857 | 22.7014 | 192780.0 |
| 2012-04-11 09:00:00 | AAPL | Stock | 22.6961 | 22.7079 | 22.6939 | 22.7054 | 184996.0 |
| 2012-04-11 09:05:00 | AAPL | Stock | 22.705 | 22.7125 | 22.6714 | 22.6793 | 686392.0 |
| 2012-04-11 09:10:00 | AAPL | Stock | 22.6786 | 22.6971 | 22.6736 | 22.685 | 367696.0 |
> showing 50 of 325,592 rows — these rows as CSV