PREVIEW / stock_5min / 2014-08-29
file: by_date/stock_5min/2014/2014-08-29.parquet size: 5.1 MB rows: 343,481 symbols: 3,585
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-29 04:15:00 | AAPL | Stock | 25.655 | 25.655 | 25.6525 | 25.655 | 4000.0 |
| 2014-08-29 04:20:00 | AAPL | Stock | 25.655 | 25.655 | 25.655 | 25.655 | 1600.0 |
| 2014-08-29 04:35:00 | AAPL | Stock | 25.6825 | 25.6825 | 25.6825 | 25.6825 | 800.0 |
| 2014-08-29 04:40:00 | AAPL | Stock | 25.6825 | 25.6825 | 25.675 | 25.675 | 3636.0 |
| 2014-08-29 04:45:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 5600.0 |
| 2014-08-29 04:55:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 800.0 |
| 2014-08-29 05:00:00 | AAPL | Stock | 25.6825 | 25.6825 | 25.6825 | 25.6825 | 400.0 |
| 2014-08-29 05:05:00 | AAPL | Stock | 25.68 | 25.6825 | 25.68 | 25.6825 | 1120.0 |
| 2014-08-29 05:10:00 | AAPL | Stock | 25.6825 | 25.6875 | 25.6825 | 25.6875 | 4080.0 |
| 2014-08-29 05:15:00 | AAPL | Stock | 25.6875 | 25.6875 | 25.675 | 25.675 | 2400.0 |
| 2014-08-29 05:20:00 | AAPL | Stock | 25.675 | 25.675 | 25.67 | 25.675 | 12180.0 |
| 2014-08-29 05:25:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 800.0 |
| 2014-08-29 05:40:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 8000.0 |
| 2014-08-29 05:45:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 2400.0 |
| 2014-08-29 05:50:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 800.0 |
| 2014-08-29 05:55:00 | AAPL | Stock | 25.675 | 25.675 | 25.6725 | 25.6725 | 6400.0 |
| 2014-08-29 06:00:00 | AAPL | Stock | 25.65 | 25.6625 | 25.65 | 25.6625 | 7232.0 |
| 2014-08-29 06:05:00 | AAPL | Stock | 25.6725 | 25.675 | 25.6725 | 25.675 | 800.0 |
| 2014-08-29 06:10:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 8800.0 |
| 2014-08-29 06:15:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 8000.0 |
| 2014-08-29 06:20:00 | AAPL | Stock | 25.675 | 25.675 | 25.675 | 25.675 | 5028.0 |
| 2014-08-29 06:25:00 | AAPL | Stock | 25.685 | 25.6875 | 25.685 | 25.685 | 3600.0 |
| 2014-08-29 06:30:00 | AAPL | Stock | 25.69 | 25.69 | 25.69 | 25.69 | 1200.0 |
| 2014-08-29 06:35:00 | AAPL | Stock | 25.6875 | 25.6875 | 25.6875 | 25.6875 | 4000.0 |
| 2014-08-29 06:40:00 | AAPL | Stock | 25.695 | 25.7 | 25.695 | 25.7 | 1200.0 |
| 2014-08-29 06:45:00 | AAPL | Stock | 25.7 | 25.7 | 25.7 | 25.7 | 6200.0 |
| 2014-08-29 06:50:00 | AAPL | Stock | 25.705 | 25.72 | 25.705 | 25.705 | 10000.0 |
| 2014-08-29 07:00:00 | AAPL | Stock | 25.705 | 25.725 | 25.7 | 25.725 | 25016.0 |
| 2014-08-29 07:05:00 | AAPL | Stock | 25.715 | 25.715 | 25.7 | 25.7 | 8024.0 |
| 2014-08-29 07:10:00 | AAPL | Stock | 25.6925 | 25.7 | 25.6875 | 25.7 | 4980.0 |
| 2014-08-29 07:15:00 | AAPL | Stock | 25.7 | 25.7 | 25.68 | 25.68 | 14276.0 |
| 2014-08-29 07:20:00 | AAPL | Stock | 25.68 | 25.6875 | 25.68 | 25.6875 | 4024.0 |
| 2014-08-29 07:25:00 | AAPL | Stock | 25.6975 | 25.6975 | 25.6975 | 25.6975 | 2000.0 |
| 2014-08-29 07:30:00 | AAPL | Stock | 25.695 | 25.6975 | 25.6875 | 25.6875 | 7140.0 |
| 2014-08-29 07:35:00 | AAPL | Stock | 25.695 | 25.695 | 25.695 | 25.695 | 2800.0 |
| 2014-08-29 07:40:00 | AAPL | Stock | 25.695 | 25.695 | 25.6875 | 25.6875 | 7624.0 |
| 2014-08-29 07:45:00 | AAPL | Stock | 25.6875 | 25.69 | 25.6875 | 25.6875 | 25076.0 |
| 2014-08-29 07:50:00 | AAPL | Stock | 25.6875 | 25.6925 | 25.6875 | 25.69 | 7500.0 |
| 2014-08-29 07:55:00 | AAPL | Stock | 25.68 | 25.6925 | 25.675 | 25.6825 | 12540.0 |
| 2014-08-29 08:00:00 | AAPL | Stock | 25.6825 | 25.73 | 25.6625 | 25.675 | 140684.0 |
| 2014-08-29 08:05:00 | AAPL | Stock | 25.675 | 25.675 | 25.665 | 25.67 | 29696.0 |
| 2014-08-29 08:10:00 | AAPL | Stock | 25.6675 | 25.6675 | 25.66 | 25.6675 | 39396.0 |
| 2014-08-29 08:15:00 | AAPL | Stock | 25.6675 | 25.6725 | 25.6625 | 25.665 | 25984.0 |
| 2014-08-29 08:20:00 | AAPL | Stock | 25.6725 | 25.6775 | 25.665 | 25.67 | 51552.0 |
| 2014-08-29 08:25:00 | AAPL | Stock | 25.665 | 25.6725 | 25.65 | 25.65 | 107148.0 |
| 2014-08-29 08:30:00 | AAPL | Stock | 25.65 | 25.655 | 25.6375 | 25.655 | 43600.0 |
| 2014-08-29 08:35:00 | AAPL | Stock | 25.6525 | 25.655 | 25.6275 | 25.65 | 37732.0 |
| 2014-08-29 08:40:00 | AAPL | Stock | 25.65 | 25.65 | 25.6375 | 25.6475 | 27804.0 |
| 2014-08-29 08:45:00 | AAPL | Stock | 25.6475 | 25.6525 | 25.64 | 25.6525 | 16240.0 |
| 2014-08-29 08:50:00 | AAPL | Stock | 25.6525 | 25.6525 | 25.6425 | 25.645 | 30028.0 |
> showing 50 of 343,481 rows — these rows as CSV