PREVIEW / stock_1min / 2014-06-19
file: by_date/stock_1min/2014/2014-06-19.parquet size: 14.1 MB rows: 1,042,699 symbols: 2,898
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-06-19 04:02:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 1600.0 |
| 2014-06-19 04:05:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 400.0 |
| 2014-06-19 04:09:00 | AAPL | Stock | 23.1025 | 23.1025 | 23.1025 | 23.1025 | 800.0 |
| 2014-06-19 04:11:00 | AAPL | Stock | 23.1375 | 23.14 | 23.1375 | 23.14 | 4800.0 |
| 2014-06-19 04:12:00 | AAPL | Stock | 23.125 | 23.15 | 23.125 | 23.1375 | 14000.0 |
| 2014-06-19 04:13:00 | AAPL | Stock | 23.14 | 23.1675 | 23.14 | 23.15 | 1200.0 |
| 2014-06-19 04:19:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 400.0 |
| 2014-06-19 04:20:00 | AAPL | Stock | 23.14 | 23.14 | 23.14 | 23.14 | 400.0 |
| 2014-06-19 04:43:00 | AAPL | Stock | 23.135 | 23.135 | 23.135 | 23.135 | 800.0 |
| 2014-06-19 04:45:00 | AAPL | Stock | 23.1025 | 23.1025 | 23.1025 | 23.1025 | 400.0 |
| 2014-06-19 04:47:00 | AAPL | Stock | 23.135 | 23.135 | 23.135 | 23.135 | 800.0 |
| 2014-06-19 04:48:00 | AAPL | Stock | 23.14 | 23.14 | 23.14 | 23.14 | 400.0 |
| 2014-06-19 05:07:00 | AAPL | Stock | 23.1325 | 23.1325 | 23.1325 | 23.1325 | 2400.0 |
| 2014-06-19 05:10:00 | AAPL | Stock | 23.14 | 23.1425 | 23.14 | 23.1425 | 2080.0 |
| 2014-06-19 05:11:00 | AAPL | Stock | 23.1325 | 23.1325 | 23.1325 | 23.1325 | 3600.0 |
| 2014-06-19 05:13:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 2000.0 |
| 2014-06-19 05:18:00 | AAPL | Stock | 23.1325 | 23.1325 | 23.1325 | 23.1325 | 2000.0 |
| 2014-06-19 06:00:00 | AAPL | Stock | 23.1325 | 23.1325 | 23.1325 | 23.1325 | 400.0 |
| 2014-06-19 06:16:00 | AAPL | Stock | 23.1125 | 23.1125 | 23.1125 | 23.1125 | 2400.0 |
| 2014-06-19 06:27:00 | AAPL | Stock | 23.13 | 23.13 | 23.13 | 23.13 | 1200.0 |
| 2014-06-19 06:31:00 | AAPL | Stock | 23.135 | 23.1375 | 23.1325 | 23.1375 | 8320.0 |
| 2014-06-19 06:33:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 15924.0 |
| 2014-06-19 06:34:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 400.0 |
| 2014-06-19 06:39:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 400.0 |
| 2014-06-19 06:40:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 14400.0 |
| 2014-06-19 06:42:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 1576.0 |
| 2014-06-19 06:45:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 400.0 |
| 2014-06-19 06:46:00 | AAPL | Stock | 23.1375 | 23.14 | 23.1375 | 23.14 | 4000.0 |
| 2014-06-19 06:47:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 400.0 |
| 2014-06-19 06:48:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 1200.0 |
| 2014-06-19 06:49:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 1600.0 |
| 2014-06-19 06:52:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 2824.0 |
| 2014-06-19 06:55:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 8000.0 |
| 2014-06-19 07:01:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1325 | 23.1325 | 3888.0 |
| 2014-06-19 07:02:00 | AAPL | Stock | 23.1325 | 23.1325 | 23.125 | 23.125 | 5316.0 |
| 2014-06-19 07:03:00 | AAPL | Stock | 23.12 | 23.12 | 23.12 | 23.12 | 2204.0 |
| 2014-06-19 07:04:00 | AAPL | Stock | 23.1075 | 23.1075 | 23.1075 | 23.1075 | 3008.0 |
| 2014-06-19 07:05:00 | AAPL | Stock | 23.125 | 23.1325 | 23.1125 | 23.125 | 3600.0 |
| 2014-06-19 07:06:00 | AAPL | Stock | 23.1125 | 23.1125 | 23.1125 | 23.1125 | 1800.0 |
| 2014-06-19 07:07:00 | AAPL | Stock | 23.125 | 23.1375 | 23.125 | 23.1375 | 5200.0 |
| 2014-06-19 07:08:00 | AAPL | Stock | 23.1375 | 23.145 | 23.1375 | 23.145 | 7124.0 |
| 2014-06-19 07:09:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 1200.0 |
| 2014-06-19 07:15:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 2360.0 |
| 2014-06-19 07:16:00 | AAPL | Stock | 23.14 | 23.14 | 23.1375 | 23.1375 | 6336.0 |
| 2014-06-19 07:24:00 | AAPL | Stock | 23.135 | 23.1375 | 23.135 | 23.1375 | 7856.0 |
| 2014-06-19 07:25:00 | AAPL | Stock | 23.1375 | 23.1375 | 23.1375 | 23.1375 | 1924.0 |
| 2014-06-19 07:27:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 2400.0 |
| 2014-06-19 07:28:00 | AAPL | Stock | 23.125 | 23.125 | 23.125 | 23.125 | 980.0 |
| 2014-06-19 07:31:00 | AAPL | Stock | 23.1125 | 23.12 | 23.1125 | 23.12 | 1500.0 |
| 2014-06-19 07:33:00 | AAPL | Stock | 23.1225 | 23.1225 | 23.1225 | 23.1225 | 800.0 |
> showing 50 of 1,042,699 rows — these rows as CSV