PREVIEW / stock_5min / 2014-03-19
file: by_date/stock_5min/2014/2014-03-19.parquet size: 5.5 MB rows: 360,541 symbols: 3,540
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-19 05:10:00 | AAPL | Stock | 19.0264 | 19.0304 | 19.0264 | 19.0304 | 5600.0 |
| 2014-03-19 05:15:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0182 | 19.0182 | 11200.0 |
| 2014-03-19 05:30:00 | AAPL | Stock | 19.0236 | 19.0236 | 19.0179 | 19.0179 | 11200.0 |
| 2014-03-19 05:50:00 | AAPL | Stock | 19.0229 | 19.0229 | 19.0229 | 19.0229 | 2800.0 |
| 2014-03-19 06:05:00 | AAPL | Stock | 19.0243 | 19.0243 | 19.0239 | 19.0239 | 5600.0 |
| 2014-03-19 06:50:00 | AAPL | Stock | 19.0196 | 19.0196 | 19.0196 | 19.0196 | 5600.0 |
| 2014-03-19 07:05:00 | AAPL | Stock | 19.0211 | 19.0214 | 19.0211 | 19.0214 | 5600.0 |
| 2014-03-19 07:10:00 | AAPL | Stock | 19.0307 | 19.0396 | 19.0307 | 19.0396 | 14000.0 |
| 2014-03-19 07:15:00 | AAPL | Stock | 19.0475 | 19.05 | 19.0475 | 19.05 | 8400.0 |
| 2014-03-19 07:20:00 | AAPL | Stock | 19.05 | 19.05 | 19.04 | 19.04 | 5796.0 |
| 2014-03-19 07:25:00 | AAPL | Stock | 19.0282 | 19.0357 | 19.0282 | 19.0357 | 16800.0 |
| 2014-03-19 07:35:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0286 | 19.0286 | 5600.0 |
| 2014-03-19 07:50:00 | AAPL | Stock | 19.035 | 19.035 | 19.035 | 19.035 | 2800.0 |
| 2014-03-19 08:00:00 | AAPL | Stock | 19.0475 | 19.0475 | 19.0129 | 19.0225 | 110040.0 |
| 2014-03-19 08:05:00 | AAPL | Stock | 19.0339 | 19.0354 | 19.0321 | 19.0354 | 18368.0 |
| 2014-03-19 08:10:00 | AAPL | Stock | 19.0339 | 19.0339 | 19.0229 | 19.0264 | 19600.0 |
| 2014-03-19 08:15:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2014-03-19 08:20:00 | AAPL | Stock | 19.0286 | 19.0286 | 19.0239 | 19.0239 | 11200.0 |
| 2014-03-19 08:25:00 | AAPL | Stock | 19.0336 | 19.0339 | 19.0336 | 19.0339 | 5600.0 |
| 2014-03-19 08:30:00 | AAPL | Stock | 19.0239 | 19.0325 | 19.0239 | 19.0325 | 8400.0 |
| 2014-03-19 08:35:00 | AAPL | Stock | 19.03 | 19.03 | 19.0271 | 19.0271 | 8400.0 |
| 2014-03-19 08:40:00 | AAPL | Stock | 19.0343 | 19.0418 | 19.0336 | 19.0336 | 68880.0 |
| 2014-03-19 08:45:00 | AAPL | Stock | 19.0368 | 19.0407 | 19.0304 | 19.0407 | 84000.0 |
| 2014-03-19 08:50:00 | AAPL | Stock | 19.0386 | 19.0496 | 19.0386 | 19.0496 | 61852.0 |
| 2014-03-19 08:55:00 | AAPL | Stock | 19.0504 | 19.0518 | 19.0471 | 19.0511 | 117740.0 |
| 2014-03-19 09:00:00 | AAPL | Stock | 19.0482 | 19.06 | 19.0482 | 19.0579 | 102060.0 |
| 2014-03-19 09:05:00 | AAPL | Stock | 19.0557 | 19.0557 | 19.0557 | 19.0557 | 5600.0 |
| 2014-03-19 09:10:00 | AAPL | Stock | 19.0557 | 19.0557 | 19.05 | 19.05 | 131012.0 |
| 2014-03-19 09:15:00 | AAPL | Stock | 19.05 | 19.05 | 19.0468 | 19.05 | 53200.0 |
| 2014-03-19 09:20:00 | AAPL | Stock | 19.0475 | 19.0511 | 19.0186 | 19.0186 | 186536.0 |
| 2014-03-19 09:25:00 | AAPL | Stock | 19.02 | 19.0421 | 19.0014 | 19.0093 | 494676.0 |
| 2014-03-19 09:30:00 | AAPL | Stock | 19.0104 | 19.0446 | 18.9868 | 19.0286 | 9965984.0 |
| 2014-03-19 09:35:00 | AAPL | Stock | 19.0276 | 19.0282 | 18.97 | 19.0039 | 3893512.0 |
| 2014-03-19 09:40:00 | AAPL | Stock | 19.0039 | 19.0493 | 19.0039 | 19.0464 | 4189808.0 |
| 2014-03-19 09:45:00 | AAPL | Stock | 19.0496 | 19.0768 | 19.0304 | 19.0636 | 5748792.0 |
| 2014-03-19 09:50:00 | AAPL | Stock | 19.0644 | 19.1071 | 19.0536 | 19.1018 | 5281528.0 |
| 2014-03-19 09:55:00 | AAPL | Stock | 19.0982 | 19.1268 | 19.0982 | 19.1139 | 5612068.0 |
| 2014-03-19 10:00:00 | AAPL | Stock | 19.1136 | 19.1246 | 19.0957 | 19.1186 | 3742452.0 |
| 2014-03-19 10:05:00 | AAPL | Stock | 19.1229 | 19.1479 | 19.1189 | 19.1444 | 5777660.0 |
| 2014-03-19 10:10:00 | AAPL | Stock | 19.1475 | 19.1514 | 19.1029 | 19.1275 | 3923444.0 |
| 2014-03-19 10:15:00 | AAPL | Stock | 19.1271 | 19.1411 | 19.1129 | 19.1139 | 1850184.0 |
| 2014-03-19 10:20:00 | AAPL | Stock | 19.1168 | 19.1215 | 19.0949 | 19.0996 | 2838444.0 |
| 2014-03-19 10:25:00 | AAPL | Stock | 19.1025 | 19.1225 | 19.1025 | 19.1111 | 2386104.0 |
| 2014-03-19 10:30:00 | AAPL | Stock | 19.1096 | 19.1118 | 19.0968 | 19.1036 | 2025632.0 |
| 2014-03-19 10:35:00 | AAPL | Stock | 19.1036 | 19.1104 | 19.0836 | 19.095 | 2006620.0 |
| 2014-03-19 10:40:00 | AAPL | Stock | 19.0923 | 19.0975 | 19.055 | 19.0656 | 3200932.0 |
| 2014-03-19 10:45:00 | AAPL | Stock | 19.0629 | 19.09 | 19.0614 | 19.0846 | 2059148.0 |
| 2014-03-19 10:50:00 | AAPL | Stock | 19.0893 | 19.1104 | 19.0846 | 19.0908 | 1530508.0 |
| 2014-03-19 10:55:00 | AAPL | Stock | 19.0914 | 19.1089 | 19.0846 | 19.0892 | 1341844.0 |
| 2014-03-19 11:00:00 | AAPL | Stock | 19.0911 | 19.1071 | 19.0761 | 19.0782 | 1712788.0 |
> showing 50 of 360,541 rows — these rows as CSV