PREVIEW / stock_5min / 2015-03-12
file: by_date/stock_5min/2015/2015-03-12.parquet size: 5.5 MB rows: 363,011 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-12 04:00:00 | AAPL | Stock | 30.7475 | 30.8575 | 30.7475 | 30.75 | 7600.0 |
| 2015-03-12 04:05:00 | AAPL | Stock | 30.7525 | 30.7525 | 30.75 | 30.75 | 2800.0 |
| 2015-03-12 04:15:00 | AAPL | Stock | 30.725 | 30.725 | 30.7125 | 30.715 | 1200.0 |
| 2015-03-12 04:35:00 | AAPL | Stock | 30.69 | 30.69 | 30.69 | 30.69 | 400.0 |
| 2015-03-12 04:55:00 | AAPL | Stock | 30.6975 | 30.6975 | 30.6975 | 30.6975 | 400.0 |
| 2015-03-12 05:00:00 | AAPL | Stock | 30.69 | 30.6925 | 30.69 | 30.69 | 3600.0 |
| 2015-03-12 05:05:00 | AAPL | Stock | 30.69 | 30.69 | 30.6825 | 30.6825 | 2396.0 |
| 2015-03-12 05:10:00 | AAPL | Stock | 30.68 | 30.68 | 30.68 | 30.68 | 400.0 |
| 2015-03-12 05:15:00 | AAPL | Stock | 30.68 | 30.6875 | 30.68 | 30.6875 | 1600.0 |
| 2015-03-12 05:25:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.665 | 30.665 | 13200.0 |
| 2015-03-12 05:30:00 | AAPL | Stock | 30.665 | 30.6675 | 30.665 | 30.6675 | 1600.0 |
| 2015-03-12 05:35:00 | AAPL | Stock | 30.6675 | 30.6675 | 30.6525 | 30.6525 | 1600.0 |
| 2015-03-12 05:40:00 | AAPL | Stock | 30.645 | 30.645 | 30.645 | 30.645 | 8400.0 |
| 2015-03-12 05:45:00 | AAPL | Stock | 30.645 | 30.645 | 30.64 | 30.645 | 12364.0 |
| 2015-03-12 05:50:00 | AAPL | Stock | 30.65 | 30.65 | 30.65 | 30.65 | 2000.0 |
| 2015-03-12 06:00:00 | AAPL | Stock | 30.675 | 30.6875 | 30.675 | 30.6875 | 2604.0 |
| 2015-03-12 06:05:00 | AAPL | Stock | 30.6425 | 30.6425 | 30.6425 | 30.6425 | 400.0 |
| 2015-03-12 06:10:00 | AAPL | Stock | 30.65 | 30.65 | 30.65 | 30.65 | 3200.0 |
| 2015-03-12 06:15:00 | AAPL | Stock | 30.65 | 30.675 | 30.63 | 30.675 | 9200.0 |
| 2015-03-12 06:20:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.675 | 30.675 | 8400.0 |
| 2015-03-12 06:30:00 | AAPL | Stock | 30.6875 | 30.7 | 30.6875 | 30.7 | 5200.0 |
| 2015-03-12 06:35:00 | AAPL | Stock | 30.7 | 30.7 | 30.675 | 30.7 | 3400.0 |
| 2015-03-12 06:40:00 | AAPL | Stock | 30.7 | 30.7 | 30.7 | 30.7 | 400.0 |
| 2015-03-12 06:45:00 | AAPL | Stock | 30.715 | 30.715 | 30.7075 | 30.7075 | 7200.0 |
| 2015-03-12 06:50:00 | AAPL | Stock | 30.72 | 30.72 | 30.7175 | 30.72 | 6900.0 |
| 2015-03-12 07:00:00 | AAPL | Stock | 30.7175 | 30.7175 | 30.675 | 30.675 | 17612.0 |
| 2015-03-12 07:05:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.6625 | 30.6725 | 11600.0 |
| 2015-03-12 07:10:00 | AAPL | Stock | 30.6625 | 30.6725 | 30.6625 | 30.6725 | 2400.0 |
| 2015-03-12 07:15:00 | AAPL | Stock | 30.6525 | 30.7 | 30.6525 | 30.665 | 4000.0 |
| 2015-03-12 07:20:00 | AAPL | Stock | 30.6775 | 30.695 | 30.665 | 30.695 | 11800.0 |
| 2015-03-12 07:25:00 | AAPL | Stock | 30.6725 | 30.6775 | 30.6725 | 30.6775 | 2000.0 |
| 2015-03-12 07:30:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.6575 | 30.67 | 5444.0 |
| 2015-03-12 07:35:00 | AAPL | Stock | 30.67 | 30.6875 | 30.67 | 30.6875 | 6792.0 |
| 2015-03-12 07:40:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.6825 | 30.6875 | 10132.0 |
| 2015-03-12 07:45:00 | AAPL | Stock | 30.685 | 30.685 | 30.685 | 30.685 | 400.0 |
| 2015-03-12 07:50:00 | AAPL | Stock | 30.675 | 30.6975 | 30.675 | 30.695 | 6680.0 |
| 2015-03-12 07:55:00 | AAPL | Stock | 30.705 | 30.715 | 30.7 | 30.71 | 10920.0 |
| 2015-03-12 08:00:00 | AAPL | Stock | 30.7125 | 30.7175 | 30.6475 | 30.6925 | 205532.0 |
| 2015-03-12 08:05:00 | AAPL | Stock | 30.69 | 30.6975 | 30.68 | 30.6875 | 98028.0 |
| 2015-03-12 08:10:00 | AAPL | Stock | 30.6825 | 30.6825 | 30.6475 | 30.6475 | 68916.0 |
| 2015-03-12 08:15:00 | AAPL | Stock | 30.655 | 30.67 | 30.6425 | 30.67 | 70772.0 |
| 2015-03-12 08:20:00 | AAPL | Stock | 30.67 | 30.6725 | 30.64 | 30.65 | 82804.0 |
| 2015-03-12 08:25:00 | AAPL | Stock | 30.645 | 30.6575 | 30.645 | 30.6575 | 15340.0 |
| 2015-03-12 08:30:00 | AAPL | Stock | 30.6575 | 30.67 | 30.615 | 30.6375 | 117384.0 |
| 2015-03-12 08:35:00 | AAPL | Stock | 30.6325 | 30.655 | 30.6275 | 30.6375 | 150464.0 |
| 2015-03-12 08:40:00 | AAPL | Stock | 30.6375 | 30.6425 | 30.61 | 30.625 | 57916.0 |
| 2015-03-12 08:45:00 | AAPL | Stock | 30.63 | 30.63 | 30.59 | 30.6 | 50024.0 |
| 2015-03-12 08:50:00 | AAPL | Stock | 30.6 | 30.615 | 30.58 | 30.5928 | 65864.0 |
| 2015-03-12 08:55:00 | AAPL | Stock | 30.6 | 30.6375 | 30.5875 | 30.6375 | 136976.0 |
| 2015-03-12 09:00:00 | AAPL | Stock | 30.6375 | 30.645 | 30.5875 | 30.61 | 237716.0 |
> showing 50 of 363,011 rows — these rows as CSV