PREVIEW / stock_5min / 2008-11-03
file: by_date/stock_5min/2008/2008-11-03.parquet size: 4.3 MB rows: 314,069 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-03 06:15:00 | AAPL | Stock | 3.8732 | 3.8732 | 3.8286 | 3.8286 | 8400.0 |
| 2008-11-03 06:25:00 | AAPL | Stock | 3.8286 | 3.8286 | 3.8286 | 3.8286 | 8400.0 |
| 2008-11-03 06:45:00 | AAPL | Stock | 3.8293 | 3.8293 | 3.8293 | 3.8293 | 28000.0 |
| 2008-11-03 07:05:00 | AAPL | Stock | 3.8571 | 3.8732 | 3.8571 | 3.8732 | 13440.0 |
| 2008-11-03 07:15:00 | AAPL | Stock | 3.8661 | 3.8661 | 3.8661 | 3.8661 | 19124.0 |
| 2008-11-03 07:20:00 | AAPL | Stock | 3.8482 | 3.8571 | 3.8464 | 3.8571 | 34300.0 |
| 2008-11-03 07:25:00 | AAPL | Stock | 3.8446 | 3.8446 | 3.8296 | 3.8339 | 43092.0 |
| 2008-11-03 07:30:00 | AAPL | Stock | 3.8425 | 3.8429 | 3.8425 | 3.8429 | 8736.0 |
| 2008-11-03 07:45:00 | AAPL | Stock | 3.8464 | 3.8464 | 3.8393 | 3.8393 | 35476.0 |
| 2008-11-03 07:50:00 | AAPL | Stock | 3.8364 | 3.8364 | 3.8339 | 3.8339 | 42000.0 |
| 2008-11-03 07:55:00 | AAPL | Stock | 3.8296 | 3.8296 | 3.8218 | 3.8225 | 28000.0 |
| 2008-11-03 08:00:00 | AAPL | Stock | 3.8371 | 3.8429 | 3.8211 | 3.8286 | 565152.0 |
| 2008-11-03 08:05:00 | AAPL | Stock | 3.8286 | 3.8296 | 3.8232 | 3.8261 | 261772.0 |
| 2008-11-03 08:10:00 | AAPL | Stock | 3.8296 | 3.8386 | 3.8261 | 3.8286 | 179200.0 |
| 2008-11-03 08:15:00 | AAPL | Stock | 3.8304 | 3.8321 | 3.8168 | 3.8168 | 461188.0 |
| 2008-11-03 08:20:00 | AAPL | Stock | 3.8214 | 3.8218 | 3.7829 | 3.7968 | 1500408.0 |
| 2008-11-03 08:25:00 | AAPL | Stock | 3.7986 | 3.7986 | 3.7768 | 3.7793 | 888076.0 |
| 2008-11-03 08:30:00 | AAPL | Stock | 3.7836 | 3.8032 | 3.7836 | 3.7982 | 386120.0 |
| 2008-11-03 08:35:00 | AAPL | Stock | 3.7986 | 3.7986 | 3.7857 | 3.7868 | 646016.0 |
| 2008-11-03 08:40:00 | AAPL | Stock | 3.7864 | 3.7925 | 3.7857 | 3.7896 | 242200.0 |
| 2008-11-03 08:45:00 | AAPL | Stock | 3.7936 | 3.8011 | 3.7896 | 3.7982 | 268464.0 |
| 2008-11-03 08:50:00 | AAPL | Stock | 3.7993 | 3.7996 | 3.7911 | 3.7946 | 295596.0 |
| 2008-11-03 08:55:00 | AAPL | Stock | 3.7921 | 3.7964 | 3.7893 | 3.7893 | 71400.0 |
| 2008-11-03 09:00:00 | AAPL | Stock | 3.79 | 3.8425 | 3.7704 | 3.7818 | 1138788.0 |
| 2008-11-03 09:05:00 | AAPL | Stock | 3.7839 | 3.7839 | 3.7443 | 3.7446 | 1521128.0 |
| 2008-11-03 09:10:00 | AAPL | Stock | 3.7479 | 3.7625 | 3.7446 | 3.7586 | 1524572.0 |
| 2008-11-03 09:15:00 | AAPL | Stock | 3.7589 | 3.7607 | 3.7464 | 3.7536 | 1003940.0 |
| 2008-11-03 09:20:00 | AAPL | Stock | 3.7521 | 3.8425 | 3.7511 | 3.7532 | 351736.0 |
| 2008-11-03 09:25:00 | AAPL | Stock | 3.7536 | 3.7814 | 3.7514 | 3.7814 | 1635116.0 |
| 2008-11-03 09:30:00 | AAPL | Stock | 3.7814 | 3.7929 | 3.745 | 3.785 | 32295788.0 |
| 2008-11-03 09:35:00 | AAPL | Stock | 3.785 | 3.8354 | 3.7804 | 3.8211 | 34157732.0 |
| 2008-11-03 09:40:00 | AAPL | Stock | 3.8211 | 3.8321 | 3.8029 | 3.8075 | 23058196.0 |
| 2008-11-03 09:45:00 | AAPL | Stock | 3.8071 | 3.8257 | 3.8021 | 3.8164 | 21058408.0 |
| 2008-11-03 09:50:00 | AAPL | Stock | 3.8168 | 3.8407 | 3.8036 | 3.8354 | 20230364.0 |
| 2008-11-03 09:55:00 | AAPL | Stock | 3.8354 | 3.85 | 3.8207 | 3.8364 | 19523336.0 |
| 2008-11-03 10:00:00 | AAPL | Stock | 3.8368 | 3.8554 | 3.825 | 3.8468 | 26508860.0 |
| 2008-11-03 10:05:00 | AAPL | Stock | 3.8464 | 3.8818 | 3.8464 | 3.8748 | 28473172.0 |
| 2008-11-03 10:10:00 | AAPL | Stock | 3.8746 | 3.8921 | 3.8632 | 3.8893 | 21434028.0 |
| 2008-11-03 10:15:00 | AAPL | Stock | 3.8892 | 3.8964 | 3.8725 | 3.8739 | 21367444.0 |
| 2008-11-03 10:20:00 | AAPL | Stock | 3.8739 | 3.8779 | 3.86 | 3.8643 | 16653756.0 |
| 2008-11-03 10:25:00 | AAPL | Stock | 3.8639 | 3.8696 | 3.8511 | 3.8593 | 14912688.0 |
| 2008-11-03 10:30:00 | AAPL | Stock | 3.86 | 3.8664 | 3.8439 | 3.8571 | 20273120.0 |
| 2008-11-03 10:35:00 | AAPL | Stock | 3.8564 | 3.8696 | 3.8529 | 3.8604 | 14101192.0 |
| 2008-11-03 10:40:00 | AAPL | Stock | 3.8604 | 3.8654 | 3.8311 | 3.8332 | 18121852.0 |
| 2008-11-03 10:45:00 | AAPL | Stock | 3.8332 | 3.8518 | 3.8271 | 3.8454 | 16374008.0 |
| 2008-11-03 10:50:00 | AAPL | Stock | 3.845 | 3.8629 | 3.845 | 3.8591 | 13280736.0 |
| 2008-11-03 10:55:00 | AAPL | Stock | 3.8589 | 3.86 | 3.8459 | 3.855 | 9012164.0 |
| 2008-11-03 11:00:00 | AAPL | Stock | 3.8554 | 3.8593 | 3.8471 | 3.8482 | 9299276.0 |
| 2008-11-03 11:05:00 | AAPL | Stock | 3.8489 | 3.8536 | 3.8375 | 3.8489 | 9818900.0 |
| 2008-11-03 11:10:00 | AAPL | Stock | 3.8486 | 3.8582 | 3.8411 | 3.8468 | 9424464.0 |
> showing 50 of 314,069 rows — these rows as CSV