PREVIEW / stock_1min / 2014-05-13
file: by_date/stock_1min/2014/2014-05-13.parquet size: 14.1 MB rows: 1,045,873 symbols: 2,877
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-05-13 04:42:00 | AAPL | Stock | 21.1804 | 21.1804 | 21.1804 | 21.1804 | 2800.0 |
| 2014-05-13 04:48:00 | AAPL | Stock | 21.1725 | 21.1725 | 21.1725 | 21.1725 | 2800.0 |
| 2014-05-13 04:52:00 | AAPL | Stock | 21.1836 | 21.1836 | 21.1836 | 21.1836 | 2800.0 |
| 2014-05-13 05:14:00 | AAPL | Stock | 21.1511 | 21.1511 | 21.1511 | 21.1511 | 9520.0 |
| 2014-05-13 05:35:00 | AAPL | Stock | 21.1929 | 21.1929 | 21.1929 | 21.1929 | 2800.0 |
| 2014-05-13 06:12:00 | AAPL | Stock | 21.1536 | 21.1536 | 21.1536 | 21.1536 | 8400.0 |
| 2014-05-13 06:24:00 | AAPL | Stock | 21.1464 | 21.1464 | 21.1464 | 21.1464 | 2800.0 |
| 2014-05-13 07:03:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1607 | 21.1607 | 11760.0 |
| 2014-05-13 07:08:00 | AAPL | Stock | 21.1711 | 21.1711 | 21.1711 | 21.1711 | 11172.0 |
| 2014-05-13 07:25:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-13 07:30:00 | AAPL | Stock | 21.1857 | 21.1857 | 21.1857 | 21.1857 | 2800.0 |
| 2014-05-13 07:31:00 | AAPL | Stock | 21.1818 | 21.1818 | 21.1818 | 21.1818 | 2800.0 |
| 2014-05-13 07:32:00 | AAPL | Stock | 21.1839 | 21.1839 | 21.1839 | 21.1839 | 2800.0 |
| 2014-05-13 07:38:00 | AAPL | Stock | 21.1868 | 21.1868 | 21.1846 | 21.1846 | 16800.0 |
| 2014-05-13 07:40:00 | AAPL | Stock | 21.1868 | 21.1868 | 21.1868 | 21.1868 | 3220.0 |
| 2014-05-13 07:43:00 | AAPL | Stock | 21.185 | 21.185 | 21.185 | 21.185 | 2800.0 |
| 2014-05-13 07:44:00 | AAPL | Stock | 21.1793 | 21.185 | 21.1786 | 21.185 | 14000.0 |
| 2014-05-13 07:45:00 | AAPL | Stock | 21.1786 | 21.1786 | 21.1786 | 21.1786 | 2800.0 |
| 2014-05-13 07:46:00 | AAPL | Stock | 21.175 | 21.175 | 21.175 | 21.175 | 2800.0 |
| 2014-05-13 07:47:00 | AAPL | Stock | 21.1732 | 21.1793 | 21.1732 | 21.1793 | 5600.0 |
| 2014-05-13 07:48:00 | AAPL | Stock | 21.1732 | 21.1732 | 21.1679 | 21.1679 | 69972.0 |
| 2014-05-13 08:00:00 | AAPL | Stock | 21.1807 | 21.185 | 21.1807 | 21.185 | 7980.0 |
| 2014-05-13 08:01:00 | AAPL | Stock | 21.1621 | 21.1686 | 21.1621 | 21.1654 | 16800.0 |
| 2014-05-13 08:02:00 | AAPL | Stock | 21.1711 | 21.1711 | 21.1711 | 21.1711 | 28000.0 |
| 2014-05-13 08:04:00 | AAPL | Stock | 21.1586 | 21.1586 | 21.1582 | 21.1582 | 8400.0 |
| 2014-05-13 08:05:00 | AAPL | Stock | 21.1482 | 21.1586 | 21.1482 | 21.1586 | 8400.0 |
| 2014-05-13 08:09:00 | AAPL | Stock | 21.1564 | 21.1564 | 21.1564 | 21.1564 | 2800.0 |
| 2014-05-13 08:10:00 | AAPL | Stock | 21.1564 | 21.1571 | 21.1564 | 21.1571 | 8400.0 |
| 2014-05-13 08:12:00 | AAPL | Stock | 21.1532 | 21.1532 | 21.1532 | 21.1532 | 2800.0 |
| 2014-05-13 08:13:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1518 | 21.1518 | 11200.0 |
| 2014-05-13 08:15:00 | AAPL | Stock | 21.15 | 21.15 | 21.15 | 21.15 | 8400.0 |
| 2014-05-13 08:16:00 | AAPL | Stock | 21.15 | 21.15 | 21.15 | 21.15 | 5600.0 |
| 2014-05-13 08:19:00 | AAPL | Stock | 21.1489 | 21.1493 | 21.1411 | 21.1425 | 68936.0 |
| 2014-05-13 08:20:00 | AAPL | Stock | 21.1411 | 21.1425 | 21.1411 | 21.1425 | 28000.0 |
| 2014-05-13 08:23:00 | AAPL | Stock | 21.1336 | 21.1336 | 21.1325 | 21.1325 | 28000.0 |
| 2014-05-13 08:24:00 | AAPL | Stock | 21.1229 | 21.1236 | 21.1229 | 21.1236 | 11200.0 |
| 2014-05-13 08:26:00 | AAPL | Stock | 21.1275 | 21.1286 | 21.1268 | 21.1268 | 11900.0 |
| 2014-05-13 08:27:00 | AAPL | Stock | 21.12 | 21.1218 | 21.1179 | 21.1218 | 36400.0 |
| 2014-05-13 08:29:00 | AAPL | Stock | 21.1236 | 21.1296 | 21.1236 | 21.1296 | 18760.0 |
| 2014-05-13 08:30:00 | AAPL | Stock | 21.13 | 21.13 | 21.1071 | 21.1071 | 52808.0 |
| 2014-05-13 08:31:00 | AAPL | Stock | 21.1214 | 21.1214 | 21.1071 | 21.1071 | 33600.0 |
| 2014-05-13 08:32:00 | AAPL | Stock | 21.1182 | 21.125 | 21.1182 | 21.125 | 28000.0 |
| 2014-05-13 08:33:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 7000.0 |
| 2014-05-13 08:34:00 | AAPL | Stock | 21.125 | 21.125 | 21.125 | 21.125 | 7000.0 |
| 2014-05-13 08:37:00 | AAPL | Stock | 21.1236 | 21.125 | 21.1221 | 21.1239 | 44800.0 |
| 2014-05-13 08:38:00 | AAPL | Stock | 21.1221 | 21.1221 | 21.1196 | 21.1196 | 19600.0 |
| 2014-05-13 08:39:00 | AAPL | Stock | 21.1221 | 21.1304 | 21.1221 | 21.1304 | 19600.0 |
| 2014-05-13 08:40:00 | AAPL | Stock | 21.1254 | 21.1254 | 21.1246 | 21.1246 | 16800.0 |
| 2014-05-13 08:42:00 | AAPL | Stock | 21.1271 | 21.1271 | 21.1271 | 21.1271 | 14000.0 |
| 2014-05-13 08:48:00 | AAPL | Stock | 21.1286 | 21.1314 | 21.125 | 21.125 | 26488.0 |
> showing 50 of 1,045,873 rows — these rows as CSV