PREVIEW / stock_5min / 2011-12-21
file: by_date/stock_5min/2011/2011-12-21.parquet size: 4.7 MB rows: 322,345 symbols: 3,562
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-21 04:00:00 | AAPL | Stock | 14.1771 | 14.1771 | 14.1771 | 14.1771 | 5600.0 |
| 2011-12-21 04:15:00 | AAPL | Stock | 14.2071 | 14.2071 | 14.2071 | 14.2071 | 2800.0 |
| 2011-12-21 04:45:00 | AAPL | Stock | 14.1829 | 14.1829 | 14.1829 | 14.1829 | 7000.0 |
| 2011-12-21 05:20:00 | AAPL | Stock | 14.2036 | 14.2036 | 14.2036 | 14.2036 | 12880.0 |
| 2011-12-21 05:25:00 | AAPL | Stock | 14.2032 | 14.2032 | 14.2032 | 14.2032 | 5320.0 |
| 2011-12-21 06:00:00 | AAPL | Stock | 14.2032 | 14.2032 | 14.2032 | 14.2032 | 5600.0 |
| 2011-12-21 06:25:00 | AAPL | Stock | 14.1429 | 14.1786 | 14.1429 | 14.1786 | 5600.0 |
| 2011-12-21 06:35:00 | AAPL | Stock | 14.1582 | 14.1582 | 14.0993 | 14.0993 | 16800.0 |
| 2011-12-21 06:40:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-12-21 07:00:00 | AAPL | Stock | 14.1289 | 14.1357 | 14.1289 | 14.1357 | 5600.0 |
| 2011-12-21 07:05:00 | AAPL | Stock | 14.1289 | 14.1379 | 14.1289 | 14.1379 | 18228.0 |
| 2011-12-21 07:10:00 | AAPL | Stock | 14.1404 | 14.1404 | 14.1404 | 14.1404 | 2800.0 |
| 2011-12-21 07:15:00 | AAPL | Stock | 14.1393 | 14.1407 | 14.1393 | 14.1407 | 8400.0 |
| 2011-12-21 07:20:00 | AAPL | Stock | 14.1421 | 14.1421 | 14.1418 | 14.1418 | 30800.0 |
| 2011-12-21 07:25:00 | AAPL | Stock | 14.1418 | 14.1596 | 14.1418 | 14.1429 | 99400.0 |
| 2011-12-21 07:30:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1296 | 14.1296 | 10612.0 |
| 2011-12-21 07:35:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1368 | 14.1421 | 9800.0 |
| 2011-12-21 07:40:00 | AAPL | Stock | 14.1518 | 14.1518 | 14.1257 | 14.1304 | 55300.0 |
| 2011-12-21 07:45:00 | AAPL | Stock | 14.1196 | 14.1196 | 14.0982 | 14.0982 | 64400.0 |
| 2011-12-21 07:50:00 | AAPL | Stock | 14.1246 | 14.1268 | 14.1075 | 14.1196 | 100800.0 |
| 2011-12-21 08:00:00 | AAPL | Stock | 14.135 | 14.135 | 14.1129 | 14.1129 | 99680.0 |
| 2011-12-21 08:05:00 | AAPL | Stock | 14.1129 | 14.1129 | 14.0761 | 14.0893 | 235676.0 |
| 2011-12-21 08:10:00 | AAPL | Stock | 14.0839 | 14.0839 | 14.0771 | 14.0807 | 106260.0 |
| 2011-12-21 08:15:00 | AAPL | Stock | 14.0754 | 14.0779 | 14.0689 | 14.0732 | 246400.0 |
| 2011-12-21 08:20:00 | AAPL | Stock | 14.075 | 14.0861 | 14.0718 | 14.0807 | 188440.0 |
| 2011-12-21 08:25:00 | AAPL | Stock | 14.0821 | 14.0929 | 14.0821 | 14.0914 | 44940.0 |
| 2011-12-21 08:30:00 | AAPL | Stock | 14.0964 | 14.1 | 14.0929 | 14.1 | 91280.0 |
| 2011-12-21 08:35:00 | AAPL | Stock | 14.1014 | 14.105 | 14.1014 | 14.1036 | 62720.0 |
| 2011-12-21 08:40:00 | AAPL | Stock | 14.1054 | 14.1243 | 14.1054 | 14.1243 | 228004.0 |
| 2011-12-21 08:45:00 | AAPL | Stock | 14.1268 | 14.1321 | 14.1243 | 14.1268 | 212772.0 |
| 2011-12-21 08:50:00 | AAPL | Stock | 14.1286 | 14.1504 | 14.1268 | 14.1393 | 331212.0 |
| 2011-12-21 08:55:00 | AAPL | Stock | 14.1386 | 14.1418 | 14.1339 | 14.1371 | 65100.0 |
| 2011-12-21 09:00:00 | AAPL | Stock | 14.1411 | 14.1571 | 14.1411 | 14.1571 | 299768.0 |
| 2011-12-21 09:05:00 | AAPL | Stock | 14.1589 | 14.1836 | 14.1464 | 14.1786 | 535752.0 |
| 2011-12-21 09:10:00 | AAPL | Stock | 14.1789 | 14.185 | 14.1464 | 14.1704 | 504532.0 |
| 2011-12-21 09:15:00 | AAPL | Stock | 14.165 | 14.1732 | 14.1629 | 14.1664 | 81900.0 |
| 2011-12-21 09:20:00 | AAPL | Stock | 14.1725 | 14.1746 | 14.1643 | 14.1643 | 31696.0 |
| 2011-12-21 09:25:00 | AAPL | Stock | 14.1661 | 14.1736 | 14.1607 | 14.1704 | 482552.0 |
| 2011-12-21 09:30:00 | AAPL | Stock | 14.1632 | 14.1893 | 14.1254 | 14.1464 | 15237152.0 |
| 2011-12-21 09:35:00 | AAPL | Stock | 14.1475 | 14.1546 | 14.1307 | 14.1375 | 5644212.0 |
| 2011-12-21 09:40:00 | AAPL | Stock | 14.1379 | 14.1404 | 14.025 | 14.0361 | 14513632.0 |
| 2011-12-21 09:45:00 | AAPL | Stock | 14.0338 | 14.0921 | 14.0338 | 14.0464 | 8548288.0 |
| 2011-12-21 09:50:00 | AAPL | Stock | 14.0468 | 14.0814 | 14.0466 | 14.067 | 4809700.0 |
| 2011-12-21 09:55:00 | AAPL | Stock | 14.0719 | 14.0986 | 14.0479 | 14.0957 | 5706652.0 |
| 2011-12-21 10:00:00 | AAPL | Stock | 14.095 | 14.0971 | 14.0454 | 14.0636 | 7165172.0 |
| 2011-12-21 10:05:00 | AAPL | Stock | 14.0636 | 14.0875 | 14.0554 | 14.0743 | 3792348.0 |
| 2011-12-21 10:10:00 | AAPL | Stock | 14.0757 | 14.1061 | 14.0732 | 14.1032 | 4852344.0 |
| 2011-12-21 10:15:00 | AAPL | Stock | 14.1021 | 14.1386 | 14.0986 | 14.1282 | 6512380.0 |
| 2011-12-21 10:20:00 | AAPL | Stock | 14.1284 | 14.1571 | 14.1282 | 14.1343 | 6502468.0 |
| 2011-12-21 10:25:00 | AAPL | Stock | 14.1304 | 14.135 | 14.1086 | 14.1211 | 3735508.0 |
> showing 50 of 322,345 rows — these rows as CSV