PREVIEW / stock_5min / 2009-02-24
file: by_date/stock_5min/2009/2009-02-24.parquet size: 4.6 MB rows: 317,519 symbols: 3,356
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-24 06:40:00 | AAPL | Stock | 3.1118 | 3.1118 | 3.1118 | 3.1118 | 2800.0 |
| 2009-02-24 07:10:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 5600.0 |
| 2009-02-24 07:20:00 | AAPL | Stock | 3.1043 | 3.1043 | 3.0971 | 3.0971 | 72800.0 |
| 2009-02-24 07:25:00 | AAPL | Stock | 3.0857 | 3.0857 | 3.0857 | 3.0857 | 14000.0 |
| 2009-02-24 07:30:00 | AAPL | Stock | 3.0861 | 3.0861 | 3.0675 | 3.0675 | 76720.0 |
| 2009-02-24 07:35:00 | AAPL | Stock | 3.0704 | 3.0704 | 3.0543 | 3.0543 | 5600.0 |
| 2009-02-24 07:40:00 | AAPL | Stock | 3.0625 | 3.0661 | 3.0443 | 3.0443 | 67200.0 |
| 2009-02-24 07:45:00 | AAPL | Stock | 3.0496 | 3.0625 | 3.0496 | 3.0625 | 16800.0 |
| 2009-02-24 07:50:00 | AAPL | Stock | 3.0625 | 3.0711 | 3.0489 | 3.0707 | 22400.0 |
| 2009-02-24 07:55:00 | AAPL | Stock | 3.0707 | 3.0761 | 3.0707 | 3.0761 | 9520.0 |
| 2009-02-24 08:00:00 | AAPL | Stock | 3.0746 | 3.0875 | 3.0746 | 3.0807 | 63896.0 |
| 2009-02-24 08:05:00 | AAPL | Stock | 3.0807 | 3.1125 | 3.0804 | 3.0839 | 309988.0 |
| 2009-02-24 08:10:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0875 | 3.0875 | 2800.0 |
| 2009-02-24 08:15:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0825 | 3.0871 | 19600.0 |
| 2009-02-24 08:20:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0893 | 3.0893 | 32144.0 |
| 2009-02-24 08:25:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0893 | 3.0893 | 68936.0 |
| 2009-02-24 08:30:00 | AAPL | Stock | 3.0896 | 3.1 | 3.0893 | 3.0968 | 247800.0 |
| 2009-02-24 08:35:00 | AAPL | Stock | 3.0939 | 3.1214 | 3.0896 | 3.1214 | 173768.0 |
| 2009-02-24 08:40:00 | AAPL | Stock | 3.1071 | 3.1161 | 3.1032 | 3.1032 | 523600.0 |
| 2009-02-24 08:45:00 | AAPL | Stock | 3.1036 | 3.1036 | 3.1 | 3.1036 | 180320.0 |
| 2009-02-24 08:50:00 | AAPL | Stock | 3.1046 | 3.1146 | 3.1046 | 3.1125 | 397824.0 |
| 2009-02-24 08:55:00 | AAPL | Stock | 3.1129 | 3.1161 | 3.1125 | 3.1125 | 103600.0 |
| 2009-02-24 09:00:00 | AAPL | Stock | 3.1125 | 3.15 | 3.1107 | 3.1429 | 633192.0 |
| 2009-02-24 09:05:00 | AAPL | Stock | 3.1436 | 3.1436 | 3.1321 | 3.1389 | 492800.0 |
| 2009-02-24 09:10:00 | AAPL | Stock | 3.1375 | 3.1425 | 3.1343 | 3.1343 | 238000.0 |
| 2009-02-24 09:15:00 | AAPL | Stock | 3.1336 | 3.1343 | 3.1293 | 3.1293 | 165060.0 |
| 2009-02-24 09:20:00 | AAPL | Stock | 3.1289 | 3.1318 | 3.1246 | 3.125 | 653604.0 |
| 2009-02-24 09:25:00 | AAPL | Stock | 3.125 | 3.1275 | 3.1179 | 3.1236 | 370440.0 |
| 2009-02-24 09:30:00 | AAPL | Stock | 3.1229 | 3.1546 | 3.1071 | 3.1536 | 20629000.0 |
| 2009-02-24 09:35:00 | AAPL | Stock | 3.1536 | 3.1704 | 3.1429 | 3.1638 | 18459168.0 |
| 2009-02-24 09:40:00 | AAPL | Stock | 3.1639 | 3.1696 | 3.1521 | 3.1525 | 15485652.0 |
| 2009-02-24 09:45:00 | AAPL | Stock | 3.1525 | 3.1575 | 3.1393 | 3.1482 | 15143632.0 |
| 2009-02-24 09:50:00 | AAPL | Stock | 3.1489 | 3.1593 | 3.1479 | 3.1504 | 9543828.0 |
| 2009-02-24 09:55:00 | AAPL | Stock | 3.1511 | 3.1536 | 3.1429 | 3.1439 | 8495172.0 |
| 2009-02-24 10:00:00 | AAPL | Stock | 3.1429 | 3.1536 | 3.1293 | 3.1439 | 15091216.0 |
| 2009-02-24 10:05:00 | AAPL | Stock | 3.1432 | 3.1575 | 3.1386 | 3.1554 | 8749468.0 |
| 2009-02-24 10:10:00 | AAPL | Stock | 3.1554 | 3.1607 | 3.1464 | 3.1489 | 8120700.0 |
| 2009-02-24 10:15:00 | AAPL | Stock | 3.1489 | 3.1575 | 3.1361 | 3.1571 | 9675484.0 |
| 2009-02-24 10:20:00 | AAPL | Stock | 3.1566 | 3.1664 | 3.1496 | 3.1664 | 8189160.0 |
| 2009-02-24 10:25:00 | AAPL | Stock | 3.1661 | 3.1786 | 3.1593 | 3.1729 | 13142724.0 |
| 2009-02-24 10:30:00 | AAPL | Stock | 3.1732 | 3.1886 | 3.1704 | 3.1875 | 15998836.0 |
| 2009-02-24 10:35:00 | AAPL | Stock | 3.1882 | 3.1918 | 3.1779 | 3.1794 | 9366504.0 |
| 2009-02-24 10:40:00 | AAPL | Stock | 3.18 | 3.18 | 3.1646 | 3.1664 | 10553984.0 |
| 2009-02-24 10:45:00 | AAPL | Stock | 3.1664 | 3.1964 | 3.1664 | 3.1964 | 12982284.0 |
| 2009-02-24 10:50:00 | AAPL | Stock | 3.1964 | 3.1971 | 3.1757 | 3.1782 | 10590412.0 |
| 2009-02-24 10:55:00 | AAPL | Stock | 3.1779 | 3.185 | 3.1718 | 3.1779 | 11194764.0 |
| 2009-02-24 11:00:00 | AAPL | Stock | 3.1771 | 3.185 | 3.1743 | 3.1782 | 6570704.0 |
| 2009-02-24 11:05:00 | AAPL | Stock | 3.1786 | 3.1854 | 3.1664 | 3.1665 | 7339444.0 |
| 2009-02-24 11:10:00 | AAPL | Stock | 3.1661 | 3.1732 | 3.1639 | 3.1711 | 9094680.0 |
| 2009-02-24 11:15:00 | AAPL | Stock | 3.1714 | 3.1736 | 3.155 | 3.1568 | 9249296.0 |
> showing 50 of 317,519 rows — these rows as CSV