PREVIEW / stock_5min / 2014-01-13
file: by_date/stock_5min/2014/2014-01-13.parquet size: 5.7 MB rows: 371,041 symbols: 3,532
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-01-13 04:10:00 | AAPL | Stock | 19.0339 | 19.0357 | 19.03 | 19.0321 | 22596.0 |
| 2014-01-13 04:50:00 | AAPL | Stock | 19.0179 | 19.0179 | 19.0179 | 19.0179 | 2800.0 |
| 2014-01-13 05:30:00 | AAPL | Stock | 19.0732 | 19.0732 | 19.0711 | 19.0732 | 12600.0 |
| 2014-01-13 05:50:00 | AAPL | Stock | 19.0693 | 19.0693 | 19.0693 | 19.0693 | 5600.0 |
| 2014-01-13 06:10:00 | AAPL | Stock | 19.0829 | 19.0829 | 19.0829 | 19.0829 | 2800.0 |
| 2014-01-13 06:25:00 | AAPL | Stock | 19.0789 | 19.0789 | 19.0789 | 19.0789 | 8400.0 |
| 2014-01-13 06:45:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0818 | 19.0818 | 14000.0 |
| 2014-01-13 06:55:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0814 | 19.0814 | 13160.0 |
| 2014-01-13 07:00:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0821 | 19.0893 | 65716.0 |
| 2014-01-13 07:05:00 | AAPL | Stock | 19.0893 | 19.1571 | 19.0893 | 19.125 | 54180.0 |
| 2014-01-13 07:10:00 | AAPL | Stock | 19.1271 | 19.1429 | 19.1225 | 19.1389 | 43260.0 |
| 2014-01-13 07:15:00 | AAPL | Stock | 19.1307 | 19.1307 | 19.1071 | 19.1225 | 39900.0 |
| 2014-01-13 07:20:00 | AAPL | Stock | 19.1321 | 19.1375 | 19.1321 | 19.1375 | 16800.0 |
| 2014-01-13 07:25:00 | AAPL | Stock | 19.1418 | 19.1571 | 19.1418 | 19.1521 | 42000.0 |
| 2014-01-13 07:30:00 | AAPL | Stock | 19.1432 | 19.1514 | 19.125 | 19.125 | 19404.0 |
| 2014-01-13 07:40:00 | AAPL | Stock | 19.1132 | 19.1164 | 19.1132 | 19.1164 | 8428.0 |
| 2014-01-13 07:45:00 | AAPL | Stock | 19.125 | 19.125 | 19.125 | 19.125 | 12460.0 |
| 2014-01-13 07:50:00 | AAPL | Stock | 19.1271 | 19.1554 | 19.125 | 19.1554 | 59360.0 |
| 2014-01-13 07:55:00 | AAPL | Stock | 19.1539 | 19.1539 | 19.1429 | 19.1429 | 85568.0 |
| 2014-01-13 08:00:00 | AAPL | Stock | 19.1286 | 19.1554 | 19.0821 | 19.1264 | 350420.0 |
| 2014-01-13 08:05:00 | AAPL | Stock | 19.1186 | 19.13 | 19.095 | 19.095 | 250656.0 |
| 2014-01-13 08:10:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0514 | 19.0514 | 345184.0 |
| 2014-01-13 08:15:00 | AAPL | Stock | 19.0596 | 19.0686 | 19.0507 | 19.0507 | 42000.0 |
| 2014-01-13 08:20:00 | AAPL | Stock | 19.0514 | 19.0514 | 19.0179 | 19.0357 | 285740.0 |
| 2014-01-13 08:25:00 | AAPL | Stock | 19.0357 | 19.0529 | 19.0357 | 19.0411 | 173768.0 |
| 2014-01-13 08:30:00 | AAPL | Stock | 19.0361 | 19.0361 | 19.0286 | 19.0357 | 30800.0 |
| 2014-01-13 08:35:00 | AAPL | Stock | 19.0357 | 19.0393 | 19.0336 | 19.0336 | 114268.0 |
| 2014-01-13 08:40:00 | AAPL | Stock | 19.0314 | 19.0318 | 19.0215 | 19.0318 | 59528.0 |
| 2014-01-13 08:45:00 | AAPL | Stock | 19.0304 | 19.0304 | 19.0214 | 19.0304 | 35000.0 |
| 2014-01-13 08:50:00 | AAPL | Stock | 19.0304 | 19.0496 | 19.0304 | 19.0411 | 169344.0 |
| 2014-01-13 08:55:00 | AAPL | Stock | 19.0454 | 19.0454 | 19.0318 | 19.0364 | 56000.0 |
| 2014-01-13 09:00:00 | AAPL | Stock | 19.0357 | 19.0361 | 19.0264 | 19.0264 | 33600.0 |
| 2014-01-13 09:05:00 | AAPL | Stock | 19.0275 | 19.0357 | 19.0075 | 19.0075 | 150556.0 |
| 2014-01-13 09:10:00 | AAPL | Stock | 19.0114 | 19.0114 | 18.94 | 18.94 | 440748.0 |
| 2014-01-13 09:15:00 | AAPL | Stock | 18.9486 | 18.9632 | 18.9379 | 18.9632 | 170212.0 |
| 2014-01-13 09:20:00 | AAPL | Stock | 18.9596 | 18.9611 | 18.9439 | 18.9446 | 201040.0 |
| 2014-01-13 09:25:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9118 | 18.9286 | 252364.0 |
| 2014-01-13 09:30:00 | AAPL | Stock | 18.9254 | 19.0621 | 18.9243 | 19.0596 | 17450860.0 |
| 2014-01-13 09:35:00 | AAPL | Stock | 19.0579 | 19.1568 | 19.0368 | 19.1168 | 12874596.0 |
| 2014-01-13 09:40:00 | AAPL | Stock | 19.1229 | 19.1534 | 19.0825 | 19.1121 | 8628144.0 |
| 2014-01-13 09:45:00 | AAPL | Stock | 19.1107 | 19.1496 | 19.0943 | 19.1346 | 5389552.0 |
| 2014-01-13 09:50:00 | AAPL | Stock | 19.135 | 19.2125 | 19.1194 | 19.1796 | 8769572.0 |
| 2014-01-13 09:55:00 | AAPL | Stock | 19.1821 | 19.2482 | 19.1797 | 19.2393 | 8610336.0 |
| 2014-01-13 10:00:00 | AAPL | Stock | 19.2418 | 19.2768 | 19.2404 | 19.2546 | 8335516.0 |
| 2014-01-13 10:05:00 | AAPL | Stock | 19.252 | 19.2911 | 19.2446 | 19.2814 | 6371316.0 |
| 2014-01-13 10:10:00 | AAPL | Stock | 19.2721 | 19.2929 | 19.2561 | 19.2709 | 4672724.0 |
| 2014-01-13 10:15:00 | AAPL | Stock | 19.2707 | 19.2761 | 19.2329 | 19.2411 | 4527124.0 |
| 2014-01-13 10:20:00 | AAPL | Stock | 19.2418 | 19.2543 | 19.2304 | 19.2393 | 3150280.0 |
| 2014-01-13 10:25:00 | AAPL | Stock | 19.2386 | 19.2646 | 19.2375 | 19.24 | 2642304.0 |
| 2014-01-13 10:30:00 | AAPL | Stock | 19.2432 | 19.2504 | 19.2243 | 19.2293 | 3007788.0 |
> showing 50 of 371,041 rows — these rows as CSV