PREVIEW / stock_1min / 2015-11-18
file: by_date/stock_1min/2015/2015-11-18.parquet size: 15.1 MB rows: 1,093,899 symbols: 2,809
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-11-18 04:00:00 | AAPL | Stock | 28.445 | 28.7525 | 28.445 | 28.6275 | 3920.0 |
| 2015-11-18 04:01:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.625 | 28.625 | 800.0 |
| 2015-11-18 04:02:00 | AAPL | Stock | 28.66 | 28.66 | 28.63 | 28.63 | 800.0 |
| 2015-11-18 04:10:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.6525 | 28.6525 | 2000.0 |
| 2015-11-18 04:14:00 | AAPL | Stock | 28.66 | 28.66 | 28.66 | 28.66 | 400.0 |
| 2015-11-18 04:15:00 | AAPL | Stock | 28.66 | 28.66 | 28.66 | 28.66 | 1200.0 |
| 2015-11-18 04:17:00 | AAPL | Stock | 28.6975 | 28.6975 | 28.6975 | 28.6975 | 6000.0 |
| 2015-11-18 04:18:00 | AAPL | Stock | 28.6975 | 28.6975 | 28.6975 | 28.6975 | 5200.0 |
| 2015-11-18 04:21:00 | AAPL | Stock | 28.6875 | 28.695 | 28.6875 | 28.6875 | 26000.0 |
| 2015-11-18 04:22:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 12000.0 |
| 2015-11-18 04:23:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 8400.0 |
| 2015-11-18 04:24:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 4728.0 |
| 2015-11-18 04:28:00 | AAPL | Stock | 28.6925 | 28.6925 | 28.6925 | 28.6925 | 400.0 |
| 2015-11-18 04:34:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6725 | 28.6725 | 800.0 |
| 2015-11-18 04:35:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6725 | 28.6725 | 1600.0 |
| 2015-11-18 04:37:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.6525 | 28.6525 | 800.0 |
| 2015-11-18 04:41:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.6525 | 28.6525 | 996.0 |
| 2015-11-18 04:51:00 | AAPL | Stock | 28.625 | 28.6325 | 28.625 | 28.6325 | 4000.0 |
| 2015-11-18 05:01:00 | AAPL | Stock | 28.6375 | 28.6375 | 28.6375 | 28.6375 | 800.0 |
| 2015-11-18 05:03:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6725 | 28.6725 | 4000.0 |
| 2015-11-18 05:07:00 | AAPL | Stock | 28.625 | 28.625 | 28.625 | 28.625 | 1600.0 |
| 2015-11-18 05:24:00 | AAPL | Stock | 28.6275 | 28.6275 | 28.6275 | 28.6275 | 592.0 |
| 2015-11-18 05:25:00 | AAPL | Stock | 28.6125 | 28.6125 | 28.6125 | 28.6125 | 400.0 |
| 2015-11-18 05:30:00 | AAPL | Stock | 28.665 | 28.665 | 28.665 | 28.665 | 4400.0 |
| 2015-11-18 05:46:00 | AAPL | Stock | 28.6475 | 28.6475 | 28.6475 | 28.6475 | 1200.0 |
| 2015-11-18 05:47:00 | AAPL | Stock | 28.6275 | 28.6275 | 28.6275 | 28.6275 | 800.0 |
| 2015-11-18 05:50:00 | AAPL | Stock | 28.6275 | 28.6275 | 28.6275 | 28.6275 | 800.0 |
| 2015-11-18 05:54:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 400.0 |
| 2015-11-18 05:55:00 | AAPL | Stock | 28.6275 | 28.6275 | 28.625 | 28.625 | 800.0 |
| 2015-11-18 05:56:00 | AAPL | Stock | 28.66 | 28.6625 | 28.66 | 28.6625 | 4000.0 |
| 2015-11-18 05:58:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 1044.0 |
| 2015-11-18 06:03:00 | AAPL | Stock | 28.62 | 28.62 | 28.6175 | 28.6175 | 2800.0 |
| 2015-11-18 06:04:00 | AAPL | Stock | 28.6175 | 28.6175 | 28.6175 | 28.6175 | 4400.0 |
| 2015-11-18 06:05:00 | AAPL | Stock | 28.6575 | 28.66 | 28.6575 | 28.66 | 8640.0 |
| 2015-11-18 06:06:00 | AAPL | Stock | 28.6575 | 28.6625 | 28.6575 | 28.66 | 16000.0 |
| 2015-11-18 06:07:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 4000.0 |
| 2015-11-18 06:08:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 400.0 |
| 2015-11-18 06:09:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 4000.0 |
| 2015-11-18 06:10:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 6800.0 |
| 2015-11-18 06:13:00 | AAPL | Stock | 28.6625 | 28.665 | 28.6625 | 28.665 | 8712.0 |
| 2015-11-18 06:15:00 | AAPL | Stock | 28.665 | 28.675 | 28.665 | 28.675 | 11564.0 |
| 2015-11-18 06:16:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 6284.0 |
| 2015-11-18 06:17:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 400.0 |
| 2015-11-18 06:18:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 5200.0 |
| 2015-11-18 06:19:00 | AAPL | Stock | 28.675 | 28.675 | 28.6725 | 28.675 | 4000.0 |
| 2015-11-18 06:20:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 400.0 |
| 2015-11-18 06:24:00 | AAPL | Stock | 28.6725 | 28.685 | 28.6725 | 28.675 | 40080.0 |
| 2015-11-18 06:26:00 | AAPL | Stock | 28.685 | 28.685 | 28.685 | 28.685 | 5200.0 |
| 2015-11-18 06:29:00 | AAPL | Stock | 28.685 | 28.685 | 28.6675 | 28.6675 | 12032.0 |
| 2015-11-18 06:32:00 | AAPL | Stock | 28.685 | 28.685 | 28.685 | 28.685 | 5800.0 |
> showing 50 of 1,093,899 rows — these rows as CSV