PREVIEW / stock_1min / 2014-11-18
file: by_date/stock_1min/2014/2014-11-18.parquet size: 14.4 MB rows: 1,057,814 symbols: 2,916
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-18 04:00:00 | AAPL | Stock | 28.4425 | 28.53 | 28.4425 | 28.4425 | 8000.0 |
| 2014-11-18 04:08:00 | AAPL | Stock | 28.465 | 28.465 | 28.4625 | 28.4625 | 1600.0 |
| 2014-11-18 04:09:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.5425 | 28.5425 | 400.0 |
| 2014-11-18 04:18:00 | AAPL | Stock | 28.51 | 28.51 | 28.51 | 28.51 | 2000.0 |
| 2014-11-18 04:27:00 | AAPL | Stock | 28.49 | 28.49 | 28.49 | 28.49 | 400.0 |
| 2014-11-18 04:51:00 | AAPL | Stock | 28.535 | 28.535 | 28.535 | 28.535 | 800.0 |
| 2014-11-18 04:52:00 | AAPL | Stock | 28.535 | 28.535 | 28.52 | 28.52 | 800.0 |
| 2014-11-18 04:54:00 | AAPL | Stock | 28.535 | 28.5375 | 28.535 | 28.5375 | 1600.0 |
| 2014-11-18 04:56:00 | AAPL | Stock | 28.5275 | 28.5275 | 28.5275 | 28.5275 | 400.0 |
| 2014-11-18 05:00:00 | AAPL | Stock | 28.5375 | 28.5425 | 28.5375 | 28.5425 | 1428.0 |
| 2014-11-18 05:01:00 | AAPL | Stock | 28.5425 | 28.5425 | 28.53 | 28.53 | 1600.0 |
| 2014-11-18 05:05:00 | AAPL | Stock | 28.5075 | 28.5075 | 28.5075 | 28.5075 | 400.0 |
| 2014-11-18 05:10:00 | AAPL | Stock | 28.54 | 28.54 | 28.54 | 28.54 | 400.0 |
| 2014-11-18 05:12:00 | AAPL | Stock | 28.54 | 28.54 | 28.54 | 28.54 | 400.0 |
| 2014-11-18 05:26:00 | AAPL | Stock | 28.505 | 28.505 | 28.505 | 28.505 | 400.0 |
| 2014-11-18 05:29:00 | AAPL | Stock | 28.475 | 28.475 | 28.475 | 28.475 | 1200.0 |
| 2014-11-18 05:34:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 400.0 |
| 2014-11-18 05:47:00 | AAPL | Stock | 28.4575 | 28.4575 | 28.455 | 28.455 | 2000.0 |
| 2014-11-18 05:52:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.4275 | 28.4275 | 400.0 |
| 2014-11-18 05:54:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.425 | 28.425 | 1700.0 |
| 2014-11-18 05:59:00 | AAPL | Stock | 28.4325 | 28.4325 | 28.4325 | 28.4325 | 2000.0 |
| 2014-11-18 06:03:00 | AAPL | Stock | 28.475 | 28.475 | 28.455 | 28.455 | 5200.0 |
| 2014-11-18 06:19:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.4625 | 28.4625 | 4000.0 |
| 2014-11-18 06:21:00 | AAPL | Stock | 28.425 | 28.425 | 28.41 | 28.41 | 8000.0 |
| 2014-11-18 06:27:00 | AAPL | Stock | 28.4025 | 28.4025 | 28.4025 | 28.4025 | 800.0 |
| 2014-11-18 06:30:00 | AAPL | Stock | 28.3975 | 28.3975 | 28.3975 | 28.3975 | 2400.0 |
| 2014-11-18 06:38:00 | AAPL | Stock | 28.39 | 28.39 | 28.39 | 28.39 | 1200.0 |
| 2014-11-18 06:39:00 | AAPL | Stock | 28.3925 | 28.3925 | 28.3925 | 28.3925 | 800.0 |
| 2014-11-18 06:41:00 | AAPL | Stock | 28.3925 | 28.3925 | 28.3925 | 28.3925 | 400.0 |
| 2014-11-18 06:44:00 | AAPL | Stock | 28.3925 | 28.3925 | 28.3925 | 28.3925 | 10800.0 |
| 2014-11-18 06:45:00 | AAPL | Stock | 28.4025 | 28.4125 | 28.4025 | 28.4125 | 1200.0 |
| 2014-11-18 06:52:00 | AAPL | Stock | 28.42 | 28.42 | 28.42 | 28.42 | 2800.0 |
| 2014-11-18 06:55:00 | AAPL | Stock | 28.435 | 28.435 | 28.435 | 28.435 | 600.0 |
| 2014-11-18 07:00:00 | AAPL | Stock | 28.435 | 28.44 | 28.435 | 28.44 | 18784.0 |
| 2014-11-18 07:07:00 | AAPL | Stock | 28.445 | 28.445 | 28.445 | 28.445 | 2000.0 |
| 2014-11-18 07:08:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 400.0 |
| 2014-11-18 07:09:00 | AAPL | Stock | 28.45 | 28.4575 | 28.45 | 28.4575 | 3600.0 |
| 2014-11-18 07:12:00 | AAPL | Stock | 28.4525 | 28.4525 | 28.4525 | 28.4525 | 800.0 |
| 2014-11-18 07:13:00 | AAPL | Stock | 28.46 | 28.46 | 28.46 | 28.46 | 1400.0 |
| 2014-11-18 07:21:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 1200.0 |
| 2014-11-18 07:25:00 | AAPL | Stock | 28.4575 | 28.4575 | 28.4575 | 28.4575 | 400.0 |
| 2014-11-18 07:26:00 | AAPL | Stock | 28.4525 | 28.4525 | 28.445 | 28.445 | 4136.0 |
| 2014-11-18 07:27:00 | AAPL | Stock | 28.445 | 28.445 | 28.4375 | 28.4375 | 4464.0 |
| 2014-11-18 07:28:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4275 | 28.4275 | 1336.0 |
| 2014-11-18 07:35:00 | AAPL | Stock | 28.445 | 28.4475 | 28.445 | 28.4475 | 1400.0 |
| 2014-11-18 07:37:00 | AAPL | Stock | 28.4375 | 28.4475 | 28.4375 | 28.4475 | 2200.0 |
| 2014-11-18 07:38:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 888.0 |
| 2014-11-18 07:40:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 800.0 |
| 2014-11-18 07:42:00 | AAPL | Stock | 28.4475 | 28.45 | 28.4475 | 28.45 | 6800.0 |
| 2014-11-18 07:44:00 | AAPL | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 3516.0 |
> showing 50 of 1,057,814 rows — these rows as CSV