PREVIEW / stock_5min / 2006-06-01
file: by_date/stock_5min/2006/2006-06-01.parquet size: 3.2 MB rows: 229,864 symbols: 2,266
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-01 07:55:00 | AAPL | Stock | 2.1286 | 2.1286 | 2.1286 | 2.1286 | 5600.0 |
| 2006-06-01 08:00:00 | AAPL | Stock | 2.1286 | 2.1293 | 2.1261 | 2.1261 | 166768.0 |
| 2006-06-01 08:05:00 | AAPL | Stock | 2.1261 | 2.1304 | 2.1261 | 2.1304 | 53144.0 |
| 2006-06-01 08:10:00 | AAPL | Stock | 2.1296 | 2.1321 | 2.1296 | 2.1321 | 39900.0 |
| 2006-06-01 08:15:00 | AAPL | Stock | 2.1339 | 2.1339 | 2.1296 | 2.1304 | 90132.0 |
| 2006-06-01 08:20:00 | AAPL | Stock | 2.1296 | 2.1304 | 2.1296 | 2.1304 | 14000.0 |
| 2006-06-01 08:25:00 | AAPL | Stock | 2.1304 | 2.1307 | 2.1296 | 2.1296 | 70140.0 |
| 2006-06-01 08:30:00 | AAPL | Stock | 2.1257 | 2.1321 | 2.1254 | 2.1321 | 125916.0 |
| 2006-06-01 08:35:00 | AAPL | Stock | 2.1304 | 2.1386 | 2.1304 | 2.1386 | 199500.0 |
| 2006-06-01 08:40:00 | AAPL | Stock | 2.1386 | 2.1393 | 2.1364 | 2.1386 | 246120.0 |
| 2006-06-01 08:45:00 | AAPL | Stock | 2.1379 | 2.1407 | 2.1357 | 2.1393 | 211848.0 |
| 2006-06-01 08:50:00 | AAPL | Stock | 2.1411 | 2.1457 | 2.14 | 2.1429 | 402500.0 |
| 2006-06-01 08:55:00 | AAPL | Stock | 2.1439 | 2.1479 | 2.1429 | 2.1468 | 712376.0 |
| 2006-06-01 09:00:00 | AAPL | Stock | 2.1464 | 2.1464 | 2.1389 | 2.1389 | 308448.0 |
| 2006-06-01 09:05:00 | AAPL | Stock | 2.1425 | 2.1429 | 2.1393 | 2.1429 | 233128.0 |
| 2006-06-01 09:10:00 | AAPL | Stock | 2.1425 | 2.1425 | 2.1407 | 2.1425 | 167720.0 |
| 2006-06-01 09:15:00 | AAPL | Stock | 2.1425 | 2.1425 | 2.1379 | 2.1379 | 49812.0 |
| 2006-06-01 09:20:00 | AAPL | Stock | 2.1382 | 2.1382 | 2.1321 | 2.1321 | 119168.0 |
| 2006-06-01 09:25:00 | AAPL | Stock | 2.135 | 2.1421 | 2.1304 | 2.1386 | 1095780.0 |
| 2006-06-01 09:30:00 | AAPL | Stock | 2.1375 | 2.1454 | 2.1257 | 2.1339 | 31409784.0 |
| 2006-06-01 09:35:00 | AAPL | Stock | 2.1339 | 2.1521 | 2.1311 | 2.14 | 21815780.0 |
| 2006-06-01 09:40:00 | AAPL | Stock | 2.1404 | 2.145 | 2.1357 | 2.1379 | 19802524.0 |
| 2006-06-01 09:45:00 | AAPL | Stock | 2.1382 | 2.1496 | 2.1311 | 2.1471 | 22776712.0 |
| 2006-06-01 09:50:00 | AAPL | Stock | 2.1468 | 2.1493 | 2.1411 | 2.1418 | 16208332.0 |
| 2006-06-01 09:55:00 | AAPL | Stock | 2.1418 | 2.1446 | 2.1371 | 2.1429 | 13839644.0 |
| 2006-06-01 10:00:00 | AAPL | Stock | 2.1436 | 2.1461 | 2.1357 | 2.1443 | 17129756.0 |
| 2006-06-01 10:05:00 | AAPL | Stock | 2.1443 | 2.1557 | 2.1429 | 2.1475 | 23851828.0 |
| 2006-06-01 10:10:00 | AAPL | Stock | 2.1475 | 2.1618 | 2.1475 | 2.1561 | 23554776.0 |
| 2006-06-01 10:15:00 | AAPL | Stock | 2.1561 | 2.1643 | 2.1536 | 2.1604 | 17088232.0 |
| 2006-06-01 10:20:00 | AAPL | Stock | 2.1596 | 2.1675 | 2.1586 | 2.1671 | 20144404.0 |
| 2006-06-01 10:25:00 | AAPL | Stock | 2.1671 | 2.1707 | 2.165 | 2.1668 | 21632828.0 |
| 2006-06-01 10:30:00 | AAPL | Stock | 2.1671 | 2.1761 | 2.1671 | 2.1761 | 21021420.0 |
| 2006-06-01 10:35:00 | AAPL | Stock | 2.1761 | 2.1882 | 2.1757 | 2.1871 | 34382236.0 |
| 2006-06-01 10:40:00 | AAPL | Stock | 2.1871 | 2.1954 | 2.1861 | 2.1932 | 33354524.0 |
| 2006-06-01 10:45:00 | AAPL | Stock | 2.1932 | 2.1943 | 2.1886 | 2.19 | 24706640.0 |
| 2006-06-01 10:50:00 | AAPL | Stock | 2.19 | 2.1943 | 2.1861 | 2.1904 | 17136224.0 |
| 2006-06-01 10:55:00 | AAPL | Stock | 2.1904 | 2.1993 | 2.19 | 2.1968 | 19309024.0 |
| 2006-06-01 11:00:00 | AAPL | Stock | 2.1971 | 2.2046 | 2.1911 | 2.1996 | 20617632.0 |
| 2006-06-01 11:05:00 | AAPL | Stock | 2.2 | 2.2018 | 2.1957 | 2.1979 | 12032076.0 |
| 2006-06-01 11:10:00 | AAPL | Stock | 2.1982 | 2.2118 | 2.1982 | 2.2089 | 19555480.0 |
| 2006-06-01 11:15:00 | AAPL | Stock | 2.2089 | 2.2104 | 2.2032 | 2.2039 | 12840604.0 |
| 2006-06-01 11:20:00 | AAPL | Stock | 2.2036 | 2.2074 | 2.2025 | 2.205 | 13425664.0 |
| 2006-06-01 11:25:00 | AAPL | Stock | 2.2054 | 2.2086 | 2.2039 | 2.205 | 7728476.0 |
| 2006-06-01 11:30:00 | AAPL | Stock | 2.205 | 2.2136 | 2.2046 | 2.2129 | 13156724.0 |
| 2006-06-01 11:35:00 | AAPL | Stock | 2.2121 | 2.2128 | 2.2079 | 2.2089 | 12345508.0 |
| 2006-06-01 11:40:00 | AAPL | Stock | 2.2086 | 2.2096 | 2.2054 | 2.2096 | 10341884.0 |
| 2006-06-01 11:45:00 | AAPL | Stock | 2.2096 | 2.2104 | 2.2025 | 2.2043 | 6691692.0 |
| 2006-06-01 11:50:00 | AAPL | Stock | 2.2043 | 2.2075 | 2.2036 | 2.2043 | 5257308.0 |
| 2006-06-01 11:55:00 | AAPL | Stock | 2.2046 | 2.2061 | 2.2011 | 2.2046 | 9751644.0 |
| 2006-06-01 12:00:00 | AAPL | Stock | 2.2046 | 2.2082 | 2.2025 | 2.2036 | 7868308.0 |
> showing 50 of 229,864 rows — these rows as CSV