PREVIEW / stock_5min / 2010-05-06
file: by_date/stock_5min/2010/2010-05-06.parquet size: 5.5 MB rows: 366,030 symbols: 3,492
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-06 04:05:00 | AAPL | Stock | 9.1129 | 9.15 | 9.1129 | 9.15 | 33600.0 |
| 2010-05-06 04:10:00 | AAPL | Stock | 9.2857 | 9.2857 | 9.2857 | 9.2857 | 2800.0 |
| 2010-05-06 04:15:00 | AAPL | Stock | 9.1518 | 9.1518 | 9.1429 | 9.1429 | 36400.0 |
| 2010-05-06 04:20:00 | AAPL | Stock | 9.1246 | 9.1246 | 9.1246 | 9.1246 | 14000.0 |
| 2010-05-06 04:25:00 | AAPL | Stock | 9.1536 | 9.1536 | 9.1536 | 9.1536 | 5600.0 |
| 2010-05-06 04:30:00 | AAPL | Stock | 9.1536 | 9.1536 | 9.1286 | 9.1286 | 5600.0 |
| 2010-05-06 04:40:00 | AAPL | Stock | 9.1354 | 9.1357 | 9.1354 | 9.1357 | 22400.0 |
| 2010-05-06 04:45:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 14000.0 |
| 2010-05-06 05:05:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 2800.0 |
| 2010-05-06 05:35:00 | AAPL | Stock | 9.1286 | 9.1286 | 9.1286 | 9.1286 | 2800.0 |
| 2010-05-06 06:00:00 | AAPL | Stock | 9.1357 | 9.1357 | 9.1339 | 9.1339 | 11200.0 |
| 2010-05-06 06:10:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1607 | 9.1607 | 2800.0 |
| 2010-05-06 06:50:00 | AAPL | Stock | 9.1625 | 9.1643 | 9.1625 | 9.1643 | 11200.0 |
| 2010-05-06 07:00:00 | AAPL | Stock | 9.1714 | 9.1918 | 9.1661 | 9.1836 | 25200.0 |
| 2010-05-06 07:05:00 | AAPL | Stock | 9.1786 | 9.1839 | 9.1786 | 9.1786 | 38472.0 |
| 2010-05-06 07:10:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 14000.0 |
| 2010-05-06 07:15:00 | AAPL | Stock | 9.1786 | 9.1839 | 9.1679 | 9.1679 | 23072.0 |
| 2010-05-06 07:25:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 5600.0 |
| 2010-05-06 07:30:00 | AAPL | Stock | 9.1689 | 9.1689 | 9.1689 | 9.1689 | 2800.0 |
| 2010-05-06 07:35:00 | AAPL | Stock | 9.1643 | 9.1704 | 9.1643 | 9.1704 | 27888.0 |
| 2010-05-06 07:40:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1714 | 9.1714 | 2800.0 |
| 2010-05-06 07:45:00 | AAPL | Stock | 9.1625 | 9.1625 | 9.1425 | 9.1493 | 40600.0 |
| 2010-05-06 07:50:00 | AAPL | Stock | 9.1493 | 9.1496 | 9.1493 | 9.1496 | 5600.0 |
| 2010-05-06 07:55:00 | AAPL | Stock | 9.1579 | 9.1589 | 9.15 | 9.15 | 41720.0 |
| 2010-05-06 08:00:00 | AAPL | Stock | 9.155 | 9.1661 | 9.1518 | 9.1589 | 298648.0 |
| 2010-05-06 08:05:00 | AAPL | Stock | 9.1589 | 9.1657 | 9.1571 | 9.1607 | 179956.0 |
| 2010-05-06 08:10:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1339 | 9.1339 | 378252.0 |
| 2010-05-06 08:15:00 | AAPL | Stock | 9.1423 | 9.1425 | 9.0957 | 9.0975 | 164612.0 |
| 2010-05-06 08:20:00 | AAPL | Stock | 9.1064 | 9.1071 | 9.0964 | 9.0982 | 201684.0 |
| 2010-05-06 08:25:00 | AAPL | Stock | 9.1 | 9.1389 | 9.1 | 9.1286 | 134400.0 |
| 2010-05-06 08:30:00 | AAPL | Stock | 9.1375 | 9.1429 | 9.1104 | 9.1104 | 358456.0 |
| 2010-05-06 08:35:00 | AAPL | Stock | 9.1132 | 9.1164 | 9.0986 | 9.1164 | 176512.0 |
| 2010-05-06 08:40:00 | AAPL | Stock | 9.1146 | 9.1146 | 9.0984 | 9.1036 | 98000.0 |
| 2010-05-06 08:45:00 | AAPL | Stock | 9.1007 | 9.1071 | 9.0729 | 9.0982 | 450800.0 |
| 2010-05-06 08:50:00 | AAPL | Stock | 9.0982 | 9.1 | 9.0714 | 9.0714 | 246260.0 |
| 2010-05-06 08:55:00 | AAPL | Stock | 9.0718 | 9.0757 | 9.0536 | 9.0554 | 295568.0 |
| 2010-05-06 09:00:00 | AAPL | Stock | 9.0536 | 9.0689 | 9.0357 | 9.0536 | 538804.0 |
| 2010-05-06 09:05:00 | AAPL | Stock | 9.0568 | 9.0782 | 9.0536 | 9.0657 | 435960.0 |
| 2010-05-06 09:10:00 | AAPL | Stock | 9.0657 | 9.0711 | 9.0504 | 9.0518 | 162008.0 |
| 2010-05-06 09:15:00 | AAPL | Stock | 9.0536 | 9.0625 | 9.0518 | 9.0564 | 424648.0 |
| 2010-05-06 09:20:00 | AAPL | Stock | 9.0557 | 9.0679 | 9.0486 | 9.0679 | 739228.0 |
| 2010-05-06 09:25:00 | AAPL | Stock | 9.0671 | 9.0779 | 9.055 | 9.06 | 254100.0 |
| 2010-05-06 09:30:00 | AAPL | Stock | 9.0654 | 9.1839 | 9.055 | 9.1804 | 20646668.0 |
| 2010-05-06 09:35:00 | AAPL | Stock | 9.1804 | 9.205 | 9.1675 | 9.1868 | 19430544.0 |
| 2010-05-06 09:40:00 | AAPL | Stock | 9.1893 | 9.2082 | 9.1657 | 9.1786 | 14554008.0 |
| 2010-05-06 09:45:00 | AAPL | Stock | 9.1821 | 9.1893 | 9.1107 | 9.1379 | 15899856.0 |
| 2010-05-06 09:50:00 | AAPL | Stock | 9.1379 | 9.1482 | 9.1161 | 9.1281 | 9953132.0 |
| 2010-05-06 09:55:00 | AAPL | Stock | 9.1286 | 9.1954 | 9.1211 | 9.1771 | 11638256.0 |
| 2010-05-06 10:00:00 | AAPL | Stock | 9.1789 | 9.2104 | 9.1704 | 9.1968 | 10204348.0 |
| 2010-05-06 10:05:00 | AAPL | Stock | 9.1975 | 9.2014 | 9.1661 | 9.1804 | 8454544.0 |
> showing 50 of 366,030 rows — these rows as CSV