PREVIEW / stock_5min / 2015-10-08
file: by_date/stock_5min/2015/2015-10-08.parquet size: 5.4 MB rows: 356,432 symbols: 3,423
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-08 04:00:00 | AAPL | Stock | 27.5275 | 27.5275 | 27.5275 | 27.5275 | 7720.0 |
| 2015-10-08 04:05:00 | AAPL | Stock | 27.5125 | 27.56 | 27.5125 | 27.5375 | 1600.0 |
| 2015-10-08 04:20:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 5200.0 |
| 2015-10-08 04:25:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 2800.0 |
| 2015-10-08 04:30:00 | AAPL | Stock | 27.5125 | 27.5125 | 27.5125 | 27.5125 | 11016.0 |
| 2015-10-08 04:35:00 | AAPL | Stock | 27.56 | 27.56 | 27.56 | 27.56 | 400.0 |
| 2015-10-08 04:45:00 | AAPL | Stock | 27.5575 | 27.5575 | 27.5575 | 27.5575 | 1200.0 |
| 2015-10-08 04:50:00 | AAPL | Stock | 27.5575 | 27.5625 | 27.5575 | 27.56 | 6400.0 |
| 2015-10-08 05:05:00 | AAPL | Stock | 27.55 | 27.5525 | 27.55 | 27.5525 | 2404.0 |
| 2015-10-08 05:10:00 | AAPL | Stock | 27.5525 | 27.5525 | 27.5525 | 27.5525 | 1204.0 |
| 2015-10-08 05:20:00 | AAPL | Stock | 27.58 | 27.58 | 27.58 | 27.58 | 844.0 |
| 2015-10-08 06:05:00 | AAPL | Stock | 27.6125 | 27.6125 | 27.58 | 27.58 | 4800.0 |
| 2015-10-08 06:25:00 | AAPL | Stock | 27.595 | 27.595 | 27.595 | 27.595 | 800.0 |
| 2015-10-08 06:30:00 | AAPL | Stock | 27.575 | 27.5775 | 27.575 | 27.5775 | 3796.0 |
| 2015-10-08 06:35:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 400.0 |
| 2015-10-08 06:40:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 5600.0 |
| 2015-10-08 07:05:00 | AAPL | Stock | 27.6075 | 27.61 | 27.6075 | 27.61 | 2000.0 |
| 2015-10-08 07:10:00 | AAPL | Stock | 27.61 | 27.61 | 27.6 | 27.6 | 15500.0 |
| 2015-10-08 07:15:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 400.0 |
| 2015-10-08 07:30:00 | AAPL | Stock | 27.61 | 27.61 | 27.61 | 27.61 | 1200.0 |
| 2015-10-08 07:35:00 | AAPL | Stock | 27.6225 | 27.6725 | 27.6225 | 27.63 | 4400.0 |
| 2015-10-08 07:40:00 | AAPL | Stock | 27.6325 | 27.65 | 27.6325 | 27.645 | 11180.0 |
| 2015-10-08 07:45:00 | AAPL | Stock | 27.64 | 27.64 | 27.6025 | 27.62 | 6000.0 |
| 2015-10-08 07:50:00 | AAPL | Stock | 27.625 | 27.635 | 27.625 | 27.6325 | 2800.0 |
| 2015-10-08 07:55:00 | AAPL | Stock | 27.6325 | 27.65 | 27.63 | 27.65 | 9600.0 |
| 2015-10-08 08:00:00 | AAPL | Stock | 27.635 | 27.655 | 27.5775 | 27.65 | 33032.0 |
| 2015-10-08 08:05:00 | AAPL | Stock | 27.64 | 27.665 | 27.64 | 27.65 | 15160.0 |
| 2015-10-08 08:10:00 | AAPL | Stock | 27.6525 | 27.67 | 27.625 | 27.625 | 45928.0 |
| 2015-10-08 08:15:00 | AAPL | Stock | 27.6325 | 27.645 | 27.62 | 27.6275 | 10000.0 |
| 2015-10-08 08:20:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 3104.0 |
| 2015-10-08 08:25:00 | AAPL | Stock | 27.6325 | 27.6325 | 27.625 | 27.6275 | 3796.0 |
| 2015-10-08 08:30:00 | AAPL | Stock | 27.65 | 27.65 | 27.5825 | 27.5825 | 31324.0 |
| 2015-10-08 08:35:00 | AAPL | Stock | 27.6 | 27.6 | 27.595 | 27.595 | 6000.0 |
| 2015-10-08 08:40:00 | AAPL | Stock | 27.5975 | 27.6175 | 27.5775 | 27.5875 | 33280.0 |
| 2015-10-08 08:45:00 | AAPL | Stock | 27.5875 | 27.6075 | 27.5775 | 27.59 | 45476.0 |
| 2015-10-08 08:50:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.58 | 27.5825 | 2400.0 |
| 2015-10-08 08:55:00 | AAPL | Stock | 27.595 | 27.5975 | 27.5825 | 27.5975 | 13788.0 |
| 2015-10-08 09:00:00 | AAPL | Stock | 27.5825 | 27.585 | 27.5775 | 27.5775 | 10808.0 |
| 2015-10-08 09:05:00 | AAPL | Stock | 27.575 | 27.5875 | 27.5675 | 27.58 | 20800.0 |
| 2015-10-08 09:10:00 | AAPL | Stock | 27.575 | 27.585 | 27.575 | 27.575 | 26532.0 |
| 2015-10-08 09:15:00 | AAPL | Stock | 27.575 | 27.5875 | 27.5675 | 27.5875 | 18980.0 |
| 2015-10-08 09:20:00 | AAPL | Stock | 27.5875 | 27.5925 | 27.5875 | 27.59 | 9400.0 |
| 2015-10-08 09:25:00 | AAPL | Stock | 27.5925 | 27.5975 | 27.5325 | 27.535 | 232596.0 |
| 2015-10-08 09:30:00 | AAPL | Stock | 27.5475 | 27.5475 | 27.2575 | 27.3002 | 10077452.0 |
| 2015-10-08 09:35:00 | AAPL | Stock | 27.3 | 27.4025 | 27.2775 | 27.3212 | 4910948.0 |
| 2015-10-08 09:40:00 | AAPL | Stock | 27.32 | 27.4525 | 27.3125 | 27.4325 | 5437264.0 |
| 2015-10-08 09:45:00 | AAPL | Stock | 27.4325 | 27.48 | 27.35 | 27.365 | 4799512.0 |
| 2015-10-08 09:50:00 | AAPL | Stock | 27.3675 | 27.385 | 27.3 | 27.33 | 4950772.0 |
| 2015-10-08 09:55:00 | AAPL | Stock | 27.3325 | 27.3725 | 27.23 | 27.2525 | 5754496.0 |
| 2015-10-08 10:00:00 | AAPL | Stock | 27.25 | 27.2525 | 27.185 | 27.245 | 6315792.0 |
> showing 50 of 356,432 rows — these rows as CSV