PREVIEW / stock_5min / 2015-10-09
file: by_date/stock_5min/2015/2015-10-09.parquet size: 5.3 MB rows: 349,914 symbols: 3,405
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-10-09 04:00:00 | AAPL | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 1532.0 |
| 2015-10-09 05:45:00 | AAPL | Stock | 27.395 | 27.395 | 27.395 | 27.395 | 400.0 |
| 2015-10-09 05:50:00 | AAPL | Stock | 27.395 | 27.3975 | 27.395 | 27.3975 | 1600.0 |
| 2015-10-09 05:55:00 | AAPL | Stock | 27.4225 | 27.4475 | 27.4225 | 27.425 | 4000.0 |
| 2015-10-09 06:10:00 | AAPL | Stock | 27.4175 | 27.4175 | 27.4175 | 27.4175 | 400.0 |
| 2015-10-09 06:30:00 | AAPL | Stock | 27.4125 | 27.425 | 27.4125 | 27.425 | 1600.0 |
| 2015-10-09 06:35:00 | AAPL | Stock | 27.4275 | 27.45 | 27.4275 | 27.45 | 3300.0 |
| 2015-10-09 06:40:00 | AAPL | Stock | 27.425 | 27.425 | 27.425 | 27.425 | 400.0 |
| 2015-10-09 06:55:00 | AAPL | Stock | 27.46 | 27.46 | 27.46 | 27.46 | 400.0 |
| 2015-10-09 07:00:00 | AAPL | Stock | 27.4475 | 27.4475 | 27.425 | 27.425 | 2400.0 |
| 2015-10-09 07:05:00 | AAPL | Stock | 27.425 | 27.4475 | 27.425 | 27.4475 | 9480.0 |
| 2015-10-09 07:20:00 | AAPL | Stock | 27.4775 | 27.485 | 27.4675 | 27.4675 | 6360.0 |
| 2015-10-09 07:25:00 | AAPL | Stock | 27.4625 | 27.4675 | 27.4625 | 27.4675 | 4000.0 |
| 2015-10-09 07:30:00 | AAPL | Stock | 27.4675 | 27.4675 | 27.4675 | 27.4675 | 840.0 |
| 2015-10-09 07:35:00 | AAPL | Stock | 27.4775 | 27.5175 | 27.4775 | 27.5175 | 34080.0 |
| 2015-10-09 07:40:00 | AAPL | Stock | 27.49 | 27.5075 | 27.485 | 27.485 | 15880.0 |
| 2015-10-09 07:45:00 | AAPL | Stock | 27.4775 | 27.485 | 27.4675 | 27.4675 | 16340.0 |
| 2015-10-09 07:50:00 | AAPL | Stock | 27.48 | 27.48 | 27.4675 | 27.4675 | 2800.0 |
| 2015-10-09 07:55:00 | AAPL | Stock | 27.465 | 27.47 | 27.465 | 27.47 | 2400.0 |
| 2015-10-09 08:00:00 | AAPL | Stock | 27.4675 | 27.5075 | 27.4375 | 27.46 | 120168.0 |
| 2015-10-09 08:05:00 | AAPL | Stock | 27.4625 | 27.475 | 27.45 | 27.4625 | 36508.0 |
| 2015-10-09 08:10:00 | AAPL | Stock | 27.46 | 27.48 | 27.46 | 27.48 | 18156.0 |
| 2015-10-09 08:15:00 | AAPL | Stock | 27.475 | 27.4925 | 27.45 | 27.4925 | 54304.0 |
| 2015-10-09 08:20:00 | AAPL | Stock | 27.4925 | 27.5 | 27.4825 | 27.4925 | 60260.0 |
| 2015-10-09 08:25:00 | AAPL | Stock | 27.4925 | 27.495 | 27.4825 | 27.49 | 32468.0 |
| 2015-10-09 08:30:00 | AAPL | Stock | 27.4925 | 27.5 | 27.4875 | 27.4875 | 50820.0 |
| 2015-10-09 08:35:00 | AAPL | Stock | 27.49 | 27.5 | 27.49 | 27.5 | 19704.0 |
| 2015-10-09 08:40:00 | AAPL | Stock | 27.505 | 27.5075 | 27.495 | 27.5 | 14796.0 |
| 2015-10-09 08:45:00 | AAPL | Stock | 27.5075 | 27.5075 | 27.4925 | 27.495 | 12800.0 |
| 2015-10-09 08:50:00 | AAPL | Stock | 27.49 | 27.5 | 27.49 | 27.495 | 24896.0 |
| 2015-10-09 08:55:00 | AAPL | Stock | 27.49 | 27.4975 | 27.485 | 27.485 | 20492.0 |
| 2015-10-09 09:00:00 | AAPL | Stock | 27.4825 | 27.51 | 27.4625 | 27.5025 | 132876.0 |
| 2015-10-09 09:05:00 | AAPL | Stock | 27.5025 | 27.5425 | 27.47 | 27.535 | 142576.0 |
| 2015-10-09 09:10:00 | AAPL | Stock | 27.5275 | 27.5425 | 27.52 | 27.535 | 22048.0 |
| 2015-10-09 09:15:00 | AAPL | Stock | 27.535 | 27.535 | 27.5 | 27.5125 | 59220.0 |
| 2015-10-09 09:20:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.4725 | 27.4775 | 37896.0 |
| 2015-10-09 09:25:00 | AAPL | Stock | 27.475 | 27.525 | 27.45 | 27.525 | 320216.0 |
| 2015-10-09 09:30:00 | AAPL | Stock | 27.5 | 27.6 | 27.425 | 27.465 | 7290508.0 |
| 2015-10-09 09:35:00 | AAPL | Stock | 27.465 | 27.5375 | 27.3725 | 27.52 | 4630720.0 |
| 2015-10-09 09:40:00 | AAPL | Stock | 27.5212 | 27.6275 | 27.4725 | 27.625 | 4619932.0 |
| 2015-10-09 09:45:00 | AAPL | Stock | 27.622 | 27.6275 | 27.5375 | 27.5675 | 3436508.0 |
| 2015-10-09 09:50:00 | AAPL | Stock | 27.57 | 27.635 | 27.5425 | 27.585 | 3979660.0 |
| 2015-10-09 09:55:00 | AAPL | Stock | 27.585 | 27.63 | 27.5575 | 27.5825 | 3971768.0 |
| 2015-10-09 10:00:00 | AAPL | Stock | 27.5848 | 27.62 | 27.565 | 27.61 | 2696788.0 |
| 2015-10-09 10:05:00 | AAPL | Stock | 27.61 | 27.6125 | 27.565 | 27.596 | 2794500.0 |
| 2015-10-09 10:10:00 | AAPL | Stock | 27.595 | 27.685 | 27.575 | 27.675 | 4509684.0 |
| 2015-10-09 10:15:00 | AAPL | Stock | 27.675 | 27.75 | 27.6675 | 27.7415 | 4260672.0 |
| 2015-10-09 10:20:00 | AAPL | Stock | 27.74 | 27.7875 | 27.7375 | 27.7522 | 3800800.0 |
| 2015-10-09 10:25:00 | AAPL | Stock | 27.7525 | 27.8425 | 27.745 | 27.7975 | 4714660.0 |
| 2015-10-09 10:30:00 | AAPL | Stock | 27.7975 | 27.88 | 27.795 | 27.8625 | 4543328.0 |
> showing 50 of 349,914 rows — these rows as CSV