PREVIEW / stock_1min / 2014-06-16
file: by_date/stock_1min/2014/2014-06-16.parquet size: 14.4 MB rows: 1,067,836 symbols: 2,880
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-16 04:00:00 | AAPL | Stock | 22.85 | 22.85 | 22.8 | 22.8 | 800.0 |
| 2014-06-16 04:01:00 | AAPL | Stock | 22.775 | 22.775 | 22.775 | 22.775 | 2000.0 |
| 2014-06-16 04:02:00 | AAPL | Stock | 22.77 | 22.77 | 22.77 | 22.77 | 400.0 |
| 2014-06-16 04:04:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 4000.0 |
| 2014-06-16 04:06:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 2000.0 |
| 2014-06-16 04:07:00 | AAPL | Stock | 22.75 | 22.75 | 22.7275 | 22.7275 | 2400.0 |
| 2014-06-16 04:08:00 | AAPL | Stock | 22.725 | 22.725 | 22.725 | 22.725 | 800.0 |
| 2014-06-16 04:30:00 | AAPL | Stock | 22.7375 | 22.7375 | 22.7375 | 22.7375 | 1188.0 |
| 2014-06-16 04:33:00 | AAPL | Stock | 22.7375 | 22.7375 | 22.7375 | 22.7375 | 800.0 |
| 2014-06-16 04:44:00 | AAPL | Stock | 22.755 | 22.755 | 22.755 | 22.755 | 2860.0 |
| 2014-06-16 04:52:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 800.0 |
| 2014-06-16 04:53:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 740.0 |
| 2014-06-16 04:58:00 | AAPL | Stock | 22.765 | 22.82 | 22.765 | 22.82 | 3360.0 |
| 2014-06-16 05:28:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 1464.0 |
| 2014-06-16 05:53:00 | AAPL | Stock | 22.825 | 22.825 | 22.825 | 22.825 | 400.0 |
| 2014-06-16 05:54:00 | AAPL | Stock | 22.825 | 22.825 | 22.825 | 22.825 | 7600.0 |
| 2014-06-16 06:03:00 | AAPL | Stock | 22.8025 | 22.8025 | 22.8025 | 22.8025 | 3080.0 |
| 2014-06-16 06:19:00 | AAPL | Stock | 22.825 | 22.825 | 22.825 | 22.825 | 1600.0 |
| 2014-06-16 06:29:00 | AAPL | Stock | 22.825 | 22.825 | 22.815 | 22.815 | 1600.0 |
| 2014-06-16 06:40:00 | AAPL | Stock | 22.8375 | 22.85 | 22.8375 | 22.85 | 2400.0 |
| 2014-06-16 06:41:00 | AAPL | Stock | 22.86 | 22.8625 | 22.86 | 22.86 | 13200.0 |
| 2014-06-16 06:42:00 | AAPL | Stock | 22.86 | 22.86 | 22.86 | 22.86 | 1200.0 |
| 2014-06-16 06:53:00 | AAPL | Stock | 22.84 | 22.84 | 22.84 | 22.84 | 2000.0 |
| 2014-06-16 07:00:00 | AAPL | Stock | 22.8625 | 22.8725 | 22.8625 | 22.8725 | 1900.0 |
| 2014-06-16 07:01:00 | AAPL | Stock | 22.8475 | 22.8475 | 22.8475 | 22.8475 | 400.0 |
| 2014-06-16 07:04:00 | AAPL | Stock | 22.855 | 22.855 | 22.855 | 22.855 | 400.0 |
| 2014-06-16 07:07:00 | AAPL | Stock | 22.855 | 22.855 | 22.85 | 22.85 | 8000.0 |
| 2014-06-16 07:22:00 | AAPL | Stock | 22.8575 | 22.8575 | 22.8575 | 22.8575 | 1200.0 |
| 2014-06-16 07:24:00 | AAPL | Stock | 22.855 | 22.8575 | 22.8525 | 22.8525 | 18792.0 |
| 2014-06-16 07:25:00 | AAPL | Stock | 22.8525 | 22.8525 | 22.8525 | 22.8525 | 400.0 |
| 2014-06-16 07:26:00 | AAPL | Stock | 22.8525 | 22.8525 | 22.8525 | 22.8525 | 16104.0 |
| 2014-06-16 07:29:00 | AAPL | Stock | 22.85 | 22.85 | 22.85 | 22.85 | 772.0 |
| 2014-06-16 07:35:00 | AAPL | Stock | 22.8625 | 22.865 | 22.8575 | 22.865 | 4100.0 |
| 2014-06-16 07:44:00 | AAPL | Stock | 22.8675 | 22.8675 | 22.8675 | 22.8675 | 4000.0 |
| 2014-06-16 07:45:00 | AAPL | Stock | 22.865 | 22.865 | 22.865 | 22.865 | 1600.0 |
| 2014-06-16 07:46:00 | AAPL | Stock | 22.865 | 22.865 | 22.865 | 22.865 | 2000.0 |
| 2014-06-16 07:49:00 | AAPL | Stock | 22.86 | 22.86 | 22.86 | 22.86 | 400.0 |
| 2014-06-16 07:57:00 | AAPL | Stock | 22.8675 | 22.87 | 22.8675 | 22.87 | 4400.0 |
| 2014-06-16 07:58:00 | AAPL | Stock | 22.8625 | 22.8625 | 22.8625 | 22.8625 | 800.0 |
| 2014-06-16 08:00:00 | AAPL | Stock | 22.8575 | 22.875 | 22.825 | 22.8375 | 45040.0 |
| 2014-06-16 08:01:00 | AAPL | Stock | 22.8275 | 22.8275 | 22.815 | 22.815 | 9600.0 |
| 2014-06-16 08:02:00 | AAPL | Stock | 22.815 | 22.825 | 22.815 | 22.82 | 4164.0 |
| 2014-06-16 08:03:00 | AAPL | Stock | 22.82 | 22.8225 | 22.805 | 22.8075 | 24696.0 |
| 2014-06-16 08:04:00 | AAPL | Stock | 22.805 | 22.8225 | 22.805 | 22.8225 | 2800.0 |
| 2014-06-16 08:05:00 | AAPL | Stock | 22.815 | 22.8275 | 22.8075 | 22.825 | 43576.0 |
| 2014-06-16 08:06:00 | AAPL | Stock | 22.8275 | 22.8525 | 22.8125 | 22.85 | 22200.0 |
| 2014-06-16 08:07:00 | AAPL | Stock | 22.85 | 22.85 | 22.8375 | 22.8375 | 23076.0 |
| 2014-06-16 08:08:00 | AAPL | Stock | 22.8375 | 22.8425 | 22.8375 | 22.84 | 19872.0 |
| 2014-06-16 08:09:00 | AAPL | Stock | 22.84 | 22.85 | 22.83 | 22.83 | 19940.0 |
| 2014-06-16 08:10:00 | AAPL | Stock | 22.8375 | 22.8375 | 22.8375 | 22.8375 | 852.0 |
> showing 50 of 1,067,836 rows — these rows as CSV