PREVIEW / stock_5min / 2013-07-05
file: by_date/stock_5min/2013/2013-07-05.parquet size: 4.9 MB rows: 327,234 symbols: 3,494
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-07-05 04:05:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2013-07-05 04:55:00 | AAPL | Stock | 15.1632 | 15.1632 | 15.1632 | 15.1632 | 2800.0 |
| 2013-07-05 05:20:00 | AAPL | Stock | 15.1571 | 15.1571 | 15.1571 | 15.1571 | 2800.0 |
| 2013-07-05 06:00:00 | AAPL | Stock | 15.1393 | 15.1429 | 15.1393 | 15.1429 | 23100.0 |
| 2013-07-05 06:05:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1357 | 15.1357 | 11592.0 |
| 2013-07-05 06:15:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1554 | 15.1554 | 5600.0 |
| 2013-07-05 06:20:00 | AAPL | Stock | 15.1554 | 15.1571 | 15.1554 | 15.1571 | 5600.0 |
| 2013-07-05 06:25:00 | AAPL | Stock | 15.1761 | 15.1761 | 15.1761 | 15.1761 | 5712.0 |
| 2013-07-05 06:30:00 | AAPL | Stock | 15.1507 | 15.1507 | 15.1429 | 15.1429 | 11200.0 |
| 2013-07-05 06:40:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1221 | 15.1221 | 8400.0 |
| 2013-07-05 06:45:00 | AAPL | Stock | 15.1118 | 15.1118 | 15.1118 | 15.1118 | 2800.0 |
| 2013-07-05 07:00:00 | AAPL | Stock | 15.1143 | 15.1293 | 15.1143 | 15.1293 | 8400.0 |
| 2013-07-05 07:05:00 | AAPL | Stock | 15.125 | 15.1339 | 15.125 | 15.125 | 14000.0 |
| 2013-07-05 07:10:00 | AAPL | Stock | 15.1304 | 15.1429 | 15.1296 | 15.1425 | 25200.0 |
| 2013-07-05 07:15:00 | AAPL | Stock | 15.1375 | 15.1711 | 15.1296 | 15.1482 | 77840.0 |
| 2013-07-05 07:20:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 2800.0 |
| 2013-07-05 07:25:00 | AAPL | Stock | 15.1586 | 15.1586 | 15.1586 | 15.1586 | 2800.0 |
| 2013-07-05 07:30:00 | AAPL | Stock | 15.1464 | 15.1586 | 15.1464 | 15.1586 | 9912.0 |
| 2013-07-05 07:40:00 | AAPL | Stock | 15.1507 | 15.1518 | 15.1496 | 15.1496 | 28000.0 |
| 2013-07-05 07:50:00 | AAPL | Stock | 15.1496 | 15.1496 | 15.1246 | 15.1246 | 66500.0 |
| 2013-07-05 07:55:00 | AAPL | Stock | 15.125 | 15.125 | 15.0929 | 15.1057 | 87836.0 |
| 2013-07-05 08:00:00 | AAPL | Stock | 15.1161 | 15.1589 | 14.9093 | 15.1339 | 184856.0 |
| 2013-07-05 08:05:00 | AAPL | Stock | 15.1268 | 15.1357 | 15.11 | 15.1232 | 158368.0 |
| 2013-07-05 08:10:00 | AAPL | Stock | 15.1139 | 15.1139 | 15.1071 | 15.1071 | 134120.0 |
| 2013-07-05 08:15:00 | AAPL | Stock | 15.1071 | 15.1161 | 15.1071 | 15.1161 | 48020.0 |
| 2013-07-05 08:20:00 | AAPL | Stock | 15.1161 | 15.1161 | 15.1 | 15.1071 | 273980.0 |
| 2013-07-05 08:25:00 | AAPL | Stock | 15.1071 | 15.1114 | 15.0789 | 15.0979 | 305004.0 |
| 2013-07-05 08:30:00 | AAPL | Stock | 15.0893 | 15.1357 | 15.0814 | 15.1339 | 749280.0 |
| 2013-07-05 08:35:00 | AAPL | Stock | 15.1339 | 15.1489 | 15.1079 | 15.1214 | 691488.0 |
| 2013-07-05 08:40:00 | AAPL | Stock | 15.1189 | 15.1429 | 15.1146 | 15.1429 | 848708.0 |
| 2013-07-05 08:45:00 | AAPL | Stock | 15.1411 | 15.1411 | 15.125 | 15.1357 | 263592.0 |
| 2013-07-05 08:50:00 | AAPL | Stock | 15.1418 | 15.1514 | 15.1332 | 15.1504 | 245000.0 |
| 2013-07-05 08:55:00 | AAPL | Stock | 15.1511 | 15.1511 | 15.1371 | 15.1393 | 131404.0 |
| 2013-07-05 09:00:00 | AAPL | Stock | 15.1411 | 15.1411 | 15.0475 | 15.0704 | 480928.0 |
| 2013-07-05 09:05:00 | AAPL | Stock | 15.0689 | 15.0714 | 15.0046 | 15.0125 | 720384.0 |
| 2013-07-05 09:10:00 | AAPL | Stock | 15.0146 | 15.025 | 14.9821 | 15.0 | 809144.0 |
| 2013-07-05 09:15:00 | AAPL | Stock | 15.0007 | 15.0314 | 15.0 | 15.0189 | 202524.0 |
| 2013-07-05 09:20:00 | AAPL | Stock | 15.0143 | 15.0161 | 14.9964 | 15.0093 | 406616.0 |
| 2013-07-05 09:25:00 | AAPL | Stock | 15.0093 | 15.0314 | 14.9918 | 15.0107 | 538888.0 |
| 2013-07-05 09:30:00 | AAPL | Stock | 14.9989 | 15.1175 | 14.9829 | 15.0071 | 18383932.0 |
| 2013-07-05 09:35:00 | AAPL | Stock | 15.0071 | 15.0746 | 14.9849 | 15.0643 | 9132172.0 |
| 2013-07-05 09:40:00 | AAPL | Stock | 15.0661 | 15.0893 | 15.0429 | 15.0679 | 6229748.0 |
| 2013-07-05 09:45:00 | AAPL | Stock | 15.0693 | 15.0961 | 15.0571 | 15.0686 | 6300756.0 |
| 2013-07-05 09:50:00 | AAPL | Stock | 15.0674 | 15.0714 | 15.0364 | 15.0482 | 4106060.0 |
| 2013-07-05 09:55:00 | AAPL | Stock | 15.0471 | 15.0632 | 15.0125 | 15.0179 | 4048212.0 |
| 2013-07-05 10:00:00 | AAPL | Stock | 15.0168 | 15.0289 | 14.9732 | 14.9886 | 6576108.0 |
| 2013-07-05 10:05:00 | AAPL | Stock | 14.9889 | 14.9907 | 14.9501 | 14.9611 | 6918044.0 |
| 2013-07-05 10:10:00 | AAPL | Stock | 14.9596 | 14.9634 | 14.899 | 14.9046 | 8519588.0 |
| 2013-07-05 10:15:00 | AAPL | Stock | 14.9096 | 14.91 | 14.8543 | 14.8894 | 9282980.0 |
| 2013-07-05 10:20:00 | AAPL | Stock | 14.8896 | 14.9068 | 14.875 | 14.9036 | 5005224.0 |
> showing 50 of 327,234 rows — these rows as CSV