PREVIEW / stock_1min / 2014-03-10
file: by_date/stock_1min/2014/2014-03-10.parquet size: 14.6 MB rows: 1,063,074 symbols: 2,861
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-03-10 04:13:00 | AAPL | Stock | 18.9089 | 18.9089 | 18.9089 | 18.9089 | 2800.0 |
| 2014-03-10 04:19:00 | AAPL | Stock | 18.9107 | 18.9107 | 18.9107 | 18.9107 | 2800.0 |
| 2014-03-10 05:33:00 | AAPL | Stock | 18.9421 | 18.9421 | 18.9421 | 18.9421 | 2800.0 |
| 2014-03-10 06:51:00 | AAPL | Stock | 18.9304 | 18.9304 | 18.9304 | 18.9304 | 2800.0 |
| 2014-03-10 07:32:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 2800.0 |
| 2014-03-10 07:53:00 | AAPL | Stock | 18.9307 | 18.9321 | 18.9307 | 18.9321 | 9380.0 |
| 2014-03-10 07:54:00 | AAPL | Stock | 18.9429 | 18.9429 | 18.9429 | 18.9429 | 2800.0 |
| 2014-03-10 07:59:00 | AAPL | Stock | 18.9321 | 18.9321 | 18.9321 | 18.9321 | 2800.0 |
| 2014-03-10 08:00:00 | AAPL | Stock | 18.9196 | 18.9286 | 18.9196 | 18.9286 | 14000.0 |
| 2014-03-10 08:02:00 | AAPL | Stock | 18.9254 | 18.9254 | 18.9239 | 18.9239 | 33040.0 |
| 2014-03-10 08:05:00 | AAPL | Stock | 18.9425 | 18.9425 | 18.9425 | 18.9425 | 2800.0 |
| 2014-03-10 08:06:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9286 | 18.9286 | 22820.0 |
| 2014-03-10 08:07:00 | AAPL | Stock | 18.9232 | 18.9232 | 18.9232 | 18.9232 | 2800.0 |
| 2014-03-10 08:13:00 | AAPL | Stock | 18.9243 | 18.9243 | 18.9146 | 18.9232 | 34160.0 |
| 2014-03-10 08:14:00 | AAPL | Stock | 18.9071 | 18.9171 | 18.9071 | 18.9171 | 15960.0 |
| 2014-03-10 08:16:00 | AAPL | Stock | 18.9089 | 18.9089 | 18.9089 | 18.9089 | 2800.0 |
| 2014-03-10 08:17:00 | AAPL | Stock | 18.9093 | 18.9093 | 18.9093 | 18.9093 | 2800.0 |
| 2014-03-10 08:26:00 | AAPL | Stock | 18.9064 | 18.9064 | 18.9032 | 18.9032 | 25928.0 |
| 2014-03-10 08:28:00 | AAPL | Stock | 18.8982 | 18.8982 | 18.895 | 18.895 | 27748.0 |
| 2014-03-10 08:39:00 | AAPL | Stock | 18.9007 | 18.9007 | 18.8982 | 18.8982 | 8820.0 |
| 2014-03-10 08:40:00 | AAPL | Stock | 18.8964 | 18.8964 | 18.8929 | 18.8929 | 45108.0 |
| 2014-03-10 08:45:00 | AAPL | Stock | 18.8911 | 18.8964 | 18.885 | 18.8929 | 34580.0 |
| 2014-03-10 08:46:00 | AAPL | Stock | 18.89 | 18.89 | 18.89 | 18.89 | 2800.0 |
| 2014-03-10 08:47:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 11228.0 |
| 2014-03-10 08:48:00 | AAPL | Stock | 18.9 | 18.9 | 18.9 | 18.9 | 5600.0 |
| 2014-03-10 08:49:00 | AAPL | Stock | 18.8964 | 18.8964 | 18.875 | 18.875 | 105112.0 |
| 2014-03-10 08:50:00 | AAPL | Stock | 18.8707 | 18.8875 | 18.8707 | 18.8707 | 81200.0 |
| 2014-03-10 08:51:00 | AAPL | Stock | 18.8782 | 18.8782 | 18.8732 | 18.8732 | 14000.0 |
| 2014-03-10 08:55:00 | AAPL | Stock | 18.8825 | 18.8825 | 18.8818 | 18.8825 | 8400.0 |
| 2014-03-10 08:56:00 | AAPL | Stock | 18.8786 | 18.8889 | 18.8786 | 18.8889 | 44520.0 |
| 2014-03-10 08:57:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8896 | 18.8896 | 11200.0 |
| 2014-03-10 08:58:00 | AAPL | Stock | 18.8789 | 18.8789 | 18.8732 | 18.8732 | 34720.0 |
| 2014-03-10 09:00:00 | AAPL | Stock | 18.8764 | 18.8764 | 18.8757 | 18.8757 | 11200.0 |
| 2014-03-10 09:02:00 | AAPL | Stock | 18.8821 | 18.8821 | 18.8786 | 18.8786 | 14000.0 |
| 2014-03-10 09:04:00 | AAPL | Stock | 18.8796 | 18.8796 | 18.8789 | 18.8789 | 14000.0 |
| 2014-03-10 09:06:00 | AAPL | Stock | 18.8921 | 18.8939 | 18.8921 | 18.8939 | 14000.0 |
| 2014-03-10 09:07:00 | AAPL | Stock | 18.88 | 18.88 | 18.88 | 18.88 | 14000.0 |
| 2014-03-10 09:08:00 | AAPL | Stock | 18.8893 | 18.8893 | 18.8839 | 18.8839 | 16240.0 |
| 2014-03-10 09:09:00 | AAPL | Stock | 18.8946 | 18.8946 | 18.8946 | 18.8946 | 2800.0 |
| 2014-03-10 09:10:00 | AAPL | Stock | 18.8861 | 18.8861 | 18.8839 | 18.8839 | 19600.0 |
| 2014-03-10 09:11:00 | AAPL | Stock | 18.8843 | 18.8843 | 18.8836 | 18.8836 | 16800.0 |
| 2014-03-10 09:12:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 5600.0 |
| 2014-03-10 09:13:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8821 | 18.8821 | 28000.0 |
| 2014-03-10 09:14:00 | AAPL | Stock | 18.8821 | 18.8821 | 18.8732 | 18.8732 | 127792.0 |
| 2014-03-10 09:15:00 | AAPL | Stock | 18.8789 | 18.8789 | 18.8789 | 18.8789 | 2800.0 |
| 2014-03-10 09:20:00 | AAPL | Stock | 18.8682 | 18.8682 | 18.8682 | 18.8682 | 2800.0 |
| 2014-03-10 09:21:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2014-03-10 09:27:00 | AAPL | Stock | 18.8771 | 18.8771 | 18.8771 | 18.8771 | 8372.0 |
| 2014-03-10 09:28:00 | AAPL | Stock | 18.8768 | 18.8771 | 18.86 | 18.8771 | 76748.0 |
| 2014-03-10 09:29:00 | AAPL | Stock | 18.8746 | 18.8789 | 18.8714 | 18.8789 | 36008.0 |
> showing 50 of 1,063,074 rows — these rows as CSV