PREVIEW / stock_5min / 2009-09-14
file: by_date/stock_5min/2009/2009-09-14.parquet size: 4.6 MB rows: 316,429 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-09-14 07:00:00 | AAPL | Stock | 6.1036 | 6.1143 | 6.1036 | 6.1143 | 11200.0 |
| 2009-09-14 07:20:00 | AAPL | Stock | 6.1064 | 6.1079 | 6.1064 | 6.1071 | 12880.0 |
| 2009-09-14 07:25:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.1071 | 6.1071 | 16800.0 |
| 2009-09-14 07:30:00 | AAPL | Stock | 6.0993 | 6.0993 | 6.0982 | 6.0982 | 5600.0 |
| 2009-09-14 07:35:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1054 | 6.1054 | 5600.0 |
| 2009-09-14 07:50:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1054 | 6.1054 | 2800.0 |
| 2009-09-14 08:00:00 | AAPL | Stock | 6.1054 | 6.1143 | 6.1007 | 6.1104 | 105476.0 |
| 2009-09-14 08:05:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 5600.0 |
| 2009-09-14 08:10:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2009-09-14 08:15:00 | AAPL | Stock | 6.105 | 6.1071 | 6.1036 | 6.1071 | 16800.0 |
| 2009-09-14 08:20:00 | AAPL | Stock | 6.1079 | 6.1086 | 6.1071 | 6.1071 | 19600.0 |
| 2009-09-14 08:25:00 | AAPL | Stock | 6.1064 | 6.1154 | 6.1064 | 6.1154 | 39676.0 |
| 2009-09-14 08:30:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 5600.0 |
| 2009-09-14 08:40:00 | AAPL | Stock | 6.1089 | 6.1107 | 6.1089 | 6.1107 | 44128.0 |
| 2009-09-14 08:45:00 | AAPL | Stock | 6.1079 | 6.1079 | 6.1079 | 6.1079 | 2800.0 |
| 2009-09-14 08:50:00 | AAPL | Stock | 6.1089 | 6.1107 | 6.1089 | 6.1107 | 49756.0 |
| 2009-09-14 08:55:00 | AAPL | Stock | 6.1107 | 6.1136 | 6.1107 | 6.1136 | 56588.0 |
| 2009-09-14 09:00:00 | AAPL | Stock | 6.1143 | 6.1154 | 6.1125 | 6.1154 | 18116.0 |
| 2009-09-14 09:05:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1089 | 6.1093 | 25200.0 |
| 2009-09-14 09:10:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1039 | 6.1039 | 56280.0 |
| 2009-09-14 09:15:00 | AAPL | Stock | 6.1082 | 6.1136 | 6.1082 | 6.11 | 57176.0 |
| 2009-09-14 09:20:00 | AAPL | Stock | 6.11 | 6.115 | 6.11 | 6.115 | 85288.0 |
| 2009-09-14 09:25:00 | AAPL | Stock | 6.1143 | 6.1154 | 6.0982 | 6.1021 | 355264.0 |
| 2009-09-14 09:30:00 | AAPL | Stock | 6.105 | 6.1245 | 6.0954 | 6.1189 | 9832032.0 |
| 2009-09-14 09:35:00 | AAPL | Stock | 6.1186 | 6.1239 | 6.0804 | 6.0864 | 9931768.0 |
| 2009-09-14 09:40:00 | AAPL | Stock | 6.0814 | 6.1179 | 6.0814 | 6.1118 | 10317020.0 |
| 2009-09-14 09:45:00 | AAPL | Stock | 6.1121 | 6.1286 | 6.0964 | 6.0968 | 7416696.0 |
| 2009-09-14 09:50:00 | AAPL | Stock | 6.0964 | 6.1157 | 6.0904 | 6.1125 | 5764080.0 |
| 2009-09-14 09:55:00 | AAPL | Stock | 6.1111 | 6.1307 | 6.1086 | 6.1243 | 4576600.0 |
| 2009-09-14 10:00:00 | AAPL | Stock | 6.1232 | 6.1293 | 6.1179 | 6.1184 | 3445568.0 |
| 2009-09-14 10:05:00 | AAPL | Stock | 6.1179 | 6.1339 | 6.1171 | 6.1314 | 3978912.0 |
| 2009-09-14 10:10:00 | AAPL | Stock | 6.1307 | 6.1329 | 6.1218 | 6.1232 | 3781624.0 |
| 2009-09-14 10:15:00 | AAPL | Stock | 6.1225 | 6.142 | 6.1221 | 6.1357 | 5282256.0 |
| 2009-09-14 10:20:00 | AAPL | Stock | 6.1357 | 6.1607 | 6.1332 | 6.1579 | 9188172.0 |
| 2009-09-14 10:25:00 | AAPL | Stock | 6.1579 | 6.1639 | 6.1536 | 6.1614 | 6421352.0 |
| 2009-09-14 10:30:00 | AAPL | Stock | 6.1614 | 6.175 | 6.1607 | 6.1654 | 5398596.0 |
| 2009-09-14 10:35:00 | AAPL | Stock | 6.1652 | 6.17 | 6.1636 | 6.1661 | 3870076.0 |
| 2009-09-14 10:40:00 | AAPL | Stock | 6.1664 | 6.1696 | 6.1582 | 6.1668 | 3035620.0 |
| 2009-09-14 10:45:00 | AAPL | Stock | 6.1675 | 6.1768 | 6.1664 | 6.1743 | 4319028.0 |
| 2009-09-14 10:50:00 | AAPL | Stock | 6.1743 | 6.1761 | 6.1675 | 6.1693 | 3567620.0 |
| 2009-09-14 10:55:00 | AAPL | Stock | 6.1693 | 6.1725 | 6.1629 | 6.1704 | 4544176.0 |
| 2009-09-14 11:00:00 | AAPL | Stock | 6.1704 | 6.175 | 6.1668 | 6.1729 | 3324412.0 |
| 2009-09-14 11:05:00 | AAPL | Stock | 6.1729 | 6.175 | 6.1643 | 6.1689 | 2237928.0 |
| 2009-09-14 11:10:00 | AAPL | Stock | 6.1689 | 6.1689 | 6.1607 | 6.1629 | 2450420.0 |
| 2009-09-14 11:15:00 | AAPL | Stock | 6.1636 | 6.1775 | 6.1629 | 6.1748 | 2856308.0 |
| 2009-09-14 11:20:00 | AAPL | Stock | 6.1756 | 6.1786 | 6.1736 | 6.175 | 3806796.0 |
| 2009-09-14 11:25:00 | AAPL | Stock | 6.1746 | 6.1768 | 6.1718 | 6.175 | 2485112.0 |
| 2009-09-14 11:30:00 | AAPL | Stock | 6.175 | 6.1779 | 6.1721 | 6.1736 | 2321284.0 |
| 2009-09-14 11:35:00 | AAPL | Stock | 6.1736 | 6.1757 | 6.1714 | 6.1732 | 1165640.0 |
| 2009-09-14 11:40:00 | AAPL | Stock | 6.1736 | 6.1736 | 6.1654 | 6.1654 | 2050972.0 |
> showing 50 of 316,429 rows — these rows as CSV