PREVIEW / stock_5min / 2010-02-23
file: by_date/stock_5min/2010/2010-02-23.parquet size: 4.7 MB rows: 328,925 symbols: 3,457
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-23 04:45:00 | AAPL | Stock | 7.1764 | 7.1764 | 7.1764 | 7.1764 | 2800.0 |
| 2010-02-23 05:30:00 | AAPL | Stock | 7.1621 | 7.1621 | 7.1611 | 7.1611 | 5740.0 |
| 2010-02-23 06:10:00 | AAPL | Stock | 7.1411 | 7.1411 | 7.1411 | 7.1411 | 4032.0 |
| 2010-02-23 06:35:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-23 06:45:00 | AAPL | Stock | 7.1254 | 7.1254 | 7.1254 | 7.1254 | 2800.0 |
| 2010-02-23 07:05:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 3220.0 |
| 2010-02-23 07:20:00 | AAPL | Stock | 7.1289 | 7.1289 | 7.1289 | 7.1289 | 11200.0 |
| 2010-02-23 07:25:00 | AAPL | Stock | 7.1336 | 7.1336 | 7.1336 | 7.1336 | 2800.0 |
| 2010-02-23 07:35:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1304 | 7.1304 | 16800.0 |
| 2010-02-23 07:40:00 | AAPL | Stock | 7.1286 | 7.1286 | 7.1286 | 7.1286 | 2800.0 |
| 2010-02-23 07:45:00 | AAPL | Stock | 7.1304 | 7.1304 | 7.1304 | 7.1304 | 2800.0 |
| 2010-02-23 08:00:00 | AAPL | Stock | 7.1304 | 7.15 | 7.1304 | 7.1393 | 133560.0 |
| 2010-02-23 08:10:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1375 | 7.1375 | 128800.0 |
| 2010-02-23 08:15:00 | AAPL | Stock | 7.1375 | 7.1375 | 7.1321 | 7.1321 | 33880.0 |
| 2010-02-23 08:20:00 | AAPL | Stock | 7.1389 | 7.14 | 7.1389 | 7.1393 | 36400.0 |
| 2010-02-23 08:25:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 19600.0 |
| 2010-02-23 08:30:00 | AAPL | Stock | 7.1375 | 7.1411 | 7.1364 | 7.1411 | 14000.0 |
| 2010-02-23 08:35:00 | AAPL | Stock | 7.1375 | 7.1409 | 7.13 | 7.1321 | 170100.0 |
| 2010-02-23 08:40:00 | AAPL | Stock | 7.1321 | 7.1325 | 7.1268 | 7.1304 | 196308.0 |
| 2010-02-23 08:45:00 | AAPL | Stock | 7.1321 | 7.1321 | 7.1321 | 7.1321 | 45612.0 |
| 2010-02-23 08:50:00 | AAPL | Stock | 7.1321 | 7.1346 | 7.1321 | 7.1343 | 67200.0 |
| 2010-02-23 08:55:00 | AAPL | Stock | 7.1339 | 7.1339 | 7.1336 | 7.1336 | 16800.0 |
| 2010-02-23 09:00:00 | AAPL | Stock | 7.1332 | 7.1354 | 7.1307 | 7.1307 | 79576.0 |
| 2010-02-23 09:05:00 | AAPL | Stock | 7.1343 | 7.1357 | 7.1343 | 7.1346 | 25200.0 |
| 2010-02-23 09:10:00 | AAPL | Stock | 7.1343 | 7.1343 | 7.1343 | 7.1343 | 7896.0 |
| 2010-02-23 09:15:00 | AAPL | Stock | 7.1348 | 7.1348 | 7.1348 | 7.1348 | 2800.0 |
| 2010-02-23 09:20:00 | AAPL | Stock | 7.1386 | 7.1429 | 7.1386 | 7.1429 | 69020.0 |
| 2010-02-23 09:25:00 | AAPL | Stock | 7.1425 | 7.1429 | 7.1361 | 7.1396 | 37268.0 |
| 2010-02-23 09:30:00 | AAPL | Stock | 7.1404 | 7.1464 | 7.1296 | 7.1321 | 9302104.0 |
| 2010-02-23 09:35:00 | AAPL | Stock | 7.1321 | 7.1339 | 7.0957 | 7.1029 | 13155520.0 |
| 2010-02-23 09:40:00 | AAPL | Stock | 7.1025 | 7.1339 | 7.0979 | 7.1329 | 10214092.0 |
| 2010-02-23 09:45:00 | AAPL | Stock | 7.1336 | 7.1607 | 7.1336 | 7.1571 | 9650704.0 |
| 2010-02-23 09:50:00 | AAPL | Stock | 7.1571 | 7.1875 | 7.1554 | 7.1871 | 13171788.0 |
| 2010-02-23 09:55:00 | AAPL | Stock | 7.1854 | 7.1904 | 7.1639 | 7.1814 | 9427880.0 |
| 2010-02-23 10:00:00 | AAPL | Stock | 7.1707 | 7.1836 | 7.1311 | 7.1532 | 22786288.0 |
| 2010-02-23 10:05:00 | AAPL | Stock | 7.1536 | 7.1575 | 7.1204 | 7.1304 | 9368604.0 |
| 2010-02-23 10:10:00 | AAPL | Stock | 7.1293 | 7.13 | 7.0964 | 7.0982 | 16794960.0 |
| 2010-02-23 10:15:00 | AAPL | Stock | 7.0995 | 7.1068 | 7.0921 | 7.1007 | 11427136.0 |
| 2010-02-23 10:20:00 | AAPL | Stock | 7.1007 | 7.1007 | 7.0804 | 7.0839 | 9644880.0 |
| 2010-02-23 10:25:00 | AAPL | Stock | 7.0854 | 7.0961 | 7.0761 | 7.0893 | 8476720.0 |
| 2010-02-23 10:30:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.06 | 7.0775 | 13648796.0 |
| 2010-02-23 10:35:00 | AAPL | Stock | 7.0764 | 7.0807 | 7.0707 | 7.0789 | 7267036.0 |
| 2010-02-23 10:40:00 | AAPL | Stock | 7.0781 | 7.0879 | 7.0696 | 7.0854 | 5499620.0 |
| 2010-02-23 10:45:00 | AAPL | Stock | 7.0846 | 7.0889 | 7.0768 | 7.0775 | 4532108.0 |
| 2010-02-23 10:50:00 | AAPL | Stock | 7.0771 | 7.0811 | 7.0732 | 7.0743 | 3052336.0 |
| 2010-02-23 10:55:00 | AAPL | Stock | 7.0732 | 7.0914 | 7.0729 | 7.0879 | 3958220.0 |
| 2010-02-23 11:00:00 | AAPL | Stock | 7.0864 | 7.0925 | 7.0754 | 7.0754 | 4725840.0 |
| 2010-02-23 11:05:00 | AAPL | Stock | 7.0754 | 7.0814 | 7.0689 | 7.0811 | 7009380.0 |
| 2010-02-23 11:10:00 | AAPL | Stock | 7.08 | 7.0818 | 7.0707 | 7.0729 | 2648268.0 |
| 2010-02-23 11:15:00 | AAPL | Stock | 7.0732 | 7.0732 | 7.0611 | 7.0682 | 4906244.0 |
> showing 50 of 328,925 rows — these rows as CSV