PREVIEW / stock_5min / 2008-04-29
file: by_date/stock_5min/2008/2008-04-29.parquet size: 4.3 MB rows: 306,455 symbols: 3,297
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-29 07:10:00 | AAPL | Stock | 6.1179 | 6.1296 | 6.1179 | 6.1296 | 11200.0 |
| 2008-04-29 07:30:00 | AAPL | Stock | 6.1293 | 6.1296 | 6.1268 | 6.1268 | 22120.0 |
| 2008-04-29 07:40:00 | AAPL | Stock | 6.1514 | 6.1514 | 6.1514 | 6.1514 | 14000.0 |
| 2008-04-29 07:50:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 2800.0 |
| 2008-04-29 08:00:00 | AAPL | Stock | 6.1321 | 6.1436 | 6.1321 | 6.1339 | 509376.0 |
| 2008-04-29 08:05:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1286 | 6.1307 | 159404.0 |
| 2008-04-29 08:10:00 | AAPL | Stock | 6.1286 | 6.1429 | 6.1268 | 6.1429 | 255612.0 |
| 2008-04-29 08:15:00 | AAPL | Stock | 6.1429 | 6.1446 | 6.1357 | 6.1379 | 232988.0 |
| 2008-04-29 08:20:00 | AAPL | Stock | 6.1393 | 6.1464 | 6.1393 | 6.1393 | 324604.0 |
| 2008-04-29 08:25:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1361 | 6.1396 | 54040.0 |
| 2008-04-29 08:30:00 | AAPL | Stock | 6.1421 | 6.1446 | 6.1421 | 6.1432 | 103376.0 |
| 2008-04-29 08:35:00 | AAPL | Stock | 6.1429 | 6.1461 | 6.1429 | 6.1446 | 115080.0 |
| 2008-04-29 08:40:00 | AAPL | Stock | 6.1429 | 6.1439 | 6.1414 | 6.1414 | 288120.0 |
| 2008-04-29 08:45:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1336 | 6.1336 | 251160.0 |
| 2008-04-29 08:50:00 | AAPL | Stock | 6.1307 | 6.1364 | 6.125 | 6.1271 | 471492.0 |
| 2008-04-29 08:55:00 | AAPL | Stock | 6.1304 | 6.1321 | 6.1286 | 6.1311 | 39200.0 |
| 2008-04-29 09:00:00 | AAPL | Stock | 6.1321 | 6.1375 | 6.1321 | 6.1332 | 120120.0 |
| 2008-04-29 09:05:00 | AAPL | Stock | 6.1364 | 6.1364 | 6.1332 | 6.1346 | 60200.0 |
| 2008-04-29 09:10:00 | AAPL | Stock | 6.1343 | 6.1375 | 6.1343 | 6.1346 | 57400.0 |
| 2008-04-29 09:15:00 | AAPL | Stock | 6.1375 | 6.1375 | 6.1375 | 6.1375 | 25200.0 |
| 2008-04-29 09:20:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1332 | 6.1332 | 56168.0 |
| 2008-04-29 09:25:00 | AAPL | Stock | 6.1321 | 6.1329 | 6.1107 | 6.1107 | 397124.0 |
| 2008-04-29 09:30:00 | AAPL | Stock | 6.1111 | 6.1268 | 6.0804 | 6.1236 | 35150752.0 |
| 2008-04-29 09:35:00 | AAPL | Stock | 6.1225 | 6.1425 | 6.1121 | 6.1282 | 15202936.0 |
| 2008-04-29 09:40:00 | AAPL | Stock | 6.1264 | 6.1496 | 6.1261 | 6.1443 | 13200124.0 |
| 2008-04-29 09:45:00 | AAPL | Stock | 6.1457 | 6.1846 | 6.1329 | 6.1732 | 23492000.0 |
| 2008-04-29 09:50:00 | AAPL | Stock | 6.1736 | 6.1871 | 6.1686 | 6.1704 | 17521784.0 |
| 2008-04-29 09:55:00 | AAPL | Stock | 6.1691 | 6.1929 | 6.1691 | 6.1832 | 21194096.0 |
| 2008-04-29 10:00:00 | AAPL | Stock | 6.1839 | 6.2125 | 6.1839 | 6.2093 | 27247024.0 |
| 2008-04-29 10:05:00 | AAPL | Stock | 6.2086 | 6.21 | 6.1943 | 6.1979 | 13372856.0 |
| 2008-04-29 10:10:00 | AAPL | Stock | 6.1979 | 6.1979 | 6.1757 | 6.1818 | 16476628.0 |
| 2008-04-29 10:15:00 | AAPL | Stock | 6.1821 | 6.1868 | 6.1657 | 6.1754 | 12076736.0 |
| 2008-04-29 10:20:00 | AAPL | Stock | 6.175 | 6.1857 | 6.1614 | 6.1621 | 12154716.0 |
| 2008-04-29 10:25:00 | AAPL | Stock | 6.1621 | 6.1707 | 6.1375 | 6.145 | 19730900.0 |
| 2008-04-29 10:30:00 | AAPL | Stock | 6.145 | 6.1636 | 6.1425 | 6.1607 | 13083924.0 |
| 2008-04-29 10:35:00 | AAPL | Stock | 6.1607 | 6.18 | 6.1607 | 6.18 | 11908204.0 |
| 2008-04-29 10:40:00 | AAPL | Stock | 6.1804 | 6.1889 | 6.1711 | 6.1826 | 12033700.0 |
| 2008-04-29 10:45:00 | AAPL | Stock | 6.1818 | 6.1889 | 6.1746 | 6.1789 | 9771048.0 |
| 2008-04-29 10:50:00 | AAPL | Stock | 6.1789 | 6.1893 | 6.1732 | 6.1882 | 8668520.0 |
| 2008-04-29 10:55:00 | AAPL | Stock | 6.1882 | 6.1961 | 6.1789 | 6.1843 | 8833104.0 |
| 2008-04-29 11:00:00 | AAPL | Stock | 6.1843 | 6.1911 | 6.1768 | 6.1904 | 7078624.0 |
| 2008-04-29 11:05:00 | AAPL | Stock | 6.1911 | 6.1971 | 6.1789 | 6.1954 | 6086528.0 |
| 2008-04-29 11:10:00 | AAPL | Stock | 6.1954 | 6.2018 | 6.1864 | 6.2018 | 12633880.0 |
| 2008-04-29 11:15:00 | AAPL | Stock | 6.2014 | 6.2211 | 6.1986 | 6.2164 | 14821940.0 |
| 2008-04-29 11:20:00 | AAPL | Stock | 6.2164 | 6.2375 | 6.2154 | 6.2325 | 20477576.0 |
| 2008-04-29 11:25:00 | AAPL | Stock | 6.2325 | 6.2418 | 6.225 | 6.2369 | 11079376.0 |
| 2008-04-29 11:30:00 | AAPL | Stock | 6.2371 | 6.2407 | 6.2221 | 6.2229 | 9585100.0 |
| 2008-04-29 11:35:00 | AAPL | Stock | 6.2225 | 6.2296 | 6.2154 | 6.2275 | 10090612.0 |
| 2008-04-29 11:40:00 | AAPL | Stock | 6.2271 | 6.2329 | 6.2196 | 6.2304 | 6830376.0 |
| 2008-04-29 11:45:00 | AAPL | Stock | 6.2307 | 6.2311 | 6.2221 | 6.2243 | 6873300.0 |
> showing 50 of 306,455 rows — these rows as CSV