PREVIEW / stock_5min / 2013-03-21
file: by_date/stock_5min/2013/2013-03-21.parquet size: 4.9 MB rows: 324,738 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-21 04:10:00 | AAPL | Stock | 16.0707 | 16.0707 | 16.0707 | 16.0707 | 4200.0 |
| 2013-03-21 04:55:00 | AAPL | Stock | 16.0593 | 16.0593 | 16.0593 | 16.0593 | 2800.0 |
| 2013-03-21 05:45:00 | AAPL | Stock | 16.0718 | 16.0718 | 16.0718 | 16.0718 | 2800.0 |
| 2013-03-21 06:15:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 8400.0 |
| 2013-03-21 07:00:00 | AAPL | Stock | 16.0729 | 16.0729 | 16.0729 | 16.0729 | 3528.0 |
| 2013-03-21 07:10:00 | AAPL | Stock | 16.1136 | 16.1254 | 16.1029 | 16.1254 | 39200.0 |
| 2013-03-21 07:15:00 | AAPL | Stock | 16.1257 | 16.1257 | 16.1071 | 16.1071 | 8400.0 |
| 2013-03-21 07:25:00 | AAPL | Stock | 16.1339 | 16.1429 | 16.1339 | 16.1411 | 18060.0 |
| 2013-03-21 07:30:00 | AAPL | Stock | 16.1411 | 16.1411 | 16.1411 | 16.1411 | 2800.0 |
| 2013-03-21 07:35:00 | AAPL | Stock | 16.1393 | 16.1411 | 16.1393 | 16.1411 | 25844.0 |
| 2013-03-21 07:40:00 | AAPL | Stock | 16.1343 | 16.1411 | 16.1304 | 16.1407 | 72716.0 |
| 2013-03-21 07:45:00 | AAPL | Stock | 16.1446 | 16.1607 | 16.1446 | 16.1532 | 128408.0 |
| 2013-03-21 07:50:00 | AAPL | Stock | 16.1532 | 16.1532 | 16.1429 | 16.1489 | 19600.0 |
| 2013-03-21 07:55:00 | AAPL | Stock | 16.1464 | 16.15 | 16.1464 | 16.15 | 28812.0 |
| 2013-03-21 08:00:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1111 | 16.125 | 80360.0 |
| 2013-03-21 08:05:00 | AAPL | Stock | 16.125 | 16.125 | 16.1086 | 16.1104 | 81200.0 |
| 2013-03-21 08:10:00 | AAPL | Stock | 16.1104 | 16.1436 | 16.1093 | 16.1093 | 140756.0 |
| 2013-03-21 08:15:00 | AAPL | Stock | 16.1375 | 16.1393 | 16.1204 | 16.1293 | 14000.0 |
| 2013-03-21 08:20:00 | AAPL | Stock | 16.1339 | 16.1429 | 16.1321 | 16.1429 | 54040.0 |
| 2013-03-21 08:25:00 | AAPL | Stock | 16.1464 | 16.1536 | 16.1321 | 16.1321 | 197988.0 |
| 2013-03-21 08:30:00 | AAPL | Stock | 16.1375 | 16.1375 | 16.1307 | 16.1336 | 39200.0 |
| 2013-03-21 08:35:00 | AAPL | Stock | 16.1354 | 16.1354 | 16.1346 | 16.135 | 19460.0 |
| 2013-03-21 08:40:00 | AAPL | Stock | 16.1425 | 16.1429 | 16.125 | 16.125 | 50400.0 |
| 2013-03-21 08:45:00 | AAPL | Stock | 16.125 | 16.1261 | 16.1246 | 16.1261 | 26600.0 |
| 2013-03-21 08:50:00 | AAPL | Stock | 16.1204 | 16.1207 | 16.1154 | 16.1154 | 30800.0 |
| 2013-03-21 08:55:00 | AAPL | Stock | 16.11 | 16.1143 | 16.0929 | 16.1036 | 53144.0 |
| 2013-03-21 09:00:00 | AAPL | Stock | 16.0989 | 16.1011 | 16.0907 | 16.0907 | 48748.0 |
| 2013-03-21 09:05:00 | AAPL | Stock | 16.1014 | 16.1064 | 16.0968 | 16.0968 | 75684.0 |
| 2013-03-21 09:10:00 | AAPL | Stock | 16.1036 | 16.1054 | 16.0904 | 16.0904 | 98560.0 |
| 2013-03-21 09:15:00 | AAPL | Stock | 16.0911 | 16.1018 | 16.0893 | 16.0929 | 109816.0 |
| 2013-03-21 09:20:00 | AAPL | Stock | 16.0982 | 16.0982 | 16.0746 | 16.0807 | 151620.0 |
| 2013-03-21 09:25:00 | AAPL | Stock | 16.0811 | 16.0868 | 16.0714 | 16.0821 | 341180.0 |
| 2013-03-21 09:30:00 | AAPL | Stock | 16.0793 | 16.2071 | 16.075 | 16.207 | 19454204.0 |
| 2013-03-21 09:35:00 | AAPL | Stock | 16.2068 | 16.23 | 16.1711 | 16.1825 | 12049688.0 |
| 2013-03-21 09:40:00 | AAPL | Stock | 16.1789 | 16.1939 | 16.113 | 16.1357 | 9416624.0 |
| 2013-03-21 09:45:00 | AAPL | Stock | 16.1346 | 16.1379 | 16.1011 | 16.1246 | 5881260.0 |
| 2013-03-21 09:50:00 | AAPL | Stock | 16.1225 | 16.1539 | 16.1193 | 16.1421 | 5317564.0 |
| 2013-03-21 09:55:00 | AAPL | Stock | 16.1439 | 16.1496 | 16.1182 | 16.1421 | 3832836.0 |
| 2013-03-21 10:00:00 | AAPL | Stock | 16.1475 | 16.1711 | 16.1189 | 16.1518 | 3704904.0 |
| 2013-03-21 10:05:00 | AAPL | Stock | 16.1511 | 16.1918 | 16.1279 | 16.1686 | 5239136.0 |
| 2013-03-21 10:10:00 | AAPL | Stock | 16.1751 | 16.1771 | 16.1286 | 16.1389 | 4620560.0 |
| 2013-03-21 10:15:00 | AAPL | Stock | 16.1386 | 16.1386 | 16.1029 | 16.1068 | 5379892.0 |
| 2013-03-21 10:20:00 | AAPL | Stock | 16.1071 | 16.1268 | 16.1032 | 16.1161 | 2513448.0 |
| 2013-03-21 10:25:00 | AAPL | Stock | 16.1161 | 16.1393 | 16.1039 | 16.1246 | 3236884.0 |
| 2013-03-21 10:30:00 | AAPL | Stock | 16.1268 | 16.1432 | 16.1036 | 16.1432 | 2865968.0 |
| 2013-03-21 10:35:00 | AAPL | Stock | 16.1439 | 16.1457 | 16.115 | 16.136 | 2746688.0 |
| 2013-03-21 10:40:00 | AAPL | Stock | 16.1371 | 16.1661 | 16.1325 | 16.1528 | 4786768.0 |
| 2013-03-21 10:45:00 | AAPL | Stock | 16.1514 | 16.1643 | 16.145 | 16.1461 | 2940336.0 |
| 2013-03-21 10:50:00 | AAPL | Stock | 16.1464 | 16.1507 | 16.1309 | 16.1366 | 2919028.0 |
| 2013-03-21 10:55:00 | AAPL | Stock | 16.1371 | 16.1604 | 16.1346 | 16.1596 | 3397324.0 |
> showing 50 of 324,738 rows — these rows as CSV