PREVIEW / stock_5min / 2007-12-27
file: by_date/stock_5min/2007/2007-12-27.parquet size: 4.3 MB rows: 322,810 symbols: 3,260
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-27 04:20:00 | AAPL | Stock | 7.0982 | 7.0982 | 7.0982 | 7.0982 | 2800.0 |
| 2007-12-27 07:00:00 | AAPL | Stock | 7.1179 | 7.1254 | 7.1179 | 7.1254 | 8400.0 |
| 2007-12-27 07:15:00 | AAPL | Stock | 7.1214 | 7.1214 | 7.1214 | 7.1214 | 5320.0 |
| 2007-12-27 07:20:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 5600.0 |
| 2007-12-27 07:25:00 | AAPL | Stock | 7.125 | 7.1339 | 7.125 | 7.1339 | 69412.0 |
| 2007-12-27 07:30:00 | AAPL | Stock | 7.1357 | 7.1429 | 7.1304 | 7.1429 | 107800.0 |
| 2007-12-27 07:35:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1289 | 7.1289 | 43400.0 |
| 2007-12-27 07:40:00 | AAPL | Stock | 7.1254 | 7.1275 | 7.1214 | 7.1275 | 20580.0 |
| 2007-12-27 07:45:00 | AAPL | Stock | 7.1279 | 7.1286 | 7.1279 | 7.1286 | 30800.0 |
| 2007-12-27 07:55:00 | AAPL | Stock | 7.1268 | 7.1268 | 7.1268 | 7.1268 | 14000.0 |
| 2007-12-27 08:00:00 | AAPL | Stock | 7.1268 | 7.1475 | 7.1268 | 7.1339 | 986972.0 |
| 2007-12-27 08:05:00 | AAPL | Stock | 7.1361 | 7.1393 | 7.1321 | 7.1364 | 259560.0 |
| 2007-12-27 08:10:00 | AAPL | Stock | 7.1339 | 7.1354 | 7.1304 | 7.1304 | 325248.0 |
| 2007-12-27 08:15:00 | AAPL | Stock | 7.1286 | 7.1336 | 7.1071 | 7.1275 | 289352.0 |
| 2007-12-27 08:20:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1164 | 7.1286 | 250180.0 |
| 2007-12-27 08:25:00 | AAPL | Stock | 7.125 | 7.1318 | 7.1146 | 7.1179 | 415240.0 |
| 2007-12-27 08:30:00 | AAPL | Stock | 7.1179 | 7.1196 | 7.1 | 7.1007 | 1018304.0 |
| 2007-12-27 08:35:00 | AAPL | Stock | 7.1007 | 7.1071 | 7.0804 | 7.1032 | 512008.0 |
| 2007-12-27 08:40:00 | AAPL | Stock | 7.1 | 7.1 | 7.0846 | 7.0846 | 250684.0 |
| 2007-12-27 08:45:00 | AAPL | Stock | 7.0925 | 7.1054 | 7.0814 | 7.1054 | 402136.0 |
| 2007-12-27 08:50:00 | AAPL | Stock | 7.1025 | 7.1068 | 7.1 | 7.1054 | 166292.0 |
| 2007-12-27 08:55:00 | AAPL | Stock | 7.1046 | 7.1211 | 7.1046 | 7.1204 | 500080.0 |
| 2007-12-27 09:00:00 | AAPL | Stock | 7.1204 | 7.1221 | 7.1089 | 7.1107 | 877380.0 |
| 2007-12-27 09:05:00 | AAPL | Stock | 7.1086 | 7.1111 | 7.1036 | 7.105 | 369264.0 |
| 2007-12-27 09:10:00 | AAPL | Stock | 7.1054 | 7.11 | 7.1054 | 7.1068 | 131292.0 |
| 2007-12-27 09:15:00 | AAPL | Stock | 7.1068 | 7.1075 | 7.1054 | 7.1068 | 109536.0 |
| 2007-12-27 09:20:00 | AAPL | Stock | 7.1054 | 7.1054 | 7.0986 | 7.0989 | 226828.0 |
| 2007-12-27 09:25:00 | AAPL | Stock | 7.0986 | 7.1075 | 7.0964 | 7.1068 | 175980.0 |
| 2007-12-27 09:30:00 | AAPL | Stock | 7.1054 | 7.1364 | 7.0896 | 7.1239 | 21364616.0 |
| 2007-12-27 09:35:00 | AAPL | Stock | 7.1236 | 7.1239 | 7.09 | 7.116 | 16039940.0 |
| 2007-12-27 09:40:00 | AAPL | Stock | 7.1154 | 7.1568 | 7.1125 | 7.1546 | 18975824.0 |
| 2007-12-27 09:45:00 | AAPL | Stock | 7.1539 | 7.1757 | 7.1461 | 7.1568 | 22878716.0 |
| 2007-12-27 09:50:00 | AAPL | Stock | 7.1575 | 7.1661 | 7.1496 | 7.1529 | 10238312.0 |
| 2007-12-27 09:55:00 | AAPL | Stock | 7.1536 | 7.155 | 7.1364 | 7.1404 | 14574056.0 |
| 2007-12-27 10:00:00 | AAPL | Stock | 7.1407 | 7.1568 | 7.1393 | 7.1504 | 11015788.0 |
| 2007-12-27 10:05:00 | AAPL | Stock | 7.1496 | 7.1736 | 7.1436 | 7.1707 | 12755708.0 |
| 2007-12-27 10:10:00 | AAPL | Stock | 7.1707 | 7.2282 | 7.1693 | 7.2189 | 39801916.0 |
| 2007-12-27 10:15:00 | AAPL | Stock | 7.2189 | 7.2486 | 7.1996 | 7.225 | 32117232.0 |
| 2007-12-27 10:20:00 | AAPL | Stock | 7.2254 | 7.2461 | 7.2229 | 7.2332 | 15272684.0 |
| 2007-12-27 10:25:00 | AAPL | Stock | 7.2329 | 7.2479 | 7.225 | 7.2271 | 13090616.0 |
| 2007-12-27 10:30:00 | AAPL | Stock | 7.2268 | 7.2446 | 7.22 | 7.2329 | 10069220.0 |
| 2007-12-27 10:35:00 | AAPL | Stock | 7.2329 | 7.2418 | 7.2004 | 7.2036 | 13093752.0 |
| 2007-12-27 10:40:00 | AAPL | Stock | 7.2036 | 7.2179 | 7.2011 | 7.2125 | 13594700.0 |
| 2007-12-27 10:45:00 | AAPL | Stock | 7.2136 | 7.2243 | 7.2054 | 7.215 | 8747704.0 |
| 2007-12-27 10:50:00 | AAPL | Stock | 7.2146 | 7.2293 | 7.2093 | 7.2166 | 9431828.0 |
| 2007-12-27 10:55:00 | AAPL | Stock | 7.2161 | 7.2165 | 7.19 | 7.1918 | 10927840.0 |
| 2007-12-27 11:00:00 | AAPL | Stock | 7.1925 | 7.2043 | 7.1811 | 7.1889 | 11049024.0 |
| 2007-12-27 11:05:00 | AAPL | Stock | 7.1882 | 7.1907 | 7.1661 | 7.1675 | 12851608.0 |
| 2007-12-27 11:10:00 | AAPL | Stock | 7.1671 | 7.1786 | 7.1561 | 7.1757 | 14814324.0 |
| 2007-12-27 11:15:00 | AAPL | Stock | 7.1761 | 7.1782 | 7.1664 | 7.1718 | 8290604.0 |
> showing 50 of 322,810 rows — these rows as CSV