PREVIEW / stock_5min / 2008-09-02
file: by_date/stock_5min/2008/2008-09-02.parquet size: 4.5 MB rows: 315,187 symbols: 3,324
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-09-02 04:25:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 11228.0 |
| 2008-09-02 04:30:00 | AAPL | Stock | 6.1507 | 6.1536 | 6.1507 | 6.1536 | 13720.0 |
| 2008-09-02 07:00:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2008-09-02 07:05:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 5600.0 |
| 2008-09-02 07:10:00 | AAPL | Stock | 6.1407 | 6.1411 | 6.1407 | 6.1411 | 42280.0 |
| 2008-09-02 07:15:00 | AAPL | Stock | 6.1407 | 6.1425 | 6.1407 | 6.1425 | 13720.0 |
| 2008-09-02 07:20:00 | AAPL | Stock | 6.1425 | 6.1429 | 6.1425 | 6.1429 | 34524.0 |
| 2008-09-02 07:25:00 | AAPL | Stock | 6.1443 | 6.1443 | 6.1357 | 6.1357 | 23660.0 |
| 2008-09-02 07:30:00 | AAPL | Stock | 6.1532 | 6.1536 | 6.1532 | 6.1532 | 98000.0 |
| 2008-09-02 07:35:00 | AAPL | Stock | 6.1379 | 6.1379 | 6.1357 | 6.1357 | 168000.0 |
| 2008-09-02 07:40:00 | AAPL | Stock | 6.1357 | 6.15 | 6.1336 | 6.1357 | 366520.0 |
| 2008-09-02 07:50:00 | AAPL | Stock | 6.1286 | 6.1418 | 6.1286 | 6.1418 | 36400.0 |
| 2008-09-02 07:55:00 | AAPL | Stock | 6.1425 | 6.1425 | 6.125 | 6.1321 | 135240.0 |
| 2008-09-02 08:00:00 | AAPL | Stock | 6.13 | 6.1375 | 6.1204 | 6.1332 | 455448.0 |
| 2008-09-02 08:05:00 | AAPL | Stock | 6.1332 | 6.1536 | 6.1325 | 6.1496 | 789180.0 |
| 2008-09-02 08:10:00 | AAPL | Stock | 6.1496 | 6.1536 | 6.1443 | 6.15 | 398776.0 |
| 2008-09-02 08:15:00 | AAPL | Stock | 6.1496 | 6.1511 | 6.1418 | 6.1482 | 563360.0 |
| 2008-09-02 08:20:00 | AAPL | Stock | 6.1482 | 6.1561 | 6.1429 | 6.1429 | 493780.0 |
| 2008-09-02 08:25:00 | AAPL | Stock | 6.1446 | 6.1446 | 6.1357 | 6.1375 | 234304.0 |
| 2008-09-02 08:30:00 | AAPL | Stock | 6.1346 | 6.1421 | 6.1321 | 6.1329 | 146160.0 |
| 2008-09-02 08:35:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1286 | 6.1304 | 265664.0 |
| 2008-09-02 08:40:00 | AAPL | Stock | 6.1364 | 6.1393 | 6.1321 | 6.1375 | 84420.0 |
| 2008-09-02 08:45:00 | AAPL | Stock | 6.1425 | 6.1471 | 6.1393 | 6.14 | 130480.0 |
| 2008-09-02 08:50:00 | AAPL | Stock | 6.14 | 6.1411 | 6.1354 | 6.1357 | 1061088.0 |
| 2008-09-02 08:55:00 | AAPL | Stock | 6.1325 | 6.1357 | 6.1321 | 6.1321 | 213220.0 |
| 2008-09-02 09:00:00 | AAPL | Stock | 6.1321 | 6.1379 | 6.1321 | 6.1379 | 1059128.0 |
| 2008-09-02 09:05:00 | AAPL | Stock | 6.1364 | 6.1479 | 6.1357 | 6.1479 | 644532.0 |
| 2008-09-02 09:10:00 | AAPL | Stock | 6.1479 | 6.1589 | 6.1479 | 6.1589 | 1039024.0 |
| 2008-09-02 09:15:00 | AAPL | Stock | 6.1571 | 6.1571 | 6.15 | 6.1518 | 135184.0 |
| 2008-09-02 09:20:00 | AAPL | Stock | 6.1504 | 6.1525 | 6.1421 | 6.1429 | 238420.0 |
| 2008-09-02 09:25:00 | AAPL | Stock | 6.1418 | 6.1707 | 6.1407 | 6.1636 | 1504496.0 |
| 2008-09-02 09:30:00 | AAPL | Stock | 6.1611 | 6.1714 | 6.1343 | 6.1525 | 26205284.0 |
| 2008-09-02 09:35:00 | AAPL | Stock | 6.1489 | 6.17 | 6.1375 | 6.1604 | 18529812.0 |
| 2008-09-02 09:40:00 | AAPL | Stock | 6.1589 | 6.1889 | 6.1525 | 6.18 | 19366256.0 |
| 2008-09-02 09:45:00 | AAPL | Stock | 6.1791 | 6.1964 | 6.1786 | 6.1846 | 14897848.0 |
| 2008-09-02 09:50:00 | AAPL | Stock | 6.1854 | 6.1879 | 6.175 | 6.1786 | 11536588.0 |
| 2008-09-02 09:55:00 | AAPL | Stock | 6.1786 | 6.1893 | 6.1704 | 6.1782 | 10398500.0 |
| 2008-09-02 10:00:00 | AAPL | Stock | 6.1782 | 6.185 | 6.1675 | 6.1793 | 10821776.0 |
| 2008-09-02 10:05:00 | AAPL | Stock | 6.1786 | 6.1811 | 6.1679 | 6.1714 | 7925344.0 |
| 2008-09-02 10:10:00 | AAPL | Stock | 6.1718 | 6.1736 | 6.1568 | 6.1632 | 9662660.0 |
| 2008-09-02 10:15:00 | AAPL | Stock | 6.1636 | 6.1661 | 6.1521 | 6.1557 | 7719320.0 |
| 2008-09-02 10:20:00 | AAPL | Stock | 6.1568 | 6.1589 | 6.1429 | 6.1504 | 10117100.0 |
| 2008-09-02 10:25:00 | AAPL | Stock | 6.1504 | 6.1643 | 6.1482 | 6.1636 | 6602848.0 |
| 2008-09-02 10:30:00 | AAPL | Stock | 6.1639 | 6.1668 | 6.1582 | 6.16 | 6505268.0 |
| 2008-09-02 10:35:00 | AAPL | Stock | 6.1593 | 6.16 | 6.1489 | 6.1511 | 5009648.0 |
| 2008-09-02 10:40:00 | AAPL | Stock | 6.1511 | 6.1525 | 6.1339 | 6.1346 | 7630616.0 |
| 2008-09-02 10:45:00 | AAPL | Stock | 6.1342 | 6.1429 | 6.1268 | 6.1418 | 9651012.0 |
| 2008-09-02 10:50:00 | AAPL | Stock | 6.142 | 6.1489 | 6.1404 | 6.1421 | 4880736.0 |
| 2008-09-02 10:55:00 | AAPL | Stock | 6.1425 | 6.1479 | 6.1339 | 6.1454 | 5283768.0 |
| 2008-09-02 11:00:00 | AAPL | Stock | 6.145 | 6.1464 | 6.1404 | 6.1407 | 2797984.0 |
> showing 50 of 315,187 rows — these rows as CSV