PREVIEW / stock_1min / 2015-03-31
file: by_date/stock_1min/2015/2015-03-31.parquet size: 14.8 MB rows: 1,076,778 symbols: 2,884
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-03-31 04:00:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 1060.0 |
| 2015-03-31 04:02:00 | AAPL | Stock | 31.565 | 31.565 | 31.565 | 31.565 | 1148.0 |
| 2015-03-31 04:18:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 2000.0 |
| 2015-03-31 04:33:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 2800.0 |
| 2015-03-31 04:57:00 | AAPL | Stock | 31.6 | 31.6 | 31.6 | 31.6 | 2000.0 |
| 2015-03-31 06:00:00 | AAPL | Stock | 31.5225 | 31.5225 | 31.5225 | 31.5225 | 1200.0 |
| 2015-03-31 06:02:00 | AAPL | Stock | 31.46 | 31.46 | 31.46 | 31.46 | 1700.0 |
| 2015-03-31 06:03:00 | AAPL | Stock | 31.455 | 31.4725 | 31.4275 | 31.4725 | 6904.0 |
| 2015-03-31 06:04:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.3775 | 31.3775 | 2000.0 |
| 2015-03-31 06:10:00 | AAPL | Stock | 31.485 | 31.485 | 31.485 | 31.485 | 1600.0 |
| 2015-03-31 06:11:00 | AAPL | Stock | 31.485 | 31.485 | 31.485 | 31.485 | 400.0 |
| 2015-03-31 06:15:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.4875 | 31.4875 | 1000.0 |
| 2015-03-31 06:23:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 1632.0 |
| 2015-03-31 06:37:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 1600.0 |
| 2015-03-31 06:40:00 | AAPL | Stock | 31.4875 | 31.5 | 31.4875 | 31.5 | 5200.0 |
| 2015-03-31 06:44:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.47 | 31.47 | 2000.0 |
| 2015-03-31 06:45:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 1600.0 |
| 2015-03-31 06:49:00 | AAPL | Stock | 31.4975 | 31.4975 | 31.4975 | 31.4975 | 2556.0 |
| 2015-03-31 06:55:00 | AAPL | Stock | 31.5 | 31.5 | 31.5 | 31.5 | 7628.0 |
| 2015-03-31 06:57:00 | AAPL | Stock | 31.4975 | 31.5 | 31.4975 | 31.5 | 1400.0 |
| 2015-03-31 06:59:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 800.0 |
| 2015-03-31 07:00:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 800.0 |
| 2015-03-31 07:01:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.46 | 31.46 | 1200.0 |
| 2015-03-31 07:02:00 | AAPL | Stock | 31.47 | 31.47 | 31.45 | 31.4525 | 14584.0 |
| 2015-03-31 07:03:00 | AAPL | Stock | 31.4525 | 31.4525 | 31.45 | 31.45 | 1516.0 |
| 2015-03-31 07:06:00 | AAPL | Stock | 31.44 | 31.44 | 31.4275 | 31.4275 | 4284.0 |
| 2015-03-31 07:07:00 | AAPL | Stock | 31.4375 | 31.45 | 31.4375 | 31.4375 | 9672.0 |
| 2015-03-31 07:08:00 | AAPL | Stock | 31.4375 | 31.4375 | 31.4375 | 31.4375 | 3200.0 |
| 2015-03-31 07:09:00 | AAPL | Stock | 31.4375 | 31.4375 | 31.4375 | 31.4375 | 400.0 |
| 2015-03-31 07:10:00 | AAPL | Stock | 31.4375 | 31.45 | 31.4375 | 31.45 | 6016.0 |
| 2015-03-31 07:12:00 | AAPL | Stock | 31.45 | 31.45 | 31.4425 | 31.4425 | 2400.0 |
| 2015-03-31 07:14:00 | AAPL | Stock | 31.45 | 31.45 | 31.4375 | 31.4375 | 5200.0 |
| 2015-03-31 07:19:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 1600.0 |
| 2015-03-31 07:23:00 | AAPL | Stock | 31.475 | 31.475 | 31.475 | 31.475 | 1200.0 |
| 2015-03-31 07:26:00 | AAPL | Stock | 31.4625 | 31.475 | 31.4625 | 31.4625 | 2800.0 |
| 2015-03-31 07:29:00 | AAPL | Stock | 31.455 | 31.455 | 31.4475 | 31.4475 | 4840.0 |
| 2015-03-31 07:37:00 | AAPL | Stock | 31.4725 | 31.475 | 31.4725 | 31.475 | 5200.0 |
| 2015-03-31 07:38:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 1200.0 |
| 2015-03-31 07:39:00 | AAPL | Stock | 31.475 | 31.475 | 31.4625 | 31.4625 | 11632.0 |
| 2015-03-31 07:40:00 | AAPL | Stock | 31.475 | 31.475 | 31.475 | 31.475 | 820.0 |
| 2015-03-31 07:41:00 | AAPL | Stock | 31.475 | 31.475 | 31.475 | 31.475 | 5464.0 |
| 2015-03-31 07:42:00 | AAPL | Stock | 31.4575 | 31.46 | 31.45 | 31.45 | 40676.0 |
| 2015-03-31 07:43:00 | AAPL | Stock | 31.45 | 31.4575 | 31.45 | 31.4525 | 2000.0 |
| 2015-03-31 07:44:00 | AAPL | Stock | 31.4575 | 31.4575 | 31.4575 | 31.4575 | 1600.0 |
| 2015-03-31 07:45:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 400.0 |
| 2015-03-31 07:46:00 | AAPL | Stock | 31.4725 | 31.4725 | 31.4725 | 31.4725 | 400.0 |
| 2015-03-31 07:47:00 | AAPL | Stock | 31.4475 | 31.4475 | 31.4475 | 31.4475 | 800.0 |
| 2015-03-31 07:49:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 3600.0 |
| 2015-03-31 07:50:00 | AAPL | Stock | 31.4575 | 31.4575 | 31.4575 | 31.4575 | 400.0 |
| 2015-03-31 07:51:00 | AAPL | Stock | 31.445 | 31.445 | 31.445 | 31.445 | 400.0 |
> showing 50 of 1,076,778 rows — these rows as CSV