PREVIEW / stock_5min / 2015-01-06
file: by_date/stock_5min/2015/2015-01-06.parquet size: 5.7 MB rows: 374,308 symbols: 3,546
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-01-06 04:00:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 13720.0 |
| 2015-01-06 04:05:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 2000.0 |
| 2015-01-06 04:20:00 | AAPL | Stock | 26.55 | 26.55 | 26.55 | 26.55 | 1600.0 |
| 2015-01-06 04:35:00 | AAPL | Stock | 26.525 | 26.525 | 26.525 | 26.525 | 1840.0 |
| 2015-01-06 04:45:00 | AAPL | Stock | 26.525 | 26.55 | 26.525 | 26.525 | 4472.0 |
| 2015-01-06 04:55:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 6000.0 |
| 2015-01-06 05:00:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 1300.0 |
| 2015-01-06 05:05:00 | AAPL | Stock | 26.465 | 26.465 | 26.465 | 26.465 | 400.0 |
| 2015-01-06 05:15:00 | AAPL | Stock | 26.475 | 26.475 | 26.475 | 26.475 | 1600.0 |
| 2015-01-06 05:20:00 | AAPL | Stock | 26.4625 | 26.4825 | 26.4625 | 26.4625 | 1760.0 |
| 2015-01-06 05:30:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 5900.0 |
| 2015-01-06 05:40:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.5125 | 26.5125 | 792.0 |
| 2015-01-06 05:45:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.5125 | 26.5125 | 400.0 |
| 2015-01-06 05:50:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 1148.0 |
| 2015-01-06 06:00:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 800.0 |
| 2015-01-06 06:05:00 | AAPL | Stock | 26.5 | 26.5225 | 26.5 | 26.5225 | 2476.0 |
| 2015-01-06 06:10:00 | AAPL | Stock | 26.5475 | 26.5475 | 26.545 | 26.5475 | 3040.0 |
| 2015-01-06 06:15:00 | AAPL | Stock | 26.625 | 26.625 | 26.6075 | 26.6075 | 3800.0 |
| 2015-01-06 06:20:00 | AAPL | Stock | 26.5875 | 26.6225 | 26.5875 | 26.6225 | 9508.0 |
| 2015-01-06 06:30:00 | AAPL | Stock | 26.67 | 26.67 | 26.67 | 26.67 | 400.0 |
| 2015-01-06 06:35:00 | AAPL | Stock | 26.67 | 26.67 | 26.67 | 26.67 | 400.0 |
| 2015-01-06 06:40:00 | AAPL | Stock | 26.7025 | 26.75 | 26.7025 | 26.75 | 7200.0 |
| 2015-01-06 06:45:00 | AAPL | Stock | 26.735 | 26.75 | 26.725 | 26.725 | 8608.0 |
| 2015-01-06 06:50:00 | AAPL | Stock | 26.7475 | 26.7475 | 26.7475 | 26.7475 | 400.0 |
| 2015-01-06 07:00:00 | AAPL | Stock | 26.73 | 26.805 | 26.73 | 26.79 | 42000.0 |
| 2015-01-06 07:05:00 | AAPL | Stock | 26.7625 | 26.7625 | 26.72 | 26.725 | 15720.0 |
| 2015-01-06 07:10:00 | AAPL | Stock | 26.7375 | 26.75 | 26.725 | 26.725 | 5328.0 |
| 2015-01-06 07:15:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7 | 26.7 | 2568.0 |
| 2015-01-06 07:25:00 | AAPL | Stock | 26.6975 | 26.7 | 26.6975 | 26.7 | 2400.0 |
| 2015-01-06 07:30:00 | AAPL | Stock | 26.7175 | 26.7175 | 26.7025 | 26.7025 | 820.0 |
| 2015-01-06 07:35:00 | AAPL | Stock | 26.7125 | 26.735 | 26.7125 | 26.725 | 14632.0 |
| 2015-01-06 07:40:00 | AAPL | Stock | 26.7375 | 26.7375 | 26.705 | 26.7125 | 16780.0 |
| 2015-01-06 07:45:00 | AAPL | Stock | 26.705 | 26.705 | 26.6875 | 26.6875 | 10224.0 |
| 2015-01-06 07:50:00 | AAPL | Stock | 26.675 | 26.7 | 26.675 | 26.7 | 6972.0 |
| 2015-01-06 07:55:00 | AAPL | Stock | 26.695 | 26.695 | 26.6875 | 26.6875 | 1200.0 |
| 2015-01-06 08:00:00 | AAPL | Stock | 26.6975 | 26.7525 | 26.5 | 26.705 | 75012.0 |
| 2015-01-06 08:05:00 | AAPL | Stock | 26.705 | 26.7375 | 26.705 | 26.7375 | 51088.0 |
| 2015-01-06 08:10:00 | AAPL | Stock | 26.7375 | 26.74 | 26.7 | 26.715 | 25880.0 |
| 2015-01-06 08:15:00 | AAPL | Stock | 26.72 | 26.73 | 26.6975 | 26.7 | 47408.0 |
| 2015-01-06 08:20:00 | AAPL | Stock | 26.6975 | 26.6975 | 26.65 | 26.65 | 54236.0 |
| 2015-01-06 08:25:00 | AAPL | Stock | 26.65 | 26.675 | 26.65 | 26.6575 | 43712.0 |
| 2015-01-06 08:30:00 | AAPL | Stock | 26.66 | 26.66 | 26.625 | 26.65 | 93620.0 |
| 2015-01-06 08:35:00 | AAPL | Stock | 26.63 | 26.6475 | 26.615 | 26.6275 | 107456.0 |
| 2015-01-06 08:40:00 | AAPL | Stock | 26.6275 | 26.6325 | 26.6 | 26.6025 | 73168.0 |
| 2015-01-06 08:45:00 | AAPL | Stock | 26.6125 | 26.625 | 26.6075 | 26.625 | 54320.0 |
| 2015-01-06 08:50:00 | AAPL | Stock | 26.615 | 26.6325 | 26.5875 | 26.5875 | 165816.0 |
| 2015-01-06 08:55:00 | AAPL | Stock | 26.58 | 26.6075 | 26.5725 | 26.59 | 27008.0 |
| 2015-01-06 09:00:00 | AAPL | Stock | 26.585 | 26.6125 | 26.575 | 26.61 | 52636.0 |
| 2015-01-06 09:05:00 | AAPL | Stock | 26.605 | 26.625 | 26.605 | 26.6225 | 86980.0 |
| 2015-01-06 09:10:00 | AAPL | Stock | 26.625 | 26.625 | 26.605 | 26.61 | 51240.0 |
> showing 50 of 374,308 rows — these rows as CSV