PREVIEW / stock_5min / 2014-12-01
file: by_date/stock_5min/2014/2014-12-01.parquet size: 5.7 MB rows: 374,024 symbols: 3,561
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-12-01 04:00:00 | AAPL | Stock | 29.625 | 29.625 | 29.62 | 29.62 | 3200.0 |
| 2014-12-01 04:05:00 | AAPL | Stock | 29.61 | 29.6125 | 29.61 | 29.6125 | 2932.0 |
| 2014-12-01 04:10:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 400.0 |
| 2014-12-01 04:15:00 | AAPL | Stock | 29.6125 | 29.6225 | 29.6125 | 29.6225 | 3468.0 |
| 2014-12-01 04:30:00 | AAPL | Stock | 29.6 | 29.6 | 29.6 | 29.6 | 8000.0 |
| 2014-12-01 04:45:00 | AAPL | Stock | 29.64 | 29.64 | 29.64 | 29.64 | 800.0 |
| 2014-12-01 04:50:00 | AAPL | Stock | 29.645 | 29.645 | 29.645 | 29.645 | 400.0 |
| 2014-12-01 04:55:00 | AAPL | Stock | 29.65 | 29.6575 | 29.65 | 29.6575 | 800.0 |
| 2014-12-01 05:10:00 | AAPL | Stock | 29.67 | 29.67 | 29.67 | 29.67 | 2000.0 |
| 2014-12-01 05:20:00 | AAPL | Stock | 29.6525 | 29.6525 | 29.65 | 29.65 | 6000.0 |
| 2014-12-01 05:55:00 | AAPL | Stock | 29.635 | 29.635 | 29.635 | 29.635 | 400.0 |
| 2014-12-01 06:50:00 | AAPL | Stock | 29.6375 | 29.6375 | 29.6375 | 29.6375 | 2000.0 |
| 2014-12-01 07:00:00 | AAPL | Stock | 29.6625 | 29.7 | 29.6625 | 29.7 | 11840.0 |
| 2014-12-01 07:05:00 | AAPL | Stock | 29.72 | 29.7625 | 29.7125 | 29.7625 | 17108.0 |
| 2014-12-01 07:10:00 | AAPL | Stock | 29.76 | 29.7625 | 29.76 | 29.7625 | 2400.0 |
| 2014-12-01 07:15:00 | AAPL | Stock | 29.74 | 29.74 | 29.725 | 29.7275 | 9600.0 |
| 2014-12-01 07:20:00 | AAPL | Stock | 29.7175 | 29.7175 | 29.7175 | 29.7175 | 800.0 |
| 2014-12-01 07:25:00 | AAPL | Stock | 29.7075 | 29.7075 | 29.7 | 29.7 | 8300.0 |
| 2014-12-01 07:30:00 | AAPL | Stock | 29.68 | 29.6875 | 29.675 | 29.6875 | 26800.0 |
| 2014-12-01 07:40:00 | AAPL | Stock | 29.68 | 29.68 | 29.6675 | 29.6775 | 17084.0 |
| 2014-12-01 07:45:00 | AAPL | Stock | 29.6725 | 29.68 | 29.6725 | 29.68 | 5120.0 |
| 2014-12-01 07:50:00 | AAPL | Stock | 29.6775 | 29.68 | 29.6725 | 29.675 | 8220.0 |
| 2014-12-01 07:55:00 | AAPL | Stock | 29.6675 | 29.6675 | 29.645 | 29.645 | 31456.0 |
| 2014-12-01 08:00:00 | AAPL | Stock | 29.6575 | 29.74 | 29.625 | 29.6325 | 143704.0 |
| 2014-12-01 08:05:00 | AAPL | Stock | 29.64 | 29.65 | 29.6325 | 29.65 | 66296.0 |
| 2014-12-01 08:10:00 | AAPL | Stock | 29.65 | 29.65 | 29.605 | 29.625 | 101968.0 |
| 2014-12-01 08:15:00 | AAPL | Stock | 29.635 | 29.66 | 29.625 | 29.6575 | 40200.0 |
| 2014-12-01 08:20:00 | AAPL | Stock | 29.6575 | 29.67 | 29.6425 | 29.645 | 64400.0 |
| 2014-12-01 08:25:00 | AAPL | Stock | 29.6425 | 29.67 | 29.6425 | 29.67 | 53000.0 |
| 2014-12-01 08:30:00 | AAPL | Stock | 29.67 | 29.68 | 29.67 | 29.6775 | 56200.0 |
| 2014-12-01 08:35:00 | AAPL | Stock | 29.6625 | 29.7325 | 29.6625 | 29.69 | 72976.0 |
| 2014-12-01 08:40:00 | AAPL | Stock | 29.69 | 29.7125 | 29.6825 | 29.695 | 60808.0 |
| 2014-12-01 08:45:00 | AAPL | Stock | 29.6875 | 29.6925 | 29.6425 | 29.655 | 81432.0 |
| 2014-12-01 08:50:00 | AAPL | Stock | 29.655 | 29.655 | 29.6325 | 29.6475 | 52476.0 |
| 2014-12-01 08:55:00 | AAPL | Stock | 29.645 | 29.645 | 29.6275 | 29.64 | 39504.0 |
| 2014-12-01 09:00:00 | AAPL | Stock | 29.6475 | 29.6575 | 29.6375 | 29.6375 | 16680.0 |
| 2014-12-01 09:05:00 | AAPL | Stock | 29.635 | 29.6525 | 29.635 | 29.6425 | 18900.0 |
| 2014-12-01 09:10:00 | AAPL | Stock | 29.6375 | 29.66 | 29.6375 | 29.66 | 15800.0 |
| 2014-12-01 09:15:00 | AAPL | Stock | 29.66 | 29.66 | 29.6525 | 29.6525 | 12092.0 |
| 2014-12-01 09:20:00 | AAPL | Stock | 29.6502 | 29.6725 | 29.645 | 29.6725 | 47616.0 |
| 2014-12-01 09:25:00 | AAPL | Stock | 29.6725 | 29.73 | 29.6725 | 29.705 | 132924.0 |
| 2014-12-01 09:30:00 | AAPL | Stock | 29.7025 | 29.8125 | 29.65 | 29.7725 | 9131896.0 |
| 2014-12-01 09:35:00 | AAPL | Stock | 29.7795 | 29.79 | 29.6875 | 29.695 | 3541900.0 |
| 2014-12-01 09:40:00 | AAPL | Stock | 29.695 | 29.6975 | 29.5125 | 29.5552 | 6987812.0 |
| 2014-12-01 09:45:00 | AAPL | Stock | 29.5575 | 29.57 | 29.195 | 29.21 | 10129580.0 |
| 2014-12-01 09:50:00 | AAPL | Stock | 29.21 | 29.3052 | 27.8175 | 28.8675 | 48873136.0 |
| 2014-12-01 09:55:00 | AAPL | Stock | 28.865 | 29.025 | 28.765 | 28.955 | 14066484.0 |
| 2014-12-01 10:00:00 | AAPL | Stock | 28.9575 | 28.9875 | 28.785 | 28.885 | 8716312.0 |
| 2014-12-01 10:05:00 | AAPL | Stock | 28.865 | 28.9425 | 28.63 | 28.645 | 9926788.0 |
| 2014-12-01 10:10:00 | AAPL | Stock | 28.65 | 28.845 | 28.605 | 28.83 | 10296184.0 |
> showing 50 of 374,024 rows — these rows as CSV