PREVIEW / stock_5min / 2014-05-14
file: by_date/stock_5min/2014/2014-05-14.parquet size: 5.4 MB rows: 364,173 symbols: 3,541
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-14 05:05:00 | AAPL | Stock | 21.1579 | 21.1582 | 21.1579 | 21.1582 | 14000.0 |
| 2014-05-14 05:15:00 | AAPL | Stock | 21.1446 | 21.1446 | 21.1446 | 21.1446 | 2800.0 |
| 2014-05-14 05:35:00 | AAPL | Stock | 21.1289 | 21.1289 | 21.1289 | 21.1289 | 5600.0 |
| 2014-05-14 05:45:00 | AAPL | Stock | 21.1257 | 21.1257 | 21.1257 | 21.1257 | 2800.0 |
| 2014-05-14 06:35:00 | AAPL | Stock | 21.1321 | 21.1321 | 21.1321 | 21.1321 | 2800.0 |
| 2014-05-14 06:50:00 | AAPL | Stock | 21.1339 | 21.1339 | 21.1339 | 21.1339 | 2800.0 |
| 2014-05-14 06:55:00 | AAPL | Stock | 21.1479 | 21.1479 | 21.1479 | 21.1479 | 14000.0 |
| 2014-05-14 07:15:00 | AAPL | Stock | 21.1425 | 21.1425 | 21.1425 | 21.1425 | 2800.0 |
| 2014-05-14 07:20:00 | AAPL | Stock | 21.1425 | 21.1425 | 21.1425 | 21.1425 | 2800.0 |
| 2014-05-14 07:25:00 | AAPL | Stock | 21.1418 | 21.1425 | 21.1418 | 21.1425 | 5600.0 |
| 2014-05-14 07:30:00 | AAPL | Stock | 21.135 | 21.135 | 21.1321 | 21.1321 | 11200.0 |
| 2014-05-14 07:40:00 | AAPL | Stock | 21.1375 | 21.1375 | 21.1375 | 21.1375 | 2800.0 |
| 2014-05-14 07:55:00 | AAPL | Stock | 21.1532 | 21.1532 | 21.1532 | 21.1532 | 2800.0 |
| 2014-05-14 08:00:00 | AAPL | Stock | 21.1439 | 21.15 | 21.1418 | 21.1429 | 28364.0 |
| 2014-05-14 08:05:00 | AAPL | Stock | 21.1411 | 21.1429 | 21.1411 | 21.1429 | 9184.0 |
| 2014-05-14 08:10:00 | AAPL | Stock | 21.1357 | 21.1357 | 21.1357 | 21.1357 | 5600.0 |
| 2014-05-14 08:15:00 | AAPL | Stock | 21.1393 | 21.1429 | 21.135 | 21.1429 | 23912.0 |
| 2014-05-14 08:20:00 | AAPL | Stock | 21.1511 | 21.1664 | 21.1504 | 21.1586 | 86632.0 |
| 2014-05-14 08:25:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1507 | 21.1507 | 54516.0 |
| 2014-05-14 08:30:00 | AAPL | Stock | 21.1586 | 21.1586 | 21.1529 | 21.1532 | 8400.0 |
| 2014-05-14 08:35:00 | AAPL | Stock | 21.155 | 21.155 | 21.155 | 21.155 | 2800.0 |
| 2014-05-14 08:45:00 | AAPL | Stock | 21.16 | 21.1604 | 21.1486 | 21.1486 | 36288.0 |
| 2014-05-14 08:50:00 | AAPL | Stock | 21.1571 | 21.1571 | 21.1536 | 21.1536 | 8400.0 |
| 2014-05-14 08:55:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1571 | 21.1571 | 26040.0 |
| 2014-05-14 09:05:00 | AAPL | Stock | 21.1607 | 21.1607 | 21.1482 | 21.1596 | 27440.0 |
| 2014-05-14 09:10:00 | AAPL | Stock | 21.1571 | 21.1643 | 21.1571 | 21.1643 | 8400.0 |
| 2014-05-14 09:20:00 | AAPL | Stock | 21.1632 | 21.1632 | 21.1625 | 21.1625 | 8400.0 |
| 2014-05-14 09:25:00 | AAPL | Stock | 21.1571 | 21.1621 | 21.1536 | 21.1621 | 38780.0 |
| 2014-05-14 09:30:00 | AAPL | Stock | 21.1571 | 21.2339 | 21.1496 | 21.1896 | 5501104.0 |
| 2014-05-14 09:35:00 | AAPL | Stock | 21.1936 | 21.2379 | 21.1864 | 21.2268 | 3743936.0 |
| 2014-05-14 09:40:00 | AAPL | Stock | 21.2254 | 21.2757 | 21.2179 | 21.2582 | 5225444.0 |
| 2014-05-14 09:45:00 | AAPL | Stock | 21.2606 | 21.275 | 21.2071 | 21.21 | 3375540.0 |
| 2014-05-14 09:50:00 | AAPL | Stock | 21.2075 | 21.2496 | 21.2039 | 21.2336 | 2156084.0 |
| 2014-05-14 09:55:00 | AAPL | Stock | 21.2382 | 21.2632 | 21.2329 | 21.2493 | 2549540.0 |
| 2014-05-14 10:00:00 | AAPL | Stock | 21.2489 | 21.2696 | 21.2326 | 21.2679 | 2500316.0 |
| 2014-05-14 10:05:00 | AAPL | Stock | 21.2704 | 21.3268 | 21.2629 | 21.3121 | 5916288.0 |
| 2014-05-14 10:10:00 | AAPL | Stock | 21.3104 | 21.3357 | 21.2932 | 21.3104 | 4680480.0 |
| 2014-05-14 10:15:00 | AAPL | Stock | 21.3111 | 21.3211 | 21.2889 | 21.2986 | 2093280.0 |
| 2014-05-14 10:20:00 | AAPL | Stock | 21.2975 | 21.2975 | 21.2625 | 21.2711 | 3279192.0 |
| 2014-05-14 10:25:00 | AAPL | Stock | 21.27 | 21.2986 | 21.2543 | 21.2936 | 1983212.0 |
| 2014-05-14 10:30:00 | AAPL | Stock | 21.2932 | 21.2989 | 21.2525 | 21.2675 | 2295888.0 |
| 2014-05-14 10:35:00 | AAPL | Stock | 21.2714 | 21.3054 | 21.2607 | 21.2861 | 2514344.0 |
| 2014-05-14 10:40:00 | AAPL | Stock | 21.2861 | 21.3064 | 21.2718 | 21.2729 | 1478680.0 |
| 2014-05-14 10:45:00 | AAPL | Stock | 21.2768 | 21.2918 | 21.2661 | 21.28 | 1922116.0 |
| 2014-05-14 10:50:00 | AAPL | Stock | 21.2782 | 21.3007 | 21.2746 | 21.2839 | 890960.0 |
| 2014-05-14 10:55:00 | AAPL | Stock | 21.2857 | 21.3025 | 21.2768 | 21.2804 | 1019816.0 |
| 2014-05-14 11:00:00 | AAPL | Stock | 21.2832 | 21.3007 | 21.2686 | 21.2736 | 861532.0 |
| 2014-05-14 11:05:00 | AAPL | Stock | 21.2754 | 21.28 | 21.2679 | 21.275 | 769104.0 |
| 2014-05-14 11:10:00 | AAPL | Stock | 21.2764 | 21.2954 | 21.2736 | 21.2761 | 740152.0 |
| 2014-05-14 11:15:00 | AAPL | Stock | 21.2775 | 21.2893 | 21.2743 | 21.2839 | 433384.0 |
> showing 50 of 364,173 rows — these rows as CSV