PREVIEW / stock_5min / 2010-10-29
file: by_date/stock_5min/2010/2010-10-29.parquet size: 4.6 MB rows: 318,114 symbols: 3,492
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-10-29 05:15:00 | AAPL | Stock | 10.8414 | 10.8661 | 10.8368 | 10.8368 | 9800.0 |
| 2010-10-29 05:35:00 | AAPL | Stock | 10.8586 | 10.8586 | 10.8586 | 10.8586 | 2800.0 |
| 2010-10-29 05:50:00 | AAPL | Stock | 10.8489 | 10.8489 | 10.8489 | 10.8489 | 2800.0 |
| 2010-10-29 06:25:00 | AAPL | Stock | 10.8371 | 10.8371 | 10.8371 | 10.8371 | 2800.0 |
| 2010-10-29 06:55:00 | AAPL | Stock | 10.8468 | 10.8571 | 10.8468 | 10.8571 | 11200.0 |
| 2010-10-29 07:00:00 | AAPL | Stock | 10.8464 | 10.8464 | 10.8464 | 10.8464 | 5600.0 |
| 2010-10-29 07:05:00 | AAPL | Stock | 10.8496 | 10.8496 | 10.8496 | 10.8496 | 2800.0 |
| 2010-10-29 07:20:00 | AAPL | Stock | 10.8396 | 10.8396 | 10.8396 | 10.8396 | 2800.0 |
| 2010-10-29 07:25:00 | AAPL | Stock | 10.8396 | 10.8396 | 10.8396 | 10.8396 | 2800.0 |
| 2010-10-29 07:35:00 | AAPL | Stock | 10.8393 | 10.8393 | 10.8393 | 10.8393 | 9800.0 |
| 2010-10-29 07:50:00 | AAPL | Stock | 10.8432 | 10.8468 | 10.8432 | 10.8432 | 8400.0 |
| 2010-10-29 07:55:00 | AAPL | Stock | 10.8525 | 10.86 | 10.8525 | 10.86 | 31780.0 |
| 2010-10-29 08:00:00 | AAPL | Stock | 10.8629 | 10.8679 | 10.85 | 10.8529 | 208852.0 |
| 2010-10-29 08:05:00 | AAPL | Stock | 10.8564 | 10.8675 | 10.8518 | 10.8675 | 94332.0 |
| 2010-10-29 08:10:00 | AAPL | Stock | 10.8661 | 10.8764 | 10.8661 | 10.8764 | 197316.0 |
| 2010-10-29 08:15:00 | AAPL | Stock | 10.88 | 10.8918 | 10.8732 | 10.875 | 320656.0 |
| 2010-10-29 08:20:00 | AAPL | Stock | 10.8782 | 10.8818 | 10.8732 | 10.8732 | 217476.0 |
| 2010-10-29 08:25:00 | AAPL | Stock | 10.8714 | 10.8779 | 10.8675 | 10.8779 | 78400.0 |
| 2010-10-29 08:30:00 | AAPL | Stock | 10.8779 | 10.8911 | 10.8646 | 10.88 | 356860.0 |
| 2010-10-29 08:35:00 | AAPL | Stock | 10.8793 | 10.8793 | 10.8679 | 10.8696 | 68180.0 |
| 2010-10-29 08:40:00 | AAPL | Stock | 10.8696 | 10.8754 | 10.8696 | 10.875 | 42420.0 |
| 2010-10-29 08:45:00 | AAPL | Stock | 10.8789 | 10.8889 | 10.8782 | 10.8889 | 144340.0 |
| 2010-10-29 08:50:00 | AAPL | Stock | 10.8889 | 10.9071 | 10.8889 | 10.9036 | 764400.0 |
| 2010-10-29 08:55:00 | AAPL | Stock | 10.9014 | 10.9021 | 10.9 | 10.9018 | 91000.0 |
| 2010-10-29 09:00:00 | AAPL | Stock | 10.9018 | 10.9079 | 10.9018 | 10.9025 | 238000.0 |
| 2010-10-29 09:05:00 | AAPL | Stock | 10.905 | 10.9071 | 10.9004 | 10.9004 | 184548.0 |
| 2010-10-29 09:10:00 | AAPL | Stock | 10.9011 | 10.9011 | 10.8982 | 10.8982 | 71764.0 |
| 2010-10-29 09:15:00 | AAPL | Stock | 10.9014 | 10.9057 | 10.8986 | 10.8986 | 110404.0 |
| 2010-10-29 09:20:00 | AAPL | Stock | 10.9 | 10.9 | 10.8914 | 10.8964 | 95200.0 |
| 2010-10-29 09:25:00 | AAPL | Stock | 10.8964 | 10.8964 | 10.865 | 10.8654 | 285376.0 |
| 2010-10-29 09:30:00 | AAPL | Stock | 10.8654 | 10.8957 | 10.8571 | 10.895 | 9722272.0 |
| 2010-10-29 09:35:00 | AAPL | Stock | 10.8914 | 10.9243 | 10.8893 | 10.9079 | 9828000.0 |
| 2010-10-29 09:40:00 | AAPL | Stock | 10.9075 | 10.9121 | 10.88 | 10.8939 | 8015056.0 |
| 2010-10-29 09:45:00 | AAPL | Stock | 10.8954 | 10.905 | 10.8846 | 10.901 | 6749876.0 |
| 2010-10-29 09:50:00 | AAPL | Stock | 10.8982 | 10.9 | 10.8743 | 10.8837 | 6497848.0 |
| 2010-10-29 09:55:00 | AAPL | Stock | 10.8839 | 10.8839 | 10.8689 | 10.872 | 3764124.0 |
| 2010-10-29 10:00:00 | AAPL | Stock | 10.8718 | 10.8896 | 10.8668 | 10.8867 | 5106444.0 |
| 2010-10-29 10:05:00 | AAPL | Stock | 10.8857 | 10.9036 | 10.8846 | 10.8918 | 8282820.0 |
| 2010-10-29 10:10:00 | AAPL | Stock | 10.8914 | 10.8929 | 10.8786 | 10.8832 | 3744300.0 |
| 2010-10-29 10:15:00 | AAPL | Stock | 10.8827 | 10.8939 | 10.8804 | 10.8879 | 3319512.0 |
| 2010-10-29 10:20:00 | AAPL | Stock | 10.8879 | 10.8886 | 10.8764 | 10.8809 | 2799832.0 |
| 2010-10-29 10:25:00 | AAPL | Stock | 10.8804 | 10.8954 | 10.8804 | 10.8814 | 3131968.0 |
| 2010-10-29 10:30:00 | AAPL | Stock | 10.8829 | 10.8832 | 10.8496 | 10.8543 | 5812940.0 |
| 2010-10-29 10:35:00 | AAPL | Stock | 10.851 | 10.8664 | 10.8507 | 10.8567 | 5340328.0 |
| 2010-10-29 10:40:00 | AAPL | Stock | 10.8552 | 10.8586 | 10.8196 | 10.8229 | 7280644.0 |
| 2010-10-29 10:45:00 | AAPL | Stock | 10.8229 | 10.8336 | 10.8086 | 10.8307 | 7198240.0 |
| 2010-10-29 10:50:00 | AAPL | Stock | 10.8309 | 10.8386 | 10.8257 | 10.8361 | 4492432.0 |
| 2010-10-29 10:55:00 | AAPL | Stock | 10.8361 | 10.8411 | 10.8268 | 10.8393 | 2861096.0 |
| 2010-10-29 11:00:00 | AAPL | Stock | 10.8368 | 10.8436 | 10.8343 | 10.8396 | 2957472.0 |
| 2010-10-29 11:05:00 | AAPL | Stock | 10.84 | 10.8407 | 10.8225 | 10.8381 | 4311748.0 |
> showing 50 of 318,114 rows — these rows as CSV