PREVIEW / stock_5min / 2015-07-15
file: by_date/stock_5min/2015/2015-07-15.parquet size: 5.4 MB rows: 361,295 symbols: 3,489
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-07-15 04:00:00 | AAPL | Stock | 31.4825 | 31.4825 | 31.4825 | 31.4825 | 800.0 |
| 2015-07-15 04:05:00 | AAPL | Stock | 31.4825 | 31.4825 | 31.4825 | 31.4825 | 400.0 |
| 2015-07-15 04:15:00 | AAPL | Stock | 31.505 | 31.505 | 31.505 | 31.505 | 2000.0 |
| 2015-07-15 04:35:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 400.0 |
| 2015-07-15 04:40:00 | AAPL | Stock | 31.5425 | 31.5425 | 31.5075 | 31.5075 | 3200.0 |
| 2015-07-15 05:15:00 | AAPL | Stock | 31.505 | 31.505 | 31.505 | 31.505 | 2400.0 |
| 2015-07-15 05:30:00 | AAPL | Stock | 31.505 | 31.505 | 31.505 | 31.505 | 452.0 |
| 2015-07-15 05:45:00 | AAPL | Stock | 31.4725 | 31.4725 | 31.4725 | 31.4725 | 400.0 |
| 2015-07-15 06:00:00 | AAPL | Stock | 31.4075 | 31.4075 | 31.4075 | 31.4075 | 400.0 |
| 2015-07-15 06:15:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.435 | 31.435 | 4252.0 |
| 2015-07-15 06:25:00 | AAPL | Stock | 31.42 | 31.42 | 31.42 | 31.42 | 400.0 |
| 2015-07-15 07:15:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.475 | 31.475 | 5200.0 |
| 2015-07-15 07:20:00 | AAPL | Stock | 31.4825 | 31.485 | 31.46 | 31.4725 | 10592.0 |
| 2015-07-15 07:25:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 3128.0 |
| 2015-07-15 07:35:00 | AAPL | Stock | 31.465 | 31.465 | 31.465 | 31.465 | 3040.0 |
| 2015-07-15 07:40:00 | AAPL | Stock | 31.4725 | 31.475 | 31.4725 | 31.475 | 13944.0 |
| 2015-07-15 07:50:00 | AAPL | Stock | 31.4825 | 31.4925 | 31.4825 | 31.4925 | 22368.0 |
| 2015-07-15 07:55:00 | AAPL | Stock | 31.4975 | 31.5025 | 31.4975 | 31.5 | 13932.0 |
| 2015-07-15 08:00:00 | AAPL | Stock | 31.4975 | 31.5012 | 31.4075 | 31.4768 | 84508.0 |
| 2015-07-15 08:05:00 | AAPL | Stock | 31.4775 | 31.485 | 31.475 | 31.4795 | 36748.0 |
| 2015-07-15 08:10:00 | AAPL | Stock | 31.4842 | 31.4875 | 31.4825 | 31.4875 | 9000.0 |
| 2015-07-15 08:15:00 | AAPL | Stock | 31.495 | 31.4975 | 31.49 | 31.4975 | 10000.0 |
| 2015-07-15 08:20:00 | AAPL | Stock | 31.4875 | 31.5025 | 31.4875 | 31.5025 | 26852.0 |
| 2015-07-15 08:25:00 | AAPL | Stock | 31.5025 | 31.505 | 31.5 | 31.5 | 50520.0 |
| 2015-07-15 08:30:00 | AAPL | Stock | 31.4925 | 31.5 | 31.485 | 31.4975 | 31968.0 |
| 2015-07-15 08:35:00 | AAPL | Stock | 31.49 | 31.4975 | 31.4825 | 31.4975 | 15204.0 |
| 2015-07-15 08:40:00 | AAPL | Stock | 31.4975 | 31.5 | 31.4925 | 31.4925 | 22908.0 |
| 2015-07-15 08:45:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.475 | 31.475 | 36644.0 |
| 2015-07-15 08:50:00 | AAPL | Stock | 31.485 | 31.485 | 31.4775 | 31.4775 | 2900.0 |
| 2015-07-15 08:55:00 | AAPL | Stock | 31.485 | 31.485 | 31.475 | 31.4775 | 4880.0 |
| 2015-07-15 09:00:00 | AAPL | Stock | 31.475 | 31.485 | 31.45 | 31.4625 | 17864.0 |
| 2015-07-15 09:05:00 | AAPL | Stock | 31.4625 | 31.475 | 31.4625 | 31.4625 | 12668.0 |
| 2015-07-15 09:10:00 | AAPL | Stock | 31.4625 | 31.465 | 31.45 | 31.4592 | 30820.0 |
| 2015-07-15 09:15:00 | AAPL | Stock | 31.45 | 31.4575 | 31.45 | 31.45 | 25132.0 |
| 2015-07-15 09:20:00 | AAPL | Stock | 31.4625 | 31.465 | 31.45 | 31.465 | 14612.0 |
| 2015-07-15 09:25:00 | AAPL | Stock | 31.4625 | 31.47 | 31.4175 | 31.43 | 73648.0 |
| 2015-07-15 09:30:00 | AAPL | Stock | 31.43 | 31.54 | 31.4025 | 31.5265 | 5303992.0 |
| 2015-07-15 09:35:00 | AAPL | Stock | 31.53 | 31.5475 | 31.395 | 31.4075 | 3902284.0 |
| 2015-07-15 09:40:00 | AAPL | Stock | 31.4088 | 31.4488 | 31.405 | 31.4365 | 2551808.0 |
| 2015-07-15 09:45:00 | AAPL | Stock | 31.4375 | 31.5 | 31.42 | 31.4775 | 3236420.0 |
| 2015-07-15 09:50:00 | AAPL | Stock | 31.475 | 31.525 | 31.455 | 31.51 | 2523092.0 |
| 2015-07-15 09:55:00 | AAPL | Stock | 31.5125 | 31.545 | 31.5 | 31.504 | 2160268.0 |
| 2015-07-15 10:00:00 | AAPL | Stock | 31.505 | 31.5375 | 31.4925 | 31.5325 | 1263148.0 |
| 2015-07-15 10:05:00 | AAPL | Stock | 31.5312 | 31.65 | 31.5175 | 31.6275 | 4667232.0 |
| 2015-07-15 10:10:00 | AAPL | Stock | 31.6322 | 31.6725 | 31.6 | 31.6388 | 2701972.0 |
| 2015-07-15 10:15:00 | AAPL | Stock | 31.635 | 31.6538 | 31.615 | 31.6275 | 1847700.0 |
| 2015-07-15 10:20:00 | AAPL | Stock | 31.627 | 31.635 | 31.6 | 31.62 | 1876860.0 |
| 2015-07-15 10:25:00 | AAPL | Stock | 31.62 | 31.625 | 31.5862 | 31.59 | 1417376.0 |
| 2015-07-15 10:30:00 | AAPL | Stock | 31.589 | 31.6375 | 31.5875 | 31.6342 | 1934720.0 |
| 2015-07-15 10:35:00 | AAPL | Stock | 31.6355 | 31.6562 | 31.625 | 31.6488 | 1987388.0 |
> showing 50 of 361,295 rows — these rows as CSV