PREVIEW / stock_5min / 2013-12-10
file: by_date/stock_5min/2013/2013-12-10.parquet size: 5.4 MB rows: 361,904 symbols: 3,527
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-12-10 04:00:00 | AAPL | Stock | 20.2721 | 20.2721 | 20.2721 | 20.2721 | 2800.0 |
| 2013-12-10 05:50:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 2800.0 |
| 2013-12-10 06:05:00 | AAPL | Stock | 20.2589 | 20.2589 | 20.2589 | 20.2589 | 2800.0 |
| 2013-12-10 06:15:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 21000.0 |
| 2013-12-10 06:30:00 | AAPL | Stock | 20.2489 | 20.2489 | 20.2489 | 20.2489 | 5572.0 |
| 2013-12-10 06:50:00 | AAPL | Stock | 20.2429 | 20.2429 | 20.2429 | 20.2429 | 8680.0 |
| 2013-12-10 06:55:00 | AAPL | Stock | 20.2357 | 20.2357 | 20.2264 | 20.2264 | 36400.0 |
| 2013-12-10 07:05:00 | AAPL | Stock | 20.2396 | 20.2396 | 20.2393 | 20.2393 | 16800.0 |
| 2013-12-10 07:10:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2236 | 20.2236 | 8400.0 |
| 2013-12-10 07:15:00 | AAPL | Stock | 20.2232 | 20.2279 | 20.215 | 20.215 | 32200.0 |
| 2013-12-10 07:20:00 | AAPL | Stock | 20.2071 | 20.2071 | 20.2071 | 20.2071 | 11200.0 |
| 2013-12-10 07:25:00 | AAPL | Stock | 20.2107 | 20.2107 | 20.2007 | 20.2007 | 11200.0 |
| 2013-12-10 07:30:00 | AAPL | Stock | 20.1968 | 20.1968 | 20.1696 | 20.1786 | 56532.0 |
| 2013-12-10 07:45:00 | AAPL | Stock | 20.1893 | 20.1893 | 20.1893 | 20.1893 | 2800.0 |
| 2013-12-10 07:50:00 | AAPL | Stock | 20.1857 | 20.1964 | 20.1857 | 20.1964 | 16800.0 |
| 2013-12-10 07:55:00 | AAPL | Stock | 20.19 | 20.2029 | 20.1786 | 20.1836 | 123200.0 |
| 2013-12-10 08:00:00 | AAPL | Stock | 20.1929 | 20.2329 | 20.1771 | 20.2296 | 385448.0 |
| 2013-12-10 08:05:00 | AAPL | Stock | 20.1775 | 20.1775 | 20.1429 | 20.1518 | 267820.0 |
| 2013-12-10 08:10:00 | AAPL | Stock | 20.1468 | 20.1536 | 20.145 | 20.1536 | 37912.0 |
| 2013-12-10 08:15:00 | AAPL | Stock | 20.1589 | 20.1589 | 20.1343 | 20.1375 | 208180.0 |
| 2013-12-10 08:20:00 | AAPL | Stock | 20.1407 | 20.1411 | 20.125 | 20.1371 | 202888.0 |
| 2013-12-10 08:25:00 | AAPL | Stock | 20.1304 | 20.1357 | 20.1268 | 20.1268 | 100604.0 |
| 2013-12-10 08:30:00 | AAPL | Stock | 20.1307 | 20.1404 | 20.1307 | 20.1389 | 67592.0 |
| 2013-12-10 08:35:00 | AAPL | Stock | 20.1389 | 20.1554 | 20.1389 | 20.1525 | 116480.0 |
| 2013-12-10 08:40:00 | AAPL | Stock | 20.1525 | 20.1561 | 20.1504 | 20.1504 | 56000.0 |
| 2013-12-10 08:45:00 | AAPL | Stock | 20.1504 | 20.1561 | 20.1504 | 20.1507 | 70980.0 |
| 2013-12-10 08:50:00 | AAPL | Stock | 20.1507 | 20.1507 | 20.1289 | 20.1439 | 138096.0 |
| 2013-12-10 08:55:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1343 | 20.1429 | 90496.0 |
| 2013-12-10 09:00:00 | AAPL | Stock | 20.1432 | 20.1507 | 20.1382 | 20.1429 | 188048.0 |
| 2013-12-10 09:05:00 | AAPL | Stock | 20.1411 | 20.1429 | 20.1286 | 20.1429 | 143696.0 |
| 2013-12-10 09:10:00 | AAPL | Stock | 20.1446 | 20.1479 | 20.1339 | 20.1429 | 82348.0 |
| 2013-12-10 09:15:00 | AAPL | Stock | 20.1443 | 20.1482 | 20.1386 | 20.1404 | 109928.0 |
| 2013-12-10 09:20:00 | AAPL | Stock | 20.1389 | 20.1511 | 20.1339 | 20.1511 | 74816.0 |
| 2013-12-10 09:25:00 | AAPL | Stock | 20.1432 | 20.1536 | 20.1286 | 20.1293 | 336868.0 |
| 2013-12-10 09:30:00 | AAPL | Stock | 20.1293 | 20.1636 | 20.0893 | 20.1066 | 12631304.0 |
| 2013-12-10 09:35:00 | AAPL | Stock | 20.1054 | 20.1318 | 20.0429 | 20.1271 | 11589508.0 |
| 2013-12-10 09:40:00 | AAPL | Stock | 20.1299 | 20.1596 | 20.1093 | 20.1186 | 7285208.0 |
| 2013-12-10 09:45:00 | AAPL | Stock | 20.1189 | 20.1216 | 20.0807 | 20.1025 | 5195204.0 |
| 2013-12-10 09:50:00 | AAPL | Stock | 20.105 | 20.1071 | 20.0543 | 20.0836 | 6406568.0 |
| 2013-12-10 09:55:00 | AAPL | Stock | 20.0775 | 20.1018 | 20.0654 | 20.0932 | 2636508.0 |
| 2013-12-10 10:00:00 | AAPL | Stock | 20.0919 | 20.0989 | 20.07 | 20.0907 | 2697884.0 |
| 2013-12-10 10:05:00 | AAPL | Stock | 20.0907 | 20.0975 | 20.0636 | 20.0661 | 2586472.0 |
| 2013-12-10 10:10:00 | AAPL | Stock | 20.0671 | 20.1121 | 20.0479 | 20.105 | 5431048.0 |
| 2013-12-10 10:15:00 | AAPL | Stock | 20.1068 | 20.1307 | 20.1025 | 20.116 | 5342176.0 |
| 2013-12-10 10:20:00 | AAPL | Stock | 20.1089 | 20.1168 | 20.0929 | 20.1025 | 4061400.0 |
| 2013-12-10 10:25:00 | AAPL | Stock | 20.1014 | 20.1375 | 20.0821 | 20.1375 | 3756284.0 |
| 2013-12-10 10:30:00 | AAPL | Stock | 20.1379 | 20.1561 | 20.1339 | 20.1464 | 3981040.0 |
| 2013-12-10 10:35:00 | AAPL | Stock | 20.1443 | 20.1896 | 20.1379 | 20.1847 | 4345908.0 |
| 2013-12-10 10:40:00 | AAPL | Stock | 20.1849 | 20.1893 | 20.1646 | 20.17 | 2839256.0 |
| 2013-12-10 10:45:00 | AAPL | Stock | 20.1732 | 20.2107 | 20.1729 | 20.2064 | 3739680.0 |
> showing 50 of 361,904 rows — these rows as CSV