PREVIEW / stock_1min / 2015-07-22
file: by_date/stock_1min/2015/2015-07-22.parquet size: 14.3 MB rows: 1,051,223 symbols: 2,848
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-07-22 04:00:00 | AAPL | Stock | 30.425 | 31.0775 | 30.425 | 30.815 | 76060.0 |
| 2015-07-22 04:01:00 | AAPL | Stock | 30.8725 | 30.875 | 30.625 | 30.7475 | 150696.0 |
| 2015-07-22 04:02:00 | AAPL | Stock | 30.7 | 30.7825 | 30.7 | 30.7825 | 44208.0 |
| 2015-07-22 04:03:00 | AAPL | Stock | 30.8625 | 30.8625 | 30.815 | 30.8375 | 15600.0 |
| 2015-07-22 04:04:00 | AAPL | Stock | 30.8375 | 30.8375 | 30.815 | 30.815 | 3680.0 |
| 2015-07-22 04:06:00 | AAPL | Stock | 30.825 | 30.825 | 30.7525 | 30.7625 | 9544.0 |
| 2015-07-22 04:07:00 | AAPL | Stock | 30.8175 | 30.8175 | 30.755 | 30.755 | 3232.0 |
| 2015-07-22 04:08:00 | AAPL | Stock | 30.755 | 30.7925 | 30.75 | 30.755 | 34800.0 |
| 2015-07-22 04:09:00 | AAPL | Stock | 30.755 | 30.795 | 30.755 | 30.755 | 7336.0 |
| 2015-07-22 04:10:00 | AAPL | Stock | 30.755 | 30.7825 | 30.755 | 30.7825 | 31704.0 |
| 2015-07-22 04:11:00 | AAPL | Stock | 30.755 | 30.7925 | 30.755 | 30.78 | 36532.0 |
| 2015-07-22 04:12:00 | AAPL | Stock | 30.78 | 30.78 | 30.78 | 30.78 | 10600.0 |
| 2015-07-22 04:13:00 | AAPL | Stock | 30.795 | 30.795 | 30.795 | 30.795 | 2000.0 |
| 2015-07-22 04:14:00 | AAPL | Stock | 30.8 | 30.8125 | 30.795 | 30.8125 | 5684.0 |
| 2015-07-22 04:15:00 | AAPL | Stock | 30.8175 | 30.8325 | 30.8175 | 30.8325 | 1600.0 |
| 2015-07-22 04:16:00 | AAPL | Stock | 30.86 | 30.9225 | 30.86 | 30.9075 | 10268.0 |
| 2015-07-22 04:17:00 | AAPL | Stock | 30.9125 | 30.9225 | 30.9125 | 30.9225 | 3200.0 |
| 2015-07-22 04:18:00 | AAPL | Stock | 30.95 | 30.9875 | 30.95 | 30.9825 | 12200.0 |
| 2015-07-22 04:19:00 | AAPL | Stock | 30.985 | 31.025 | 30.975 | 30.9875 | 29764.0 |
| 2015-07-22 04:20:00 | AAPL | Stock | 30.9675 | 31.025 | 30.965 | 31.0 | 9640.0 |
| 2015-07-22 04:21:00 | AAPL | Stock | 30.9975 | 30.9975 | 30.975 | 30.975 | 1400.0 |
| 2015-07-22 04:22:00 | AAPL | Stock | 30.975 | 31.0 | 30.975 | 31.0 | 4848.0 |
| 2015-07-22 04:23:00 | AAPL | Stock | 30.9675 | 30.9975 | 30.9625 | 30.9925 | 6100.0 |
| 2015-07-22 04:26:00 | AAPL | Stock | 30.95 | 30.965 | 30.95 | 30.9525 | 2508.0 |
| 2015-07-22 04:27:00 | AAPL | Stock | 30.99 | 31.0 | 30.99 | 31.0 | 3600.0 |
| 2015-07-22 04:28:00 | AAPL | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 2400.0 |
| 2015-07-22 04:29:00 | AAPL | Stock | 30.9925 | 30.9925 | 30.9925 | 30.9925 | 600.0 |
| 2015-07-22 04:30:00 | AAPL | Stock | 31.0025 | 31.0725 | 31.0025 | 31.0725 | 16060.0 |
| 2015-07-22 04:31:00 | AAPL | Stock | 31.1025 | 31.23 | 31.1025 | 31.23 | 109628.0 |
| 2015-07-22 04:32:00 | AAPL | Stock | 31.2 | 31.2 | 31.1075 | 31.1475 | 18800.0 |
| 2015-07-22 04:33:00 | AAPL | Stock | 31.1725 | 31.1725 | 31.1025 | 31.1025 | 8124.0 |
| 2015-07-22 04:34:00 | AAPL | Stock | 31.1025 | 31.1025 | 31.06 | 31.06 | 15600.0 |
| 2015-07-22 04:35:00 | AAPL | Stock | 31.0625 | 31.0625 | 31.06 | 31.0625 | 21900.0 |
| 2015-07-22 04:37:00 | AAPL | Stock | 31.13 | 31.15 | 31.13 | 31.15 | 2832.0 |
| 2015-07-22 04:38:00 | AAPL | Stock | 31.15 | 31.15 | 31.13 | 31.13 | 12792.0 |
| 2015-07-22 04:39:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 5560.0 |
| 2015-07-22 04:41:00 | AAPL | Stock | 31.125 | 31.1275 | 31.11 | 31.11 | 4776.0 |
| 2015-07-22 04:42:00 | AAPL | Stock | 31.11 | 31.11 | 31.0875 | 31.0875 | 6400.0 |
| 2015-07-22 04:43:00 | AAPL | Stock | 31.0025 | 31.0025 | 31.0 | 31.0 | 10628.0 |
| 2015-07-22 04:44:00 | AAPL | Stock | 31.0 | 31.075 | 31.0 | 31.07 | 8964.0 |
| 2015-07-22 04:46:00 | AAPL | Stock | 31.02 | 31.02 | 31.02 | 31.02 | 2000.0 |
| 2015-07-22 04:47:00 | AAPL | Stock | 31.0025 | 31.01 | 31.0025 | 31.01 | 6400.0 |
| 2015-07-22 04:48:00 | AAPL | Stock | 31.02 | 31.02 | 31.02 | 31.02 | 3200.0 |
| 2015-07-22 04:49:00 | AAPL | Stock | 31.02 | 31.02 | 31.02 | 31.02 | 1960.0 |
| 2015-07-22 04:50:00 | AAPL | Stock | 31.0025 | 31.0075 | 31.0 | 31.0 | 8800.0 |
| 2015-07-22 04:51:00 | AAPL | Stock | 31.035 | 31.0375 | 31.035 | 31.0375 | 4000.0 |
| 2015-07-22 04:52:00 | AAPL | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 14000.0 |
| 2015-07-22 04:53:00 | AAPL | Stock | 31.0 | 31.0 | 30.95 | 30.95 | 39600.0 |
| 2015-07-22 04:54:00 | AAPL | Stock | 30.9775 | 30.9775 | 30.975 | 30.975 | 4000.0 |
| 2015-07-22 04:55:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.925 | 30.925 | 2600.0 |
> showing 50 of 1,051,223 rows — these rows as CSV