PREVIEW / stock_5min / 2006-07-20
file: by_date/stock_5min/2006/2006-07-20.parquet size: 3.1 MB rows: 223,259 symbols: 2,302
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-07-20 04:15:00 | AAPL | Stock | 2.1071 | 2.1071 | 2.1071 | 2.1071 | 14000.0 |
| 2006-07-20 04:55:00 | AAPL | Stock | 2.1214 | 2.1214 | 2.1214 | 2.1214 | 2800.0 |
| 2006-07-20 05:25:00 | AAPL | Stock | 2.1218 | 2.1218 | 2.1218 | 2.1218 | 28000.0 |
| 2006-07-20 05:55:00 | AAPL | Stock | 2.1164 | 2.1164 | 2.1071 | 2.1125 | 98000.0 |
| 2006-07-20 06:10:00 | AAPL | Stock | 2.125 | 2.125 | 2.125 | 2.125 | 16800.0 |
| 2006-07-20 06:20:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 25228.0 |
| 2006-07-20 06:40:00 | AAPL | Stock | 2.1232 | 2.1246 | 2.1229 | 2.1232 | 41972.0 |
| 2006-07-20 06:50:00 | AAPL | Stock | 2.1264 | 2.1264 | 2.1264 | 2.1264 | 2800.0 |
| 2006-07-20 07:00:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 95200.0 |
| 2006-07-20 07:05:00 | AAPL | Stock | 2.1232 | 2.1232 | 2.1232 | 2.1232 | 10080.0 |
| 2006-07-20 07:10:00 | AAPL | Stock | 2.1179 | 2.1179 | 2.1179 | 2.1179 | 14000.0 |
| 2006-07-20 07:20:00 | AAPL | Stock | 2.1286 | 2.1329 | 2.125 | 2.1329 | 184660.0 |
| 2006-07-20 07:25:00 | AAPL | Stock | 2.1329 | 2.1389 | 2.1329 | 2.135 | 92568.0 |
| 2006-07-20 07:30:00 | AAPL | Stock | 2.1339 | 2.1396 | 2.1304 | 2.1304 | 228900.0 |
| 2006-07-20 07:35:00 | AAPL | Stock | 2.1304 | 2.1339 | 2.1304 | 2.1321 | 212240.0 |
| 2006-07-20 07:40:00 | AAPL | Stock | 2.1304 | 2.1339 | 2.1304 | 2.1339 | 106428.0 |
| 2006-07-20 07:45:00 | AAPL | Stock | 2.1339 | 2.1389 | 2.1339 | 2.1375 | 378840.0 |
| 2006-07-20 07:50:00 | AAPL | Stock | 2.1375 | 2.1482 | 2.1357 | 2.1357 | 1015336.0 |
| 2006-07-20 07:55:00 | AAPL | Stock | 2.1411 | 2.1464 | 2.1411 | 2.1439 | 141400.0 |
| 2006-07-20 08:00:00 | AAPL | Stock | 2.1436 | 2.1721 | 2.1275 | 2.1711 | 11837392.0 |
| 2006-07-20 08:05:00 | AAPL | Stock | 2.1714 | 2.1718 | 2.1607 | 2.1696 | 5350604.0 |
| 2006-07-20 08:10:00 | AAPL | Stock | 2.1686 | 2.1764 | 2.1661 | 2.1732 | 7792512.0 |
| 2006-07-20 08:15:00 | AAPL | Stock | 2.1732 | 2.18 | 2.1718 | 2.1779 | 7258636.0 |
| 2006-07-20 08:20:00 | AAPL | Stock | 2.1779 | 2.1821 | 2.1721 | 2.1732 | 4736480.0 |
| 2006-07-20 08:25:00 | AAPL | Stock | 2.1736 | 2.1814 | 2.1721 | 2.1725 | 4930408.0 |
| 2006-07-20 08:30:00 | AAPL | Stock | 2.1732 | 2.1804 | 2.1679 | 2.18 | 5210324.0 |
| 2006-07-20 08:35:00 | AAPL | Stock | 2.18 | 2.185 | 2.1786 | 2.1807 | 6240388.0 |
| 2006-07-20 08:40:00 | AAPL | Stock | 2.1807 | 2.1807 | 2.1675 | 2.1693 | 5441772.0 |
| 2006-07-20 08:45:00 | AAPL | Stock | 2.1682 | 2.1746 | 2.1646 | 2.1732 | 2438688.0 |
| 2006-07-20 08:50:00 | AAPL | Stock | 2.1714 | 2.1779 | 2.1714 | 2.1779 | 4039672.0 |
| 2006-07-20 08:55:00 | AAPL | Stock | 2.1779 | 2.1818 | 2.1714 | 2.1757 | 4331208.0 |
| 2006-07-20 09:00:00 | AAPL | Stock | 2.1757 | 2.1782 | 2.1693 | 2.1768 | 2167592.0 |
| 2006-07-20 09:05:00 | AAPL | Stock | 2.1761 | 2.1875 | 2.175 | 2.1839 | 4266136.0 |
| 2006-07-20 09:10:00 | AAPL | Stock | 2.185 | 2.1875 | 2.1764 | 2.1789 | 6261472.0 |
| 2006-07-20 09:15:00 | AAPL | Stock | 2.1786 | 2.1811 | 2.175 | 2.1793 | 7834232.0 |
| 2006-07-20 09:20:00 | AAPL | Stock | 2.1779 | 2.1818 | 2.1775 | 2.1807 | 3404604.0 |
| 2006-07-20 09:25:00 | AAPL | Stock | 2.1804 | 2.185 | 2.1679 | 2.1771 | 10472140.0 |
| 2006-07-20 09:30:00 | AAPL | Stock | 2.1771 | 2.1846 | 2.1689 | 2.1775 | 137223520.0 |
| 2006-07-20 09:35:00 | AAPL | Stock | 2.1774 | 2.1807 | 2.1625 | 2.1696 | 67885692.0 |
| 2006-07-20 09:40:00 | AAPL | Stock | 2.1696 | 2.1708 | 2.1486 | 2.1514 | 80318924.0 |
| 2006-07-20 09:45:00 | AAPL | Stock | 2.1514 | 2.1679 | 2.1489 | 2.1671 | 57511720.0 |
| 2006-07-20 09:50:00 | AAPL | Stock | 2.1671 | 2.1693 | 2.1511 | 2.1564 | 50525244.0 |
| 2006-07-20 09:55:00 | AAPL | Stock | 2.1571 | 2.16 | 2.1443 | 2.1475 | 42558376.0 |
| 2006-07-20 10:00:00 | AAPL | Stock | 2.1475 | 2.1643 | 2.1336 | 2.1357 | 65723896.0 |
| 2006-07-20 10:05:00 | AAPL | Stock | 2.1357 | 2.1693 | 2.1329 | 2.1393 | 46369260.0 |
| 2006-07-20 10:10:00 | AAPL | Stock | 2.1393 | 2.1493 | 2.1379 | 2.1482 | 36043448.0 |
| 2006-07-20 10:15:00 | AAPL | Stock | 2.1482 | 2.1511 | 2.1439 | 2.1507 | 25711644.0 |
| 2006-07-20 10:20:00 | AAPL | Stock | 2.1511 | 2.1554 | 2.1464 | 2.1525 | 33812716.0 |
| 2006-07-20 10:25:00 | AAPL | Stock | 2.1529 | 2.1571 | 2.1482 | 2.1539 | 30099860.0 |
| 2006-07-20 10:30:00 | AAPL | Stock | 2.1539 | 2.155 | 2.1482 | 2.1507 | 17010952.0 |
> showing 50 of 223,259 rows — these rows as CSV