PREVIEW / stock_5min / 2008-06-24
file: by_date/stock_5min/2008/2008-06-24.parquet size: 4.5 MB rows: 318,409 symbols: 3,341
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-06-24 07:00:00 | AAPL | Stock | 6.15 | 6.15 | 6.1275 | 6.1389 | 11200.0 |
| 2008-06-24 07:15:00 | AAPL | Stock | 6.1243 | 6.1243 | 6.1243 | 6.1243 | 21308.0 |
| 2008-06-24 07:20:00 | AAPL | Stock | 6.1243 | 6.1243 | 6.1164 | 6.1164 | 12040.0 |
| 2008-06-24 07:25:00 | AAPL | Stock | 6.1164 | 6.1243 | 6.1164 | 6.1243 | 5880.0 |
| 2008-06-24 07:30:00 | AAPL | Stock | 6.1179 | 6.13 | 6.1179 | 6.13 | 63952.0 |
| 2008-06-24 07:35:00 | AAPL | Stock | 6.1286 | 6.1286 | 6.1286 | 6.1286 | 5600.0 |
| 2008-06-24 07:40:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1282 | 6.1282 | 14000.0 |
| 2008-06-24 07:50:00 | AAPL | Stock | 6.1346 | 6.135 | 6.1346 | 6.135 | 8400.0 |
| 2008-06-24 07:55:00 | AAPL | Stock | 6.135 | 6.1389 | 6.135 | 6.1389 | 15400.0 |
| 2008-06-24 08:00:00 | AAPL | Stock | 6.1336 | 6.1429 | 6.1286 | 6.1286 | 288932.0 |
| 2008-06-24 08:05:00 | AAPL | Stock | 6.1214 | 6.125 | 6.1179 | 6.125 | 111552.0 |
| 2008-06-24 08:10:00 | AAPL | Stock | 6.1318 | 6.1318 | 6.1196 | 6.1232 | 131600.0 |
| 2008-06-24 08:15:00 | AAPL | Stock | 6.1232 | 6.1311 | 6.1232 | 6.1311 | 58520.0 |
| 2008-06-24 08:20:00 | AAPL | Stock | 6.1289 | 6.1375 | 6.1289 | 6.1318 | 113288.0 |
| 2008-06-24 08:25:00 | AAPL | Stock | 6.1296 | 6.1389 | 6.1286 | 6.1357 | 108920.0 |
| 2008-06-24 08:30:00 | AAPL | Stock | 6.1361 | 6.1364 | 6.1357 | 6.1357 | 110040.0 |
| 2008-06-24 08:35:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1325 | 6.1339 | 30800.0 |
| 2008-06-24 08:40:00 | AAPL | Stock | 6.1325 | 6.1329 | 6.1307 | 6.1321 | 33600.0 |
| 2008-06-24 08:45:00 | AAPL | Stock | 6.1318 | 6.1414 | 6.1286 | 6.135 | 129220.0 |
| 2008-06-24 08:50:00 | AAPL | Stock | 6.1321 | 6.1357 | 6.1321 | 6.1325 | 38500.0 |
| 2008-06-24 08:55:00 | AAPL | Stock | 6.1321 | 6.135 | 6.1321 | 6.135 | 14000.0 |
| 2008-06-24 09:00:00 | AAPL | Stock | 6.1375 | 6.1393 | 6.1289 | 6.1289 | 127848.0 |
| 2008-06-24 09:05:00 | AAPL | Stock | 6.1286 | 6.1296 | 6.1236 | 6.1243 | 186284.0 |
| 2008-06-24 09:10:00 | AAPL | Stock | 6.1246 | 6.1357 | 6.1246 | 6.1357 | 183512.0 |
| 2008-06-24 09:15:00 | AAPL | Stock | 6.1357 | 6.1404 | 6.1293 | 6.1357 | 358960.0 |
| 2008-06-24 09:20:00 | AAPL | Stock | 6.13 | 6.1493 | 6.13 | 6.1479 | 207704.0 |
| 2008-06-24 09:25:00 | AAPL | Stock | 6.1496 | 6.1854 | 6.1432 | 6.1536 | 384020.0 |
| 2008-06-24 09:30:00 | AAPL | Stock | 6.1536 | 6.1786 | 6.1296 | 6.1736 | 17499104.0 |
| 2008-06-24 09:35:00 | AAPL | Stock | 6.1729 | 6.1893 | 6.1661 | 6.1868 | 14314552.0 |
| 2008-06-24 09:40:00 | AAPL | Stock | 6.1882 | 6.1982 | 6.1607 | 6.1743 | 13394304.0 |
| 2008-06-24 09:45:00 | AAPL | Stock | 6.1761 | 6.1843 | 6.1511 | 6.1807 | 9296252.0 |
| 2008-06-24 09:50:00 | AAPL | Stock | 6.1807 | 6.2029 | 6.1689 | 6.1943 | 12682124.0 |
| 2008-06-24 09:55:00 | AAPL | Stock | 6.1946 | 6.2107 | 6.1879 | 6.1946 | 9909116.0 |
| 2008-06-24 10:00:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1536 | 6.1886 | 18732924.0 |
| 2008-06-24 10:05:00 | AAPL | Stock | 6.1886 | 6.1971 | 6.1818 | 6.1879 | 10912328.0 |
| 2008-06-24 10:10:00 | AAPL | Stock | 6.1857 | 6.2104 | 6.1839 | 6.1982 | 12562200.0 |
| 2008-06-24 10:15:00 | AAPL | Stock | 6.1982 | 6.2025 | 6.1821 | 6.2 | 10251472.0 |
| 2008-06-24 10:20:00 | AAPL | Stock | 6.1996 | 6.2064 | 6.1611 | 6.1686 | 10645068.0 |
| 2008-06-24 10:25:00 | AAPL | Stock | 6.17 | 6.1854 | 6.1554 | 6.1811 | 7845404.0 |
| 2008-06-24 10:30:00 | AAPL | Stock | 6.1811 | 6.1925 | 6.1429 | 6.1504 | 12161576.0 |
| 2008-06-24 10:35:00 | AAPL | Stock | 6.1504 | 6.1761 | 6.1429 | 6.1613 | 10169488.0 |
| 2008-06-24 10:40:00 | AAPL | Stock | 6.1613 | 6.1671 | 6.1457 | 6.1625 | 8550360.0 |
| 2008-06-24 10:45:00 | AAPL | Stock | 6.1629 | 6.1885 | 6.1589 | 6.1818 | 10626168.0 |
| 2008-06-24 10:50:00 | AAPL | Stock | 6.1811 | 6.1882 | 6.1743 | 6.1848 | 6278720.0 |
| 2008-06-24 10:55:00 | AAPL | Stock | 6.1854 | 6.2321 | 6.1854 | 6.2155 | 14675752.0 |
| 2008-06-24 11:00:00 | AAPL | Stock | 6.2182 | 6.2321 | 6.2161 | 6.2218 | 11234636.0 |
| 2008-06-24 11:05:00 | AAPL | Stock | 6.2229 | 6.2279 | 6.2075 | 6.2189 | 7372736.0 |
| 2008-06-24 11:10:00 | AAPL | Stock | 6.2182 | 6.2204 | 6.2039 | 6.2179 | 5768812.0 |
| 2008-06-24 11:15:00 | AAPL | Stock | 6.2175 | 6.2557 | 6.2175 | 6.2529 | 14203672.0 |
| 2008-06-24 11:20:00 | AAPL | Stock | 6.2529 | 6.2586 | 6.2375 | 6.24 | 7617960.0 |
> showing 50 of 318,409 rows — these rows as CSV