PREVIEW / stock_5min / 2016-07-06
file: by_date/stock_5min/2016/2016-07-06.parquet size: 5.3 MB rows: 355,900 symbols: 3,252
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-06 04:00:00 | AAPL | Stock | 23.755 | 23.755 | 23.755 | 23.755 | 4000.0 |
| 2016-07-06 04:25:00 | AAPL | Stock | 23.7175 | 23.7175 | 23.7175 | 23.7175 | 800.0 |
| 2016-07-06 04:35:00 | AAPL | Stock | 23.7175 | 23.7175 | 23.7 | 23.7 | 1432.0 |
| 2016-07-06 04:40:00 | AAPL | Stock | 23.6925 | 23.6925 | 23.6925 | 23.6925 | 1600.0 |
| 2016-07-06 05:00:00 | AAPL | Stock | 23.68 | 23.68 | 23.68 | 23.68 | 1400.0 |
| 2016-07-06 05:05:00 | AAPL | Stock | 23.6675 | 23.6675 | 23.6675 | 23.6675 | 8200.0 |
| 2016-07-06 05:10:00 | AAPL | Stock | 23.6675 | 23.6675 | 23.6675 | 23.6675 | 16000.0 |
| 2016-07-06 05:15:00 | AAPL | Stock | 23.6675 | 23.6675 | 23.6675 | 23.6675 | 4000.0 |
| 2016-07-06 05:20:00 | AAPL | Stock | 23.6675 | 23.6675 | 23.6675 | 23.6675 | 12568.0 |
| 2016-07-06 05:30:00 | AAPL | Stock | 23.6425 | 23.6425 | 23.6425 | 23.6425 | 400.0 |
| 2016-07-06 06:10:00 | AAPL | Stock | 23.67 | 23.67 | 23.6525 | 23.6525 | 9200.0 |
| 2016-07-06 06:15:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.6525 | 23.6525 | 1292.0 |
| 2016-07-06 06:20:00 | AAPL | Stock | 23.65 | 23.65 | 23.6425 | 23.6425 | 5800.0 |
| 2016-07-06 06:25:00 | AAPL | Stock | 23.6425 | 23.6425 | 23.6175 | 23.6175 | 20780.0 |
| 2016-07-06 06:30:00 | AAPL | Stock | 23.6175 | 23.6175 | 23.6175 | 23.6175 | 3708.0 |
| 2016-07-06 06:40:00 | AAPL | Stock | 23.6175 | 23.6175 | 23.6175 | 23.6175 | 400.0 |
| 2016-07-06 06:50:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.6275 | 23.6275 | 1760.0 |
| 2016-07-06 07:00:00 | AAPL | Stock | 23.625 | 23.645 | 23.6225 | 23.645 | 12520.0 |
| 2016-07-06 07:05:00 | AAPL | Stock | 23.645 | 23.6625 | 23.645 | 23.6625 | 2800.0 |
| 2016-07-06 07:10:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 4000.0 |
| 2016-07-06 07:15:00 | AAPL | Stock | 23.655 | 23.655 | 23.655 | 23.655 | 400.0 |
| 2016-07-06 07:20:00 | AAPL | Stock | 23.6625 | 23.675 | 23.66 | 23.66 | 14116.0 |
| 2016-07-06 07:25:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 16000.0 |
| 2016-07-06 07:30:00 | AAPL | Stock | 23.66 | 23.6625 | 23.65 | 23.65 | 6400.0 |
| 2016-07-06 07:35:00 | AAPL | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 400.0 |
| 2016-07-06 07:45:00 | AAPL | Stock | 23.65 | 23.6525 | 23.65 | 23.6525 | 4200.0 |
| 2016-07-06 07:50:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 2328.0 |
| 2016-07-06 07:55:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6625 | 23.6625 | 7400.0 |
| 2016-07-06 08:00:00 | AAPL | Stock | 23.645 | 23.6625 | 23.6375 | 23.6625 | 50740.0 |
| 2016-07-06 08:05:00 | AAPL | Stock | 23.6575 | 23.68 | 23.6575 | 23.68 | 5788.0 |
| 2016-07-06 08:10:00 | AAPL | Stock | 23.6725 | 23.6725 | 23.6375 | 23.64 | 24020.0 |
| 2016-07-06 08:15:00 | AAPL | Stock | 23.6375 | 23.6425 | 23.6375 | 23.6425 | 4980.0 |
| 2016-07-06 08:20:00 | AAPL | Stock | 23.6325 | 23.6375 | 23.6325 | 23.6375 | 11800.0 |
| 2016-07-06 08:25:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6175 | 23.6225 | 62128.0 |
| 2016-07-06 08:30:00 | AAPL | Stock | 23.62 | 23.62 | 23.6125 | 23.62 | 26892.0 |
| 2016-07-06 08:35:00 | AAPL | Stock | 23.62 | 23.645 | 23.62 | 23.635 | 59532.0 |
| 2016-07-06 08:40:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.625 | 23.63 | 19692.0 |
| 2016-07-06 08:45:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.6275 | 23.6275 | 5832.0 |
| 2016-07-06 08:50:00 | AAPL | Stock | 23.625 | 23.645 | 23.625 | 23.6375 | 29808.0 |
| 2016-07-06 08:55:00 | AAPL | Stock | 23.645 | 23.65 | 23.64 | 23.65 | 8040.0 |
| 2016-07-06 09:00:00 | AAPL | Stock | 23.65 | 23.6675 | 23.65 | 23.6675 | 6280.0 |
| 2016-07-06 09:05:00 | AAPL | Stock | 23.655 | 23.655 | 23.65 | 23.65 | 16000.0 |
| 2016-07-06 09:10:00 | AAPL | Stock | 23.6475 | 23.6575 | 23.645 | 23.645 | 7140.0 |
| 2016-07-06 09:15:00 | AAPL | Stock | 23.65 | 23.6625 | 23.65 | 23.6625 | 8156.0 |
| 2016-07-06 09:20:00 | AAPL | Stock | 23.665 | 23.665 | 23.65 | 23.65 | 7200.0 |
| 2016-07-06 09:25:00 | AAPL | Stock | 23.655 | 23.655 | 23.6375 | 23.65 | 21912.0 |
| 2016-07-06 09:30:00 | AAPL | Stock | 23.65 | 23.775 | 23.625 | 23.7 | 4669384.0 |
| 2016-07-06 09:35:00 | AAPL | Stock | 23.702 | 23.725 | 23.655 | 23.7 | 2593436.0 |
| 2016-07-06 09:40:00 | AAPL | Stock | 23.7 | 23.73 | 23.6575 | 23.679 | 2530404.0 |
| 2016-07-06 09:45:00 | AAPL | Stock | 23.6788 | 23.7075 | 23.6625 | 23.675 | 1914992.0 |
> showing 50 of 355,900 rows — these rows as CSV